SBI Annuity Deposit Scheme Monthly Income Calculator Excel is a tool that will calculate the monthly income of investors who had invested in SBI Annuity Deposit Scheme in a very simple way. Our Excel calculator needs only Deposit Amount, Annual Interest Rate and Tenure in Months.
Click here to download SBI Annuity Deposit Scheme Monthly Income Calculator Excel free !
What is SBI Annuity Deposit Scheme Monthly Income Calculator Excel Sheet ?
SBI Annuity Deposit Scheme Monthly Income Calculator Excel is excel based calculator that calculate the monthly income of the invested amount. It is very easy to use and do calculation on the basis of investment and tenure.
For Example :
Mrs. Sharma, a senior citizen, invests ₹5,00,000 in the scheme for 60 month at a senior citizen FD rate of 6.50% per annum.
Calculation:
Her monthly payout will be ₹9,783.07 (approx).
She will receive this fixed amount for 60 months, providing her with a steady income to cover monthly expenses.
Also check :-SBI Annuity Deposit Scheme Calculator
How to download SBI Annuity Deposit Scheme Monthly Income Calculator Excel Sheet ?
To download the sheet link is given below:-
| Feature | Details |
|---|---|
| File Name | SBI Annuity Deposit Scheme Monthly Income Calculator.xlsx |
| File Type | Excel Spreadsheet (.xlsx) |
| File Size | 7.8KB (Approx.) |
| Purpose | Calculate SBI Annuity Deposit Scheme Monthly Income |
| Download Link | SBI Annuity Deposit Scheme Monthly Income Calculator Excel |
| Price | Free |
How to use SBI Annuity Deposit Scheme Monthly Income Calculator Excel
Download the Excel file
Open the file in Microsoft Excel or Google Sheets.
Enter your values in the following fields:
- Deposit Amount (P) : ₹5,00,000
- Annual Interest Rate (%) : 6.50%
- Tenure (Months) : 60 months
The Monthly Interest Rate and Monthly Annuity Payment will be calculated automatically using formulas.
FAQs
What is the minimum deposit amount for this scheme?
The minimum deposit amount depends on the branch, but it should be sufficient to generate at least ₹1,000 per month.
What is the purpose of the SBI Annuity Deposit Calculator Excel sheet?
The Excel sheet helps you calculate the exact monthly annuity payment based on your deposit amount, tenure, and interest rate.
Can I modify the Excel sheet for other banks’ annuity deposits?
Yes! Just change the interest rate and tenure based on the bank’s scheme, and it will work.
Does the Excel sheet calculate TDS deductions?
No, this version does not include TDS calculations. However, you can manually deduct 10% TDS if the annual interest exceeds ₹40,000 (₹50,000 for senior citizens).