Straight Line Depreciation - Partial Year

This assignment will provide you with practice in computing depreciation on long-term assets using the straight-line method. This problem assumes all assets have been owned for only a portion of the year. Other problems in this resource assumes that assets were owned for the entire year.

Relevant Excel Functions

This assignment will require you to be able to use some or all of the following Excel functions. Click on the hyperlinked section number next to the relevant Excel skill to be directed to a page showing how to perform the assigned task in Excel:

• Cell References (1.5)

• SUM Function (1.14)

• Drop-Down Lists (1.10)

• Absolute Cell References (1.1)

• Nested IF Statements (1.12)