gaurav das (15hs61019)

20
Balance Sheet of Hero Motocorp <--------------------------------- in Rs. Cr. ---------------------- Horizontal Analysis Mar '15 Mar '14 Mar '13 Mar '12 Mar '11 2014-2015 2013-2014 2012-2013 2011-2012 12 mths 12 mths 12 mths 12 mths 12 mths Rupee Change (Cr.) % Change Rupee Change (Cr.) % Change Rupee Change (Cr.) % Change Rupee Change (Cr.) % Change Sources Of Funds Total Share Capital 39.94 39.94 39.94 39.94 39.94 0 0 0 0 0 0 0 0 Equity Share Capital 39.94 39.94 39.94 39.94 39.94 0 0 0 0 0 0 0 0 Share Application Money 0 0 0 0 0 0 0 0 0 0 0 0 0 Preference Share Capital 0 0 0 0 0 0 0 0 0 0 0 0 0 Reserves 6,501.39 5,559.93 4,966.30 4,249.89 2,916.12 941.46 16.932946998 593.63 11.953164328 716.41 16.8571422 1333.77 45.73782972 Networth 6,541.33 5,599.87 5,006.24 4,289.83 2,956.06 941.46 16.812175997 593.63 11.857801464 716.41 16.7001956 1333.77 45.11985548 Secured Loans 0 0 302.16 1,011.39 1,471.04 0 0 -302.16 -100 -709.23 -70.124284 -459.65 -31.246601 Unsecured Loans 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Debt 0 0 302.16 1,011.39 1,471.04 0 0 -302.16 -100 -709.23 -70.124284 -459.65 -31.246601 Total Liabilities 6,541.33 5,599.87 5,308.40 5,301.22 4,427.10 941.46 16.812175997 291.47 5.4907316706 7.17999999999938 0.13544052 874.12 19.7447539 0 0 0 0 0 0 0 Mar '15 Mar '14 Mar '13 Mar '12 Mar '11 2014-2015 2013-2014 2012-2013 2011-2012 12 mths 12 mths 12 mths 12 mths 12 mths Rupee Change (Cr.) % Change Rupee Change (Cr.) % Change Rupee Change (Cr.) % Change Rupee Change (Cr.) % Change Application Of Funds Gross Block 4,697.98 3,761.52 4,427.29 4,980.69 5,122.32 936.46 24.89578681 -665.77 -15.03786741 -553.4 -11.11091 -141.63 -2.76495807 Less: Revaluation Reserves 0 0 0 0 0 0 0 0 0 0 0 0 0 Less: Accum. Depreciation 1,785.29 1,518.27 1,356.31 1,195.18 1,042.04 267.02 17.587122185 161.96 11.941222877 161.13 13.4816513 153.14 14.69617289 Net Block 2,912.69 2,243.25 3,070.98 3,785.51 4,080.28 669.44 29.842416137 -827.73 -26.95328527 -714.53 -18.875396 -294.77 -7.22425912 Capital Work in Progress 712.55 854.11 62.09 38.84 49.96 -141.56 -16.57397759 792.02 1275.5999356 23.25 59.8609681 -11.12 -22.2578062 Investments 3,154.11 4,088.77 3,623.83 3,964.26 5,128.75 -934.66 -22.85919726 464.94 12.830072051 -340.43 -8.5874791 -1164.49 -22.7051426 Inventories 815.49 669.55 636.76 675.57 524.93 145.94 21.796729146 32.79 5.1495068786 -38.8100000000001 -5.7447785 150.64 28.69715962 Sundry Debtors 1,389.59 920.58 665 272.31 130.59 469.01 50.947228921 255.58 38.433082707 392.69 144.20697 141.72 108.5228578 Cash and Bank Balance 159.25 117.5 181.04 76.82 71.52 41.75 35.531914894 -63.54 -35.09721608 104.22 135.667795 5.3 7.410514541 Total Current Assets 2,364.33 1,707.63 1,482.80 1,024.70 727.04 656.7 38.456808559 224.83 15.162530348 458.1 44.7057675 297.66 40.94135123 Loans and Advances 1,378.02 1,203.54 1,401.95 1,075.61 740.23 174.48 14.497233162 -198.41 -14.15243054 326.34 30.3399931 335.38 45.30753955 Fixed Deposits 0 0 0 0 0 0 0 0 0 0 0 0 0 Total CA, Loans & Advances 3,742.35 2,911.17 2,884.75 2,100.31 1,467.27 831.18 28.551407166 26.4200000000001 0.9158505936 784.44 37.3487723 633.04 43.14407028 Deferred Credit 0 0 0 0 0 0 0 0 0 0 0 0 0 Current Liabilities 3,180.69 2,903.12 2,893.39 3,497.63 5,218.09 277.57 9.5610928932 9.73000000000002 0.3362837364 -604.24 -17.275698 -1720.46 -32.971068 Provisions 799.68 1,594.31 1,439.86 1,090.07 1,081.07 -794.63 -49.84162428 154.45 10.726737322 349.79 32.0887649 9 0.832508533 Total CL & Provisions 3,980.37 4,497.43 4,333.25 4,587.70 6,299.16 -517.06 -11.49678817 164.18 3.7888420931 -254.45 -5.5463522 -1711.46 -27.1696544 Net Current Assets -238.02 -1,586.26 -1,448.50 -2,487.39 -4,831.89 1348.24 -84.99489365 -137.76 9.5105281326 1038.89 -41.766269 2344.5 -48.521386 Miscellaneous Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Assets 6,541.33 5,599.87 5,308.40 5,301.22 4,427.10 941.46 16.812175997 291.47 5.4907316706 7.17999999999938 0.13544052 874.12 19.7447539 0 0 0 0 0 0 0 0 Contingent Liabilities 816.42 487.63 502 252.62 131.9 328.79 67.426122265 -14.37 -2.862549801 249.38 98.7174412 120.72 91.52388173 Book Value (Rs) 327.58 280.43 250.7 214.83 148.03 47.15 16.813465036 29.73 11.858795373 35.87 16.6969231 66.8 45.12598798

