# Question

a. Download the spreadsheet for problem 14.7 from the website for this textbook.

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:

• Asset name (values should be chair, desk, laptop, monitor, software, and workstation)

• Net book value (create a formula to calculate this number) assuming that the current date is 06/30/2014

• 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”

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:

• Asset name (values should be chair, desk, laptop, monitor, software, and workstation)

• Net book value (create a formula to calculate this number) assuming that the current date is 06/30/2014

• 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”

## Answer to relevant Questions

Task: Use Excel and the Solver add-in to explore the effect of various resource constraints on the optimal product mix.b. Download the sample spreadsheet discussed in the article and print out the screenshots showing that ...One of the threats associated with having employees telecommute is that they may use company-provided resources (e.g., laptop, printer, etc.) for a side business. What are some other threats? What controls can mitigate the ...Excel Problem*Objective: Learn how to find and correct errors in complex spreadsheets used for payroll.Requireda. Disable data validation on the hours worked column in order to input the following erroneous data:• Change ...The balanced scorecard measures organizational performance along four dimensions. Is it possible that measures on the customer, internal operations, and innovation and learning dimensions could be improving without any ...Excel Problem*Objective: Create pivot tables for what-if analysis.RequiredRead the article “Make Excel an Instant Know-It-All” by Roberta Ann Jones in the March 2004 issue of the Journal of Accountancy (available at ...Post your question

0