Determine whether an archaeologist should fund a $500K expedition with an 80% expected ROI to recover a 6,000-year-old crown, given a 20% success rate and a required 85% ROI threshold. The analysis reveals the decision is finely balanced, with quantitative metrics slightly below the threshold but qualitative factors potentially justifying the investment.
Key Insights:
- Importance of categorizing costs into upfront, recurring, and opportunity costs for comprehensive financial analysis
- Present value calculations for comparing alternative deal structures (lump sum vs. revenue sharing)
- Probabilistic expected value analysis: (Success % × Upside) + (Failure % × Downside) versus required thresholds
- Recognition that ROI threshold misses by only 5 percentage points (80% vs. 85% required) leaves decision ambiguous
- Qualitative factors (personal fulfillment, future synergies, reputational benefits) can justify investment even when quantitative metrics marginally miss targets