Transcript
![Page 1: 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,](https://reader036.vdocuments.us/reader036/viewer/2022082820/56649e365503460f94b2563d/html5/thumbnails/1.jpg)
Financial Functions
![Page 2: 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,](https://reader036.vdocuments.us/reader036/viewer/2022082820/56649e365503460f94b2563d/html5/thumbnails/2.jpg)
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 =
![Page 3: 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,](https://reader036.vdocuments.us/reader036/viewer/2022082820/56649e365503460f94b2563d/html5/thumbnails/3.jpg)
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