Google Sheets
YIELDMAT function in Google Sheets
Calculates the annual yield of a security paying interest at maturity, based on price.
=YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention])YIELDMAT syntax and parameters
Six arguments, five required.
- settlementanyRequired
- maturityanyRequired
- issueanyRequired
- rateanyRequired
- priceanyRequired
- day_count_conventionanyOptional
YIELDMAT examples
Formulas you'll actually reuse.
The yield implied by paying 100.386 for that note:
=YIELDMAT(DATE(2026, 3, 15), DATE(2027, 1, 15), DATE(2026, 1, 15), 4%, 100.386, 0)Result
0.035Flag notes yielding more than the benchmark in G2:
=IF(YIELDMAT(B2, C2, D2, E2, F2) > G2, "Cheap", "Rich")
YIELDMAT in Excel
Same name — your formula ports as-is.
Try YIELDMAT in the playground
Edit the example — nothing to install.
Preloaded with the YIELDMAT formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Google Sheets gets this done.
- ACCRINTCalculates the accrued interest of a security that has periodic payments.FinancialExcel
- ACCRINTMCalculates the accrued interest of a security that pays interest at maturity.FinancialExcel
- AMORLINCReturns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period.FinancialExcel
- COUPDAYBSCalculates the number of days from the first coupon, or interest payment, until settlement.FinancialExcel
- COUPDAYSCalculates the number of days in the coupon, or interest payment, period that contains the specified settlement date.FinancialExcel
- COUPDAYSNCCalculates the number of days from the settlement date until the next coupon, or interest payment.FinancialExcel