Borrowing and saving with PMT, PV, FV and NPER
ExpertExpert
10 questions, about 19 minutes
Work out the monthly payment on a loan, how much you can borrow, how long you'll be paying and what your savings bring in.
What we'll do
- The monthly payment with PMT
- How much you can borrow with PV
- Saving with FV
- How long you'll pay with NPER
What you'll use
PMTPVFVNPERIF
How it works
In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.
2examplesYou watch
10questionsYou do it yourself