FD Calculator

You can calculate the maturity amount of your Fixed Deposit using the FV (Future Value) function in Microsoft Excel or Google Sheets.

Formula:

`=FV(rate, nper, pmt, [pv], [type])`

Example Scenario:

• Principal Investment: $1,00,000
• Interest Rate: 7% p.a.
• Tenure: 5 Years
• Compounding: Annually

Steps:

1. Open Excel/Google Sheets.
2. In a cell, enter the formula:

`=FV(7%, 5, 0, -100000)`

1. Press Enter. The result will be $1,40,255.

Note:

• Rate: Enter the annual interest rate (e.g., 7% or 0.07). If compounding is quarterly, divide by 4.
• Nper: Number of periods (years). If compounding is quarterly, multiply by 4.
• Pmt: 0 (since it's a one-time deposit, not a recurring one).
• Pv: The principal amount (enter as a negative number to represent cash outflow).

Fixed Deposit (FD) is a financial instrument offered by banks and Non-Banking Financial Companies (NBFCs) in India where you deposit a lump sum amount for a fixed period at a predetermined interest rate. FDs are one of the most popular and safest investment options, offering guaranteed returns and capital protection.

When you open an FD, you agree to keep your money with the bank for a specific period (tenure), and in return, the bank pays you interest at a fixed rate. The interest rate is locked in at the time of deposit and remains constant throughout the tenure, regardless of market fluctuations.

FDs are ideal for conservative investors who want:

• Guaranteed returns with minimal risk
• Predictable income through regular interest payments
• Capital protection (up to $5 lakhs insured by DICGC)
• Flexible tenure options (from 7 days to 10 years)
• Higher interest rates for senior citizens

Our FD calculator uses compound interest formula to calculate your fixed deposit maturity amount:

FD Calculation Formula: A = P(1 + r/n)^(nt)

Where:

• A = Maturity amount (Principal + Interest)
• P = Principal (deposit amount)
• r = Annual interest rate (as decimal)
• n = Compounding frequency per year (usually quarterly = 4)
• t = Tenure in years

Example Calculation:

Principal = $10,00,000

Interest Rate = 6.5% per annum

Tenure = 5 years

Compounding = Quarterly (4 times per year)

A = 10,00,000 × (1 + 0.065/4)^(4×5)

A = 10,00,000 × (1.01625)^20

A = 10,00,000 × 1.3804

A = $13,80,400

Interest Earned = $13,80,400 - $10,00,000 = $3,80,400

Using an FD calculator offers several advantages:

Investment Planning: Calculate your FD maturity amount before investing to plan your financial goals. See how much you'll receive at maturity and how much interest you'll earn.

Compare Options: Compare FDs from different banks with varying interest rates and tenures. Find the best FD option that maximizes your returns.

Accuracy: Manual calculations for compound interest can be complex and error-prone. Our calculator provides instant, accurate results.

No Login Required: Our FD calculator is completely free and doesn't require any registration. Use it unlimited times to calculate FD returns for different scenarios.

Understanding how FDs compare to other investment options helps in making informed decisions:

Risk:

• FD: Low risk, guaranteed returns.
• Mutual Funds: Moderate to High risk, returns depend on market performance.
• Stocks: High risk, high volatility.

Returns:

• FD: Fixed returns (currently 6-8%).
• Mutual Funds: Potential for higher returns (10-15% for equity funds), but not guaranteed.
• Stocks: Potential for very high returns (or losses).

Liquidity:

• FD: Premature withdrawal allowed with a penalty (usually 1%).
• Mutual Funds: High liquidity (except ELSS with 3-year lock-in).
• Stocks: High liquidity (funds available in T+1 days).

Taxation:

• FD: Interest is fully taxable as per your income slab. TDS applies if interest exceeds $40,000/year ($50,000 for seniors).
• Mutual Funds: LTCG taxed at 12.5% (>$1.25L), STCG at 20%.
• Stocks: LTCG taxed at 12.5% (>$1.25L), STCG at 20%.

Interest earned on Fixed Deposits is fully taxable. Here's what you need to know:

• Income Tax: The interest income is added to your total income and taxed according to your income tax slab rates.
• TDS (Tax Deducted at Source): Banks deduct TDS at 10% if the interest earned in a financial year exceeds $40,000 ($50,000 for senior citizens).
• Form 15G/15H: If your total income is below the taxable limit, you can submit Form 15G (for individuals <60) or Form 15H (for senior citizens >60) to the bank to avoid TDS deduction.
• Tax-Saving FD: 5-year tax-saving FDs qualify for deduction under Section 80C (up to $1.5 Lakh), but have a 5-year lock-in period.

Breaking an FD prematurely (before maturity) usually attracts a penalty (typically 0.5% to 1% reduction in interest rate). You should consider breaking an FD only if:

1. Emergency: You need funds urgently and have no other liquid assets.
2. Better Opportunities: Interest rates have risen significantly, and reinvesting (even after the penalty) yields higher returns.
3. Reinvestment Strategy: You want to ladder your FDs (split one large FD into smaller ones with different maturities) for better liquidity.

While our calculator does this automatically, here's how to calculate FD manually:

Step 1: Convert annual rate to decimal

r = Annual Rate ÷ 100

Step 2: Determine compounding frequency

Most banks compound FD interest quarterly (n = 4)

Step 3: Calculate growth factor

Growth Factor = (1 + r/n)^(n×t)

Step 4: Calculate maturity amount

A = P × Growth Factor

Step 5: Calculate interest earned

Interest = A - P

Manual Example:

P = $5,00,000, Rate = 7%, Tenure = 3 years, Compounding = Quarterly

Step 1: r = 7 ÷ 100 = 0.07

Step 2: n = 4 (quarterly)

Step 3: Growth Factor = (1 + 0.07/4)^(4×3) = (1.0175)^12 = 1.2314

Step 4: A = 5,00,000 × 1.2314 = $6,15,700

Step 5: Interest = 6,15,700 - 5,00,000 = $1,15,700