Who This Helps
This is for junior analysts who want to stop copy-pasting numbers and start shipping clear recommendations. You're busy, your data changes fast, and your founder needs a calm answer by Friday.
Mini Case
Meet Ben. He runs a startup where revenue is up 20% but cash is flat. He needs a one-page unit economics truth. You run the numbers: your gross margin is 65%, but your CAC payback period is 14 months. That's too long. Ben needs a decision, not a spreadsheet.
Do This Now (5 Steps)
- Pull your last 3 months of revenue and cost data. Focus on gross margin and customer acquisition cost.
- Calculate your CAC payback period. Divide total sales and marketing spend by number of new customers, then divide by monthly gross profit per customer.
- Use AI to summarize the trend. Ask your AI tool: "Compare this month's CAC payback to last quarter. Highlight any red flags." This saves you 30 minutes of manual charting.
- Write one recommendation. Example: "Reduce spend on Channel A because its payback is 18 months."
- Share a one-pager with Ben. Include your unit economics snapshot card and a clear next step.
Avoid These Traps
- Don't report every number. Focus on the 3 metrics that matter: gross margin, CAC payback, and runway.
- Don't wait for perfect data. Use your best estimate and note assumptions.
- Don't skip the recommendation. Ben doesn't want a data dump; he wants a decision.
- Don't forget to update your report weekly. A stale number is worse than no number.
- Don't use jargon like "cohort analysis" without explaining it in plain English.
- Don't ignore cash. Revenue is great, but cash is oxygen.
- Don't overcomplicate the one-pager. One page, three sections: problem, data, action.
- Don't assume Ben knows unit economics. Add a short definition at the top.
Your Win by Friday
By Friday, you'll have a clean one-page report that Ben can use to make a calm decision. You'll reduce your manual update time by 40% using AI to spot trends. And you'll ship a recommendation, not just a spreadsheet. That's a win for you, and a win for the company.