The PMT function is an Excel Financial function that returns the periodic payment for an annuity. The formula for the PMT function is PMT(rate,nper,pv, [fv], [type]). The NPV function returns the net ...

Credit: By discounting every future $3,000 cash flow back at a rate of 10%, and subtracting the initial cash outlay of $15,000, we arrive at a net present value of $3,433.70 for this project. Under ...