Главная
Study mode:
on
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
Description:
Learn to calculate the Future Value of a Lump Sum Investment or Debt Instrument using Excel's FV Function and the Future Value Math Formula in this comprehensive 56-minute video tutorial. Compare simple and compound interest, explore new terms for compound interest, and understand how cash flow direction affects calculations. Work through multiple examples, including investments with quarterly and daily interest payments, long-term savings accounts, and debt scenarios. Create graphs to visualize the difference between simple and compound interest, and master date math for calculating periods less than a year. Download accompanying Excel files and PDF notes to enhance your learning experience.

Excel and Business Math - Compound Interest Calculating Future Value of a Lump Sum FV Excel Function

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Finance #Financial Analysis #Cash Flow Analysis #Simple Interest #Personal Finance #Compound Interest
1 of 14

) Introduction