A SSESSMENT 3 BRIEF
Subject Code and Title BIZ201 Accounting for Decision Making
Assessment Scenario Analysis - Individual
Individual/Group Individual
Length 1500 words ± 10%
Learning Outcomes b) Apply relevant accounting concepts to simple business scenarios.
c) Interpret and analyse the information contained in general purpose financial statements, to evaluate the overall financial position and performance of a business.
Submission By 11:55 pm AEST/AEDT Sunday of Module 4.2 (Week 8)
Weighting 30%
Total Marks 100 marks
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. Providing numbers without appropriate Excel formulas will not be accepted.
5. Submit your assessment files using the following naming convention:
First Name_Last Name_BIZ201_Assessment3_Workbook.xlsx
First Name_Last Name_BIZ201_Assessment3_Report.docx
Woolworths Group Limited
Woolworths Group is a diverse group of retail businesses that began as a bargain store in
Australia in 1924. Presently, it consists of three core businesses; Australian Food New, Zealand Food and Portfolio. It operates across Australia and New Zealand and sells a variety of products ranging from fresh food to financial services. In recent years, it has faced volatile growth patterns.
In this assessment, your task is to analyse the financial data of Woolworths Group Limited and devise solutions to move this business forward. The analysis will be based on the data compiled from the Group’s Annual Reports. Some information that is useful for this assessment includes:
Woolworths Group Limited - https://www.woolworthsgroup.com.au/
Annual Reports - https://www.woolworthsgroup.com.au/page/investors/ourperformance/reports/Reports/
As this is a critical time for Woolworths, extensive financial investigation must be completed to inform the decision-making process. Woolworths’ stakeholders are seeking increased growth, profit and to become more competitive strategically. You are expected to complete an Excel Workbook and Business Report for them.
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.
See the Report Format section for guidance on the report structure.
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. More information on referencing can be found on https://library.torrens.edu.au/academicskills/apa/tool. The marking rubric at the end of this document provides a guide on the number of references to be included in this report. References are not included in the word count.
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.
Marking Rubric: Assessment 3
Assessment Attributes Fail
(Yet to achieve minimum standard) 0 – 49 Pass
(Functional)
50 – 64 Credit
(Proficient)
65 – 74 Distinction
(Advanced)
75 – 84 High Distinction
(Exceptional)
85 – 100
Grade Description
(Grading Scheme)
Fail grade will be awarded if a student is unable to demonstrate satisfactory academic performance in the subject or has failed to complete required assessment points in accordance with the subject’s required assessment points. Pass is awarded for work showing a satisfactory achievement of all learning outcomes and an adequate understanding of theory and application of skills. A consistent academic referencing system is used and sources are appropriately acknowledged. Credit is awarded for work showing a more than satisfactory achievement of all learning outcomes and a more than adequate understanding of theory and
application of skills. A consistent academic referencing system is used and sources are appropriately acknowledged. Distinction is awarded for work of superior quality in achieving all learning outcomes and a superior integration and understanding of theory and application of skills. Evidence of in-depth research, reading, analysis and evaluation is demonstrated. A consistent academic referencing system is used and sources are appropriately acknowledged. High Distinction is awarded for work of outstanding quality in achieving all learning outcomes together with outstanding integration and understanding of theory and application of skills. Evidence of
in-depth research, reading, analysis, original and creative thought is demonstrated. A consistent academic referencing system is used and sources are appropriately acknowledged.
Calculation of
financial metrics
30% Demonstrates no evidence of use excel formulas and relevant worksheets to calculate appropriate ratios. Demonstrates limited evidence of use excel formulas and relevant worksheets to calculate appropriate ratios. Demonstrates consistent evidence of use excel formulas and relevant worksheets to calculate appropriate ratios. Demonstrates an advanced evidence of use excel formulas and relevant worksheets to calculate appropriate ratios. Consistently demonstrates an advanced evidence of use excel formulas and relevant worksheets to calculate appropriate ratios.
Understanding of
Profitability, Efficiency, Liquidity and Solvency of the business using ratio analysis and providing Does not use ratio analysis to demonstrate the understanding of
Profitability, Efficiency, Liquidity and Solvency of the business. Does not Limited use of ratio analysis
to demonstrate the understanding of
Profitability, Efficiency, Liquidity and Solvency of the business. Provides Well-developed use of ratio analysis to demonstrate the understanding of Profitability, Efficiency, Liquidity and Solvency of the business.
Provides some general and Thoroughly developed understanding of
Profitability, Efficiency, Liquidity and Solvency of the business by using ratio analysis. Provides Highly developed understanding of
Profitability, Efficiency, Liquidity and Solvency of the business by using ratio analysis. Provides thorough
BIZ201_Assessment_3_Brief_Scenerio Analysis Page 5 of 6
recommendations 40% provide recommendations. some/general recommendations. some specific recommendations. thoughtful specific recommendations. and insightful recommendations.
Understanding of Cash flow Statement
15% Does not compare statement of cash flow. Does not comment and/or
provide reason for differences. Compares statement of cash flow. Comments on differences without providing reasons. Compares statement of cash flow. Comments on differences. Provides some reasons. Compares statement of cash flow. Comments on differences. Provides most reasons. Compares statement of cash flow. Comments well on differences. Provides all reasons.
Correct citation of key
resources and evidence
Overall structure, appearance and referencing of the
report are assessed
15% Demonstrates inconsistent use of good quality, credible and relevant resources to support and develop ideas. Less than 4 good quality references provided. Has not correctly used APA referencing style. Demonstrates use of credible and relevant resources to support and develop ideas, but these are not always explicit or well developed. At least 4 good quality references provided. Multiple mistakes and errors in reference list. Demonstrates use of high quality, credible and relevant resources to support and develop ideas. At least 6 good quality references provided. Some mistakes and errors in reference list. Demonstrates use of good quality, credible and relevant resources to support and develop arguments and statements. Shows evidence of wide scope within the organisation for sourcing evidence. At least 6 good quality references provided. Few mistakes and errors in reference list. Demonstrates use of high- quality, credible and relevant resources to support and develop arguments and position statements. Shows evidence of wide scope within and without the organisation for sourcing evidence. At more than 6 good quality references provided. No mistakes and errors in reference list.
BIZ201_Assessment_3_Brief_Scenerio Analysis Page 6 of 6