Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer on an excel spreadsheet with formulas/explanations. thanks! YouTube 6. Project.pdf Mind Tup-Cengage Learning Minbox (3,116) - dbomb111209 X Depreciation Project.pdf Create a both

please answer on an excel spreadsheet with formulas/explanations. thanks!
image text in transcribed
YouTube 6. Project.pdf Mind Tup-Cengage Learning Minbox (3,116) - dbomb111209 X Depreciation Project.pdf 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: Depreciation Schedule 1. Allows for the entry of Purchase Price, Salvage Value, Year Purchased, Useful Life, Depreciation Method, and Asset Description for each asset. 2. Allows the tracking of 25 assets simultaneously. 3. Spans the years 2015 to 2099. 4. Includes today's date. 5. Ensures that the Salvage Value is less than the Purchase Price 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 cach 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. Hints Depreciation Schedule 1. Whenever possible, use named cells and ranges for the fields that involve calculations 2 Simplify your formula creation: 1. First, figure out how to put something, anything (maybe yes, no) in the correct cells based on year purchased and useful life. b. Second, figure out how to calculate the correct period for DDB and SYD based on the year and the year the equipment was purchased. Third, figure out how to calculate depreciation for each method. d. Once you have a, b, c working individually, put them together and create one big honking formula that you can copy across and down the schedule! Asset Value 1. Use hints 1 and 2 above, but note you may not be able to use named cells and references for cvery item in your formulus. 2 Insert a column immediately to the left of 2015, then leave it blank. You may need it to do your calculations. Once the calculations are working properly, you may hide that column for aesthetic reasons. If you end up not needing the column, you may delete it YouTube 6. Project.pdf Mind Tup-Cengage Learning Minbox (3,116) - dbomb111209 X Depreciation Project.pdf 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: Depreciation Schedule 1. Allows for the entry of Purchase Price, Salvage Value, Year Purchased, Useful Life, Depreciation Method, and Asset Description for each asset. 2. Allows the tracking of 25 assets simultaneously. 3. Spans the years 2015 to 2099. 4. Includes today's date. 5. Ensures that the Salvage Value is less than the Purchase Price 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 cach 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. Hints Depreciation Schedule 1. Whenever possible, use named cells and ranges for the fields that involve calculations 2 Simplify your formula creation: 1. First, figure out how to put something, anything (maybe yes, no) in the correct cells based on year purchased and useful life. b. Second, figure out how to calculate the correct period for DDB and SYD based on the year and the year the equipment was purchased. Third, figure out how to calculate depreciation for each method. d. Once you have a, b, c working individually, put them together and create one big honking formula that you can copy across and down the schedule! Asset Value 1. Use hints 1 and 2 above, but note you may not be able to use named cells and references for cvery item in your formulus. 2 Insert a column immediately to the left of 2015, then leave it blank. You may need it to do your calculations. Once the calculations are working properly, you may hide that column for aesthetic reasons. If you end up not needing the column, you may delete it

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investing From Scratch A Handbook For The Young Investor

Authors: James Lowell

1st Edition

014303684X, 978-0143036845

More Books

Students also viewed these Finance questions