Name

Rate Function — Microsoft.VisualBasic.Financial

Synopsis

Rate(nper, pmt, pv[, fv[, due[, guess]]])
nper required; Double

The total number of periods in the annuity.

pmt required; Double

The payment amount per period.

pv required; Double

The present value of the payments or future receipts.

fv optional; Double

The future value or cash balance after the final payment. If omitted, its value defaults to 0.

due optional; DueDate enumeration

A flag indicating whether payments are due at the beginning of the payment period (a value of DueDate.BegOfPeriod) or at the end of the payment period (a value of DueDate.EndOfPeriod, the default).

guess optional; Double

An estimate of the value to be returned by the function. If omitted, its value defaults to .1 (10%).

Return Value

A Double representing the interest rate per period

Description

Calculates the interest rate for an annuity (a loan or an investment) that consists of fixed payments over a known duration.

Get VB.NET Language Pocket Reference 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.