Need help. Formulas would be helpful. Thanks!!

2 Fecord the followine in the general joumal, Unk/roference your amounts bock to the cells on the depteciation. A. Record the entry for the original purchase on lan 1, Year 1. B. Record the depreciation journal eatry for Dec 31, vear 2 for all three methods. Prepare a units of production depreciation schedule using Excel/Sheet formulas for years 1-5. The schedule should start with the purchase date, and include the cost, and for each year: the depreciation expense, the accumulated depreciation, the cost, and the book value. Round to 2 decimal places. Prepare a double declining balance depreciation schedule using Excel/Sheet formulas for years 1-5. The schedule should start with the purchase date, and include the cost, and for each year: the depreciation expense, the accumulated depreciation, the cost, and the book value. Round to 2 decimal places. REQUIRED FOR POINTS: Complete a depreciation schedule for the new assembly machine using all 3 depreciation methods. Link/reference all cells on your depreciation schedules back to the Master Fixed Asset record. Use the 1 math functionality as needed. Referencing 'answer' cells (schedules) back to 'input' cells (fixed asset record) creates a functioning, effective worksheet. Making these connections allows the worksheet to be used for analyzing potential changes in the results. Bardmen Corp has purchased a new Assembly Machine on Jan 1, 2073 paying 10% of the purchase price in cashand signing a 5 year note for the balance. The following information is known: Use Learning fesources (Sliota) and Ebook Ch 9 . D. Record the journsi entry for Units of Froduction if Assembly Muchine a written down due to impairment on Dec 31 Year 2, after depreciation recorded. E. Recalculate ONiY the year 1 depreciation for each method if the machine had been purchased on June 1 rather than ian 1 . Record the new year 1 journal entry for this change. If no change is needed, please record "ho change" in the journal enty. 3 Explain your aniwen to leq2C. Are the results different or the same for the 2 methods and why