LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing XML containing Complex Elements troy Excel Discussion (Misc queries) 0 September 29th 05 06:27 PM
Matrix operations with complex numbers Veritas Excel Discussion (Misc queries) 1 July 22nd 05 06:30 PM
does anyone have a great Interest only amortization schedule wher. Kelsey Excel Discussion (Misc queries) 2 January 29th 05 10:44 PM
Loan Amortization Template in Excel [email protected] Excel Worksheet Functions 3 January 29th 05 03:50 AM
How to stop #REF! on linked cells in complex spreadsheets Formann Excel Worksheet Functions 0 November 18th 04 12:34 PM


All times are GMT +1. The time now is 07:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"