# 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 sheets 4 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?