Formulas and Functions

Chapter 6 Financial Functions 11 5
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 rst year.
cost salvage life depr-period rst-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