Excel and Business Math - Compound Interest Calculating Future Value of a Lump Sum FV Excel Function
Offered By: ExcelIsFun via YouTube
Course Description
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
Related Courses
Evaluación de Decisiones EstratégicasDiplomadas Ingenieria Industrial UC via NovoEd Основы корпоративных финансов (Fundamentals of Corporate Finance)
Higher School of Economics via Coursera Analyse Financière
First Finance Institute via First Business MOOC 财务会计概论(中文版)
University of Pennsylvania via Coursera Principles of Valuation: Time Value of Money
University of Michigan via Coursera