Building an Operating Model in Excel
Learn how to build a dynamic financial operating model in Excel from scratch just like the investment bankers do it. We make it super simple by taking you step by step through each line using the example of a lemonade stand.
Meet Your Instructor
Understand what a financial operating model is and what attributes make for a good one.
Revenue and COGS Assumptions
We take you step-by-step through the assumptions section of your model, focusing on the inputs and structure that will drive the revenue and cost of goods sold components of the income statement.
The Income Statement Part 2
Finalize your income statement by connecting the operating expenses section, identifying capital expenditures and filling out the the depreciation and tax lines.
The Statement of Cash Flows
Finalize your model by assembling a statement of cash flows to understand how cash is generated and consumed.