datarekha

Monte Carlo Simulation for Business Decisions

Our model says $800,000 profit — but every input is a guess. Monte Carlo simulation draws thousands of possible futures and tells you the probability of each, including the chance you actually lose money.

9 min read Advanced Business Analytics Lesson 16 of 21

What you'll learn

  • What Monte Carlo simulation is and why single-point estimates hide critical risk
  • How to read a profit distribution: mean, loss probability, and percentile ranges
  • Why sensitivity analysis and expected value are incomplete on their own
  • How to interpret a 5th and 95th percentile as a practical 90% confidence range
  • The garbage-in-garbage-out limit of Monte Carlo and how to avoid it

Before you start

Your sensitivity analysis from the previous lesson confirmed that demand is the input that moves profit the most. Your expected-value calculation confirmed that the average outcome is positive. But your CFO just asked a harder question: What is the probability we actually lose money?

Neither tool answers that. Sensitivity analysis varies one input at a time and gives you a table of what-ifs. Expected value averages outcomes but requires you to hand-specify the probability of each scenario. Neither gives you the full distribution of profit across all the ways demand, cost, and price could realistically combine.

That is exactly what Monte Carlo simulation does.

What Monte Carlo simulation is

Monte Carlo simulation — named after the famous casino district because it relies on repeated random sampling — is a technique where, instead of plugging one best-guess value into each uncertain input, you draw each input from a probability distribution (a mathematical description of all the values a variable could plausibly take and how likely each is), compute the output, and repeat this process thousands of times. The result is not a single number but a whole distribution of outcomes: a histogram of profits showing every region from worst case to best case, along with the probability of landing in each region.

In one sentence: sensitivity analysis shows you which knob matters most; Monte Carlo turns every knob simultaneously, at random, ten thousand times, and shows you the resulting spread.

Why one number is dangerous

Suppose your business plan prints: Profit = $800,000. That number is computed from:

Profit = (Price - Unit Cost) x Demand - Fixed Costs
       = ($50 - $30) x 100,000 - $1,200,000
       = $800,000

The $800,000 is real — if every assumption hits its exact target. But demand is not a fixed fact. It is a guess. If demand comes in at 70,000 units instead of 100,000 units, profit collapses to $200,000. If it comes in at 55,000 units, you are in the red.

A single number tells you the destination assuming perfect aim. Monte Carlo tells you the distribution of landing spots given realistic aim.

Building the simulation: one uncertain input

In this lesson we hold price and cost fixed (they are negotiated contracts) and treat demand as the one uncertain input. We believe demand is centered on 100,000 units with a standard deviation of 20,000 units, and we model it as a Normal distribution (the symmetric bell-curve shape, appropriate when the variable is the aggregate of many independent small factors — which demand typically is). Standard deviation of 20,000 means that roughly two-thirds of the time demand falls within 20,000 units of the mean, and about 95% of the time it falls within 40,000 units.

The simulation runs the profit formula 10,000 times, each time drawing a fresh random demand from that distribution.

Reading the output

The simulation prints five numbers. Here is what each means for your decision.

Mean profit: ~$800,000. This matches the single-point estimate exactly — which is expected. When the input distribution is symmetric (Normal) and the profit formula is linear in demand, the average output equals the output at the average input. Monte Carlo confirms the earlier calculation rather than replacing it.

Chance of a loss: ~2.3%. This is the number the single-point model cannot produce at all. Roughly 1 in 43 simulated futures ends in an outright loss. Whether that is acceptable depends on your context: 2.3% might be fine for a small discretionary project and disqualifying for a bet-the-company investment.

5th percentile: ~$149,000. In 5% of simulated futures — the worst tail — profit falls to around $149,000 or below. This is your downside guard: even in a bad year, the model says you are more likely than not to clear $149,000.

95th percentile: ~$1,456,000. In the best 5% of futures, profit reaches about $1.46 million. The gap between the 5th and 95th percentiles — roughly $149,000 to $1.46 million — is your 90% confidence range (the interval that captures the middle 90% of outcomes). A range of over $1.3 million wide is a sobering reminder of how much a single uncertain input can matter.

What the distribution adds that the point estimate hid

