Assessment Task
Calculate financial information for a given business case study. Then interpret and analyse these results to demonstrate an understanding of how business decisions are made.
Context
Using Financial Statements of companies to perform calculations, interpreting results and analysing them will help you develop understanding about how business decisions are made in the industry considering the available financial information. By completing this assessment, you will demonstrate the importance of financial information in business decision making, including the application of financial statements analysis to business decisions.
Instructions
Follow the instructions below to complete this assessment.
- Download the provided workbook ‘BIZ201_Assessment_2_Student Workbook’ from the Assessment 2 area on Blackboard.
- Download the ‘Financial Statements Document’ from the Assessment 2 area on Blackboard. You will use the information contained in this document for the completion of tasks in this brief.
- Complete the following calculations and tasks for the given business:
- Conduct a horizontal (percentage) analysis of ‘Statement of Financial Position’ for the year ended 2022 in the provided Excel Workbook within the ‘Balance Sheet’ worksheet. Round your answers to two decimal places.
- Conduct a ratio analysis of the years ended 2022 and 2021. Calculate the listed ratios for Profitability, Efficiency, Liquidity and Solvency in the provided Excel Workbook within the ‘Income Statement’ worksheet. Round your answers to two decimal places.
- Consolidate your findings and their impact on the decision making of the business in the report by using the results of the ‘Ratio Analysis’ in the Excel workbook to comment on the company’s Profitability, Efficiency, Liquidity and Solvency. Based on the results of your analysis, provide recommendations on areas that need improvement orfurther investigation.
- With reference to the Statement of Cash Flows of the company in the provided Excel Workbook, give reasons for the differences in Net (Decrease)/ Increase in Cash and Cash Equivalents between 2022 and 2021 in the report.