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.
The FV function returns the future value of an investment that has periodic constant payments and a constant interest rate.
- 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 ...