Calculate the coverage your family truly needs with an income replacement model that projects earnings adjusts for taxes and personal spending discounts to present value and factors in debts savings education goals and existing policies includes yearly breakdown sensitivity inputs example data CSV export and instant PDF download plus detailed notes transparent assumptions explained
# | Age | Projected Income (PKR) | After Tax | Family Share | Discount Factor | PV This Year | Cumulative PV |
---|---|---|---|---|---|---|---|
1 | 36 | 2,500,000.00 | 2,250,000.00 | 1,575,000.00 | 1.0600 | 1,485,849.06 | 1,485,849.06 |
2 | 37 | 2,600,000.00 | 2,340,000.00 | 1,638,000.00 | 1.1236 | 1,457,814.17 | 2,943,663.23 |
3 | 38 | 2,704,000.00 | 2,433,600.00 | 1,703,520.00 | 1.1910 | 1,430,308.24 | 4,373,971.47 |
4 | 39 | 2,812,160.00 | 2,530,944.00 | 1,771,660.80 | 1.2625 | 1,403,321.29 | 5,777,292.76 |
5 | 40 | 2,924,646.40 | 2,632,181.76 | 1,842,527.23 | 1.3382 | 1,376,843.53 | 7,154,136.29 |
6 | 41 | 3,041,632.26 | 2,737,469.03 | 1,916,228.32 | 1.4185 | 1,350,865.35 | 8,505,001.65 |
7 | 42 | 3,163,297.55 | 2,846,967.79 | 1,992,877.45 | 1.5036 | 1,325,377.33 | 9,830,378.97 |
8 | 43 | 3,289,829.45 | 2,960,846.50 | 2,072,592.55 | 1.5938 | 1,300,370.21 | 11,130,749.18 |
9 | 44 | 3,421,422.63 | 3,079,280.36 | 2,155,496.25 | 1.6895 | 1,275,834.92 | 12,406,584.10 |
10 | 45 | 3,558,279.53 | 3,202,451.58 | 2,241,716.10 | 1.7908 | 1,251,762.56 | 13,658,346.67 |
11 | 46 | 3,700,610.71 | 3,330,549.64 | 2,331,384.75 | 1.8983 | 1,228,144.40 | 14,886,491.07 |
12 | 47 | 3,848,635.14 | 3,463,771.63 | 2,424,640.14 | 2.0122 | 1,204,971.87 | 16,091,462.94 |
13 | 48 | 4,002,580.55 | 3,602,322.49 | 2,521,625.74 | 2.1329 | 1,182,236.55 | 17,273,699.48 |
14 | 49 | 4,162,683.77 | 3,746,415.39 | 2,622,490.77 | 2.2609 | 1,159,930.20 | 18,433,629.68 |
15 | 50 | 4,329,191.12 | 3,896,272.01 | 2,727,390.40 | 2.3966 | 1,138,044.72 | 19,571,674.40 |
16 | 51 | 4,502,358.76 | 4,052,122.89 | 2,836,486.02 | 2.5404 | 1,116,572.18 | 20,688,246.59 |
17 | 52 | 4,682,453.11 | 4,214,207.80 | 2,949,945.46 | 2.6928 | 1,095,504.78 | 21,783,751.37 |
18 | 53 | 4,869,751.24 | 4,382,776.12 | 3,067,943.28 | 2.8543 | 1,074,834.88 | 22,858,586.25 |
19 | 54 | 5,064,541.29 | 4,558,087.16 | 3,190,661.01 | 3.0256 | 1,054,554.98 | 23,913,141.22 |
20 | 55 | 5,267,122.94 | 4,740,410.65 | 3,318,287.45 | 3.2071 | 1,034,657.71 | 24,947,798.94 |
21 | 56 | 5,477,807.86 | 4,930,027.07 | 3,451,018.95 | 3.3996 | 1,015,135.87 | 25,962,934.81 |
22 | 57 | 5,696,920.17 | 5,127,228.15 | 3,589,059.71 | 3.6035 | 995,982.36 | 26,958,917.17 |
23 | 58 | 5,924,796.98 | 5,332,317.28 | 3,732,622.10 | 3.8197 | 977,190.24 | 27,936,107.41 |
24 | 59 | 6,161,788.86 | 5,545,609.97 | 3,881,926.98 | 4.0489 | 958,752.69 | 28,894,860.10 |
25 | 60 | 6,408,260.41 | 5,767,434.37 | 4,037,204.06 | 4.2919 | 940,663.02 | 29,835,523.12 |
Total PV to Family | PKR 29,835,523.12 |
Scenario | Age | Retires | Income | Growth % | Tax % | Consumption % | Discount % | Immediate | Education | Savings | Existing Cover |
---|---|---|---|---|---|---|---|---|---|---|---|
Balanced | 35 | 60 | 2,500,000 | 4.0 | 10.0 | 30.0 | 6.0 | 500,000 | 1,500,000 | 300,000 | 2,000,000 |
High Growth | 30 | 60 | 1,800,000 | 7.0 | 8.0 | 25.0 | 6.0 | 400,000 | 2,000,000 | 250,000 | 1,200,000 |
Conservative | 40 | 58 | 3,200,000 | 3.0 | 12.0 | 35.0 | 7.0 | 600,000 | 1,000,000 | 500,000 | 3,000,000 |
Assumption | PV to Family (PKR) |
---|---|
Discount rate - 1% | 33,511,454.93 |
Discount rate + 1% | 26,713,147.05 |
Growth rate - 1% | 26,888,012.02 |
Growth rate + 1% | 33,229,969.98 |
Use this to see how sensitive the estimate is to economic assumptions.
Important Note: All the Calculators listed in this site are for educational purpose only and we do not guarentee the accuracy of results. Please do consult with other sources as well.