Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

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

ExcelIsFun via YouTube

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This course teaches how to compare simple and compound interest and calculate the future value of lump-sum investments and debt using mathematical formulas and Excel’s FV function. It covers annual, quarterly, and daily compounding, cash-flow direction, and date-based period calculations.

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

Reviews

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.