YIELD Function in Excel: Syntax, Examples and Free Practice
YIELD is an Excel Financial function. Returns the yield on a bond paying periodic interest.
YIELD syntax
Arguments
settlement: The security's settlement (purchase) datematurity: The security's maturity daterate: The interest rate per periodpr: The security's price per $100 face valueredemption: The security's redemption value per $100 face value
When to use YIELD
YIELD is used in loan, investment, or valuation models where precise financial math is required.
Practice YIELD online, free
Open the live Excel-style spreadsheet and try YIELD yourself. No Excel install or sign-up needed to start.
Practice YIELD now →More Financial functions
Frequently asked questions
What does the YIELD function do in Excel?
Returns the yield on a bond paying periodic interest.
What is the syntax of YIELD in Excel?
The syntax is =YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis]). settlement: The security's settlement (purchase) date; maturity: The security's maturity date; rate: The interest rate per period; pr: The security's price per $100 face value; redemption: The security's redemption value per $100 face value.
Where can I practice YIELD online for free?
Open the free live spreadsheet on Cellgrids and try YIELD 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