A three-statement operating model incorporates your company’s income statement, balance sheet, and cash flow statement to provide an integrated and complete view of your organization’s financial health. Follow along with Chris Reilly, financial modeling expert and experienced Excel trainer, as he shows you how to build a three-statement model in Excel. Chris explains how to clean up source data, build the cash flow statement, build EBITDA, and forecast the income statement, balance sheet, debt schedule, and more.
Skills you’ll gain
Finance
Operating Models
Microsoft Excel
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
LearningLinkedIn Learning
Certificate of Completion
Showcase on your LinkedIn profile under “Licenses and Certificate” section
Chris Reilly I will help you become a Financial Modeling expert.
Learner reviews
4.8out of 5
The overall rating is calculated using the average of submitted ratings. Ratings and reviews can only be submitted when non-anonymous learners complete at least 40% of the course. This helps us avoid fake reviews and spam.
It's a wonderful learning experience to everyone whose work usually involves numbers.The Model has useful techniques to use while navigating the analysis of huge data with numerous figures.its very much commendable.
Helpful
·
Report
Grace Mary Baby
Grace Mary Baby
Finance Professional | FP&A | Corporate Finance
5/5 March 1, 2024
A great start for FP&A aspirants! Very relevant and practical content! Looking forward to more courses from the instructor!
Helpful
·
Report
Contents
What you should know 1m 24s
What you're going to build 4m 11s
Call with the CFO 3m 26s
Initial groundwork and freeze frames 3m 8s
Identifying hardcoded data 2m 19s
Applying the currency format 3m 28s
The value of a placeholder row 4m 7s
Initial error checking 3m 2s
Expanding on error checking 5m 50s
Formatting guide 2m 42s
Indenting and cleanup 3m 43s
Build the cash from operations 7m 35s
Build the cash from investing 2m 58s
Build the cash from financing 3m 27s
Build the change in cash and ending cash 5m 59s
An overview of EBITDA 4m 54s
Building the EBITDA schedule 8m 39s
Foundation of a good forecast 7m 34s
Build the annual income statement 5m 53s
Build the annual balance sheet 4m 29s
Calculating year-over-year growth 4m 39s
Forecasting the revenue 6m 55s
Forecasting the cost of goods sold 6m 17s
Forecasting the variable expenses 6m 30s
Forecasting the fixed expenses 4m 8s
Forecasting the headcount 5m 30s
Headcount in outer years 5m 59s
Forecast the income tax expense 2m 41s
An overview of the balance sheet 1m 40s
How to lay the net working capital 3m 51s
Forecasting the accounts receivable 6m 40s
Forecasting the inventory 3m 11s
Forecasting the accounts payable 3m 20s
Modeling prepaid expenses and accruals 6m 31s
Building the bonus accrual 11m 10s
Building the tax accrual 9m 27s
An overview of CapEx and depreciation 4m 22s
How to lay the fixed assets schedule 2m 50s
Building the CapEx forecast 4m 36s
Building the depreciation waterfall 8m 40s
Modeling existing depreciation 3m 16s
Connecting the fixed assets to the model 4m 16s
Quick cleanup 3m 48s
How to lay the debt schedule 4m 45s
Groundwork of the cash flow sweep 6m 30s
Finishing the cash flow sweep 4m 56s
Modeling the revolver 4m 59s
Getting started with term debt 3m 3s
Setting up term debt amortization 4m
Modeling the term debt amortization 4m 38s
Connecting the debt schedule to the model 5m 26s
Model the leverage ratio 7m 26s
Model the fixed charge coverage ratio 8m 46s
Pre-summary cleanup 8m 7s
Link up the one-pager: Part 1 8m 32s
Link up the one-pager: Part 2 5m 28s
Stress testing the model 3m 57s
Email to the CFO 3m 16s
Epilogue: Real-life application of the model 5m 34s
What’s included
Practice while you learn1 exercise file
Test your knowledge9 quizzes
Learn on the goAccess on tablet and phone
Similar courses
2h 3m Excel Data Visualization: Designing Custom Visualizations
3h 42m Excel: Managing and Analyzing Data
1h 22m Learning Excel What-If Analysis
Download courses
Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.
Introduction: My name is Terence Hammes MD, I am a inexpensive, energetic, jolly, faithful, cheerful, proud, rich person who loves writing and wants to share my knowledge and understanding with you.
We notice you're using an ad blocker
Without advertising income, we can't keep making this site awesome for you.