View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cfspahn24
 
Posts: n/a
Default complex amortization

Problem: 5 loan amounts, each different, with varying interest rates,
payments, and loan periods. The loan periods are epressed in decimals of a
year, not full years. I need to determine the total amortization if, as the
highest interest loan is paid off, the payment for that loan is applied to
the next highest interest rate loan, continuing until the final loan is paid
off. This boggles my mind!