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.
Market-driven forecasting - Microsoft Excel Tutorial
From the course: Financial Analysis: Making Business Projections
Market-driven forecasting
A final note on revenue forecasting. Many large corporations prepare their annual forecast based on their market share position and the expected growth of that same market. That methodology is based on market data that is produced and sold by organizations specialized in specific industries. Those companies gather sales data from the biggest players in the industry, consolidate them, and communicate back the aggregate view to their affiliates. Those organizations also analyze trends and evolutions in the market. And offer their opinion in terms of expected growth in the market. They also calculate the market share of the different players in that market. Corporations within that market then use that information to define their plan. For example, based on their current market share position, they can decide to set a market share goal for the year. Once that goal is defined, there is a revenue target that needs to be met in order to get those market shares. It also means that those…
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)
-
-
-
-
-