Who This Helps
This is for junior analysts who need to ship clean analysis with clear recommendations, not just data dumps. If you're in the Founder Finance Basics Mission Pack, you know the goal: make calm founder decisions. This helps you automate the 'Runway Forecast' mission so you're not stuck manually updating spreadsheets every week.
Mini Case
Ben's revenue was up, but his cash was flat. His old forecast said 9 months of runway. After automating his data flow, he saw the real number was 5 months. He caught a 45% error before his board meeting. That's the power of fresh context.
Do This Now (5 Steps)
- Find your single source of truth for cash, burn, and revenue. This is usually your accounting software or a central spreadsheet.
- Set a weekly 15-minute check to pull the latest numbers. Put it on your calendar right now.
- Use an AI tool to connect to that data source. A simple instruction like "update the runway model with last week's numbers" can do the heavy lifting. No more copy-paste errors.
- Generate the new forecast. The tool should spit out the key figure: your updated months of runway.
- Write one bullet for the change from last week and one clear recommendation. For example: "Runway tightened from 5.2 to 4.8 months. Recommendation: Delay the next marketing hire by one quarter."
Avoid These Traps
- Don't build a beautiful, static slide deck. It's outdated the moment you finish it.
- Don't present data without a clear 'so what.' A number alone isn't analysis.
- Don't mix forecasts with targets. A forecast is your best guess of what will happen, not what you hope will happen.
- Don't ignore small weekly changes. A 0.2-month drop each week adds up to a big problem fast.
- Don't automate bad data first. Garbage in, gospel out—wait, that's not right. Clean your inputs!
- Don't hide uncertainty. If your forecast has a wide range, say so.
- Don't forget to connect runway to a specific decision, like hiring or fundraising.
- Don't do this alone. Show your process to your manager early. It makes you look proactive.
Your Win by Friday
By Friday, you'll have one automated report—your runway forecast—that updates itself. You'll walk into your next check-in with a current number, a clear trend line, and a confident recommendation. You'll have saved 3 hours of manual work and gained trust by providing always-fresh context. That's a quiet win that shouts 'promotion material.'