Create an Excel workbook containing two 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

AutoSave OFF BESU- | IF Function Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X V Arial 12 ~ AF = = v ab Wrap Text 480 General V Do LIX s Paste B I U A Merge & Center $ % ) * 40 .00 00 0 Insert Delete Format Ideas Conditional Format Formatting as Table Cell Styles v Sort & Filter Find & Select D6 x fx A B D E F G H 1 J L M N 0 P Q R S 1 Olive Oil Variables 2 First 500 gallons 3 Gallons above 500 Price $23 $20 Number of Gallons 10 483 500 1,600 Total 230 11,109 11,500 33,500 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Sheet1 Sheet4 Sheet2 Sheet3 Olive Oil + Ready - + 130%