Microsoft Office Tutorials and References
In Depth Information
Using PRICEDISC and YIELDDISC to Calculate Discount Bonds
Using
Using PRICEDISC
PRICEDISC and
and YIELDDISC
YIELDDISC to Calculate Discount Bonds
to Calculate Discount Bonds
Excel provides PRICEDISC and YIELDDISC for calculating discounted bonds.
Figure 13.23 illustrates these functions.
Figure 13.23.
Figure 13.23. YIELDDISC
YIELDDISC and
and PRICEDISC
PRICEDISC calculate discounted bonds.
calculate discounted bonds.
Syntax
PRICEDISC(settlement_date,maturity_date,discount_rate,redemp-
tion_value_per_$100,day_basis)
The PRICEDISC function returns the price per $100 face value of a discoun-
ted security.
Search JabSto ::




Custom Search