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