fax_Depreciation_Calculation_Example_8

Asset acquired at beginning of accounting period in middle of fiscal year using Date of Purchase basis. Date of Purchase method based on Days.

System-Wide Configuration: Spread "Catch-Up' among Remaining Periods in Purchase Year

"Date of Purchase" Config: (see below) Actual # Days in each Purchase Year Period
FY: Calendar Year (January to December)
New Asset: Acquired July 1, 2000
Cost: $ 12,000
Depr Method: S/L 5 (20% each year),.Date of Purchase Basis
Annual Depr: (Years 1 to 5) 12,000 * 20% = 2,400
Current FY/Pd: FY: 2000 Pd: 10
Depr Yr/Pds Remaining: Depr Yr: 1 Days Remaining: 365 (at time of initialization)
Dates No Days FY FY Pd
Jul 1 to Jul 31, 2000 31 00 7
Aug 1 to Aug 31, 2000 31 00 8
Sept 1 to Sept 30, 2000 30 00 9
Oct 1 to Oct 31, 2000 31 00 10
Nov 1 to Nov 30, 2000 30 00 11
Dec 1 to Dec 31, 2000 31 00 12
Jan 1 to Jan 31, 2001 31 01 1
Feb 1 to Feb 28, 2001 28 01 2
Mar 1 to Mar 31, 2001 31 01 3
Apr 1 to Apr 30, 2001 30 01 4
May 1 to May 31, 2001 31 01 5
Jun 1 to Jun 30, 2001 30 01 6
365

End Of Purchase Year 1- Begin Purchase Year 2

Dates No Days FY FY Pd
Jul 1 to Jul 31, 2000 31 01 7
Aug 1 to Aug 31, 2001 31 01 8

and so on.

Basic Formula

(Annual Depr - PYTD Depr) * # Days in Curr Pd

# Days Remaining in PY

(Including Current Pd)

= Current Pd Depreciation
FY00 Pd 7: (2,400.00 - 0.00) = 1795.06 * 31

273

= 203.84
FY00 Pd 8: (2,400.00 - 203.84 = 2196.16 * 31

334

= 203.84
FY00 Pd 9: (2,400.00 - 407.68) = 1992.32 * 30

303

= 197.26
FY00 Pd 10: (2,400 - 604.94) = 1795.06 * 31

273

= 203.83
FY00 Pd 11: (2,400.00 - 808.77) = 1591.23 * 30

242

= 197.26
FY00 Pd 12: (2,400.00 - 1006.03) = 1393.97 * 31

212

= 203.84
FY00 Pd 1: (2,400.00 - 1209.87) = 1190.13 *31

181

= 203.84
FY01 Pd 2: (2,400.00 - 1413.71) = 986.29 * 28

150

= 184.11
FY01 Pd 3: (2,400.00 - 1597.82 = 802.18 * 31

122

= 203.83
FY01 Pd 4: (2,400.00 - 1801.65) = 598.35 * 30

91

= 197.26
FY01 Pd 5: (2,400.00 - 1998.91) = 401.09 * 31

61

= 203.83
FY01 Pd 6: (2,400.00 - 2202.74) = 197.26 * 30

30

= 197.26

End Of Purchase Year 1 - Begin Purchase Year 2

(Annual Depr - PYTD Depr) * # Days in Curr Pd

# Days Remaining in PY

(Including Current Pd)

= Current Pd Depreciation
FY01 Pd 7: (2,400.00 - 0.00) = 2400.00 * 31

365

= 203.84
FY01 Pd 8: (2,400.00 - 203.84) = 2196.16 * 31

334

= 203.84

...and so on.

In this example, the system-wide default configuration on the Configure Fixed Assets Settings screen has been used to "Catch-Up" any missed depreciation among the remaining periods of the purchase year. No periods are missed for this example, so there is no "Catch-Up" amount computed for any period.

The Date of Purchase configuration for this example has been changed from the default to use the actual number of days in each purchase year period. When this configuration option is selected, the Depr Start Date field on the G/L Book Info tab and Other Books Info subtask of the Manage Asset Master Information screen determines how many days will be used in the computation for the first period in the first purchase year. Because the Depr Start Date for this example is the first day of the period, the full number of days in the period was used to compute depreciation for the first purchase month.