From the course: Excel for Finance: Building a Three-Statement Operating Model
Unlock the full course today
Join today to access over 23,300 courses taught by industry experts.
Forecasting the variable expenses - Microsoft Excel Tutorial
From the course: Excel for Finance: Building a Three-Statement Operating Model
Forecasting the variable expenses
- [Instructor] So now let's move on to our operating expenses. These are expenses that are often called below the line, the line being the gross profit, right? This is the profit we make from directly selling our product, but we have all kinds of administrative expenses to keep the business going. It's, you know, hiring people. We have rent, professional fees, insurance, all, you know, what's called the administrative expenses. And we need to model those out as well. Big picture speaking, these expenses are normally broken down into two buckets. We have variable expenses, which means they move contingent upon something else, typically revenue or labor, or something like that. And then we have fixed expenses, which means they're just going to grow or stay steady regardless of what the business does above the line or above gross profit. And I can see that here in the notes from the CFL. A few variable ones. I've got 18%…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
Foundation of a good forecast7m 34s
-
(Locked)
Build the annual income statement5m 53s
-
(Locked)
Build the annual balance sheet4m 29s
-
(Locked)
Calculating year-over-year growth4m 39s
-
(Locked)
Forecasting the revenue6m 55s
-
(Locked)
Forecasting the cost of goods sold6m 17s
-
(Locked)
Forecasting the variable expenses6m 30s
-
(Locked)
Forecasting the fixed expenses4m 8s
-
(Locked)
Forecasting the headcount5m 30s
-
(Locked)
Headcount in outer years5m 59s
-
(Locked)
Forecast the income tax expense2m 41s
-
-
-
-
-
-