A firm has experienced the following sales, costs and gross profit figures over the last 3 years:

Create a forecast of sales, costs and gross profits for the next 5 years.
Assume growth will continue at the existing rate, along with costs.
You will need to consider the location of the growth calculation: remember the concept of the base column. Also bear in mind the rule of only one formula per row (left-to-right consistency). Your report should show both the historic and the forecast figures.

Transcribed Image Text:

Year 1 2 3 Sales 100 110 120 Costs 80 85 90 Gross profit 20 25 35