Student Others
46 Points
Joined October 2012
Hello Friends,
The most common financial functions in Excel 2007 — PV (Present Value) and FV (Future Value) — use the same arguments. The key to using these financial functions is to understand the terminology used by their arguments:
Calculating the Present Value (PV):
The PV function returns the present value of an investment, which is the total amount that a series of future payments is worth presently. The syntax of the PV function is as follows:
=PV(rate,nper,pmt,[fv],[type])
Determining the Future Value (FV):
The FV function calculates the future value of an investment. The syntax of this function is
=FV(rate,nper,pmt,[pv],[type])
Thanks And Regards.
Agili Ron