← Back to library
Mental ModelsOpen4 min read

Turn a Spreadsheet Into a Yes: The Narrative Constructor

You have the numbers but investors, lenders, and clients keep saying maybe. A 5-step recipe plus a paste-ready prompt that turns raw evidence into a story that closes.


The stuck moment. You are raising $600K for your third small multifamily deal. The underwriting is tight: purchase price, rehab budget, rent comps, a 7.4% cash-on-cash return. You email the package to twelve past investors and get two soft maybes. The data is complete. The story is missing, so nobody feels why this deal, why now, why you.

The recipe: Narrative Constructor.

  1. Name the one decision. Write a single sentence: "I need [this audience] to [this action] by [this date]." If you cannot fill all three blanks, the problem is upstream of the story.
  2. Find the tension. Every story runs on a gap. What does your audience gain by acting, and what does waiting cost them? Write both in plain language.
  3. Turn data points into proof beats. Arrange the evidence in this order: situation, problem, stakes, solution, ask. Each number now supports a beat instead of sitting in a table.
  4. Cut to three numbers. Keep only the figures that move the decision. Everything else goes in an appendix they can request.
  5. Run the repeat test. Tell it to someone in 90 seconds. If they cannot repeat your point in one sentence, tighten the tension and cut again.

The AI move. Paste this into Claude or ChatGPT and fill the brackets:

You are a communications strategist who turns business data into decision-driving narratives for skeptical audiences.

Context: I am [your role, e.g. a real-estate investor raising $600K from past investors]. My audience is [who] and I need them to [specific action] by [date]. Here is my evidence in raw form: [paste your numbers, facts, and data points].

Task: Build a narrative from this evidence. First, state the core tension in one sentence: what my audience gains by acting and loses by waiting. Then arrange the evidence into five beats: situation, problem, stakes, solution, ask. Pick the three numbers that most move the decision and flag which data to cut or move to an appendix. Finish with a 90-second spoken version I can deliver on a call.

Format: (1) the tension sentence, (2) the five beats, each 2-3 sentences with its supporting evidence named, (3) the three keeper numbers with one line on why each earns its place, (4) the 90-second script in plain spoken language.

Constraints: No hype words. Write like a smart friend explaining over coffee. Do not invent numbers or facts I did not give you. If my evidence has a gap that weakens a beat, tell me instead of papering over it.

What it's worth: The gap between two maybes and a funded raise. Same data, ordered as a story, is often the difference between 60 days of chasing and a closed round.