Continuous compounding

This query is : Resolved 

Avatar

Querist : Anonymous

Profile Image
Querist : Anonymous (Querist)
20 October 2010 How continuous compounding calculations are done?ie when interest is to be compounded daily?

20 October 2010 Just run the interest calculation cycle, system will calculate the interest.

Now , in computer it is a simple task.

21 October 2010 Step 1
Take the annual interest rate let us say 12% p.a.
Now compute the daily interest rate 12%/365 = 0.0329% per day
So this now your interest rate per day.

21 October 2010 Step 2
Compute how much will be Rs. 1 if you invest at this rate at the end of Day1.
It will be Rs.1.000329 (that is Rs 1 + 0.000329)

21 October 2010 Step 3
If you want to know how much this will be at the end of Day 20 (20 days compounded interest), then do like this:
1.000329 raised to 20th power. In excel do the following =1.000329^20 you will get 1.006596.

21 October 2010 Final Note
So the interest is 0.006596.
You can recheck this by doing daily and carrying forward the balance and see the result will be the same.
Through excel sheet you can do a template so that it becomes easy every time.

Hope this helps.


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro

Follow us
add to google news


Answer Query



Company
29 June 2026
Accountant (Finance & Compliance)

TRIEYEZ

Kolkata

CA

View Details
Company
ARTICLESHIP 30 June 2026
Taxation Content Writer Intern

Interactive Media Pvt Ltd.

New Delhi

CA Inter

View Details
Company
Featured 24 June 2026
HEAD - AUDIT AND TAXATION

A R JADHAV AND ASSOCIATES

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 27 June 2026
CA Articled Trainee And Paid Assistant

SKAA & Associates

New Delhi

CA Inter

View Details
Company
29 June 2026
ACCOUNTANT

SANDEEP AASHISH & CO

Araria

B.Com

View Details
Company
ARTICLESHIP 17 July 2026
Article Assistant and B.com pass

BANSAL YOGESH AND CO

Gautam Budh Nagar

B.Com

View Details
Company
13 July 2026
AVP / VP - PCG Advisory

Workforce Connect

Mumbai

MBA

View Details
Company
20 July 2026
Senior GST Executive

Chandak Agarwal & Co

Mumbai

Graduate (Any)

View Details