Sheet3 Sheet2 Sheet1 A B C D E G H Name Section F End of Problem Data Input Section: Estimated residual value Estimated useful life Depreciation Expense Per Year Helpful Hint: Use the following functions to calculate depreciation =SLN(cost,salvage,life) Output Section: Year ended December 31 Depreciation expense Accumulated depreciation Partial Balance Sheet Machine December 31 Less accumulated depreciation A s s e t s = #1 #2 Cash Accum. Depr. Liabilities + Stockholder’s Equity Problem 3-59A Cost of asset, January 1, 2010 Part 1. Part 2. Part 3. Part 4. Amount Formula 1 Fomula 2 Title Formula 3 Formula 4 Formula 5 Formula 6 Type answer starting here Charlotte Motorcycle Repair Corporation Reimers, Financial Accounting 3e 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00 13.00 2010.00 2011.00 2012.00 2013.00 14.00 15.00 16.00 17.00 18.00 19.00 20.00 21.00 22.00 23.00 24.00 2010.00 25.00 26.00 27.00 28.00 29.00 30.00 31.00 211.00 2010.00 32.00 33.00 34.00 35.00 36.00 37.00 38.00 39.00 40.00 Sheet3 Sheet2 Sheet1 A B C D E G H Name Section F End of Problem Data Input Section: Estimated residual value Estimated useful life Depreciation Expense Per Year Helpful Hint: Use the following functions to calculate depreciation =SLN(cost,salvage,life) Output Section: Year ended December 31 Depreciation expense Accumulated depreciation Partial Balance Sheet Machine December 31 Less accumulated depreciation A s s e t s = #1 #2 Cash Accum. Depr. Liabilities + Stockholder’s Equity Problem 3-59A Cost of asset, January 1, 2010 Part 1. Part 2. Part 3. Part 4. Amount Formula 1 Fomula 2 Title Formula 3 Formula 4 Formula 5 Formula 6 Type answer starting here Charlotte Motorcycle Repair Corporation Reimers, Financial Accounting…
Attachments:
p3-59a.xls