Hero MotoCorp Financial Model
Hero MotoCorp Financial Model
Hero MotoCorp Financial Model
Hero MotoCorp Limited, formerly Hero Honda, is an Indian multinational motorcycle and scooter manuf
manufacturer in the world, and in India, where it has a market share of about 37.1% in the two-wheeler in
₹59,600 crore (US$8.4 billion).
Hero Honda started its operations in 1984 as a joint venture between Hero Cycles (sometimes called Her
of India and Honda of Japan. In June 2012, Hero MotoCorp approved a proposal to merge the investmen
came 18 months after its split from Hero Honda.
"Hero" is the brand name used by the Munjal brothers for their flagship company, Hero Cycles Ltd. A joi
in 1984 as the Hero Honda Motors Limited at Dharuhera, India. Munjal family and Honda group both ow
During the 1980s, the company introduced motorcycles that were popular in India for their fuel economy
it – Forget it' that emphasised the motorcycle's fuel efficiency helped the company grow at a double-digit
wheeler manufacturing company in India and globally. It maintains global industry leadership to date. Th
years (1984–2010) has come from the Japanese counterpart Honda.
The name of the company was changed from Hero Honda Motors Limited to Hero MotoCorp Limited on
developed by the British firm Wolff Olin’s. The logo was revealed on 9 August 2011 in London, to coinc
Hero MotoCorp can now export to Latin America, Africa and West Asia. Hero is free to use any vendor f
On 21 April 2014, Hero MotoCorp announced its plan on a ₹254 crore (equivalent to ₹327 crore or US$
next five years to set up a manufacturing plant in Bangladesh. The plant started production in 2017 under
of the manufacturing company and rest 45% is owned by Niloy Motors (A subsidiary of Nitol-Niloy Gro
Hero Dawn.
Model Hero MotoCorp
torcycle and scooter manufacturer based in New Delhi, India. The company is the largest two-wheeler
7.1% in the two-wheeler industry. As of 27 May 2021, the market capitalization of the company was
cles (sometimes called Hero Group, not to be confused with the Hero Group food company of Switzerland)
sal to merge the investment arm of its parent Hero Investment Pvt. Ltd. with the automaker. This decision
any, Hero Cycles Ltd. A joint venture between the Hero Group and Honda Motor Company was established
y and Honda group both owned 26% stake in the Company.
ndia for their fuel economy and low cost. A popular advertising campaign based on the slogan 'Fill it – Shut
pany grow at a double-digit pace since inception. In 2001, the company became the second largest two-
ustry leadership to date. The technology in the bikes of Hero MotoCorp (earlier Hero Honda) for almost 26
Hero MotoCorp Limited on 29 July 2011. The new brand identity and logo of Hero MotoCorp were
t 2011 in London, to coincide with the third test match between England and India.
is free to use any vendor for its components instead of just Honda-approved vendors.
alent to ₹327 crore or US$46 million in 2019) joint venture with Bangladesh's Nitol-Niloy Group in the
d production in 2017 under the name "HMCL Niloy Bangladesh Limited". Hero MotoCorp owns the 55%
sidiary of Nitol-Niloy Group). Hero also updated its 100cc engine range in 2014 for 110cc bikes except
Source : https://en.wikipedia.org/wiki/Hero_MotoCo
n.wikipedia.org/wiki/Hero_MotoCorp
Table Content
1 Income Statement
2 Balance Sheet
5 Assets Schedule
6 Debt Schedule
7 DCF Model
8 Beta Calculation
9 Ratio Analysis
10 Graphical Analysis
Income Sta
Historical
2017
Total Revenue ₹ 283,459,900,000.00
Cost of Revenue ₹ -192,751,000,000.00
Gross Profit ₹ 90,708,900,000.00
Selling, General and Administrative Expenses ₹ -32,898,300,000.00
Depreciation, Amortization and Depletion ₹ -5,022,500,000.00
Other Income/Expense, Operating ₹ -10,597,300,000.00
Operation and Maintenance Expenses ₹ -1,217,200,000.00
Provision Expense/Write-Back ₹ -95,700,000.00
Taxes Other Than Income Taxes ₹ 73,200,000.00
Operating Income/Expenses ₹ -49,757,800,000.00
Actual
2017
Total Revenue ₹ 283,459,900,000.00
Cost of Revenue -68%
Selling, General and Administrative Expenses -12%
Depreciation, Amortization and Depletion -2%
Other Income/Expense, Operating -4%
Operation and Maintenance Expenses 0%
Provision Expense/Write-Back 0%
Taxes Other Than Income Taxes 0%
Total Net Finance Income/Expense 0%
Net Investment Income 2%
Other Income/Expense, Non-Operating 0%
Irregular Income/Expenses 0%
Income Statement Hero MotoCorp
Historical
2018 2019 2020
₹ 319,353,900,000.00 ₹ 335,731,900,000.00 ₹ 288,779,400,000.00
₹ -220,492,500,000.00 ₹ -236,120,100,000.00 ₹ -199,280,700,000.00
₹ 98,861,400,000.00 ₹ 99,611,800,000.00 ₹ 89,498,700,000.00
₹ -36,933,000,000.00 ₹ -39,509,500,000.00 ₹ -36,609,300,000.00
₹ -5,749,800,000.00 ₹ -6,244,400,000.00 ₹ -8,457,600,000.00
₹ -7,131,700,000.00 ₹ -8,393,600,000.00 ₹ -10,039,700,000.00
₹ -1,325,800,000.00 ₹ -1,407,900,000.00 ₹ -1,404,100,000.00
₹ -52,400,000.00 ₹ - ₹ -530,400,000.00
₹ - ₹ - ₹ -
₹ -51,192,700,000.00 ₹ -55,555,400,000.00 ₹ -57,041,100,000.00
₹ 39,522,333,246.81
₹ 1,771,852,294.11
₹ 4,864,035,483.21
₹ -
₹ 1,632,260,833.06
₹ 8,268,148,610.38
₹ 47,790,481,857.19
₹ 14,337,144,557.16
₹ 33,453,337,300.03
₹ 21,101,128.61
₹ 33,432,236,171.43
30.0%
0.1%
₹ 167.37
₹ 167.34
₹ 199,750,120.00
₹ 199,791,153.00
₹ 113.00
2024
₹ 294,198,727,454.43
-69.095%
-11.904%
-2.090%
-2.987%
-0.438%
-0.058%
0.006%
0.602%
1.653%
0.000%
0.555%
Bala
Hi
2017
Total Assets ₹ 153,120,000,000.00
Total Current Assets ₹ 75,705,100,000.00
Cash, Cash Equivalents and Short Term Investments ₹ 46,494,800,000.00
Inventories ₹ 7,085,800,000.00
Trade and Other Receivables, Current ₹ 19,756,000,000.00
Other Current Assets ₹ 0.00
Cash Restricted or Pledged, Current ₹ 899,700,000.00
Derivative Investment and Hedging Assets, Current ₹ 44,200,000.00
Prepayments and Deposits, Current ₹ 1,424,600,000.00
Total Non-Current Assets ₹ 77,414,900,000.00
Net Property, Plant and Equipment ₹ 48,815,300,000.00
Net Intangible Assets ₹ 5,451,700,000.00
Total Long Term Investments ₹ 15,223,100,000.00
Trade and Other Receivables, Non-Current ₹ 5,444,100,000.00
Prepayments and Deposits, Non-Current ₹ 2,480,700,000.00
Ok Ok Ok
Forecated
2021 2022 2023
₹ 212,702,500,000.00 ₹ 226,896,340,000.00 ₹ 241,090,180,000.00
₹ 90,705,500,000.00 ₹ 93,352,550,000.00 ₹ 95,999,600,000.00
₹ 44,713,700,000.00 ₹ 43,690,300,000.00 ₹ 42,666,900,000.00
₹ 15,527,950,000.00 ₹ 17,536,020,000.00 ₹ 19,544,090,000.00
₹ 28,238,000,000.00 ₹ 29,869,800,000.00 ₹ 31,501,600,000.00
₹ 0.00 ₹ 0.00 ₹ 0.00
₹ 423,250,000.00 ₹ 310,980,000.00 ₹ 198,710,000.00
-₹ 16,800,000.00 -₹ 28,620,000.00 -₹ 40,440,000.00
₹ 1,819,400,000.00 ₹ 1,974,070,000.00 ₹ 2,128,740,000.00
₹ 121,997,000,000.00 ₹ 133,543,790,000.00 ₹ 145,090,580,000.00
₹ 61,387,900,000.00 ₹ 64,882,790,000.00 ₹ 68,377,680,000.00
₹ 8,973,200,000.00 ₹ 10,000,780,000.00 ₹ 11,028,360,000.00
₹ 43,583,400,000.00 ₹ 50,826,860,000.00 ₹ 58,070,320,000.00
₹ 5,730,000,000.00 ₹ 5,597,620,000.00 ₹ 5,465,240,000.00
₹ 2,322,500,000.00 ₹ 2,235,740,000.00 ₹ 2,148,980,000.00
Ok Ok Ok
2024
₹ 255,284,020,000.00
₹ 98,646,650,000.00
₹ 41,643,500,000.00
₹ 21,552,160,000.00
₹ 33,133,400,000.00
₹ 0.00
₹ 86,440,000.00
-₹ 52,260,000.00
₹ 2,283,410,000.00
₹ 156,637,370,000.00
₹ 71,872,570,000.00
₹ 12,055,940,000.00
₹ 65,313,780,000.00
₹ 5,332,860,000.00
₹ 2,062,220,000.00
₹ 255,284,020,000.00
₹ 44,658,030,000.00
₹ 31,489,010,000.00
₹ 5,017,450,000.00
₹ 2,734,940,000.00
₹ 2,373,200,000.00
₹ 3,043,430,000.00
₹ 9,897,580,000.00
₹ 2,420,390,000.00
₹ 1,905,400,000.00
₹ 5,571,790,000.00
₹ 200,728,410,000.00
₹ 198,351,080,000.00
₹ 792,390,000.00
₹ 26,899,240,000.00
₹ 295,260,000.00
₹ 170,364,190,000.00
₹ 2,377,330,000.00
Ok
Cash flow
Hist
2017
CASH FLOW FROM OPERATING ACTIVITIES
Income/Loss before Non-Cash Adjustment ₹ 35,463,000,000.00
Total Adjustments for Non-Cash Items ₹ 11,863,600,000.00
Depreciation, Amortization and Depletion, Non-Cas ₹ 5,022,500,000.00
Stock-Based Compensation, Non-Cash Adjustment ₹ 34,200,000.00
Taxes, Non-Cash Adjustment ₹ 13,391,000,000.00
Interest and Finance Income/Expenses, Non-Cash A ₹ -1,320,200,000.00
Other Provisions, Non-Cash Adjustment ₹ -
Net Investment Income/Loss, Non-Cash Adjustment ₹ -6,748,700,000.00
Irregular Income/Loss, Non-Cash Adjustment ₹ 1,700,600,000.00
Pension and Employee Benefit Expense, Non-Cash A ₹ -215,800,000.00
Changes in Operating Capital ₹ 4,615,500,000.00
Change in Inventories ₹ 534,100,000.00
Change in Trade and Other Receivables ₹ -2,682,000,000.00
Change in Other Current Assets ₹ 363,900,000.00
Change in Payables and Accrued Expenses ₹ 5,908,600,000.00
Change in Provisions ₹ 127,700,000.00
Change in Other Current Liabilities ₹ -418,000,000.00
Change in Other Operating Capital ₹ 781,200,000.00
Cash generated from Operating activities ₹ 51,942,100,000.00
Taxes Refund/Paid, Indirect ₹ -11,870,200,000.00
Net cash from operating Activities ₹ 40,071,900,000.00
₹ 33,453,337,300.03
₹ 14,321,100,000.00
₹ 12,308,520,000.00
₹ 181,320,000.00
₹ 7,728,140,000.00
₹ -4,170,820,000.00
₹ 1,007,760,000.00
₹ -832,870,000.00
₹ -2,203,070,000.00
₹ 302,120,000.00
₹ 93,580,000.00
₹ -2,903,330,000.00
₹ 15,321,720,000.00
₹ 3,135,790,000.00
₹ -13,997,350,000.00
₹ 695,940,000.00
₹ -1,717,090,000.00
₹ -442,100,000.00
₹ 47,868,017,300.03
₹ -5,909,220,000.00
₹ 41,958,797,300.03
₹ -12,245,960,000.00
₹ -249,440,000.00
₹ -15,459,100,000.00
₹ -1,814,260,000.00
₹ 1,127,620,000.00
₹ 4,900,680,000.00
₹ -23,740,460,000.00
₹ -10,160,000.00
₹ -1,517,830,000.00
₹ -2,184,050,000.00
₹ -271,540,000.00
₹ -23,902,120,000.00
₹ -4,758,310,000.00
₹ -32,644,010,000.00
₹ -14,425,672,699.97
₹ 3,731,460,000.00
₹ -10,694,212,699.97
Ass
Historical
Asset Schedule
2017 2018
₹ 292,834,434,911.52 ₹ 294,198,727,454.43
₹ 10,453,931,730.07 ₹ 10,502,635,773.73
3.570% 3.570%
₹ 68,377,680,000.00 ₹ 71,872,570,000.00
₹ 11,028,360,000.00 ₹ 12,055,940,000.00
₹ 79,406,040,000.00 ₹ 83,928,510,000.00
₹ 11,228,530,000.00 ₹ 12,308,520,000.00
14.141% 14.665%
86.111% 85.635%
13.889% 14.365%
₹ 9,669,048,238.78 ₹ 10,540,458,365.06
₹ 1,559,481,761.22 ₹ 1,768,061,634.94
De
Historical
Debt Schedule
2017 2018
Interest Expense
Interest Expense Net of Capitalized Interest ₹ 272,800,000.00 ₹ 308,000,000.00
Interest As a percent of Debt 3% 3%
Debt Schedule
Historical Forecasted
2019 2020 2021 2022
₹ 4,452,550,000.00 ₹ 5,017,450,000.00
₹ 2,284,300,000.00 ₹ 2,373,200,000.00
₹ 3,171,970,000.00 ₹ 3,043,430,000.00
₹ 9,908,820,000.00 ₹ 10,434,080,000.00
₹ 2,313,960,000.00 ₹ 2,420,390,000.00
₹ 12,222,780,000.00 ₹ 12,854,470,000.00
₹ 644,820,000.00 ₹ 709,280,000.00
5% 6%
W
Historical
Consolidated Working Capital
2017 2018
Ratio Assumptions
Inventory Turnover Ratio 26.39
Days of Inventory in hand 13.83
₹ 292,834,434,911.52 ₹ 294,198,727,454.43
₹ -202,334,384,360.85 ₹ -203,277,044,303.97
₹ 31,501,600,000.00 ₹ 33,133,400,000.00
₹ 19,544,090,000.00 ₹ 21,552,160,000.00
₹ 51,045,690,000.00 ₹ 54,685,560,000.00
₹ 32,130,090,000.00 ₹ 31,489,010,000.00
₹ 4,452,550,000.00 ₹ 5,017,450,000.00
₹ 2,284,300,000.00 ₹ 2,373,200,000.00
₹ 38,866,940,000.00 ₹ 38,879,660,000.00
₹ 12,178,750,000.00 ₹ 15,805,900,000.00
₹ -3,627,150,000.00 ₹ -3,627,150,000.00
₹ -200,326,314,360.85 ₹ -201,268,974,303.97
10.91 9.89
33.45 36.90
9.54 9.10
38.25 40.09
2.201% 2.468%
1.129% 1.167%
-6.17 -6.33
-59.13 -57.69
₹ 1,631,800,000.00 ₹ 1,631,800,000.00
₹ 2,008,070,000.00 ₹ 2,008,070,000.00
₹ 641,080,000.00 ₹ 641,080,000.00
₹ -564,900,000.00 ₹ -564,900,000.00
₹ -88,900,000.00 ₹ -88,900,000.00
₹ 3,627,150,000.00 ₹ 3,627,150,000.00
Cost of Equity & Cost of Debt
Risk Free Rate (Rf) 6.80%
Beta 0.826067295873372
Histor
DCF Valuation Model
2017
Terminal Value
Historical
2018 2019 2020
34,935.94
WACC Calculations
Forecasted
2021 2022 2023 2024
₹ 3,069,667,584,885.10
Covariance 9.5916241677892E-05
Correlation 0.47897171671673
Standard Deviation (Hero MotoCorp) 0.018621936655197
Standard Deviation (NIFTY) 0.010797402358
Mean (Hero MotoCorp) 0.000906038879016
Mean (NIFTY) 0.001757444713976
Annual Return (Hero MotoCorp) 0.198437362411149
Annual Return (NIFTY) 0.521001368648143
Beta (Covariance/Variance NIFTY) 0.826067295873373
Beta (S.D Hero MotoCorp/S.D NIFTY * Correlation) 0.826067295873373
Beta (Slope) 0.826067295873372
Alpha (Mean Hero MotoCorp - Beta * Mean NIFTY) -0.000545728723505
Alpha (Intercept) -0.000545728723505
Alpha -0.000545728723505
Beta Parameter 0.826067295873372
Total Return of Stock 0.825521567149867
RATIO ANA
Historical
2017 2018 2019
Profitability Ratios
Gross Margin 32.00% 30.96% 29.67%
Operating Margin 14.45% 14.93% 13.12%
Net Margin 12.51% 11.66% 10.32%
Return on Assets 18.72% 19.18% 16.67%
Return on Capital Employed 18.72% 19.18% 16.67%
Liquidity Ratios
Current Ratio 1.81 2.01 1.91
Quick Ratio -0.17 -0.21 -0.28
Solvency Ratios
Debt to Equity Ratio 0.01 0.01 0.02
Debt to Assets Ratio 0.01 2.33 2.37
Total assets to equity ratio 1.47 1.44 1.40
Turnover Ratio
Assets Turnover 1.85 1.84 1.81
Receivables Turnover Ratio 14.03 15.81 16.62
Accounts Payables Turnover 5.60 6.41 6.86
Days Sales Outstanding 26.01 23.09 21.96
Days Payables Outstanding 65.17 56.97 53.20
DUPONT ANAL
ROE= Tax Burden * Interest Burden * Operating Ma
UPONT ANALYSIS
est Burden * Operating Margin* Asset Turnover * Equity Multiplier
Net Profi t
₹ 60,000,000,000.00
₹ 50,000,000,000.00
₹ 40,000,000,000.00
₹ 30,000,000,000.00
₹ 20,000,000,000.00
₹ 10,000,000,000.00
₹-
2017 2018 2019 2020 2021 2022 2023 2024
Revenue
₹ 350,000,000,000.00
₹ 340,000,000,000.00
₹ 330,000,000,000.00
₹ 320,000,000,000.00
₹ 310,000,000,000.00
₹ 300,000,000,000.00
₹ 290,000,000,000.00
₹ 280,000,000,000.00
₹ 270,000,000,000.00
₹ 260,000,000,000.00
₹ 250,000,000,000.00
2017 2018 2019 2020 2021 2022 2023 2024
Current Rati o
2.50
2.00
1.50
1.00
2.00
1.50
1.00
0.50
0.00
2017 2018 2019 2020 2021 2 02 2 2 02 3 2 02 4
₹ 185.00
₹ 180.00
₹ 175.00
₹ 170.00
₹ 165.00
₹ 160.00
₹ 155.00
₹ 150.00
2017 2018 20 1 9 2020 2021 2022 2023 2 02 4
RAPHICAL ANALYSIS
Total Assets
₹ 300,000,000,000.00
₹ 250,000,000,000.00
₹ 200,000,000,000.00
₹ 150,000,000,000.00
₹ 100,000,000,000.00
₹ 50,000,000,000.00
₹ 0.00
2023 2024 2017 2018 2019 2020 2021 2022 2023 2024
12.00%
10.00%
8.00%
6.00%
4.00%
2.00%
Leverage
1.50
1.45
1.40
1.35
1.30
1.45
1.40
1.35
1.30
1.25
1.20
2 02 3 2 02 4 1.15
2017 2018 2019 2020 2021 2022 2023 2024
Return on Equity
25.00%
20.00%
15.00%
10.00%
5.00%
0.00%
2023 2 02 4 2017 2018 2019 2020 2021 2022 2023 2024