The Most Addictive Python and SQL Courses
Learn Excel and Financial Modeling the Way Finance Teams Actually Use Them
Overview
Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
Learn about the time value of money to figure out loan payments, save for college and retirement, buy a house, lease or purchase a car, and make long-term business decisions.
Syllabus
Introduction
- Making financial decisions
- The time value of candy
- Overview of the time value of money terms
- Common time value of money misunderstandings
- Columbus and the power of compounding
- The impact of interest rates
- The impact of compounding periods
- The time value of money when buying a car
- Using business calculators
- Computing a car payment with a business calculator
- Computing a house payment with a business calculator
- Computing a house payment with a balloon payment at the end
- Computing the amount you can afford to borrow
- Mortgage amortization schedules
- Finding Excel financial functions
- Computing a car payment using Excel
- Computing a house payment using Excel
- Using Excel to construct a loan amortization schedule
- Computing an effective interest rate using Excel
- Start saving early
- Growth in savings and the rule of 72
- Saving for a target amount for a house
- The importance of starting to save for retirement now
- Time value of money dangers: A payday loan
- Where to go from here
Taught by
Jim Stice and Kay Stice