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