Create the spreadsheet on page 493 with formulas to calculate the total depre¬ ciation expense and to display the correct values in the columns: Age, Depreciation Rate, and Depreciation Expense. Hint: You will need to use the VLOOKUP, MATCH, and ISNA functions to do this. You may also want to read the article “Double-Teaming In Excel,” by Judith K. Welch, Lois S. Mahoney, and Daniel R. Brickner, in the November 2005 issue of the Journal ofAccountancy, from which this problem was adapted.

Transcribed Image Text:

Eile Edit View Insert Format Iools Data Window Help Adobe PDF 22 21 100% Microsoft Excel-Book1 Reply with Changes... End Review... a L17 fx A B D E F G EP BIU Type a question for help Depreciation Depreciation Expense 1 MACRS DEPRECIATION RATE 2 PROPERTY CLASS ASSET DEPRECIATION SCHEDULE Year for computation: 2008 Year 3 Age -234567890 3456789 B C Name Purchased Age Property Class Cost Rate 1 22% 16% 13% Desk 2007 30% 25% 20% Chair 2005 20% 20% 17% File Cabinet 2001 14% 18% 15% CAD software 2006 14% 16% 14% Copier 2005 5% 10% Server 2002 10 11 12 13 10 14 15 16 17 18 19 Sheet1 Sheet2 Sheet3 7% Office software 2000 3% Printer 2006 Workstation 2005 Laptop 2007 Firewall 2003 IPS 2004 ABBAACBCAMCC 3500 1200 750 85000 1500 6500 50600 7500 2000 3000 10000 15000 Total Draw Autoshapes Ready M X