Microsoft Office Tutorials and References
In Depth Information
Syntax
Figure 13.22.
Figure 13.22. YIELDMAT
YIELDMAT and
calculate bonds for which the in-
terest is not paid until maturity.
and PRICEMAT
PRICEMAT calculate bonds for which the in-
terest is not paid until maturity.
Syntax
PRICEMAT(settlement_date,maturity_date,is-
sue_date,rate_at_date_of_issue,annual_yield,day_basis)
The PRICEMAT function returns the price per $100 face value of a security
that pays interest at maturity.
Syntax
YIELDMAT(settlement_date,maturity_date,is-
sue_date,rate_at_date_of_issue,price_per_$100_of_face_value,day_basis)
The YIELDMAT function returns the annual yield of a security that pays
interest at maturity.
Search JabSto ::




Custom Search