# Prompt 04 — NotebookLM Meta Prompt: Shortcut.ai Financial Pro Forma

**Paste into:** NotebookLM (https://notebooklm.google.com), with your business plan sources loaded.
**Use NotebookLM's output in:** Shortcut.ai (https://shortcut.ai/shortcut) — paste into a new Shortcut workbook prompt. (If a plan is required, use code **MIT** for free access.)

---

You are an expert prompt engineer for Shortcut AI, an AI spreadsheet tool. The role you will assign in the Shortcut prompt is a top-1% startup financial modeler trained in the 24 Steps of Disciplined Entrepreneurship.

Read every source attached to this notebook — these are the outputs from the 24 Steps. Generate the single best possible prompt I can paste into Shortcut.ai to build a five-year financial pro forma.

The Shortcut prompt you produce must require these tabs at the bottom of the workbook, in this order:

1. **Assumptions** — every driver in one place, with units, source notes, and a sensitivity row (low / base / high)
2. **Sales Plan** — monthly granularity for 60 months rolling up to annual; pipeline → bookings → revenue waterfall
3. **COGS** — variable cost per unit / per customer, gross margin calculation, scaling logic
4. **Staffing Plan** — hires by role and quarter, fully loaded cost, ramped productivity
5. **OpEx** — sales & marketing, R&D, G&A, broken out monthly
6. **CapEx** — one-time spend, depreciation schedule

The Shortcut prompt must explicitly instruct Shortcut to ground every assumption in the following named steps from my business plan sources:

- **Step 8 — Quantify Value Proposition** sets price defensibility and willingness to pay
- **Step 13 — Map Customer Acquisition Process** sets funnel stages and conversion rates
- **Step 15 — Design Business Model** sets the revenue structure (subscription, transactional, hybrid, services attach)
- **Step 16 — Pricing Framework** sets unit price, tiers, and expansion levers
- **Step 17 — LTV (Life-Time Value)** sets retention curve, churn, and net revenue retention
- **Step 18 — Map Sales Process** sets sales cycle length and quota capacity per rep
- **Step 19 — COCA (Cost of Customer Acquisition)** sets blended CAC, payback period, and S&M efficiency

The Shortcut prompt must also specify:

- Formulas explicitly (do not let Shortcut invent them) — for example `Revenue = New Customers × ARPA × (1 − Churn)`
- Monthly granularity that rolls up to annual columns at the right edge of each tab
- Charts on Sales Plan (bookings vs. revenue) and Assumptions (LTV / COCA ratio over time)
- Units in every cell label (USD, %, count, months)
- Sensitivity rows on every key assumption so we can stress-test price, CAC, and churn

Output only the final, ready-to-paste prompt for Shortcut.ai. No preamble. No explanation.