Omitted and Misdated Cash Flows

Why a Complete Timeline Matters

An NPV calculation can use the correct discount rate and still be wrong if its cash-flow list is incomplete or its dates are inaccurate. A missing receipt understates NPV; a duplicated receipt overstates it. Moving a cash flow to an earlier or later date changes its present value even when its amount is unchanged. The reliable starting point is therefore not a formula alone, but a complete timeline that shows each cash flow once, with its correct sign and date.

This tutorial assumes a single valuation date at time 0, a fixed effective annual interest rate $i$, and cash flows dated in years. The rate is applied consistently to every flow. If a flow occurs at time $t$, its present value is its signed amount multiplied by $v^t$, where $v=1/(1+i)$. A receipt is positive and a payment is negative. When actual dates do not fall on whole years, the time exponent must match the stated compounding and date convention; do not silently treat a fraction of a year as a whole period.

Definition: For signed cash flows $C_k$ occurring at times $t_k$, the net present value at time 0 is the sum of their present values: $$ \operatorname{NPV}=\sum_k C_kv^{t_k}, \qquad v=\frac{1}{1+i}. $$ A timeline is complete when it includes every relevant cash flow exactly once, with its correct signed amount and time.

When auditing a record, keep two timelines separate: the actual timeline and the recorded timeline. The difference between their NPVs is the correction. Establishing that direction explicitly prevents a common sign error: a positive correction means the recorded NPV must increase, while a negative correction means it must decrease.

Present-Value Corrections for Timeline Errors

Each timeline error can be expressed as a change in present value. If an actual cash flow is omitted, add its signed present value. If an entry is duplicated, remove the extra copy. If a flow is dated incorrectly, replace the present value at the recorded date with the present value at the actual date.

\begin{aligned} \text{Omitted flow }C\text{ at }t &: \quad \Delta\operatorname{NPV}=Cv^t,\\ \text{Extra duplicate }C\text{ at }t &: \quad \Delta\operatorname{NPV}=-Cv^t,\\ \text{Flow }C\text{ recorded at }t_r\text{ but actually at }t_a &: \quad \Delta\operatorname{NPV}=Cv^{t_a}-Cv^{t_r}. \end{aligned}

Here $\Delta\operatorname{NPV}$ means actual NPV minus recorded NPV. The signed amount $C$ matters. For example, omitting an outflow means $C<0$, so the correction is negative: adding the missing payment lowers NPV.

Why the Correction Formulas Work

NPV is a sum of discounted cash flows. Because each dated entry contributes its own present value, changing one entry changes the total by the difference between its correct contribution and the contribution currently included in the record.

Write the recorded contribution.
A flow $C$ recorded at time $t_r$ contributes $Cv^{t_r}$ to recorded NPV.

Write the correct contribution.
The same flow, actually dated at $t_a$, contributes $Cv^{t_a}$ to correct NPV.

Subtract recorded from correct.
The change is $Cv^{t_a}-Cv^{t_r}$. If the entry was omitted, its recorded contribution is zero, leaving $Cv^{t_a}$. If an extra duplicate was recorded, removing that extra contribution changes NPV by $-Cv^t$.

This argument also explains why corrections from separate errors can be added: each error changes one or more terms in the NPV sum, so the total correction is the sum of those individual changes. This is valid when the errors are identified without counting the same erroneous entry twice.

Worked Example: An Omitted Receipt and a Duplicate Entry

A project’s actual cash flows are $-\$10{,}000$ at time 0, $+\$3{,}000$ at time 1, $+\$4{,}000$ at time 2, and $+\$5{,}000$ at time 3. The record contains the first two flows, lists the time-2 receipt twice, and omits the time-3 receipt. At an effective annual rate of $10\%$, find the recorded NPV, the correction, and the correct NPV.

Method. First calculate the recorded NPV from what is actually listed. Then remove the extra time-2 receipt and add the omitted time-3 receipt. Here $v=1/1.10$.

\begin{aligned} \operatorname{NPV}_{\text{recorded}} &=-10{,}000+\frac{3{,}000}{1.10} +\frac{4{,}000}{1.10^2}+\frac{4{,}000}{1.10^2}\\ &=-10{,}000+2{,}727.2727+3{,}305.7851+3{,}305.7851\\ &=-\$661.16. \end{aligned}

