YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention])One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.
settlement:
The date on which the security is purchased, or the date when the buyer takes ownership of the security.
maturity:
The date on which the security will mature, or the date when the principal amount is due to be paid back to the investor.
issue:
The date on which the security was issued, or the date when the issuer first sold the security to investors.
rate:
The annual coupon rate of the security, expressed as a percentage.
price:
The price of the security expressed as a percentage of its face value.
[day_count_convention]:
An optional parameter that specifies the day count convention to use for the calculation. If omitted, the default convention is used.
The YIELDMAT function in Google Sheets is a financial function used to calculate the annual yield of a security that pays interest at maturity. This function is particularly useful for investors who want to assess the return on investment for bonds or other fixed-income securities. It takes into account the settlement date, maturity date, and the security's price, among other parameters.
In simpler terms, YIELDMAT helps you determine how much return you can expect from a security that matures at a future date.
Imagine you are evaluating a bond investment with the following details:
| Settlement Date | Maturity Date | Price | Redemption Value | Coupon Rate | Frequency |
|---|---|---|---|---|---|
| 2023-01-01 | 2025-01-01 | 950 | 1000 | 5% | 1 |
You want to calculate the annual yield of this bond based on its current price and other parameters.
To achieve this, you would use the YIELDMAT function as follows:
=YIELDMAT(A2, B2, C2, D2, E2, F2)In this formula:
A2 is the cell containing the Settlement Date.B2 is the cell containing the Maturity Date.C2 is the cell containing the Price of the bond.D2 is the cell containing the Redemption Value.E2 is the cell containing the Coupon Rate.F2 is the cell containing the Frequency of coupon payments.When you apply the YIELDMAT formula to the bond details, the output would give you the annual yield of the bond, which could look something like this:
| Settlement Date | Maturity Date | Price | Redemption Value | Coupon Rate | Frequency | Annual Yield |
|---|---|---|---|---|---|---|
| 2023-01-01 | 2025-01-01 | 950 | 1000 | 5% | 1 | 6.32% |
This result indicates that the bond has an annual yield of 6.32%, which helps you assess its attractiveness as an investment.
YIELDMAT is beneficial because it provides a straightforward way to calculate the yield of a security that matures in the future. It helps investors make informed decisions by evaluating the potential return on their investments. Additionally, it can be used in various financial analyses, making it a versatile tool for anyone dealing with fixed-income securities.
YIELDMAT is an essential function for anyone working with fixed-income securities, providing a powerful way to enhance investment analysis and decision-making capabilities.
Happy investing!
You have a table with bond details, including settlement dates in Column A and maturity dates in Column B. Use YIELDMAT to calculate the yield of a bond based on these dates, helping investors assess potential returns efficiently.
Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis.
Browse our complete library of Google Sheets formula guides
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.