Upload: shivangi-gupta

Post on 24-Jan-2016

215 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Gaurav Das (15HS61019)

Balance Sheet of Hero Motocorp <--------------------------------- in Rs. Cr. ------------------------------------> Horizontal Analysis

Mar '15 Mar '14 Mar '13 Mar '12 Mar '11 2014-2015 2013-2014 2012-2013 2011-201212 mths 12 mths 12 mths 12 mths 12 mths Rupee Change (Cr.) % Change Rupee Change (Cr.) % Change Rupee Change (Cr.) % Change Rupee Change (Cr.) % Change

Sources Of FundsTotal Share Capital 39.94 39.94 39.94 39.94 39.94 0 0 0 0 0 0 0 0Equity Share Capital 39.94 39.94 39.94 39.94 39.94 0 0 0 0 0 0 0 0Share Application Money 0 0 0 0 0 0 0 0 0 0 0 0 0Preference Share Capital 0 0 0 0 0 0 0 0 0 0 0 0 0Reserves 6,501.39 5,559.93 4,966.30 4,249.89 2,916.12 941.46 16.9329469975 593.63 11.953164328 716.41 16.85714218 1333.77 45.737829719Networth 6,541.33 5,599.87 5,006.24 4,289.83 2,956.06 941.46 16.8121759969 593.63 11.857801464 716.41 16.70019558 1333.77 45.119855483Secured Loans 0 0 302.16 1,011.39 1,471.04 0 0 -302.16 -100 -709.23 -70.1242844 -459.65 -31.24660104Unsecured Loans 0 0 0 0 0 0 0 0 0 0 0 0 0Total Debt 0 0 302.16 1,011.39 1,471.04 0 0 -302.16 -100 -709.23 -70.1242844 -459.65 -31.24660104Total Liabilities 6,541.33 5,599.87 5,308.40 5,301.22 4,427.10 941.46 16.8121759969 291.47 5.4907316706 7.17999999999938 0.135440521 874.12 19.744753902

0 0 0 0 0 0 0Mar '15 Mar '14 Mar '13 Mar '12 Mar '11 2014-2015 2013-2014 2012-2013 2011-201212 mths 12 mths 12 mths 12 mths 12 mths Rupee Change (Cr.) % Change Rupee Change (Cr.) % Change Rupee Change (Cr.) % Change Rupee Change (Cr.) % Change

