PV Function in Excel | Financial Function in Excel

PV, one of the financial functions in excel, calculates the present value of a loan or an investment, based on a constant interest rate.

=PV(rate, nper, pmt, [fv], [type])

rate - The interest rate per period.
nper - The number of payment periods.
pmt - The payment made each period (EMI).
fv - [optional] Future value. If omitted, defaults to zero.
type - [optional] Payment type, 0 = end of period, 1