The YIELDMAT
function calculates the annual yield of a security paying interest at maturity, based on price.
Parts of a YIELDMAT formula
The YIELDMAT
formula is formatted as =YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention]).
Part | Description | Notes |
settlement |
The settlement date of the security, the date after issuance when the security is delivered to the buyer. | |
maturity |
The maturity or end date of the security, when it can be redeemed at face or par value. | |
issue |
The date the security was initially issued. | |
rate |
The annualized rate of interest. | |
price |
The price at which the security is bought. | |
day_count_convention |
An indicator of what day count method to use. |
|
Sample formulas
YIELDMAT(DATE(2010,01,02),DATE(2039,12,31),DATE(2010,01,01),3,100.47)
YIELDMAT(A2,B2,C2,D2,E2,1)
Notes
settlement
,maturity
, andissue
should be entered usingDATE
,TO_DATE
, or other date parsing functions rather than by entering text.
Examples
A | B | C | D | |
---|---|---|---|---|
1 | Formula | Result | ||
2 | settlement |
1/2/2010 | =YIELDMAT(B2, B3, B4, B5, B6, B7) | 0.13 |
3 | maturity | 12/31/2010 | ||
4 | issue |
1/1/2008 | ||
5 |
|
2% | ||
6 | price |
90 | ||
7 | day_count_convention |
2 |
Related functions
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.