Application Of FundsGross Block 4,697.98 3,761.52 4,427.29 4,980.69 5,122.32 936.46 24.8957868096 -665.77 -15.037867409 -553.4 -11.11091034 -141.63 -2.764958066Less: Revaluation Reserves 0 0 0 0 0 0 0 0 0 0 0 0 0Less: Accum. Depreciation 1,785.29 1,518.27 1,356.31 1,195.18 1,042.04 267.02 17.5871221851 161.96 11.941222877 161.13 13.4816513 153.14 14.696172892Net Block 2,912.69 2,243.25 3,070.98 3,785.51 4,080.28 669.44 29.8424161373 -827.73 -26.95328527 -714.53 -18.87539592 -294.77 -7.224259119Capital Work in Progress 712.55 854.11 62.09 38.84 49.96 -141.56 -16.573977591 792.02 1275.5999356 23.25 59.86096807 -11.12 -22.25780624Investments 3,154.11 4,088.77 3,623.83 3,964.26 5,128.75 -934.66 -22.859197265 464.94 12.830072051 -340.43 -8.587479126 -1164.49 -22.70514258Inventories 815.49 669.55 636.76 675.57 524.93 145.94 21.7967291464 32.79 5.1495068786 -38.8100000000001 -5.744778483 150.64 28.697159621Sundry Debtors 1,389.59 920.58 665 272.31 130.59 469.01 50.9472289209 255.58 38.433082707 392.69 144.20697 141.72 108.5228578Cash and Bank Balance 159.25 117.5 181.04 76.82 71.52 41.75 35.5319148936 -63.54 -35.097216085 104.22 135.6677948 5.3 7.4105145414Total Current Assets 2,364.33 1,707.63 1,482.80 1,024.70 727.04 656.7 38.4568085592 224.83 15.162530348 458.1 44.70576754 297.66 40.941351232Loans and Advances 1,378.02 1,203.54 1,401.95 1,075.61 740.23 174.48 14.4972331622 -198.41 -14.152430543 326.34 30.33999312 335.38 45.307539549Fixed Deposits 0 0 0 0 0 0 0 0 0 0 0 0 0Total CA, Loans & Advances 3,742.35 2,911.17 2,884.75 2,100.31 1,467.27 831.18 28.5514071662 26.4200000000001 0.9158505936 784.44 37.34877232 633.04 43.14407028Deferred Credit 0 0 0 0 0 0 0 0 0 0 0 0 0Current Liabilities 3,180.69 2,903.12 2,893.39 3,497.63 5,218.09 277.57 9.56109289316 9.73000000000002 0.3362837364 -604.24 -17.27569812 -1720.46 -32.97106796Provisions 799.68 1,594.31 1,439.86 1,090.07 1,081.07 -794.63 -49.841624276 154.45 10.726737322 349.79 32.08876494 9 0.8325085332Total CL & Provisions 3,980.37 4,497.43 4,333.25 4,587.70 6,299.16 -517.06 -11.496788166 164.18 3.7888420931 -254.45 -5.546352203 -1711.46 -27.16965437Net Current Assets -238.02 -1,586.26 -1,448.50 -2,487.39 -4,831.89 1348.24 -84.994893649 -137.76 9.5105281326 1038.89 -41.76626906 2344.5 -48.52138604Miscellaneous Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0Total Assets 6,541.33 5,599.87 5,308.40 5,301.22 4,427.10 941.46 16.8121759969 291.47 5.4907316706 7.17999999999938 0.135440521 874.12 19.744753902

0 0 0 0 0 0 0 0Contingent Liabilities 816.42 487.63 502 252.62 131.9 328.79 67.4261222648 -14.37 -2.8625498008 249.38 98.71744122 120.72 91.523881729Book Value (Rs) 327.58 280.43 250.7 214.83 148.03 47.15 16.8134650358 29.73 11.858795373 35.87 16.69692315 66.8 45.125987975

Page 2: Gaurav Das (15HS61019)

Income Statement of Hero Motocorp <--------------------------------------- in Rs. Cr. ------------------------------------>

Mar '15 Mar '14 Mar '13 Mar '1212 mths 12 mths 12 mths 12 mths

IncomeSales Turnover 29,302.94 27,155.82 23,768.11 23,579.03Excise Duty 1,717.64 1,880.35 0 0Net Sales 27,585.30 25,275.47 23,768.11 23,579.03Other Income 337.7 446.38 398.38 364.57Stock Adjustments 29.97 -8.36 0 0Total Income 27,952.97 25,713.49 24,166.49 23,943.60ExpenditureRaw Materials 19,890.84 18,320.46 17,470.73 17,467.69Power & Fuel Cost 158.47 137.46 129.18 112.66Employee Cost 1,172.87 930.04 820.92 735.52Other Manufacturing Expenses 0 0 0 0Selling and Admin Expenses 0 0 0 0Miscellaneous Expenses 2,850.91 2,339.09 2,025.33 1,738.41Preoperative Exp Capitalised 0 0 0 0Total Expenses 24,073.09 21,727.05 20,446.16 20,054.28

Mar '15 Mar '14 Mar '13 Mar '1212 mths 12 mths 12 mths 12 mths

Operating Profit 3,542.18 3,540.06 3,321.95 3,524.75PBDIT 3,879.88 3,986.44 3,720.33 3,889.32Interest 11.09 11.82 11.91 21.3PBDT 3,868.79 3,974.62 3,708.42 3,868.02Depreciation 539.97 1,107.37 1,141.75 1,097.34Other Written Off 0 0 0 0Profit Before Tax 3,328.82 2,867.25 2,566.67 2,770.68Extra-ordinary items 0 0 0 0PBT (Post Extra-ord Items) 3,328.82 2,867.25 2,566.67 2,770.68Tax 943.18 758.17 411.04 486.58Reported Net Profit 2,385.64 2,109.08 2,118.18 2,378.13Total Value Addition 4,182.25 3,406.59 2,975.43 2,586.59Preference Dividend 0 0 0 0Equity Dividend 1,198.12 1,299.13 1,198.13 898.59Corporate Dividend Tax 223.76 220.79 203.62 145.77Per share data (annualised)Shares in issue (lakhs) 1,996.88 1,996.88 1,996.88 1,996.88Earning Per Share (Rs) 119.47 105.62 106.07 119.09Equity Dividend (%) 3,000.00 3,252.70 3,000.00 2,250.00Book Value (Rs) 327.58 280.43 250.7 214.83

