Functions Reference

Chapter 6
|
Financial functions 53
Chapter 6
Financial functions
Financial functions calculate financial information, such as net present value and
payments. For example, you can calculate the monthly payments required to buy a car at
a certain loan rate using the PMT function.
Click a function name for details.
FV
Format
FV(payment;interestRate;periods)
Parameters
payment - payment to be made per period
interestRate - interest rate per period
periods - number of periods
Data type returned
number
Description
Returns the future value of an initial investment, based on a constant interestRate and
payment amount for the number of periods in months. For example, you can calculate
how much you’ll earn on an investment in which you pay $50 a month for 60 months at a
6 percent annual interest rate.
This function Returns
FV, page 53 The future value of an initial investment, based on a constant interest rate and
payment amount for the number of periods in months.
NPV, page 54 The net present value of a series of unequal payments made at regular intervals,
assuming a fixed rate per interval.
PMT, page 55 The payment required to meet the requirements of the term, interest rate, and
principal.
PV, page 56 The present value of a series of equal payments made at regular intervals
(periods), assuming a fixed interest rate per interval.