# Problem 10-2A – Due In 24 Hours

Complete the attached, Problem 10-2A Template.  Please refer to Ch. 10 in your textbook for detailed instructions.

## Pr. 10-2A

 Problem 10-2A Name: 0 Section: # N-box Incorrects due to blanks COUNTIF(B15:AT24,” “) 40 Score: 0% # N-box +B-box corrects COUNTIF(B15:AT24,” “) 0 Key Code: [Key code here] Total SUM(AD13:AD15) Instructions 40 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. 0% 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 lables 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 Year 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. Year 2 Year 3 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 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 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 Since depreciation cannot cause book value to fall below residual value: Depreciable Balance Residual Value − = Yearly Depreciation Year 3 Mark Sears: Enter as a formula. 2. The method that yields the most depreciation expense in Year 1 is the 3. The method that yields the most total depreciation over the three years is the

## Sol

 Problem 10-2A Name: Solution Section: Score: ON Key Code: 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 Year 1 \$ 22,500 Mark Sears: Complete the calculations below, then plug amounts in here. \$ 28,500 Mark Sears: Complete the calculations below, then plug amounts in here. \$ 48,000 Mark Sears: Complete the calculations below, then plug amounts in here. Year 2 22,500 22,500 16,000 Year 3 22,500 16,500 3,500 Totals \$ 67,500 Mark Sears: Enter as a formula. \$ 67,500 Mark Sears: Enter as a formula. \$ 67,500 Mark Sears: Enter as a formula. Calculations: Straight-line method: (Cost − Residual Value) / Years = Yearly Depreciation \$ 72,000 \$ 4,500 3 \$ 22,500 Mark Sears: Enter as a formula. Units-of-activity method: (Cost − Residual Value) / Total Hours = Rate \$ 72,000 \$ 4,500 18,000 \$3.75 Mark Sears: Enter as a formula. Rate x Hours = Yearly Depreciation Year 1 \$3.75 7,600 \$ 28,500 Mark Sears: Enter as a formula. Year 2 \$3.75 6,000 \$ 22,500 Year 3 \$3.75 4,400 \$ 16,500 Double-declining-balance method: Depreciable Balance x Rate = Yearly Depreciation Year 1 \$ 72,000 0.666667 Mark Sears: Enter fraction with an equal sign, such as “=2/3” \$ 48,000 Mark Sears: Enter as a formula. Year 2 \$ 24,000 0.666667 \$ 16,000 Since depreciation cannot cause book value to fall below residual value: Depreciable Balance Residual Value − = Yearly Depreciation Year 3 \$ 8,000 \$ 4,500 \$ 3,500 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 three years is the all yield the same overall
0 replies