PPF CalculatorPrepared by: Karthikeyan Chellappa

Input Parameters CalculationsInvestment Frequency Annual PPF Interest RateInvestment Amount ₹ 745

Year 1Month DepositApr 745May 0Jun 0Jul 0Aug 0Sep 0Oct 0Nov 0Dec 0Jan 0Feb 0Mar 0Year End Balance

Year 2Month DepositApr 745May 0Jun 0Jul 0Aug 0Sep 0Oct 0Nov 0Dec 0Jan 0Feb 0Mar 0Year End Balance

Year 3Month DepositApr 745

Choose your investment frequency and the investment amount

Choose your investment frequency and the investment amount

May 0Jun 0Jul 0Aug 0Sep 0Oct 0Nov 0Dec 0Jan 0Feb 0Mar 0Year End Balance

Year 4Month DepositApr 745May 0Jun 0Jul 0Aug 0Sep 0Oct 0Nov 0Dec 0Jan 0Feb 0Mar 0Year End Balance

Year 5Month DepositApr 745May 0Jun 0Jul 0Aug 0Sep 0Oct 0Nov 0Dec 0Jan 0Feb 0Mar 0Year End Balance

Year 6Month Deposit

Apr 745May 0Jun 0Jul 0Aug 0Sep 0Oct 0Nov 0Dec 0Jan 0Feb 0Mar 0Year End Balance

Year 7Month DepositApr 745May 0Jun 0Jul 0Aug 0Sep 0Oct 0Nov 0Dec 0Jan 0Feb 0Mar 0Year End Balance

Year 8Month DepositApr 745May 0Jun 0Jul 0Aug 0Sep 0Oct 0Nov 0Dec 0Jan 0Feb 0Mar 0Year End Balance

Year 9

Month DepositApr 745May 0Jun 0Jul 0Aug 0Sep 0Oct 0Nov 0Dec 0Jan 0Feb 0Mar 0Year End Balance

Year 10Month DepositApr 745May 0Jun 0Jul 0Aug 0Sep 0Oct 0Nov 0Dec 0Jan 0Feb 0Mar 0Year End Balance

Year 11Month DepositApr 745May 0Jun 0Jul 0Aug 0Sep 0Oct 0Nov 0Dec 0Jan 0Feb 0Mar 0Year End Balance

Year 12Month DepositApr 745May 0Jun 0Jul 0Aug 0Sep 0Oct 0Nov 0Dec 0Jan 0Feb 0Mar 0Year End Balance

Year 13Month DepositApr 745May 0Jun 0Jul 0Aug 0Sep 0Oct 0Nov 0Dec 0Jan 0Feb 0Mar 0Year End Balance

Year 14Month DepositApr 745May 0Jun 0Jul 0Aug 0Sep 0Oct 0Nov 0Dec 0Jan 0Feb 0Mar 0Year End Balance

Year 15Month DepositApr 745May 0Jun 0Jul 0Aug 0Sep 0Oct 0Nov 0Dec 0Jan 0Feb 0Mar 0Year End Balance

PPF CalculatorPrepared by: Karthikeyan Chellappa

Calculations Output ValuesPPF Interest Rate 8.70% Maturity Amount ₹ 23,232

Year 1Balance Interest

745 5745 5745 5745 5745 5745 5745 5745 5745 5745 5745 5745 5810

Year 2Balance Interest

1,555 111,555 111,555 111,555 111,555 111,555 111,555 111,555 111,555 111,555 111,555 111,555 111,691

Year 3Balance Interest

2,436 18

The maturity amount is what you will get after 15 years

The maturity amount is what you will get after 15 years

2,436 182,436 182,436 182,436 182,436 182,436 182,436 182,436 182,436 182,436 182,436 182,648

Year 4Balance Interest

3,393 253,393 253,393 253,393 253,393 253,393 253,393 253,393 253,393 253,393 253,393 253,393 253,688

Year 5Balance Interest

4,434 324,434 324,434 324,434 324,434 324,434 324,434 324,434 324,434 324,434 324,434 324,434 324,819

