Create a both a depreciation schedule and a summary of the book value of assets for the Bozeman City Golf course. Your workbook should, at a minimum, have the following characteristics: 1. 2. 4. Depreciation Schedule Allows for the entry of Purchase Price, Salvage Value, Year Purchased, Useful Life, Depreciation Method, and Asset Description for each asset. Allows the tracking of 25 assets simultaneously. 3. Spans the years 2015 to 2099. Includes today's date. 5. Ensures that the Salvage Value is less than the Purchase Price. 6. Ensures that the Useful Life is a whole number. 7. Ensures that the Asset Year + the Useful Life is less than the last year of the table 8. Allows the choice of Straight Line (SL), Sum of the Years Digit (SYD), or Double Declining Balance (DDB) depreciation for each asset. 9. Ensures that Asset Description and Year are always visible. 10. Calculates Total Depreciation for each yearthis amount should always be visible. 11. Ensures that depreciation for each asset begins in the Year Purchased and ends at the appropriate time period. 12. Is formatted to professional standards. 13. Has the depreciation schedule Cell Width set to at least 17 units. Asset Book Value 1. Maintains the formatting of the depreciation schedule with different coloring so that it is clear to the user exactly what s/he is seeing 2. Draws the purchase price through asset description data from the depreciation schedule. 3. Calculates Total Asset Value on an annual basis. Create a both a depreciation schedule and a summary of the book value of assets for the Bozeman City Golf course. Your workbook should, at a minimum, have the following characteristics: 1. 2. 4. Depreciation Schedule Allows for the entry of Purchase Price, Salvage Value, Year Purchased, Useful Life, Depreciation Method, and Asset Description for each asset. Allows the tracking of 25 assets simultaneously. 3. Spans the years 2015 to 2099. Includes today's date. 5. Ensures that the Salvage Value is less than the Purchase Price. 6. Ensures that the Useful Life is a whole number. 7. Ensures that the Asset Year + the Useful Life is less than the last year of the table 8. Allows the choice of Straight Line (SL), Sum of the Years Digit (SYD), or Double Declining Balance (DDB) depreciation for each asset. 9. Ensures that Asset Description and Year are always visible. 10. Calculates Total Depreciation for each yearthis amount should always be visible. 11. Ensures that depreciation for each asset begins in the Year Purchased and ends at the appropriate time period. 12. Is formatted to professional standards. 13. Has the depreciation schedule Cell Width set to at least 17 units. Asset Book Value 1. Maintains the formatting of the depreciation schedule with different coloring so that it is clear to the user exactly what s/he is seeing 2. Draws the purchase price through asset description data from the depreciation schedule. 3. Calculates Total Asset Value on an annual basis