Hands-on financial modeling with Microsoft Excel 365 : build your own practical models for forecasting, valuation, trading, and growth analysis / Shmuel Oluwa

Contents Include:

Part 1: Financial modeling overview

1. An Introduction to Financial Modeling and Excel

2.Steps for Building a Financial Model

Part 2: The use of excel features and functions for financial modeling

3.Formulas and Functions - Completing Modeling Tasks with a Single Formula

4.The Referencing Framework in Excel

5. An Introduction to Power Query

Part 3: Building an integrated 3 - Statement Financial Model with valuation by DCF

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

Includes Index.