Financial Functions

Working with Loans and Investments• =PMT(rate, nper, pv, [fv=0] [type=0])• =FV(rate, nper, pmt, [pv=0] [type=0])• =NPER(rate, pmt, pv, [fv=0] [type=0])• =PV(rate, nper, pmt, [fv=0] [type=0])• =RATE(nper, pmt, pv, [fv=0] [type=0])

• Rate=• NPER =• PV =• FV =

• PMT =

Working with Loans and Investments

• To calculate the of the monthly or quarterly required to , use the PMT function

• To calculate the , use the FV function

• To calculate the monthly or quarterly a loan or meet an investment goal, use the

NPER function

• To calculate the of a loan or investment, use the PV function

• To calculate the of a loan or investment, use the RATE function