What you knew beforeWhat Monte Carlo adds
Expected profit: $800,000Full profit distribution across 10,000 futures
(Nothing)P(loss) = 2.3%, roughly 1 in 43
(Nothing)90% of outcomes land between ~$149k and ~$1.46M
Demand is the most sensitive inputDemand uncertainty alone creates a $1.3M wide range

The mean is the same. But a decision-maker evaluating whether to greenlight this project now has something entirely different: a quantified risk profile. They can ask whether the 2.3% loss probability exceeds the firm’s risk tolerance, whether the downside of $149,000 at the 5th percentile is survivable, and whether the upside justifies the spread.

Connecting the three tools

It helps to see these lessons as a progression:

  • Sensitivity analysis (previous lesson): vary one input at a time, hold the rest fixed. Tells you which input to worry about most. Does not give probabilities.
  • Expected value (two lessons back): assign explicit probabilities to a few hand-chosen scenarios, compute the weighted average. Gives a single average payoff. Requires you to pre-specify every scenario.
  • Monte Carlo simulation (this lesson): specify a full probability distribution for each uncertain input, sample thousands of times, read the resulting output distribution. Gives the full range plus the probability of any region — including P(loss).

Each tool answers a different question. A rigorous analysis uses all three.

What to do with the output

A Monte Carlo result is an input to a conversation, not a final answer. Typical next steps:

  1. Stress-test the distribution assumption. Run the simulation again with a wider standard deviation (say, 30,000 instead of 20,000) and see how much P(loss) changes. If P(loss) jumps from 2.3% to 8%, the result is sensitive to the assumption — which should prompt more research into the demand forecast.

  2. Set a risk threshold before seeing the numbers. Decide in advance: “We will proceed if P(loss) is below 5%.” This prevents the common trap of anchoring to whatever the simulation prints and declaring it acceptable after the fact.

  3. Report the range, not just the mean. Presenting “$800,000 profit” to a board is incomplete. Presenting “$800,000 average profit, 2.3% chance of a loss, 90% of outcomes between $149,000 and $1.46 million” is decision-grade information.

Next

Forecasting: trend and seasonality — predicting the future from historical patterns, not just simulating it from assumed distributions.

Quick check

0/3
Q1The simulation prints a mean profit of $802,524 and a loss probability of 2.3%. A colleague says, 'The average is positive, so there is nothing to worry about.' What is the most important thing the colleague is ignoring?
Q2A team re-runs the simulation with demand standard deviation increased from 20,000 to 35,000 units, keeping the mean demand at 100,000. The mean profit stays near $800,000. What happens to the loss probability and why?
Q3A startup is evaluating two projects. Project A: mean profit $500,000, P(loss) = 1%, 90% range $300,000 to $700,000. Project B: mean profit $800,000, P(loss) = 15%, 90% range -$200,000 to $1,800,000. The startup has limited cash reserves and cannot survive a loss. Which project should it prefer, and why?

Practice this in an interview

All questions
How do you choose the classification threshold for a model when the goal is a business outcome, not pure accuracy?

The default 0.5 threshold optimises for balanced accuracy but is rarely the right choice for business objectives. The correct threshold is found by translating the business cost of false positives and false negatives into a cost matrix, then sweeping the threshold on a held-out set to find the point that minimises expected cost or maximises expected profit. Operational constraints — such as review-team capacity — further bound the feasible region.

How do you choose the optimal decision threshold for a binary classifier?

The optimal threshold depends on the business cost of false positives versus false negatives, not on defaulting to 0.5. You choose it by plotting the PR or ROC curve on a held-out set, computing the metric that captures your cost function (e.g., F-beta, revenue, expected cost) at each threshold, and selecting the point that maximises it. Threshold tuning is free and should always precede resampling or model changes.

Estimate the number of Uber rides taken in New York City on a typical weekday.

Market-sizing questions test whether you can decompose a complex number into estimable sub-components, make explicit and reasonable assumptions, sanity-check against known benchmarks, and communicate uncertainty without losing structure. The answer itself matters less than the reasoning chain.

Explain the Monty Hall problem and why switching wins two-thirds of the time.

In the Monty Hall problem, a host who knows where the prize is always opens an empty door — this action transfers probability mass to the remaining unopened door, making switching win with probability 2/3 and staying win only 1/3. The key is that the host's action is not random.

Sign in to track your progress

Completed lessons, your XP, level, and streak save to your account — it's free and takes a few seconds.

Explore further

Related lessons

Skip to content