Loading…
Loading…
Four functions answer the classic money questions. FV: what will my savings grow to? PV: how big a loan can a payment afford? NPER: how many payments until it is paid off? RATE: what interest rate is hidden in a deal? Use the same period everywhere: for monthly payments divide the annual rate by 12. Money you pay out is negative.
Syntax
FV(rate, nper, pmt) · PV(rate, nper, pmt) · NPER(rate, pmt, pv) · RATE(nper, pmt, pv)
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.