Flexible TVM Timeline with PMT

Timeline Controls

What do you want to solve for?

PV today ($) Use sign convention when solving: paid out = negative, received = positive.

FV future ($)

PMT periodic payment ($) New: equal payment each period.

Rate r (% per period)

Years / periods n

Payment timing

Left label

Right label

Excel sign rule: cash paid out should be negative and cash received should be positive. Practice example: =FV(6%,4,150,-5000,0). For RATE and NPER, do not wrap with ABS(); use opposite signs when appropriate.

Result

Click Calculate & Update

Timeline

PV at t=0 PMT periodic payments FV at t=n

Finance Formula

Click Calculate & Update to display the formula.

Excel Function

Click Calculate & Update to display the Excel function.