--- title: "Financial Ratio Analysis Workbook (Excel) | MCC Solutions" description: "Excel workbook that turns three years of income statement and balance sheet figures into about 20 ratios, with the formula in words, a trend column and a flag…" url: "https://mcc-solutionsnj.com/toolkits/financial-ratio-analysis-workbook" --- 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 · 14-day full refund · example and blank copies · download link by email Buy now, $29 🌙 The desk is asleep. The store never is. Every kit and ebook downloads the moment you pay, day or night. Questions get answered after we open in the morning. [Browse the store](/toolkits) 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. Not the right fit if You don't have an income statement and balance sheet yet, or you need industry benchmarks built in. 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 [![Ratios tab of the Financial Ratio Analysis Workbook, with example data](/img/toolkits/financial-ratio-analysis-workbook/a.png)](/img/toolkits/financial-ratio-analysis-workbook/a.png) Ratios tab with example data. Made-up numbers. [![Inputs tab of the Financial Ratio Analysis Workbook, with example data](/img/toolkits/financial-ratio-analysis-workbook/b.png)](/img/toolkits/financial-ratio-analysis-workbook/b.png) Inputs tab with example data. Made-up numbers. Get it ## Financial Ratio Analysis Workbook Or pay with PayPal Uses the email and terms box above. You get the same download link by email. ZIP code (for sales tax) Want every toolkit? The [toolkit membership](/membership) includes all of them, with a lower rate if you pay yearly. Get every update for a year, $29: the [Yearly Updates Pass](/updates-pass?kit=financial-ratio-analysis-workbook) gives you each refreshed edition we release of the kits you own. One payment, no automatic renewal. Delivered as a zip with a filled example and a blank copy. Built for Excel, tested in LibreOffice; it should open in Google Sheets but not every feature is tested there. For one business, your own use. General information, not accounting, tax or legal 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. Ways to get it ## Just this kit, or more This kit **$29 one time** Financial Ratio Analysis Workbook. Buy this kit The set **$89 one time** 3 kits including this one, $28 less than buying them separately. [See the set](/toolkits/business-finance-ratios-bundle) Membership **$29 a month** Every kit and document pack in the store, including new ones. Cancel any time. [See the membership](/membership) Questions ## Common questions **What do I get and how is it delivered?** The Financial Ratio Analysis Workbook as two Excel files in one zip: a filled-in EXAMPLE so you can see every tab working, and a BLANK copy for your own numbers, plus a README. The download link arrives by email after payment. **Will it open on a Mac, Google Sheets or my phone?** Built for Excel and tested in LibreOffice, which runs on Mac and Windows; it should open in Google Sheets, but not every feature is tested there. Phone spreadsheet apps are not tested. If a file will not open or something looks wrong, reply to your order email and we will make it right. If it is not right for you, email us within 14 days of buying for a full refund. **Is this legal or tax advice?** No, it is not accounting, tax, investment or lending advice. **Is it the right fit for me?** It is made for owners who have an income statement and a balance sheet and want to read them, and bookkeepers who explain the numbers to clients. Skip it if you don't have an income statement and balance sheet yet, or you need industry benchmarks built in. 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](/bookkeeping/#interest) [Free books health check](/bookkeeping/health-check) Prefer to keep it yourself but want a hand getting started? [Book a 45 minute setup session](/workbook-setup-session) ($65). Buy it with the others [Bundle ### Business Finance Ratios Bundle This product plus 2 more, in one download. $89 instead of $117 separately](/toolkits/business-finance-ratios-bundle)[### Month-End Close Workbook A real month-end close in one Excel file. It tells you when a rec does not tie, which variances still need an answer, and when the period is ready to lock. $19](/toolkits/month-end-close-workbook) ## More bookkeeping and business toolkits - [First Job, First Paycheck Kit](/toolkits/first-job-first-paycheck-kit) $12 - [Fix-Your-Own-Credit Kit: Free Reports, Disputes and Freezes](/toolkits/diy-credit-repair-kit) $15 - [Florida Employer Compliance Kit 2027](/toolkits/florida-employer-compliance-kit-2027) $19 - [Florida Landlord Compliance Kit](/toolkits/florida-landlord-compliance-kit) $19 - [Florida Small Claims Court Kit](/toolkits/florida-small-claims-court-kit) $19 - [Florida Unemployment Checklist](/toolkits/florida-unemployment-checklist) $15 [See every toolkit and document pack](/toolkits/all) ## Rather have someone do the books? [Get a Bookkeeping Quote](/bookkeeping/#interest)[Call (908) 444-6373](tel:+19084446373)