Using Excel as your tool:

$1.$ Add a column to the provided file titled $$FinalDepreciation$.$

$$ Use formulas to calculate the amount of depreciation expense for each asset that should be taken for $2021.$ DO NOT input numbers.

$$ Pay attention to whether the asset has been $$Retired$.$ Remember from Chapter $5$ that we have to make a partial year adjustment if the asset is disposed of before it is fully depreciated.

$2.$ Add a second column to the provided file titled $$AccumulatedDepreciation$.$

$$ Use formulas to calculate the total accumulated depreciation for each asset as of December $31,2021($calculated as $$BOY Accumulated Depreciation$$ plus FinalDepreciation$).$

$3.$ Calculate the total $2021$ depreciation expense of all assets $($not total accumulated depreciation$).$

$4.$ Two decimal places.

$5.$ Save your spreadsheet with filename: Group#$\_$Alteryx$\_$Part$1.$xlsx

$$ Replace the # with your group number

$6.$ You do not need to test for mid$-$quarter convention $($you will do this in a later requirement$).$ You should

calculate the depreciation amounts based on the conventions reported by the client.

$([$BOY Basis$]+[$Additions$])*[$DepRateWithRetirements$]\backslash$table$[[$ID$,$Description,$\backslash$table$[[$Date$],[$Purchased$]],\backslash$table$[[$Date Placed$],[$in Service$]],\backslash$table$[[$Date$],[$Retired$]],$Property Type,$\backslash$table$[[$Recovery$],[$Period$]],$Convention,Method,$\backslash$table$[[$BOY$],[$Basis$]],$Additions,Retirements,$\backslash$table$[[$EOY$],[$Basis$]],\backslash$table$[[$BOY Accumulated$],[$Dep$]]],[1001,$Helicopter,$15/1/2018,15/1/2018,,$Personal,$5,HY,200DB,285,000,,,285,000,202,920],[1002,\backslash$table$[[$Building$]],15/1/2018,15/1/2018,\frac{31}{7}\frac{?}{2021},$Real Nonresidential,$39,$MM$,SL,950,000,,950,000,\backslash$table$[[-,-,-1]],72,096],[1003,$Bus,$15/2/2018,15/2/2018,9/8/2021,$Personal,$5,HY,200DB,57,000,,57,000,-,40,584],[1004,\backslash$table$[[$Office$],[],[$Equipment$]],15/2/2018,15/2/2018,,$Personal,$7,$HY$,200$DB$,47,500,,,47,500,26,728],[1005,\backslash$table$[[$Computer$],[$Equipment$]],15/2/2018,15/2/2018,,$Personal,$5,$HY$,200$DB$,19,000,,,19,000,13,528],[1006,\backslash$table$[[$Warehouse$],[$Equipment$]],15/2/2018,15/2/2018,,$Personal,$7,$HY$,200$DB$,142,500,,,142,500,80,185],[1007,$Freezer,$\frac{15}{2}\frac{?}{2018},15/2/2018,\frac{31}{12}\frac{?}{2021},$Personal,$5,HY,200DB,28,500,,28,500,-,20,292],[1008,$Forklift,$15/2/2018,15/2/2018,\frac{17}{1}\frac{?}{2021},$Personal,$5,HY,200DB,16,150,,16,150,-,11,499],[1009,$Copier,$\frac{1}{3}\frac{?}{2018},\frac{1}{3}\frac{?}{2018},1/6/2021,$Personal,$5,HY,200DB,7,500,,7,500,\backslash$table$[[-],[-],[-10]],5,340],[1010,$Delivery Van,$\frac{4}{3}\frac{?}{2021},\frac{4}{3}\frac{?}{2021},,$Personal,$5,HY,200DB,-,25,000,\backslash$table$[[-,-]],25,000,],[1011,\backslash$table$[[$Office$],[$Furniture and$],[$Equipment$]],15/8/2021,15/8/2021,,$Personal,$7,$HY$,200$DB$,-,332,500,-,332,500,-]]$