Choose a point of view
From a borrower's perspective, receiving the loan is a positive present value and paying the instalments is a negative payment. Use one viewpoint consistently. Giving every cash flow the same sign can make a standard borrowing problem inconsistent.
Write the timeline before entering numbers: when the money arrives, how often payments happen, how many payments there are, and whether a balance remains at the end.
Work through a twelve-payment loan
For an illustrative 1,200 loan at 6% nominal annual interest compounded monthly, use 12 end-of-month payments, PV = +1,200 and FV = 0. With a monthly rate of 0.5%, the calculated PMT is approximately −103.28.
The minus sign represents money leaving the borrower's viewpoint. Keep the unrounded payment during mathematical checks. A real payment schedule may round each payment and adjust the final one, so it need not match a repeated rounded amount exactly.
Check before changing the model
Confirm that N counts payments rather than years. Check END versus BEGIN and whether the annual rate is nominal or effective. If a comparison uses different assumptions, fix those assumptions before comparing payments.
Yieldra keeps all five TVM registers visible and separates payment frequency from compounding frequency. Its free TVM result card helps inspect balance and interest after the input problem is clear.
- Label the interest convention.
- State whether payments are in advance or arrears.
- Include a nonzero FV when a final balance remains.