Page 3: Gaurav Das (15HS61019)

<--------------------------------------- in Rs. Cr. ------------------------------------> Vertical Analysis

Mar '11 2015 2014 2013 2012 201112 mths As % of Net Sales

19,397.93 106.2266 107.4394 100 100 1000 6.22665 7.439426 0 0 0

19,397.93 100 100 100 100 100209.78 1.224203 1.76606 1.676111 1.546162 1.081456

0 0.108645 -0.033076 0 0 019,607.71 101.3328 101.733 101.6761 101.5462 101.0815

14,222.94 72.10667 72.48316 73.50492 74.08146 73.32195100.47 0.574473 0.543847 0.543501 0.477797 0.517942618.95 4.251794 3.679615 3.453872 3.119382 3.190804

0 0 0 0 0 00 0 0 0 0 0

1,870.04 10.33489 9.254388 8.521208 7.372695 9.640410 0 0 0 0 0

16,812.40 87.26782 85.96101 86.0235 85.05134 86.6711

Mar '11 2015 2014 2013 2012 201112 mths As % of Net Sales

2,585.53 12.84082 14.00591 13.9765 14.94866 13.32892,795.31 14.06503 15.77197 15.65261 16.49483 14.41035

15.17 0.040203 0.046765 0.050109 0.090335 0.0782042,780.14 14.02482 15.72521 15.6025 16.40449 14.33215

402.38 1.957456 4.381204 4.803705 4.653881 2.0743450 0 0 0 0 0

2,377.76 12.06737 11.344 10.7988 11.75061 12.25780 0 0 0 0 0

2,377.76 12.06737 11.344 10.7988 11.75061 12.2578476.86 3.41914 2.999628 1.729376 2.063613 2.458304

1,927.90 8.648229 8.344375 8.911857 10.08578 9.9386892,589.46 15.16115 13.47785 12.51858 10.96987 13.34916

0 0 0 0 0 02,096.72 4.343328 5.139885 5.040914 3.810971 10.80899

340.14 0.811157 0.873535 0.856694 0.618219 1.753486

1,996.88 7.238928 7.900466 8.401509 8.468881 10.2942996.55 0.433093 0.417876 0.44627 0.505067 0.497734

5,250.00 10.87536 12.869 12.62195 9.542377 27.06474148.03 1.187517 1.109495 1.054775 0.911106 0.763123

Page 4: Gaurav Das (15HS61019)

Balance Sheet of Hero Motocorp <--------------------------------- in Rs. Cr. ------------------------------------>

Mar '15 Mar '14 Mar '13 Mar '1212 mths 12 mths 12 mths 12 mths

Sources Of FundsTotal Share Capital 39.94 39.94 39.94 39.94Equity Share Capital 39.94 39.94 39.94 39.94Share Application Money 0 0 0 0Preference Share Capital 0 0 0 0Reserves 6,501.39 5,559.93 4,966.30 4,249.89Networth 6,541.33 5,599.87 5,006.24 4,289.83Secured Loans 0 0 302.16 1,011.39Unsecured Loans 0 0 0 0Total Debt 0 0 302.16 1,011.39Total Liabilities 6,541.33 5,599.87 5,308.40 5,301.22

Mar '15 Mar '14 Mar '13 Mar '1212 mths 12 mths 12 mths 12 mths

Application Of FundsGross Block 4,697.98 3,761.52 4,427.29 4,980.69Less: Revaluation Reserves 0 0 0 0Less: Accum. Depreciation 1,785.29 1,518.27 1,356.31 1,195.18Net Block 2,912.69 2,243.25 3,070.98 3,785.51Capital Work in Progress 712.55 854.11 62.09 38.84Investments 3,154.11 4,088.77 3,623.83 3,964.26Inventories 815.49 669.55 636.76 675.57Sundry Debtors 1,389.59 920.58 665 272.31Cash and Bank Balance 159.25 117.5 181.04 76.82Total Current Assets 2,364.33 1,707.63 1,482.80 1,024.70Loans and Advances 1,378.02 1,203.54 1,401.95 1,075.61Fixed Deposits 0 0 0 0Total CA, Loans & Advances 3,742.35 2,911.17 2,884.75 2,100.31Deferred Credit 0 0 0 0Current Liabilities 3,180.69 2,903.12 2,893.39 3,497.63Provisions 799.68 1,594.31 1,439.86 1,090.07Total CL & Provisions 3,980.37 4,497.43 4,333.25 4,587.70Net Current Assets -238.02 -1,586.26 -1,448.50 -2,487.39Miscellaneous Expenses 0 0 0 0Total Assets 6,541.33 5,599.87 5,308.40 5,301.22

