Excel and Business Math - Compound Interest Calculating Future Value of a Lump Sum FV Excel Function
ExcelIsFun via YouTube
Overview
Syllabus
) Introduction.
) Compare Simple Interest and Compounded Interest Long Hand on Paper.
) Example 01 & 02: Simple Interest Compared to Compound Interest In Excel & Two Sides to Every Debt Transaction.
) New Terms for Compound Interest – we will use these for the rest of the Finance Videos..
) Direction of the Cash Flow Matters: For Compound Interest Calculations in Excel, the Direction of the Cash Flow Matters.
) Example 03: Math Formulas and FV Excel Function in Excel to make Future Value Calculations, both long hand and in a single cell..
) Video Example #04 for Future Value Calculation for Investment (Savings Account with quarterly Interest Payments).
) Video Example #05 for Future Value Calculation for Debt.
) Video Example #06: Comparing Simple Interest and Compound Interest in a Graph.
) Video Example #07 for Future Value Calculation for Savings Account (Savings Account with Daily Interest Payments).
) 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!).
) Daily Savings Account Example.
) Daily Savings Account Examples for less than one year. We calculate Total Number Of Periods using Date Math..
) Summary.
Taught by
ExcelIsFun