Google Sheets

YIELDMAT: Google Sheets Formulae Explained

How do you use YIELDMAT in Google Sheets?

The YIELDMAT function in Google Sheets calculates the yield on a maturity date for a bond. The function takes the following arguments:

BOND_PRICE - The price of the bond

YIELD - The yield of the bond

COUPON_PAYMENT - The coupon payment of the bond

MATURITY_DATE - The maturity date of the bond

The function returns the yield on the maturity date for the bond.

What is the syntax of YIELDMAT in Google Sheets?

The syntax of YIELDMAT in Google Sheets is as follows:

=YIELDMAT(rate,nper,pmt,fv,type)

Where:

rate is the annual interest rate nper is the number of payments pmt is the payment amount fv is the future value type is the payment type (0 for lump sum, 1 for annuity)

What is an example of how to use YIELDMAT in Google Sheets?

The YIELDMAT function in Google Sheets can be used to calculate the yield on a government bond or other investment. The syntax for the function is YIELDMAT(rate,nper,pmt,pv,fv,type). The "rate" is the annual interest rate of the investment, the "nper" is the number of payments over the life of the investment, the "pmt" is the periodic payment, the "pv" is the present value of the investment, the "fv" is the future value of the investment, and "type" is 0 for a regular bond or 1 for a bond that pays periodic interest.

An example of how to use the YIELDMAT function in Google Sheets is to calculate the yield on a 10-year government bond with a 3% annual interest rate. The syntax for the function would be YIELDMAT(3%,10,100,0,100,1). This function would return a yield of 2.745%.

When should you not use YIELDMAT in Google Sheets?

There are a few occasions when you should not use the YIELDMAT function in Google Sheets. One instance would be when you do not have any data to input into the function. Additionally, you should not use the function if you are trying to calculate the yield on a bond that does not have a fixed coupon rate. Lastly, the YIELDMAT function should not be used to calculate the yield on a bond that is not currently trading on the market.

What are some similar formulae to YIELDMAT in Google Sheets?

There are a few similar formulae to YIELDMAT in Google Sheets. The first is NPV, which calculates the net present value of a series of cash flows. Another is IRR, which calculates the internal rate of return of a series of cash flows. Lastly, there is XNPV, which calculates the net present value of a series of cash flows, using the x-factor method.

Move beyond 

Google Sheets

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.