Year 6Balance Interest

5,565 405,565 405,565 405,565 405,565 405,565 405,565 405,565 405,565 405,565 405,565 405,565 406,049

Year 7Balance Interest

6,794 496,794 496,794 496,794 496,794 496,794 496,794 496,794 496,794 496,794 496,794 496,794 497,385

Year 8Balance Interest

8,130 598,130 598,130 598,130 598,130 598,130 598,130 598,130 598,130 598,130 598,130 598,130 598,838

Year 9

Balance Interest9,583 699,583 699,583 699,583 699,583 699,583 699,583 699,583 699,583 699,583 699,583 699,583 69

10,417

Year 10Balance Interest

11,162 8111,162 8111,162 8111,162 8111,162 8111,162 8111,162 8111,162 8111,162 8111,162 8111,162 8111,162 8112,133

Year 11Balance Interest

12,878 9312,878 9312,878 9312,878 9312,878 9312,878 9312,878 9312,878 9312,878 9312,878 9312,878 9312,878 9313,999

Year 12Balance Interest

14,744 10714,744 10714,744 10714,744 10714,744 10714,744 10714,744 10714,744 10714,744 10714,744 10714,744 10714,744 10716,027

Year 13Balance Interest

16,772 12216,772 12216,772 12216,772 12216,772 12216,772 12216,772 12216,772 12216,772 12216,772 12216,772 12216,772 12218,231

Year 14Balance Interest

18,976 13818,976 13818,976 13818,976 13818,976 13818,976 13818,976 13818,976 13818,976 13818,976 13818,976 13818,976 13820,627

Year 15Balance Interest

21,373 15521,373 15521,373 15521,373 15521,373 15521,373 15521,373 15521,373 15521,373 15521,373 15521,373 15521,373 15523,232

23232

PPF Tracker

Enter data only in green cells

Balance on March 31st of current yearSet as zero for new accounts

* For existing account, "Year 1" Year 1*simply refers to first year of tracking Month Deposit

Apr 5,000May 5,000Jun 5,000Jul 5,000Aug 5,000Sep 5,000Oct 5,000Nov 5,000Dec 5,000Jan 5,000Feb 5,000Mar 5,000Year End Balance

Year 2Month DepositApr 5,000May 5,000Jun 5,000Jul 5,000Aug 5,000Sep 5,000Oct 5,000Nov 5,000Dec 5,000Jan 5,000Feb 5,000Mar 5,000Year End Balance

Loan available for new accounts Year 3Amount available 15706.875 Month Deposit

Apr 5,000

May 5,000Jun 5,000Jul 5,000Aug 5,000Sep 5,000Oct 5,000Nov 5,000Dec 5,000Jan 5,000Feb 5,000Mar 5,000Year End Balance

Loan available for new accounts Year 4Amount available 32780.2481 Month Deposit

Apr 5,000May 5,000Jun 5,000Jul 5,000Aug 5,000Sep 5,000Oct 5,000Nov 5,000Dec 5,000Jan 5,000Feb 5,000Mar 5,000Year End Balance

Loan available for new accounts Year 5Amount available 51339.0047 Month Deposit

Apr 5,000May 5,000Jun 5,000Jul 5,000Aug 5,000Sep 5,000Oct 5,000Nov 5,000Dec 5,000Jan 5,000Feb 5,000Mar 5,000Year End Balance

Loan available for new accounts Year 6Amount available 71512.3731 Month Deposit

Apr 5,000May 5,000Jun 5,000Jul 5,000Aug 5,000Sep 5,000Oct 5,000Nov 5,000Dec 5,000Jan 5,000Feb 5,000Mar 5,000Year End Balance

Loan available for new accounts Year 7Amount available 93440.8246 Month Deposit

Apr 5,000Withdrawal limit 143024.746 May 5,000

Jun 5,000Jul 5,000Aug 5,000Sep 5,000Oct 5,000Nov 5,000Dec 5,000Jan 5,000Feb 5,000Mar 5,000Year End Balance

