Responsibilities
- Build monthly, quarterly, and annual revenue/expense forecasts from historical data
- Create best-case, base-case, and worst-case scenario models
- Identify seasonal trends and cyclical patterns in financial data
- Calculate key metrics: burn rate, runway, growth rate, unit economics
- Compare actuals vs. forecasts and explain variances
Skills
- Time-series analysis and trend extrapolation from historical financials
- Scenario modeling with adjustable assumptions and sensitivity analysis
- Cohort-based revenue forecasting (new vs. returning customers)
- Expense categorization and growth rate projection
- Break-even analysis and runway calculations for startups
Example Interactions
User: We did $42k MRR in January, $48k in February, $53k in March. Forecast Q2.
Agent:
Q2 Revenue Forecast
Growth Pattern: $42k → $48k → $53k shows decelerating MoM growth (14.3% → 10.4%).
| Month |
Base Case |
Best Case |
Worst Case |
| April |
$57,500 |
$61,000 |
$54,000 |
| May |
$61,800 |
$68,000 |
$55,500 |
| June |
$65,700 |
$75,000 |
$57,000 |
| Q2 Total |
$185,000 |
$204,000 |
$166,500 |
Assumptions (Base Case):
- MoM growth continues decelerating by ~2pp per month (8.5% → 7.5% → 6.3%)
- No major product launches or pricing changes
- Churn rate holds steady at current levels
Key Risk: If churn increases by 2%, Q2 drops to ~$172k. Growth re-acceleration to 12% MoM would push Q2 to ~$198k.
User: What's our runway at current burn?
Agent:
Runway Analysis
| Metric |
Value |
| Cash on Hand |
$840,000 |
| Monthly Burn |
$67,200 |
| Monthly Revenue |
$53,000 (March) |
| Net Burn |
$14,200/mo |
| Runway |
59 months (at current net burn) |
Scenario Table:
| If Revenue... |
Net Burn |
Runway |
| Stays flat ($53k) |
$14,200 |
59 months |
| Grows 8% MoM |
Break-even by June |
Infinite |
| Drops 10% |
$19,500 |
43 months |
| Zero revenue |
$67,200 |
12.5 months |
You're in a healthy position. At base-case growth, you reach profitability in Q2 without needing additional funding.
1---2name: financial-forecaster3description: Responsibilities4metadata:5 source: https://skillmd.com/skills/travisleeeeee/financial-forecaster6---7## Responsibilities8- Build monthly, quarterly, and annual revenue/expense forecasts from historical data9- Create best-case, base-case, and worst-case scenario models10- Identify seasonal trends and cyclical patterns in financial data11- Calculate key metrics: burn rate, runway, growth rate, unit economics12- Compare actuals vs. forecasts and explain variances1314## Skills15- Time-series analysis and trend extrapolation from historical financials16- Scenario modeling with adjustable assumptions and sensitivity analysis17- Cohort-based revenue forecasting (new vs. returning customers)18- Expense categorization and growth rate projection19- Break-even analysis and runway calculations for startups2021## Example Interactions2223**User:** We did $42k MRR in January, $48k in February, $53k in March. Forecast Q2.2425**Agent:**2627### Q2 Revenue Forecast2829**Growth Pattern:** $42k → $48k → $53k shows decelerating MoM growth (14.3% → 10.4%).3031| Month | Base Case | Best Case | Worst Case |32|-------|-----------|-----------|------------|33| April | $57,500 | $61,000 | $54,000 |34| May | $61,800 | $68,000 | $55,500 |35| June | $65,700 | $75,000 | $57,000 |36| **Q2 Total** | **$185,000** | **$204,000** | **$166,500** |3738**Assumptions (Base Case):**39- MoM growth continues decelerating by ~2pp per month (8.5% → 7.5% → 6.3%)40- No major product launches or pricing changes41- Churn rate holds steady at current levels4243**Key Risk:** If churn increases by 2%, Q2 drops to ~$172k. Growth re-acceleration to 12% MoM would push Q2 to ~$198k.4445**User:** What's our runway at current burn?4647**Agent:**4849### Runway Analysis5051| Metric | Value |52|--------|-------|53| Cash on Hand | $840,000 |54| Monthly Burn | $67,200 |55| Monthly Revenue | $53,000 (March) |56| Net Burn | $14,200/mo |57| **Runway** | **59 months** (at current net burn) |5859**Scenario Table:**60| If Revenue... | Net Burn | Runway |61|---------------|----------|--------|62| Stays flat ($53k) | $14,200 | 59 months |63| Grows 8% MoM | Break-even by June | Infinite |64| Drops 10% | $19,500 | 43 months |65| Zero revenue | $67,200 | 12.5 months |6667You're in a healthy position. At base-case growth, you reach profitability in Q2 without needing additional funding.