Class Microsoft.VisualBasic.Financial Syntax Dim result As Double = Rate(nPer, pmt, pv[, fv[, due[, guess]]])
nPer (required; Double) The total number of payment periods.
pmt (required; Double) The payment amount per period.
pv (required; Double) The present value of a series of future payments.
fv (optional; Double) The future value or cash balance after the final payment. If omitted, the default value is 0.
due (optional; DueDate enumeration) A value indicating when payments are due, from the Microsoft.VisualBasic.DueDate enumeration. DueDate.EndOfPeriod indicates that payments are due at the end of the payment period; DueDate.BegOfPeriod indicates that payments are due at the beginning of the period. If omitted, the default value is DueDate.EndOfPeriod.
guess (optional; Double) An estimate of the value to be returned by the function. If omitted, its value defaults to 0.1 (that is, 10%).
Description The Rate function calculates the interest rate for an annuity that consists of fixed payments over a known duration. An annuity is a series of fixed cash payments made over a period of time. It can be either a loan or an investment. Usage at a Glance If pv and fv represent liabilities, their value is negative; if they represent assets, their value is positive. The function works using iteration. Starting with guess, the function cycles through the calculation until the result is accurate to within 0.00001 percent. If a result can't be found after 20 tries, it fails. If it fails, a different value for guess can be used. The value returned is the per-period rate. If you calculate the monthly rate, multiply by 12 to obtain the annual percentage rate.
See Also FV Function, IPmt Function, NPer Function, NPV Function, Pmt Function, PV Function, NPV Function |
