Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Given : Financial Ratios Table Financial Ratio 2 0 1 9 2 0 2 0 2 0 2 1 EBIT ( R million ) 6

Given :
Financial Ratios Table
Financial Ratio 201920202021
EBIT (R million)683576831
Gross Profit 1,7361,6681,840
Net Profit Margin 5.4%3.5%6.2%
Return on Equity (ROE)6.6%4.8%7.8%
Liquidity Ratios Table
Financial Ratio 2019,2020,2021,
Current Ratio 1.7,2.1,2.0
Quick Ratio 1.1,1.4,1.3
Cash Ratio 0.3,0.60.5
Efficiency Ratios Table
Financial Ratio 201920202021
Stock Days 596660
Creditors Days 676660
Debtors Days 534845
Working Capital Cycle 454845
Asset Utilization Ratio
Financial Ratio 201920202021
Total Asset Turnover 0.810.820.88
Leverage Ratios
Financial Ratio 201920202021
Debt to Equity Ratio 0.90.80.7
Debt Ratio 0.470.440.41
Cost of Capital
Estimated Required Rate of Return (RRR): N/A
Estimated Weighted Average Cost of Capital (WACC): N/A
DuPont Model Interpretation
Return on Equity (ROE)= Net Profit Margin \times Asset Turnover \times Financial Leverage
2019: 5.4%\times 0.81\times 1.86=8.1%2020: 3.5%\times 0.82\times 1.73=5.0%2021: 6.2%\times 0.88\times 1.58=8.7%
Compound Annual Growth Rate (CAGR)
Share Price CAGR: -1.3%
Earnings CAGR: +6.6%
Dividends CAGR: -2.9%
Provide academic calculated table for Mpact Limited Financials Report Ratio Analysis between year 2019,2020 and 2021 and brief explanations.
1. EBIT
2. Gross profit
3. Net profit Margins
4. Return on Equity
5. Current ratio
6. Quick Ratio
7. Cash ratio
8. Stock days in (365 days)
9. Creditors Days (Payment Period)
10. Debtors days (Collection Period)
11. Working Capital Cycle
12. Total Asset Turnover
13. Debt to Equity Ration
14. Debt Ratio
15. Estimated Required Rate of Return (RRR)
16. Estimated Weighted Average Cost of Capital (WACC)
17.2019-2021 DuPont Model Interpretation (ROE)
18. Compound Annual Growth (CAGR) Over 3 years 2019,2020,2021 Years Share Price, Earing and dividends
Provide Step by step calculations showing the results

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Business Statistics

Authors: Ronald M. Weiers

7th Edition

978-0538452175, 538452196, 053845217X, 2900538452198, 978-1111524081

Students also viewed these Finance questions