Function Type: Financial
Description:
Returns the annual yield of a security that pays interest at maturity.
Function Structure:
=YIELDMAT(settlement, maturity, issue, pr, [basis]).
Argument Breakdown:
settlement – This is the settlement date of the security. The date should be after the issue date when the security is traded to the buyer.
maturity – The maturity date of the security. It is expressed as a serial date number.
pr – This is the security’s price per $100 face value.
basis – The type of count day basis to use.
Example:

If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig.