Payback of Unequal Cash Flows

Calculate using the labelled inputs: Payback of Unequal Cash Flows.

First simple recovery (periods)
2.5
First discounted recovery (periods)
2.5
Later falls below zero, simple balance
0
Later falls below zero, discounted balance
0
Final undiscounted net balance
200.00
Final net present value
200.00

Calculation and assumptions

C_n=−I+ΣCF_t; PV_n=−I+ΣCF_t/(1+r/100)^t; first crossing in period n: (n−1)+unrecovered_at_(n−1)/positive_flow_n.

Enter 1–200 equally spaced period-end flows with up to two decimals. Negative flows increase what remains to recover. Fractional recovery linearly interpolates within the crossing period using that period’s entire discounted flow; it is not continuous discounting. A dash means no crossing within entered flows. Initial zero outlay recovers at time zero. Later falls are counted separately: first recovery need not last. Exact rational discounting rounds only final monetary totals, halves away from zero. No IRR or investment verdict. In one chosen two-decimal currency; no taxes or current market rates are supplied.

Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.

Frequently asked questions

How is the result calculated?

C_n=−I+ΣCF_t; PV_n=−I+ΣCF_t/(1+r/100)^t; first crossing in period n: (n−1)+unrecovered_at_(n−1)/positive_flow_n.

What assumptions apply?

Enter 1–200 equally spaced period-end flows with up to two decimals. Negative flows increase what remains to recover. Fractional recovery linearly interpolates within the crossing period using that period’s entire discounted flow; it is not continuous discounting. A dash means no crossing within entered flows. Initial zero outlay recovers at time zero. Later falls are counted separately: first recovery need not last. Exact rational discounting rounds only final monetary totals, halves away from zero. No IRR or investment verdict. In one chosen two-decimal currency; no taxes or current market rates are supplied.

How precise are the results?

Monetary totals use two decimal places, with exact halves rounded away from zero at the steps described. Ratios and other numbers show up to ten significant digits. Display precision does not improve input accuracy. Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.

Also try:

Back to category →