MBA's Guide to Microsoft Excel

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 calibrate its estimated life, or identifies the supporting docu- mentation for the schedule. You can also increase or decrease the number of periods.

Changing the Number of Periods

You can easily increase or decrease the number of periods shown in any of the asset depre- ciation schedules. To increase the number of periods, remove the border from the last row of the depreciation schedule and then copy the current last row of the schedule (the row for Period 20) down as needed. To decrease the number of periods, simply delete any unneeded rows from the bottom of the schedule.

Chapter Contents:

• EasyRefresher: Asset Depreciation
• Using the Asset Depreciation Starter Workbooks
• Understanding the Straight-Line Depreciation Starter Workbook
• Understanding the Declining Balance Depreciation Starter Workbook
• Understanding the Sum-of-the-Years’-Digits Depreciation Starter Workbook
• Understanding the Annuity or Sinking Fund Depreciation Starter Workbook
• Understanding the Activity Depreciation Starter Workbook
• Customizing the Asset Depreciation Starter Workbooks