Excel for Startup Founders: Runway, Unit Economics, Cap Table & Investor Updates
20 hands-on labs for first-time founders: runway and burn, a 12-month forecast, CAC, LTV and payback, pricing tiers, a hiring plan, a seed-round cap table, use of funds, MRR growth, cohort retention, budget vs actual, break-even and an investor update dashboard, then an MRR bridge with a waterfall chart, a bank ledger summarised with SUMIFS, annual prepaid plans and deferred revenue, a price increase test, burn multiple and magic number, a scenario switch for the cash plan, the Series A option pool shuffle and a final board pack dashboard, every cell checked instantly.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This course teaches first-time founders the spreadsheet work behind a startup in 20 interactive labs, all built around one fictional software company. You calculate burn and runway, a 12-month forecast, CAC, LTV and payback, pricing tiers, a hiring plan, a seed-round cap table, use of funds, MRR growth, cohort retention, budget vs actual, break-even and an investor update. The second half goes deeper: an MRR bridge with new, expansion, contraction and churned MRR as a waterfall chart, a bank ledger turned into a budget table with SUMIFS, annual prepaid plans with deferred revenue, a price increase with break-even churn, burn multiple and magic number by quarter, a Lean–Base–Growth scenario switch for an 18-month cash plan, the Series A option pool shuffle and a final board pack dashboard. Fictional data, not financial or legal advice.
Lessons
- Runway and Burn: How Many Months of Cash Are Left?Free
- A Simple 12-Month Forecast: Growth Rate, Costs and the Gap Locked
- Unit Economics: CAC, LTV and Payback for One Customer Locked
- Pricing Tiers: MRR per Plan, ARPA and an Annual Price Locked
- Hiring Plan: What Four New People Really Cost Next Year Locked
- Cap Table: Price per Share and Dilution After a Seed Round Locked
- Use of Funds: Turning the Raise into a Budget and a Chart Locked
- MRR Growth: Month-over-Month, CMGR and the Best Months Locked
- Cohort Retention Basics: Who Is Still a Customer After 3 Months? Locked
- Budget vs Actual: The Monthly Check Before the Board Meeting Locked
- Break-Even Customers: Are We Default Alive? Locked
- Investor Update Dashboard: KPIs, Changes, Chart and Highlights Locked
- MRR Bridge: New, Expansion, Contraction, Churn and a Waterfall Chart Locked
- From Bank Ledger to Budget Lines: SUMIFS by Category and Month Locked
- Annual Prepaid Plans: Cash Collected, Revenue Recognised and Deferred Revenue Locked
- Raising Prices: New MRR, Customers Kept and the Break-Even Loss Locked
- Capital Efficiency: Burn Multiple and Magic Number by Quarter Locked
- Lean, Base or Growth: A Scenario Switch for the 18-Month Cash Plan Locked
- The Option Pool Shuffle: Series A Price per Share and Founder Dilution Locked
- Final Project: Half-Year Board Pack Dashboard Locked
Learner reviews
Be the first to review this course.