Reference no: EM133030886

BIZ201 Accounting for Decision Making - Laureate International Universities

Assessment - Scenario Analysis

Learning Outcome 1: Apply relevant accounting concepts to simple business scenarios.

Learning Outcome 2: Interpret and analyse the information contained in general purpose financial statements, to evaluate the overall financial position and performance of a business.

Context:

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.

Instructions:
1. Answer questions in Part 1 and 2 at the end of this brief.
2. Submit two files; Excel Workbook and Business Report.
3. Excel workbook is provided on Blackboard. Download it, perform calculations on it, save it and submit with the Business Report.
4. For calculation questions, show all workings through appropriate Excel formulas.

Woolworths Group Limited

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 Flows for the most recent four financial years. Provide answers to 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.

Report Format

Your business report should include the following sections:

Cover Page - It should include student name and ID, subject code and name, assessment number, University's name, lecturer's name, submission date and word count. Be creative while making your cover page.

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)

References - Torrens Academic Writing Guide - APA for citing and referencing research must be used.

Attachment:- Accounting for Decision Making.rar