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
Accounting
Easy Refresher: Asset Depreciation
Asset depreciation answers the question, “How much does the asset cost per period?” To answer that question, you need to: know the cost of the asset, estimate the number of periods in the asset’s useful life, project any salvage value the asset will have at the end of its useful life, and choose a … [Read more...] about Easy Refresher: Asset Depreciation
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