a function giving the interest rate for inv x for period y & bal z

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a function that returns the interest rate for a given investment "x"
that grows to balance "y" over period "z". No money is taken out until the
end. I use Excel 2003.
Thanks,
Cal
 
Cal,

For your period Z, you need to use start and end dates: for this example, it is 3 years, 1000 at the
start, 1200 at the end:

=INTRATE(DATEVALUE("1/1/5"),DATEVALUE("1/1/8"),1000,1200)

You can also specify a basis, which would be a fifth argument.

HTH,
Bernie
MS Excel MVP
 

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

IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows 7
"variable interest rate" 1
What function to calculate interest on savings 2
Excel formula for monthly interest rates 1
Which function to calculate a 401k rate of return? 10
Calculating percentage growth rate from a cumulative figure 4
which financial function should I use? 6
Financial Functions, in particular, the INTRATE function 5

Back
Top