Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Financial Modeling 101: Master the Key Financial Concepts
Chapter 1 - Course introduction and overview
Welcome to Financial Modeling 101: Master the Key Financial Concepts. Here's what you'll learn. (7:42)
Chapter 2 - Overview: How to Develop a Financial Model
2a. What is a Financial Model? (6:54)
2b. Main Steps in Developing a Financial Model (7:24)
Guideline: Principles & Main Steps in Developing a Financial Model
Quiz on Developing a Financial Model
Answers to Quiz on Developing a Financial Model
Chapter 3 - Time Value of Money
Spreadsheet: Example Calculations and Exercises for Time Value of Money Concepts
3a. Time Value of Money (3:21)
3b. Future Value (14:48)
3c. Present Value & Discount Rate (5:18)
3d. Discount Rate and Risk (8:17)
3e. Inflation (Nominal vs. Real) (6:07)
3f. Cash Flow (6:27)
3g. Weighted Average Cost of Capital (WACC) (4:14)
3h. Discounted Cash Flow (2:01)
3i. Depreciation and Tax (26:05)
Reference Sheet: Time Value of Money Concepts
Quiz on the Time Value of Money
Answers to Quiz on the Time Value of Money
Chapter 4 - Financial Forecasting
4a. Why do Financial Forecasting? (4:25)
4b. Market Size Estimation (4:54)
4c. How to Forecast Revenue Step-by-Step (5:42)
4d. How to Forecast Cash Flows (2:53)
Guideline: How to Forecast Revenue and Cash Flows
Quiz on Forecasting
Answers to Quiz on Forecasting
Chapter 5 - Financial Evaluation Metrics
5a. The Context (4:04)
Spreadsheet: Example Calculations and Exercises for Financial Evaluation Metrics
5b. Payback Period (5:15)
5c. Return on Investment (ROI) (4:32)
5d. Net Cash Flow (NCF) (3:03)
5e. Net Present Value (NPV) (15:53)
5f. Internal Rate of Return (IRR) (12:25)
5g. NPV vs IRR (12:06)
READ THIS before continuing!
5h. Modified IRR (MIRR) [master] (14:01)
5i. Differential Cash Flow, Unacost, Capitalized Cost [master] (9:33)
5j. Excess Present Value Index (EPVI) [master] (3:55)
5k. XNPV, XIRR, XMIRR [master] (9:41)
5l. 6 Pitfalls in Profitability Analysis to Watch Out For (2:55)
Quiz on Financial Evaluation Metrics
Answers to Quiz on Financial Evaluation Metrics
Chapter 6 - Financial Evaluation of Projects and Investments
6a. Example Applications (1:56)
Reference Sheet: Financial Evaluation Step-by-Step Guide
6b. Step-by-Step Guide to Financial Evaluation (7:11)
Spreadsheet: Financial Evaluation Step-by-Step Guide Examples
6c. Step-by-Step Guide: Example 1 (5:36)
6d. Step-by-Step guide: Example 2 (9:45)
6e. Step-by-Step Guide: Example 3 (7:42)
Spreadsheet Template: Financial Evaluation
6f. How to Use the Financial Evaluation Spreadsheet Template (4:54)
6g. Course Conclusion (1:05)
Course Evaluation Questionnaire
5k. XNPV, XIRR, XMIRR [master]
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock