On this page
Write the unit before entering N
A three-year quarterly exercise contains twelve quarter-length intervals. If P/Y and C/Y are both four and I/Y is a nominal annual quotation, N = 12 is consistent. Entering N = 3 would value three intervals rather than three years under that state.
Inspect the complete synthetic single-sum state
| Input | Entry |
|---|---|
| N | 12 |
| I/Y | 6 |
| P/Y and C/Y | 4 and 4 |
| PV | −10,000 |
| PMT | 0 |
| FV | Compute |
Enter the interval count and solve
Set the stated frequencies first, clear prior TVM values and enter the table’s known quantities. With P/Y = C/Y = 4, the periodic rate is 6%/4 = 1.5%.
- Store the quarter count12N
The worksheet records twelve modeled intervals.
- Compute the future amount after all known values are enteredCPTFV
The mathematical check is +11,956.181715, before display rounding.
Check a time-unit mismatch before changing the answer
The independent result is 10,000 × 1.015^12. The value grows over twelve quarterly intervals. Check whether N refers to years, payments or another interval count in the source question; do not correct a mismatch merely by trying different numbers until an answer matches.