Ratio Analysis (auto Calculation)
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Ratio Analysis (auto Calculation) as PDF for free.
More details
- Words: 533
- Pages: 8
Annexture Ratio
Formula Current Ratio =
Current Asset Current Liabilities
Liquid Ratio =
Current Asset -Debtors Current Liabilities
Most Liquid Ratio =
Cash + Bank+Markeetable Securitiets Current Liabilities
Most Liquid Ratio =
C A -Inventory-Debtors-Prepaid Expenses Current Liabilities
receiveable turnover =
Net credit sales Closing A/R
Debitor Turnover =
360 A/R Ratio
A/P Ratio =
Net Purchases Closing A/P
=
=
=
=
=
=
=
2007 1,240,430 = 542,025 2007 1,234,419 = 542,025 2007 76,827 = 542,025 2007 1113498 = 542025 2007 2,619,960 = 2,138 2007 360 = 1225.43 2007 331,246.0 = 23,120 2007
2.29
2.28
0.14
2.05
1225.43
0.29
14.33
Turnover or A/P Ratio per Day =
360 A/P Ratio
=
Inventory Turn Over =
CGS Closing Inventory
=
Time Period of Stock Turn Over =
360 inventory Turnover Ratio
=
Asset Turnover Ratio =
Total Net Sales Fixed Assets
=
Asset Turnover Ratio =
Total Net Sales Current Asset
=
Debt Ratio =
Debt Ratio =
TEAR Ratio =
TEAR Ratio =
Total Liabilities Total Assets To total assets Total Debt Total Assets
Operating Profit Interest Expense times invest earned ratio EBIT Financial changes
=
=
=
=
360 = 14.33 2007 2,242,296.00 = 48,858 2007 360 = 45.89 2007 #REF! = #REF! 2007 #REF! = 1,240,430 2007 1,296,758 = 3,533,350 2007 6,011 = 3,533,350 2007 322,558 = 75,531 2007 247,027 = 75,531
25.13
45.89
7.84
#REF!
#REF!
0.37
0
4.27
3.27
Gross Profit Ratio =
Operating Profit Ratio =
Gross Profit Sales
Operating Profit x 100 Sales
Return on Assets Ratio =
NPAT Total Assets
Return on Assets Ratio =
NPAT Total Assets - CL
Return on Share Holder Equity =
NPAT Common Stock Value (Rs)
Return on Owed Funds =
Total Net Sales Current Asset
Return on Capital Employed =
EBIT/ Operating Profit Total Assets
Earning Per Sahre =
NPAT - (Dividend to Preffered Stock # of Common Shares
=
=
=
=
=
=
=
=
2007 377,664.00 = 2,619,960 2007 322,558 = 2,619,960 2007 184,158 = 3,533,350 2007 184,158 = 2,991,325 2007 184,158 = 2,236,592 2007 2,619,960 = 1,240,430 2007 247,027 = 3,533,350 2007 184,158,000 = 95580008 2007
0.14
0.12
0.05
0.06
0.08
2.11
0.07
1.93
Price Earnig Ratio =
MPS EPS
Payout Ratio/ Dividend payout =
Cash Dividend NPAT
=
10 = 1.93
5.19
2007
Capital Gearing Ratio =
Owed Capital Total Capital
=
=
= 2007 695,416 = 2,932,008
#DIV/0!
0.24
2008 1,719,948 1,597,703 2008 1,713,116 1,597,703 2008 66,944 1,597,703 2008 1455407 1597703 2008 3,013,752 71,611 2008 360 42.09 2008 479,473.0 680,294 2008
=
1.08
=
1.07
=
0.04
=
0.91
=
42.09
=
8.55
=
0.7
360 0.7 2008 2,834,336.00 69,638.0 2008 360 40.7 2008 #REF! #REF! 2008 23,307,442 1,719,948 2008 2,224,167 4,382,273 2008 6,832 4,382,273 2008 25,078 81,576 2008 (56,498) 81,576
=
510.78
=
40.7
=
8.84
=
#REF!
=
13.55
=
0.51
=
0
=
0.31
=
-0.69
2008 179,416.00 3,013,752 2008 25,078 3,013,752 2008 10,354 4,382,273 2008 10,354 2,784,570 2008 10,354 2,158,106 2008 3,013,752 17,948 2008 (56,498) 4,382,273 2008 10354000 95580008 2008
=
0.06
=
0.01
=
0
=
0
=
0
=
167.92
=
-0.01
=
0.11
10 0.11
=
92.31
=
#DIV/0!
=
0.32
2008
2008 1,013,787 3,171,893
Formula Current Ratio =
Current Asset Current Liabilities
Liquid Ratio =
Current Asset -Debtors Current Liabilities
Most Liquid Ratio =
Cash + Bank+Markeetable Securitiets Current Liabilities
Most Liquid Ratio =
C A -Inventory-Debtors-Prepaid Expenses Current Liabilities
receiveable turnover =
Net credit sales Closing A/R
Debitor Turnover =
360 A/R Ratio
A/P Ratio =
Net Purchases Closing A/P
=
=
=
=
=
=
=
2007 1,240,430 = 542,025 2007 1,234,419 = 542,025 2007 76,827 = 542,025 2007 1113498 = 542025 2007 2,619,960 = 2,138 2007 360 = 1225.43 2007 331,246.0 = 23,120 2007
2.29
2.28
0.14
2.05
1225.43
0.29
14.33
Turnover or A/P Ratio per Day =
360 A/P Ratio
=
Inventory Turn Over =
CGS Closing Inventory
=
Time Period of Stock Turn Over =
360 inventory Turnover Ratio
=
Asset Turnover Ratio =
Total Net Sales Fixed Assets
=
Asset Turnover Ratio =
Total Net Sales Current Asset
=
Debt Ratio =
Debt Ratio =
TEAR Ratio =
TEAR Ratio =
Total Liabilities Total Assets To total assets Total Debt Total Assets
Operating Profit Interest Expense times invest earned ratio EBIT Financial changes
=
=
=
=
360 = 14.33 2007 2,242,296.00 = 48,858 2007 360 = 45.89 2007 #REF! = #REF! 2007 #REF! = 1,240,430 2007 1,296,758 = 3,533,350 2007 6,011 = 3,533,350 2007 322,558 = 75,531 2007 247,027 = 75,531
25.13
45.89
7.84
#REF!
#REF!
0.37
0
4.27
3.27
Gross Profit Ratio =
Operating Profit Ratio =
Gross Profit Sales
Operating Profit x 100 Sales
Return on Assets Ratio =
NPAT Total Assets
Return on Assets Ratio =
NPAT Total Assets - CL
Return on Share Holder Equity =
NPAT Common Stock Value (Rs)
Return on Owed Funds =
Total Net Sales Current Asset
Return on Capital Employed =
EBIT/ Operating Profit Total Assets
Earning Per Sahre =
NPAT - (Dividend to Preffered Stock # of Common Shares
=
=
=
=
=
=
=
=
2007 377,664.00 = 2,619,960 2007 322,558 = 2,619,960 2007 184,158 = 3,533,350 2007 184,158 = 2,991,325 2007 184,158 = 2,236,592 2007 2,619,960 = 1,240,430 2007 247,027 = 3,533,350 2007 184,158,000 = 95580008 2007
0.14
0.12
0.05
0.06
0.08
2.11
0.07
1.93
Price Earnig Ratio =
MPS EPS
Payout Ratio/ Dividend payout =
Cash Dividend NPAT
=
10 = 1.93
5.19
2007
Capital Gearing Ratio =
Owed Capital Total Capital
=
=
= 2007 695,416 = 2,932,008
#DIV/0!
0.24
2008 1,719,948 1,597,703 2008 1,713,116 1,597,703 2008 66,944 1,597,703 2008 1455407 1597703 2008 3,013,752 71,611 2008 360 42.09 2008 479,473.0 680,294 2008
=
1.08
=
1.07
=
0.04
=
0.91
=
42.09
=
8.55
=
0.7
360 0.7 2008 2,834,336.00 69,638.0 2008 360 40.7 2008 #REF! #REF! 2008 23,307,442 1,719,948 2008 2,224,167 4,382,273 2008 6,832 4,382,273 2008 25,078 81,576 2008 (56,498) 81,576
=
510.78
=
40.7
=
8.84
=
#REF!
=
13.55
=
0.51
=
0
=
0.31
=
-0.69
2008 179,416.00 3,013,752 2008 25,078 3,013,752 2008 10,354 4,382,273 2008 10,354 2,784,570 2008 10,354 2,158,106 2008 3,013,752 17,948 2008 (56,498) 4,382,273 2008 10354000 95580008 2008
=
0.06
=
0.01
=
0
=
0
=
0
=
167.92
=
-0.01
=
0.11
10 0.11
=
92.31
=
#DIV/0!
=
0.32
2008
2008 1,013,787 3,171,893
Related Documents
Ratio Analysis (auto Calculation)
May 2020 0
Ratio Analysis
June 2020 21
Ratio Analysis
November 2019 42
Ratio Analysis
June 2020 29
Ratio Analysis
June 2020 23