INTRATE()

Syntax. INTRATE(Settlement,Maturity,Investment,Repayment,Basis)

Definition. This function calculates the equivalent interest rate in arrears for a security that has received a markdown (discount, disagio) for an intra-annual duration. The only difference between this function and YIELDDISC() is the naming of the arguments.

Arguments

  • Settlement (required) The date when the ownership of the security changes.

  • Maturity (required) The day when the payments from the security must take place.

  • Investment (optional) The purchase price of the security at the day of settlement.

  • Redemption (required) The payment at the day of maturity.

  • Basis (optional) The method you want to use for determining the days in the year according to Table 15-2, shown earlier. ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.