Question: Please ubize Excel to complete the requirements listed below. Make sure your answers are transfered to the appropriate blank in the Solutions ( orange tab

Please ubize Excel to complete the requirements listed below. Make sure your answers are transfered to the appropriate blank in the Solutions (orange tab) worksheet in this workbook. Make sure you are utilizing Excel functions, formatting, and calculation abilities where applicable. Your worksheets should be easy to read and labelled properly.Problet(Depreciation-SL, DDB, SYD, Act.) On January 1st,2022, Marco Company, a medium-sized manufacturer, acquired the following assetsCostSalvage ValueUseful LifeUnits of ProductionClass Life11Asset #1 $1,400,000$ 120,000520222023202455.00040,00035,0005Total units of output=150,00034Asset #2 $ 965,000 $ 50,000720222023202428,00016.00014,0007*Total units ofoutput=75,000Asiset #3 $ 800,000 $1020222023202475.00068.00055,00010Total units ofoutputInstructionsGeneral$%988FNumberThe following depreciation methods will be used (1) straight-line, (2) double-declining-balance;(3) sum-of-the-years'-digits, and (4) units-of-output(a) Calculate the annual depreciation for each of the three assets for each of the four depreciation methods described above. Provide the depreciation expense for years 2022,2023, and 2024. To complete this, utilize Excel worksheets and tools to create a table that is easy to read, useformulas and cell references where appropriate, and label the annual depreciation for each year Make sure all compenents are included such as depreciable cost, etcNOTE: Do not round units of activity in calculations but round final solutions to two digits.(b) Calculate the annual depreciation for each of the three assets for each of the four depreciation methods, assuming they were all purchased September 1st,2022. Provide the depreciation expense for years 2022,2023,2024Provide all solutions in the Solutions tab. Be sure to use cell references.(c )(1) Which depreciation method would maximize net income for financial statement reporting for the 3-year period ending December 31,2024 for Asset art in the (a) situation?(C)(2) Which depreciation method would minimize net income for financial statement reporting for the 3-year period ending December 31,2024 for Asset #2 in the (a) situation?
Please ubize Excel to complete the requirements

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!