View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default 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.