Create a both a depreciation schedule and a summary of the book value of assets for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 6. 7. Ensures that the Asset Year + the Useful Life is less than the last year of the table Allows the choice of Straight Line (SL), Sum of the Years Digit (SYD), or Double Declining Balance (DDB) depreciation for each asset. 8. 9. Ensures that Asset Description and Year are always visible. 10. Calculates Total Depreciation for each year-this 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 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. Calculates Total Asset Value on an annual basis. 1. 3. Hints Depreciation Schedule 1. Whenever possible, use named cells and ranges for the fields that involve calculations 2. Simplify your formula creation: a. 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. c. 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 every item in your formulas. 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. 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. 6. 7. Ensures that the Asset Year + the Useful Life is less than the last year of the table Allows the choice of Straight Line (SL), Sum of the Years Digit (SYD), or Double Declining Balance (DDB) depreciation for each asset. 8. 9. Ensures that Asset Description and Year are always visible. 10. Calculates Total Depreciation for each year-this 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 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. Calculates Total Asset Value on an annual basis. 1. 3. Hints Depreciation Schedule 1. Whenever possible, use named cells and ranges for the fields that involve calculations 2. Simplify your formula creation: a. 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. c. 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 every item in your formulas. 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.
Expert Answer:
Answer rating: 100% (QA)
A Depreciation Schedule And A Summary Of The Book Value Of Assets For The Bozeman City Golf Course For example say a company purchased a machine for 100000 and the machine had a useful life of ten yea... View the full answer
Related Book For
Cost management a strategic approach
ISBN: 978-0073526942
5th edition
Authors: Edward J. Blocher, David E. Stout, Gary Cokins
Posted Date:
Students also viewed these databases questions
-
A balloon is weighted so that it is barely able to float in water. If it is pushed beneath the surface, will it return to the surface, stay at the depth to which it is pushed, or sink? Explain.
-
A 200-mm-focal-length lens can be adjusted so that it is 200.0 mm to 208.2 mm from the film. For what range of object distances can it be adjusted?
-
A shaft is to be designed so that it is supported by roller bearings. The basic geometry is shown in the figure. The allowable slope at the bearings is 0.001 mm/mm without bearing life penalty. For a...
-
If Sam gives a speech where he teaches his audience how to deal with a parking ticket, he is most likely using what organizational framework? Problem-Solution O Spatial Chronological O Cause-Effect O...
-
Explain in words how Avogadros number could be obtained from the unit-cell edge length of a cubic crystal. What other data are required?
-
Which of the following is a secondary authority? a. Revenue Ruling b. Supreme Court decision c. Internal Revenue code section d. Wiley tax textbook
-
Estimate the energy required for an average person (see Fig. 9.32) to run a mile in 4 minutes in still standard air. Compare your estimate if you instead modeled the person as a cylinder \(6...
-
You have been asked to analyze the bids for 200 polished disks used in solar panels. These bids have been submitted by three suppliers: Thailand Polishing, India Shine, and Sacramento Glow. Thailand...
-
Molin Corporation is a manufacturer that uses job-order costing. The company closes out any overapplied or underapplied overhead to Cost of Goods Sold at the end of the year. The company has supplied...
-
On January 1, 2010, Porter Company purchased an 80% interest in the capital stock of Salem Company for $850,000. At that time, Salem Company had capital stock of $550,000 an retained earnings of...
-
What is the most we should pay for a bond with a par value of $ 1 0 0 0 , coupon rate of 4 . 3 % paid semi - annually, and a remaining life of 1 0 years? The bond is rated BBB , with a yield to...
-
A bank has capital of $200 and a leverage ratio of 5. If the value of the banks assets declines by 10 percent, then its capital will be reduced to a. $100. b. $150. c. $180. d. $185.
-
If the Fed wants to increase the money supply, it can a. raise income tax rates. b. reduce income tax rates. c. buy bonds in open-market operations. d. sell bonds in open-market operations.
-
Most economists are ________ that natural resources will eventually limit economic growth. As evidence, they note that the prices of most natural resources, adjusted for overall inflation, have...
-
If the reserve ratio is and the central bank increases the quantity of reserves in the banking system by $120, the money supply increases by a. $90. b. $150. c. $160. d. $480.
-
Recessions occur a. regularly, about every 3 years. b. regularly, about every 7 years. c. regularly, about every 12 years. d. irregularly.
-
Company A purchased inventory from a supplier on credit and has 30 days to pay the supplier. How would this transaction impact the accounting equation of Company A? Explain
-
Audrey purchases a riding lawnmower using a 2-year, no-interest deferred payment plan at Lawn Depot for x dollars. There was a down payment of d dollars and a monthly payment of m dollars. Express...
-
These sales and cost data (000s) are for two companies in the transportation industry: Company A Company B Amount % of Sales Amount % of Sales Sales $100,000 100% $100,000 100% Variable costs $60,000...
-
Waymouth Manufacturing operates a contract manufacturing plant located in Dublin, Ireland. The plant provides a variety of electronics products and components to consumer goods manufacturers around...
-
Name the five steps of the theory of constraints and explain the purpose of each. Which is the most important step and why?
-
Why is it important to test a theory? Why not simply accept a theory if it sounds right?
-
What is the intuition behind the geometric growth in interest?
-
You have $100,000 to donate to your college. You want to endow a perpetual scholarship that makes its first payment in 1 year. If the colleges discount rate is 4%, how large will the annual...
Study smarter with the SolutionInn App