Excel Calculator helps in making the right prediction on how to make investments that give a higher ROI. Public Provident Fund (PPF) is a financial account that offers a high interest on the amount deposited in the account along with the tax benefits. The ROI Calculation that the PPF Account provides can be evaluated using a PPF Account Calculator. This calculation can also be done on an Excel Calculator for PPF Account.
What is PPF Account?
PPF Stands for Public Provident Fund which is an account dedicated to the individual who wants to save money for their retirement. Introduced in the year 1968 by the National Saving Institute of the Ministry, this scheme’s aim was to provide the savings-cum tax savings banking tool to the people that can also benefit them in the retirement period. The Scheme is guaranteed by the Central Government that makes it the safest savings instrument to invest the money.
How to Use the PPF Excel Calculator?
PPF Account Excel Calculator is a very easy and effective tool to calculate the PPF Account Maturity amount, Monthly or Yearly payment structure, Maturity after 15, 20, 25, 30, and 35 years that easily determines the amount that you will get after investing the amount. You can use the PPF Account Excel Calculator by following these steps-
- Download the PPF Account Excel Calculator from the above link.
- An Excel Sheet will open containing a calculation with amount Rs.12,500 for 8.0% interest
- Simply enter the amount you want to calculate in the deposit amount tab and press enter.
- The Calculator will display the maturity amount after 15, 20, 25, 30, and 35 years.
- If the Interest rate changes then the interest rate can also be changed in the Interest slot.
Note:-The PPF Account Excel Calculate uses yearly deposit amount for the calculations for monthly PPF Account Calculation visit PPF Account Calculator.
Interest Rate on PPF Account
PPF Account offers an attractive interest rate that delivers the best investment tool for retirement. The current Interest rate as of 2019 offered by the PPF Account is 8% per annum calculated on a compound basis. The interest rate on the PPF Account changes every year and to keep track of the interest earned every year you can visit the Ask Bank PPF Account Calculator.
List of Bank Offering PPF Account
There are 23 banks that offer PPF Account. The list of banks offering PPF accounts is as follows-
- Allahabad Bank
- Andhra Bank
- Axis Bank
- Bank of Baroda
- Bank of India
- Bank of Maharashtra
- Canara Bank
- Central Bank of India
- Corporation Bank
- Dena Bank
- HDFC Bank
- ICICI Bank
- IDBI Bank
- Indian Bank
- Indian Overseas Bank
- Oriental Bank of Commerce
- Punjab and Sind Bank
- Punjab National Bank
- State Bank of India
- UCO Bank
- Union Bank of India
- United Bank of India
- Vijaya Bank
Should I Pay Monthly or Yearly?
A question might arise when presented with an option to deposit the amount on a monthly or yearly basis which makes you think what is the difference? In this example below, we will provide two PPF Account of the same amount one deposited annually and one deposited the same amount by splitting it into 12 parts with the monthly payment.
Monthly PPF Amount Payment
An amount of Rs.2000 is deposited per month to the PPF Account with an interest rate of 8.0% per annum. The maturity tenure of this account is for 15 years. The calculation of the final amount is as follows-
| Year | Deposit | Interest Earned | Closing Balance |
|---|---|---|---|
| 1 | 24,000.00 | 1,040.00 | 25,040.00 |
| 2 | 24,000.00 | 4,083.20 | 52,083.93 |
| 3 | 24,000.00 | 9,289.92 | 81,292.23 |
| 4 | 24,000.00 | 16,833.28 | 1,12,835.95 |
| 5 | 24,000.00 | 26,900.16 | 1,46,904.24 |
| 6 | 24,000.00 | 39,692.48 | 1,83,696.36 |
| 7 | 24,000.00 | 55,428.16 | 2,23,431.64 |
| 8 | 24,000.00 | 74,342.72 | 2,66,347.55 |
| 9 | 24,000.00 | 96,690.56 | 3,12,695.65 |
| 10 | 24,000.00 | 1,22,746.24 | 3,62,751.64 |
| 11 | 24,000.00 | 1,52,806.40 | 4,16,812.35 |
| 12 | 24,000.00 | 1,87,191.36 | 4,75,195.75 |
| 13 | 24,000.00 | 2,26,247.04 | 5,38,251.97 |
| 14 | 24,000.00 | 2,70,347.20 | 6,06,352.35 |
| 15 | 24,000.00 | 3,19,895.36 | 6,79,900.35 |
The following Calculation table shows us the maturity amount after 15 years on a deposit of Rs.2000 per month for 15 years at the rate of 8% per annum is Rs.6,79,900.35/-
Yearly PPF Amount Payment
An amount of Rs.24000 is deposited per year to the PPF Account with an interest rate of 8.0% per annum. The maturity tenure of this account is for 15 years. The calculation of the final amount is as follows-
| Year | Deposit | Interest Earned | Closing Balance |
|---|---|---|---|
| 1 | 24,000.00 | 1,920.00 | 25,920.00 |
| 2 | 24,000.00 | 3,993.60 | 53,913.60 |
| 3 | 24,000.00 | 6,233.12 | 84,147.12 |
| 4 | 24,000.00 | 8,651.76 | 1,16,798.76 |
| 5 | 24,000.00 | 11,263.92 | 1,52,062.92 |
| 6 | 24,000.00 | 14,085.04 | 1,90,148.04 |
| 7 | 24,000.00 | 17,131.84 | 2,31,279.84 |
| 8 | 24,000.00 | 20,422.40 | 2,75,702.40 |
| 9 | 24,000.00 | 23,976.16 | 3,23,678.16 |
| 10 | 24,000.00 | 27,814.24 | 3,75,492.24 |
| 11 | 24,000.00 | 31,959.36 | 4,31,451.36 |
| 12 | 24,000.00 | 36,436.08 | 4,91,887.08 |
| 13 | 24,000.00 | 41,270.96 | 5,57,157.96 |
| 14 | 24,000.00 | 46,492.64 | 6,27,650.64 |
| 15 | 24,000.00 | 52,132.08 | 7,03,783.08 |
The following Calculation table shows us the maturity amount after 15 years on a deposit of Rs.24000 per year for 15 years at the rate of 8% per annum is Rs.7,03,783.08/-
Comparing PPF Account On Monthly and Yearly Bases
In the comparison of both the tables, we can determine the amount that on the first year of the PPF Account the amount deposited is Rs.2000 and 24,000 for Monthly and yearly respectively. The interest earned in the first year is Rs. 1,040.00 and 1,920.00 Monthly and yearly respectively. There is a difference of Rs.880/- similarly for the second year, the amount deposited is Rs.2000 and 24,000 for Monthly and yearly respectively. The closing balance for the second year is Rs. 25,040.00 25,920.00 for Monthly and Yearly respectively.
The interest earned in the second year is Rs. 4,083.20 and 3,993.60 for Monthly and yearly respectively. When we calculate and compare the Monthly and yearly PPF Amount the deposited monthly amount on maturity after 15 years is Rs.6,79,900.35/-, and when calculated yearly the amount on maturity after 15 years is Rs.7,03,783.08/-. The difference came out to be Rs.23,882.73 for the same amount to be deposited and for the same tenure which suggests why we should invest on a Yearly basis.
