Need help figuring out how to enter all answers in yellow boxes as a formula in excel

1. Prepare depreciation schedules using Straight-Line, Activity Based, and Double-Dedlining Balance Depreciation OME INSERT PAGE LAYOAUT ORMULASDATA REMEW AI Sullivan Ranch Corporation has purchased a new tractor. The fellewing Slwan Ranch Corret has purchased a new tractor The folowing information s gven $ 150,000 s Cost 4 Estmated Residual:10,000 5 Estimated years 6 Estimated Lifle in hours ual Hours war year 2 270 LI Year 4 220 Prepare the lollowing Straight Line depreciation schedule by using the excel SLN FUNCTION (ix) to calkculate the 13 Depreciation Expense for whan 14 the Depreciation Expensecohann. Enter formulas or absolute cell references for the remaining cels Book Value 25 Prepare the followng 6 Use absolute cell reterences when 5 Prepare the 57 calculate Depreclation Expense for Years 1-4 in the Depreclation Expense column Enter formulas or absolute cel references for the remaining cells