saas-financial-modeling-metrics_skill

This skill helps solo founders build a clear SaaS financial model by calculating unit economics, churn, CAC, LTV and runway on a single editable spreadsheet.

142

GitHub Stars

1

Bundled Files

2 months ago

Catalog Refreshed

4 months ago

First Indexed

Readme & install

Copy the install command, review bundled files from the catalogue, and read any extended description pulled from the listing source.

Installation

Preview and clipboard use veilstrat where the catalogue uses aiagentskills.

npx veilstrat add skill whawkinsiv/solo-founder-superpowers --skill saas-financial-modeling-metrics

SKILL.md8.8 KB

Overview

This skill helps solo founders build simple, actionable SaaS financial models and understand core metrics like MRR, ARR, CAC, LTV, churn, payback, and the quit number. It translates unit economics into a single monthly spreadsheet that’s easy to update and use for decision making. The goal is practical clarity: know whether to spend, hire, pivot, or stop based on clean math and benchmarks.

How this skill works

I inspect your current revenue, customer counts, acquisition spend, and operating costs to produce a one-sheet monthly model and a short dashboard of leading indicators. The skill calculates MRR/ARR breakdowns, CAC by channel, LTV (with gross margin), LTV:CAC, CAC payback, churn rates, runway, and the quit number. I show each formula, benchmark outcomes, and highlight danger zones with specific recommendations.

When to use it

Preparing to quit your job and need a realistic MRR target
Validating unit economics before scaling paid acquisition
Monitoring early-stage SaaS health (MRR, churn, runway)
Deciding whether to hire, invest in growth, or reduce burn
Building a simple monthly financial forecast for investor or personal planning

Best practices

Keep the model to a single spreadsheet and update it monthly
Value your time consistently when computing CAC for founder-led channels
Track both logo churn (count) and revenue churn (MRR) separately
Always show calculations, not just results — include formulas and inputs
Compare key metrics to benchmarks (LTV:CAC, payback, churn) and flag red lines

Example use cases

Calculate your quit number and realistic months-to-quit at a target price
Build a monthly unit-economics table: customers, MRR, COGS, gross margin, CAC, LTV, payback, runway
Run a channel-level CAC analysis to decide where to double down or stop spending
Forecast 3-month MRR under conservative growth assumptions and compute break-even customers
Create an essential metrics dashboard: MRR, new signups, activation, churn, CAC, LTV

FAQ

The quit number is the MRR required to replace your post-tax personal burn (Monthly nut ÷ 0.70). It’s a planning tool—reliability depends on realistic input for personal expenses, tax assumptions, and conservative growth rates.

How should I value founder time in CAC?

Be consistent: use $0 if you want to treat founder time as sunk, or use an opportunity-cost hourly rate. Include whichever approach in the model so you can compare scenarios.