Download Start Excel File: https://ift.tt/2GJNDCr
Download pdf Notes: https://ift.tt/2HjmbMI
Entire Class Web Site: https://ift.tt/2BjafuY
In this video learn how to calculate the Future Value of an Lump Sum Investment or Debt Instrument using the Excel FV Function and the Future Value Math Formula.
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. (01:05) Compare Simple Interest and Compounded Interest Long Hand on Paper
3. (05:00) Example 01 & 02: Simple Interest Compared to Compound Interest In Excel & Two Sides to Every Debt Transaction
4. (13:51) New Terms for Compound Interest – we will use these for the rest of the Finance Videos.
5. (20:35) Direction of the Cash Flow Matters: For Compound Interest Calculations in Excel, the Direction of the Cash Flow Matters
6. (23:28) Example 03: Math Formulas and FV Excel Function in Excel to make Future Value Calculations, both long hand and in a single cell.
7. (32:32) Video Example #04 for Future Value Calculation for Investment (Savings Account with quarterly Interest Payments)
8. (36:03) Video Example #05 for Future Value Calculation for Debt
9. (38:27) Video Example #06: Comparing Simple Interest and Compound Interest in a Graph
10. (44:04) Video Example #07 for Future Value Calculation for Savings Account (Savings Account with Daily Interest Payments)
11. (47:00) Video Example #08 for Future Value Calculation for Savings Account (Savings Account with quarterly Interest Payments AND we leave amount in Bank for 35 years!)
12. (49:17) Daily Savings Account Example
13. (51:10) Daily Savings Account Examples for less than one year. We calculate Total Number Of Periods using Date Math.
14. (53:25) Summary
Next Video: 44 Excel & Business Math