FV (Future Value): -It returns the future value of on investment based on periodic, constant payment and a constant interest rate.

                        Syntax: -      =Fv(Interest/Condition, Term, Installment)

                        Ex: -              =Fv(11%/12, 60, 1000)

                                                =Fv(5%/365, 1825, 10)

                                                =Fv(10%/4, 20, 5000)

                                                =Fv(10%/2, 10, 10000)

PMT (Per Month Term):- Calculate the payment for a loan based on constant payments and a constant interest rate.

 

                        Syntax: -      =PMT(Interest/Condition, Loan Amount)

                        Ex: -              =PMT(11%/12, 60, 100000)

 

PV (Present Value): -It returns the present value of an investment. The present value is the total amount that a series of future payment is worth row for example when you borrow money the loan amount is the present value to the lender.

                        Syntax: -      =PV(Interest/Condition, Loan Installment)

                        Ex: -              =PV(11%/12, 60, 2174.24)