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.
| Register | Enter |
|---|---|
| N | Total number of equal periods |
| I/Y | Interest percentage per N period |
| PV | Value at time 0 |
| PMT | Level payment each period |
| FV | Value 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.