mirror of
https://github.com/magnus919/agent-skills.git
synced 2026-09-11 19:47:12 +03:00
a45952d9c1
* feat(skill): beef up financial-modeling with templates/scripts/evals Add a schema-valid eval manifest (6 cases: unit-economics review, pricing decision, fundraising scenario, SaaS metrics interpretation, model sanity check, runway and burn analysis), four fillable templates (unit-economics record, pricing decision record, fundraising scenario, model sanity checklist), a stdlib SaaS-metrics calculator (ARR, monthly and annualized logo churn, NDR, Rule of 40) with a unittest suite, and a README Quick Start documenting the script. Closes #241. Co-authored-by: factory-droid[bot] <138933559+factory-droid[bot]@users.noreply.github.com> * fix(skill): guard churn prints in saas-metrics human output print_human indexed monthly_logo_churn_pct and annualized_logo_churn_pct unconditionally while compute_metrics only populates them when churn inputs are given, so human-readable runs without churn inputs (--mrr alone, --mrr + NDR, --mrr + growth/margin) crashed with a KeyError (exit 1), violating the script's documented 0/2 exit-code contract. Guard both churn print lines with `if 'monthly_logo_churn_pct' in metrics:`, mirroring the existing NDR and Rule-of-40 guards, and add a regression test class covering human output with churn omitted. Co-authored-by: factory-droid[bot] <138933559+factory-droid[bot]@users.noreply.github.com> --------- Co-authored-by: factory-droid[bot] <138933559+factory-droid[bot]@users.noreply.github.com>
3.1 KiB
3.1 KiB
Fundraising Scenario
Fill this scenario before starting a financing process. Size the raise from the cash model, show what it buys in each case, model the fully diluted cap-table impact, and list what must be prepared for diligence. This is not legal, securities, tax, or accounting advice; involve qualified counsel.
Business Case and Cash Model
- Stage / round:
[fill: e.g. Series A] - Currency:
[fill: e.g. USD] - Prepared by / date:
[fill: name or handle, YYYY-MM-DD] - Base-case net monthly cash burn:
[fill: amount; define cash basis, not P&L loss] - Available cash today:
[fill: amount] - Base-case cash-out date without financing:
[fill: date]
Raise Size and Runway
- Proposed raise size:
[fill: amount] - Target runway after close (months):
[fill: count]
| Case | Net monthly burn | Runway from raise (months) | Cash-out date | Key drivers |
|---|---|---|---|---|
| Upside | [fill: amount] |
[fill: result] |
[fill: date] |
[fill: drivers] |
| Base | [fill: amount] |
[fill: result] |
[fill: date] |
[fill: drivers] |
| Downside | [fill: amount] |
[fill: result] |
[fill: date] |
[fill: drivers] |
- One-time costs and slower-collections sensitivity:
[fill: what else could move the burn] - Contingency plan if terms change or timing slips:
[fill: description]
Cap Table Impact (Fully Diluted)
- Pre-money valuation:
[fill: amount] - New money:
[fill: amount] - Post-money valuation:
[fill: amount] - Option-pool increase and who bears the dilution:
[fill: % and description] - Existing convertibles, warrants, and preferences:
[fill: summary]
| Holder class | Pre-round ownership % | Post-round ownership % | Notes |
|---|---|---|---|
| Founders | [fill: %] |
[fill: %] |
[fill: notes] |
| Employees (option pool) | [fill: %] |
[fill: %] |
[fill: notes] |
| Existing investors | [fill: %] |
[fill: %] |
[fill: notes] |
| New investors | n/a | [fill: %] |
[fill: notes] |
Term-Sheet Modeling
Model the economic result of key terms at several exit values, not just the headline valuation.
| Term | Assumption to model | Result across exit values |
|---|---|---|
| Liquidation preference | [fill: multiple and seniority] |
[fill: who gets paid first and how much at each exit] |
| Participation | [fill: participates or capped] |
[fill: effect on common proceeds] |
| Anti-dilution | [fill: down-round mechanics] |
[fill: conversion impact] |
| Pro-rata / ROFR / drag-along | [fill: rights] |
[fill: effect on future rounds and transfers] |
Diligence Preparation
- Reconciled financial model (base/upside/downside, linked statements)
- Current cap table with all instruments
- Historical financial statements
- Customer and retention analysis
- Material contracts and corporate records
- Risks and assumptions document
- Access-control plan for sensitive records
Decisions & Follow-Ups
- Decision this scenario supports:
[fill: e.g. raise now vs. extend runway first] - Open questions for counsel / advisors:
[fill: questions] - Next review date:
[fill: YYYY-MM-DD]