Google Sheets

YIELDDISC: Google Sheets Formulae Explained

How do you use YIELDDISC in Google Sheets?

The YIELDDISC function in Google Sheets calculates the yield on a bond, based on the price and the par value. You can use it to compare different bonds, or to see how the yield changes over time.

What is the syntax of YIELDDISC in Google Sheets?

The syntax of YIELDDISC in Google Sheets is as follows:

=YIELDDISC(rate,days,investment)

This function calculates the yield on a discounted security. The rate is the annual interest rate, days is the number of days until the security matures, and investment is the amount of the security.

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

The YIELDDISC function in Google Sheets calculates the yield of a bond or note that pays periodic interest. The function takes three arguments: the periodic interest rate, the number of periods, and the face value of the bond or note. The function returns the yield of the bond or note as a decimal value. For example, the following formula calculates the yield of a bond with a periodic interest rate of 5%, a number of periods of 10, and a face value of $1,000:

=YIELDDISC(5%,10,1000)

The function returns a value of 0.05, or 5%.

When should you not use YIELDDISC in Google Sheets?

There are a few occasions when you should not use YIELDDISC in Google Sheets. One such time is when you are trying to calculate a bond's yield to maturity. In this case, you should use the functions BONDYIELD or YIELD. Another time you should not use YIELDDISC is when you are trying to calculate a loan's annual percentage rate (APR). In this case, you should use the function APR.

What are some similar formulae to YIELDDISC in Google Sheets?

The closest similar formula to YIELDDISC in Google Sheets is NPV(). NPV() calculates the net present value of a series of cash flows, where each cash flow is discounted using a rate you specify. Another similar formula is IRR(). IRR() calculates the internal rate of return for a series of cash flows. This function determines the rate of return at which the present value of the cash flows is equal to zero.

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.