YIELDMAT
Financial

Returns the annual yield of a security that pays interest at maturity

Syntax:

=YIELDMAT(settlement, maturity, issue, rate, pr, [basis])

Example:

=YIELDMAT("2/15/2023", "5/15/2023", "11/15/2022", 0.061, 100)