Prepare a straight$-$line 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. Include all calculations on the schedule.

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. Include all calculations on the schedule. 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. Include all calculations on the schedule.

Record the following in the general journal. Link$/$reference your amounts back to the cells on the depreciation schedule to create a functioning effective multi$-$use analysis tool for the business.

A$.$ Record the entry for the original purchase on Jan $1,$ Year $1.$

B$.$ Record the depreciation journal entry for Dec $31,$ year $1$ for all three methods. B$.$ Record the depreciation journal entry for Dec $31,$ year $1$ for all three methods.

C$.$ Record the journal entry if Assembly Machine sold on Jan $1,$ Year $4,$ for both Straightline and DDB methods.

D$.$ Record the journal entry if Assembly Machine is written down due to impairment on Dec $31$ Year $2,$ after depreciation recorded for the year for Units of Production method.

E$.$ Recalculate ONLY the year $1$ depreciation for each method if the machine had been purchased on May $1$ E$.$ Recalculate ONLY the year $1$ depreciation for each method if the machine had been purchased on May $1$ rather than Jan $1.$ Record the new year $\backslash (\backslash$mathbf$\{1\}\backslash )$ journal entry for this change. If no change is needed, please record $"$no change" in the journal entry.

Explain your answers to Req $2$C$.$ Are the results different or the same for the $2$ methods and why? Response must be supported by the schedule and journal entry response.