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
Matemáticas financierasUniversidad Nacional Autónoma de México via Coursera 『いざ! 資産形成』 ~ 余裕を持って、余裕を増やす。 ~ (ga107)
Tokyo Stock Exchange via gacco Principles of Wealth Management
Hanken School of Economics via FutureLearn The Complete Personal Finance Course: Save,Protect,Make More
Udemy How to Make Better Capital Investment Decisions and Recognise Investment Opportunities
Coventry University via FutureLearn