As a first step, present three revenue forecasts in the Assumptions sheet:

$$ Analysts forecast: following the analyst estimates provided below $($in $m$)$

$2024202520262027$

$496\mathrm{.}97614\mathrm{.}80746\mathrm{.}031,024\mathrm{.}00$

$$ Compounded growth: using a geometric mean of the $2018-2023$ period.

$$ Exponential smoothing: using an appropriate exponential smoothing method based on the

$2018-2023$ period.

After generating the three Revenue forecasts, analyse their profiles and label each forecast as the

Base, Optimistic and Pessimistic scenario