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

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
This course teaches learners how to calculate the Future Value of a Lump Sum Investment or Debt Instrument using the Excel FV Function and the Future Value Math Formula. The course covers topics such as comparing Simple Interest and Compound Interest, understanding the direction of cash flow in Excel calculations, and various examples of Future Value calculations for different scenarios. The intended audience for this course is individuals interested in Excel and Business Math, particularly those looking to enhance their financial analysis skills. The teaching method includes practical examples demonstrated using Excel functions and formulas.

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.