CODITECT Financial Model - Assumptions Registry
Overview
This document catalogs all assumptions embedded in the CODITECT financial model. Each assumption is categorized by type, with current values, dependencies, and validation notes.
1. PRICING ASSUMPTIONS
1.1 Base Pricing
| ID | Parameter | Value | Rationale |
|---|---|---|---|
| P-01 | Individual Price | $15/month | Competitive with GitHub Copilot, Cursor |
| P-02 | Team Price | $250/month | ~10 seats × $25/seat implied |
| P-03 | Enterprise Price | $1,300/month | ~20 seats × $65/seat implied |
1.2 Discount Structure
| ID | Parameter | Value | Rationale |
|---|---|---|---|
| P-04 | Annual Discount | 20% | Industry standard SaaS discount |
| P-05 | % Customers on Annual | 30% | Conservative; enterprise skews higher |
1.3 Pricing Risks
- Downside: Market commoditization could force 30-40% price cuts
- Upside: Value-based pricing for enterprise could support 2x premium
- Validation: Compare against Cursor Pro ($20), GitHub Copilot Business ($19)
2. GROWTH ASSUMPTIONS
2.1 Customer Acquisition
| ID | Parameter | Value | Period | Notes |
|---|---|---|---|---|
| G-01 | Starting Customers | 0 | Month 0 | Pre-launch |
| G-02 | Month 1 Customers | 10 | Month 1 | Beta users/founders network |
| G-03 | Early Growth Rate | 250% | Months 1-3 | Viral PLG assumption |
| G-04 | Seed Growth Rate | 150% | Months 4-6 | Post-angel marketing |
| G-05 | Scaling Growth Rate | 100% | Months 7-10 | Channel maturity |
| G-06 | Maturing Growth Rate | 50% | Months 11-15 | Market penetration |
| G-07 | Steady Growth Rate | 40% | Months 16-21 | Sustainable growth |
| G-08 | Late Growth Rate | 30% | Months 21-30 | Market saturation |
| G-09 | Mature Growth Rate | 25% | Month 31+ | Long-term steady state |
2.2 Growth Model Dependencies
Customer[t+1] = Customer[t] × (1 + Growth Rate) - Churn
Net Growth = New Customers - Churned Customers
2.3 Growth Risks
- Downside: 50% slower growth if PLG doesn't work → 18-month cash crunch
- Upside: Enterprise contracts could 2x growth rates
- Validation: Compare against Linear, Notion early growth (100-200% MoM)
3. CUSTOMER MIX ASSUMPTIONS
3.1 Segment Distribution
| ID | Parameter | Individual | Team | Enterprise |
|---|---|---|---|---|
| M-01 | Month 1 Mix | 50% | 40% | 10% |
| M-02 | Month 12 Mix | 80% | 16% | 4% |
| M-03 | Month 24 Mix | 75% | 20% | 5% |
| M-04 | Month 36+ Mix | 70% | Variable | Variable |
3.2 Mix Evolution Logic
- Individual grows fastest initially (PLG)
- Team/Enterprise require sales motion
- Mix stabilizes as enterprise sales mature
3.3 Mix Risks
- Downside: 90% individual = lower ARPU, higher churn
- Upside: 30% enterprise = 3x ARPU, better retention
4. CHURN ASSUMPTIONS
4.1 Initial Churn Rates
| ID | Tier | Monthly Churn | Implied Retention |
|---|---|---|---|
| C-01 | Individual | 33.33% | 3 months |
| C-02 | Team | 16.67% | 6 months |
| C-03 | Enterprise | 10.00% | 10 months |
4.2 Improved Churn (Month 24+)
| ID | Tier | Improved Churn | Improved Retention |
|---|---|---|---|
| C-04 | Individual | 20.00% | 5 months |
| C-05 | Team | 12.50% | 8 months |
| C-06 | Enterprise | 10.00% | 10 months (no change) |
4.3 Churn Assumptions Rationale
- Initial high churn reflects product-market fit discovery
- Improvement assumes feature maturity, stickiness
- Enterprise stability reflects contract obligations
4.4 Churn Risks
- Downside: 50% individual churn = negative unit economics
- Upside: 10% individual churn = 10x LTV improvement
5. CUSTOMER ACQUISITION COST (CAC)
5.1 CAC by Segment
| ID | Tier | CAC | CAC/Price Ratio |
|---|---|---|---|
| CAC-01 | Individual | $10 | 0.67x monthly |
| CAC-02 | Team | $200 | 0.80x monthly |
| CAC-03 | Enterprise | $1,000 | 0.77x monthly |
5.2 CAC Assumptions
- Individual: Pure PLG, minimal paid acquisition
- Team: Content marketing + freemium conversion
- Enterprise: Outbound sales + account management
5.3 CAC Risks
- Downside: CAC inflation 2-3x in competitive market
- Upside: Viral loops could reduce CAC 50%
6. UNIT ECONOMICS DERIVED
6.1 Calculated Metrics
| Metric | Individual | Team | Enterprise |
|---|---|---|---|
| LTV | $45 | $1,500 | $13,000 |
| LTV/CAC | 4.5x | 7.5x | 13.0x |
| Payback | 0.78 months | 0.94 months | 0.90 months |
6.2 LTV Formula
LTV = Price / Churn Rate
Individual: $15 / 0.333 = $45
Team: $250 / 0.167 = $1,500
Enterprise: $1,300 / 0.10 = $13,000
6.3 Blended Metrics (Month 12 Mix)
Blended ARPU = (0.80 × $15) + (0.16 × $250) + (0.04 × $1,300) = $104
Blended LTV = (0.80 × $45) + (0.16 × $1,500) + (0.04 × $13,000) = $796
7. EXPENSE ASSUMPTIONS
7.1 Headcount Plan
| ID | Period | Headcount | Monthly Burn |
|---|---|---|---|
| E-01 | Months 0-4 | 2 | $13,000 |
| E-02 | Months 5-10 | 8 (+6 Month 5) | $100,750 |
| E-03 | Months 11-16 | 8 | $130,000 |
| E-04 | Months 17-28 | 13 (+5 Month 17) | $211,250 |
| E-05 | Month 29+ | 18 (+5 Month 29) | $292,500 |
7.2 Compensation
| ID | Parameter | Value |
|---|---|---|
| E-06 | Initial Founder Salary | $60,000/year |
| E-07 | Full Founder Salary | $130,000/year (July 2026+) |
| E-08 | Average Employee Salary | $150,000/year |
| E-09 | Benefits Multiplier | 1.30x (30% benefits load) |
| E-10 | Fully Loaded Cost | $195,000/year |
7.3 Variable Expenses (% of Revenue)
| ID | Category | % of Revenue |
|---|---|---|
| E-11 | Marketing | 35% |
| E-12 | R&D (non-salary) | 3.75% |
| E-13 | G&A | 10% |
| E-14 | Cloud Storage | 5% |
7.4 Fixed Expenses
| ID | Category | Amount | Scaling |
|---|---|---|---|
| E-15 | Office | $1,000-$4,500/month | Steps with headcount |
| E-16 | Subscriptions | $400-$1,200/month | Steps with headcount |
| E-17 | Other | 3% of revenue | Variable |
8. FUNDING ASSUMPTIONS
8.1 Capital Structure
| ID | Round | Amount | Month | Valuation Implied |
|---|---|---|---|---|
| F-01 | Initial | $0 | 0 | N/A |
| F-02 | Angel | $500,000 | 2 | ~$2.5M post |
| F-03 | Seed | $10,000,000 | 6 | ~$40M post |
| Total | $10,500,000 |
8.2 Use of Funds
- Months 1-6: Product development, initial GTM
- Months 6-12: Scale engineering team, marketing
- Month 12+: Cash flow positive, organic growth
9. OPERATIONAL ASSUMPTIONS
9.1 Gross Margin
| ID | Parameter | Value |
|---|---|---|
| O-01 | COGS Rate | 15% of revenue |
| O-02 | Gross Margin | 85% |
9.2 COGS Components (Assumed)
- Infrastructure: ~8% of revenue
- Third-party APIs: ~4% of revenue
- Support: ~3% of revenue
9.3 Tax Assumptions
| ID | Parameter | Value |
|---|---|---|
| O-03 | Effective Tax Rate | 26.5% |
| O-04 | Tax Applied | When EBITDA > 0 |
| O-05 | NOL Carryforward | Not modeled |
10. TIMING ASSUMPTIONS
10.1 Key Dates
| ID | Milestone | Month | Date |
|---|---|---|---|
| T-01 | Model Start | 0 | August 2025 |
| T-02 | First Customer | 1 | September 2025 |
| T-03 | Angel Close | 2 | October 2025 |
| T-04 | Seed Close | 6 | February 2026 |
| T-05 | EBITDA Positive | 13 | September 2026 |
| T-06 | First Hire Wave | 5 | January 2026 |
| T-07 | Second Hire Wave | 17 | January 2027 |
| T-08 | Third Hire Wave | 29 | January 2028 |
11. ASSUMPTION SENSITIVITY MATRIX
High Impact (Change Carefully)
| Assumption | Impact | Sensitivity |
|---|---|---|
| Month 1-3 Growth Rate | Revenue trajectory | ±10% → ±30% Year 1 revenue |
| Individual Churn | Unit economics | ±5% → ±25% LTV |
| Individual Price | ARPU | ±$5 → ±$3M ARR Year 3 |
| Seed Timing | Runway | ±2 months → survival risk |
Medium Impact
| Assumption | Impact | Sensitivity |
|---|---|---|
| Customer Mix | ARPU blend | ±10% enterprise → ±15% ARPU |
| Headcount Timing | Burn rate | ±3 months → ±$300K runway |
| Marketing % | OpEx | ±5% → ±$500K Year 2 |
Low Impact
| Assumption | Impact | Sensitivity |
|---|---|---|
| Office Cost | Minor | ±$2K → <1% burn |
| Subscriptions | Minor | ±$500 → <0.5% burn |
| Tax Rate | Net income only | ±5% → minimal runway impact |
12. VALIDATION CHECKLIST
Before Using This Model
- Validate pricing against current market (Cursor, Copilot, Codeium)
- Confirm seed timing with investor conversations
- Test growth rates against comparable companies
- Verify salary assumptions match hiring plan
- Review churn assumptions against industry benchmarks
Assumptions Requiring Periodic Update
- Pricing (quarterly)
- Growth rates (monthly actuals)
- Churn rates (monthly cohort analysis)
- CAC (monthly by channel)
- Headcount plan (quarterly)
Last Updated: February 5, 2026
Author: Hal Casteel with assistance from Claude 4.5
Source: CODITECT_Financial_Model_Final.xlsx