Straight Line Depreciation - Full 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 the entire year. Other problems in this resource relax this assumption, allowing for assets owned for only a portion of the 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)