Excel workbook
Financial Ratio Analysis Workbook: Margins, Liquidity, Leverage and Efficiency Ratios in Excel
Enter three years of statements and see margins, liquidity, leverage and efficiency ratios side by side, with what each one means in plain English.
$29 one time · example and blank copies · download link by email
Who it is for
Owners who have an income statement and a balance sheet and want to read them, and bookkeepers who explain the numbers to clients.
Why it is different
- The targets are yours. The workbook never says a ratio is good or bad, because that depends on your industry and your lender.
- Empty cells show blank, not errors, so you can fill it in a section at a time.
- A filled example with three years of invented figures and a blank copy with working formulas.
What is inside
- Start Here. What the workbook does, which cells to fill in and how to use it.
- Inputs. Three years of income statement and balance sheet figures, with a check that the balance sheet balances.
- Ratios. Profitability, liquidity, leverage and efficiency ratios with the formula in words, a trend column and a flag against your own targets.
- What It Means. What a higher or lower number usually signals for each ratio and the common mistake in reading it.
- Checks. Balance and sanity checks so a typing error does not produce a believable wrong answer.
A look inside
Example data, real formulas
Get it
Financial Ratio Analysis Workbook
Want every toolkit? The toolkit membership includes all of them, with a lower rate if you pay yearly.
Delivered as a zip of editable Word files and printable PDFs. For one business, your own use. General information and templates, not legal, tax or accounting advice. Ratios are general measures. What is healthy varies by industry, size and lender, and the example figures are invented. Not accounting, tax, investment or lending advice. Payment is handled by Stripe. If a file will not open or something looks wrong, reply to your order email and we will make it right.
Rather hand it off?
We can keep the books for you each month
If tracking this yourself is more than you want to take on, we do monthly bookkeeping in QuickBooks, Xero or Excel. Tell us what you use and what is behind, and we reply with a written quote after a short review of your books. No obligation.
Get a bookkeeping quote Free books health checkPrefer to keep it yourself but want a hand getting started? Book a 45 minute setup session ($65).
Buy it with the others