Inside the Runway Tool

Welcome to the new site. Problems, use store.hemrock.com

Inside the Runway Tool

Sheet-by-sheet reference: every input, formula, and output. Use this to scan the model before purchase, or as a cell-level reference when editing with AI.

11 sheets4 sections

How to read this

Cells are referenced by R<row>/<column><row> notation. R9/E9 means column E, row 9. R38–R45 is a block of inputs spanning those rows. Multi-column ranges like D39–J39 mean the same row across several columns. Types: INPUT = user-edited, FORMULA = calculated, DROPDOWN = select from list.

Runway Tool — Sheet Map

Sheets

README, License, Disclaimer, Get Started, Summary, Key Reports, Forecast, Sources & Uses, Statements, Glossary, Changelog

Get Started Sheet (B1:G77)

Section: Model Structure (R6-R14)

Row Label Type Default Notes
R9 Company Name INPUT "Company" Used in Disclaimer
R10 Base Timescale INPUT/DROPDOWN "monthly" monthly/quarterly/annually
R11 # of months in model INPUT 36 Sets total periods
R12 Date of first period INPUT (date) Jan 2026 End date of first period
R13 Fiscal year end INPUT (date) Dec 2026 End of fiscal year
R14 Relative or absolute dates INPUT/DROPDOWN "relative"

Section: Balance Sheet (R17-R49)

Row Label Type Default Notes
R20 Cash on hand, beginning INPUT ($) 0 Col C = currency symbol
R23 Use auto revenue recognition DROPDOWN "yes"
R24 Deferred revenue start month INPUT (#) 1
R27 Use auto cash collection DROPDOWN "yes"
R28 Days Accounts Receivable INPUT (#) 0
R31 Prepaid Expenses % of SG&A INPUT (%) 0
R32 Accounts Payable % of SG&A INPUT (%) 0
R33 Accrued Liabilities % of SG&A INPUT (%) 0
R36 Depreciation straight-line months INPUT (#) 36
R39 Corporate Income Tax rate INPUT (%) 21%
R40 Tax payment schedule DROPDOWN "quarterly"
R41 VAT rate INPUT (%) 0
R42 VAT payment schedule DROPDOWN "quarterly"
R45 Inventory lead time months INPUT (#) 0
R46 Safety stock % of COGS INPUT (%) 0
R47 Minimum order quantity ($) INPUT ($) 0
R48 % paid at purchase INPUT (%) 100%
R49 Remaining paid N days later INPUT (#) 0

Section: Seasonality (R52-R67)

Row Label Type Default
R55-R66 January-December % change INPUT (%) 0 each
R67 Estimated impact (should = 0) FORMULA

Section: Model Checks (R70-R77)

All FORMULA — returns yes/no:

  • R73: Balance sheet balances?
  • R74: Cash stays above zero?
  • R75: Deferred revenues positive?
  • R76: Inventory positive?
  • R77: PP&E positive?

Forecast Sheet (B1:columns through 36+ periods)

Driver System (columns K-U per row)

Column Purpose
K Initial Value (INPUT)
L Starts in period # (INPUT)
M Repeats every N months (INPUT)
N Changing based on (DROPDOWN)
O Changes every N months (INPUT)
P Changing by % or # (INPUT)

Row Map

Row Label Type Notes
R5-R11 Timescale header FORMULA Period, date, FY, seasonality
R18 Fundraising section
R19 Equity Investment INPUT Default: $500k SAFE in month 1
R20-R21 Additional funding rows INPUT TBD
R23 Revenues section
R24 First revenue stream INPUT via drivers Default: $5k starting month 1
R25 Subscribers (metric) INPUT via drivers Default: 100, 5% monthly growth
R26 Second revenue stream INPUT via drivers Uses # per subscriber
R27-R28 Additional revenue rows INPUT TBD
R30 Expenses section
R31 R&D INPUT via drivers
R32 Sales & Marketing INPUT via drivers
R33 G&A INPUT via drivers
R34 Misc SG&A INPUT via drivers
R35 Cost of Sales INPUT via drivers
R36-R48 Additional expense rows INPUT TBD, insert above R49
R49 "Insert new rows above" marker
R52 Totals by Category FORMULA
R55-R80 Category aggregations FORMULA Subscribers, GTV, Bookings, Billings, Revenue by stream, SG&A by category, COGS, CAPEX, D&A, Interest, Other, Taxes

Statements Sheet

All FORMULA. Monthly financial statements:

  • R10-R38: Income Statement (Revenue → COGS → Gross Margin → SG&A → EBITDA → D&A → Interest → EBT → Taxes → Net Income)
  • R41-R80: Balance Sheet (Assets, Liabilities, Equity)
  • R83+: Cash Flow Statement

Summary Sheet

All FORMULA. Annual rollup (3 years):

  • Income Statement, Cash Flows, Balance Sheet

Ready to put this to work?

View the Runway Tool