This assignment will be based on real data which can be taken primarily from the

This assignment will be based on real data which can be taken primarily from the annual reports of Dubai Refreshment for the last 3 years ended December 31, 2020-2019-2018 (1 prior year’s (2017) annual reports are also available for more depth and to be used as a base for Horizontal Analysis).
Full copies of the Annual Financial Reports are available on Moodle and through the websites of Dubai Financial Markets (https://www.dfm.ae/issuers/listed-securities/securities/financial-report-details?id=c8d957c3-4ec4-4208-9607-850583e1e175)
This is an individual assignment.
Required
You have been hired as a consultant by Dubai Refreshment to prepare an independent report analysing the financial status of the company and to communicate your findings in a formal written report to a group of its senior managers. This forms part of a management development programme which is designed to enable them to understand the company’s financial statements so that they in turn can brief their own departmental staff on the company.
You are therefore required to produce a professional report which should include a detailed analysis of the following areas:-
(a) Profitability
(b) Efficiency
(c) Liquidity
(d) Gearing
(e) Horizontal common size analysis using the consolidated statement of income (use 2017 as a base)
(f) Vertical common size analysis Using the consolidated balance sheet (use total assets as a base)
(g) Comparative analysis with a competitor company within the same industry
(h) The evaluation of performance of business units using financial and non-financial measures
(i) Conclusions and Recommendations
Your findings should be submitted in a formal report with well-founded conclusions and recommendations.
You should state any assumptions made
Professional presentation expected
Font size 12 Times New Roman
Standard margin sizes, headers & footers
In text citations and Harvard style Referencing where appropriate
All tables, graphs, charts and calculations to be placed in the appendix and cross referred to in the main text.
Report style language – not essay
Should include:-
• Title page,
• Table of contents
• Executive Summary (approx. 1/8th in size of the main report)
• Introduction which should, include a brief background and an indication of what is to come in the report
• The main body of the report should include sections on:- profitability efficiency, liquidity, gearing, horizontal analysis and vertical analysis
• Conclusion
• Recommendations
• References
• Appendix (which should include all graphs, charts, calculations etc.)
Comments from Customer
this is my first time to deal with you guys and i am an A student
i need to receive a perfect assignment please
I’ve added all the guidelines received from the instructor