Given Data:
Depreciation Type : Actual Days
Placed of Service:
Duration : 2 years
Year 1 : 50%
Year 2 : 50%
Asset Cost : 360
Salvage Value : 240
Basis : 360 - 240 = 120
First Month no. of days : 30
Day of Place of service : 16
First Month Formula
Basis * Year Percentage / Number of Months in a year * (Remaining Day/Days in First Month)
Remaining Day = FIrst Month no. of days - Day of Place of Service + 1
Last Month Formula
Basis * Year Percentage / Number of Months in a year * (Remaining Day/Days in First Month)
Remaining Day = 16 - 1
Remaining Day = Day of Place of Service - 1
Remaining Monthly Formula
Basis * Year Percentage / Number of Months in a year
Year # | Month # | Date | Transaction |
| Depreciated Value | Depreciation To Date |
1 | 1 | 11/16/2020 | Place in service |
|
| 0.00 |
1 | 1 | 11/30/2020 | Depreciation | 120 *.5 / 12 * (30 - 16 + 1 )/30 | 2.50 | 2.50 |
1 | 2 | 12/31/2020 | Depreciation | 120 *.5 / 12 | 5.00 | 7.50 |
1 | 3 | 01/31/2021 | Depreciation | 120 *.5 / 12 | 5.00 | 12.50 |
1 | 4 | 02/28/2021 | Depreciation | 120 *.5 / 12 | 5.00 | 17.50 |
1 | 5 | 03/31/2021 | Depreciation | 120 *.5 / 12 | 5.00 | 22.50 |
1 | 6 | 04/30/2021 | Depreciation | 120 *.5 / 12 | 5.00 | 27.50 |
1 | 7 | 05/31/2021 | Depreciation | 120 *.5 / 12 | 5.00 | 32.50 |
1 | 8 | 06/30/2021 | Depreciation | 120 *.5 / 12 | 5.00 | 37.50 |
1 | 9 | 07/31/2021 | Depreciation | 120 *.5 / 12 | 5.00 | 42.50 |
1 | 10 | 08/31/2021 | Depreciation | 120 *.5 / 12 | 5.00 | 47.50 |
1 | 11 | 09/30/2021 | Depreciation | 120 *.5 / 12 | 5.00 | 52.50 |
1 | 12 | 10/31/2021 | Depreciation | 120 *.5 / 12 | 5.00 | 57.50 |
2 | 1 | 11/30/2021 | Depreciation | 120 *.5 / 12 | 5.00 | 62.50 |
2 | 2 | 12/31/2021 | Depreciation | 120 *.5 / 12 | 5.00 | 67.50 |
2 | 3 | 01/31/2022 | Depreciation | 120 *.5 / 12 | 5.00 | 72.50 |
2 | 4 | 02/28/2022 | Depreciation | 120 *.5 / 12 | 5.00 | 77.50 |
2 | 5 | 03/31/2022 | Depreciation | 120 *.5 / 12 | 5.00 | 82.50 |
2 | 6 | 04/30/2022 | Depreciation | 120 *.5 / 12 | 5.00 | 87.50 |
2 | 7 | 05/31/2022 | Depreciation | 120 *.5 / 12 | 5.00 | 92.50 |
2 | 8 | 06/30/2022 | Depreciation | 120 *.5 / 12 | 5.00 | 97.50 |
2 | 9 | 07/31/2022 | Depreciation | 120 *.5 / 12 | 5.00 | 102.50 |
2 | 10 | 08/31/2022 | Depreciation | 120 *.5 / 12 | 5.00 | 107.50 |
2 | 11 | 09/30/2022 | Depreciation | 120 *.5 / 12 | 5.00 | 112.50 |
2 | 12 | 10/31/2022 | Depreciation | 120 *.5 / 12 | 5.00 | 117.50 |
3 | 1 (excess month for actual days) | 11/30/2022 | Depreciation | 120 *.5 /12 * (16 - 1 )/30 | 2.50 | 120.00 |
This is marked as Fully Depreciated when Total Months < Depreciated Months