YIELDMAT Function in Excel: Syntax, Examples and Free Practice
YIELDMAT is an Excel Financial function. Returns the annual yield for a security paying interest at maturity.
YIELDMAT syntax
Arguments
settlement: The security's settlement (purchase) datematurity: The security's maturity dateissue: The security's issue daterate: The interest rate per periodpr: The security's price per $100 face value
When to use YIELDMAT
YIELDMAT is used in loan, investment, or valuation models where precise financial math is required.
Practice YIELDMAT online, free
Open the live Excel-style spreadsheet and try YIELDMAT yourself. No Excel install or sign-up needed to start.
Practice YIELDMAT now →More Financial functions
Frequently asked questions
What does the YIELDMAT function do in Excel?
Returns the annual yield for a security paying interest at maturity.
What is the syntax of YIELDMAT in Excel?
The syntax is =YIELDMAT(settlement, maturity, issue, rate, pr, [basis]). settlement: The security's settlement (purchase) date; maturity: The security's maturity date; issue: The security's issue date; rate: The interest rate per period; pr: The security's price per $100 face value.
Where can I practice YIELDMAT online for free?
Open the free live spreadsheet on Cellgrids and try YIELDMAT yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Financial functions · Excel case studies · Excel tutorials · Excel shortcuts