Time Value of Money and Finance Functions in Excel
Master Excel for financial analysis! Learn to evaluate loans, investments & long-term value with powerful financial functions.
Course Content
Time Value of Money and Finance Functions in Excel is an intermediate-level Udemy course taught by CreateMyExcel with Ben Scholl. It runs 2h 16m, is taught in English, and includes a certificate of completion. It is a paid course, first published August 2025.
Master financial modeling in Excel with this practical, hands-on course! Learn to build powerful models for loans, investments, and discounting – essential skills for students, professionals, and business users.
This course demystifies complex financial concepts, showing you how to apply them using Excel’s built-in formulas and functions. You'll gain proficiency in creating robust financial models to support informed decision-making.
Loan Modeling Expertise:
- Time Value of Money: Understand and apply the principles of time value of money.
- Loan Payment Calculations: Master the use of Excel functions like PMT, IPMT, and PPMT to accurately calculate loan payments, interest, and principal.
- Amortization Schedules: Build both fixed-rate and dynamic amortization schedules to visualize loan repayment.
- Advanced Loan Analysis: Analyze complex loan scenarios including balloon loans, principal paydowns, and variable-rate mortgages.
- Loan Term & Capacity: Learn to determine optimal loan terms, calculate borrowing capacity, and solve for interest rates.
Investment Modeling Skills:
- Future Value Calculations: Develop models to calculate the future value of lump sums, recurring deposits, and mixed investments.
- Compound Interest: Understand and apply compound interest calculations, including nominal and effective rates.
- Investment Schedules: Build comprehensive investment schedules to track performance.
- Goal-Based Investing: Solve for required contributions to achieve specific financial goals.
Discounting Techniques for Investment Evaluation:
- Present Value Analysis: Evaluate the present value of future cash flows using powerful discounting techniques.
- NPV (Net Present Value): Calculate NPV to assess the profitability of investments.
- IRR (Internal Rate of Return): Determine the IRR to evaluate investment returns.
- Payback Period: Calculate the payback period to understand the time required to recover initial investment.
- Real-World Applications: Apply these techniques to real-world scenarios like leasing vs. buying and property investment decisions.
By the end of this course, you'll be equipped to build accurate and insightful financial models in Excel, empowering you to make smarter personal, academic, and business decisions.
Hire the developers behind TutorialSearch.io
We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.