Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IRR function when the cash flows are not in array? | Excel Worksheet Functions | |||
IRR for 2 cash flows | Excel Worksheet Functions | |||
IRR formula for monthly cash flows | Excel Worksheet Functions | |||
PV of uneven stream of cash flows | Excel Worksheet Functions | |||
Is the IRR calculation based on cash flows at beginning of year? | Excel Worksheet Functions |