How can I use the YIELDMAT function in Google Sheets?

How can I use the YIELDMAT function in Google Sheets?

By /

The YIELDMAT function in Google Sheets is a financial formula that allows users to calculate the yield of a security with a maturity date. This function takes into account the maturity date, the settlement date, the price, the redemption value, and the basis of the security, and returns the annual yield as a percentage. To use the YIELDMAT function, simply input the required parameters into the formula and it will automatically calculate the yield. This function is particularly useful for investors and financial analysts who need to determine the yield of a security for investment decisions.

YIELDMAT function

The YIELDMAT function calculates the annual yield of a security paying interest at maturity, based on price.

Parts of a YIELDMAT formula

The YIELDMAT formula is formatted as =YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention]).

PartDescriptionNotes
settlementThe settlement date of the security, the date after issuance when the security is delivered to the buyer. 
maturityThe maturity or end date of the security, when it can be redeemed at face or par value. 
issueThe date the security was initially issued. 
rateThe annualized rate of interest. 
priceThe price at which the security is bought. 
day_count_conventionAn indicator of what day count method to use.
  • Optional – 0 by default.
  • 0 indicates U.S. (NASD) 30/360 – This assumes 30-day months and 360-day years as per the National Association of Securities Dealers standard and performs specific adjustments to entered dates which fall at the end of months.
  • 1 indicates Actual/Actual – This calculates based upon the actual number of days between the specified dates and the actual number of days in the intervening years. Used for U.S. Treasury Bonds and Bills, but also the most relevant for non-financial use.
  • 2 indicates Actual/360 – This calculates based on the actual number of days between the specified dates, but assumes a 360-day year.
  • 3 indicates Actual/365 – This calculates based on the actual number of days between the specified dates, but assumes a 365-day year.
  • 4 indicates European 30/360 – Similar to 0, this calculates based on a 30-day month and 360-day year, but adjusts end-of-month dates according to European financial conventions.

​

Sample formulas

YIELDMAT(DATE(2010,01,02),DATE(2039,12,31),DATE(2010,01,01),3,100.47)

YIELDMAT(A2,B2,C2,D2,E2,1)

Notes

  • settlement, maturity, and issue should be entered using DATE, TO_DATE, or other date parsing functions rather than by entering text.

Examples

 ABCD
1  FormulaResult
2settlement1/2/2010=YIELDMAT(B2, B3, B4, B5, B6, B7)0.13
3maturity12/31/2010  
4issue1/1/2008  
5

rate

2%  
6price90  
7day_count_convention2  

Related functions

PRICEMAT: Calculates the price of a security paying interest at maturity, based on expected yield.

YIELDDISC: Calculates the annual yield of a discount (non-interest-bearing) security, based on price.

 

Cite this article

stats writer (2024). How can I use the YIELDMAT function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-yieldmat-function-in-google-sheets/

stats writer. "How can I use the YIELDMAT function in Google Sheets?." PSYCHOLOGICAL SCALES, 29 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-yieldmat-function-in-google-sheets/.

stats writer. "How can I use the YIELDMAT function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-yieldmat-function-in-google-sheets/.

stats writer (2024) 'How can I use the YIELDMAT function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-yieldmat-function-in-google-sheets/.

[1] stats writer, "How can I use the YIELDMAT function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.

stats writer. How can I use the YIELDMAT function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.

Download Post (.PDF)

Related terms:

  1. How can I use the YIELDMAT function in Excel to calculate the annual yield for a security with a maturity date and a specified settlement date?
  2. Let’s learn how to do it in Google SheetsHow can we do it in Google Sheets?
  3. How to use Google Sheets to translate text using the Google Translate function?
  4. How can I use the ERF function in Google Sheets to calculate the error function of a given value?
  5. What is the function of the VLOOKUP function in Google Sheets?
  6. “How can I use the MAP function in Google Sheets to transform the values in a range based on a specified function?”
  7. Count Specific Characters in Google SheetsHow to count specific characters in google sheets?
  8. How do I use the COUPPCD function in Google Sheets?
  9. ?How can I create a PRICEMAT function in Google Sheets?
  10. How can I use the TBILLYIELD function in Google Sheets?
Slide Up
x
PDF
Scroll to Top