From the course: Financial Analysis: Making Business Projections
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Adjusting for changes in productivity - Microsoft Excel Tutorial
From the course: Financial Analysis: Making Business Projections
Adjusting for changes in productivity
Voiceover: Up until now we have looked at our current resources and at adding or removing resources, but there is one assumption we have kept the same all along which is that the productivity of our resources remains the same overtime. This of course can be true, but in some occasions we could want to push the productivity of our resources to increase in the future and account for it in our financial plan. For example, you could be unsatisfied with the level of productivity of your resources and believe it should be higher. That of course would affect only your current resources since any new resource could be accounted at that desired level from the start. The logic would then be the following: you need to look at the current productivity of your resources and define what would be the level they need to attain in the coming year. Whether that desired productivity is reached right away or overtime during the year would be entirely up to you to define. Maybe you could change some…
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
-
-
-
-
(Locked)
Revenue projection basics1m 46s
-
(Locked)
Preparing past P&Ls3m 40s
-
(Locked)
Projecting revenue based on your resources5m 32s
-
(Locked)
Adjusting for changes in productivity2m 12s
-
(Locked)
Adjusting for changing resources2m 55s
-
Detailing your plan by month using seasonality1m 52s
-
(Locked)
Creating a product-level projection2m 39s
-
(Locked)
Adding back exceptional elements using pipeline information2m 32s
-
(Locked)
Market-driven forecasting2m 46s
-
(Locked)
-
-
-
-
-