Building a 3 Statement Financial Model
[Required] Step-by-step course to learn to build a basic financial statement model in Excel online
Course introduction
Learning objectives
Model preview
What is a financial model
Types of financial models
Downloadable files
Key structure for model building
Modeling best practice
Inherent tensions in model building
Interactive exercise 1
Model inputs
Model processing
Model outputs
Model structure and approach
Financial modeling steps
Interactive exercise 2
Case overview
Historical data
Historical data cleanup
Assumptions, drivers and forecasting methods
Forecasting methods
Interactive exercise 3
Historical income statement demonstration
Fill in assumptions demonstration
Forecast operating revenues and profits
Forecasting revenues
Forecasting gross margin and SG&A expenses
Forecast revenue down to EBITDA demonstration
Interactive exercise 4
Forecast working capital
Working capital equations – receivable days
Working capital equations – payable days
Working capital equations – inventory days
Forecast working capital demonstration
Forecast PP&E
Forecast PP&E demonstration
Interactive exercise 5
Forecast capital structure
Approaches to modeling capital structure
Circular references
Iterative calculation demonstration
Forecast long-term debt demonstration
Forecast interests and repayments demonstration
Complete the supporting schedule demonstration
Interactive exercise 6
Cash flow forecast
Cash flows from operating activities
Cash flows from investing activities
Cash flows from financing activities
Complete income statement and balance sheet demonstration
Cash flow from operating activities demonstration
Cash flow from investing activities and financing activities demonstration
Check balance sheet demonstration
Interactive exercise 7
Auditing techniques
Change the assumptions to check the model
Model auditing tools in Excel
Check formula inconsistency
Interactive exercise 8
Charts and graphs
Final thoughts
A modular approach to building models
Other final models
Additional case study overview
Downloadable files
Raw data
Copy and paste raw data
Format and link historical subtotals
Build supporting schedules
Calculate historical ratios and metrics
Fill in the assumptions
Build the income statement
Build the balance sheet
Complete supporting schedules
Complete the cash flow statement
Complete the I/S and B/S
Build charts and graphs
Download the completed model
Next steps
Summary
Qualified assessment
Share Your Feedback
Course Completion