Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

...

Given Data:

Depreciation Type : Mid-Month

Duration : 2 years

Year 1 : 50%

Year 2 : 50%

Asset Cost : 360

Salvage Value : 240

Basis : 360 - 240 = 120

First and Last Monthly Formula

Basis * Year Percentage / Number of Months in a year / 2

Remaining Monthly Formula

Basis * Year Percentage / Number of Months in a year

Expand

title	Imported Assets

Expand

title	Mid Month Convention Sample Computation

Year #	Month #	Date	Transaction	Computation	Depreciated Value	Depreciation To Date
1	1	12/31/2020	Place in service	0	0	0.00
1	1	12/31/2020	Depreciation	120 * .5 / 12 / 2	2.5	2.50
1	2	01/31/2021	Depreciation	120 * .5 / 12	5	7.50
1	3	02/28/2021	Depreciation	120 * .5 / 12	5	12.50
1	4	03/31/2021	Depreciation	120 * .5 / 12	5	17.50
1	5	04/30/2021	Depreciation	120 * .5 / 12	5	22.50
1	6	05/31/2021	Depreciation	120 * .5 / 12	5	27.50
1	7	06/30/2021	Depreciation	120 * .5 / 12	5	32.50
1	8	07/31/2021	Depreciation	120 * .5 / 12	5	37.50
1	9	08/31/2021	Depreciation	120 * .5 / 12	5	42.50
1	10	09/30/2021	Depreciation	120 * .5 / 12	5	47.50
1	11	10/31/2021	Depreciation	120 * .5 / 12	5	52.50
1	12	11/30/2021	Depreciation	120 * .5 / 12	5	57.50
2	1	12/31/2021	Depreciation	120 * .5 / 12	5	62.50
2	2	01/31/2022	Depreciation	120 * .5 / 12	5	67.50
2	3	02/28/2022	Depreciation	120 * .5 / 12	5	72.50
2	4	03/31/2022	Depreciation	120 * .5 / 12	5	77.50
2	5	04/30/2022	Depreciation	120 * .5 / 12	5	82.50
2	6	05/31/2022	Depreciation	120 * .5 / 12	5	87.50
2	7	06/30/2022	Depreciation	120 * .5 / 12	5	92.50
2	8	07/31/2022	Depreciation	120 * .5 / 12	5	97.50
2	9	08/31/2022	Depreciation	120 * .5 / 12	5	102.50
2	10	09/30/2022	Depreciation	120 * .5 / 12	5	107.50
2	11	10/31/2022	Depreciation	120 * .5 / 12	5	112.50
2	12	11/30/2022	Depreciation	120 * .5 / 12	5	117.50
3	1 (excess month for mid month)	12/31/2022	Depreciation	120 * .5 / 12 / 2	2.5	120.00

This is marked as Fully Depreciated when Total Months < Depreciated Months