ExcelIsFun

Rank: 754 / 5440

9 selected videos

Excel Finance Trick #8: Complete Loan Analysis

See how to use the PMT and RATE functions for a complete Debt/Loan Analysis.

Debt Analysis with input variables: % Down Payment, APR, Years, Points, Extra Fee. See how to calculate Amount to Borrow, Monthly Payment, Actual Cash Received, Adjusted APR, and PMT w Balloon Payment.

In This Series learn 17 amazing Finance Tricks. Learn about the PMT, PV, FV, NPER, RATE, SLN, DB, EFFECT, NOMINAL, NPV, XNPV, and the CUMIPMT functions that can make your financing tasks much easier in Excel. See...

View more

Related topics : interest rates loan / loan calculator rate / calculating loan payments in excel

Excel Finance Trick 11: How Long Pay Off Credit Card Balance

See how to calculate HOW LONG IT TAKES TO PAY OFF A CREDIT CARD BALANCE using the NPER function.

When you make only the minimum payment on a credit card, it takes a long time to pay off the balance. How long? Use the NPER function to find out how long it will take to pay off the credit card balance.

Solve for how many total periods there are.

In This Series learn 17 amazing Finance Tricks. Learn about the PMT, PV, FV, NPER, RATE, SLN, DB, EFFECT, NOMINAL, NPV, XNPV, and the CUMIPMT...

View more

Related topics : loan credit card pay off / loan credit card calculator / interest rates loan

Excel Finance Trick #4: PMT function & Balloon payment

See how to use the PMT function & a Balloon payment. When you have to make Period payments on a loan contract and a lump sum payment at the end of the contract, you can use this trick to calculate your PMT amount!

In This Series learn 17 amazing Finance Tricks. Learn about the PMT, PV, FV, NPER, RATE, SLN, DB, EFFECT, NOMINAL, NPV, XNPV, and the CUMIPMT functions that can make your financing tasks much easier in Excel. See how to use the PMT function in the standard way, but also see how to...

View more

Related topics : loan payment calculator excel / interest rates loan

Excel Magic Trick #113: Nested IF & Short Term Loans

Nested IF example. See how to use the TEXT function, concatenation using the Ampersand (&) symbol and the IF function to create labels and loan calculating formulas for various short-term loans.

View more

Related topics : short term loan calculator

Excel Magic Trick 623: PayDay LoansAre Bad Finance -- APR & EAR & Amortization Table

Learn how to see the painful near-extortion that Pay Day Loans inflict on people using Excel. Learn how to calculate APR (Annual Percentage Rate), EAR (Effective Annual Rate), an Amortization Table and the EAR for a loan that takes a fee out up front. Learn Excel financial formulas and see the EFFECT and RATE functions.

In this video the Excel is beautiful but the financial havoc that Pay Day Loans inflict can be painful!

View more

Related topics : pay day loan / amortization loan calculator excel

Excel Magic Trick 738: Goal Seek, PMT function for Loan Payment, Cash Flows and Balloon Payment

Download file: http://people.highline.edu/mgirvin/

Learn how to use Goal Seek to change a formula input to cause a formula to evaluate to set amount. Goal Seek is like a "reverse" formula because we tell the formula what we want it to evaluate to and Goal Seek changes the formula input. Learn how to use the PMT function to calculate a loan payment with a 15% down requirement and a balloon payment at the end.

View more

Related topics : loan payment calculator excel

Excel Finance Class 35: Calculate PMT for Present Value of Annuity PMT Function for Loan Payment

Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htm

Learn how to use the PMT function to calculate a loan payment.

View more

Related topics : loan payment calculator excel

Excel Magic Trick 355: VLOOKUP for Mortgage Calculator

See how to use VLOOKUP to create a Mortgage Calculator that can handle 4 different types of loans: Begin Annuity, End Annuity, Interest Only and Other loan.

View more

Related topics : mortgage calculator loan

Excel Magic Trick 944.5: Formula For Total Interest Over Life Of Business Amortization Loan

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm

Topics:

1) Create Defined Names to use in formula using the Create Name From Selection feature and the keyboard shortcut: Ctrl + Shift + F3

2) Total Interest over the life of a Business Amortization Loan formula: LoanPV * PeriodicRate * (TotalPeriod + 1) / 2

View more

Related topics : amortization loan formula