Microsoft Office Tutorials and References
In Depth Information
Using DISC to Back into the Discount Rate
Figure 13.20.
Figure 13.20. You can use the
You can use the INTRATE
function to derive the underlying in-
terest rate for the bond.
INTRATE function to derive the underlying in-
terest rate for the bond.
Using
Using DISC
to Back into the Discount Rate
If you have a security and know the price, you can back into the discount
rate by using DISC.
DISC to Back into the Discount Rate
Syntax
DISC(settlement,maturity,pr,redemption,basis)
The DISC function returns the discount rate for a security. It takes the fol-
lowing arguments:
settlement
settlement This is the security s settlement date.
maturity
maturity This is the security s maturity date. The maturity date
is the date when the security expires.
Search JabSto ::




Custom Search