Adverse Selection & Lemons Market Calculator Excel Template

The Adverse Selection & Lemons Market Calculator Excel Template brings George Akerlof's landmark market-for-lemons model to life in a fully interactive spreadsheet. Whether you're an economics student exploring information asymmetry, a finance professional studying credit markets, or an instructor illustrating how hidden information destroys market efficiency, this template produces instant, formula-driven results for any parameter set.

What You Can Calculate

This template computes 9 key market outputs:

• Pooled Expected Value — The weighted average value of a random item in the market, assuming buyers cannot distinguish good items from lemons. Calculated as q × V_good + (1−q) × V_lemon.
• Pooled Willingness to Pay (WTP) — The maximum price a buyer will offer in a market of mixed quality. Equals the pooled expected value adjusted for any risk discount. This is the pivotal price that determines whether good sellers stay or exit.
• WTP for Known Lemon (p_lemon) — What a buyer would pay if they knew for certain the item was low quality. Tests whether even the lemons market can sustain trade.
• Good Sellers Participate? — A Yes/No output showing whether good-quality sellers find the pooled WTP acceptable relative to their reservation price.
• Market Outcome — The model's headline result: Full Trade, Partial Unraveling, Lemon-Only Market, or Complete Collapse. Instantly shows where adverse selection leads under your parameter assumptions.
• Equilibrium Expected Value & WTP — The actual value and price in equilibrium, accounting for which sellers remain in the market after adverse selection plays out.
• Items Traded — The number of transactions that occur in equilibrium, from full volume to zero in a market collapse.
• Forgone Surplus (Welfare Loss) — The total value destroyed by information asymmetry — gains from trade that would occur with perfect information but are lost because good sellers exit.
• Lemons Share in Equilibrium — The percentage of traded items that are lemons, illustrating Gresham's Law dynamic where bad items drive out good.

Required Inputs

To use this calculator, you'll need:

• Value of Good Item (V_good) — Buyer's maximum willingness to pay if they knew the item was good quality.
• Value of Lemon (V_lemon) — Buyer's maximum willingness to pay for a known low-quality item.
• Seller Reserve Price – Good (C_good) — The minimum price good sellers will accept. If pooled WTP falls below this, good sellers exit.
• Seller Reserve Price – Lemon (C_lemon) — The floor price for lemon sellers. If even this threshold isn't met, the market collapses entirely.
• Fraction Good (q) — The percentage of market items that are good quality, expressed as common knowledge to all participants.
• Risk Discount (alpha) — Buyer's willingness to pay as a fraction of expected value (50–100%). At 100% the buyer is risk-neutral; lower values reflect risk aversion.
• Number of Sellers (N) — Total sellers in the market, used to calculate items traded and aggregate welfare loss.

Methodology

The model implements the full Akerlof (1970) two-type adverse selection framework with an educational alpha extension for risk aversion. Pooled WTP = alpha × [q × V_good + (1−q) × V_lemon]. Market outcome is determined by comparing WTP against seller reservation prices across all three cases (q=0, q=100, and 0<q<100). All formulas are visible and editable for full audit transparency.

Assumptions

This model assumes:

• Two-type model: items are either good or lemon with no intermediate quality
• Buyers cannot distinguish quality before purchase; sellers know their own item quality
• Single-period model with no signaling, warranties, or reputation effects
• Homogeneous valuations within each buyer and seller type
• Sellers exit entirely when market WTP falls below their reservation price

For educational purposes only. Not financial advice.