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

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *