maturity-amt: A number value representing the total amount to be received at maturity, including both principal and interest. maturity-amt must be greater than 0.
days-basis: An optional European method for dates falling on the 31st of a month.
Example
Suppose you are presented with an investment opportunity. The investment is a discount security offered for sale at $685 (invest-amount), will mature on June 30, 2015 (maturity) at $1,000 (maturity-amt), and the purchase will settle on May 1, 2009 (settle).
=INTRATE("5/1/2009", "6/30/2015", 685, 1000, 0) returns approximately 7.46045269290106%, the effective annual interest rate of the hypothetical security. This rate could be compared to the interest rate you might earn on alternative investments as part of the decision as to which investment to make.