BIZ201 Accounting for Decision Making And Management

This assessment is aimed at consolidating your learning from Modules 1-3. In this assessment, you are required to reflect on your understanding of accounting concepts and apply this understanding to business scenarios, as per this brief.

1. Apply relevant accounting concepts to simple business scenarios.
2. Interpret and analyse the information contained in general purpose financial statements, to evaluate the overall financial position and performance of a business

Part 1 – Excel Workbook Calculations

There are three financial statements provided for Woolworths Group; Consolidated Statements of Profit or Loss, Consolidated Statements of Financial Position and Consolidated Statement of Cash Flowsfor the most recent four financial years. Provide answersto the following calculations by using appropriate Excel formulas. Numbers without Excel formulas only will not be accepted.

1. Ratio Analysis – Within the Income Statement worksheet, conduct a ratio analysis of the years ended 2020 and 2019. Calculate the listed ratios for profitability, efficiency, liquidity and solvency. Round your answers to two decimal places.
2. Vertical Analysis – Within the Balance Sheet worksheet, conduct a vertical analysis of Statement of Financial Position for the year ended 2020.

Part 2 – Business Report

1. Using the results of the Ratio Analysis in the Excel workbook, comment on Woolworths Group’s Profitability, Efficiency, Liquidity and Solvency.
2. Based on the results of your analysis, provide recommendations on areas that need improvement or further investigation. Provide recommendations on improving growth, profit and competitiveness.
3. With reference to the Statement of Cash Flows of Woolworths Group, give reasons for the differences in Net increase/(decrease) in cash and cash equivalents between 2020 and 2019.

Executive Summary – An executive summary should provide a succinct summary of the content within the report. It should present information in such a way that readers are able to understand the intention and key elements of the report without having to read the entire document. This section is not included in the word count. (Approximately 150 – 300 words)

Table of Contents – A summary of the sections (headings/sub-headings) and page numbers. Introduction – The introduction should set the scene and provide context for the aim. It should provide background to the company. (Approximately 150 words)

Main Discussion – (Rename the headings/sub-headings to reflect your report). This section should include the analysis and recommendations on Profitability, Efficiency, Liquidity, Solvency to address questions 1 and 2 of part 2. It should also address question 3 of part 2 on Statement of Cash Flows.

Conclusion – The conclusion should restate the aim then provide a brief and concise summary of the discussion to demonstrate that the aim of the report has been achieved. No new information should be included in the conclusion. (Approximately 100 -150 words)

Appendices – This section should provide supporting material which is unsuitable for inclusion in the body of the report, but still has some value to contribute to the report. Note – if you have included an Appendices section in your report, you must mention them in the main body.