Details of this Paper

Depreciation Schedule for Year...

Description

Solution


Question

Depreciation Schedule for Year 2009 The year MUST be 2009 even if we are in a future year. Use SL depreciation without partial amounts. "Account Number" Description "Date Placed In Service" "Estimated Useful Life" "Acquisition Cost" "Beginning Accumulated Depreciation" "Current Period Depreciation" "Ending Accumulated Depreciation" "Net Book Value" If I change the year (2009 above) then all of your numbers much change to correct amounts 11001 Desk 04/05/2006 5 $500 Insert functions to finish out the table using Excel to solve for all depreciation items. 11100 Laptop 05/02/2007 5 $2,400 $480 You cannot have a negative net book value 11200 Workstation 03/25/2006 5 $1,900 Description 11050 Chair 02/01/2003 5 $750 Legend of formulas used in this spreadsheet: Software 11500 Software 07/01/2008 4 $750 1 IF Used in column F Laptop 11500 Software 06/30/2007 4 $2,100 2 YEAR Used in column F Monitor 11500 Software 01/31/2005 4 $900 3 SUMIF Used below Workstation 11300 Monitor 02/20/2007 3 $800 Desk 11300 Monitor 09/30/2003 3 $1,200 HINT: You can never have more depreciation in column H than the Acq. Cost in Column E. Chair 11300 Monitor 10/15/2006 3 $600 11001 Desk 04/04/2007 5 $1,000 11001 Desk 08/08/2003 5 $1,500 11050 Chair 06/30/2008 5 $1,250 $250 sum $480 $0 "Asset Names" "New Book Value" Software Insert functions in cells B19-b24 to complete this chart. You must use functions which would change if the year changes Laptop Monitor Workstation Desk Chair List the conditional formatting steps taken. DO NOT USE PASSWORD CONTROLS FOR ANY SHEETS.

 

Paper#8428 | Written in 18-Jul-2015

Price : $25
SiteLock