Spreadsheet Template & Formula Hub
Runway Calculator Excel Template
Download a ready-to-use 24-month financial runway projection model pre-filled with your customized numbers, native Excel formulas, and cash depletion indicators.
Excel Financial Model Parameters
Native Excel / Google Sheets Formulas
// Cell B2: Cash | Cell B3: Revenue | Cell B4: Expenses
=IF((B4-B3)<=0, "Sustainable", B2/(B4-B3))
Copy this formula directly into cell B5 in your Excel sheet to calculate static runway months.
Live Generated Model Preview (First 4 Months)24-month full export
| Month | Start Cash | Revenue | Expenses | End Cash |
|---|---|---|---|---|
| Month 1 | $100,000 | $20,000 | $35,000 | $85,000 |
| Month 2 | $85,000 | $21,000 | $35,700 | $70,000 |
| Month 3 | $70,000 | $22,050 | $36,414 | $55,000 |
| Month 4 | $55,000 | $23,153 | $37,142 | $40,000 |
Related Financial Calculators
Explore more precision calculators to streamline your planning.
Cash Runway Calculatorfinancial
Calculate cash survival months with customizable emergency reserve buffers.
Open Calculator
Startup Runway Calculatorfinancial
Model venture capital burn, fundraising timing, and milestone runway.
Open Calculator
Burn Rate Calculatorfinancial
Measure gross burn, net burn, and SaaS capital efficiency Burn Multiple.
Open Calculator
Hiring Runway Calculatorfinancial
Model headcount salary additions and benefits overhead on runway months.
Open Calculator
Runway Excel Frequently Asked Questions
Everything you need to know about cash runway, burn rates, and financial planning.
In Microsoft Excel or Google Sheets, the formula is: =IF((B4-B3)<=0, "Sustainable", B2/(B4-B3)), where B2 is your Cash Balance, B3 is Monthly Revenue, and B4 is Monthly Expenses.