Reference no: EM132592865 , Length: word count:1500
BIZ201 Accounting for Decision Making - Laureate International Universities
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 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.
Myer Holdings Ltd
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
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.
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.
Attachment:- Accounting for Decision Making.rar