Principal Amortization based on variable cash flows
Hi,
I am trying to build an amortization schedule that would help me determine my bond borrowing capacity however it needs to be based on variable semiannual payments versus leveled payments. Has anyone done that before and has any suggestions on the formulas to use. Thanks in advance. Neda |
Principal Amortization based on variable cash flows
Amortization tables are straightforward. You can find a template on the net, or
build your own. You need 5 columns: Period/Date, Opening Balance, Payment, Interest, Closing Balance In the Interest column, enter the formula which calculates interest for the period (such as Opening Balance * Interest Rate / 2). For the Payment column, enter the formula which determines the variable payment, or manually enter the payment schedule. -- Regards, Fred "neda5" wrote in message ... Hi, I am trying to build an amortization schedule that would help me determine my bond borrowing capacity however it needs to be based on variable semiannual payments versus leveled payments. Has anyone done that before and has any suggestions on the formulas to use. Thanks in advance. Neda |
All times are GMT +1. The time now is 01:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com