Loading…
Loading…
PMT works out a loan payment, NPV brings future cash flows back to today's money, and IRR finds the rate of return of a series of cash flows. Money you pay out is negative. For monthly loans, divide the annual rate by 12 and use months for the number of periods.
Syntax
PMT(rate, nper, pv) · NPV(rate, value1, …) · IRR(values)
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.