Problem 10-2A - due in 24 hours
combs
WRD27e_PR10-2A.xlsxPr. 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 | |||||
