1 | P a g e
CHAPTER 4
DEPRECIATION
CHAPTER 4 QUESTIONS
1. The SLN function will calculate depreciation on a straight-line basis.
2. The SLN function takes 3 arguments: cost, salvage value, and useful life.
3. The arguments to the SLN function can actually be either values or references.
8. A fourth argument is needed for the DDB and SYD depreciation functions. It is the year for which the
asset is being depreciated. For example, year 1, year 2 etc.
9. To add a new series of data to an existing chart:
a. Open your existing chart
b. From the Design tab, click Select Data from the Data Group.
10. Straight-line depreciation will always produce a horizontal line reflecting a constant depreciation
2 | P a g e
Chapter 4 Assignments
1.
3 | P a g e
2.
4 | P a g e
3.
5 | P a g e
4.
6 | P a g e
6.
7 | P a g e
7.
8.
9 | P a g e
CHAPTER 4 CASES
1. Kelly’s Boutique
10 | P a g e
2.
11 | P a g e
3. Wine Depot
