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
|