The duplicate is an extra positive receipt, so removing it reduces NPV by $4{,}000/1.10^2=\$3{,}305.7851$. The omitted receipt increases NPV by $5{,}000/1.10^3=\$3{,}756.5740$. Thus:

\begin{aligned} \Delta\operatorname{NPV} &=-\frac{4{,}000}{1.10^2}+\frac{5{,}000}{1.10^3}\\ &=-3{,}305.7851+3{,}756.5740\\ &=\$450.7889. \end{aligned}

The correct NPV is the recorded NPV plus the correction: $-\$661.1570+\$450.7889=-\$210.3681$, or -\$210.37 to the nearest cent. Directly using the actual timeline gives $-10{,}000+2{,}727.2727+3{,}305.7851+3{,}756.5740=-\$210.3681$, which checks the correction. The common mistake avoided here is adding the omitted receipt but forgetting to remove the duplicate.

Misdated Cash Flows: Direction and Size of the Error

For a positive receipt and a positive interest rate, recording the receipt too early overstates its present value: $v^{t_r}>v^{t_a}$ when $t_r<t_a$. Recording an outflow too early has the opposite effect on NPV because the cash flow is negative. In all cases, use the signed amount in the actual-minus-recorded formula rather than relying on a verbal rule alone.

Worked Example: A Receipt Entered One Year Too Early

A project’s actual cash flows are $-\$15{,}000$ at time 0, $+\$4{,}000$ at time 1, $+\$6{,}000$ at time 2, and $+\$8{,}000$ at time 3. The record instead places the $+\$6{,}000$ receipt at time 1. At an effective annual rate of $10\%$, calculate both NPVs and the overstatement in the record.

Method. Calculate the record using its stated dates, then recalculate using the actual dates. The misdated receipt is the only difference.

\begin{aligned} \operatorname{NPV}_{\text{recorded}} &=-15{,}000+\frac{4{,}000}{1.10} +\frac{6{,}000}{1.10}+\frac{8{,}000}{1.10^3}\\ &=-15{,}000+3{,}636.3636+5{,}454.5455+6{,}010.5184\\ &=\$101.4275\approx \$101.43. \end{aligned}

For the actual timeline, the time-2 receipt is discounted for two years:

\begin{aligned} \operatorname{NPV}_{\text{actual}} &=-15{,}000+\frac{4{,}000}{1.10} +\frac{6{,}000}{1.10^2}+\frac{8{,}000}{1.10^3}\\ &=-15{,}000+3{,}636.3636+4{,}958.6777+6{,}010.5184\\ &=-\$394.4403\approx-\$394.44. \end{aligned}

The recorded NPV exceeds the correct NPV by:

\frac{6{,}000}{1.10}-\frac{6{,}000}{1.10^2} =5{,}454.5455-4{,}958.6777 =\$495.8678\approx \$495.87.

The difference between the two full NPVs is also $\$101.4275-(-\$394.4403)=\$495.8678$. A common mistake is to use the value at the correct date as the correction itself; the correction is instead the actual present value minus the present value already recorded.

Combining Missing and Misdated Entries

Several errors can occur together. Label each one, calculate its correction with a consistent sign convention, and then add the corrections. A useful check is to reconstruct the complete timeline and calculate its NPV directly.

Worked Example: Correcting a Missing Receipt and an Early-Paid Outflow

At an effective annual rate of $10\%$, a ledger shows an initial payment of $\$10{,}000$ at time 0 and an outflow of $\$6{,}050$ at time 2. The actual timeline has that outflow at time 1 and also includes a receipt of $\$1{,}331$ at time 3, which the ledger omitted. Find both NPVs and the correction.

Method. The ledger’s NPV is $-\$10{,}000-\$6{,}050/1.10^2=-\$15{,}000$, since $6{,}050/1.21=\$5{,}000$.

Correcting the outflow date changes its present-value contribution from $-\$5{,}000$ to $-\$5{,}500$, because $6{,}050/1.10=\$5{,}500$. The date correction is therefore $-\$500$. The omitted receipt contributes $1{,}331/1.10^3=\$1{,}000$, because $1.10^3=1.331$. The net correction is:

\Delta\operatorname{NPV}=-500+1{,}000=\$500.

The repaired NPV is $-\$15{,}000+\$500=-\$14{,}500$. Checking from the complete actual timeline gives $-\$10{,}000-\$6{,}050/1.10+\$1{,}331/1.10^3=-\$10{,}000-\$5{,}500+\$1{,}000=-\$14{,}500$. The correction is an increase of $\$500$, not $\$1{,}500$: the omitted receipt adds $\$1{,}000$, while moving the outflow earlier lowers NPV by $\$500$. This sign check is particularly important when a problem combines receipts and payments.

