Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
FVSCHEDULE should allow cell reference for interest rate schedule | Excel Worksheet Functions |