0% found this document useful (0 votes)
15 views14 pages

5Y Ratio Analysis PSO Vs Wafi

The document presents financial data for two companies over the years 2020 to 2024, including metrics such as revenue, gross profit, EBIT, interest expense, and net income. It also provides details on total assets, shareholders' equity, total debt, and various financial ratios like ROA, ROE, and margins. Additionally, it includes average metrics for both companies and a weighted score comparison.

Uploaded by

mahshoqshar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
15 views14 pages

5Y Ratio Analysis PSO Vs Wafi

The document presents financial data for two companies over the years 2020 to 2024, including metrics such as revenue, gross profit, EBIT, interest expense, and net income. It also provides details on total assets, shareholders' equity, total debt, and various financial ratios like ROA, ROE, and margins. Additionally, it includes average metrics for both companies and a weighted score comparison.

Uploaded by

mahshoqshar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Year RevenueGross_Profit EBITInterest_Expense

Net_Income
2020 1121161 5267 -5565 13976 -11020
2021 1223678 55777 40516 4242 29405
2022 2541730 176432 146423 5192 91244
2023 3539155 82381 65726 41528 9319
2024 3742082 109117 83198 54739 18327
Year Total_Assets
Shareholders_Equity
Total_Debt
Working_Capital
Cash_Equivalents
Short_Term_Investments
Accounts_Receivable
Inventory
2020 375231 113978 88173 60648 6098 0 198135 65750
2021 413929 142373 79146 84578 2974 0 222385 90277
2022 966687 227343 181552 172619 37458 0 433138 363827
2023 1067454 232344 461795 175534 40625 0 505968 328755
2024 1063519 251033 440368 187797 20390 4201 492939 319902
Year RevenueGross_Profit EBITInterest_Expense
Net_Income
2020 165140 6862 -4020 1415 -4821
2021 249210 22808 9508 666.34 4467
2022 412699 32629 12080 1069 -72.31
2023 431650 29524 6638 833.61 5851
2024 427946 22105 4575 941.86 3297
Year Total_Assets
Shareholders_Equity
Total_Debt
Working_Capital
Cash_Equivalents
Short_Term_Investments
Accounts_Receivable
Inventory
2020 54646 -651.16 15103 -18399 2543 618.93 5067 13510
2021 84850 15321 6047 -8308 4973 429.59 6068 36629
2022 101732 14597 6656 -9318 10801 468.7 7660 42922
2023 106349 19737 7131 -6699 6552 521.6 9482 48051
2024 113874 23058 7410 -3252 4695 10804 8852 45624
Year RevenueGross_Profit EBITInterest_Expense
Net_Income
Total_Assets
Shareholders_Equity
Total_Debt
Working_Capital
2020 1121161 5267 -5565 13976 -11020 375231 113978 88173 60648
2021 1223678 55777 40516 4242 29405 413929 142373 79146 84578
2022 2541730 176432 146423 5192 91244 966687 227343 181552 172619
2023 3539155 82381 65726 41528 9319 1067454 232344 461795 175534
2024 3742082 109117 83198 54739 18327 1063519 251033 440368 187797
Cash_Equivalents
Short_Term_Investments
Accounts_Receivable
InventoryAvg_AssetsAvg_EquityAvg_Debt
Gross_Margin
Operating_Margin
Net_Margin
6098 0 198135 65750 0.004698 -0.004964 -0.009829
2974 0 222385 90277 394580 128175.5 83659.5 0.045581 0.03311 0.02403
37458 0 433138 363827 690308 184858 130349 0.069414 0.057608 0.035898
40625 0 505968 328755 1017071 229843.5 321673.5 0.023277 0.018571 0.002633
20390 4201 492939 319902 1065487 241688.5 451081.5 0.029159 0.022233 0.004898
ROA ROE Debt_to_Equity
Debt_to_Assets
Asset_Turnover
Interest_Coverage
WC_to_Revenue
WC_to_Debt
0.773597 0.234983 -0.398183 0.054094 0.68783
0.074522 0.229412 0.555906 0.191207 3.101216 9.551155 0.069118 1.068633
0.132179 0.49359 0.798582 0.187808 3.682023 28.20166 0.067914 0.950796
0.009163 0.040545 1.987549 0.432613 3.479754 1.582691 0.049598 0.380112
0.017201 0.075829 1.754224 0.414067 3.512088 1.519904 0.050185 0.426455
Year RevenueGross_Profit EBITInterest_Expense
Net_Income
Total_Assets
Shareholders_Equity
Total_Debt
Working_Capital
2020 165140 6862 -4020 1415 -4821 54646 -651.16 15103 -18399
2021 249210 22808 9508 666.34 4467 84850 15321 6047 -8308
2022 412699 32629 12080 1069 -72.31 101732 14597 6656 -9318
2023 431650 29524 6638 833.61 5851 106349 19737 7131 -6699
2024 427946 22105 4575 941.86 3297 113874 23058 7410 -3252
Cash_Equivalents
Short_Term_Investments
Accounts_Receivable
InventoryAvg_AssetsAvg_EquityAvg_Debt
Gross_Margin
Operating_Margin
Net_Margin
2543 618.93 5067 13510 0.041553 -0.024343 -0.029193
4973 429.59 6068 36629 69748 7334.92 10575 0.091521 0.038153 0.017925
10801 468.7 7660 42922 93291 14959 6351.5 0.079062 0.029271 -0.000175
6552 521.6 9482 48051 104040.5 17167 6893.5 0.068398 0.015378 0.013555
4695 10804 8852 45624 110111.5 21397.5 7270.5 0.051654 0.010691 0.007704
ROA ROE Debt_to_Equity
Debt_to_Assets
Asset_Turnover
Interest_Coverage
WC_to_Revenue
WC_to_Debt
-23.19399 0.276379 -2.840989 -0.111415 -1.218235
0.064045 0.609005 0.394687 0.071267 3.573006 14.26899 -0.033337 -1.373904
-0.000775 -0.004834 0.455984 0.065427 4.423782 11.30028 -0.022578 -1.39994
0.056238 0.340828 0.361301 0.067053 4.148865 7.962956 -0.01552 -0.939419
0.029942 0.154083 0.321364 0.065072 3.886479 4.85741 -0.007599 -0.438866
Metric PSO_5Y_Avg
Wafi_5Y_Avg
Gross_Mar 0.034426 0.066438
Operating 0.025312 0.01383
Net_Margi 0.011526 0.001963
ROE 0.209844 0.274771
ROA 0.058266 0.037362
Debt_to_Eq1.173971 -4.332131
Interest_C 8.091445 7.10973
Asset_Turn 3.44377 4.008033
WC_to_Re 0.058182 -0.03809
WC_to_De 0.702765 -1.074073
Metric PSO_5Y_Avg
Wafi_5Y_Avg Weight PSO_normWafi_norm
PSO_weighted
Wafi_weighted
Gross_Mar 0.034426 0.066438 0.1 0 1 0 0.1
Operating 0.025312 0.01383 0.15 1 0 0.15 0
Net_Margi 0.011526 0.001963 0.1 1 0 0.1 0
ROE 0.209844 0.274771 0.2 0 1 0 0.2
ROA 0.058266 0.037362 0.1 1 0 0.1 0
Debt_to_Eq1.173971 -4.332131 0.15 0 1 0 0.15
Interest_C 8.091445 7.10973 0.1 1 0 0.1 0
Asset_Turn 3.44377 4.008033 0.05 0 1 0 0.05
WC_to_Re 0.058182 -0.03809 0.03 1 0 0.03 0
WC_to_De 0.702765 -1.074073 0.02 1 0 0.02 0
Company
Weighted_Score
PSO 0.5
Wafi Energ 0.5
RatioFormula (Excel)Notes
Gross Marg 0 Measures % of revenue left after COGS.
Operating 0 Core operating profitability before interest & taxes.
Net Margin 0 Bottom-line profitability after all expenses.
ROA 0 How efficiently assets generate profit.
ROE 0 Return generated on owners’ equity.
Debt to Equ 0 Capital structure risk; lower is better (for the same returns).
Debt to As 0 Debt relative to asset base; lower is safer.
Asset Turn 0 Sales per unit of assets.
Interest C 0 Ability to service debt from operating earnings (>1x preferred).
WC to Rev 0 Liquidity buffer relative to sales.
WC to Deb 0 Liquidity buffer relative to debt; >0 suggests cushion.

You might also like