Skip to content
Decision tree templates

Decision Tree — Buy Flood Cover? (Risk Tolerance)

Why firms insure against negative expected value: going uninsured has the best expected outcome (−$35.4k) but, with a risk tolerance of $250k, a certainty equivalent of −$186.8k, so the risk-averse choice is the high-excess policy (CE −$40.4k) — the switch the tree states outright. Illustrative values.

Template previewDecision tree
Should a 40-person manufacturer buy flood cover?Should a 40-person manufacturer buy flood cover?Net 12-month outcome of the flood risk, US$ thousands — premiums plus uninsured losses1 decision · 3 chance nodes · 9 outcomes · maximise expected value · risk tolerance $250kOPTIMAL STRATEGYHigh-excess policy, $150k excess·EV −$36.9k·CE −$40.4kNo coverStandard policy, $50k excesscost $38k · net −$43.0kMajor flood0.03Minor flood0.07No flood0.9Major flood0.03Minor flood0.07No flood0.9Flooding in the next 12monthsEV −$35.4k · CE −$186.8k−$900k−$120k$0Flooding in the next 12monthsEV −$5.0k · CE −$5.5k−$50knet −$88k−$50knet −$88k$0net −$38kHigh-excess policy, $150k excesscost $24k · net −$36.9kMajor flood0.03Minor flood0.07No flood0.9Flood coverEV −$36.9k · CE −$40.4kFlooding in the next 12monthsEV −$12.9k · CE −$16.4k−$150knet −$174k · P 0.03−$120knet −$144k · P 0.07$0net −$24k · P 0.9DecisionChanceOutcomeOptimal strategyRejected alternativeRisk profile·cumulative probability by first choice0%25%50%75%100%−$1,000k−$800k−$600k−$400k−$200k$0final outcome, net of costsFIRST CHOICEEVNo cover−$35.4kσ $155.1k · worst −$900kStandard policy, $50k excess−$43.0kσ $15.0k · worst −$88kHigh-excess policy, $150k exc…−$36.9kσ $38.9k · worst −$174kWhat the rollback showsBest first choice: “High-excess policy, $150k excess”, certainty equivalent −$40.4k (EV −$36.9k) — $3.1k ahead of the next best,“Standard policy, $50k excess” (CE −$43.5k).Following it, the outcome ranges from −$174k to −$24k across 3 possible results, standard deviation $38.9k; every outcome is a netcost.With risk tolerance $250k the certainty equivalent is −$40.4k, a risk premium of $3.5k; a risk-averse decision maker takes“High-excess policy, $150k excess” instead of the expected-value choice “No cover” (EV −$35.4k).Note: Risk tolerance is about a sixth of equity, a common rule of thumb for a small firm; flood bands are the site's 1-in-33-year (major) and1-in-14-year (minor) events.Note: Illustrative values for a fictional firm.

Make it your own.

title "Should a 40-person manufacturer buy flood cover?"
subtitle "Net 12-month outcome of the flood risk, US$ thousands — premiums plus uninsured losses"
currency $
unit k
risk-tolerance 250
risk-profile compare
note "Risk tolerance is about a sixth of equity, a common rule of thumb for a small firm; flood bands are the site's 1-in-33-year (major) and 1-in-14-year (minor) events."
note "Illustrative values for a fictional firm."

decision "Flood cover"
  "No cover" -> chance "Flooding in the next 12 months"
    "Major flood" p 0.03 -> -900
    "Minor flood" p 0.07 -> -120
    "No flood" p rest -> 0
  "Standard policy, $50k excess" cost 38 -> chance "Flooding in the next 12 months"
    "Major flood" p 0.03 -> -50
    "Minor flood" p 0.07 -> -50
    "No flood" p rest -> 0
  "High-excess policy, $150k excess" cost 24 -> chance "Flooding in the next 12 months"
    "Major flood" p 0.03 -> -150
    "Minor flood" p 0.07 -> -120
    "No flood" p rest -> 0