please follow the information that i have provided within the screenshot and also the file that was attached in excel.

Purchase price Delivery cost Total cost Salvage value Depreciable base $25,000 $500 $1,500 Straight Line Depreciation Expense Net Book Value Double Declining Balance Depreciation Expense Net Book Value DDB Rate Year 1 Year 2 Year 3 Year 4 Year 1 Year 2 Year 3 Year 4 Units of Production Depreciation Expense Units of production rate Net Book Value MACRS Depreciation Expense Net Book Value Year 1 Year 2 Year 3 Year 4 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 MACRS Rate 20.00% 32.00% 19.20% 11.52% 11.52% 5.76% Estimated units produced Estimated life - 1,000,000 4 years The machine produced as follows: Year 1 Year 2 Year 3 Year 4 Units of production rate MACRS Rate 250,000 units 270,000 units 320,000 units 160,000 units Todd Service Company purchased a copier on January 1.. 2030:. The Following information applies to the copier purchased: Purchase price - $25,000 Delivery cost - $ 500 Estimated life - 4years Estimated copies 11000300 produced Salvage value $ 1.500 The copies produced as follows: Year 1 250,000 copies Year 2 270,000 copies Year 3 320,000 copies Year 4 1:50.000 copies Using Excel. determine the amount of depreciation expense and the net book value for each of the four years [6 years for MACRS} using each of the following methods: Straight-line Double-declining balance Units of production MACRS. assuming the machine is classied as ve-year property