Financial Modeling in Excel

1.Introduction of Financial Modeling
What is Financial Modeling?
What are the Different Types of Financial Models?
How to Structure a Financial Model?

2.Purpose of Financial Modeling
How to Format a Financial Model?
Guidelines for Color Coding in Financial Modeling
How to Make Financial Models Easier to Audit?
What are the Sign Convention Rules in Financial Modeling?

3.Maintain Consistency in Financial Modeling
How to Ensure Simplicity in Financial Models (“BASE”)
How to Manage Date Complexities in Excel
How to Name Cells and Ranges
Why Group Rows Instead of Hiding Them?

4.Structure a Financial Model
No Spacer Columns Between Data

5.Annual vs. Quarterly Model
How to Handle Circular References in Financial Modeling
IFERROR Error-Trap
How to Error-Proof a Financial Model
Favor Direct Calculations over “Plugs”
Industry Guidelines on Presentability and Design
How to Integrate Scenario and Sensitivity Analysis

6.3-Statement Model
How to Build a 3-Statement Model
How to Format the 3-Statement Financial Model
What is Periodicity in 3-Statement Modeling?
What is the Structure of a 3-Statement Model?
How to Forecast the Income Statement?
How to Forecast the Balance Sheet?
Why Does the 3-Statement Model Matter?

7.Financial Modeling Techniques
Where do I begin?
3-Statement Linkages
Interest Expense Circularity in Financial Models

8.Income Statement
Income Statement Historical Data
How to Project the Income Statement

9.Balance Sheet Forecasting
How to Forecast the Balance Sheet?
Working Capital
PP&E and Intangible Assets
Goodwill
Deferred tax assets and liabilities
Common stock and APIC
Stock-based compensation

1.Introduction of Financial Modeling
What is Financial Modeling?
What are the Different Types of Financial Models?
How to Structure a Financial Model?

2.Purpose of Financial Modeling
How to Format a Financial Model?
Guidelines for Color Coding in Financial Modeling
How to Make Financial Models Easier to Audit?
What are the Sign Convention Rules in Financial Modeling?

3.Maintain Consistency in Financial Modeling
How to Ensure Simplicity in Financial Models (“BASE”)
How to Manage Date Complexities in Excel
How to Name Cells and Ranges
Why Group Rows Instead of Hiding Them?

4.Structure a Financial Model
No Spacer Columns Between Data

5.Annual vs. Quarterly Model
How to Handle Circular References in Financial Modeling
IFERROR Error-Trap
How to Error-Proof a Financial Model
Favor Direct Calculations over “Plugs”
Industry Guidelines on Presentability and Design
How to Integrate Scenario and Sensitivity Analysis

6.3-Statement Model
How to Build a 3-Statement Model
How to Format the 3-Statement Financial Model
What is Periodicity in 3-Statement Modeling?
What is the Structure of a 3-Statement Model?
How to Forecast the Income Statement?
How to Forecast the Balance Sheet?
Why Does the 3-Statement Model Matter?

7.Financial Modeling Techniques
Where do I begin?
3-Statement Linkages
Interest Expense Circularity in Financial Models

8.Income Statement
Income Statement Historical Data
How to Project the Income Statement

9.Balance Sheet Forecasting
How to Forecast the Balance Sheet?
Working Capital
PP&E and Intangible Assets
Goodwill
Deferred tax assets and liabilities
Common stock and APIC
Stock-based compensation