Question

EXCEL

Sullivan ranch corporation has purchased a new tractor and has provided the information related to the purchase. the controller has asked you to calculate the depreciation for the new piece of equipment using different methods. straight-line depreciation, units of production depreciation, snd double-declining balance depreciation. use the information included in the excel simulation and EXCEL FUNCTION FORMULAS described below to complete the task.

Answer 1

Answer is given below

For excel formulas Screen shot is given

For units of production method absolute reference is used and for DDB method - DDB formula in excel has been used.

Screen shots given for both.

Answer 2