View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default rate of return on investment per annum

PS....

I wrote:
Assuming that you mean $100000 for (just) 3 years, with
interest computed and compounded quarterly at a nominal rate of 7%, the
answer might be:
=fv(7%/4, 4*3, 0, -100000)
which is $123,144.


And just in case you truly meant "3 years and one month" with interest
computed and compounded quarterly at a nominal rate of 7%, interest for
the "odd period" (less than a quarter) is usually prorated. So the
answer might be written:

=fv(7%/12, 1, 0, -fv(7%/4, 4*3, 0, -100000))

or more simply:

=fv(7%/4, 4*3, 0, -100000) * (1 + 7%/12)

which is $123,862.