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.
|