Question
Instructions Follow the instructions below to complete this assessment. Follow the instructions below to complete this assessment. 1. Download the provided workbook BIZ201_Assessment_2_Student Workbook from
Instructions Follow the instructions below to complete this assessment.
Follow the instructions below to complete this assessment. 1. Download the provided workbook BIZ201_Assessment_2_Student Workbook from the Assessment 2 area on Blackboard. 2. 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. 3. Complete the following calculations and tasks for the given business: a. Conduct a horizontal of Statement of Financial Position forthe year ended 2022 in the provided Excel Workbook within the Balance Sheet worksheet. Round your answers to two decimal places. b. Conduct a ratio analysis of the years ended 2022 and 2021. Calculate the listed ratiosfor Profitability, Efficiency, Liquidity and Solvency in the provided Excel Workbook within the Income Statement worksheet. Round your answers to two decimal places. c. 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 companys Profitability, Efficiency, Liquidity and Solvency. Based on the results of your analysis, provide recommendations on areasthat need improvement orfurther investigation. d. 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started