Every calculator on this site is also available as a spreadsheet you can keep, change and share. The templates use the same formulas as the calculators, open with worked examples, and work in Excel and in Google Sheets. There is no sign-up and no email address to give: each link downloads the file.
Spreadsheet templates
- Financial statement analyzerExcel and Google Sheets · 42 KB · Enter one balance sheet and income statement for 22 ratios, the DuPont breakdown and SEC industry medians for 40 industries
- Financial ratio calculatorsExcel and Google Sheets · 21 KB · Every calculator on this site in one workbook, one sheet for each group of ratios, opened on worked examples
- Altman Z-scoreExcel and Google Sheets · 9 KB · All three versions, Z, Z′ and Z″, with the five ratios and each version's zones
- Piotroski F-scoreExcel and Google Sheets · 9 KB · Two years of figures in, all nine signals and the score out
- Beneish M-scoreExcel and Google Sheets · 9 KB · Two years of figures in, all eight indices and the score against the −1.78 cut-off
Using a template in Google Sheets
- Download the template.
- Open Google Sheets and choose File, then Import, then Upload, and select the file. You can also upload it to Google Drive and open it with Google Sheets.
- Choose “Create new spreadsheet”. The formulas, the industry list and the links all carry over.
How the templates work
- Yellow cells are inputs. Replace the example figures with your own; everything else recalculates.
- Green cells are results. Each one is a visible formula, so you can check it, copy it or change it.
- The same definitions as the calculators. The formulas are generated from the definitions behind the calculators on this site, and every result is checked against them before release.
- A link to each explanation. Every ratio links to its page here, which says what the result means and what it does not show.
- No macros. The files contain formulas only, so they open without security warnings.
Printable practice worksheets
Ready-made PDF worksheets with answer keys, for teaching or exam practice. For new problems every time, with each step checked as you work, use the financial ratio practice problems.
- Current ratio: 6 problems with answer keyPDF · 91 KB · fresh copies anytime from the practice problems page
- Quick ratio: 6 problems with answer keyPDF · 93 KB · fresh copies anytime from the practice problems page
- Debt-to-equity ratio: 6 problems with answer keyPDF · 93 KB · fresh copies anytime from the practice problems page
- Gross profit margin: 6 problems with answer keyPDF · 92 KB · fresh copies anytime from the practice problems page
- Return on equity: 6 problems with answer keyPDF · 93 KB · fresh copies anytime from the practice problems page
- All five ratios: 10 problems with answer keyPDF · 109 KB · fresh copies anytime from the practice problems page
Free to use and share
The templates and worksheets are free under the Creative Commons Attribution 4.0 licence (CC BY 4.0). You can use them, change them and share them, in class or at work, as long as you credit FinancialRatios.guide. The industry benchmarks come from public SEC filings; the current ratio by industry guide explains how they are measured.