What do you think?
Rate this book
Learn how to do Financial Modeling
Learn how to do Financial Modeling
Table of Contents
1. Introduction to Financial Modeling - What is financial modeling, why it's important, overview of the key concepts
2. Formatting and Layout of Models - Best practices for setting up and formatting financial models to make them clear and easy to follow
3. Inputs and Assumptions - How to structure model inputs and assumptions, sensitivity analysis, scenarios
4. The 3 Financial Statements - Understanding the 3 key financial income statement, balance sheet, cash flow statement
5. Linking the 3 Statements - Techniques for linking the income statement, balance sheet, and cash flow statement in models
6. Projecting the Income Statement - How to build a robust income statement projection model
7. Projecting the Balance Sheet - How to build a balance sheet projection based on income statement projections
8. Projecting Cash Flows - Building an integrated cash flow projection from net income projections
9. Sales and Revenue Drivers - Modeling techniques for forecasting key sales and revenue drivers
10. Operating Costs Projections - Approaches for modeling future operating costs based on revenue projections
11. Capital Expenditures - How to project capital expenditures and depreciation expense
12. Working Capital - Modeling techniques for projecting working capital needs
13. Debt Schedule - Building a debt schedule and projecting interest expense
14. Valuation Methods - Overview of DCF, comparables, precedent transactions, LBO models
15. Discounted Cash Flow Model - Constructing a DCF model for valuing a company
16. Comps and Precedents - Building comps and precedents models for valuation
17. Leveraged Buyouts - Constructing an LBO model to analyze a leveraged buyout scenario
18. Sensitivity Analysis - Performing sensitivity analysis on key model assumptions and outputs
19. Scenario Analysis - Building scenario analysis models to stress test key assumptions
20. Presenting Model Outputs - Best practices for presenting model outputs in charts, graphs, tables
Table of Contents
1. Introduction to Financial Modeling - What is financial modeling, why it's important, overview of the key concepts
2. Formatting and Layout of Models - Best practices for setting up and formatting financial models to make them clear and easy to follow
3. Inputs and Assumptions - How to structure model inputs and assumptions, sensitivity analysis, scenarios
4. The 3 Financial Statements - Understanding the 3 key financial income statement, balance sheet, cash flow statement
5. Linking the 3 Statements - Techniques for linking the income statement, balance sheet, and cash flow statement in models
6. Projecting the Income Statement - How to build a robust income statement projection model
7. Projecting the Balance Sheet - How to build a balance sheet projection based on income statement projections
8. Projecting Cash Flows - Building an integrated cash flow projection from net income projections
9. Sales and Revenue Drivers - Modeling techniques for forecasting key sales and revenue drivers
10. Operating Costs Projections - Approaches for modeling future operating costs based on revenue projections
11. Capital Expenditures - How to project capital expenditures and depreciation expense
12. Working Capital - Modeling techniques for projecting working capital needs
13. Debt Schedule - Building a debt schedule and projecting interest expense
14. Valuation Methods - Overview of DCF, comparables, precedent transactions, LBO models
15. Discounted Cash Flow Model - Constructing a DCF model for valuing a company
16. Comps and Precedents - Building comps and precedents models for valuation
17. Leveraged Buyouts - Constructing an LBO model to analyze a leveraged buyout scenario
18. Sensitivity Analysis - Performing sensitivity analysis on key model assumptions and outputs
19. Scenario Analysis - Building scenario analysis models to stress test key assumptions
20. Presenting Model Outputs - Best practices for presenting model outputs in charts, graphs, tables
54 pages, Paperback
Published August 13, 2023
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
No one has reviewed this book yet.