Formulas and Functions

Chapter 6 Financial Functions 11 7
cost salvage life depr-period depr-factor
First year, straight-
line (returns $250)
=DDB(B2, C2, D2,
E7, F7)
1 1
First year, triple-
declining balance
(returns $750)
=DDB(B2, C2, D2,
E8, F8)
3 1
Related Topics
For related functions and additional information, see:
“DB” on page 114
“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
DISC
The DISC function returns the annual discount rate of a security that pays no interest
and is sold at a discount to its redemption value.
DISC(settle, maturity, price, redemption, days-basis)
 settle: The trade settlement date. settle is a date/time value. The trade settlement
date is usually one or more days after the trade date.
 maturity: The date when the security matures. maturity is a date/time value. It must
be after settle.
 price: The cost of the security per $100 of par value. price is a number value.
 redemption: The redemption value per $100 of par value. redemption is a number
value that must be greater than 0. redemption is the amount that will be received
per $100 of face value. Often, it is 100, meaning that the security’s redemption value
is equal to its face value.