How to calculate Compound Interest

N

Nikhil

Hi,

Can any one let me know how to calculate compound interest in excel using
formula for function.

Thanks in Advance
 
J

Jim Aksel

See if any of the following functions are helpful:
INTRATE
IRR
MIRR
RATE
YIELD
--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project
 
B

Bernard Liengme

Invest P for n years at R% per year

beginning of year 1 you have P, so end of Year 1 you have: P+RP or P(1+R)
beginning of year 2 you have P(1+R); end of year 2 you have P(1+R)(1+R) or
P(1+R)^2
beginning of year 3 you have P(1+R)^2; end of year 3 you have P(1+R)^2*(1+R)
=
P(1+R)^3
.......
by the mathematical method called induction: by end of year n you have
P(1+R)^n

In Excel
A1 holds P
A2 holds R
A3 holds n
Value at then of year =A1*(1+A2)^A3
Interest accumulated =A1*(1+A2)^A3 -A1
best wishes
 
N

Nikhil

Thanks you very much Bernard


Bernard Liengme said:
Invest P for n years at R% per year

beginning of year 1 you have P, so end of Year 1 you have: P+RP or P(1+R)
beginning of year 2 you have P(1+R); end of year 2 you have P(1+R)(1+R) or
P(1+R)^2
beginning of year 3 you have P(1+R)^2; end of year 3 you have P(1+R)^2*(1+R)
=
P(1+R)^3
.......
by the mathematical method called induction: by end of year n you have
P(1+R)^n

In Excel
A1 holds P
A2 holds R
A3 holds n
Value at then of year =A1*(1+A2)^A3
Interest accumulated =A1*(1+A2)^A3 -A1
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top