## 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 |

## Leave a Reply

Want to join the discussion?Feel free to contribute!