Contingent Liabilities 816.42 487.63 502 252.62Book Value (Rs) 327.58 280.43 250.7 214.83

Page 5: Gaurav Das (15HS61019)

<--------------------------------- in Rs. Cr. ------------------------------------> Vertical Analysis

Mar '11 2015 2014 2013 2012 201112 mths As % of Total Assets

39.94 0.6105791941 0.7132308429 0.752392435 0.753411479 0.902170721239.94 0.6105791941 0.7132308429 0.752392435 0.753411479 0.9021707212

0 0 0 0 0 00 0 0 0 0 0

2,916.12 99.389420806 99.286769157 93.55549695 80.16814997 65.8697567262,956.06 100 100 94.30788938 80.92156145 66.7719274471,471.04 0 0 5.692110617 19.07843855 33.228072553

0 0 0 0 0 01,471.04 0 0 5.692110617 19.07843855 33.2280725534,427.10 100 100 100 100 100

Mar '11 2015 2014 2013 2012 201112 mths As % of Total Assets

5,122.32 71.819950989 67.17155934 83.40158993 93.95365595 115.703733820 0 0 0 0 0

1,042.04 27.292461931 27.112593685 25.55025997 22.54537635 23.5377560934,080.28 44.527489058 40.058965655 57.85132997 71.4082796 92.165977728

49.96 10.893044687 15.252318357 1.16965564 0.732661538 1.12850398685,128.75 48.218175814 73.015445001 68.26595584 74.78014495 115.84897563

524.93 12.466730772 11.956527562 11.99532816 12.74367032 11.857197714130.59 21.24323341 16.439310198 12.5273152 5.136742108 2.949786542

71.52 2.434520197 2.0982629954 3.410443825 1.449100396 1.6155045063727.04 36.144484379 30.494100756 27.93308718 19.32951283 16.422488762740.23 21.066358065 21.492284642 26.41002939 20.28985781 16.720426464

0 0 0 0 0 01,467.27 57.210842443 51.986385398 54.34311657 39.61937064 33.142915227

0 0 0 0 0 05,218.09 48.624515198 51.842632061 54.50587748 65.97783152 117.867000971,081.07 12.225036804 28.47048235 27.12418054 20.56262521 24.4193715986,299.16 60.849552002 80.313114412 81.63005802 86.54045673 142.28637257

-4,831.89 -3.638709559 -28.326729013 -27.2869415 -46.92108609 -109.14345730 0 0 0 0 0

4,427.10 100 100 100 100 100

131.9 12.480948064 8.7078807187 9.45671012 4.765318172 2.9793770188148.03 5.0078500855 5.0077948238 4.72270364 4.052463395 3.3437238825

Page 6: Gaurav Das (15HS61019)

Income Statement of Hero Motocorp <--------------------------------------- in Rs. Cr. ------------------------------------>

Mar '15 Mar '14 Mar '13 Mar '1212 mths 12 mths 12 mths 12 mths

IncomeSales Turnover 29,302.94 27,155.82 23,768.11 23,579.03Excise Duty 1,717.64 1,880.35 0 0Net Sales 27,585.30 25,275.47 23,768.11 23,579.03Other Income 337.7 446.38 398.38 364.57Stock Adjustments 29.97 -8.36 0 0Total Income 27,952.97 25,713.49 24,166.49 23,943.60ExpenditureRaw Materials 19,890.84 18,320.46 17,470.73 17,467.69Power & Fuel Cost 158.47 137.46 129.18 112.66Employee Cost 1,172.87 930.04 820.92 735.52Other Manufacturing Expenses 0 0 0 0Selling and Admin Expenses 0 0 0 0Miscellaneous Expenses 2,850.91 2,339.09 2,025.33 1,738.41Preoperative Exp Capitalised 0 0 0 0Total Expenses 24,073.09 21,727.05 20,446.16 20,054.28

Mar '15 Mar '14 Mar '13 Mar '1212 mths 12 mths 12 mths 12 mths

