amortization

You can use the debt amortization starter workbooks without modification for many debt instruments. However, you will still want to regularly make several changes to the workbooks. Note: Before you change anything in the starter workbook other than the input parameters, unprotect the document. As … [Read more...] about Customizing the Debt Amortization Starter Workbooks

The variable rate, annuity due amortization starter workbook has three parts: the Variable Interest Rate, Annuity Due Amortization Inputs box; the Variable Interest Rate, Annuity Due Amortization Schedule; and the Balloon Payment Schedule. Variable Interest Rate, Annuity Due Amortization … [Read more...] about Understanding the Variable Rate, Annuity Due Amortization Starter Workbook

The variable rate ordinary annuity amortization starter workbook has three parts: the Variable Interest Rate Amortization Inputs box, the Variable Interest Rate Amortization Schedule, and the Balloon Payment Schedule. Variable Interest Rate Amortization Inputs The amortization inputs, along with … [Read more...] about Understanding the Variable Rate, Ordinary Annuity Amortization Starter Workbook

The fixed rate annuity due amortization starter workbook has three parts: the Fixed Interest Rate, Annuity Due Amortization Inputs box; the Fixed Interest Rate, Annuity Due Amortization Schedule; and the Balloon Payment Schedule. Fixed Interest Rate, Annuity Due Amortization Inputs The … [Read more...] about Understanding the Fixed Rate, Annuity Due Amortization Starter Workbook

The fixed rate, ordinary annuity amortization starter workbook has three parts: the Fixed Interest Rate Amortization Inputs box, the Fixed Interest Rate Amortization Schedule, and the Balloon Payment Schedule. Fixed Interest Rate Amortization Inputs The amortization inputs are the only four … [Read more...] about Understanding the Fixed Rate, Ordinary Annuity Amortization Starter Workbook

You can use the debt amortization starter workbooks, as shown in Figures 14-1 through 14-4, to construct debt amortization schedules for a variety of debt instruments. Given four parameters—principal, debt term, amortization term, and interest rate—these starter workbooks … [Read more...] about Using the Debt Amortization Starter Workbooks