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
- DELIVERY GOLD & SILVER AND OTHER ETF TRADING PROFIT AS BUSINESS INCOME
- GSTR-1A How to update Invoice
- Excess salary payment.
- 3cd- cash system of accounting is allowed?
- Provision for loans that are under Revenue Recovery
- APPLICABILITYOF GST ON STUDENT HOSTEL FEES
- Form 121-contradictory opinions
- Current Account Opening for Sole Proprietorship with Udyam Certificate - Zero Turnover
- TDS on Purchase of Immovable Property by NRI from NRI
- Is Personal Guarantee of Director is Compulsory in case of loan to company ??
- Cash gift by grand mother to her grand daughter
- Tax amount diff in Gstr1 and 3B in tax compare reports
- Tds on GST in connection with sale to public company
- Restoration of certificate of practice
- Regarding change in correspondence address in SSP portal
- No Compliences after incorporation
- USEFUL LIFE OF USED/SECOND HAND COMMERCIAL VEHICLES
- Claiming TDS deducted by builder on Hardship compensation and Corpus
- Address Change to another state of a Registered Trust with 12AB approval
- Updated return in budget 2026
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
