On this page
Write the intended model
Identify the valuation date, interval length, annual or periodic rate quotation and whose cash flows are being entered. Decide whether the model uses a level PMT or an explicit sequence before selecting a worksheet.
Check the relevant stored quantities
| Worksheet | Check |
|---|---|
| TVM | N, I/Y, PV, PMT, FV; explicit unused zeros |
| TVM settings | P/Y, C/Y and END/BGN |
| Cash Flow | CF0; every amount paired with its F count |
| NPV | I for one declared entry interval |
Make a check that does not repeat the same entry error
Use an expanded timeline or a separate formula with explicit periodic factors. Check whether the answer has the expected sign, units and valuation date. Re-entering the same mistaken state is not an independent verification.
Retain the error and its cause
Record the stored state, expected mathematical value and corrected cause in a study log. Useful error labels include timing, quote conversion, leftover payment, omitted zero intervals and sign perspective. The resulting categories can guide the next practice session.
Continue with CFA learning resources