Completed
) Example 01 & 02: Simple Interest Compared to Compound Interest In Excel & Two Sides to Every Debt Transaction
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel and Business Math - Compound Interest Calculating Future Value of a Lump Sum FV Excel Function
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Compare Simple Interest and Compounded Interest Long Hand on Paper
- 3 ) Example 01 & 02: Simple Interest Compared to Compound Interest In Excel & Two Sides to Every Debt Transaction
- 4 ) New Terms for Compound Interest – we will use these for the rest of the Finance Videos.
- 5 ) Direction of the Cash Flow Matters: For Compound Interest Calculations in Excel, the Direction of the Cash Flow Matters
- 6 ) Example 03: Math Formulas and FV Excel Function in Excel to make Future Value Calculations, both long hand and in a single cell.
- 7 ) Video Example #04 for Future Value Calculation for Investment (Savings Account with quarterly Interest Payments)
- 8 ) Video Example #05 for Future Value Calculation for Debt
- 9 ) Video Example #06: Comparing Simple Interest and Compound Interest in a Graph
- 10 ) Video Example #07 for Future Value Calculation for Savings Account (Savings Account with Daily Interest Payments)
- 11 ) 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 ) Daily Savings Account Example
- 13 ) Daily Savings Account Examples for less than one year. We calculate Total Number Of Periods using Date Math.
- 14 ) Summary
