Hardware founders burn cash in lumps: tooling, inventory, certifications, test events, and a team that has to stay together between awards. A SaaS-style runway spreadsheet misses those pulses. This kit is a 15-tab Excel workbook built for hardware, deep tech and defense startups that need a CFO-grade cash picture without hiring one yet.
You get a working 36-month cash and runway model, not a blank template. Opening balances, payroll and headcount, inventory and tooling outflows, grant and customer inflows, and a runway readout that updates as you change assumptions. Tabs are linked with live formulas. A Checks tab runs dozens of tie-outs and input validations with a single master pass/fail before you send the file to an investor or a contracting officer.
What is inside:
• 13-week and monthly cash views so near-term survival and longer raise timing sit in one file, plus a Board Cash Page summary
• Runway in months, with Base / Downside / Upside scenario levers and stress toggles for revenue delay, capex overrun and hiring freeze, plus a runway sensitivity grid
• Hardware-aware cost lines: BOM cost per unit (or percent-of-revenue COGS), inventory safety-stock timing, Capex categories for tooling and test equipment, and opex lines for test, certification and compliance
• Financing inputs for equity, debt, equipment loan, AR revolver, SBIR-style grant tranches and customer prepayments
• A 13-prompt AI prompt pack that maps bank exports, headcount, POs and term sheets into the yellow input cells and helps explain board, lender and investor views—without rewriting the model
Who it is for:
• Pre-seed to Series A hardware and deep-tech founders
• Defense suppliers planning around grant and milestone cash timing
• Operators who already know their BOM and burn, and need the cash story in one place
How to use it:
Open the workbook, replace the sample figures with your own opening cash, burn and expected inflows, then read the 13-Week Cash, 36-Month Runway and Board Cash Page. Use the prompt pack when you want help filling inputs or stress-testing a hire plan or a tooling deposit. Every number in the sample walkthrough is invented; your live numbers replace them.
What this is not:
It is not tax, legal or investment advice. It is not a substitute for your accountant or a negotiated indirect rate. It is a working model you own and edit.
File format: Excel (.xlsx), standard formulas only, no macros. Same product family as the Breeze CFO Hardware Runway Kit sold on Gumroad and Etsy at $59.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Entrepreneurship, Cash Flow Management Excel: Hardware Runway and Cash Forecast Kit for Startups Excel (XLSX) Spreadsheet, Breeze CFO