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
- Itr 1 processing
- Off Market debit and credit transaction
- Showing Gift from relative in ITR for this year
- Reporting Income under Section 44ADA
- ITR selection for salaries and capital gain less than L
- ITR 1: Details for showing Exempt Income
- ITR 2 Short Term gain & Long term gain
- Form 10E u/s 89(1). Need clarification because experts opinions differ !!!!
- ITR returnFY25-26
- Share accounting-->fifo - capital gain - period as per fifo?
- Gst invoice numbering and delivery challan numbering
- Sales amount in Gstr1
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
- Tax amount diff in Gstr1 and 3B in tax compare reports
- Tds on GST in connection with sale to public company
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
