Mr.
Ramesh Nayak
Calculation of HLV
Particulars Amount
Gross Salary 1,800,000
Less: Monthly Household Expense 840,000
Net Annual Income 960,000
Number of Years Earning Span(n) 20 Retirement age - Current age
Discount Rate 6% r
HLV 11,671,791.83 =D6*((1-(1/(1+D9)^D8))/D9)*(1+D9)
Less: Existing Insurance 1,000,000
Less: Current Assets 800,000
Additional Insurance Required 9,871,792
Note: PMT x (1- 1/(1+ r)n ) / r x (1 + r)
Ramesh Nayak
Calculation of Need Approach
Need PV
Childern's Higher Education 5,000,000 R 6%
Daughter's Marriage 1,500,000
Retirement Corpus 20,000,000
Total Value of Future Needs 26,500,000
PV of Future Needs 8,262,825 =K8*(1/(1+N5)^20)
D8))/D9)*(1+D9)
PV of Monthly Household Exp 9,634,734 =(70000*12)*(1-1/(1+N5)^20)/N5
Outstanding Home Loan 3,000,000
Total Value of Needs 20,897,559
Less: Current Assets 800,000
Less: Existing Insurance 1,000,000
Insurance Needs 19,097,559 =K14-K15-K16
1+N5)^20)/N5
ULIP COMPUTATION- LIC NIVESH PLUS(Growth Fund)
Years Premium NAV Units Allocated Cummulative Units Gross Fund Value FMC
2025 100000 21.11 4736.87 4736.87 100000.00 1450.00
2026 100000 22.80 4385.99 9122.86 208000.00 3016.00
2027 100000 24.62 4061.10 13183.96 324640.00 4707.28
2028 100000 26.59 3760.28 16944.23 450611.20 6533.86
2029 100000 28.72 3481.74 20425.97 586660.10 8506.57
2030 100000 31.02 3223.83 23649.80 733592.90 10637.10
2031 100000 33.50 2985.03 26634.83 892280.34 12938.06
2032 100000 36.18 2763.92 29398.75 1063662.76 15423.11
2033 100000 39.07 2559.18 31957.93 1248755.78 18106.96
2034 100000 42.20 2369.61 34327.54 1448656.25 21005.52
h Fund)
Mortality Charges Fund Value
1250.00 97300.00
1250.00 203734.00
1250.00 318682.72
1250.00 442827.34
1250.00 576903.52
1250.00 721705.81
1250.00 878092.27
1250.00 1046989.65
1250.00 1229398.83
1250.00 1426400.73
HLV COMPUTATION FOR ROY COUPLE
[Link] Roy
Particulars Amount
Annual Salary 1,200,000
Less: Joint Annual Household Exp 37,500
Less: Joint Home Loan EmI 17,500
Net Annual Income 1,145,000
Discounting Rate 0.06
Number of years (n) 25
HLV 15,515,159 =C8*(1-(1/(1+C10)^C11))/C10*(1+C10)
Existing Insurance 500,000
Current Assets 400,000
Additional Insurance Required 14,615,159
Note: PMT x (1- 1/(1+ r)n ) / r x (1 + r)
ROY COUPLE
[Link] Roy
Particulars Amount
Annual Salary 1,000,000
Less: Joint Annual Household Exp 37,500
Less: Joint Home Loan EmI 17,500
Net Annual Income 945,000
Discounting Rate 0.06
Number of years (n) 26
HLV 13,025,272 =J8*(1-(1/(1+J10)^J11))/J10*(1+J10)
Existing Insurance -
Current Assets 400,000
Additional Insurance Required 12,625,272
r)n ) / r x (1 + r)
NEED APPROACH COMPUTATION FOR ROY COUPLE
Need PV
Buying bigger home in 7 years 50,000,000 r=
Family Expenses 3,000,000
Retirement Corpus 10,000,000
Total Future Needs 63,000,000
PV of Future Needs 14,678,913.72 =D8*(1/(1+G5)^25)
PV of Monthly Household Exp 11,505,021
Total Needs 26,183,934
Less: Current Assets 800,000
Less: Existing Insurance 500,000
Insurance Needs 24,883,934 =D13-D14-D15
6%
ULIP COMPUTATION- AXIS MAX LIFE INSURANCE(Hight Growth Fu
Years Premium NAV Units Allocated Cummulative Units Gross Fund Value
2025 100500 114.77 875.664 875.664 100500.00
2026 100500 123.952 810.800 1686.465 209040.00
2027 100500 133.868 750.741 2437.206 326263.20
2028 100500 144.577 695.131 3132.336 452864.26
2029 100500 156.143 643.639 3775.976 589593.40
2030 100500 168.635 595.962 4371.938 737260.87
2031 100500 182.126 551.817 4923.755 896741.74
2032 100500 196.696 510.942 5434.697 1068981.08
2033 100500 212.431 473.094 5907.791 1254999.56
2034 100501 229.426 438.055 6345.846 1455900.53
RANCE(Hight Growth Fund)
FMC Mortality Charges Fund Value
1457.25 1250.00 97792.75
3031.08 1250.00 204758.92
4730.82 1250.00 320282.38
6566.53 1250.00 445047.72
8549.10 1250.00 579794.29
10690.28 1250.00 725320.59
13002.76 1250.00 882488.98
15500.23 1250.00 1052230.85
18197.49 1250.00 1235552.07
21110.56 1251.00 1433538.97
