Get startedGet started for free

Forecasting

Now that you calculated different opportunities based on the NRM pillars, it is time to wrap up and present the numbers to your management. You would like to present a waterfall graph to show how your initiatives will have an impact on the company's net sales of 2024.

Let's start by making a forecast for the net sales in 2024 without our NRM initiatives. We'll base ourselves on the market sales until 2022, extrapolate the current trend until 2024 and calculate what it represents in net sales. You will create the waterfall graph in the next exercise.

If you lost progress, close any open reports and load 3_3_forecasting.xlsx from the Workbooks folder.

This exercise is part of the course

Case Study: Net Revenue Management in Excel

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise