Excel loan calculation function

Excel help documentation

The PV present value functionPV (rate, Nper, Pmt, Fv, Type)
Among them, rate, Nper (payment period), Pmt (payment) is a must, Fv (ending) and Type (0, the final payment; 1, the first payment) is an option, the default option is (0,0).
Example: there is a loan, the annual interest rate of 10%, two years to pay off, in monthly installments (2*12=24), each to pay 1000 yuan, the final desired outstanding balance of 3000 yuan, the monthly repayment (early 1). The formula for computing
PV (present value) and =PV (10%/12,24, -1000, -3000,1) =24309.67 yuan
The installment payment (24*1000+3000=27000 element) of the present value of 24309.67 yuan.

Rates of RATE functionRATE (Nper.Pmt, Pv, Fv, Type, Guess)
Among them, Nper, Pmt, Pv, Fv, Type and Guess are optional, optional (expected interest rate).
Example: there is a loan PV (-21851.45), two years to pay off, in monthly installments (2*12=24), pays (Pmt) 1000 yuan, the final desired outstanding balance, Fv (3000), at the beginning of every month repayment (1), the expected rate of 10%/12. Interest rate formula for:
RATE (interest rates) and =RATE (24, -100024309.67, -3000,1, 9%/12) =0.8333%

Future value of FV functionFV (rate, Nper, Pmt, Pv, Type)
Among them, rate, Nper and Pmt necessary, Pv and Type optional.
Example: there is a fixed monthly investment, monthly investment amount 1000 yuan, the investment period of 2 years (24 months), the annual rate of return of 10%, two years after the total amount of FV, calculation formula is
FV=FV (10%/12,24, -1000,0,0) =26446.92

The monthly repayment of PMT functionPMT (rate, Nper, Pv, Fv, Type)
Example: there is a total of 24309.67 yuan loan, the annual interest rate of 10%, the repayment period of 24 months, monthly matching repayment, the final additional one-time payment of 3000 yuan, the monthly repayment period, the monthly repayment amount is calculated as follows:
PMT (10%/12,2424309.67, -3000,1) =1000

Temporarily set out these common.