Financial Model
Financial Model
Configure pricing, COGS, and deployment schedules for each product
This product is disabled. Enable it above to configure pricing and deployments.
Annual inflation/growth rates applied to costs and pricing. These compound year-over-year starting from the start year.
Operating expenses for office/manufacturing space
Equipment purchases with depreciation
No equipment added yet
| Role | Department | Salary | Benefits % | COGS % | Start Date | |
|---|---|---|---|---|---|---|
$ |
| Role | Department | Salary | Benefits % | COGS % | Start Date | |
|---|---|---|---|---|---|---|
$ |
| Role | Department | Monthly Cost | COGS % | Start Date | |
|---|---|---|---|---|---|
$ |
Automatic hiring rules based on business metrics. The model will add headcount when thresholds are crossed.
Based on your robot deployment schedule, these hires will be triggered:
| Actuals | |
|---|---|
| Category | |
| Hardware R&D | |
| Software | |
| Actuals | |
|---|---|
| Category | |
| Marketing | |
| Travel | |
| Actuals | |
|---|---|
| Category | |
| Utilities | |
| Internet | |
| Office | |
| Legal | |
| Accounting | |
| Insurance | |
When the model begins (cash starts at $0)
Last year of projections
Use QuickBooks data for historical months
Sum of all funding rounds
Historical expenses from QuickBooks
Cash inflows from investments. If no funding, business goes negative.
No funding configured
Without funding, cash will go negative as expenses accumulate
Edit assumptions to generate results automatically
| Product | 3-Year Total | |
|---|---|---|
| Robot | ||
| Cart | ||
| Consumables | ||
| Fleet Software | ||
| Machine Tending | ||
| Total Revenue |
Operating expenses by category - compare with QuickBooks P&L
| Category | Total | |
|---|---|---|
| Cost of Goods Sold | ||
| R&D | ||
| Sales & Marketing | ||
| G&A | ||
| Total OpEx | ||
| Total Expenses (COGS + OpEx) |
| Year | Revenue | Gross Profit | Gross Margin | EBITDA | Units | ARR | Headcount | Ending Cash |
|---|---|---|---|---|---|---|---|---|
Import your historical P&L data. Export "Profit and Loss by Month" as CSV from your accounting system, then upload here.
To download an Excel file with the full model output, go to the tab and click "Download Excel".