Page History

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	ecdb5e56-0e2c-3e03-a39a-d088ee783b83
key	FA-197

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	ecdb5e56-0e2c-3e03-a39a-d088ee783b83
key	FA-155

Jira

server	JIRA
serverId	ecdb5e56-0e2c-3e03-a39a-d088ee783b83
key	FA-205

Jira

server	Jira
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	ecdb5e56-0e2c-3e03-a39a-d088ee783b83
key	FA-266

Jira

server	Jira
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	ecdb5e56-0e2c-3e03-a39a-d088ee783b83
key	FA-265

Expand

title	Full Month Convention Sample Computation

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

Monthly Depreciation Formula

Basis * Year Percentage / Number of Months in a year

Year #	Month #	Date	Transaction	Computation		Depreciation To Date
1	1	12/31/2020	Place in service			0.00
1	1	12/31/2020	Depreciation	120 * .5 /12	5.00	5.00
1	2	01/31/2021	Depreciation	120 * .5 /12	5.00	10.00
1	3	02/28/2021	Depreciation	120 * .5 /12	5.00	15.00
1	4	03/31/2021	Depreciation	120 * .5 /12	5.00	20.00
1	5	04/30/2021	Depreciation	120 * .5 /12	5.00	25.00
1	6	05/31/2021	Depreciation	120 * .5 /12	5.00	30.00
1	7	06/30/2021	Depreciation	120 * .5 /12	5.00	35.00
1	8	07/31/2021	Depreciation	120 * .5 /12	5.00	40.00
1	9	08/31/2021	Depreciation	120 * .5 /12	5.00	45.00
1	10	09/30/2021	Depreciation	120 * .5 /12	5.00	50.00
1	11	10/31/2021	Depreciation	120 * .5 /12	5.00	55.00
1	12	11/30/2021	Depreciation	120 * .5 /12	5.00	60.00
2	1	12/31/2021	Depreciation	120 * .5 /12	5.00	65.00
2	2	01/31/2022	Depreciation	120 * .5 /12	5.00	70.00
2	3	02/28/2022	Depreciation	120 * .5 /12	5.00	75.00
2	4	03/31/2022	Depreciation	120 * .5 /12	5.00	80.00
2	5	04/30/2022	Depreciation	120 * .5 /12	5.00	85.00
2	6	05/31/2022	Depreciation	120 * .5 /12	5.00	90.00
2	7	06/30/2022	Depreciation	120 * .5 /12	5.00	95.00
2	8	07/31/2022	Depreciation	120 * .5 /12	5.00	100.00
2	9	08/31/2022	Depreciation	120 * .5 /12	5.00	105.00
2	10	09/30/2022	Depreciation	120 * .5 /12	5.00	110.00
2	11	10/31/2022	Depreciation	120 * .5 /12	0	115.00
2	12	11/30/2022	Depreciation	120 * .5 /12	1	120.00

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

...

Expand

title	Mid Quarter Convention Sample Computation

Given Data:

Depreciation Type : Mid Year

Duration : 2 years

Year 1 : 50%

Year 2 : 50%

Asset Cost : 360

Salvage Value : 240

Basis : 360 - 240 = 120

Depreciation Formulas

Monthly Depreciation: (Basis * Depreciation Percentage / ( Years * 12)) = ((120 * 0.5)/ 12) = 60 / 12 = 5

Yearly Depreciation: Monthly Depreciation * 12 = 5 * 12 = 60

Quarterly Depreciation: Yearly Depreciation / 4 = 60 / 4 = 15

Mid Quarter Depreciation: Quarterly Depreciation / 2 = 15 / 2 = 7.5

The total depreciation on the quarter where the asset was placed in service should be 7.5.

Remaining Months In Quarter = No. of Months starting from Date In Service up to the last of month of the Quarter where the asset was placed in service.

Date In Service Jan 1, 2022: Remaining Months in Quarter: 3 (Jan, Feb, March)

Depreciation: Mid Quarter Depreciation / Remaining Months of the Quarter = 7.5 / 3 = 2.5

Next Month Depreciations after quarter depreciation: should use regular Monthly Depreciation: 5

