RD Calculator

Recurring Deposit (RD) is a disciplined investment scheme offered by banks and Post Offices in India. It allows you to deposit a fixed amount every month for a pre-decided tenure and earn interest rates similar to Fixed Deposits (FDs).

Key Features of RD:

• Regular Savings: Invest small fixed amounts monthly (e.g., $500, $1000).
• Guaranteed Returns: Interest rates are fixed at the time of opening and do not change during the tenure.
• Tenure: Flexible tenure ranging from 6 months to 10 years.
• Compounding: Interest is typically compounded quarterly.
• Liquidity: Loan and premature withdrawal facilities available (with penalty).
• Safety: Bank RDs are insured up to $5 Lakh by DICGC.

You can calculate RD maturity value in Excel using the FV function, but with a small twist because payments are monthly but compounding is often quarterly.

Simple Monthly Compounding Formula (Approximate):

`=FV(rate/12, tenure_months, -monthly_deposit, 0, 1)`

Exact Quarterly Compounding Formula:

Calculating exact quarterly compounding for monthly deposits in Excel is complex. However, you can use this generalized formula for monthly compounding which is close to actuals:

`=FV(Interest_Rate/12, Tenure_Months, -Monthly_Deposit, 0, 1)`

• Interest_Rate: Annual rate (e.g., 7%)
• Tenure_Months: Total months (e.g., 36)
• Monthly_Deposit: Amount deposited each month

Deciding between RD, SIP (Systematic Investment Plan), and FD depends on your goal and risk profile.

| Feature | Recurring Deposit (RD) | SIP (Mutual Funds) | Fixed Deposit (FD) |

|---------|------------------------|--------------------|--------------------|

| Investment Type | Fixed Monthly | Fixed Monthly | One-time Lump Sum |

| Risk | Low (Guaranteed) | Moderate to High | Low (Guaranteed) |

| Returns | 6.5% - 8.0% | 12% - 15% (Equity) | 6.5% - 8.0% |

| Taxation | Taxed as per slab | LTCG 12.5% (>$1.25L) | Taxed as per slab |

| Suitability | Short-term goals, Risk-averse | Long-term wealth creation | Lump sum parking |

Conclusion:

• Choose RD if you want to save monthly for short-term goals (e.g., a vacation, buying a gadget) without risk.
• Choose SIP for long-term wealth creation (5+ years) to beat inflation.
• Choose FD if you already have a lump sum amount to invest.

Interest earned on Recurring Deposits is fully taxable. It is added to your annual income and taxed according to your income tax slab.

TDS (Tax Deducted at Source) Rules:

• Banks deduct 10% TDS if interest earned on RD + FD exceeds $40,000 in a financial year ($50,000 for Senior Citizens).
• If you do not provide PAN, TDS is deducted at 20%.
• Form 15G/15H: If your total income is below the taxable limit, you can submit Form 15G (for individuals <60) or Form 15H (for seniors) to avoid TDS deduction.

Banks offer various types of RD accounts to suit different needs:

1. Regular RD: Fixed monthly deposit for a fixed tenure. Standard interest rates apply.
2. Senior Citizen RD: Offers 0.50% to 0.75% higher interest rates than regular RDs.
3. Tax-Saving RD: Has a lock-in period of 5 years and offers tax benefits under Section 80C (less common than Tax-Saving FD).
4. Flexi RD: Allows you to deposit a variable amount every month (core amount + flexible component) depending on your surplus funds.
5. NRE/NRO RD: For NRIs to save from their overseas or Indian income.

Just like FD laddering, you can use RD Laddering to optimize your savings and liquidity.

How it works:

Instead of opening one large RD, open multiple smaller RDs with different tenures.

Example:

• Open RD 1: $5,000 for 1 year
• Open RD 2: $5,000 for 2 years
• Open RD 3: $5,000 for 3 years

Benefits:

1. Liquidity: You get maturity amounts every year.
2. Rate Averaging: You reduce the risk of locking in low rates for long periods.
3. Flexibility: If you need money, you can break one small RD without disturbing others.

You can close your RD account before maturity, but it comes with a cost:

• Penalty: Banks typically charge a 0.5% to 1% penalty on the interest rate.
• Interest Calculation: Interest is paid for the period the deposit actually remained with the bank, at the rate applicable for that period (minus the penalty).
• Partial Withdrawal: Most banks do not allow partial withdrawals from RDs. However, you can take a loan/overdraft (usually up to 90% of the deposit balance) against your RD instead of breaking it.

Our RD calculator uses the compound interest formula to precisely calculate maturity values with quarterly compounding.

Formula: A = P × (1+R/N)^(N×t) - (This is for lump sum, RD formula is complex summation)

Actual RD Formula Used:

M = P × [((1+r/n)^(n×t) - 1) / (1-(1+r/n)^(-1/3))] (Approximation for quarterly compounding on monthly deposits)

Example:

• Monthly Deposit: $5,000
• Rate: 7% p.a.
• Tenure: 12 Months

The calculator computes interest for the first installment for 12 months, second for 11 months, and so on, compounding quarterly.

Result:

• Total Investment: $60,000
• Maturity Value: $62,323 (approx)
• Interest Earned: $2,323