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
- Is this income indian or foreign income?
- GST on export of services and Input Credit
- ITC temporary reversal and reclaim
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- Inventory of finished goods
- Applicable TDS rate for sale of property in Nov 2024
- Tds on building rent monthly
- GST ON EXPORT COMMISSION
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- Can we claim ITC of Feb-2024 in the month of November-2024 which was not claimed by oversight
- Sale of property furniture sale
- Confusion around Form 26QB fields
- Adjustment entry in the case of Individual and HUF on 31st March
- Stock difference tax applicable on composite rate or normal rate
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- Issue of gst e invoice
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
Trending Online Classes
CAclubindia
