Spreadsheet calculators and planning tools

Free calculators and planning helpers for founders and finance teams who live in Google Sheets and Excel. When you need full statements, jump to our templates.

Explore spreadsheet templates for full workbooks, or open the Lexicon for clear definitions of the terms behind the math.

Built for real spreadsheet work

Search or filter to match the job in front of you—percentages and growth, descriptive stats, loan schedules, time and hours, retirement checks, currency reference rates, and more. Most tools include copy-ready Google Sheets and Excel snippets; finance results are illustrations, not advice.

Spreadsheet mathLive
Trapezoidal rule calculator (pasted x and y)
Paired x and y from Sheets or Excel → composite trapezoidal approximation to ∫y dx, including uneven Δx after sorting; SUMPRODUCT / SUMMENPRODUKT / SOMMEPROD patterns—not a symbolic f(x) solver.
Open tool
Spreadsheet mathLive
Winning percentage calculator (wins, losses, ties)
W–L–T record → winning % with ties as ½ win each in the numerator; IF/ WENN / SI guard for zero games—not live win probability or odds conversion.
Open tool
StatisticsLive
Average calculator
Arithmetic mean from a list or weighted average (value and weight per line); sum and count; AVERAGE and SUMPRODUCT for Sheets and Excel.
Open tool
PlanningLive
U.S. savings bond calculator
Paper U.S. Series EE, E, I, and Savings Notes: redemption value from issue date and denomination using U.S. Treasury Fiscal Data, with Sheets and Excel scaling tips—not tax or investment advice.
Open tool
PlanningLive
Rule of 72 calculator
Heuristic and exact (annual compounding) doubling time and implied rate—72/… and LOG patterns for Google Sheets and Excel. Illustration only, not a return forecast.
Open tool
Spreadsheet mathLive
Annuity calculator
Level payment stream: solve payment, present value, or future value from a nominal rate, periods, and ordinary vs due timing—PMT, PV, and FV patterns for Sheets and Excel; not an insurance quote.
Open tool
StatisticsLive
One-way ANOVA calculator
One-way between-subjects ANOVA from pasted groups—F statistic, p-value, η², and ANOVA table; AVERAGE per group and Excel Data Analysis pointers—not Tukey, two-way, or repeated measures.
Open tool
PlanningLive
CD calculator
Certificate of deposit: principal, APY, and term in months or years—maturity balance and interest with your compounding pick. Sheets/Excel friendly; illustration only, not a bank offer.
Open tool
Unit economicsLive
ROI calculator
Gain and total ROI % from amount invested vs amount returned; optional holding period for the same annualized growth math as the CAGR calculator (not ROI ÷ years). Copy-ready cell math for Sheets and Excel—illustration only.
Open tool
Unit economicsLive
ROAS calculator
Attributed revenue divided by ad spend—ROAS as a multiple and as a percent for the same inputs. Copy-ready =revenue/spend patterns for Google Sheets and Excel—illustration only, not platform attribution.
Open tool
Unit economicsLive
Payback period calculator
Break-even time from initial investment and equal or unequal periodic cash inflows; optional discounted payback with a nominal annual rate. Annual or monthly periods—Sheets/Excel patterns. Capital budgeting illustration, not loan payoff.
Open tool
Unit economicsLive
Burn multiple calculator
Net burn and net new ARR for the same period (month, quarter, or year) to burn multiple—capital-efficiency check for subscription businesses; Sheets/Excel snapshot formulas. Illustration only.
Open tool
Unit economicsLive
Customer lifetime value (CLV) calculator
CLV from monthly ARPU and churn, or revenue × periods, with optional margin and CAC for LTV:CAC. Not home-loan LTV. Illustration only.
Open tool
Unit economicsLive
Break-even calculator
Fixed costs, price per unit, and variable cost per unit → contribution margin, break-even units, and break-even revenue for one product—Sheets/Excel CVP patterns; illustration only.
Open tool
Unit economicsLive
CAGR calculator
Beginning value, ending value, and time to compound annual growth rate (CAGR)—plus total return % and multiple. Dates or years + months; Sheets/Excel POWER patterns—illustration only.
Open tool
Unit economicsLive
IRR calculator
Initial outlay and annual net cash flows to periodic IRR (internal rate of return), NPV=0 at one rate per year. Same family as Excel/Sheets IRR—illustration only.
Open tool
Unit economicsLive
WACC calculator
Weighted average cost of capital from market-value equity and debt, cost of equity and pre-tax cost of debt, and corporate tax rate—with weight and after-tax debt lines. Sheets/Excel—illustration only.
Open tool
Unit economicsLive
MIRR calculator
Initial outlay, annual signed cash flows, finance rate, and reinvestment rate to periodic MIRR (modified internal rate of return)—aligned with Excel/Sheets MIRR. Illustration only.
Open tool
Unit economicsLive
Year-over-year (YoY) growth calculator
Prior-year value vs current value → YoY growth % and absolute change. Same-metric year-over-year—not CAGR over multiple years (use the CAGR calculator). Sheets/Excel patterns—illustration only.
Open tool
Unit economicsLive
Staff turnover rate calculator
Separations and average headcount (or beginning and ending headcount) in the same period → employee turnover %—workforce, not revenue or inventory turnover. Sheets/Excel; illustration only.
Open tool