Calculation guide
Draw reproducible scenarios using the integer seed. Percentiles linearly interpolate neighboring sorted outcomes. Equal bounds represent fixed cash.
X(j) = Σ [low(i) + U(i,j) × (high(i)−low(i))]. Sort X and interpolate at (n−1)p.
Inputs
Requested percentile (%)
Example entry 10 %. Allowed range 0 to 100.
Simulation draws
Example entry 2000. Allowed range 100.0 to 20000.0. Use whole numbers.
Integer random seed
Example entry 42. Allowed range 0.0 to 4294967295.0. Use whole numbers.
Minimum net flow
Example entry 100 (in the selected currency).
Maximum net flow
Example entry 100 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Requested percentile (%) | 10% |
| Simulation draws | 2,000 |
| Integer random seed | 42 |
Independent uniform net cash flows
| Minimum net flow | Maximum net flow |
|---|---|
| 80 | 120 |
| -40 | -20 |
| Result | Value |
|---|---|
| Estimated cash-flow percentile | 53.331795 |
| Simulated mean cash flow | 70.320513 |
Interpreting the result
The tenth percentile is a simulated outcome near the bottom tenth of the distribution. Changing the seed shows how much the finite sample affects the estimate.
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Requested percentile (%) | 10% | 11% | Estimated cash-flow percentile | 53.331795 | 53.98174 |
| Simulation draws | 2,000 | 2,200 | Estimated cash-flow percentile | 53.331795 | 53.556408 |
| Integer random seed | 42 | 46 | Estimated cash-flow percentile | 53.331795 | 52.874002 |
| Minimum net flow (row 1) | 80 | 88 | Estimated cash-flow percentile | 53.331795 | 59.877806 |
| Maximum net flow (row 1) | 120 | 132 | Estimated cash-flow percentile | 53.331795 | 55.079152 |
