YIELDMAT

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:

Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.

We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.

or you can help me through https://www.buymeacoffee.com/cashheaven 😉

---

Back to Learn Excel->