Hands-On Financial Modeling with Excel for Microsoft 365

Table of Contents

1. An Introduction to Financial Modeling and Excel
2. Steps for Building a Financial Model
3. Formulas and Functions - Completing Modeling Tasks with a Single Formula
4. The Referencing Framework in Excel
5. An Introduction to Power Query
6. Understanding Project and Building Assumptions
7. Asset and Debt Schedules
8. Preparing a Cash Flow Statement
9. Ratio Analysis
10. Valuation
11. Model Testing for Reasonableness and Accuracy
12. Case Study 1 – Building a Model to Extract a Balance Sheet and Profit and Loss from a Trial Balance
13. Case Study 2 – Creating a Model for Capital Budgeting