I need help with problem 5-41 using the template .

5-41. Refer to Problem 2-28 at the end of Chap- ter 2. Assume that the capital acquisitions in that problem were made at the begin ning of fiscal year 2016. It is now the end of fiscal year 2018. Prepare a schedule showing those capital assets, their cost, 530 Review chapter content and explore online res CHAPTER5 Capital Budgeting 211 al rate ate of acts? Why? ncial their useful life, the accumulated depreci- ation at the beginning of 2018, the depreci- ation expense charged for 2018 (assuming straight-line depreciation and no salvage value), the accumulated depreciation as of the end of the year, and the net book value (cost less accumulated depreciation) as of the end of 2018. Use a spreadsheet program such as Excel. As River Country may dispose of the items at different times, note that it is necessary to track each item separately. ap- ons in- nd ule st, line resources at study.sagepub.com/finkler5e the mill rate that the town charges its citizens will 2-28. River County is planning several capital acquisitions for the coming year. These include the purchase of two new garbage trucks at $150,000 each, one new bull- dozer at $240,000, three new riding lawn mowers at $16,0oo each, and construc- tion of an activity center in the park for $650,000. The expected lifetime of the various capital items is 1o years for gar- bage trucks, 8 years for the bulldozer, 5 years for the lawn mowers, and 40 years for the activity center. Prepare a capital budget for the items to be acquired, show- ing their estimated lifetimes and their per unit and total costs. 2-29. Zoo Extravaganza is a not-for-profit orga- Week 3 Case Study Template(2) (1) - Compatibility Mode Ex File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do 1 PROBLEM 5-41 2 Case Study Template for Week 3 5 CAPITAL ASSET SCHEDU Accumulated Beg of FY 2018 $0 Depreciation Accumulated End of FY 2018 S0 Net Book End of 2018 So Useful Annual Depreciation Expense Depreciation Value TEM Cost Life Depreciation for 2018 9 Garbage Trucks 10 Truck 1 11 Truck 2 12 Bulldozer 13 Lawn Mower 14 Mower 1 15 Mower 2 16 Mower 3 17 Activity Center 18 Total 10 10 $0 S0 40 S0 20 21 23 24 25 26 27 28 29 30 Problem 5-39