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

I will test accuracy of your worksheet with random input variables ? acquisition cost and salvage value. Place your name in cell A1 of the worksheets. Review assignment rubric for specific grade evaluation.

Transcribed Image Text:

ABES 55 Home Insert Draw Page Layout X F2 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 1 2 Sales Goal $ 3 Bonus $ 19 20 21 22 23 24 25 26 27 28 AutoSave OFF 29 30 31 32 33 34 35 Paste 36 37 38 39 40 41 42 43 ^^ × ◄ Arial A Input Variables Sheet1 B B IU U ✔ V 10,000 500 с V Sheet4 12 fx =IF(E2>B$2,"$500","$0") D Sales Rep Taylor Jenny Rick Formulas Data ✓ A^ A V Sheet2 V A✓ E F Sales Bonus $ 11,000 $500 $10,000 $0 $ 9,000 $0 Sheet3 Review G Olive Oil + View H Tell me ab, Wrap Text I Merge & Center v J K IF Function General $ % 9 V L M 500 N .00 →→→0 Conditional Format Cell Formatting as Table Styles 0 P Q R L Insert S — IIX Delete T Format B U E WB Σ v V Share AP. O. Sort & Filter Find & Select W X Comments 4 Ideas + Y 100% ABES 55 Home Insert Draw Page Layout X F2 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 1 2 Sales Goal $ 3 Bonus $ 19 20 21 22 23 24 25 26 27 28 AutoSave OFF 29 30 31 32 33 34 35 Paste 36 37 38 39 40 41 42 43 ^^ × ◄ Arial A Input Variables Sheet1 B B IU U ✔ V 10,000 500 с V Sheet4 12 fx =IF(E2>B$2,"$500","$0") D Sales Rep Taylor Jenny Rick Formulas Data ✓ A^ A V Sheet2 V A✓ E F Sales Bonus $ 11,000 $500 $10,000 $0 $ 9,000 $0 Sheet3 Review G Olive Oil + View H Tell me ab, Wrap Text I Merge & Center v J K IF Function General $ % 9 V L M 500 N .00 →→→0 Conditional Format Cell Formatting as Table Styles 0 P Q R L Insert S — IIX Delete T Format B U E WB Σ v V Share AP. O. Sort & Filter Find & Select W X Comments 4 Ideas + Y 100%