**PPF Calculator SBI**

## Introduction

The Public Provident Fund (PPF) in Post office is one of the popular savings schemes in India which is offered by the Government of India. PPF is a long-term investment scheme with a Lock-in period of 15 Years.

Most of the people deposits their money in PPF accounts through Stat Bank of India (SBI), which is one of the largest commercial banks in India. However, Most of the them may not be aware of potential returns they can earn through PPF.

This post aims to provide a good guidance to the SBI PPF account holders by answering few common questions related to PPF.

We will also explore, in case If you deposit Rs.500/- rupees on monthly basis in PPF account, then, how much earnings you will get by the end of the maturity period ?

If you want to earn Rs.15,00,000/- from the SBI PPF account, then how much amount is to deposited on every month ?

If you need Rs.40,00,000/- from PPF account, then, how much money is to deposited every month will be discussed by using a Simple Free Excel sheet.

Additionally, We also introduce a PPF Calculator SBI, a Customisable tool that aims to tailor the calculations as per your specific needs.

Without a further ado, Let’s get Started..!!

**Features of SBI PPF**

The Main features of SBI Public Provident Fund (PPF) is as follows

S.No. | Particulars | Details | |

1. | Scheme Name | Public Provident Fund (PPF) | |

2. | Eligibility | – Individuals – For Minor or a Person of Unsound mind by their Guardian can open the account. | |

3. | Deposit Limits | Minimum Deposit – Rs.500/- per Financial Year Maximum Deposit – Rs.1,50,000/- per Financial Year | |

4. | Maturity period | 15 Years | |

5. | Rate of Interest p.a. | @ 7.10% p.a. w.e.f. 01st Jan,2024 | |

6. | Pre-mature Withdrawal & Loans | Allowed subject to T & C | |

7. | Income Tax benefits | U/s 80C of the Income Tax Act, 1961 | |

8. | Nomination Facility | Available |

**Also Read: 9 Things to know about SBI Green Rupee Term Deposit Scheme**

**PPF Calculator SBI for 15 years : How to Use Excel ?**

Now, I’m going to explain you about Excel PPF Calculator SBI. Not only that I will showcase you, how to use this Excel sheet to calculate your PPF Savings simply by entering 2 fields as per your needs with out any hustle.

I’m also trying to explain you with 8 simple PPF Examples to understand your PPF earnings quite easily.

Let’s get into examples my friend.

**How to Download SBI PPF Calculator Excel [Free]**

**Steps:**

1. Download Free Excel PPF Calculator SBI here.

2. No Passwords given.

3. Double click on the downloaded file to “Open” it

**Example 1: When you deposit Rs.500 per month [****PPF Calculator SBI Monthly**]

**PPF Calculator SBI Monthly**]

**Step 1:**Enter your Monthly deposit under the column of “Deposit Amount p.m”. It can be from Rs.500 rupees to Rs.12,500/- only.

Enter Rs.500 rupees in the “Deposit Amount p.m” column.

**Step 2:**Now, You need to enter the “Rate of Interest p.a. (%)”

If you know the latest Post office interest rate, you can enter here.

If you don’t know the latest Post office Public Provident Fund (PPF) Interest rates, then **click **here.

At present, the Post office Public Provident Fund (PPF) Interest rate for 2024 is 7.10% p.a. I considered the same rate of interest uniformly through all the 15 Years.

But if you want change Rate of interest, you can change it under E Column of “Interest”. I will also tell you the same.

Don’t worry.

**Step 3:**Now, you just no need to enter any of the other fields like

– Deposit period (in Years)

– Amount Invested

– Total Interest Receivable

– Maturity Value

Your computation is now Ready ðŸ™‚

**My Analysis:**

Particulars | Rs. |

Deposited amount | Rs.500/- per Month |

Amount Invested per year [A] | Rs.90,000/- per Month |

Total Interest you receive is [B] | Rs.72,728/- |

Total Maturity Value for 15 Years | Rs.1,62,728 /- |

**Example 2: When you deposit Rs.1,000 Monthly ****[****PPF Calculator SBI Monthly**]

**[**

**PPF Calculator SBI Monthly**]**Step 1:**Enter Rs.1,000 rupees in the “Deposit Amount p.m” column.

**Step 2:**Now, you just No need to enter any of the other fields like

– Rate of Interest p.a. (%)

– Deposit period (in Years)

– Amount Invested

– Total Interest Receivable

– Maturity Value

**Step 3:**

Your computation is Ready ðŸ™‚

**My Analysis:**

Particulars | Rs. |

Deposited amount | Rs.1,000/- per Month |

Amount Invested per year [A] | Rs.1,80,000/- |

Total Interest you receive is [B] | Rs.1,45,456/- |

Total Maturity Value for 15 Years | Rs.3,25,456 /- |

**Example 3: When you deposit Rs.2,000 Monthly ****[****PPF Calculator SBI Monthly**]

**[**

**PPF Calculator SBI Monthly**]**Step 1:**Enter Rs.2,000 rupees in the “Deposit Amount p.m” column.

**Step 2:**Now, you just No need to enter any of the other fields like

– Rate of Interest p.a. (%)

– Deposit period (in Years)

– Amount Invested

– Total Interest Receivable

– Maturity Value

**Step 3:**

Your computation is Ready ðŸ™‚

**My Analysis:**

Particulars | Rs. |

Deposited amount | Rs.2,000/- per Month |

Amount Invested per year [A] | Rs.3,60,000/- |

Total Interest you receive is [B] | Rs.2,90,913/- |

Total Maturity Value for 15 Years | Rs.6,50,913/- |

**Example 4: When you deposit Rs.3,000 Monthly ****[****PPF Calculator SBI Monthly**]