Year #	Quarter #	Month #	Date	Transaction	Computation		Depreciation To Date
1	1	1	01/31/2022	Depreciation	7.5 / 3	2.50	2.50
1	1	2	02/28/2022	Depreciation	7.5 / 3	2.50	5.00
1	1	3	03/31/2022	Depreciation	7.5 / 3	2.50	7.50
1	2	4	04/30/2022	Depreciation	120 * .5 /12	5.00	12.50
1	2	5	05/31/2022	Depreciation	120 * .5 /12	5.00	17.50
1	2	6	06/30/2022	Depreciation	120 * .5 /12	5.00	22.50
1	3	7	07/31/2022	Depreciation	120 * .5 /12	5.00	27.50
1	3	8	08/31/2022	Depreciation	120 * .5 /12	5.00	32.5
1	3	9	09/30/2022	Depreciation	120 * .5 /12	5.00	37.50
1	4	10	10/31/2022	Depreciation	120 * .5 /12	5.00	42.50
1	4	11	11/30/2022	Depreciation	120 * .5 /12	5.00	47.50
1	4	12	12/31/2022	Depreciation	120 * .5 /12	5.00	52.50
2	1	1	01/31/2023	Depreciation	120 * .5 /12	5.00	57.50
2	1	2	02/31/2023	Depreciation	120 * .5 /12	5.00	62.50
2	1	3	03/28/2023	Depreciation	120 * .5 /12	5.00	67.50
2	2	4	04/31/2023	Depreciation	120 * .5 /12	5.00	72.50
2	2	5	05/30/2023	Depreciation	120 * .5 /12	5.00	77.50
2	2	6	06/31/2023	Depreciation	120 * .5 /12	5.00	82.50
2	3	7	07/30/2023	Depreciation	120 * .5 /12	5.00	87.50
2	3	8	08/31/2023	Depreciation	120 * .5 /12	5.00	92.50
2	3	9	09/31/2023	Depreciation	120 * .5 /12	5.00	97.50
2	4	10	10/30/2023	Depreciation	120 * .5 /12	5.00	102.50
2	4	11	11/31/2023	Depreciation	120 * .5 /12	5.00	107.50
2	4	12	12/30/2023	Depreciation	120 * .5 /12	5.00	112.50
3	1	1	01/31/2024	Depreciation	120 * .5 /12	5.00	117.50
3	1	2	02/29/2024	Depreciation	120 * .5 /12	2.50	120.00

Given Data:

Depreciation Type : Mid Year

Duration : 2 years

Year 1 : 50%

Year 2 : 50%

Asset Cost : 360

Salvage Value : 240

Basis : 360 - 240 = 120

Depreciation Formulas

Monthly Depreciation: (Basis * Depreciation Percentage / ( Years * 12)) = ((120 * 0.5)/ 12) = 60 / 12 = 5

Yearly Depreciation: Monthly Depreciation * 12 = 5 * 12 = 60

Quarterly Depreciation: Yearly Depreciation / 4 = 60 / 4 = 15

Mid Quarter Depreciation: Quarterly Depreciation / 2 = 15 / 2 = 7.5

The total depreciation on the quarter where the asset was placed in service should be 7.5.

Remaining Months In Quarter = No. of Months starting from Date In Service up to the last of month of the Quarter where the asset was placed in service.

Date In Service Feb 1, 2022: Remaining Months in Quarter: 2 (Feb, March)

Depreciation: Mid Quarter Depreciation / Remaining Months of the Quarter = 7.5 / 2 = 3.75

Next Month Depreciations after quarter depreciation: should use regular Monthly Depreciation: 5

Year #	Quarter #	Month #	Date	Transaction	Computation		Depreciation To Date
1	1	2	02/28/2022	Depreciation	7.5 / 2	3.75	3.75
1	1	3	03/31/2022	Depreciation	7.5 / 2	3.75	7.50
1	2	4	04/30/2022	Depreciation	120 * .5 /12	5.00	12.50
1	2	5	05/31/2022	Depreciation	120 * .5 /12	5.00	17.50
1	2	6	06/30/2022	Depreciation	120 * .5 /12	5.00	22.50
1	3	7	07/31/2022	Depreciation	120 * .5 /12	5.00	27.50
1	3	8	08/31/2022	Depreciation	120 * .5 /12	5.00	32.5
1	3	9	09/30/2022	Depreciation	120 * .5 /12	5.00	37.50
1	4	10	10/31/2022	Depreciation	120 * .5 /12	5.00	42.50
1	4	11	11/30/2022	Depreciation	120 * .5 /12	5.00	47.50
1	4	12	12/31/2022	Depreciation	120 * .5 /12	5.00	52.50
2	1	1	01/31/2023	Depreciation	120 * .5 /12	5.00	57.50
2	1	2	02/31/2023	Depreciation	120 * .5 /12	5.00	62.50
2	1	3	03/28/2023	Depreciation	120 * .5 /12	5.00	67.50
2	2	4	04/31/2023	Depreciation	120 * .5 /12	5.00	72.50
2	2	5	05/30/2023	Depreciation	120 * .5 /12	5.00	77.50
2	2	6	06/31/2023	Depreciation	120 * .5 /12	5.00	82.50
2	3	7	07/30/2023	Depreciation	120 * .5 /12	5.00	87.50
2	3	8	08/31/2023	Depreciation	120 * .5 /12	5.00	92.50
2	3	9	09/31/2023	Depreciation	120 * .5 /12	5.00	97.50
2	4	10	10/30/2023	Depreciation	120 * .5 /12	5.00	102.50
2	4	11	11/31/2023	Depreciation	120 * .5 /12	5.00	107.50
2	4	12	12/30/2023	Depreciation	120 * .5 /12	5.00	112.50
3	1	1	01/31/2024	Depreciation	120 * .5 /12	5.00	117.50
3	1	2	02/29/2024	Depreciation	120 * .5 /12	2.50	120.00

