Download Start Excel File: https:\/\/ift.tt\/2GJNDCr
\nDownload pdf Notes: https:\/\/ift.tt\/2HjmbMI
\nEntire Class Web Site: https:\/\/ift.tt\/2BjafuY<\/p>\n
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.
\nExcel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College \/ Mike Girvin at excelisfun Channel at YouTube Channel.
\nTopics in Video:
\n1. (00:01) Introduction
\n2. (01:05) Compare Simple Interest and Compounded Interest Long Hand on Paper
\n3. (05:00) Example 01 & 02: Simple Interest Compared to Compound Interest In Excel & Two Sides to Every Debt Transaction
\n4. (13:51) New Terms for Compound Interest \u2013 we will use these for the rest of the Finance Videos.
\n5. (20:35) Direction of the Cash Flow Matters: For Compound Interest Calculations in Excel, the Direction of the Cash Flow Matters
\n6. (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.
\n7. (32:32) Video Example #04 for Future Value Calculation for Investment (Savings Account with quarterly Interest Payments)
\n8. (36:03) Video Example #05 for Future Value Calculation for Debt
\n9. (38:27) Video Example #06: Comparing Simple Interest and Compound Interest in a Graph
\n10. (44:04) Video Example #07 for Future Value Calculation for Savings Account (Savings Account with Daily Interest Payments)
\n11. (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!)
\n12. (49:17) Daily Savings Account Example
\n13. (51:10) Daily Savings Account Examples for less than one year. We calculate Total Number Of Periods using Date Math.
\n14. (53:25) Summary<\/p>\n
Next Video: 44 Excel & Business Math<\/p>\n