Formulas > =YIELDMAT()
How to Use YIELDMAT() in Google Sheets
Description
How To Actually Use YIELDMAT() in Sheets
YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention])
Try YIELDMAT yourself
Use the YIELDMAT formula to calculate the annual yield of a security. The settlement date is in cell A1, maturity date in B1, issue date in C1, interest rate in D1, and price in E1. Your formula should return the yield in cell F1.
Hints (2)
-
Make sure to reference the correct cells for each parameter.
-
Remember that the settlement and maturity dates should be in date format.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the YIELDMAT() formula:
Generate a YIELDMAT() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses YIELDMAT(). 2 free AI generations, no signup. Members get unlimited use.
Generate a YIELDMAT() formula