Given Data:

Depreciation Type : Mid Year

Duration : 2 years

Year 1 : 50%

Year 2 : 50%

Asset Cost : 360

Salvage Value : 240

Basis : 360 - 240 = 120

Depreciation Formulas

Monthly Depreciation: (Basis * Depreciation Percentage / ( Years * 12)) = ((120 * 0.5)/ 12) = 60 / 12 = 5

Yearly Depreciation: Monthly Depreciation * 12 = 5 * 12 = 60

Quarterly Depreciation: Yearly Depreciation / 4 = 60 / 4 = 15

Mid Quarter Depreciation: Quarterly Depreciation / 2 = 15 / 2 = 7.5

The total depreciation on the quarter where the asset was placed in service should be 7.5.

Remaining Months In Quarter = No. of Months starting from Date In Service up to the last of month of the Quarter where the asset was placed in service.

Date In Service March 1, 2022: Remaining Months in Quarter: 1 (March)

Depreciation: Mid Quarter Depreciation / Remaining Months of the Quarter = 7.5 / 1 = 7.5

Next Month Depreciations after quarter depreciation: should use regular Monthly Depreciation: 5

Year #	Quarter #	Month #	Date	Transaction	Computation		Depreciation To Date
1	1	3	03/31/2022	Depreciation	7.5 / 1	7.50	7.50
1	2	4	04/30/2022	Depreciation	120 * .5 /12	5.00	12.50
1	2	5	05/31/2022	Depreciation	120 * .5 /12	5.00	17.50
1	2	6	06/30/2022	Depreciation	120 * .5 /12	5.00	22.50
1	3	7	07/31/2022	Depreciation	120 * .5 /12	5.00	27.50
1	3	8	08/31/2022	Depreciation	120 * .5 /12	5.00	32.5
1	3	9	09/30/2022	Depreciation	120 * .5 /12	5.00	37.50
1	4	10	10/31/2022	Depreciation	120 * .5 /12	5.00	42.50
1	4	11	11/30/2022	Depreciation	120 * .5 /12	5.00	47.50
1	4	12	12/31/2022	Depreciation	120 * .5 /12	5.00	52.50
2	1	1	01/31/2023	Depreciation	120 * .5 /12	5.00	57.50
2	1	2	02/31/2023	Depreciation	120 * .5 /12	5.00	62.50
2	1	3	03/28/2023	Depreciation	120 * .5 /12	5.00	67.50
2	2	4	04/31/2023	Depreciation	120 * .5 /12	5.00	72.50
2	2	5	05/30/2023	Depreciation	120 * .5 /12	5.00	77.50
2	2	6	06/31/2023	Depreciation	120 * .5 /12	5.00	82.50
2	3	7	07/30/2023	Depreciation	120 * .5 /12	5.00	87.50
2	3	8	08/31/2023	Depreciation	120 * .5 /12	5.00	92.50
2	3	9	09/31/2023	Depreciation	120 * .5 /12	5.00	97.50
2	4	10	10/30/2023	Depreciation	120 * .5 /12	5.00	102.50
2	4	11	11/31/2023	Depreciation	120 * .5 /12	5.00	107.50
2	4	12	12/30/2023	Depreciation	120 * .5 /12	5.00	112.50
3	1	1	01/31/2024	Depreciation	120 * .5 /12	5.00	117.50
3	1	2	02/29/2024	Depreciation	120 * .5 /12	2.50	120.00

Page tree

Versions Compared

Old Version 22

New Version Current

Key