Problem 9.2b: Name Section N Box Incorrects Due To Blank

Pr 9 2bproblem 9 2bname0section N Box Incorrects Due To Blanks C

Pr 9 2bproblem 9 2bname0section N Box Incorrects due to blanks COUNTIF(B15:AT24," ") 46 Score: 6% # N-box +B-box corrects COUNTIF(B15:AT24," ") 3 Key Code: [Key code here] Total SUM(AD13:AD15) Instructions 49 Answers are entered in the cells with gray backgrounds. Percentage =(AD16-AD13-AD14)/AD16 Cells with non-gray backgrounds are protected and cannot be edited. 6% An asterisk () will appear to the right of an incorrect entry. Notes: If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " " If number-entry or blank-entry box is incorrect, returns "" 1.

If number-entry or blank-entry box is correct, returns single space, " " Depreciation Expense Use data verification to set data entry to whole number >= 0, and use drop-downs for labels and names, so that students can't enter a space in a box and have it counted as correct. A. B. C. Conditional formatting might be used but wasn't here, to hide some of the error check return symbols.

If A1 = "~*", then font = red, if something else, then font = background color. Straight- Units-of- Double-Declining- Year Line Activity Balance 1 Mark Sears: Complete the calculations below, then plug the amounts in here. Mark Sears: Complete the calculations below, then plug the amounts in here. Mark Sears: Complete the calculations below, then plug the amounts in here. Totals Mark Sears: Enter as a formula.

Mark Sears: Enter as a formula. Mark Sears: Enter as a formula. Calculations: Straight-line method: (Cost − Residual Value) / Years = Yearly Depreciation $ 71,250 Mark Sears: Enter as a formula. Units-of-activity method: (Cost − Residual Value) / Total Hours = Rate Mark Sears: Enter as a formula. Rate x Hours = Yearly Depreciation Year 1 Mark Sears: Enter as a formula.

Year 2 Year 3 Year 4 Double-declining-balance method: Depreciable Balance x Rate = Yearly Depreciation Year 1 Mark Sears: Enter fraction with an equal sign, such as "=2/3" Mark Sears: Enter as a formula. Year 2 Year 3 Since depreciation cannot cause book value to fall below residual value: Depreciable Balance Residual Value − = Yearly Depreciation Year 4 Mark Sears: Enter as a formula. 2. The method that yields the most depreciation expense in Year 1 is the double-declining-balance method 3. The method that yields the most total depreciation over the four years is the all yield the same overall Sol Problem 9-2B Name: Solution Section: Score: ON Instructions Answers are entered in the cells with gray backgrounds.

Cells with non-gray backgrounds are protected and cannot be edited. An asterisk (*) will appear to the right of an incorrect entry. 1. Depreciation Expense A. B.

C. Straight- Units-of- Double-Declining- Year Line Activity Balance 1 $ 71,250 Mark Sears: Complete the calculations below, then plug amounts in here. $ 102,600 Mark Sears: Complete the calculations below, then plug amounts in here. $ 160,000 Mark Sears: Complete the calculations below, then plug amounts in here. 2 71,,,,,,,,,000 Totals $ 285,000 Mark Sears: Enter as a formula. $ 285,000 Mark Sears: Enter as a formula. $ 285,000 Mark Sears: Enter as a formula. Calculations: Straight-line method: (Cost − Residual Value) / Years = Yearly Depreciation $ 320,000 $ 35, $ 71,250 Mark Sears: Enter as a formula. Units-of-activity method: (Cost − Residual Value) / Total Hours = Rate $ 320,000 $ 35,,000 $14.25 Mark Sears: Enter as a formula.

Rate x Hours = Yearly Depreciation Year 1 $14.25 7,200 $ 102,600 Mark Sears: Enter as a formula. Year 2 $14.25 6,,200 Year 3 $14.25 4,,700 Year 4 $14.25 2,,500 Double-declining-balance method: Depreciable Balance x Rate = Yearly Depreciation Year 1 $ 320,.500000 Mark Sears: Enter fraction with an equal sign, such as "=2/3" $ 160,000 Mark Sears: Enter as a formula. Year 2 $ 160,.,000 Year 3 $ 80,.,000 Since depreciation cannot cause book value to fall below residual value: Depreciable Balance Residual Value − = Yearly Depreciation Year 4 $ 40,000 $ 35,000 $ 5,000 Mark Sears: Enter as a formula. 2. The method that yields the most depreciation expense in Year 1 is the double-declining-balance method 3. The method that yields the most total depreciation over the four years is the all yield the same overall