Accounting For Decision Making Report Writing - Accounting Assignment Help

Assignment Task

Part 1 – Excel Workbook Calculations

There are 3 consolidated reports pertaining to profit and loss, balance sheet and cash flow activities for the most recent 5 years. In this section, you must show all of your workings, that is, you must include the Excel formulas used in your calculations. Numbers only will not be accepted.

1. Vertical Analysis - Within the Balance Sheet worksheet, conduct a vertical analysis of the 2020 financial information.

2. Ratio Analysis - Within the Income Statement worksheet, conduct a ratio analysis of years 2020 and 2019. Calculate listed ratios for profitability, efficiency, liquidity and solvency. Round your answers to two decimal places.

Part 2 – Business Report

1. Using the results of the Ratio Analysis in the Excel workbook, comment on Myer’s Profitability, Efficiency, Liquidity and Solvency.

2. Based on the results of your analysis, make recommendations on areas that need improvement or further investigation. Include in your recommendations how Myer can improve its growth, profit and competitiveness.

3. With reference to the Statement of Cash Flow of Myer, give reasons for net increase/decrease in cash and cash equivalents between 2020 and 2019. See the Report Format section for guidance on the report structure.

This Accounting Assignment has been solved by our Accounting experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.