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 |
navigation.financialTools
Explore more precision calculators to streamline your planning.
financialTools.cashRunwayfinancial
financialTools.cashRunwayDesc
common.launchTool
financialTools.startupRunwayfinancial
financialTools.startupRunwayDesc
common.launchTool
financialTools.burnRatefinancial
financialTools.burnRateDesc
common.launchTool
financialTools.hiringRunwayfinancial
financialTools.hiringRunwayDesc
common.launchTool
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.