-
Excel workbook preview
Goals, OKRs, KPIs and Business Performance
Financial Ratio Calculator (Liquidity, Profitability and Efficiency)
3 downloads per free account, no card needed.
Who this is for
An owner whose bank asked about liquidity and debt cover before renewing a facility downloads this to calculate the ratios and see which ones need explaining.
What is inside
- 18 ratios in 4 groups: liquidity, profitability, efficiency, and leverage and debt service
- Inputs for one balance sheet and a 12-month P&L, this year and last, with a balance check
- Current, prior and change for every ratio, with the formula written next to it
- Cash conversion cycle from debtor, inventory and creditor days
- Debt service coverage and interest cover, with the DSCR definition stated
- Own targets and amber bands per ratio with a live RAG status
How to use it: Enter the balance sheet and the last 12 months' profit and loss for both years, check the inputs balance, then set your own targets for the ratios.
Files & formats
- XLSXfinancial-ratio-calculator.xlsx13 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.


