Excel in Practice for Accounting

profilemicell32
m4_a3.xls
Home>Business & Finance homework help>Accounting homework help>Excel in Practice for Accounting

A Problems

P9-28A(30-40min)
Req.1
Staright-Line Depreciation Schedule
Date Asset Cost Depreciation Rate Depreciable Cost Depreciation Expense Accumulated Depreciation Asset Book Value
January 9,2010
December 31, 2010
December 31, 2011
December 31, 2012
December 31, 2013
December 31, 2014
December 31, 2015
Depreciable Cost ÷ Total unit Output = Depreciation per Unit
÷ =
Units -of- Production Depreciation Schedule
Date Asset Cost Depreciation Per Unit Number of Units Depreciation Expense Accumulated Depreciation Asset Book Value
January 9, 2010
December 31, 2010
December 31, 2011
December 31, 2012
December 31, 2013
December 31, 2014
December 31, 2015
SL Depreciation Rate × DDB rate Multiplier = DDB rate
× =
Double-Declining-Balance(DDb) Depreciation Schedule
Date Asset Cost DDB Rate Asset Book Value Depreciation Expense Accumulated Depreciation Asset Book Value
January 9, 2010
December 31, 2010
December 31, 2011
December 31, 2012
December 31, 2013
December 31, 2014
December 31, 2015
Req.2
P10A-9B (15-25 min)
Req.1
Req.2
Req.3
P11-29A (15-20 min)
Req. 1
Req. 2
Req. 3
Req. 4