Using Depreciation Schedules
You create depreciation schedules to depreciate capital assets over time in formulas.
To use depreciation schedules:
-
From the Analysis grouping label, and then select Depreciation Scheduler.
-
Add a depreciation schedule—see Adding Depreciation Schedules.
-
Option: To change schedule lengths, in Schedule, select a schedule and click Length—see Setting the Length of Depreciation Schedules.
-
Delete a depreciation schedule–see Deleting Depreciation Schedule
-
Optional: To distribute the depreciation percentage across the schedule years, click each year cell and enter a percentage.
-
First column—Year number
-
Percent column—Percentage of depreciation per year. Use digits for percentages, for example, enter 20 for 20%, as opposed to .2. For salvage value reasons, the rates need not equal 100.
-
-
Click OK.
Adding Depreciation Schedules
To create depreciation schedules:
-
On Edit Depreciation Schedule, click Add.
-
In Name, enter a name.
-
In Length in Years enter a number of years.
-
Click OK.
Deleting Depreciation Schedule
To delete depreciation schedule:
-
From the Analysis grouping label, and then select Depreciation Scheduler.
-
On Edit Depreciation Schedule, select a Schedule from the drop-down, and then click Delete.
-
Click OK.
Setting the Length of Depreciation Schedules
To change the length of depreciation schedules:
-
On Edit Depreciation Schedule in Schedule, select a schedule, and click Length.
-
In New Length, enter a number of years.
-
Click OK.