Level cash flows

TVM worksheet: N, I/Y, PV, PMT, and FV

Use the TVM worksheet when payments are level and equally spaced. Put every quantity on one time scale before keying it in: monthly N requires a monthly effective I/Y, half-year coupon periods require a half-year yield, and annual periods require an annual rate.

PV+PMTaNi+FV(1+i)N=0PV+PMT\,a_{\overline{N}|i}+FV(1+i)^{-N}=0
RegisterEnter
NTotal number of equal periods
I/YInterest percentage per N period
PVValue at time 0
PMTLevel payment each period
FVValue at time N after the last payment

Enter zero for an unused register, enter the four known values, and press CPT followed by the unknown register. For a 20,000 loan repaid by 60 month-end payments at 0.5% per month, the direct-period sequence is60 N; 0.5 I/Y; 20000 PV; 0 FV; CPT PMT, producing approximately −386.66 from the borrower's viewpoint.