Dear Mr.Tanui
Could you please do the same task for another company like Almari or Aramco or SABIC
and I will pay the same price but the deadline is tomorrow ??
Is that OK
PLEASE CONFIRM
Task 1.
You are required to search for a well-known organization's finance report (hopefully stock listed). Then extract the monthly or quarterly revenue/sale data for a period of five years. After that, find the monthly or quarterly trend in this data. Finally, estimate the annual to monthly or quarterly trend ratio.
Examples of sources of info:
https://investor.starbucks.com/phoenix.zhtml?c=99518&p=quarterlyearningshttps://investor.dunkinbrands.com/results.cfm
https://www.investor.jnj.com/annual-reports.cfm
https://investor.shareholder.com/mattel/annuals.cfm
Task 2
Based on the data set provided in sheet 2 of the excel workbook you got you to practice the different forecasting methods, please calculate all the error metrics and state based on the tracking signal values whether the forecast is accurate or not. Please, submit these two tasks in one excel file only.
Attachment:- Qarterly_Annual trend excercise-3.xlsx