Description
This is a spreadsheet on financial analysis of Hero Honda Motors.
« Previous Hero Honda Motors Years
------------------ in Rs. Cr. -----------------Mar '05 12 mths Sources Of Funds Total Share Capital Equity Share Capital Share Application Money Preference Share Capital Reserves Revaluation Reserves Networth Secured Loans Unsecured Loans Total Debt Total Liabilities Mar '06 12 mths Mar '07 12 mths Mar '08 12 mths
Balance Sheet
39.94 39.94 0 0 1,453.44 0 1,493.38 0 201.76 201.76 1,695.14 Mar '05 12 mths
39.94 39.94 0 0 1,969.39 0 2,009.33 0 185.78 185.78 2,195.11 Mar '06 12 mths
39.94 39.94 0 0 2,430.12 0 2,470.06 0 165.17 165.17 2,635.23 Mar '07 12 mths
39.94 39.94 0 0 2,946.30 0 2,986.24 0 132 132 3,118.24 Mar '08 12 mths
Application Of Funds Gross Block Less: Accum. Depreciation Net Block Capital Work in Progress Investments Inventories Sundry Debtors Cash and Bank Balance Total Current Assets Loans and Advances Fixed Deposits Total CA, Loans & Advances
1,104.19 429.71 674.48 40.85 2,026.65 204.26 89.55 17.14 310.95 243.75 0.46 555.16
1,471.97 522.6 949.37 44.19 2,061.89 226.55 158.66 23.22 408.43 278.63 135.5 822.56
1,800.63 635.1 1,165.53 189.92 1,973.87 275.58 335.25 35.26 646.09 268.04 0.52 914.65
1,938.78 782.52 1,156.26 408.49 2,566.82 317.1 297.44 130.58 745.12 196.37 0.51 942
Deffered Credit Current Liabilities Provisions Total CL & Provisions Net Current Assets Miscellaneous Expenses Total Assets Contingent Liabilities Book Value (Rs)
0 1,117.29 484.71 1,602.00 -1,046.84 0 1,695.14 0 74.79
0 1,192.98 489.92 1,682.90 -860.34 0 2,195.11 73.48 100.62
0 1,171.50 437.24 1,608.74 -694.09 0 2,635.23 165.59 123.7
0 1,455.57 499.76 1,955.33 -1,013.33 0 3,118.24 56.37 149.55
Mar '09 12 mths
39.94 39.94 0 0 3,760.81 0 3,800.75 0 78.49 78.49 3,879.24 Mar '09 12 mths
2,516.27 942.56 1,573.71 120.54 3,368.75 326.83 149.94 217.49 694.26 325.8 2.08 1,022.14
0 1,678.93 526.97 2,205.90 -1,183.76 0 3,879.24 100.54 190.33
Hero Honda Motors
Profit & Loss account
« Previous Years
------------------ in Rs. Cr. -----------------Mar '05 12 mths Mar '06 12 mths Mar '07 12 mths Mar '08 12 mths Mar '09 12 mths
Income Sales Turnover Excise Duty Net Sales Other Income Stock Adjustment s Total Income Expenditure Raw Materials Power & Fuel Cost Employee Cost Other Manufacturi ng Expenses Selling and Admin Expenses Miscellaneo us Expenses Preoperativ e Exp Capitalised Total Expenses
8,606.62 1,178.22 7,428.40 138.2
10,097.17 1,377.96 8,719.21 160.46
11,553.47 1,647.52 9,905.95 197.68
12,048.30 1,703.29 10,345.01 216.3
13,553.23 1,227.85 12,325.38 222.14
14.95 7,581.55
14.97 8,894.64
3.2 10,106.83
-14.14 10,547.17
22.09 12,569.61
5,276.42 32.88 267.97
6,142.78 46.65 320.61
7,255.66 52.45 353.81
7,465.36 56.55 383.45
8,842.14 73.7 448.65
177.46
238.39
280.17
304.11
354.08
358.03
446.98
558.99
563.27
669.34
144.4
156.79
206.11
190.36
206.54
0 6,257.16 Mar '05 12 mths
0 7,352.20 Mar '06 12 mths
0 8,707.19 Mar '07 12 mths
0 8,963.10 Mar '08 12 mths
0 10,594.45 Mar '09 12 mths
Operating Profit PBDIT Interest PBDT Depreciatio n Other Written Off Profit Before Tax Extraordinary items PBT (Post Extra-ord Items) Tax Reported Net Profit Total Value Addition
1,186.19 1,324.39 17.76 1,306.63 89.38 0
1,381.98 1,542.44 15.58 1,526.86 114.62 0
1,201.96 1,399.64 13.76 1,385.88 139.78 0
1,367.77 1,584.07 13.47 1,570.60 160.32 0
1,753.02 1,975.16 13.04 1,962.12 180.66 0
1,217.25
1,412.24
1,246.10
1,410.28
1,781.46
0
0
0
0
0
1,217.25 406.78 810.47
1,412.24 440.9 971.34
1,246.10 388.21 857.89
1,410.28 442.4 967.88
1,781.46 499.7 1,281.76
980.74
1,209.42
1,451.53
1,497.74
1,752.31
Preference Dividend 0 Equity Dividend 399.38 Corporate Dividend Tax 56.52 Per share data (annualised) Shares in issue (lakhs) 1,996.88 Earning Per Share (Rs) 40.59 Equity Dividend (%) 1,000.00 Book Value (Rs)
0 399.38
0 339.47
0 379.41
0 399.38
56.01
57.69
64.48
67.87
1,996.88
1,996.88
1,996.88
1,996.88
40.59
42.96
48.47
64.19
1,000.00
850
950
1,000.00
74.79
100.62
123.7
149.55
190.33
Mar '05
Mar '06
Mar '07
PROFITABILITY RATIOS
PROFIT MARGIN=PROFIT AFTER TAX /SALES ASSET TURNOVER =SALES/TOTAL ASSET RETURN ON ASSETS OR TURNOVER RETURN ON EQUITY=PAT/AVG. SHAREHOLDER EQUITY RETURN ON NET WORTH = PAT/NET WORTH LIQUIDITY RATIOS CURRENT RATIO =CURRENT ASSETS/CURRENT LIAB. QUICK RATIO =QUICK ASSETS/CURRENT LIAB. DEBTOR TURNOVER RATIO=SALES/DEBTORS INVENTORY TURNOVER=COGS/INVENTORIES TOTAL ASSET TURNOVER SOLVENCY RATIOS DEBT TO EQUITY RATIO INTEREST COVER RATIO=EBIT/INT. EXPENSE CAPITAL MARKET RATIOS EARNINGS PER SHARE DIVIDEND PER SHARE
10.91042 4.382175 47.81139 20.29219 54.27085
11.14023 3.972106 44.25017 24.31998 48.34149
8.660351 3.759046 32.55465 21.47947 34.73154
0.346542 0.219039 96.10966 42.13561 4.382175
0.488775 0.354157 63.6403 44.56928 3.972106
0.568551 0.397249 34.46225 41.9242 3.759046
5.051577 4.651477 4.135453 69.54 91.64 91.56
40.59 20.0002
42.96 48.64 20.0002 17.00002
Mar '08
Mar '09
9.356008 3.31758 31.0393 24.23335 32.41133
10.39935 3.177267 33.04152 32.09214 33.72387
0.48176 0.319588 40.50666 37.99527 3.31758
0.463366 0.315205 90.39102 41.46875 3.177267
3.304957 1.965198 105.70 137.62
42.87
64.19
19.00014
20.0002
ANALYSIS PROFIT MARGIN
THIS REPRESENTS THE PROFIT MADE ON TE SALES MADE. THIS MUST ME HIGH AS THIS IS G DECREASES AND AGAIN INCREASES SES.SO THERE IS A VARIATION IN IT AND IT SHOULD NOT
ASSET TURNOVER
THIS REPRESENENTS HOW WELL THE IS UTILISING IT ASSETS ,AS WE SEE THIS RATIO DECRA EFFICIENTLY
RETURN ON ASSET RETURN ON EQUITY CURRENT RATIO
THIS REPRESENTS THE RATIO OF PROFIT AFTER TAX DIVIDED BY TOTAL ASSET , SO THIS T ESENTS THIS MEASURES THE EFFICIENCY WITH WHICH SHAREHOLDERS FUNDS AE EMPLOYED
THIS IS USED AS AN INDICATOR OF A COMPANYS ABILITY TO PAY ITS DEBT IN THE SHORT T FOR THE COMPANY
QUICK RATIO
THIS IS USED AS A SUPPLEMENT TO THE CURRENT RATIO , THIS MUST BE EQUAL TO 1:1 , A
DEBTOR TURNOVER RATIO THIS MEASURES THE EFFICACY OF A FIRMS CREDIT AND COLLECTION POLICY RATIO BETTRER IT WILLILL BE . BE AS WE SEE THIS IS FLACTUATING THIS IS NOT THIS
INVENTORY TURNOVER RATIO THIS REPRESENTS HOW WELL THE COMPANY IS CONVERTING ITS INVENTORIES IN
DEBT TO EQUITY RATIO THIS SHOWS THE AMOUNT OF DEBT IN THE CAPITAL STRUCTURE , AS DEBT INCREASES TH
INTEREST RATIO THIS REFLECTS THE ABILITY TO PAY ITS INTEREST ON DEBT , MORE THIS RATIO BETTER IT WILL BE EARNINGS PER SHARE THIS RATIO IS USEFUL FROM THE INVESTORS POINT OF VIEW, THIS MUST BE HIGH DVIDEND PER SHARE
THIS IS AMOUNT OF THE DIVIDEND PAID PER PER SHARE , COMPANY IS PAYING DIVIDEND
. THIS MUST ME HIGH AS THIS IS GOOD FOR THE COMPANY RIATION IN IT AND IT SHOULD NOT BE THERE.
AS WE SEE PROFIT MARGIN OF THE COMPANY
ETS ,AS WE SEE THIS RATIO DECRAESES FO THE COMPANY AND IT'S NOT GOOD FOR THE COMPANY . ASSET IS
IDED BY TOTAL ASSET , SO THIS TELLS US ABOUT THE HOW MUCH PROFIT ARE WE GETTING PER UNIT OF SALES , AS THIS RATIO DECREAS .AS THIS IS INCREASING SO THIS IS GOOD FROM THE SHAREHOLDER POINT OF VIEW.
LDERS FUNDS AE EMPLOYED
TO PAY ITS DEBT IN THE SHORT TERM
.THIS RATIO MUST BE EQUAL TO 1:1 , AS WE THIS IS LESS THAN ONE FOR THE COMPANY SO 2:1, AS WE SEE THIS IS LESS THAN THE REQUIRED , SO S LESS
, THIS MUST BE EQUAL TO 1:1 , AS THIS IS LESS THAN ONE ITS NOT GOOD FOR THE COMPANY
CREDIT AND COLLECTION POLICY AND SHOWS THE NUMBER OF TIMES EACH YEAR THE DEBTORS TURNS IN TO CASH , HIGHER THE THIS IS FLACTUATING THIS IS NOT GOOD FO THE COMPANY .
CONVERTING ITS INVENTORIES IN TO FINISHED GOODS , AS THIS IS INCRESING THIS IS GOOD FOR THE COMPNY
RUCTURE , AS DEBT INCREASES THE RISK , SO THIS MUST BE LESS .THSI RATIO DECEASE FOR THE COMPANY , SO IT IS BENEFICIAL .
ORE THIS RATIO BETTER IT WILL BE , AS WE SEE ITS INCREASING ITS GOO VIEW, THIS MUST BE HIGH AS THIS IS INCREASING THIS IS GOOD .
OD
E , COMPANY IS PAYING DIVIDEND OF 20 PERCENT .
ANY FIRST INCREASES THEN DECREASES
IS NOT BEING ULTILISED
ASSETS
POINT OF VIEW. S LESS THAN THE REQUIRED , SO THIS IS NOT GOOD
S IN TO CASH , HIGHER THE
S IS GOOD FOR THE COMPANY
ANY , SO IT IS BENEFICIAL .
doc_293036749.xls
This is a spreadsheet on financial analysis of Hero Honda Motors.
« Previous Hero Honda Motors Years
------------------ in Rs. Cr. -----------------Mar '05 12 mths Sources Of Funds Total Share Capital Equity Share Capital Share Application Money Preference Share Capital Reserves Revaluation Reserves Networth Secured Loans Unsecured Loans Total Debt Total Liabilities Mar '06 12 mths Mar '07 12 mths Mar '08 12 mths
Balance Sheet
39.94 39.94 0 0 1,453.44 0 1,493.38 0 201.76 201.76 1,695.14 Mar '05 12 mths
39.94 39.94 0 0 1,969.39 0 2,009.33 0 185.78 185.78 2,195.11 Mar '06 12 mths
39.94 39.94 0 0 2,430.12 0 2,470.06 0 165.17 165.17 2,635.23 Mar '07 12 mths
39.94 39.94 0 0 2,946.30 0 2,986.24 0 132 132 3,118.24 Mar '08 12 mths
Application Of Funds Gross Block Less: Accum. Depreciation Net Block Capital Work in Progress Investments Inventories Sundry Debtors Cash and Bank Balance Total Current Assets Loans and Advances Fixed Deposits Total CA, Loans & Advances
1,104.19 429.71 674.48 40.85 2,026.65 204.26 89.55 17.14 310.95 243.75 0.46 555.16
1,471.97 522.6 949.37 44.19 2,061.89 226.55 158.66 23.22 408.43 278.63 135.5 822.56
1,800.63 635.1 1,165.53 189.92 1,973.87 275.58 335.25 35.26 646.09 268.04 0.52 914.65
1,938.78 782.52 1,156.26 408.49 2,566.82 317.1 297.44 130.58 745.12 196.37 0.51 942
Deffered Credit Current Liabilities Provisions Total CL & Provisions Net Current Assets Miscellaneous Expenses Total Assets Contingent Liabilities Book Value (Rs)
0 1,117.29 484.71 1,602.00 -1,046.84 0 1,695.14 0 74.79
0 1,192.98 489.92 1,682.90 -860.34 0 2,195.11 73.48 100.62
0 1,171.50 437.24 1,608.74 -694.09 0 2,635.23 165.59 123.7
0 1,455.57 499.76 1,955.33 -1,013.33 0 3,118.24 56.37 149.55
Mar '09 12 mths
39.94 39.94 0 0 3,760.81 0 3,800.75 0 78.49 78.49 3,879.24 Mar '09 12 mths
2,516.27 942.56 1,573.71 120.54 3,368.75 326.83 149.94 217.49 694.26 325.8 2.08 1,022.14
0 1,678.93 526.97 2,205.90 -1,183.76 0 3,879.24 100.54 190.33
Hero Honda Motors
Profit & Loss account
« Previous Years
------------------ in Rs. Cr. -----------------Mar '05 12 mths Mar '06 12 mths Mar '07 12 mths Mar '08 12 mths Mar '09 12 mths
Income Sales Turnover Excise Duty Net Sales Other Income Stock Adjustment s Total Income Expenditure Raw Materials Power & Fuel Cost Employee Cost Other Manufacturi ng Expenses Selling and Admin Expenses Miscellaneo us Expenses Preoperativ e Exp Capitalised Total Expenses
8,606.62 1,178.22 7,428.40 138.2
10,097.17 1,377.96 8,719.21 160.46
11,553.47 1,647.52 9,905.95 197.68
12,048.30 1,703.29 10,345.01 216.3
13,553.23 1,227.85 12,325.38 222.14
14.95 7,581.55
14.97 8,894.64
3.2 10,106.83
-14.14 10,547.17
22.09 12,569.61
5,276.42 32.88 267.97
6,142.78 46.65 320.61
7,255.66 52.45 353.81
7,465.36 56.55 383.45
8,842.14 73.7 448.65
177.46
238.39
280.17
304.11
354.08
358.03
446.98
558.99
563.27
669.34
144.4
156.79
206.11
190.36
206.54
0 6,257.16 Mar '05 12 mths
0 7,352.20 Mar '06 12 mths
0 8,707.19 Mar '07 12 mths
0 8,963.10 Mar '08 12 mths
0 10,594.45 Mar '09 12 mths
Operating Profit PBDIT Interest PBDT Depreciatio n Other Written Off Profit Before Tax Extraordinary items PBT (Post Extra-ord Items) Tax Reported Net Profit Total Value Addition
1,186.19 1,324.39 17.76 1,306.63 89.38 0
1,381.98 1,542.44 15.58 1,526.86 114.62 0
1,201.96 1,399.64 13.76 1,385.88 139.78 0
1,367.77 1,584.07 13.47 1,570.60 160.32 0
1,753.02 1,975.16 13.04 1,962.12 180.66 0
1,217.25
1,412.24
1,246.10
1,410.28
1,781.46
0
0
0
0
0
1,217.25 406.78 810.47
1,412.24 440.9 971.34
1,246.10 388.21 857.89
1,410.28 442.4 967.88
1,781.46 499.7 1,281.76
980.74
1,209.42
1,451.53
1,497.74
1,752.31
Preference Dividend 0 Equity Dividend 399.38 Corporate Dividend Tax 56.52 Per share data (annualised) Shares in issue (lakhs) 1,996.88 Earning Per Share (Rs) 40.59 Equity Dividend (%) 1,000.00 Book Value (Rs)
0 399.38
0 339.47
0 379.41
0 399.38
56.01
57.69
64.48
67.87
1,996.88
1,996.88
1,996.88
1,996.88
40.59
42.96
48.47
64.19
1,000.00
850
950
1,000.00
74.79
100.62
123.7
149.55
190.33
Mar '05
Mar '06
Mar '07
PROFITABILITY RATIOS
PROFIT MARGIN=PROFIT AFTER TAX /SALES ASSET TURNOVER =SALES/TOTAL ASSET RETURN ON ASSETS OR TURNOVER RETURN ON EQUITY=PAT/AVG. SHAREHOLDER EQUITY RETURN ON NET WORTH = PAT/NET WORTH LIQUIDITY RATIOS CURRENT RATIO =CURRENT ASSETS/CURRENT LIAB. QUICK RATIO =QUICK ASSETS/CURRENT LIAB. DEBTOR TURNOVER RATIO=SALES/DEBTORS INVENTORY TURNOVER=COGS/INVENTORIES TOTAL ASSET TURNOVER SOLVENCY RATIOS DEBT TO EQUITY RATIO INTEREST COVER RATIO=EBIT/INT. EXPENSE CAPITAL MARKET RATIOS EARNINGS PER SHARE DIVIDEND PER SHARE
10.91042 4.382175 47.81139 20.29219 54.27085
11.14023 3.972106 44.25017 24.31998 48.34149
8.660351 3.759046 32.55465 21.47947 34.73154
0.346542 0.219039 96.10966 42.13561 4.382175
0.488775 0.354157 63.6403 44.56928 3.972106
0.568551 0.397249 34.46225 41.9242 3.759046
5.051577 4.651477 4.135453 69.54 91.64 91.56
40.59 20.0002
42.96 48.64 20.0002 17.00002
Mar '08
Mar '09
9.356008 3.31758 31.0393 24.23335 32.41133
10.39935 3.177267 33.04152 32.09214 33.72387
0.48176 0.319588 40.50666 37.99527 3.31758
0.463366 0.315205 90.39102 41.46875 3.177267
3.304957 1.965198 105.70 137.62
42.87
64.19
19.00014
20.0002
ANALYSIS PROFIT MARGIN
THIS REPRESENTS THE PROFIT MADE ON TE SALES MADE. THIS MUST ME HIGH AS THIS IS G DECREASES AND AGAIN INCREASES SES.SO THERE IS A VARIATION IN IT AND IT SHOULD NOT
ASSET TURNOVER
THIS REPRESENENTS HOW WELL THE IS UTILISING IT ASSETS ,AS WE SEE THIS RATIO DECRA EFFICIENTLY
RETURN ON ASSET RETURN ON EQUITY CURRENT RATIO
THIS REPRESENTS THE RATIO OF PROFIT AFTER TAX DIVIDED BY TOTAL ASSET , SO THIS T ESENTS THIS MEASURES THE EFFICIENCY WITH WHICH SHAREHOLDERS FUNDS AE EMPLOYED
THIS IS USED AS AN INDICATOR OF A COMPANYS ABILITY TO PAY ITS DEBT IN THE SHORT T FOR THE COMPANY
QUICK RATIO
THIS IS USED AS A SUPPLEMENT TO THE CURRENT RATIO , THIS MUST BE EQUAL TO 1:1 , A
DEBTOR TURNOVER RATIO THIS MEASURES THE EFFICACY OF A FIRMS CREDIT AND COLLECTION POLICY RATIO BETTRER IT WILLILL BE . BE AS WE SEE THIS IS FLACTUATING THIS IS NOT THIS
INVENTORY TURNOVER RATIO THIS REPRESENTS HOW WELL THE COMPANY IS CONVERTING ITS INVENTORIES IN
DEBT TO EQUITY RATIO THIS SHOWS THE AMOUNT OF DEBT IN THE CAPITAL STRUCTURE , AS DEBT INCREASES TH
INTEREST RATIO THIS REFLECTS THE ABILITY TO PAY ITS INTEREST ON DEBT , MORE THIS RATIO BETTER IT WILL BE EARNINGS PER SHARE THIS RATIO IS USEFUL FROM THE INVESTORS POINT OF VIEW, THIS MUST BE HIGH DVIDEND PER SHARE
THIS IS AMOUNT OF THE DIVIDEND PAID PER PER SHARE , COMPANY IS PAYING DIVIDEND
. THIS MUST ME HIGH AS THIS IS GOOD FOR THE COMPANY RIATION IN IT AND IT SHOULD NOT BE THERE.
AS WE SEE PROFIT MARGIN OF THE COMPANY
ETS ,AS WE SEE THIS RATIO DECRAESES FO THE COMPANY AND IT'S NOT GOOD FOR THE COMPANY . ASSET IS
IDED BY TOTAL ASSET , SO THIS TELLS US ABOUT THE HOW MUCH PROFIT ARE WE GETTING PER UNIT OF SALES , AS THIS RATIO DECREAS .AS THIS IS INCREASING SO THIS IS GOOD FROM THE SHAREHOLDER POINT OF VIEW.
LDERS FUNDS AE EMPLOYED
TO PAY ITS DEBT IN THE SHORT TERM
.THIS RATIO MUST BE EQUAL TO 1:1 , AS WE THIS IS LESS THAN ONE FOR THE COMPANY SO 2:1, AS WE SEE THIS IS LESS THAN THE REQUIRED , SO S LESS
, THIS MUST BE EQUAL TO 1:1 , AS THIS IS LESS THAN ONE ITS NOT GOOD FOR THE COMPANY
CREDIT AND COLLECTION POLICY AND SHOWS THE NUMBER OF TIMES EACH YEAR THE DEBTORS TURNS IN TO CASH , HIGHER THE THIS IS FLACTUATING THIS IS NOT GOOD FO THE COMPANY .
CONVERTING ITS INVENTORIES IN TO FINISHED GOODS , AS THIS IS INCRESING THIS IS GOOD FOR THE COMPNY
RUCTURE , AS DEBT INCREASES THE RISK , SO THIS MUST BE LESS .THSI RATIO DECEASE FOR THE COMPANY , SO IT IS BENEFICIAL .
ORE THIS RATIO BETTER IT WILL BE , AS WE SEE ITS INCREASING ITS GOO VIEW, THIS MUST BE HIGH AS THIS IS INCREASING THIS IS GOOD .
OD
E , COMPANY IS PAYING DIVIDEND OF 20 PERCENT .
ANY FIRST INCREASES THEN DECREASES
IS NOT BEING ULTILISED
ASSETS
POINT OF VIEW. S LESS THAN THE REQUIRED , SO THIS IS NOT GOOD
S IN TO CASH , HIGHER THE
S IS GOOD FOR THE COMPANY
ANY , SO IT IS BENEFICIAL .
doc_293036749.xls