BIZ201 Assessment 3 Brief XXXXXXXXXXPage 1 of 9 ASSESSMENT 3 BRIEF Subject Code and Title BIZ201 Accounting for Decision Making Assessment Scenario Analysis - Individual Individual/Group Individual...

I have attached the worksheet and brief


BIZ201 Assessment 3 Brief Page 1 of 9 ASSESSMENT 3 BRIEF Subject Code and Title BIZ201 Accounting for Decision Making Assessment Scenario Analysis - Individual Individual/Group Individual Length 1,500 words 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 (Week 8) Weighting 30% Total Marks 100 marks Context: This assessment is aimed at consolidating knowledge from Modules 1-3. By prescribing this assessment, you are able to reflect on the understanding of accounting concepts and be able to apply them to business scenarios like given in 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. For calculation questions show all workings through appropriate Excel formulas. Copy pasted numbers without appropriate Excel formulas will not be accepted. 4. Submit your assessment files using the following naming convention: First Name_Last Name_BIZ201_Assessment3_Workbook.xlsx First Name_Last Name_BIZ201_Assessment3_Report.doc BIZ201 Assessment 3 Brief Page 2 of 9 Myer is a departmental store chain that began in Australia in the 1900’s. Presently, Myer operates 61 stores across Australia and sells a variety of products ranging from electrical goods, homeware, fashion and beauty. In more recent years, Myer has faced growing pressure from competitors such as JB Hi-fi, Uniqlo, Zara as well as the growth of online shopping. In this assessment, your task is to analyse the financial data of Myer’s last five years of trading and devise solutions to move the business forward. The analysis will be based on data compiled from Myer’s Annual Reports. Some information is useful for this assessment includes: Myer - https://www.myer.com.au/content/about-us-myer Annual Reports - http://investor.myer.com.au/Reports/?page=Annual-Reports As this present moment is quite critical for Myer, extensive financial investigation must be completed to inform the decision-making process. Myer’s stakeholders are seeking increased growth, profits and to become more competitive. You are expected to complete an Excel Workbook and Business Report aimed at board members. Myer Holdings Ltd https://www.myer.com.au/content/about-us-myer http://investor.myer.com.au/Reports/?page=Annual-Reports BIZ201 Assessment 3 Brief Page 3 of 9 Part 1 – Excel Workbook Calculations This Excel Workbook is available on learning portal under assessment section. 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 use Excel formulas to calculate your answers. Numbers only will not be accepted. 1. Vertical Analysis - Within the Balance Sheet worksheet, conduct a vertical analysis of the 2019 financial information. 2. Ratio Analysis - Within the Income Statement worksheet, conduct a ratio analysis of the last 2 years of operations (2019 and 2018). Determine the ratios listed in the areas of profitability, efficiency, liquidity and solvency. Part 2 – Business Report 1. Using the results of the Ratio Analysis in Excel workbook, comment on the organisation’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 the organisations can improve its growth, profit targets and become more competitive. 3. With reference to Statement of Cashflows of Myer, compare and comment with reasons on net increase/decrease in cash and cash equivalents in 2018 and 2019. See the Report Format section for guidance on the report structure. BIZ201 Assessment 3 Brief Page 4 of 9 Report Format As this is a business report, the following sections and headings should be included in your write up: Cover Page – Includes assessment title, student name and ID, subject name and code, lecturer’s name, submission date, word count. Be creative while making your cover page. Executive Summary – An executive summary provides a succinct summary of the content within the report. It presents 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. It is recommended to write 10-20% of your total word limit of the report. This section is not included in the word count. Table of Contents – A summary of the sections (headings/sub-headings) and pages numbers. Introduction – The introduction sets the scene and provides context for the aim. It provides background to the issues being addressed only. (Approximately 10% of word count) Main Discussion – (Rename the headings/sub-headings to reflect your report). This section should provide information regarding the analysis you undertook addressing the key deliverables i.e. Part 2. Conclusion – The conclusion restates the aim then provides a brief and concise summary of the discussion to demonstrate that the aim of the report has been achieved. No new information is to be included in the conclusion. (Approximately 10% of word count) References – It is essential that you use Torrens Academic Writing Guide – APA for citing and referencing research. Please see more information on referencing here http://library.laureate.net.au/research_skills/referencing. Please see the marking rubric at the end of this document for a guide to how many references you should be including in this report. References are not included in the word count. Appendices – This is where you 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. http://library.laureate.net.au/research_skills/referencing BIZ201 Assessment 3 Brief Page 5 of 9 Appendix – Myer Holdings Financial Data Table 1 Summary of Consolidated Income Statements Note. Adapted from “Annual Reports”, by Myer Pty Ltd, 2019, (http://investor.myer.com.au/Reports/?page=Annual-Reports). In the public domain http://investor.myer.com.au/Reports/?page=Annual-Reports BIZ201 Assessment 3 Brief Page 6 of 9 Table 2 Summary of Consolidated Balance Sheets Note. Adapted from “Annual Reports”, by Myer Pty Ltd, 2019, (http://investor.myer.com.au/Reports/?page=Annual-Reports). In the public domain http://investor.myer.com.au/Reports/?page=Annual-Reports BIZ201 Assessment 3 Brief Page 7 of 9 Table 3 Summary of Consolidated Cash Flows Note. Adapted from “Annual Reports”, by Myer Pty Ltd, 2019, (http://investor.myer.com.au/Reports/?page=Annual-Reports). In the public domain http://investor.myer.com.au/Reports/?page=Annual-Reports BIZ201 Assessment 3 Brief Page 8 of 9 Marking Rubric: Assessment 3 Assessment Attributes Fail (Unacceptable) 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