Business Template - Depreciation Schedule

Depreciation Schedule Base 12 months DayCount 3 Actual Days/365. Periods +12.00 in advance, monthly (first day of month) No Business Days: no days excluded * Depreciation Type 0 Straight Line 1 Declining Balance 2 Double Declining 3 Sum of Years Digits ProjMode 0 (0=Accruals, 1 = Cash) Total Depreciation 20 19 18 17 17 16 15 15 14 14 3 3 3 Value (Start Period) 200 180 161 143 126 109 93 78 63 49 35 31 28 Start Life (or Initial Final Depreciation Period Commencing Depreciation Decline Rate) Value Value Type * Jan 05 Jan 06 Jan 07 Jan 08 Jan 09 Jan 10 Jan 11 Jan 12 Jan 13 Jan 14 Jan 15 Jan 16 Jan 17 Jan 18 Plant Item No 1 1 Jan 06 10.00% 100 0 Depreciation 10 10 10 10 10 10 10 10 10 10 Value (Start Period) 100 90 80 70 60 50 40 30 20 10 Plant Item No 2 1 Jan 06 10.00% 100 1 Depreciation 10 9 8 7 7 6 5 5 4 4 3 3 3 Value (Start Period) 100 90 81 73 66 59 53 48 43 39 35 31 28 DayCount: Describes how the length of a timeperiod is calculated, particularly relevant where there are partial periods (ie the depreciation changes or terminates part-way through a timeperiod). You may need to consult the Business Functions Help File if you require more information. The most common options are 3 (Actual/365), 0 (30/360) and 6 (ACT/ACT in period). Periods: Describes when Depreciation actually occurs at various points during the year. It generally does not matter too much what it is in a depreciation function, where you often use Accruals mode (ProjMode=0) anyway. You may need to consult the Business Functions Help File if you require more information. Basically, -12 means monthly in arrear, -4 means quarterly in arrear, etc. You can also specify a series of values in mm.dd format, for example -3.10, -9.10 means bi-annually in arrear on 10th March and 10th of September.