Knowledge Base
How to Build a P&L Model from Scratch
A detailed guide to creating a financial model — from product parameters to a finished dashboard with key metrics.
1. Product Parameters
Start with the "General" tab: set the forecast horizon (12–36 months), start and launch dates, activation rate (what share of new customers become active) and churn rate (how many customers leave per month). If your product has pricing tiers — enable the tier grid.
2. Acquisition Channels
Go to "Channels": create groups (e.g., Digital Ads, Organic, Referral) and add subchannels. For each, set reach, funnel conversions (impressions → clicks → installs → sales), payment model and lifecycle (ramp-up, decay). More details in the "Channels Setup" guide.
3. Revenue
On the "Revenue" tab, add income streams. Four types: per new customer (one-time), per active customer (monthly), periodic (fixed amount), and percentage of base (e.g., of turnover). Set active months — revenue is calculated only for selected periods.
4. Expenses
"Operations" tab: add operational expenses. Same four calculation types. Typical items: server infrastructure, licenses, support, office. Don't forget variable costs that grow with the customer base.
5. Team
"Team" tab: create domains (departments) and teams. Add members with roles, salaries and allocation percentages. Set active months — developers usually from month 0, marketing closer to launch.
6. Partners
If you have partner payments (revenue share, bounty) — configure them on the "Partners" tab. Each rule is tied to a calculation base: revenue, turnover, customer count or fixed amount.
7. Review Results
Go to the dashboard — all metrics are calculated automatically. Pay attention to LTV/CAC (target > 3), breakeven month, NPV and Cash Runway. If the numbers don't look right — go back to channels or expenses and experiment with parameters.