runway-calculator
Compare original and translation side by side
🇺🇸
Original
English🇨🇳
Translation
ChineseRunway Calculator
Runway 计算器
Overview
概述
Determine how many months your business can operate at its current spending rate before running out of cash. Calculates gross burn, net burn, and runway under multiple scenarios (current, lean, growth).
计算你的企业按照当前支出率运营,在现金耗尽前还能维持多少个月。可计算多种场景(当前、精简、增长)下的总消耗(gross burn)、净消耗(net burn)以及 runway。
Wilson Tools Used
使用的 Wilson 工具
- — calculate average monthly expenses (gross burn) and net burn (expenses minus revenue)
spending_summary - — determine current cash position from recent balance and identify trends in burn rate
transaction_search
- — 计算平均月度支出(总消耗)和净消耗(支出减去收入)
spending_summary - — 根据近期余额确定当前现金状况,并识别消耗率的趋势
transaction_search
Workflow
工作流程
- Ask for the current cash balance (or identify from the most recent account balance).
- Use for the past 3-6 months to calculate:
spending_summary- Gross Burn = average monthly total expenses
- Monthly Revenue = average monthly total income
- Net Burn = Gross Burn - Monthly Revenue
- Use to check if burn is trending up or down (compare last 3 months vs prior 3 months).
transaction_search - Calculate runway under three scenarios:
RUNWAY ANALYSIS — as of [Date]
═══════════════════════════════════════════════
Current Cash Balance $150,000
Current Lean (-20%) Growth (+30%)
───────────────────────────────────────────────────────────
Gross Burn/mo $25,000 $20,000 $32,500
Monthly Revenue $15,000 $15,000 $15,000
Net Burn/mo $10,000 $5,000 $17,500
Runway (months) 15.0 30.0 8.6
Cash-Out Date Jul 2027 Oct 2028 Jan 2027
═══════════════════════════════════════════════════════════
Burn Trend: +8% over past 3 months ⚠- Runway = Cash Balance / Net Burn (monthly).
- Cash-Out Date = Today + (Runway * 30 days).
- Flag warning levels:
- Green: 12+ months runway
- Yellow: 6-12 months runway
- Red: Under 6 months runway
- If net burn is negative (revenue exceeds expenses), report as "Profitable — infinite runway" and show monthly cash accumulation instead.
- 获取当前现金余额(或从最新账户余额中识别)。
- 使用分析过去3-6个月的数据,计算:
spending_summary- 总消耗(Gross Burn)= 月度总支出平均值
- 月度收入(Monthly Revenue)= 月度总收入平均值
- 净消耗(Net Burn)= 总消耗 - 月度收入
- 使用检查消耗率是上升还是下降趋势(对比最近3个月与之前3个月的数据)。
transaction_search - 计算三种场景下的 runway:
RUNWAY ANALYSIS — as of [Date]
═══════════════════════════════════════════════
Current Cash Balance $150,000
Current Lean (-20%) Growth (+30%)
───────────────────────────────────────────────────────────
Gross Burn/mo $25,000 $20,000 $32,500
Monthly Revenue $15,000 $15,000 $15,000
Net Burn/mo $10,000 $5,000 $17,500
Runway (months) 15.0 30.0 8.6
Cash-Out Date Jul 2027 Oct 2028 Jan 2027
═══════════════════════════════════════════════════════════
Burn Trend: +8% over past 3 months ⚠- Runway = 现金余额 / 月度净消耗。
- 现金耗尽日期(Cash-Out Date)= 今日 + (Runway * 30天)。
- 标记预警等级:
- 绿色:12个月及以上的 runway
- 黄色:6-12个月的 runway
- 红色:不足6个月的 runway
- 如果净消耗为负数(收入超过支出),则报告为“盈利——无限 runway”,并显示月度现金积累情况。
Without Wilson
不使用 Wilson 的操作步骤
- Check your current bank balance across all business accounts.
- Export the last 6 months of transactions as CSV.
- In a spreadsheet, add a column:
Month.=TEXT(Date,"YYYY-MM") - Pivot table: Rows = Month, Values = Sum of expenses (negative amounts), Sum of income (positive amounts).
- Gross Burn = (use absolute values).
=AVERAGE(MonthlyExpenses) - Avg Revenue = .
=AVERAGE(MonthlyIncome) - Net Burn = .
=GrossBurn - AvgRevenue - Runway = . Cash-Out Date =
=CashBalance/NetBurn.=TODAY()+(Runway*30) - For the lean scenario, multiply expenses by 0.8. For growth, multiply by 1.3.
- Track this monthly in a running spreadsheet. Plot cash balance over time to visualize the glide path.
- 查看所有企业账户的当前银行余额。
- 将过去6个月的交易记录导出为CSV文件。
- 在电子表格中添加列:
Month。=TEXT(Date,"YYYY-MM") - 创建数据透视表:行=月份,值=支出总和(负数金额)、收入总和(正数金额)。
- 总消耗 = (使用绝对值)。
=AVERAGE(MonthlyExpenses) - 平均收入 = 。
=AVERAGE(MonthlyIncome) - 净消耗 = 。
=GrossBurn - AvgRevenue - Runway = 。现金耗尽日期 =
=CashBalance/NetBurn。=TODAY()+(Runway*30) - 对于精简场景,将支出乘以0.8;对于增长场景,乘以1.3。
- 在持续更新的电子表格中每月跟踪此数据。绘制现金余额随时间变化的图表,以可视化资金消耗轨迹。
Important Notes
重要说明
- Runway assumes constant burn and revenue. In reality, both fluctuate. Use the 3-month average to smooth noise, but watch the trend.
- Include all cash: checking, savings, money market. Exclude receivables unless collection is near-certain.
- For startups raising funding: investors want to see 18+ months of runway after their investment. Calculate post-raise runway as (Current Cash + Investment) / Net Burn.
- Net burn is what matters, not gross burn. A company spending $50K/month but earning $45K/month has a $5K net burn and 30 months of runway on $150K cash.
- Runway的计算基于消耗和收入恒定的假设,但实际中两者都会波动。使用3个月平均值来平滑波动,但需关注趋势。
- 需包含所有现金:支票账户、储蓄账户、货币市场账户。除非收款几乎确定,否则不要计入应收账款。
- 对于正在融资的初创企业:投资者希望看到投资后有18个月以上的 runway。融资后的runway计算公式为(当前现金 + 投资金额)/ 净消耗。
- 关键指标是净消耗而非总消耗。一家每月支出5万美元但收入4.5万美元的公司,净消耗为5000美元,15万美元现金可支撑30个月的runway。