**[**

**PPF Calculator SBI Monthly**]**Step 1:**Enter Rs.3,000 rupees in the “Deposit Amount p.m” column.

**Step 2:**Now, you just No need to enter any of the other fields like

– Rate of Interest p.a. (%)

– Deposit period (in Years)

– Amount Invested

– Total Interest Receivable

– Maturity Value

**Step 3:**

Your computation will be Ready ðŸ™‚

**My Analysis:**

Particulars | Rs. |

Deposited amount | Rs.3,000/- per Month |

Amount Invested per year [A] | Rs.540,000/- |

Total Interest you receive is [B] | Rs.4,36,370/- |

Total Maturity Value for 15 Years | Rs.9,76,370/- |

**Example 5: When you deposit Rs.5,000 Monthly ****[****PPF Calculator SBI Monthly**]

**[**

**PPF Calculator SBI Monthly**]**Step 1:**Enter Rs.5,000 rupees in the “Deposit Amount p.m” column.

**Step 2:**Now, you just No need to enter any of the other fields like

– Rate of Interest p.a. (%)

– Deposit period (in Years)

– Amount Invested

– Total Interest Receivable

– Maturity Value

**Step 3:**

Your computation is Ready ðŸ™‚

**My Analysis:**

Particulars | Rs. |

Deposited amount | Rs.5,000/- per Month |

Amount Invested per year [A] | Rs.9,00,000/- |

Total Interest you receive is [B] | Rs.7,27,283/- |

Total Maturity Value for 15 Years | Rs.16,27,283/- |

**Example 6: When you deposit Rs.7,500 Monthly ****[****PPF Calculator SBI Monthly**]

**[**

**PPF Calculator SBI Monthly**]**Step 1:**Enter Rs.7,500 rupees in the “Deposit Amount p.m” column.

**Step 2:**Now, you just No need to enter any of the other fields like

– Rate of Interest p.a. (%)

– Deposit period (in Years)

– Amount Invested

– Total Interest Receivable

– Maturity Value

**Step 3:**

Your computation is now Ready ðŸ™‚

**My Analysis:**

Particulars | Rs. |

Deposited amount | Rs.7,500/- per Month |

Amount Invested per year [A] | Rs.13,50,000/- |

Total Interest you receive is [B] | Rs.10,90,925/- |

Total Maturity Value for 15 Years | Rs.24,40,925/- |

**Example 7: When you deposit Rs.10,000 Monthly ****[****PPF Calculator SBI Monthly**]

**[**

**PPF Calculator SBI Monthly**]**Step 1:**Enter Rs.10,000 rupees in the “Deposit Amount p.m” column.

**Step 2:**Now, you just No need to enter any of the other fields like

– Rate of Interest p.a. (%)

– Deposit period (in Years)

– Amount Invested

– Total Interest Receivable

– Maturity Value

**Step 3:**

Your computation is now Ready ðŸ™‚

**My Analysis:**

Particulars | Rs. |

Deposited amount | Rs.10,000/- per Month |

Amount Invested per year [A] | Rs.18,00,000/- |

Total Interest you receive is [B] | Rs.14,54,567/- |

Total Maturity Value for 15 Years | Rs.32,54,567/- |

**Example 8: When you deposit Rs.12,500 Monthly**

**Step 1:**Enter Rs.12,500 rupees in the “Deposit Amount p.m” column.

**Step 2:**Now, you just No need to enter any of the other fields like

– Rate of Interest p.a. (%)

– Deposit period (in Years)

– Amount Invested

– Total Interest Receivable

– Maturity Value

**Step 3:**

Your computation is now Ready ðŸ™‚

**My Analysis:**

Particulars | Rs. |

Deposited amount | Rs.12,500/- per Month |

Amount Invested per year [A] | Rs.22,50,000/- per Month |

Total Interest you receive is [B] | Rs.18,18,209/- |

Total Maturity Value for 15 Years | Rs.40,68,209/- |

**Conclusion**

The Public Provident Fund (PPF) Scheme is a good option for the investos who wants invest money in differnt basket. You can definitely consider the PPF as one of such option as you can earn interest on a Compounding basis.

If you want to earn atleast Rs.15,00,000/- from the SBI PPF account, then, you should deposit Rs.5,000 per month for 15 years. Then, you will get Interest of Rs.Rs.7,27,283/- with a Maturity value of Rs.16,27,283/- at the end of 15 years.

If you need Rs.40,00,000/- from PPF account, then, you should deposit Rs.12,500 per month for 15 years. Then, you will get Interest of Rs.Rs.1818209/- with a Maturity value of Rs.40,68,209/- at the end of 15 years.

**FAQ’s**

**1. How much will I get after 15 years in PPF?**

If you invest Rs.6,000 per year with an annual Interest rate of 7.10% can earn upto Rs.1.62 Lakhs at the end of 15 Years. In case, If you make a Maximum monthly deposit of Rs.12,500 per month can earn upto Rs.40.68 Lakhs at the end of 15 Years.

**2. What if I invest 5,000 per month in PPF?**

If you invest Rs.5,000 per month then your Yearly investment is Rs.60,000. With an annual Interest rate is 7.10%, a person can create a corpus of upto Rs.16.27 Lakhs by the end of 15 Years.

**3. What is PPF 10000 per month?**

If you invest Rs.10,000 per month, then, your Yearly investment will be Rs.1,20,000. With an annual Interest rate is 7.10%, a person can create a corpus of upto Rs.32.54 Lakhs by the end of 15 Years.

**4. What is the return of PPF in SBI?**

The latest interest rate in SBI for Public Provident Fund (PPF) is 7.10% per annum. PPF account holders can earn interest on a Compounding basis.

Thanks for your time ðŸ™‚