Monte Carlo cash-flow percentile estimate from supplied distributions · Calculation guide

Model each signed net-flow component as independently uniform between its limits.

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

InputValue
Requested percentile (%)10%
Simulation draws2,000
Integer random seed42

Independent uniform net cash flows

Minimum net flowMaximum net flow
80120
-40-20
ResultValue
Estimated cash-flow percentile53.331795
Simulated mean cash flow70.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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Requested percentile (%)10%11%Estimated cash-flow percentile53.33179553.98174
Simulation draws2,0002,200Estimated cash-flow percentile53.33179553.556408
Integer random seed4246Estimated cash-flow percentile53.33179552.874002
Minimum net flow (row 1)8088Estimated cash-flow percentile53.33179559.877806
Maximum net flow (row 1)120132Estimated cash-flow percentile53.33179555.079152
Monte Carlo cash-flow percentile estimate from supplied distributions →

Sources