You can use the asset depreciation starter workbooks for a wide variety of depreciation calculations. However, you might want to change the starter workbooks so that they more precisely meet your requirements. For example, you can add text that describes the asset, describes the units of use that … [Read more...] about Customizing the Asset Depreciation Starter Workbooks

# Using Excel

## Understanding the Activity Depreciation Starter Workbook

You can use the activity depreciation starter workbook shown in Figure 15-5 to construct depreciation schedules with the activity method. The activity method is unique among depreciation methods because it expenses the original cost of an asset based on use rather than on time. In general, you use … [Read more...] about Understanding the Activity Depreciation Starter Workbook

## Understanding the Annuity or Sinking Fund Depreciation Starter Workbook

You can use the annuity or sinking fund depreciation starter workbook, shown in Figure 15-4, to construct depreciation schedules with the annuity or sinking fund depreciation methods. The annuity and sinking fund depreciation methods include, as part of the depreciation expense, a return on the … [Read more...] about Understanding the Annuity or Sinking Fund Depreciation Starter Workbook

## Understanding the Sum-of-the-Years’-Digits Depreciation Starter Workbook

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