In this chapter, we will look into some of the most commonly used finance functions provided by Excel for use in financial calculations. So, let us began.
FV Function
The FV function returns the future value of an investment that has periodic constant payments and a constant interest rate.
Syntax
=FV(rate, period, payment, [present value], [type])
The FV function takes the following arguments:
- The first argument is the interest rate for the period. Here, it is assumed that payment is made once per year. If the payment period is different, divide the rate accordingly. So,
if payment is ...
