You can use the asset depreciation starter workbooks shown in Figures 15-1 through 15-5 to construct depreciation schedules using a variety of asset depreciation conventions. Given three parametersâ€”original cost, salvage value, and estimated lifeâ€”these starter workbooks calculate the period … [Read more...] about Using the Asset Depreciation Starter Workbooks

# Using Excel

## Customizing the Debt Amortization Starter Workbooks

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

## Understanding the Variable Rate, Annuity Due Amortization Starter Workbook

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

## Understanding the Variable Rate, Ordinary Annuity 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

## Understanding the Fixed Rate, Annuity Due 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

## Understanding the Fixed Rate, Ordinary Annuity 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