Build three to five year startup financial projections covering revenue, expenses, hiring, and cash flow. Compare conservative, base, and optimistic scenarios to estimate funding needs and runway, the time remaining before cash runs out.
中文简介正在准备中。当前显示英语简介。
This skill should be used when the user asks to "create financial projections", "build a financial model", "forecast revenue", "calculate burn rate", "estimate runway", "model cash flow", or requests 3-5 year financial planning for a startup.
安装前可以查看交给 AI 代理的指令内容。
Build comprehensive 3-5 year financial models with revenue projections, cost structures, cash flow analysis, and scenario planning for early-stage startups.
Financial modeling provides the quantitative foundation for startup strategy, fundraising, and operational planning. Create realistic projections using cohort-based revenue modeling, detailed cost structures, and scenario analysis to support decision-making and investor presentations.
Cohort-Based Projections: Build revenue from customer acquisition and retention by cohort.
Formula:
MRR = Σ (Cohort Size × Retention Rate × ARPU)
ARR = MRR × 12
Key Inputs:
Operating Expenses Categories:
Cost of Goods Sold (COGS)
Sales & Marketing (S&M)
Research & Development (R&D)
General & Administrative (G&A)
Components:
Formula:
Runway = Current Cash Balance / Monthly Burn Rate
Monthly Burn = Monthly Revenue - Monthly Expenses
Role-Based Hiring Plan: Track headcount by department and role.
Key Metrics:
Typical Ratios (Early-Stage SaaS):
Conservative Scenario (P10):
Base Scenario (P50):
Optimistic Scenario (P90):
Detailed Projections: 3 Years
High-Level Projections: Years 4-5
Clarify revenue model and pricing.
SaaS Model:
Marketplace Model:
Transactional Model:
Use cohort-based methodology for accuracy.
Monthly Customer Acquisition: Define new customers acquired each month.
Retention Curve: Model customer retention over time.
Typical SaaS Retention:
Revenue Calculation: For each cohort, calculate retained customers × ARPU for each month.
Break down costs by category and behavior.
Fixed vs. Variable:
Scaling Assumptions:
Model headcount growth by role and department.
Inputs:
Example:
Engineer: $150K salary × 1.35 = $202K fully-loaded
Sales Rep: $100K OTE × 1.30 = $130K fully-loaded
Calculate monthly cash position and runway.
Monthly Cash Flow:
Beginning Cash
+ Revenue Collected (consider payment terms)
- Operating Expenses Paid
- CapEx
= Ending Cash
Runway Calculation:
If Ending Cash < 0:
Funding Need = Negative Cash Balance
Runway = 0
Else:
Runway = Ending Cash / Average Monthly Burn
Track metrics that matter for stage.
Revenue Metrics:
Unit Economics:
Efficiency Metrics:
Cash Metrics:
Create three scenarios with different assumptions.
Variable Assumptions:
Fixed Assumptions:
Revenue Drivers:
Key Ratios:
Example Projection:
Year 1: $500K ARR, 50 customers, $100K MRR by Dec
Year 2: $2.5M ARR, 200 customers, $208K MRR by Dec
Year 3: $8M ARR, 600 customers, $667K MRR by Dec
Revenue Drivers:
Key Ratios:
Example Projection:
Year 1: $5M GMV, 15% take rate = $750K revenue
Year 2: $20M GMV, 15% take rate = $3M revenue
Year 3: $60M GMV, 15% take rate = $9M revenue
Revenue Drivers:
Key Ratios:
Revenue Drivers:
Key Ratios:
Pre-Money Valuation: Based on metrics and comparables.
Dilution:
Post-Money = Pre-Money + Investment
Dilution % = Investment / Post-Money
Use of Funds: Allocate funding to extend runway and achieve milestones.
Example:
Raise: $5M at $20M pre-money
Post-Money: $25M
Dilution: 20%
Use of Funds:
- Product Development: $2M (40%)
- Sales & Marketing: $2M (40%)
- G&A and Operations: $0.5M (10%)
- Working Capital: $0.5M (10%)
Identify Key Milestones:
Funding Amount: Ensure runway to achieve next milestone + 6 months buffer.
Pitfall 1: Overly Optimistic Revenue
Pitfall 2: Underestimating Costs
Pitfall 3: Ignoring Cash Flow Timing
Pitfall 4: Static Headcount
Pitfall 5: Not Scenario Planning
Sanity Checks:
Benchmark Against Peers: Compare key metrics to similar companies at similar stage.
Investor Feedback: Share model with advisors or investors for feedback on assumptions.
This skill provides formulas and model outlines in the sections above; it does not bundle complete spreadsheet models.
Build the model from the user's inputs, label assumptions, and check the formulas before presenting projections.
To create a startup financial model:
Use the guidance above to build and validate a model for the specific business.
还没有评价。欢迎分享你的使用感受。
无需登录即可发表。欢迎分享使用感受、提问，或说明在哪些环境下无法运行。
还没有评论。来写第一条吧。
Automate website tasks with agent-browser, a command-line browser tool for AI agents. Fill forms, click controls, extract page text, capture screenshots, and test web apps, with support for saving and reusing login state.
中文简介正在准备中。当前显示英语简介。
Review Python, FastAPI, and React code for security weaknesses in access checks, input handling, secrets, and dependencies. Produce a report with severity levels, file locations, explanations, and recommended fixes, supported by scanning patterns.
中文简介正在准备中。当前显示英语简介。
Create a series of personalized sales emails for new prospects or older leads. Get message drafts, subject line alternatives to compare, recommended sending intervals, and ways to include customer results and clear meeting requests.
中文简介正在准备中。当前显示英语简介。
Plan user communities that support customer acquisition, retention, and expanded use. Develop ambassador programs, user groups, and community content, then assess meaningful participation, customer advocacy, and business impact rather than relying on membership counts alone.
中文简介正在准备中。当前显示英语简介。
Research competitors’ features, pricing, messaging, and customer complaints to produce comparison tables and an actionable report. Identify underserved needs, clarify how an offering differs, and plan regular monitoring of competitor changes.
中文简介正在准备中。当前显示英语简介。
Plan content using customer questions, keyword data, and competitor coverage. Organize core themes and related articles, match topics to buying stages, and rank ideas by customer impact, product relevance, search potential, and production needs.
中文简介正在准备中。当前显示英语简介。