future value function for compound interest
On Aug 20, 7:36 pm, frustrated wife
wrote:
How would I use the FV function for compound interest on an investment
maturing in 30, 60, or 90 days? So, for example, where would I plug in the
following values:
$1,000 investment
1.39% interest rate
30 day
I need to do the same for 90 days, 60 days, 6 months and 9 months.
Thanks!
If those 3 number facts are in A1:A3....
=FV(A2,A3/30,,-A1)
I assumed the rate was a 30 day rate based on your comments. You'd
have to adjust the A3/30 to match the rate if necessary.
|