How to compute compound interest in excel
This query is : Resolved
27 October 2010
Can anyone proide me a sheet of compounding interest in excel via email: kapilbhatia2004@yahoo.co.in
29 October 2010
How do you want to compound?
Daily? Monthly?
Daily? Monthly?
01 November 2010
Step 1
Get the annual rate. Let us say 12%
Step 2
If monthly compounding, then get monthly rate which is 12/12 = 1% or 0.01
If it is daily compouding then get the daily rate which is 12/365 =0.03287% or .003287
Get the annual rate. Let us say 12%
Step 2
If monthly compounding, then get monthly rate which is 12/12 = 1% or 0.01
If it is daily compouding then get the daily rate which is 12/365 =0.03287% or .003287
01 November 2010
Step 3
Add 1 to the above
Monthly - 1.01
Daily - 1.003287
Step 4
What period?
Let us say 3 months for monthly commpounding
Let us say 15 days for daily compounded
Add 1 to the above
Monthly - 1.01
Daily - 1.003287
Step 4
What period?
Let us say 3 months for monthly commpounding
Let us say 15 days for daily compounded
01 November 2010
Final Step
On a principal amount of 200, the maturing amount will be
for monthly 200 X (1.01)^3
for daily 200 X (1.003287)^15
^ is a function in Excel (raised to)
Hope this is clear, if not pls revert
On a principal amount of 200, the maturing amount will be
for monthly 200 X (1.01)^3
for daily 200 X (1.003287)^15
^ is a function in Excel (raised to)
Hope this is clear, if not pls revert
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
- GST Audit whether Govt Companies are exempt?
- PTRC Show Cause Notice on Email
- Accounting treatment of AMC alongwith the purchase of Laptop
- Unable to File TDS Q2 Return – New TRACES Portal Error
- Condonation Request sec 119(2) b -Enhancement Limit of Leave Exemption prior to AY 2023
- GST Treatment of Purchases with GST Paid where Outward Supplies of Manufactured CattleFeed Exempt
- Taxation of crypto futures in India Fy 2026- 2027
- EPF ECR NEW RULES Sep 17th 2026
- Issuing of delivery challan by seller of goods
- Transfer of Physical Stock Between Two Proprietorship Concerns
- Expert Help Required for TDS Refund 100000 Through TRACES – AY 2022–23
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- 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
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
