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