Compound Interest Calculation
This query is : Resolved
Aranya Dey
(Querist)
01 December 2008
Plz. anybody answer the following:-
What is the formula for Calculation of Compound Interest in Recurring Deposits?
What is the formula for Calculation of Compound Interest in Recurring Deposits?
CA Debasish Banerjee
(Expert)
01 December 2008
Principal Amount 900 ( in Cell B16)
Period in Year/s 1 (in Cell B17)
Rate of Interest
(% p.a.) 12 (in Cell B18)
Componding Frequency 12 (in Cell B19)
(Monthly 12; Qrtly 4..)
Maturity Value (in Cell 20)type the following
= FV(B18%/B19,B17*B19,0,-B16)
and you will get
1,014.14
Period in Year/s 1 (in Cell B17)
Rate of Interest
(% p.a.) 12 (in Cell B18)
Componding Frequency 12 (in Cell B19)
(Monthly 12; Qrtly 4..)
Maturity Value (in Cell 20)type the following
= FV(B18%/B19,B17*B19,0,-B16)
and you will get
1,014.14
Dhirajlal Rambhia
(Expert)
27 June 2023
"Sorry, I am not a featured member."
For featured members contact....
https://www.caclubindia.com/catalogue/featured.asp
For featured members contact....
https://www.caclubindia.com/catalogue/featured.asp
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
- EPF ECR NEW FILE SEP 17TH 2026
- Under marginal scheme
- Clarification Requested: Gift → NRO → NRE → Overseas Transfer - USA/CANDA (FEMA & Tax Compliance)
- GST on Renting godown to KFCSC for Storage of Raagi
- Capitalgain tax purposes for valuation report compulsory
- Import of Software Service.
- Utilisation Fy 25-26 TDS challans in Fy 26-27 TDS Return
- Oct 2025 Invoices
- TDS on Fixed Assets purchased
- SECTION 393(3) TAX ON CASH WITHDRAWAL
- Capital Gail Exemption Certificate
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
- How to pay remaining amount of TDS after due date?
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