Operating Profit 3,542.18 3,540.06 3,321.95 3,524.75PBDIT 3,879.88 3,986.44 3,720.33 3,889.32Interest 11.09 11.82 11.91 21.3PBDT 3,868.79 3,974.62 3,708.42 3,868.02Depreciation 539.97 1,107.37 1,141.75 1,097.34Other Written Off 0 0 0 0Profit Before Tax 3,328.82 2,867.25 2,566.67 2,770.68Extra-ordinary items 0 0 0 0PBT (Post Extra-ord Items) 3,328.82 2,867.25 2,566.67 2,770.68Tax 943.18 758.17 411.04 486.58Reported Net Profit 2,385.64 2,109.08 2,118.18 2,378.13Total Value Addition 4,182.25 3,406.59 2,975.43 2,586.59Preference Dividend 0 0 0 0Equity Dividend 1,198.12 1,299.13 1,198.13 898.59Corporate Dividend Tax 223.76 220.79 203.62 145.77Per share data (annualised)Shares in issue (lakhs) 1,996.88 1,996.88 1,996.88 1,996.88Earning Per Share (Rs) 119.47 105.62 106.07 119.09Equity Dividend (%) 3,000.00 3,252.70 3,000.00 2,250.00Book Value (Rs) 327.58 280.43 250.7 214.83

Page 7: Gaurav Das (15HS61019)

<--------------------------------------- in Rs. Cr. ------------------------------------> Horizontal Analysis

Mar '11 2014-2015 2013-201412 mths Rupee Change (Cr.) % Change Rupee Change (Cr.) % Change

19,397.93 2,147.12 7.906666048 3,387.71 14.2531736850 -162.71 -8.65317627 1,880.35 0

19,397.93 2,309.83 9.138623337 1,507.36 6.3419430489209.78 -108.68 -24.34696895 48.00 12.04879763

0 38.33 -458.492823 -8.36 019,607.71 2,239.48 8.709358395 1,547.00 6.401426107

14,222.94 1,570.38 8.571728002 849.73 4.8637349441100.47 21.01 15.28444638 8.28 6.4096609382618.95 242.83 26.10962969 109.12 13.292403645

0 0.00 0 0.00 00 0.00 0 0.00 0

1,870.04 511.82 21.88115891 313.76 15.4917963990 0.00 0 0.00 0

16,812.40 2,346.04 10.79778433 1,280.89 6.2646971363

Mar '11 2014-2015 2013-201412 mths Rupee Change (Cr.) % Change Rupee Change (Cr.) % Change

2,585.53 2.12 0.059885991 218.11 6.565721942,795.31 -106.56 -2.673061679 266.11 7.1528600957

15.17 -0.73 -6.175972927 -0.09 -0.7556675062,780.14 -105.83 -2.662644479 266.20 7.1782592047

402.38 -567.40 -51.2385201 -34.38 -3.0111670680 0.00 0 0.00 #DIV/0!

2,377.76 461.57 16.09800331 300.58 11.7108938820 0.00 0 0.00 0

2,377.76 461.57 16.09800331 300.58 11.710893882476.86 185.01 24.40217893 347.13 84.451634877

1,927.90 276.56 13.11282645 -9.10 -0.4296141032,589.46 775.66 22.76939696 431.16 14.490678658

0 0.00 0 0.00 02,096.72 -101.01 -7.775203405 101.00 8.4298031098

340.14 2.97 1.345169618 17.17 8.4323740301

1,996.88 0.00 0 0.00 096.55 13.85 13.11304677 -0.45 -0.424248138

5,250.00 -252.70 -7.768930427 252.70 8.4233333333148.03 47.15 16.81346504 29.73 11.858795373

Page 8: Gaurav Das (15HS61019)

Horizontal Analysis

2012-2013 2011-2012Rupee Change (Cr.) % Change Rupee Change (Cr.) % Change

189.08 0.8018989755 4,181.10 21.554361730.00 0 0.00 0

189.08 0.8018989755 4,181.10 21.5543617333.81 9.2739391612 154.79 73.78682429

0.00 0 0.00 0222.89 0.9308959388 4,335.89 22.11318915

3.04 0.0174035605 3,244.75 22.8134970716.52 14.663589562 12.19 12.1329750285.40 11.610833152 116.57 18.83350836

0.00 0 0.00 00.00 0 0.00 0

286.92 16.504737087 -131.63 -7.0388868690.00 0 0.00 0

391.88 1.9540965819 3,241.88 19.28267231

2012-2013 2011-2012Rupee Change (Cr.) % Change Rupee Change (Cr.) % Change

-202.80 -5.7535995461 939.22 36.3260144-168.99 -4.3449754713 1,094.01 39.13734076

-9.39 -44.084507042 6.13 40.40870138-159.60 -4.1261420572 1,087.88 39.1304035

44.41 4.0470592524 694.96 172.71236140.00 0 0.00 0

-204.01 -7.3631743832 392.92 16.524796450.00 0 0.00 0

-204.01 -7.3631743832 392.92 16.52479645-75.54 -15.524682478 9.72 2.038334102

-259.95 -10.930857438 450.23 23.3533897388.84 15.03291979 -2.87 -0.110833919

0.00 0 0.00 0299.54 33.334446188 -1,198.13 -57.14306154

57.85 39.685806407 -194.37 -57.14411713

