SWP Calculator With Inflation Excel : Here is SWP Calculator in excel sheet that helps investors to calculate their investment amount with inflation adjustes. This downloadable sheet is act like calculator in Excel sheet where one can do SWP calculation according to their need.
Lets start !
SWP Calculator With Inflation Excel Download Free
Click here for SWP Calculator With Inflation Excel absoultely free !
This is our Best SWP Calculator With Inflation in Excel sheet for the SWP (Systematic Withdrawal Plan) investors who are worrid about the inflation.
For Example , Suppose Mr Ram wants to invest 10,00,000 and wants to withdrwa money of 20000.00 per month, assume the inflation rate is 6% and return rate is 12%.
Note : this is just an example.
After using above info you will get this kind of data in excel sheet.
| Month | Remaining Balance (₹) | Withdrawal (₹) | Inflation-Adjusted Withdrawal (₹) |
|---|---|---|---|
| 1 | 989391.44 | 20000.00 | 20097.35 |
| 2 | 978584.40 | 20000.00 | 20195.18 |
| 3 | 967576.50 | 20000.00 | 20293.48 |
| 4 | 956365.38 | 20000.00 | 20392.26 |
| 5 | 944948.62 | 20000.00 | 20491.52 |
| 6 | 933323.78 | 20000.00 | 20591.26 |
| 7 | 921488.41 | 20000.00 | 20691.49 |
| 8 | 909440.01 | 20000.00 | 20792.21 |
| 9 | 897176.09 | 20000.00 | 20893.41 |
| 10 | 884694.09 | 20000.00 | 20995.11 |
| 11 | 871991.46 | 20000.00 | 21097.31 |
| 12 | 859065.61 | 20000.00 | 21200.00 |
| 13 | 845913.91 | 20000.00 | 21303.19 |
| 14 | 832533.73 | 20000.00 | 21406.89 |
| 15 | 818922.38 | 20000.00 | 21511.09 |
| 16 | 805077.18 | 20000.00 | 21615.79 |
| 17 | 790995.38 | 20000.00 | 21721.01 |
| 18 | 776674.23 | 20000.00 | 21826.74 |
| 19 | 762110.96 | 20000.00 | 21932.98 |
| 20 | 747302.73 | 20000.00 | 22039.74 |
| 21 | 732246.71 | 20000.00 | 22147.02 |
| 22 | 716940.03 | 20000.00 | 22254.82 |
| 23 | 701379.78 | 20000.00 | 22363.15 |
| 24 | 685563.03 | 20000.00 | 22472.00 |
| 25 | 669486.81 | 20000.00 | 22581.38 |
| 26 | 653148.13 | 20000.00 | 22691.30 |
| 27 | 636543.97 | 20000.00 | 22801.75 |
| 28 | 619671.26 | 20000.00 | 22912.74 |
| 29 | 602526.93 | 20000.00 | 23024.27 |
| 30 | 585107.84 | 20000.00 | 23136.34 |
| 31 | 567410.85 | 20000.00 | 23248.96 |
| 32 | 549432.77 | 20000.00 | 23362.12 |
| 33 | 531170.39 | 20000.00 | 23475.84 |
| 34 | 512620.44 | 20000.00 | 23590.11 |
| 35 | 493779.66 | 20000.00 | 23704.94 |
| 36 | 474644.71 | 20000.00 | 23820.32 |
| 37 | 455212.25 | 20000.00 | 23936.27 |
| 38 | 435478.89 | 20000.00 | 24052.78 |
| 39 | 415441.20 | 20000.00 | 24169.86 |
| 40 | 395095.73 | 20000.00 | 24287.50 |
| 41 | 374438.99 | 20000.00 | 24405.72 |
| 42 | 353467.44 | 20000.00 | 24524.52 |
| 43 | 332177.53 | 20000.00 | 24643.89 |
| 44 | 310565.64 | 20000.00 | 24763.85 |
| 45 | 288628.14 | 20000.00 | 24884.39 |
| 46 | 266361.36 | 20000.00 | 25005.52 |
| 47 | 243761.58 | 20000.00 | 25127.23 |
| 48 | 220825.04 | 20000.00 | 25249.54 |
| 49 | 197547.96 | 20000.00 | 25372.44 |
| 50 | 173926.51 | 20000.00 | 25495.94 |
| 51 | 149956.82 | 20000.00 | 25620.05 |
| 52 | 125634.97 | 20000.00 | 25744.75 |
| 53 | 100957.03 | 20000.00 | 25870.07 |
| 54 | 75919.00 | 20000.00 | 25995.99 |
| 55 | 50516.85 | 20000.00 | 26122.53 |
| 56 | 24746.51 | 20000.00 | 26249.68 |
| 57 | 0 | 20000.00 | 26377.45 |