Getivan Ranch Corboration has purchased a new tractor. The followire inforination is given Check Answers Legend Graded cell: Leave hlank if no answer is needed. fecuairnd: Scratcbead Use as a non-graded workspoce 1. Presare the following Straight-4ine depreciation schedule by wang the fucel sti. function to calculate Depreciation Expense and enterinc formulat for the remaining cells. Use absolvte cell teferences when appropnate. (Use cpis 44 to B12 from the given informabon to complete this question.? Check Answers Legend 2. Frepare the following Activity Bused depredation schedule by enterinc formulas. Use absolute cell relerosces when aperopeiate F Graded celc Leave blank if no answer is (Use cells A4 to B12 from the given information to complete this question.) neeceed. Sctatcheat Use as a non-graded workapsce 3. Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB function to calculate Depreciation Expense and entering formulas for the remaining cells. Use absolute cell references when appropriate. (Use cells A4 to B12 from the given information to complete this question.) Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. Nothing in this area will be graded, but it will be submitted with your assignment