Part A Calculate the following ratio for each of the last 3 years (You can use Excel formulas that reference the data in the previous tab, or you can just enter the values into the boxes below.) 2023 Profitability Ratios 1. Return on Equity 2. Return on Capital Employed 3. Operating Profit Margin 4. Gross Profit Margin Efficiency Ratios PART 3: FINANCIAL STATEMENT ANALYSIS 5. Average Inventory Turnover Period 6. Average Settlement Period for Accounts Receivable 7. Average Settlement Period for Accounts Payable 8. Sales Revenue to Capital Employed Liquidity Ratios 9. Current Ratio 10. Acid Test Ratio Leverage Ratios 11. Gearing Ratio 12. Interest Cover Ratio Investment Ratios (Percentage to 1 decimal place) (Percentage to 1 decimal place) (Percentage to 1 decimal place) (Percentage to 1 decimal place) {No. of days to 1 decimal place) [No. of days to 1 decimal place) (No. of days to 1 decimal place) (Percentage to 1 decimal place) (Decimal value to 2 decimal places) (Decimal value to 2 decimal places) (Percentage to 1 decimal place) (Decimal value to 2 decimal places). (Percentage to 1 decimal place) (Percentage to 2 decimal places) (Round to the nearest cent) (Decimal value to 1 decimal place) 13. Dividend Payout Ratio 14. Dividend Yield 15. Earnings Per Share 16. P/E Ratio* *(use the EPS rounded to the nearest cent in doing this calculation) Enter Student No. Part 3 Data & Instructions. Part 3 (A) Part 3 (B) Part 3 (C) 2024 Part 3 (D) Part 3 (E) 2025 Industry Averages 29.5% 10.6% 15.7% 41.3% 71.1 37.4 44.2 89.1% 4.97 2.98 60.9% 6.01 42.8% 5.22% $0.25 9.0

Calculate the following ratio for each of the last 3 vears Calculate the following ratio for each of the last 3 vears