inflation&purchasing power

profilenikhilreddy
Financialratioxxl2.xlsx
Home>Business & Finance homework help>inflation&purchasing power

Sheet1

2018 2017 2016 2015
Revnue 113000 102000 92300 8500
Cost of revenue 46500 46000 39800
Gross profit 66500 56000 52500
Sales,general & ad…. 40400 35300 35500
Depriciation 3300 3400 3650
Provision 1030 870 410
Other opinc/Exp 0 0 0
Operating Income 21770 16430 12940
Intrest expense 1100 920 350
Other Income /Exp 2400 1500 -400
Profit before tax 20470 15850 12190
Income tax and other tax 8110 6140 5120
Net income from com…. 16060 12250 9260
Extraordinary & disco.. 0 0 0
Shares of associates 0 0 0
Minorty intrest 0 0 0
Net income 16060 12250 9260
Ni preferred Di… 16060 12250 9260
Basic share 95 95 95
Diluted shares 95 95 95
EPS Basic 166 127 95
Market Price per share 1100 780 600
Book Value 380 350 340
EPS Dialuted 166 127 95
Balance sheet
ASSETS 2018 2017 2016
NON CURRENT ASSETS
prooperty , Plant and Epquiment 25000 27500 27800.5
Capital work in progress 1000 930.5 1882.5
FINANCIAL ASSETS
Investment 7300 5850.5 4745
Loans 400 462.5 640
Other Non current assets 715 830.5 710
34415 35574 35778
CURRENT ASSETS
Inventories 9600.5 9020.5 9420 8200
FINANCIAL ASSETS
Investments 19250.5 13935 12813
Trade receivable 1250 888 979.5 784.2
Cash and cash equalents 15990 14475.5 8695
Bank balance and other then cash and cash equalents 113 95.5 105.5
Loans 180 277 166.5
Other financial accest 525 430 320
Current Tax Assets 190 65.5 30.5
Other Current Assets 220 170 313.5
Total current assts 47319 39357 32843.5
ToTal Assets 81734 74931 68621.5
EQUITY AND LIABILITIES
EQUITY
Equity Shares Capital 965 965 965
Other equity 34500 33550 31840
35465 34515 32805
LIABILITIES
NON_CURRENT LIABILITIES
Financial Liabilities
Borrowings 350 350 330.5
Provisions 25650 23916 19724.5
Deferred Tax Liabilities (NET) 590 1220 1561.5
Other NON-Current liabilities 6 6.5 7.3
26596 25492.5 21623.8
CURRENT LIABILITIES
FINEANCIAL LIABILITIES
Trade Payables 12500.5 9948.5 8000.5 7300.5 LIQUID RATIO
Other Financial Liabilities 3160.5 3140.5 3115.8
Provision 1573.5 875 535
Other Current Liabilities 1410.5 1064 2020
Total current liabilities 18645 15028 13671.3
Total Liabilities 45241 40520.5 35295.1
TOTAL EQUITY AND LIABIITIES 81734 74931 68621.5 ACTIVITY RATIO
LIQUID RATIO
PARTICULERS 2018 2017 2016
Current ratio 2.53 2.61 2.4
Quick Ratio 2.02 2.01 1.71
Acid ratio 2.3 2.3 1.92
ACTIVITY RATIO
PARTICULERS 2018 2017 2016
Total Assets T.O Ratio 1.38 1.36 1.34
Fixed assets T.O Ratio 3.28 2.86 2.57
Capital T.O Ratio 3.09 2.96 2.76
Current Assets T.O Ratio 6.06 6.78 6.75
Inventory T.O Ratio 1.24 1.24 1.12
Debtors T.O Ratio 90.68 114.76 94.43
Payable T.O Ratio 1.09 1.33 1.32
Solvency Ratio SOLVENCY RATIO
PARTICULERS 2018 2017 2016
Equity ratio 0.56 0.58 0.60
Debt ratio 0.42 0.43 0.39
Debt equity ratio 0.75 0.74 0.66
Debt to total assets 0.33 0.34 0.32
Interest coverage ratio 19.79 17.86 36.97
Profitability ratio
PARTICULERS 2018 2017 2016
Gross profit ratio 58.85 54.90 56.88
Net profit ratio 14.21 12.01 10.03
Operating profit ratio 19.27 16.11 14.02
Cost of Goods sold ratio 41.15 45.10 43.12
Financial expenses ratio 0.97 0.90 0.38
Return on assets 19.65 16.35 13.49
Return on equity 27.20 21.99 17.49 Profitability ratio
DU point model
Equity Multiplier 2.3 2.2 2.1
Return on equity 45.20 35.46 28.12
Earning per share 169 129 97
Valuation ratio
PARTICULERS 2018 2017 2016
PE ratio 11.58 8.21 6.32
Market value to Book Value 2.89 2.23 1.76
Valuation ratio
2018 Current ratio Quick Ratio Acid ratio 2.5299999999999998 2.02 2.2999999999999998 2017 Current ratio Quick Ratio Acid ratio 2.61 2.0099999999999998 2.2999999999999998 2016 Current ratio Quick Ratio Acid ratio 2.4 1.71 1.92 2018 Total Assets T.O Ratio Fixed assets T.O Ratio Capital T.O Ratio Current Assets T.O Ratio Inventory T.O Ratio Debtors T.O Ratio Payable T.O Ratio 1.38 3.28 3.09 6.06 1.24 90.68 1.0900000000000001 2017 Total Assets T.O Ratio Fixed assets T.O Ratio Capital T.O Ratio Current Assets T.O Ratio Inventory T.O Ratio Debtors T.O Ratio Payable T.O Ratio 1.36 2.86 2.96 6.78 1.24 114.76 1.33 2016 Total Assets T.O Ratio Fixed assets T.O Ratio Capital T.O Ratio Current Assets T.O Ratio Inventory T.O Ratio Debtors T.O Ratio Payable T.O Ratio 1.34 2.57 2.76 6.75 1.1200000000000001 94.43 1.32 2018 Equity ratio Debt ratio Debt equity ratio Debt to total assets Interest coverage ratio 0.56214237030227143 0.4215631885114679 0.7499224587621599 0.33 19.790909090909089 2017 Equity ratio Debt ratio Debt equity ratio Debt to total assets Interest coverage ratio 0.57618149341435321 0.42556299350616833 0.73859191655801826 0.34 17.858695652173914 2016 Equity ratio Debt ratio Debt equity ratio Debt to total assets Interest coverage ratio 0.59699509737908141 0.39351631113262553 0.65916171315348271 0.32 36.971428571428568 2018 Gross profit ratio Net profit ratio Operating profit ratio Cost of Goods sold ratio Financial expenses ratio Return on assets Return on equity DU point model Equity Multiplier Return on equity Earning per share 58.849557522123895 14.212389380530974 19.265486725663717 41.150442477876105 0.97345132743362828 19.64910563535371 27.19967030702658 2.3046383758635276 45.20109681113999 169.05263157894737 2017 Gross profit ratio Net profit ratio Operating profit ratio Cost of Goods sold ratio Financial expenses ratio Return on assets Return on equity DU point model Equity Multiplier Return on equity Earning per share 54.901960784313729 12.009803921568627 16.1078431372549 45.098039215686278 0.90196078431372551 16.348373837263615 21.985543294993573 2.1709691438504999 35.459162682891503 128.94736842105263 2016 Gross profit ratio Net profit ratio Operating profit ratio Cost of Goods sold ratio Financial expenses ratio Return on assets Return on equity DU point model Equity Multiplier Return on equity Earning per share 56.879739978331521 10.032502708559047 14.019501625135428 43.120260021668471 0.37919826652221017 13.494313006856451 17.488562371019579 2.0918000304831579 28.12122589192548 97.473684210526315 2018 PE ratio Market value to Book Value 11.578947368421053 2.8947368421052633 2017 PE ratio Market value to Book Value 8.2105263157894743 2.2285714285714286 2016 PE ratio Market value to Book Value 6.3157894736842106 1.7647058823529411 2018 Current ratio Quick Ratio Acid ratio 2.5299999999999998 2.02 2.2999999999999998 2017 Current ratio Quick Ratio Acid ratio 2.61 2.0099999999999998 2.2999999999999998 2016 Current ratio Quick Ratio Acid ratio 2.4 1.71 1.92 2018 Total Assets T.O Ratio Fixed assets T.O Ratio Capital T.O Ratio Current Assets T.O Ratio Inventory T.O Ratio Debtors T.O Ratio Payable T.O Ratio 1.38 3.28 3.09 6.06 1.24 90.68 1.0900000000000001 2017 Total Assets T.O Ratio Fixed assets T.O Ratio Capital T.O Ratio Current Assets T.O Ratio Inventory T.O Ratio Debtors T.O Ratio Payable T.O Ratio 1.36 2.86 2.96 6.78 1.24 114.76 1.33 2016 Total Assets T.O Ratio Fixed assets T.O Ratio Capital T.O Ratio Current Assets T.O Ratio Inventory T.O Ratio Debtors T.O Ratio Payable T.O Ratio 1.34 2.57 2.76 6.75 1.1200000000000001 94.43 1.32 2018 Equity ratio Debt ratio Debt equity ratio Debt to total assets Interest coverage ratio 0.56214237030227143 0.4215631885114679 0.7499224587621599 0.33 19.790909090909089 2017 Equity ratio Debt ratio Debt equity ratio Debt to total assets Interest coverage ratio 0.57618149341435321 0.42556299350616833 0.73859191655801826 0.34 17.858695652173914 2016 Equity ratio Debt ratio Debt equity ratio Debt to total assets Interest coverage ratio 0.59699509737908141 0.39351631113262553 0.65916171315348271 0.32 36.971428571428568 2018 Gross profit ratio Net profit ratio Operating profit ratio Cost of Goods sold ratio Financial expenses ratio Return on assets Return on equity DU point model Equity Multiplier Return on equity Earning per share 58.849557522123895 14.212389380530974 19.265486725663717 41.150442477876105 0.97345132743362828 19.64910563535371 27.19967030702658 2.3046383758635276 45.20109681113999 169.05263157894737 2017 Gross profit ratio Net profit ratio Operating profit ratio Cost of Goods sold ratio Financial expenses ratio Return on assets Return on equity DU point model Equity Multiplier Return on equity Earning per share 54.901960784313729 12.009803921568627 16.1078431372549 45.098039215686278 0.90196078431372551 16.348373837263615 21.985543294993573 2.1709691438504999 35.459162682891503 128.94736842105263 2016 Gross profit ratio Net profit ratio Operating profit ratio Cost of Goods sold ratio Financial expenses ratio Return on assets Return on equity DU point model Equity Multiplier Return on equity Earning per share 56.879739978331521 10.032502708559047 14.019501625135428 43.120260021668471 0.37919826652221017 13.494313006856451 17.488562371019579 2.0918000304831579 28.12122589192548 97.473684210526315 2018 PE ratio Market value to Book Value 11.578947368421053 2.8947368421052633 2017 PE ratio Market value to Book Value 8.2105263157894743 2.2285714285714286 2016 PE ratio Market value to Book Value 6.3157894736842106 1.7647058823529411 2018 Current ratio Quick Ratio Acid ratio 2.5299999999999998 2.02 2.2999999999999998 2017 Current ratio Quick Ratio Acid ratio 2.61 2.0099999999999998 2.2999999999999998 2016 Current ratio Quick Ratio Acid ratio 2.4 1.71 1.92 2018 Total Assets T.O Ratio Fixed assets T.O Ratio Capital T.O Ratio Current Assets T.O Ratio Inventory T.O Ratio Debtors T.O Ratio Payable T.O Ratio 1.38 3.28 3.09 6.06 1.24 90.68 1.0900000000000001 2017 Total Assets T.O Ratio Fixed assets T.O Ratio Capital T.O Ratio Current Assets T.O Ratio Inventory T.O Ratio Debtors T.O Ratio Payable T.O Ratio 1.36 2.86 2.96 6.78 1.24 114.76 1.33 2016 Total Assets T.O Ratio Fixed assets T.O Ratio Capital T.O Ratio Current Assets T.O Ratio Inventory T.O Ratio Debtors T.O Ratio Payable T.O Ratio 1.34 2.57 2.76 6.75 1.1200000000000001 94.43 1.32 2018 Equity ratio Debt ratio Debt equity ratio Debt to total assets Interest coverage ratio 0.56214237030227143 0.4215631885114679 0.7499224587621599 0.33 19.790909090909089 2017 Equity ratio Debt ratio Debt equity ratio Debt to total assets Interest coverage ratio 0.57618149341435321 0.42556299350616833 0.73859191655801826 0.34 17.858695652173914 2016 Equity ratio Debt ratio Debt equity ratio Debt to total assets Interest coverage ratio 0.59699509737908141 0.39351631113262553 0.65916171315348271 0.32 36.971428571428568 2018 Gross profit ratio Net profit ratio Operating profit ratio Cost of Goods sold ratio Financial expenses ratio Return on assets Return on equity DU point model Equity Multiplier Return on equity Earning per share 58.849557522123895 14.212389380530974 19.265486725663717 41.150442477876105 0.97345132743362828 19.64910563535371 27.19967030702658 2.3046383758635276 45.20109681113999 169.05263157894737 2017 Gross profit ratio Net profit ratio Operating profit ratio Cost of Goods sold ratio Financial expenses ratio Return on assets Return on equity DU point model Equity Multiplier Return on equity Earning per share 54.901960784313729 12.009803921568627 16.1078431372549 45.098039215686278 0.90196078431372551 16.348373837263615 21.985543294993573 2.1709691438504999 35.459162682891503 128.94736842105263 2016 Gross profit ratio Net profit ratio Operating profit ratio Cost of Goods sold ratio Financial expenses ratio Return on assets Return on equity DU point model Equity Multiplier Return on equity Earning per share 56.879739978331521 10.032502708559047 14.019501625135428 43.120260021668471 0.37919826652221017 13.494313006856451 17.488562371019579 2.0918000304831579 28.12122589192548 97.473684210526315 2018 PE ratio Market value to Book Value 11.578947368421053 2.8947368421052633 2017 PE ratio Market value to Book Value 8.2105263157894743 2.2285714285714286 2016 PE ratio Market value to Book Value 6.3157894736842106 1.7647058823529411 2018 Current ratio Quick Ratio Acid ratio 2.5299999999999998 2.02 2.2999999999999998 2017 Current ratio Quick Ratio Acid ratio 2.61 2.0099999999999998 2.2999999999999998 2016 Current ratio Quick Ratio Acid ratio 2.4 1.71 1.92 2018 Total Assets T.O Ratio Fixed assets T.O Ratio Capital T.O Ratio Current Assets T.O Ratio Inventory T.O Ratio Debtors T.O Ratio Payable T.O Ratio 1.38 3.28 3.09 6.06 1.24 90.68 1.0900000000000001 2017 Total Assets T.O Ratio Fixed assets T.O Ratio Capital T.O Ratio Current Assets T.O Ratio Inventory T.O Ratio Debtors T.O Ratio Payable T.O Ratio 1.36 2.86 2.96 6.78 1.24 114.76 1.33 2016 Total Assets T.O Ratio Fixed assets T.O Ratio Capital T.O Ratio Current Assets T.O Ratio Inventory T.O Ratio Debtors T.O Ratio Payable T.O Ratio 1.34 2.57 2.76 6.75 1.1200000000000001 94.43 1.32 2018 Equity ratio Debt ratio Debt equity ratio Debt to total assets Interest coverage ratio 0.56214237030227143 0.4215631885114679 0.7499224587621599 0.33 19.790909090909089 2017 Equity ratio Debt ratio Debt equity ratio Debt to total assets Interest coverage ratio 0.57618149341435321 0.42556299350616833 0.73859191655801826 0.34 17.858695652173914 2016 Equity ratio Debt ratio Debt equity ratio Debt to total assets Interest coverage ratio 0.59699509737908141 0.39351631113262553 0.65916171315348271 0.32 36.971428571428568 2018 Gross profit ratio Net profit ratio Operating profit ratio Cost of Goods sold ratio Financial expenses ratio Return on assets Return on equity DU point model Equity Multiplier Return on equity Earning per share 58.849557522123895 14.212389380530974 19.265486725663717 41.150442477876105 0.97345132743362828 19.64910563535371 27.19967030702658 2.3046383758635276 45.20109681113999 169.05263157894737 2017 Gross profit ratio Net profit ratio Operating profit ratio Cost of Goods sold ratio Financial expenses ratio Return on assets Return on equity DU point model Equity Multiplier Return on equity Earning per share 54.901960784313729 12.009803921568627 16.1078431372549 45.098039215686278 0.90196078431372551 16.348373837263615 21.985543294993573 2.1709691438504999 35.459162682891503 128.94736842105263 2016 Gross profit ratio Net profit ratio Operating profit ratio Cost of Goods sold ratio Financial expenses ratio Return on assets Return on equity DU point model Equity Multiplier Return on equity Earning per share 56.879739978331521 10.032502708559047 14.019501625135428 43.120260021668471 0.37919826652221017 13.494313006856451 17.488562371019579 2.0918000304831579 28.12122589192548 97.473684210526315 2018 PE ratio Market value to Book Value 11.578947368421053 2.8947368421052633 2017 PE ratio Market value to Book Value 8.2105263157894743 2.2285714285714286 2016 PE ratio Market value to Book Value 6.3157894736842106 1.7647058823529411 2018 Current ratio Quick Ratio Acid ratio 2.5299999999999998 2.02 2.2999999999999998 2017 Current ratio Quick Ratio Acid ratio 2.61 2.0099999999999998 2.2999999999999998 2016 Current ratio Quick Ratio Acid ratio 2.4 1.71 1.92 2018 Total Assets T.O Ratio Fixed assets T.O Ratio Capital T.O Ratio Current Assets T.O Ratio Inventory T.O Ratio Debtors T.O Ratio Payable T.O Ratio 1.38 3.28 3.09 6.06 1.24 90.68 1.0900000000000001 2017 Total Assets T.O Ratio Fixed assets T.O Ratio Capital T.O Ratio Current Assets T.O Ratio Inventory T.O Ratio Debtors T.O Ratio Payable T.O Ratio 1.36 2.86 2.96 6.78 1.24 114.76 1.33 2016 Total Assets T.O Ratio Fixed assets T.O Ratio Capital T.O Ratio Current Assets T.O Ratio Inventory T.O Ratio Debtors T.O Ratio Payable T.O Ratio 1.34 2.57 2.76 6.75 1.1200000000000001 94.43 1.32 2018 Equity ratio Debt ratio Debt equity ratio Debt to total assets Interest coverage ratio 0.56214237030227143 0.4215631885114679 0.7499224587621599 0.33 19.790909090909089 2017 Equity ratio Debt ratio Debt equity ratio Debt to total assets Interest coverage ratio 0.57618149341435321 0.42556299350616833 0.73859191655801826 0.34 17.858695652173914 2016 Equity ratio Debt ratio Debt equity ratio Debt to total assets Interest coverage ratio 0.59699509737908141 0.39351631113262553 0.65916171315348271 0.32 36.971428571428568 2018 Gross profit ratio Net profit ratio Operating profit ratio Cost of Goods sold ratio Financial expenses ratio Return on assets Return on equity DU point model Equity Multiplier Return on equity Earning per share 58.849557522123895 14.212389380530974 19.265486725663717 41.150442477876105 0.97345132743362828 19.64910563535371 27.19967030702658 2.3046383758635276 45.20109681113999 169.05263157894737 2017 Gross profit ratio Net profit ratio Operating profit ratio Cost of Goods sold ratio Financial expenses ratio Return on assets Return on equity DU point model Equity Multiplier Return on equity Earning per share 54.901960784313729 12.009803921568627 16.1078431372549 45.098039215686278 0.90196078431372551 16.348373837263615 21.985543294993573 2.1709691438504999 35.459162682891503 128.94736842105263 2016 Gross profit ratio Net profit ratio Operating profit ratio Cost of Goods sold ratio Financial expenses ratio Return on assets Return on equity DU point model Equity Multiplier Return on equity Earning per share 56.879739978331521 10.032502708559047 14.019501625135428 43.120260021668471 0.37919826652221017 13.494313006856451 17.488562371019579 2.0918000304831579 28.12122589192548 97.473684210526315 2018 PE ratio Market value to Book Value 11.578947368421053 2.8947368421052633 2017 PE ratio Market value to Book Value 8.2105263157894743 2.2285714285714286 2016 PE ratio Market value to Book Value 6.3157894736842106 1.7647058823529411

Sheet2

Sheet3