A Practical Audit Sequence

When reviewing a calculation, avoid trying to infer the answer from a single reported NPV. Make an explicit reconciliation between the record and the actual timeline.

Fix the valuation date, rate, and time unit. Confirm that $i$ is an effective annual rate if times are measured in years.
Write all actual flows once. Include receipts, payments, and any relevant terminal or working-capital flows at their actual dates.
Compare entries individually. Mark each as correct, omitted, duplicated, or misdated. Do not call two legitimate flows duplicates merely because their amounts match.
Calculate corrections as actual minus recorded. Keep payments negative and receipts positive throughout.
Verify by direct valuation. Calculate NPV from the complete corrected timeline and compare it with recorded NPV plus the net correction.

A useful summary table can keep the signs visible:

Error in record	Correction to recorded NPV	Typical direction at positive interest
Positive receipt omitted at time $t$	Add $Cv^t$, where $C>0$	NPV increases
Negative payment omitted at time $t$	Add $Cv^t$, where $C<0$	NPV decreases
Extra copy of a flow $C$ at time $t$	Subtract $Cv^t$	Depends on whether $C$ is positive or negative
Flow $C$ recorded at $t_r$, actually at $t_a$	Add $C(v^{t_a}-v^{t_r})$	Depends on the sign and direction of the date error

Common Mistakes

Correcting the wrong direction. Define the correction as actual NPV minus recorded NPV before calculating.
Ignoring the cash-flow sign. An omitted payment is not an NPV increase; its signed amount is negative.
Discounting a dated flow by the wrong number of periods. A flow at time 3 is discounted by $v^3$, not $v^2$, even if it is entered in a row near a time-2 flow.
Counting a duplicate twice. Remove only the extra copy; retain the legitimate entry.
Rounding intermediate present values. Keep several digits through the reconciliation and round the final dollar answer to cents.

Key takeaway: A timeline error changes NPV by the present value of the correct entry minus the present value of the entry currently recorded. Use signed amounts, actual dates, and a direct corrected-timeline calculation to verify the result. The methods in this tutorial are aligned with the SOA Exam FM (Financial Mathematics) syllabus.

Check Your Understanding

For each problem, use actual NPV minus recorded NPV as the correction. Round dollar results to the nearest cent.

At an effective annual rate of $5\%$, a receipt of $\$1{,}102.50$ due at time 2 is omitted. By how much should recorded NPV be corrected? (Answer: Increase by $\$1{,}000.00$.)
At an effective annual rate of $10\%$, a receipt of $\$4{,}000$ due at time 3 is entered at time 2. By how much does recorded NPV exceed correct NPV? (Answer: $\$300.53$.)
At an effective annual rate of $10\%$, an extra copy of a $\$2{,}420$ receipt at time 2 appears in a ledger. By how much does the recorded NPV exceed the correct NPV? (Answer: $\$2{,}000.00$.)
At an effective annual rate of $5\%$, a $\$2{,}205$ payment at time 2 is omitted, while a $\$1{,}102.50$ receipt due at time 2 is entered at time 1. Find the net correction to recorded NPV. (Answer: Decrease by $\$2{,}050.00$.)
At an effective annual rate of $10\%$, the actual cash flows are $-\$12{,}000$ at time 0, $+\$3{,}000$ at time 1, $+\$5{,}000$ at time 2, and $+\$4{,}000$ at time 3. A ledger records the first two flows, duplicates the time-2 receipt, and omits the time-3 receipt. What is the correction to the ledger’s NPV? (Answer: Decrease by $\$1{,}126.97$.)

Error in record	Correction to recorded NPV	Typical direction at positive interest
Positive receipt omitted at time \(t\)	Add \(Cv^t\), where \(C>0\)	NPV increases
Negative payment omitted at time \(t\)	Add \(Cv^t\), where \(C<0\)	NPV decreases
Extra copy of a flow \(C\) at time \(t\)	Subtract \(Cv^t\)	Depends on whether \(C\) is positive or negative
Flow \(C\) recorded at \(t_r\), actually at \(t_a\)	Add \(C(v^{t_a}-v^{t_r})\)	Depends on the sign and direction of the date error

What You'll Learn