Complete Financial Analysis Report of Public Companies

Attached are financial reports for public companies and an outline of the task requirements. Essentially, key financial ratios need to be calculated based on the financial reports and added to an Excel spreadsheet over multiple years and a graph generated. An example of a similar spreadsheet is attached. These ratios should be compared to each other and the market in general and a report has to be written analysing and interpreting findings and conclusions. Most of it is basic financial calculating and analysis. Good English skills and some research is required to determine average market ratios as well as financial analysis and financial report writing abilities. Please present a Word document with the report and an Excel spreadsheet with the calculations and graph. The Excel should show the calculation in each cell, not just the answer. The task has to be completed within 2 weeks and is due by the 8th September. Please read the Word document attached before bidding.