YIELDMAT
The YIELDMAT function in Google Sheets is a powerful tool to calculate the annual yield of a security that pays interest at maturity, based on price. Whether you're analyzing investments or evaluating bond yields, the YIELDMAT function simplifies the calculation. Dive into our comprehensive guide to master its application.
Function Syntax and Parameters
Syntax: YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention])
Parameters:
settlement: The security's settlement date, representing the date when the security is delivered and payment is exchanged.maturity: The security's maturity date, representing the date when the security expires.issue: The security's issue date, representing the date when the security was initially issued.rate: The security's annual coupon interest rate.price: The security's price per $100 face value.day_count_convention: [Optional] The day count convention to use when calculating the yield. The default value is 0.
Step-by-Step Tutorial
- Using
YIELDMATwith basic parameters:- Example:
=YIELDMAT(Date(2022, 1, 1), Date(2027, 1, 1), Date(2021, 1, 1), 5%, 98.5) - Result: The annual yield of the security will be calculated based on the given settlement date, maturity date, issue date, coupon interest rate, and price.
- Example:
Use Cases and Scenarios
- Investment Analysis: Calculate the annual yield of bonds or other securities paying interest at maturity.
- Bond Evaluation: Determine the yield of a bond based on its price and other parameters.
Related Functions
YIELD: Calculates the yield of a security that pays interest at a fixed schedule.YIELDPRICE: Calculates the price per $100 face value of a security paying interest at maturity, based on yield.