Refer to Problem 2-28 at the end of Chapter 2. Assume that the capital acquisitions in that problem were made at the beginning of fiscal year 2012. It is now the end of fiscal year 2014. Prepare a schedule showing those capital assets, their cost, their useful life, the accumulated depreciation at the beginning of 2014, the depreciation expense charged for 2014 (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 2014. 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.
A. Solve using a spreadsheet program such as Excel.
B. Solve using a financial calculator (optional).