Please answer by tomorrow. Attached is the question.

14.7 EXCEL PROBLEM a. Create the following spreadsheet b. Create formulas to calculate Accumulated depreciation (all assets use the straight line method; all assets acquired any time during the year get a full year's initial depreciation) Current year's depreciation (straight-line method, full amount for initial year in which asset acquired) Ending accumulated depreciation Net book value at end of period Current year in the cell to the right of the phrase \"Depreciation schedule for year\" Column totals for acquisition cost, beginning depreciation, current depreciation, ending accumulated depreciation, net book value In the cell to the right of the arrow following the text \"Cross-footing test\" create a formula that checks whether the sum of the net book value column equals the sum of acquisition costs minus the sum of ending accumulated depreciation. If the two values match, the formula should display the text \"Okay\" otherwise it should display the text \"Error\" c. Create a table at the bottom of your worksheet that consists of two columns: 1. Asset name (values should be chair, desk, laptop, monitor, software, and workstation) 2. Net book value (create a formula to calculate this number) assuming that the current date is 06/30/2011 Create a formula that sums the total net book values for all classes of assets In the cell to the right of the total net book values for all asset classes, create a formula that compares the total net book values for all classes of assets to the sum of all net book values in the top portion of the spreadsheet. The formula should return \"Okay\" if the two totals match or \"Error: Sum of net book values by asset class does not equal sum of all net book values\" if the two totals do not equal one another. d. Enter your name in row 1 in the cell to the right of the text \"Name\" P14-7 Name Rachel Syverson Depreciation Schedule for year Ending Account Description Number Date Place in Service 11001 Desk 11100 Laptop 11200 Workstation 11050 Chair 11500 Software 11500 Sofware 11500 Software 11300 Monitor 11300 Monitor 11300 Monitor 11001 Desk 11001 Desk 11050 Desk Net Book Value $0 $0 $0 $0 $0 $0 $0 5 5 5 5 3 3 3 4 4 4 5 5 5 Salvage Value $500 $2,400 $1,900 $750 $750 $2,100 $900 $800 $1,200 $600 $1,000 $1,500 $1,250 $1,625 Current Period Depreciation Accumulated Net Book Value Depreciation $100 $400 $250 $50 $0 $0 $0 $100 $100 $100 $150 $250 $125 Totals $15,650 Cross-Footing Test ---> Asset Name Desk Laptop Workstation Chair Software Monitor Total 4/5/2008 5/2/2009 3/25/2008 2/1/2005 7/1/2010 6/30/2009 1/31/2007 2/20/2009 9/30/2005 10/15/2008 4/4/2009 8/8/2005 6/30/2010 Estimated Acquistion Useful Life Cost Beginning Accumulated Depreciation $0 $0 $0 $0 P14-7 Name Rachel Syverson Depreciation Schedule for year Beginning Date Account Description Number Date Place in Service 11001 Desk 11100 Laptop 11200 Workstation 11050 Chair 11500 Software 11500 Sofware 11500 Software 11300 Monitor 11300 Monitor 11300 Monitor 11001 Desk 11001 Desk 11050 Desk 12/31/2008 12/31/2009 12/31/2008 12/31/2005 12/31/2010 12/31/2009 12/31/2007 12/31/2009 12/31/2005 12/31/2008 12/31/2009 12/31/2005 12/31/2010 12/31/2010 12/31/2011 Estimated Acquistion Useful Life Cost 5 5 5 8 5 4 5 4 8 4 5 7 5 $500 $2,400 $1,900 $750 $750 $2,100 $900 $800 $1,200 $600 $1,000 $1,500 $1,250 Totals $15,650 Cross-Footing Test ---> Asset Name Desk Laptop Workstation Chair Software Monitor Total Check Net Book Value $2,289 $1,200 $910 $488 $1,185 $1,288 $7,359 Okay Ending Salvage Value Beginning Accumulated Depreciation $100 160 $400 800 $250 660 $50 175 $0 300 $0 1050 $0 360 $100 350 $100 275 $100 250 $150 340 $250 357.1428571429 $125 450 $1,625 $5,527 Current Period Depreciation $80 $400 $330 $88 $150 $525 $180 $175 $138 $125 $170 $179 $225 $2,764 Accumulated Depreciation $240 $1,200 $990 $263 $450 $1,575 $540 $525 $413 $375 $510 $536 $675 $8,291 Net Book Value $260 $1,200 $910 $488 $300 $525 $360 $275 $788 $225 $490 $964 $575 $7,359 P14-7 Name Rachel Syverson Depreciation Schedule for year Ending Account Description Number Date Place in Service 11001 Desk 11100 Laptop 11200 Workstation 11050 Chair 11500 Software 11500 Sofware 11500 Software 11300 Monitor 11300 Monitor 11300 Monitor 11001 Desk 11001 Desk 11050 Desk Net Book Value $0 $0 $0 $0 $0 $0 $0 5 5 5 5 3 3 3 4 4 4 5 5 5 Salvage Value $500 $2,400 $1,900 $750 $750 $2,100 $900 $800 $1,200 $600 $1,000 $1,500 $1,250 $1,625 Current Period Depreciation Accumulated Net Book Value Depreciation $100 $400 $250 $50 $0 $0 $0 $100 $100 $100 $150 $250 $125 Totals $15,650 Cross-Footing Test ---> Asset Name Desk Laptop Workstation Chair Software Monitor Total 4/5/2008 5/2/2009 3/25/2008 2/1/2005 7/1/2010 6/30/2009 1/31/2007 2/20/2009 9/30/2005 10/15/2008 4/4/2009 8/8/2005 6/30/2010 Estimated Acquistion Useful Life Cost Beginning Accumulated Depreciation $0 $0 $0 $0 P14-7 Name Rachel Syverson Depreciation Schedule for year Beginning Date Account Description Number Date Place in Service 11001 Desk 11100 Laptop 11200 Workstation 11050 Chair 11500 Software 11500 Sofware 11500 Software 11300 Monitor 11300 Monitor 11300 Monitor 11001 Desk 11001 Desk 11050 Desk 12/31/2008 12/31/2009 12/31/2008 12/31/2005 12/31/2010 12/31/2009 12/31/2007 12/31/2009 12/31/2005 12/31/2008 12/31/2009 12/31/2005 12/31/2010 12/31/2010 12/31/2011 Estimated Acquistion Useful Life Cost 5 5 5 8 5 4 5 4 8 4 5 7 5 $500 $2,400 $1,900 $750 $750 $2,100 $900 $800 $1,200 $600 $1,000 $1,500 $1,250 Totals $15,650 Cross-Footing Test ---> Asset Name Desk Laptop Workstation Chair Software Monitor Total Check Net Book Value $2,289 $1,200 $910 $488 $1,185 $1,288 $7,359 Okay Ending Salvage Value Beginning Accumulated Depreciation $100 160 $400 800 $250 660 $50 175 $0 300 $0 1050 $0 360 $100 350 $100 275 $100 250 $150 340 $250 357.1428571429 $125 450 $1,625 $5,527 Current Period Depreciation $80 $400 $330 $88 $150 $525 $180 $175 $138 $125 $170 $179 $225 $2,764 Accumulated Depreciation $240 $1,200 $990 $263 $450 $1,575 $540 $525 $413 $375 $510 $536 $675 $8,291 Net Book Value $260 $1,200 $910 $488 $300 $525 $360 $275 $788 $225 $490 $964 $575 $7,359