Year 8Month DepositApr 5,000

Withdrawal limit 186881.649 May 5,000Jun 5,000Jul 5,000Aug 5,000Sep 5,000Oct 5,000Nov 5,000Dec 5,000Jan 5,000Feb 5,000Mar 5,000Year End Balance

Year 9

Month DepositApr 5,000

Withdrawal limit 234554.103 May 5,000Jun 5,000Jul 5,000Aug 5,000Sep 5,000Oct 5,000Nov 5,000Dec 5,000Jan 5,000Feb 5,000Mar 5,000Year End Balance

Year 10Month DepositApr 5,000

Withdrawal limit 286374.06 May 5,000Jun 5,000Jul 5,000Aug 5,000Sep 5,000Oct 5,000Nov 5,000Dec 5,000Jan 5,000Feb 5,000Mar 5,000Year End Balance

Year 11Month DepositApr 5,000

Withdrawal limit 342702.353 May 5,000Jun 5,000Jul 5,000Aug 5,000Sep 5,000Oct 5,000Nov 5,000Dec 5,000Jan 5,000Feb 5,000Mar 5,000Year End Balance

Year 12Month DepositApr 5,000

Withdrawal limit 403931.207 May 5,000Jun 5,000Jul 5,000Aug 5,000Sep 5,000Oct 5,000Nov 5,000Dec 5,000Jan 5,000Feb 5,000Mar 5,000Year End Balance

Year 13Month DepositApr 5,000

Withdrawal limit 470486.972 May 5,000Jun 5,000Jul 5,000Aug 5,000Sep 5,000Oct 5,000Nov 5,000Dec 5,000Jan 5,000Feb 5,000Mar 5,000Year End Balance

Year 14Month DepositApr 5,000

Withdrawal limit 542833.089 May 5,000Jun 5,000Jul 5,000Aug 5,000Sep 5,000Oct 5,000Nov 5,000Dec 5,000Jan 5,000Feb 5,000Mar 5,000Year End Balance

Year 15Month DepositApr 5,000

Withdrawal limit 621473.318 May 5,000Jun 5,000Jul 5,000Aug 5,000Sep 5,000

If you wish to extend the PPF account for a block Oct 5,000of 5 years, copy the cells within the red rectangle Nov 5,000select cell H252 (one line space between years) and Dec 5,000paste. Change the entires in the interest rate Jan 5,000column to refelct the new interest rate. Feb 5,000Send me an email if you need assistance Mar 5,000

Year End Balance

PPF Tracker

Balance on March 31st of current yearSet as zero for new accounts

Year 1*Balance Interest PPF Interest Rate

5,000 36 8.70%10,000 72 PPF investment limit15,000 109 15000020,000 14525,000 18130,000 21835,000 25440,000 29045,000 32650,000 36355,000 39960,000 43562,828

Year 2Balance Interest PPF Interest Rate

67,828 492 8.70%72,828 528 PPF investment limit77,828 564 15000082,828 60087,828 63792,828 67397,828 709

102,828 745107,828 782112,828 818117,828 854122,828 890131,121

Year 3Balance Interest PPF Interest Rate

136,121 987 8.70%

141,121 1,023 PPF investment limit146,121 1,059 150000151,121 1,096156,121 1,132161,121 1,168166,121 1,204171,121 1,241176,121 1,277181,121 1,313186,121 1,349191,121 1,386205,356

Year 4Balance Interest PPF Interest Rate

210,356 1,525 8.70%215,356 1,561 PPF investment limit220,356 1,598 150000225,356 1,634230,356 1,670235,356 1,706240,356 1,743245,356 1,779250,356 1,815255,356 1,851260,356 1,888265,356 1,924286,049

Year 5Balance Interest PPF Interest Rate

291,049 2,110 8.70%296,049 2,146 PPF investment limit301,049 2,183 150000306,049 2,219311,049 2,255316,049 2,291321,049 2,328326,049 2,364331,049 2,400336,049 2,436341,049 2,473346,049 2,509373,763

