help asap please
Part 1: Straight-Line depreciation PayA-use Excel formulas to calculate deprecation expense, accuntulat deprociation, and book valvos at 12/31 for each year. Par B - warng the Excel funcion (SLM) calculate the deptociation expense for yoan 1,0 and . Units of Production (Units of Output) depreciation Use Excelf formulas to calculate deprocisfion oxpense, accurutated depriciation, and book values at 12/31 for each year: Apply your formulas in Year 8 without considering whether you've depreciated too much or too little of the asset! Note: there is no Excel tx for unts or Production deprecation. Double-Declining Balance depreciation Part A - use Excelfomelas 10 calculale dopmolation expense, accumulated dopreciation, and book values at 12/31 for each year: Apply your formulas in Year 8 without considering whether you've depreciated too much or too little of the asset! Pait 8 - using the Excel functon (DDe), calculate the deprodation evpense for years 1,6 and 8 . Part 2: Part A - complete adjusting entries for each type of depreciation method as of 12/31/21. Part B - answer the question in the commentary section. Part 1 - Calculations Straight-Line Depreciation Part A: Construct formulas to caiculate Depreciation Expense for each year, and Accumulated Depreciation and Book Value at the end of each year. Part B) Using Excelfunction (fx SL.M), determine the depreciation expense fort Year 1 Year 6 Year 8 Construct formudas to calculate Deprecistion Expense for each year, and Accumulated Depreciatien and Book Value at the end of each yearf Apply the formula without convidening whether yeu've depreciated too much of too littie of the asset! Double-Declining Batance Depreclation Part Al Censtruct formulas to calculate Depreciation Expense for each year \& Accumulated Depreclation and thook Value at the end of each year. Part gi Using crcelfunction (fx000),determinethedepreciationexpensefori Prepare the adjusting journal entry for depreciation on 12/31/21 three different wayst 5 traight-Line Units of Production, and Double naellinine Balance. Adjusting Entry: Straight-tine Adjusting Entry; Uhits of Prod. Adjusking Entry DDB Are the calculations YOU made for depreciabien expense for Double-Declining Balance and Units of Production (in Part 1) coerect? (Aaswer Yes or No and explain why your caloulations are correct or incorrect.)