Question
Using the financial statement of ENTERPRISE GROUP GHANA for the years 2019,2020 and ,2021 compute liquidity, asset management, debt, and profitability ratios. Based on these
Using the financial statement of ENTERPRISE GROUP GHANA for the years 2019,2020 and ,2021 compute liquidity, asset management, debt, and profitability ratios. Based on these ratio values, perform a trend analysis. Financial statements will include balance sheet, income/expense, and statement of cash flow. All calculations are to be done using Excel and the quantified information presented in spreadsheet format. Input the financial statements for the three years into a spreadsheet. Prepare common size statements for the three most recent years. Prepare percentage change statements for the last two years by using the three-year data for your balance sheet and income statement data. (Not required for Statement of Cash Flows).
Written Report to Accompany Spreadsheet Output: Prepare a summary report that includes a basic profile of the enterprise group ghana and identifies its chief competitors. Summarize your spreadsheet results, evaluating ratios for liquidity, asset management, debt, and profitability. Your summary should be in paragraph form using a word processor.
Calculate the Z-Score of the company over the three-year period.
Assess the solvency of the listed company assigned to you over a three-year period using Altmans Z-Score model.
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