Year 6Balance Interest PPF Interest Rate

378,763 2,746 8.70%383,763 2,782 PPF investment limit388,763 2,819 150000393,763 2,855398,763 2,891403,763 2,927408,763 2,964413,763 3,000418,763 3,036423,763 3,072428,763 3,109433,763 3,145469,108

Year 7Balance Interest PPF Interest Rate

474,108 3,437 8.70%479,108 3,474 PPF investment limit484,108 3,510 150000489,108 3,546494,108 3,582499,108 3,619504,108 3,655509,108 3,691514,108 3,727519,108 3,764524,108 3,800 Amount Withdrawn529,108 3,836572,748

Year 8Balance Interest PPF Interest Rate

577,748 4,189 8.70%582,748 4,225 PPF investment limit587,748 4,261 150000592,748 4,297597,748 4,334602,748 4,370607,748 4,406612,748 4,442617,748 4,479622,748 4,515627,748 4,551 Amount Withdrawn632,748 4,587685,405

Year 9

Balance Interest PPF Interest Rate690,405 5,005 8.70%695,405 5,042 PPF investment limit700,405 5,078 150000705,405 5,114710,405 5,150715,405 5,187720,405 5,223725,405 5,259730,405 5,295735,405 5,332740,405 5,368 Amount Withdrawn745,405 5,404807,862

Year 10Balance Interest PPF Interest Rate

812,862 5,893 8.70%817,862 5,930 PPF investment limit822,862 5,966 150000827,862 6,002832,862 6,038837,862 6,075842,862 6,111847,862 6,147852,862 6,183857,862 6,220862,862 6,256 Amount Withdrawn867,862 6,292940,974

Year 11Balance Interest PPF Interest Rate

945,974 6,858 8.70%950,974 6,895 PPF investment limit955,974 6,931 150000960,974 6,967965,974 7,003970,974 7,040975,974 7,076980,974 7,112985,974 7,148990,974 7,185995,974 7,221 Amount Withdrawn

1,000,974 7,2571,085,666

Year 12Balance Interest PPF Interest Rate

1,090,666 7,907 8.70%1,095,666 7,944 PPF investment limit1,100,666 7,980 1500001,105,666 8,0161,110,666 8,0521,115,666 8,0891,120,666 8,1251,125,666 8,1611,130,666 8,1971,135,666 8,2341,140,666 8,270 Amount Withdrawn1,145,666 8,3061,242,947

Year 13Balance Interest PPF Interest Rate

1,247,947 9,048 8.70%1,252,947 9,084 PPF investment limit1,257,947 9,120 1500001,262,947 9,1561,267,947 9,1931,272,947 9,2291,277,947 9,2651,282,947 9,3011,287,947 9,3381,292,947 9,3741,297,947 9,410 Amount Withdrawn1,302,947 9,4461,413,910

Year 14Balance Interest PPF Interest Rate

1,418,910 10,287 8.70%1,423,910 10,323 PPF investment limit1,428,910 10,360 1500001,433,910 10,3961,438,910 10,4321,443,910 10,4681,448,910 10,5051,453,910 10,5411,458,910 10,5771,463,910 10,6131,468,910 10,650 Amount Withdrawn1,473,910 10,6861,599,748

Year 15Balance Interest PPF Interest Rate

1,604,748 11,634 8.70%1,609,748 11,671 PPF investment limit1,614,748 11,707 1500001,619,748 11,7431,624,748 11,7791,629,748 11,8161,634,748 11,8521,639,748 11,8881,644,748 11,9241,649,748 11,9611,654,748 11,997 Amount Withdrawn1,659,748 12,0331,801,754

Goal CalculatorDetermine the fixed investment need to obtain a certina maturity value

Step 1 Enter maturity value required 23,232 Enter current investment limit

Step 2 Go to PPF Calculator sheet. Select investment frequency and the interest rate

Step 3

Fixed investment amount for the selected is 745

Click on me!Click on me!

150,000