We raised a $20m Series A led by Coatue + Accel! Click here to read the announcement.

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.

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.

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%.

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.

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.

Get started with Causal today.

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

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