Mary Coleman manufactures and distributes high-tech biking gadgets. Required: (1) Make a workpaper which shows the following:

Calculation of the amount Bonus Depreciation, MACRS Depreciation and Amortization for 2023. o Assume for years prior to 2023 no Section 179 or bonus depreciation were taken. For 2023 No Section 179 will be elected, Bonus Depreciation will be taken on any eligible 2023 assets.

Properly report the transactions on an excel spreadsheet showing, current year bonus depreciation, current year depreciation, current year amortization, current year amortization on prior year intangibles and depreciation on prior year assets. I would expect the columns listed below and add a column for Bonus Depreciation, a column for Adjusted Basis, a column for the factor you are using for current year depreciation, current year depreciation.

Do not recalculate Accumulated Depreciation. Assume it is correct. Assets:

Assets	Date	Convention/Yr	Cost	Accum Deprec 1/1/23
Machinery	2/1/20	MACRS HY/7	100000	56270
Building	1/1/20	S/L MM/39	300000	22767
Land	1/1/20	None	125000
Computers	7/1/20	MACRS HY/5	60000	42720
Machinery	1/1/22	MACRS HY/7	20000	2858
Patents	2/1/22	S/L 180 Months	80000	4889
Computers	2/1/23	MACRS HY/5	30000
Machinery	7/1/23	MACRS HY/7	40000
Patents	6/1/23	S/L 180 Months	100000