### 4.4 Depreciation

<
>
• Math Help

Note that the useful life of an item is an estimate of the number of years before the item must be replaced. It is an estimate because the useful life depends upon such things as frequency of use, care when in use, repair procedures, technology, and durability. The salvage value of an item is the estimated resale, trade-in, or scrap value of the item after its useful life.

To make a spreadsheet similar to the one in Example 1, use the steps below.

1. Enter the titles "Year", "Value before Depreciation", "Depreciation", and "Value after Depreciation " into Row 1.
2. Enter 1 into cell A2.
3. Enter the formula =A2 + 1 into cell A3.
4. Select cell A3. From the Edit menu, choose Copy.
5. Select cells A4 through A6. From the Edit menu, choose Paste.
6. Enter 25000 into cell B2 and 4000 into cells C2-C6.
7. Enter the formula = B2 – C2 into cell D2.
8. Select cell D2. From the Edit menu, choose Copy.
9. Select cells D3 through D6. From the Edit menu, choose Paste.
10. Enter the formula = D2 into cell B3.
11. Select cell B3. From the Edit menu, choose Copy.
12. Select cells B4 through B6. From the Edit menu, choose Paste.
13. Select cells B2 through B6, C2 through C6, and D2 through D6.
14. From the Format menu, choose Cells….
15. In the Format Cells dialog, select the Number tab.
16. From the Category: list, select Currency.
17. For Decimal places:, enter 0. For Symbol, choose \$ from the drop down list. Then click OK.
• Consumer Suggestion

If you've ever seen the movie Office Space you probably remember the scene where the main characters destroy a fax machine with a baseball bat. Although that looks like fun, there are more practical ways to get rid of office equipment that has depreciated in value or you no longer use. Consider donating old office equipment to Freecycle Network. This is a good way for your company to be green while giving back to the community.

• Checkpoint Solution

The amount of depreciation each year is

A spreadsheet showing the depreciation schedule is shown below.

These comments are not screened before publication. Constructive debate about the information on this page is welcome, but personal attacks are not. Please do not post comments that are commercial in nature or that violate copyright. Comments that we regard as obscene, defamatory, or intended to incite violence will be removed. If you find a comment offensive, you may flag it.
When posting a comment, you agree to our Terms of Use.

```            ______   ______    __   __   _    _
___    /_   _// |      \\  \ \\/ // | |  | ||
/   ||   -| ||-  |  --  //   \ ` //  | |/\| ||
| [] ||   _| ||_  |  --  \\    | ||   |  /\  ||
\__ ||  /_____// |______//    |_||   |_// \_||
-|_||  `-----`  `------`     `-`'   `-`   `-`
`-`
```
Guest   9 years ago |
When I started my first business, I was surprised that the IRS would not allow me to take all of my business expenses when I paid for the items. It was a hardship to be allowed to only deduct expenses from a depreciation schedule.
0
Guest   9 years ago |
There are lots of depreciation calculators at www.calculatorsoup.com. Click the following.
>Calculators
> Financial
> Depreciation
> Straight Line Depreciation Calculator
0
Ron Larson (author)9 years ago |
When I was working on this section, I called the person who does the accounting for our company. I was surprised to learn that accountants use several types of depreciation. The three types described in this section are still, however, the classic types.
0