Thread: FVSCHEDULE
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
reremmak reremmak is offline
external usenet poster
 
Posts: 1
Default FVSCHEDULE

I need to calculate the amount of interest due on a 4/15/04 loan and will be
repaid 11/20/09. Assume the principal is $10,000 and the interest rate has
been changing quarterly. Further assume the interest rate was 1% in the
first quarter and has been increasing by 10% every successive quarter (thus
in the second quarter the total interest was 1.1%). I tried doing this with
the FVSCHEDULE function, but my result is way to high.

Thanks