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...
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...
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...
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.
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!
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.
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.
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.
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
Related topics : amortization loan formula
9 Resources