YIELDMAT function calculates the annual yield of a security paying interest at maturity, based on price.
Parts of a YIELDMAT formula
YIELDMAT formula is formatted as
=YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention]).
||The settlement date of the security, the date after issuance when the security is delivered to the buyer.|
||The maturity or end date of the security, when it can be redeemed at face or par value.|
||The date the security was initially issued.|
||The annualized rate of interest.|
||The price at which the security is bought.|
||An indicator of what day count method to use.||
issueshould be entered using
TO_DATE, or other date parsing functions rather than by entering text.
||1/2/2010||=YIELDMAT(B2, B3, B4, B5, B6, B7)||0.13|
PRICEMAT: Calculates the price of a security paying interest at maturity, based on expected yield.
YIELDDISC: Calculates the annual yield of a discount (non-interest-bearing) security, based on price.