0.00 0 0.00 0-13.02 -10.932907885 22.54 23.34541688750.00 33.333333333 -3,000.00 -57.14285714

35.87 16.696923149 66.80 45.12598798

Page 9: Gaurav Das (15HS61019)

Balance Sheet of Hero Motocorp <------------------------------- in Rs. Cr. ------------------------------> Income Statement of Hero Motocorp <------------------------- in Rs. Cr. ---------------------->

Mar '15 Mar '14 Mar '13 Mar '12 Mar '11 Mar '15 Mar '14 Mar '13 Mar '12 Mar '11 Liquidity Ratios 2015 2014 2013 2012 201112 mths 12 mths 12 mths 12 mths 12 mths 12 mths 12 mths 12 mths 12 mths 12 mths

Current Ratio 0.743339 0.588205 0.512478 0.29297 0.139331Sources Of Funds Income Quick / Acid Test Ratio 0.486951 0.357574 0.292404 0.099819 0.038733Total Share Capital 39.94 39.94 39.94 39.94 39.94 Sales Turnover 29,302.94 27,155.82 23,768.11 23,579.03 19,397.93 Cash Ratio 0.050068 0.040474 0.06257 0.021963 0.013706Equity Share Capital 39.94 39.94 39.94 39.94 39.94 Excise Duty 1,717.64 1,880.35 0 0 0Share Application Money 0 0 0 0 0 Net Sales 27,585.30 25,275.47 23,768.11 23,579.03 19,397.93 Activity & Efficiency Ratios 2015 2014 2013 2012 2011Preference Share Capital 0 0 0 0 0 Other Income 337.7 446.38 398.38 364.57 209.78Reserves 6,501.39 5,559.93 4,966.30 4,249.89 2,916.12 Stock Adjustments 29.97 -8.36 0 0 0 Inventory Turnover Ratio (ITR) 26.02384 28.9567 28.929 27.11173 28.46543Networth 6,541.33 5,599.87 5,006.24 4,289.83 2,956.06 Total Income 27,952.97 25,713.49 24,166.49 23,943.60 19,607.71 Debtor's Turnover Ratio (DTR) 17.86626 24.71042 32.16737 77.93003 133.6866Secured Loans 0 0 302.16 1,011.39 1,471.04 Expenditure Creditor's Turnover Ratio (CTR)Unsecured Loans 0 0 0 0 0 Raw Materials 19,890.84 18,320.46 17,470.73 17,467.69 14,222.94 Total Assets Turnover Ratio (TAT) 4.217078 4.513582 4.477453 4.44785 4.381634Total Debt 0 0 302.16 1,011.39 1,471.04 Power & Fuel Cost 158.47 137.46 129.18 112.66 100.47 Net Assets Turnover Ratio (NAT) 10.31353 38.47162 14.64925 18.16398 -25.8085Total Liabilities 6,541.33 5,599.87 5,308.40 5,301.22 4,427.10 Employee Cost 1,172.87 930.04 820.92 735.52 618.95 Fixed Assets Turnover Ratio (FAT) 6.604094 6.493811 6.21291 5.513602 5.242599

Cost of Goods Sold (COGS) 21,222.18 19,387.96 18,420.83 18,315.87 14,942.36 Current Assets Turnover Ratio (CAT) 11.66728 14.80149 16.02921 23.01067 26.68069Mar '15 Mar '14 Mar '13 Mar '12 Mar '11 Other Manufacturing Expenses 0 0 0 0 012 mths 12 mths 12 mths 12 mths 12 mths Selling and Admin Expenses 0 0 0 0 0 Leverage / Capital Structure Ratios 2015 2014 2013 2012 2011

