Discussion Locked

VB FV() Function Syntax

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

can some one please give me an example on the syntax of VB Built-in function FV()
How do I call the function and specify the arguments?

Thanks!

1 reply

by tclere

Did you look in the VB help files? There is a complete explanation of the syntax and required variables.
xxxxx COPIED FROM THE HELP FILE xxxxx
Returns a Double specifying the future value of an annuity based on periodic, fixed payments and a fixedinterest rate.

Syntax

FV(rate, nper, pmt[, pv[, type]])

Named arguments:

rate: Req'd. Double specifying interest rate per period. For example, if you get a car loan at an annual percentage rate (APR) of 10 percent and make monthly payments, the rate per period is 0.1/12, or 0.0083.

nper: Req'd. Integer specifying total number of payment periods in the annuity. For example, if you make monthly payments on a four-year car loan, your loan has a total of 4 * 12 (or 48) payment periods.

pmt: Req'd. Double specifying payment to be made each period. Payments usually contain principal and interest that doesn't change over the life of the annuity.

pv: Optional. Variant specifying present value (or lump sum) of a series of future payments. For example, when you borrow money to buy a car, the loan amount is the present value to the lender of the monthly car payments you will make. If omitted, 0 is assumed.

type: Optional. Variant specifying when payments are due. Use 0 if payments are due at the end of the payment period, or use 1 if payments are due at the beginning of the period. If omitted, 0 is assumed.

This discussion is closed to new replies.