440 free courses & lectures available for Accounts and Finance

Excel Finance Trick #1: FV PV & Time Value Of Money

by ExcelIsFun on Youtube Youtube
Duration: 0.08 hours
FV = Future Value. PV = Present Value. Learn about the Time Value of Money. See how the concept of "Time Value of Money" is a fundamental idea in Finance.
  
Details:
No Captions

About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...

Excel Finance Trick #3: PMT function Lender or Borrower

by ExcelIsFun on Youtube Youtube
Duration: 0.15 hours
See how to use the PMT function for the Lender or Borrower. Cash Flows matters in Finance and so using the PMT function is very different for the Lender and ...
  
Details:
No Captions

About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...

Excel Finance Trick #4: PMT function & Balloon payment

by ExcelIsFun on Youtube Youtube
Duration: 0.06 hours
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 ...
  
Details:
No Captions

About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...

Excel Finance Trick #2: Simple & Compound Interest

by ExcelIsFun on Youtube Youtube
Duration: 0.18 hours
See how to use the FV function. See the math formula for calculating Future Value and for calculating the effective interest rate. Also see long hand how ...
  
Details:
No Captions

About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...

Excel Finance Trick #5: PMT & FV function & Delayed Payments

by ExcelIsFun on Youtube Youtube
Duration: 0.11 hours
See how to use the PMT & FV function together to calculate a delayed PMT payment amount. See how to use the PMT function to calculate a payment amount ...
  
Details:
No Captions

About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...

Excel Finance Trick #6: RATE function and Loan Points

by ExcelIsFun on Youtube Youtube
Duration: 0.07 hours
See how to use the RATE function to calculate an adjusted rate when there are Loan Points. Period rate = RATE function. In This Series learn 17 amazing ...
  
Details:
No Captions

About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...

Excel Finance Trick #7: EFFECT function (EAR Rate)

by ExcelIsFun on Youtube Youtube
Duration: 0.04 hours
See how to use the EFFECT function to calculate the Effective Annual Rate given an APR or Nominal Rate. Also see the math formula to calculate the Effective ...
  
Details:
No Captions

About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...

Excel Finance Trick #8: Complete Loan Analysis

by ExcelIsFun on Youtube Youtube
Duration: 0.18 hours
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 ...
  
Details:
No Captions

About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...

Excel Finance Trick 9: Daily Interest But Monthly Deposits?!

by ExcelIsFun on Youtube Youtube
Duration: 0.07 hours
When your savings plans pays interest 365 days in a year and you make monthly deposits, use the NOMINAL and EFFECT functions first before using the FV ...
  
Details:
No Captions

About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...

Excel Finance Trick #10: Interest Rate for Pay Day Loans

by ExcelIsFun on Youtube Youtube
Duration: 0.1 hours
See how to calculate the Interest Rates for Pay Day Loans. See how to calculate the Period Rate, the Number of Compounding Periods in a year, and the APR ...
  
Details:
No Captions

About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
1 12 44