Question: Below is a table comprising Astrazeneca Plc. financials from 2011 to 2020: AstraZeneca Plc. Year Revenue Total Expenses Total Liabilities 2020 26,617 21,455 51,107 2019
Below is a table comprising Astrazeneca Plc. financials from 2011 to 2020: AstraZeneca Plc. Year Revenue Total Expenses Total Liabilities 2020 26,617 21,455 51,107 2019 24,384 21,460 48,250 2018 22,090 18,703 48,183 2017 22,465 18,788 48,394 2016 23,002 18,100 47,672 2015 24,708 20,594 41,566 2014 26,547 24,410 38,968 2013 25,806 22,094 32,675 2012 27,973 19,825 29,803 2011 33,591 20,796 29,584 Your task is to produce a forecast for AstraZeneca Plc. revenues for the next 5 years, i.e., from year 2021 to 2025 using the below listed forecasting and forecasting error techniques. a. Forecasting Techniques: i. 2 Period Moving Averages ii. 3 Period Moving Averages iii. 2 Period Weighted Moving Averages iv. 3 Period Weighted Moving Averages v. Exponential Smoothing ( = 0.30) vi. Exponential Smoothing ( = 0.60) vii. Exponential Smoothing ( = 0.90) viii. Excel Trend Function ix. Excel Growth Function x. Simple Regression (Using weights and probabilities where possible) xi. Multiple Regression using Total Expenses and Total Liabilities as the independent variables. (Using weights and probabilities where possible) b. Forecasting Error Techniques: i. Mean Absolute Deviation ii. Mean Square Error iii. Root Mean Square Error iv. Mean Absolute Percentage Error c. You are also required to present a discussion critically analysing the forecasting and forecasting error techniques used in the main report with the data submitted as a separate document.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
