Your cart is empty.
Keep shoppingTime Value of Money and Finance Functions in Excel
1 students
Time Value of Money and Finance Functions in Excel
Use Excel’s financial functions to analyze loans, investments, and long-term value.
Created byCreateMyExcel with Ben Scholl
Last updated 7/2025
English
What you'll learn
- Learn to calculate loan payments using Excel financial functions.
- Build loan amortization schedules with fixed and dynamic options.
- Analyze interest costs, loan terms, and principal over time.
- Understand the time value of money in real-world loan scenarios.
- Calculate future value for investments using compound interest.
- Compare nominal and effective interest rates in investment planning.
- Determine required deposits or rates to meet investment goals.
- Calculate present value and apply discounting for future cash flows.
- Use Excel to evaluate leasing, investing, and buying decisions.
- Analyze investment return using NPV, IRR, and payback methods.
Explore related topics
Course content
3 sections • 45 lectures • 2h 16m total length
Requirements
- Microsoft Excel (Office 2021 or Microsoft 365) installed.
- Basic knowledge of Excel (e.g., entering data, simple calculations).
- Access to a computer with a stable internet connection.
- No prior advanced Excel skills required; suitable for beginners.
Description
This course provides a practical, hands-on approach to building financial models in Microsoft Excel, focusing on loans, investments, and discounting techniques. Designed for students, professionals, and business users, the course covers essential financial concepts and shows how to apply them using Excel’s built-in formulas and functions.
In the loan-focused section, students will explore the time value of money and learn to calculate loan payments, interest, and principal using functions like PMT, IPMT, and PPMT. They’ll build amortization schedules—both fixed-rate and dynamic—and analyze balloon loans, principal paydowns, and variable-rate mortgages. Additional lessons guide learners through determining loan terms, calculating borrowing capacity, and solving for interest rates.
The investment section shifts toward building future value models. Students will calculate the value of lump sums, recurring deposits, and mixed investments, using compound interest and both nominal and effective rates. They’ll also develop investment schedules and solve for required contributions to meet financial goals.
Finally, the course introduces discounting techniques to evaluate the present value of future cash flows. Learners will work with NPV, IRR, and payback period functions to assess investment performance. Real-world scenarios such as leasing vs. buying and property investment decisions are included.
By the end of this course, students will be able to build accurate financial models in Excel to support smarter personal, academic, and business decisions
Who this course is for:
- Learn to calculate loan payments, terms, interest, and principal using Excel.
- Build both fixed and dynamic loan amortization schedules.
- Understand balloon loans and model principal paydowns over time.
- Use Excel to determine how much you can borrow or repay.
- Compare nominal vs. effective interest rates and convert between them.
- Calculate the future value of lump sums and regular deposits.
- Plan toward investment goals by solving for rate, time, or deposit.
- Build investment schedules and evaluate outcomes over time.
- Calculate present value, NPV, and IRR for various cash flow scenarios.
- Analyze financial decisions like buying vs. leasing or investing income.