EXPALIN anExcel workbook containingtwo depreciation schedule templates, each on a separate spreadsheet. One template should be a SL depreciation schedule and the other template should be a DDB depreciation schedule. You should construct the spreadsheets using the formulas and cell referencing so that when the value of input variables are altered the calculations which automatically adjust. The spreadsheet columns should include depreciation expense, accumulated depreciation, and book value end of year (see textbook 575-576 for examples). Please note, you can not depreciate assets below any salvage value, therefore you will need to use IF function (see IF function guidance below). You must construct the worksheet with the appropriate numeric format and professional layout.Round number values to the nearest whole dollar.The fixed variables for the assignment are as follows:

Life of asset = 10 years

Depreciation methods = straight-line or double-declining balance method

Purchase date of asset = January 1, 2018

PLEASE EXPLAIN DOUBLE DEPRECIATION METHODE AND STRAIGHT LINE WITH FORMULA PLEASE

IF Function a AutoSave . OFF Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 11 ~ A A 27 v ab Wrap Text v General ZAY- O. BI U V V LA Merge & Center v $ ~ % 9 08 28 Conditional Format Cell Insert Delete Format Sort & Find & Ideas Paste Formatting as Table Styles Filter Select SUM X V fx =1F99$B$ A C D E F G H K L M N 1 Purachse Date 1-Jan-18 2 Cost 100,000 3 Useful Life 10 4 Salvage 10,000 a UT 8 Year Depreciation Accumulated Depreciation Book Value 9 9000 9000 FALSE 10 9000 18000 =1F99$B$ 11 9000 27000 12 OUT A W N H 900 36000 13 000 45000 14 9000 54000 15 9000 6300 16 9000 72000 17 9000 81000 18 9000 90000 20 21 Input Variables Sales Rep Sales Bonus 22 Sales Goal $ 10,000 Taylor 11,000 23 Bonus 500 Jenny 10,000 24 Rick 9,000 OO 25 26 27 28 29 30 31 32 33 Sheet1 Sheet4 Sheet2 Sheet3 Olive Oil + + 125% EnterAutoSave . OFF IF Function Q Qv Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial 12 AA = ab Wrap Text General ZAY - O. Paste BIU E Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Ideas Formatting as Table Styles Filter Select D6 + X V fx B D E G H J K M N O P Q R 1 Olive Oil Variables Price Number of Gallons Total First 500 gallons $23 10 230 3 Gallons above 500 $20 483 11,109 500 11,500 1,600 33,500 10 11 12 14 19 20 25 26 27 28 29 30 31 Sheet1 Sheet4 Sheet2 Sheet3 Olive Oil + Ready + 130%