determine unknown interest rates

C

Consuela

I have a question regarding how to get Excel to return
unknown interest rates. If I know the value of a deposit
and the value of that same deposit in X number of
months/years, how do I figure out the compound interest
rate?

I'd also like to calculate the annual rate, and the
effective rate.

Thanks for any help!
 
D

drabbacs

Check out help for RATE.

=RATE(5,0,-1000,1257.33,0)

returns 5%
5 is the number of year (periods) of compounding
0 additional money added over the term
-1000 present value
1257.33 future value
0 payments at the end of period
 
F

Fred Smith

To calculate effective rates, you can use the NOMINAL and EFFECT functions
which are in the Analysis Toolpak.
 
C

Consuela

What is the Analysis toolpak? I don't seem to have it.
I'm using Excel 2000 if that makes a difference...

Thanks,
Consuela
 
P

Peo Sjoblom

It comes with excel/office, if you don't have it installed look under
tools>add-ins,
check it, keep the cd handy and follow the instructions
 

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

Similar Threads

Loan amortization schedule for variable interest rates 5
Saving for College 1
FV function 2
compound sum interest factor function? 5
Lookup table for rates? 4
Need formula to figure compound interest of a deposit for a year 3
Calculate Interest Rate 2
Function help with Calculating Interest for two different investme 2

Top