Discussion Locked

Excel PMT Formula

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Does anyone know how to transform PV*((1+Rate)^nper) + pmt(1+rate*type) * (((1+rate)^Nper) -1 )/ rate)+ FV = 0
into PMT = ?????. My maths is a little rusty. Help would be greatly appreciated.

1 reply

by dryflies

use the PMT function in Excel. stop trying to invent formulas that are already defined in excel.

This discussion is closed to new replies.