• Calculator worksheet

Finance Functions Calculator

Run core time-value-of-money functions like PV, FV, NPV, PMT, and rate on a single screen.

Inputs

Live

Function

Annual rate

Periods (months)

Present value

What future cash is worth today at a chosen required return.

Variables and terms

Annual rate

The percentage assumption used by the calculation.

Periods (months)

The time period used to place the assumption in the model.

Present value

What future cash is worth today at a chosen required return.

How to read this calculator

The selected function controls which finance identity is active and which inputs feed the calculation. PMT, FV, RATE, and IPMT use the period rate and period count; EFFECT uses nominal rate and compounding; DB, DURATION, SLOPE, XNPV, XIRR, and MIRR use their named input sets.

Periodic payment

-5,066.85

Data view

FunctionPMT

OutputPeriodic payment

Current value-5,066.85

Methodology