Regarding Bank FD interest calculation
This query is : Resolved
14 September 2010
Please guide me for Bank FDR interest calculation. I want to verify the return amount of FD but i am not able to get exact amount which is written on FD Receipt
Principal amount - 1500000
FD Interest rate - 9%
for period - 1 year & 11 months
Maturity amount - 1779100.64
Please guide me formula so i can check for other FDR receipt also.
Principal amount - 1500000
FD Interest rate - 9%
for period - 1 year & 11 months
Maturity amount - 1779100.64
Please guide me formula so i can check for other FDR receipt also.
15 September 2010
Falguni,
Generally Banks calculate interest on FD on a compounding basis. Frequency of compounding is different for different FD products. In your case interest is compounded quarterly. Please see the table below
Period Amount(Begin) Int rate Amount(end)
Qtr 1 1500000 2.25% 1533750
Qtr 2 1533750 2.25% 1568259
Qtr 3 1568259 2.25% 1603545
Qtr 4 1603545 2.25% 1639625
Qtr 5 1639625 2.25% 1676517
Qtr 6 1676517 2.25% 1714238
Qtr 7 1714238 2.25% 1752809
2 mos 1752809 1.50% 1779101
Excuse me for the mis-alligned table.
Interest rate above is for the quarter (i.e 9%/4). Through Simple excel calculation you can reproduce this table. Please get back in case its not clear.
Generally Banks calculate interest on FD on a compounding basis. Frequency of compounding is different for different FD products. In your case interest is compounded quarterly. Please see the table below
Period Amount(Begin) Int rate Amount(end)
Qtr 1 1500000 2.25% 1533750
Qtr 2 1533750 2.25% 1568259
Qtr 3 1568259 2.25% 1603545
Qtr 4 1603545 2.25% 1639625
Qtr 5 1639625 2.25% 1676517
Qtr 6 1676517 2.25% 1714238
Qtr 7 1714238 2.25% 1752809
2 mos 1752809 1.50% 1779101
Excuse me for the mis-alligned table.
Interest rate above is for the quarter (i.e 9%/4). Through Simple excel calculation you can reproduce this table. Please get back in case its not clear.
16 September 2010
Thank you Mr. Bajaj. Thank you for your kind guidance. It will definitely help me for my work.
Falguni
Falguni
Message likes :
1 times
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- ITDS U/S.194T of Firm
- Unregistered suppliers utility
- Difference between Date of Payment and Date of Deduction?
- Journal entry of busniess expenses
- Same demand raised for original as well as rectification request return
- Sale of property held jointly with a non resident Indian
- GST not cancelled by tenant
- EXPORT COMMERCIAL INVOICE HSN CODE
- NRI starting business in India
- URGENT-Eligible leaves being shown as 24 days for 3 years Articleship instead of 156 days in 108
- Filling ITR - U
- Form 140 tds
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
- LLP audit under companies act
- Experienced CA recommendation from Kolkata for FNO return filing
- Interest Reporting in Form 168
- Sales of goods of amount Rs77 lakhs to a party
- Tax Demand of ₹4,650 for AY 2026-27
- Concept of Vendor and customner reconciliation
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
