The numbers behind a small business, what each one tells you, and how to work it out from your own books. 51 articles.
What working capital is, the formula, why profitable small businesses run short as they grow, and four ways to free cash, worked through an example.
The quick ratio formula, which assets count as quick line by line, how it differs from the current ratio, and what to do when it falls, with an example.
The current ratio formula with a worked example, what a good current ratio looks like for different businesses, and why a rising one can be a warning sign.
How to calculate the cash conversion cycle (DIO + DSO − DPO) from small business books, what each day is worth in cash, and the changes that shorten it.
How to calculate gross margin step by step, overall and per product, with spreadsheet formulas, what belongs in COGS and why your till and books disagree.
Operating margin explained with a small-business example: the formula, why it can fall while sales grow, the owner's pay adjustment and fixes that move it.
Contribution margin per unit, in total and as a ratio, with a worked product table, rules for which products to push, fix or drop, and break-even in one step.
Margin vs markup explained with one picture, a conversion table, spreadsheet formulas and five pricing mistakes the mix-up causes, each priced out in dollars.
What EBITDA is, how to calculate it from your P&L, why lenders and buyers use it, how it differs from SDE and cash flow, with a worked small-business example.
How to calculate EBITDA margin, find which cost moved it, compare it fairly, and when adjusted EBITDA is fair, with a worked physiotherapy clinic example.
How to calculate gross and net burn rate from your bank balance, turn it into runway, test whether you're default alive, and decide what to cut first.
How to calculate a revenue run rate, why one-off deals and seasonality distort it, and when to use ARR or trailing twelve months, with a worked example.
How to read a profit and loss statement line by line, with a florist's year as the example: monthly vs annual views, five key ratios and the common mistakes.
A free profit and loss statement template: 12 monthly columns, year totals, each line as a % of revenue and built-in checks, with a filled-in example.
A free balance sheet template that compares two dates and checks itself: a $0 check cell, a retained earnings test, key ratios and a worked example.
Balance sheet vs income statement, explained with one bookshop's books: what each shows, how retained earnings link them, and why profit isn't cash.
The cost of goods sold formula with a worked example from a small hot sauce maker: what goes in, what stays out, how to count inventory, and the IRS rules.
Cash vs accrual accounting shown with one month of a carpentry shop's books: why a $5,200 profit became an $8,000 loss, which to use, and what the IRS says.
How to calculate revenue step by step with a pilates studio's month: gross vs net, what isn't revenue, when prepaid packs count, and revenue by stream.
Revenue per employee for a small firm: the formula, counting FTEs, why pass-through revenue misleads, how to compare with care, and what to do when it moves.
How to do a Pareto analysis in a spreadsheet: rank causes, add a cumulative %, chart it, and weight by cost. Worked on a bike shop's comebacks and customers.
A step-by-step cohort analysis from a plain order export: formulas, a pivot, a retention table, and how to read rows, columns and diagonals to spot churn.
The conversion rate formula in four versions (sessions, users, orders, leads), worked on one month of real-looking numbers, and the traps that skew it.
How to create a sales forecast in seven steps: a seasonal index from your history, price and volume drivers, a bottom-up check and monthly variance rules.
How billable hours work at a small law firm: what a target asks for, utilization vs realization vs collection, tracking time ethically, and fixing leaks.
A free financial statement template: income statement, balance sheet and cash flow in one workbook, linked so they tie out, with check cells and an example.
An income statement example for a dog grooming salon, read line by line, plus a single-step soap maker and a multi-step bike shop with tax, side by side.
Income statement vs profit and loss: the same report under two names. The other names, the two that differ, and the details that change the bottom line.
How to build a budgeted income statement from a sales budget, with a kitchen supply shop's 2027 plan by quarter, scenario tests and a hiring decision.
Build a common size income statement step by step from a design studio's books, spot mix shifts, compare with peers, and read the balance sheet version too.
How to build a contribution margin income statement: sort costs into variable and fixed, add segment margin by channel, and use it for pricing and orders.
Build a comparative balance sheet with dollar and percent change, flag the lines that need a reason, and turn the changes into sources and uses of cash.
Work out cash flow from operating activities with the indirect method: add-backs, working capital sign rules, what goes elsewhere, and when it flatters you.
Gross margin vs gross profit in a worked barbershop example: when the percentage rises as dollars fall, when price rises hide, and which to use for each call.
Adjusted EBITDA line by line: which add-backs buyers and lenders accept, which they cut, what a quality of earnings review checks, and SEC non-GAAP limits.
SDE vs EBITDA from one set of books: what counts as owner's pay and perks, which buyers use which number at which deal size, and mistakes that inflate SDE.
EBITDA vs net income with a worked walk between them, where operating income fits, and which one to use for loans, equipment and owner pay decisions.
Build a year-on-year EBITDA bridge from jobs, prices and costs by service line, with a spreadsheet formula for each bar, the mix trap and how to chart it.
Negative working capital can mean customers fund your business or that bills are going unpaid. Four tests, a worked example and what to do when it turns.
How to calculate monthly recurring revenue, split it into new, expansion, contraction and churn from a Stripe export, and what to leave out of MRR.
How to calculate net dollar retention and gross revenue retention on the right group of customers, the mistakes that inflate NDR, and sourced benchmarks.
The customer lifetime value formula three ways (simple, margin-based and cohort) with a worked example of why the simple one overstates and when to use each.
How to calculate days inventory outstanding from your books, why the averaging method can shift it by 11 days, and how to read DIO by product category.
GMROI shows how much gross margin each dollar of stock earns. See the formula, a worked garden center example by department, and what to do with low lines.
Sell through rate formulas compared (units vs value, since receipt vs period), how to set a weekly plan, and when the numbers say mark down or reorder.
Open to buy formula with a six-month boutique plan: stock-to-sales ratios, converting retail to cost correctly, holding back for reorders, monthly updates.
Retail inventory management for a small shop: measure shrink, receive carefully, keep clean SKUs, cycle count by ABC, buy with rules and clear slow stock.
How to keep track of inventory in Excel with a movement log: a free template with SUMIFS balances, stock value, reorder flags and slow-item checks.
Retail customer segmentation from a POS export: a nine-box recency grid, RFM scores in a spreadsheet, actions per segment and a holdout test for offers.
Year over year growth explained with a worked example: the formula, monthly vs YTD vs TTM, Excel formulas, calendar effects, and price vs volume growth.

Move from static P&L, budget, and cash flow spreadsheets to interactive FP&A dashboards with dynamic assumption testing, overhead tracking, and verified data.