You can use the sum-of-the-years’-digits depreciation starter workbook shown in Figure 15-3 to construct depreciation schedules with the sum-of-the-years’-digits method. In general, you use this starter workbook if you’ve selected or been counseled by your tax ad- viser to use the … [Read more...] about Understanding the Sum-of-the-Years’-Digits Depreciation Starter Workbook
Understanding the Declining Balance Depreciation Starter Workbook
In general, you use the declining balance depreciation starter workbook (see Figure 15-2) if you’ve selected or been counseled by your tax adviser to use a declining balance convention, such as Accelerated Cost Recovery System (ACRS) or modified Accelerated Cost Recovery System (MACRS), for tax … [Read more...] about Understanding the Declining Balance Depreciation Starter Workbook
Understanding the Straight-Line Depreciation Starter Workbook
The straight-line depreciation starter workbook has two parts: the Straight-Line Depreciation Calculation Inputs box in the range A2:B6 and the Straight-Line Depreciation Schedule, starting with the title in row 8 (see Figure 15-1). Straight-Line Depreciation Calculation Inputs The calculation … [Read more...] about Understanding the Straight-Line Depreciation Starter Workbook
Using the Asset Depreciation Starter Workbooks
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
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