YIELD

Function Type: Financial

Description:

Returns the yield on a security that pays periodic interest.

Function Structure:

=YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis]).

Argument Breakdown:

settlement – This is the settlement date of the security. It is a date after the security is traded to the buyer that is after the issue date.

maturity – This is the maturity date of the security. It is the date when the security expires.

rate – The annual coupon rate.

pr – The price of the security per $100 face value.

redemption – This is the redemption value per $100 face value.

frequency – The number of coupon payments per year. It must be one of the following: 1 = Annually, 2 = Semi-annually, 4 = Quarterly.

basis – Specifies the financial day count basis that is used by the security.

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.

One thought on “YIELD”