From the course: Financial Analysis: Making Business Projections
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Projecting revenue based on your resources - Microsoft Excel Tutorial
From the course: Financial Analysis: Making Business Projections
Projecting revenue based on your resources
In this video we will be looking at your revenue performance as a function of the resources you have. The logic here is that you spend either money or your energy on creating business opportunities, some of which turn into revenue for your company. Therefore, if you put more resources at the service of your company through more sales people, more marketing campaigns, ads, then the more opportunities you should see coming and ultimately, the more revenue your company will be getting. Another fair assumption is to think that if you don't change the resources you put at the service of your company, then you should not see any change in your revenue performance. The simple logic here is going to be that if you have had the same resources in place for an entire year doing the same thing every working day of the year, for all you know your revenue should be pretty much the same the following year if you change nothing to your setup. If on the contrary things have been changing during the…
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
-
-
-
-
Revenue projection basics1m 46s
-
Preparing past P&Ls3m 40s
-
Projecting revenue based on your resources5m 32s
-
Adjusting for changes in productivity2m 12s
-
Adjusting for changing resources2m 55s
-
Detailing your plan by month using seasonality1m 52s
-
Creating a product-level projection2m 39s
-
Adding back exceptional elements using pipeline information2m 32s
-
Market-driven forecasting2m 46s
-
-
-
-
-
-