Question
The Modelling worksheet contains assumptions to build an Income Statement forecast for Chalten Ltd for the 2022 2026 period. Using the assumptions provided, please: [2
The Modelling worksheet contains assumptions to build an Income Statement forecast for Chalten Ltd for the 2022 2026 period. Using the assumptions provided, please:
-
[2 marks] Build the Economic scenarios section [Rows 16 -33], including a scenario selector
-
[2 marks] Build the Revenue forecast [Rows 42 -58]
-
[2 marks] Build the Cost of Sales forecast [Rows 68 -78]
-
[2 marks] Build the Income Statement forecast [Rows 88 -96]
-
[6 marks] After analysing the companys forecasts, Chaltens CFO believes the sales volume growth is too high. The company aims to having an implied operating rate that does not exceed 80%. Given that the sales growth rate is the same every year, what should that rate be to make sure Chalten followsthe 80% rule?
-
[6 marks] The model is also assessed for consistency and use of best practices
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started