LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Amortisation with a lump sum principal payment during term

I am trying to build am amortisation spreadsheet which allows for either
regular or irregular laump sum payments during the term of loan which should
affect the monthly payments during the remaining term. Spreadsheet is to be
used for commercial equipment lending rather than mortgage loan amortisation.
Can some one help with formulae please or build spreadsheet?
Thank you
 
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
Pivot table headache Dave Zed Excel Discussion (Misc queries) 2 September 22nd 06 03:59 PM
Mortgage calculation after a large extra payment Gary Wachs Excel Discussion (Misc queries) 6 April 16th 06 08:55 AM
Mortgage calculation after a large extra payment Gary Wachs Excel Worksheet Functions 4 April 16th 06 02:01 AM
Payment calculation w/ back interest Keeb Excel Discussion (Misc queries) 8 February 24th 06 05:27 AM
WANTED: Excel template for loan payment record with random/irregular payments cassidy Excel Discussion (Misc queries) 1 July 24th 05 01:09 AM


All times are GMT +1. The time now is 01:03 PM.

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

About Us

"It's about Microsoft Excel"