• crate(nper, pv, fv)—Returns the fixed interest rate per period for an investment to yield a specified future value fv, given a present value pv and a number of compounding periods nper.
• nom(apr, npery)—Returns the nominal interest rate, given an effective APR of apr, and npery number of compounding periods per year.
• rate(nper, pmt, pv, [[fv], [type], [guess]])—Returns the interest rate per period of an investment or loan over a specified number of compounding periods nper given a periodic, constant payment pmt and a specified present value pv.
If rate cannot find a result that is accurate to within 1×10−7 percent after 20 iterations, an error is returned. When this happens, try a different guess value.
Arguments
• nper is the positive integer number of compounding periods.
• pv is the real, positive present (or initial) value loan.
• fv (optional for rate) is the future value: a cash balance you want to attain after the last payment is made. If omitted, fv = 0.
• apr is the real, positive, scalar Annual Percentage Rate. It equals the nominal annual rate if compounding once a year.
• npery is the positive integer number of compounding periods per year.
• pmt is the real payment made each period. It usually includes principal and interest but no other taxes and fees.
• type (optional) is 0 for a payment made at the end of the period or 1 for the beginning. If omitted, type = 0.
• guess (optional) is a numeric value which approximates the answer, used as a starting point for the algorithm. If omitted, guess = 0.1 (10%).