beautypg.com

Apple iWork '09 User Manual

Page 115

background image

Chapter 6

Financial Functions

115

Example 2

Depreciation for Partial First Year

Assume the same facts as Example 1, except that the asset will be depreciated for less than
12 months in the first year.

cost

salvage

life

depr-period

first-year-months

1000

100

4

1

Depreciate 9
months (returns
$328.50)

=DB(B2, C2, D2,
E2, F3)

9

Depreciate 6
months (returns
$219)

=DB(B2, C2, D2,
E2, F4)

3

Depreciate 3
months (returns
$109.50)

=DB(B2, C2, D2,
E2, F5)

6

Depreciate 1
month (returns
$36.50)

=DB(B2, C2, D2,
E2, F6)

1

Related Topics
For related functions and additional information, see:

“DDB” on page 116

“SLN” on page 147

“SYD” on page 148

VDB” on page 149

“Common Arguments Used in Financial Functions” on page 341

“Listing of Financial Functions” on page 96

Value Types” on page 36

The Elements of Formulas” on page 15

“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26

“Pasting from Examples in Help” on page 41