program
knohe_
spreadsheet_for_problem_14-7.xlsxSheet1
| P 14-7 | My name | |||||||||
| Depreciation Schedule for year | ||||||||||
| Account Number | Description | Date Placed in Service | Estimated Useful Life | Acquisition Cost | Salvage Value | Beginning Accumulated Depreciation | Current Period Depreciation | Ending Accumulated Depreciation | Net Book Value | |
| 11001 | Desk | 4/5/08 | 5 | $500 | $100 | |||||
| 11100 | Laptop | 5/2/09 | 5 | $2,400 | $400 | |||||
| 11200 | Workstation | 3/25/08 | 5 | $1,900 | $250 | |||||
| 11050 | Chair | 2/1/05 | 5 | $750 | $50 | |||||
| 11500 | Software | 7/1/10 | 3 | $750 | $0 | |||||
| 11500 | Software | 6/30/09 | 3 | $2,100 | $0 | |||||
| 11500 | Software | 1/31/07 | 3 | $900 | $0 | |||||
| 11300 | Monitor | 2/20/09 | 4 | $800 | $100 | |||||
| 11300 | Monitor | 9/30/05 | 4 | $1,200 | $100 | |||||
| 11300 | Monitor | 10/15/08 | 4 | $600 | $100 | |||||
| 11001 | Desk | 4/4/09 | 5 | $1,000 | $150 | |||||
| 11001 | Desk | 8/8/05 | 5 | $1,500 | $250 | |||||
| 11050 | Chair | 6/30/10 | 5 | $1,250 | $125 | |||||
| Totals | $15,650 | $1,625 | $0 | $0 | $0 | $0 | ||||
| Cross-footing test -----> | ||||||||||
| Asset Name | Net Book Value | |||||||||
| Desk | $0 | |||||||||
| Laptop | $0 | |||||||||
| Workstation | $0 | |||||||||
| Chair | $0 | |||||||||
| Software | $0 | |||||||||
| Monitor | $0 | |||||||||
| Total |
