© Mandeep Mehta 2021
M. MehtaMicrosoft Excel Functions Quick Referencehttps://doi.org/10.1007/978-1-4842-6613-7_11

11. Finance Functions

Mandeep Mehta1  
(1)
Mumbai, India
 

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 ...

Get Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.