The Excel YIELD to maturity function is used to calculate the yield to maturity for a bond, and has the syntax YIELD (Settlement, Maturity, Rate, Pr, Redemption, Frequency, Basis).

# Discount Rate

Last modified February 13th, 2023

## Excel EFFECT Function

The Excel EFFECT function is used to calculate the effective annual rate from the nominal annual rate based on the number of compounding periods in a year. The effective annual rate allows for compounding, whereas the nominal annual rate does not allow for compounding.

Last modified February 10th, 2023