Jul-21 Company Name Claim Buddy Numbers From Ir Base Year Below (In Consistent Units) This Year
Jul-21 Company Name Claim Buddy Numbers From Ir Base Year Below (In Consistent Units) This Year
Jul-21 Company Name Claim Buddy Numbers From Ir Base Year Below (In Consistent Units) This Year
Default assumptions.
In stable growth, i will assume that ir firm will have a cost of capital similar to that of typical mature companies (riskfree rate + 4.5%)
Do i want to override this assumption = No Mature companies generally see their risk
If yes, enter the cost of capital after year 10 = 7.50% Though some sectors, even in stable growt
i will assume that ir firm will earn a return on capital equal to its cost of capital after year 10. I am assuming that whatever competitive adv
Do i want to override this assumption = No
If yes, enter the return on capital i expect after year 10 12%
i will assume that ir firm has no chance of failure over the foreseeable future.
Do i want to override this assumption = Yes
If yes, enter the probability of failure = 10%
What do i want to tie ir proceeds in failure to? V
Enter the distress proceeds as percentage of book or fair value 50%
i will assume that ir effective tax rate will adjust to ir marginal tax rate by ir terminal year. If i override this assumption, I will leave the tax
Do i want to override this assumption = No
i will assume that i have no losses carried forward from prior years ( NOL) coming into the valuation. If i have a money losing company, i m
Do i want to override this assumption = No
If yes, enter the NOL that i are carrying over into year 1 $0.00
i will asssume that today's risk free rate will prevail in perpetuity. If i override this assumption, I will change the riskfree rate after year 10.
Do i want to override this assumption = No If yes, i will be asked to enter a normal ris
If yes, enter the riskfree rate after year 10 0.00% Enter ir estimate of what the riskfree rate
i will assume that the growth rate in perpetuity will be equal to the risk free rate. This allows for both valuation consistency and prevents "im
Do i want to override this assumption = No This is an option to let i use a negative gro
If yes, enter the growth rate in perpetuity 0.00% This can be negative, if i feel the company
i have assumed that none of the cash is trapped (in foreign countries) and that there is no additional tax liability coming due and that cash is a neutral ass
Do i want to override this assumption No
If yes, enter trapped cash (if taxes) or entire balance (if mistrust) $0.00 Cash that is trapped in foreign markets (and su
& Average tax rate of the foreign markets where the cash is trapped 15% Additional tax rate due on trapped cash or disc
m ir base year below ( in consistent units)
de this assumption, I will leave the tax rate at ir effective tax rate.
that is trapped in foreign markets (and subject to additoinal tax) or cash that is being discounted by the market (because of management mistrust)
ional tax rate due on trapped cash or discount being applied to cash balance because of mistrust.
& 58), i should incorporate the change into ir stable cost of capital estimate.
rate, i are on ir own in uncharted territory.
gement mistrust)
Jul- Dec 21 Jan-June 22 Jul- Dec 22
Jan-Jun 1 2 3
Indian Health Insurance Growth 2.96% 3.50% 3.50%
Total Health insurance ### ₹ 531,645,749,220.29 ₹ 550,253,350,443.00 ₹ 569,512,217,708.50
Market Share 0.10% 0.13% 0.16% 0.19%
Gross Order Value ₹ 530,879,198.00 ₹ 703,081,744.38 ₹ 889,675,548.10 ₹ 1,088,469,642.95
Revenue as % of GOV 3.28% 3.50% 3.50% 3.50%
Revenues ₹ 17,428,696.00 ₹ 24,607,861.05 ₹ 31,138,644.18 ₹ 38,096,437.50
EBIT (Operating) margin 19.22% 20.00% 23.75% 25.63%
EBIT (Operating income) ₹ 3,349,856.00 ₹ 4,921,572.21 ₹ 7,395,427.99 ₹ 9,762,212.11
Tax rate 30.00% 30.00% 30.00% 30.00%
EBIT(1-t) ₹ 2,344,899.20 ₹ 3,445,100.55 ₹ 5,176,799.60 ₹ 6,833,548.48
- Reinvestment ₹ 4,786,110.04 ₹ 2,612,313.25 ₹ 2,783,117.33
FCFF -₹ 1,341,009.49 ₹ 2,564,486.34 ₹ 4,050,431.15
NOL ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00
6000000
₹ 50,000,000
5000000
₹ 40,000,000 4000000
3000000
₹ 30,000,000
2000000
₹ 20,000,000
1000000
₹ 10,000,000 0
1 2 3 4 5 6
-1000000
₹0
1 2 3 4 5 6 7 8 9 10 11 -2000000
VALUATION DIAGNOSTICS
Invested capital at start of valuation ₹ 35,000,000.00
Invested capital at end of valuation ₹ 54,573,262.14
Change in invested capital over 10 y ₹ 19,573,262.14
Change in EBIT*(1–t) (after-tax oper ₹ 19,326,736.15
Marginal ROIC over 10 years 98.74%
ROIC at end of valuation 29.09%
Average WACC over the 10 years ( 11.09%
Jan-June 23 Jul- Dec 23 Jan-June 24 Jul- Dec 24 Jan-June 25 Jul- Dec 25
4 5 6 7 8 9
3.50% 3.50% 3.65% 3.80% 3.95% 4.10%
₹ 589,445,145,328.30 ₹ 610,075,725,414.79 ### ₹ 656,372,541,989.34 ₹ 682,299,257,397.92 ₹ 710,273,526,951.24
0.22% 0.25% 0.25% 0.25% 0.25% 0.25%
₹ 1,300,089,471.89 ₹ 1,525,189,313.54 ₹ 1,580,858,723.48 ₹ 1,640,931,354.97 ₹ 1,705,748,143.49 ₹ 1,775,683,817.38
3.50% 3.50% 3.50% 3.50% 3.50% 3.50%
₹ 45,503,131.52 ₹ 53,381,625.97 ₹ 55,330,055.32 ₹ 57,432,597.42 ₹ 59,701,185.02 ₹ 62,148,933.61
27.50% 29.38% 31.06% 33.03% 35.00% 35.00%
₹ 12,513,361.17 ₹ 15,680,852.63 ₹ 17,182,796.80 ₹ 18,968,576.09 ₹ 20,895,414.76 ₹ 21,752,126.76
30.00% 30.00% 30.00% 30.00% 30.00% 30.00%
₹ 8,759,352.82 ₹ 10,976,596.84 ₹ 12,027,957.76 ₹ 13,278,003.26 ₹ 14,626,790.33 ₹ 15,226,488.73
₹ 2,962,677.61 ₹ 2,626,164.82 ₹ 649,476.45 ₹ 700,847.37 ₹ 756,195.87 ₹ 815,916.20
₹ 5,796,675.21 ₹ 8,350,432.02 ₹ 11,378,481.31 ₹ 12,577,155.89 ₹ 13,870,594.46 ₹ 14,410,572.54
₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00
-2000000 ₹-
1 2 3 4 5 6 7 8 9 10 11 12
Jan-June 26 Jul- Dec 26
10 Terminal year
4.25% 4.25%
₹ 740,460,151,846.66 ₹ 771,929,708,300.15
0.25% 0.25%
₹ 1,851,150,379.62 ₹ 1,929,824,270.75
3.50% 3.50%
₹ 64,790,263.29 ₹ 67,543,849.48
35.00% 35.00%
₹ 22,676,592.15 ₹ 23,640,347.32 ₹ 20,290,491.32 This is is how much we operating income grew
over the ten-year period.
30.00% 30.00%
₹ 15,873,614.51 ₹ 16,548,243.12
₹ 880,443.23 ₹ 7,840,583.42 ₹ 27,413,845.56 This is how much capital we
invested over the ten year period.
₹ 14,993,171.28 ₹ 8,707,659.70
₹ 0.00 ₹ 0.00
8.97% 8.97%
0.3495
5239813.41616677
After year 10
3.00
₹ 54,573,262.14
29.09% 8.97%
Claim Buddy
The Story
Claim Buddy will benefit as the Indian Health Insurance market grows, driven by overall econom
will be a near term COVID bouncecback effect. Tthe company will continue to reinvest (acquisit
of failure is low.
The Assumptions
The Value
he Story
ows, driven by overall economic growth and more digital access.There
continue to reinvest (acquisitions and technology) as it grows. The risk
Assumptions
3.50%
Cash Flows
he Value
3.49% 18.00%
1.55% 25.00%
0.00% 30.00% 10.00%
0.38% 25.00%
2.91% 20.00%
2.91% 0.00% 5.00%
5.33% 0.00%
3.49% 25.00%
7.26% 5.50% 0.00%
Abu Dhabi Bermuda Cook Islands Georgia Isle of Man Lithuan
6.30% 18.00%
0.59% 29.00% Equity Risk Premium Country R
9.68% 28.25%
5.33% 30.00%
0.82% 0.00%
5.33% 25.00%
6.30% 10.00%
0.82% 22.00%
2.91% 34.00%
3.31% 16.98%
0.82% 0.00%
1.55% 10.00%
5.33% 28.00%
5.33% 20.00%
5.33% 33.00%
0.00% 26.50%
5.33% 0.00%
0.59% 0.00%
0.68% 27.00%
0.68% 25.00%
1.84% 32.00%
7.26% 35.00%
8.72% 30.00%
4.36% 28.43%
5.33% 30.00%
2.42% 18.00%
8.72% 27.36%
1.16% 22.00%
2.91% 12.50%
0.59% 19.00%
0.00% 22.00%
3.49% 27.00%
9.68% 25.00%
5.33% 22.50%
6.30% 30.00%
0.68% 20.00%
5.33% 30.00%
3.49% 20.00%
0.38% 20.00%
0.48% 28.00%
7.26% 30.00%
6.30% 31.00%
2.91% 15.00%
0.00% 30.00%
6.30% 25.00%
3.49% 24.00%
2.42% 25.00%
0.00% 0.00%
11.62% 28.25%
7.26% 28.25%
5.33% 27.36%
11.62% 27.36%
4.36% 25.00%
0.59% 16.50%
2.13% 9.00%
0.82% 20.00%
2.13% 30.00%
1.84% 15.00%
8.72% 21.13%
7.26% 15.00%
0.82% 12.50%
0.59% 0.00%
0.68% 23.00%
2.13% 24.00%
3.49% 25.00%
5.33% 25.00%
0.68% 30.62%
0.00% 0.00%
4.36% 20.00%
2.13% 20.00%
5.33% 30.00%
11.62% 21.13%
0.68% 15.00%
5.33% 10.00%
1.16% 21.13%
1.16% 20.00%
19.18% 17.00%
11.62% 28.25%
8.72% 20.00%
0.00% 12.50%
1.16% 15.00%
0.00% 24.94%
0.59% 12.00%
3.49% 10.00%
6.30% 20.00%
8.72% 30.00%
1.16% 24.00%
7.26% 28.25%
0.82% 35.00%
1.55% 15.00%
1.55% 30.00%
6.30% 12.00%
6.30% 25.00%
4.36% 9.00%
2.13% 21.13%
2.42% 31.00%
8.72% 32.00%
6.30% 25.00%
3.49% 32.00%
0.00% 25.00%
0.00% 28.00%
6.30% 30.00%
6.30% 28.25%
5.33% 30.00%
0.00% 22.00%
3.49% 15.00%
6.30% 35.00%
1.55% 25.00%
5.33% 30.00%
2.42% 10.00%
1.16% 29.50%
1.84% 30.00%
0.82% 19.00%
2.13% 21.00%
0.59% 10.00%
0.00% 0.00%
2.13% 16.00%
2.13% 20.00%
5.33% 30.00%
3.31% 16.98%
0.68% 20.00%
3.49% 30.00%
3.49% 15.00%
1.84% 0.00%
8.72% 30.00%
0.00% 17.00%
0.82% 21.00%
1.16% 19.00%
6.30% 30.00%
11.62% 28.25%
2.91% 28.00%
0.48% 25.00%
1.55% 25.00%
7.26% 28.00%
2.13% 27.36%
6.30% 27.36%
19.18% 35.00%
9.68% 36.00%
6.30% 27.50%
0.00% 21.40%
0.00% 14.84%
19.18% 28.00%
0.59% 20.00%
6.30% 19.12%
5.33% 30.00%
1.55% 20.00%
6.30% 28.25%
2.42% 30.00%
5.33% 25.00%
5.33% 22.00%
1.55% 0.00%
5.33% 30.00%
6.30% 18.00%
0.48% 55.00%
0.59% 19.00%
0.00% 27.00%
4.36% 25.00%
19.18% 34.00%
3.49% 20.00%
19.18% 28.25%
11.62% 35.00%
11.62% 24.00%
CRP
4.94%
1.03%
0.00%
5.31%
3.99%
2.08%
1.53%
0.00%
0.84%
1.04%
nds Georgia Isle of Man Lithuania Netherlands Rwanda Suriname Uruguay