Miscellaneous Expenses 2,850.91 2,339.09 2,025.33 1,738.41 1,870.04Application Of Funds Preoperative Exp Capitalised 0 0 0 0 0 Debt Ratio (DR) 0.486245 0.518426 0.60198 0.850563 1.510951Gross Block 4,697.98 3,761.52 4,427.29 4,980.69 5,122.32 Total Expenses 24,073.09 21,727.05 20,446.16 20,054.28 16,812.40 Debt Equity Ratio (DER) 0.486245 0.518426 0.638313 1.051095 2.262853Less: Revaluation Reserves 0 0 0 0 0 Long Term Debt Equity Ratio (LDER) 0 0 0.060357 0.235765 0.497635Less: Accum. Depreciation 1,785.29 1,518.27 1,356.31 1,195.18 1,042.04 Mar '15 Mar '14 Mar '13 Mar '12 Mar '11 Long Term Debt Total Assets Ratio (LDAR) 0 0 0.056921 0.190784 0.332281Net Block (Net Fixed Assets) 2,912.69 2,243.25 3,070.98 3,785.51 4,080.28 12 mths 12 mths 12 mths 12 mths 12 mths Long Term Debt to TC Ratio 0 0 0.056921 0.190784 0.332281Capital Work in Progress 712.55 854.11 62.09 38.84 49.96Investments 3,154.11 4,088.77 3,623.83 3,964.26 5,128.75 Operating Profit 3,542.18 3,540.06 3,321.95 3,524.75 2,585.53 Coverage Ratios 2015 2014 2013 2012 2011Inventories 815.49 669.55 636.76 675.57 524.93 PBDIT 3,879.88 3,986.44 3,720.33 3,889.32 2,795.31Sundry Debtors 1,389.59 920.58 665 272.31 130.59 Interest 11.09 11.82 11.91 21.3 15.17 Interest Coverage Ratio (ICR) 319.4031 299.4975 278.9211 165.4812 170.437Cash and Bank Balance 159.25 117.5 181.04 76.82 71.52 PBDT 3,868.79 3,974.62 3,708.42 3,868.02 2,780.14 Dividend Coverage Ratio (DTR) 0 0 0 0 0Total Current Assets 2,364.33 1,707.63 1,482.80 1,024.70 727.04 Depreciation 539.97 1,107.37 1,141.75 1,097.34 402.38Loans and Advances 1,378.02 1,203.54 1,401.95 1,075.61 740.23 Other Written Off 0 0 0 0 0 Profitability Ratios 2015 2014 2013 2012 2011Fixed Deposits 0 0 0 0 0 Profit Before Tax 3,328.82 2,867.25 2,566.67 2,770.68 2,377.76Total CA, Loans & Advances 3,742.35 2,911.17 2,884.75 2,100.31 1,467.27 Extra-ordinary items 0 0 0 0 0 Gross Profit Margin 0.230671 0.232934 0.224977 0.223214 0.229693Deferred Credit 0 0 0 0 0 PBT (Post Extra-ord Items) 3,328.82 2,867.25 2,566.67 2,770.68 2,377.76 Operating Profit Margin 0.128408 0.140059 0.139765 0.149487 0.133289Current Liabilities 3,180.69 2,903.12 2,893.39 3,497.63 5,218.09 Tax 943.18 758.17 411.04 486.58 476.86 Net Profit Margin 0.086482 0.083444 0.089119 0.100858 0.099387Provisions 799.68 1,594.31 1,439.86 1,090.07 1,081.07 Reported Net Profit (PAT) 2,385.64 2,109.08 2,118.18 2,378.13 1,927.90 Return on Total Assets (ROTA) 0.364703 0.37663 0.399024 0.448601 0.435477Total CL & Provisions 3,980.37 4,497.43 4,333.25 4,587.70 6,299.16 Total Value Addition 4,182.25 3,406.59 2,975.43 2,586.59 2,589.46 Return on Net Assets (RONA) 0.891938 3.210216 1.30552 1.83198 -2.565027Net Current Assets -238.02 -1,586.26 -1,448.50 -2,487.39 -4,831.89 Preference Dividend 0 0 0 0 0 Return on Equity 0.364703 0.37663 0.423108 0.554365 0.652186Miscellaneous Expenses 0 0 0 0 0 Equity Dividend 1,198.12 1,299.13 1,198.13 898.59 2,096.72Total Assets 6,541.33 5,599.87 5,308.40 5,301.22 4,427.10 Corporate Dividend Tax 223.76 220.79 203.62 145.77 340.14 Expenses Ratios 2015 2014 2013 2012 2011

Per share data (annualised)Contingent Liabilities 816.42 487.63 502 252.62 131.9 Shares in issue (lakhs) 1,996.88 1,996.88 1,996.88 1,996.88 1,996.88 COGS Ratio 76.93293 76.70663 77.50229 77.67864 77.03069Book Value (Rs) 327.58 280.43 250.7 214.83 148.03 Earning Per Share (Rs) 119.47 105.62 106.07 119.09 96.55 Operating Expenses Ratio 0 0 0 0 0

Equity Dividend (%) 3,000.00 3,252.70 3,000.00 2,250.00 5,250.00 Admin Expenses Ratio 0 0 0 0 0Book Value (Rs) 327.58 280.43 250.7 214.83 148.03 Selling Expenses Ratio 0 0 0 0 0

Operating Ratio 76.93293 76.70663 77.50229 77.67864 77.03069

Stockholder & Market Value Ratios 2015 2014 2013 2012 2011

Earnings per Share Ratio (EPS) 119.47 105.62 106.07 119.09 96.55Price to Earnings Ratio (P/E) 2.741944 2.655084 2.363534 1.80393 1.533195Dividend Payout Ratio (D/P) 0.502222 0.61597 0.565641 0.377856 1.087567Retention Ratio (RR) 0.497778 0.38403 0.434359 0.622144 -0.087567Market to Book Value Ratio (MBV)