Financial Multiratio Template

Stop building financial analysis from scratch.

Every time you analyze a company, you spend hours setting up the same spreadsheet: formatting the balance sheet, writing formulas for 20 different ratios, building the DuPont model, calculating the cash conversion cycle. This template eliminates all of that.

What's inside

One fully unlocked Excel file with three structured sheets:

Sheet 1 — Financial Data Input

Paste up to 11 years of annual financial data directly from SABI or any financial database. Balance sheet and income statement fields are pre-labeled and ready to fill in.

Sheet 2 — Balance Sheet & Income Statement

Your data automatically populates a clean, professionally formatted balance sheet and P&L — ready to present to management, clients, or professors.

Sheet 3 — Full Ratio Analysis

Every ratio calculates automatically from your input data. No formulas to write. No errors to hunt down.

20+ financial ratios included

Profitability

— ROE (Return on Equity)

— ROA (Return on Assets)

— ROCE (Return on Capital Employed)

— Net profit margin

— EBIT & EBITDA

Operations

— Asset turnover

— Inventory turnover

— Days Sales Outstanding (DSO)

— Days Payable Outstanding (DPO)

— Interest coverage ratio

Structure & Solvency

— Solvency ratio

— Liquidity ratio

— Leverage / gearing

— Financial autonomy

— Firmeza ratio (ANC/PNC)

Per Employee

— Profit per employee

— Revenue per employee

— Average employee cost

— Labor cost as % of revenue

— Equity per employee

DuPont Analysis

— Full ROE decomposition

— Asset rotation effect

— Financial leverage effect

— Cost of debt (i)

— Margin × turnover breakdown

Working Capital & Cash Cycle

— Working capital (Fondo de Maniobra)

— Average maturity period (PMM)

— Cash conversion cycle

— Collection period (PC)

— Payment period (PP)

Who uses this template

— Financial analysts preparing company reports

— Consultants benchmarking clients against competitors

— Business students completing financial analysis assignments

— Companies analyzing their own performance year over year

— Anyone working with SABI database exports

What you get

✔ Excel file (.xlsx) — 100% unlocked, every formula editable

✔ 3 structured sheets ready to use immediately

✔ 20+ auto-calculated financial ratios

✔ DuPont analysis model

✔ Cash conversion cycle & working capital analysis

✔ Up to 11 years of historical data

✔ Compatible with Excel and Google Sheets

✔ Invoice included automatically

✔ Free lifetime updates

One-time payment. No subscription. Use it on as many companies as you want.

Frequently asked questions

Do I need any special Excel knowledge?

No. You only need to enter your financial data — all formulas are already built in.

Does it work with Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. All calculations work correctly.

Can I edit the formulas?

Yes — the file is 100% unlocked. You can modify any formula, add columns, or adapt the layout to your needs.

Does it work with SABI data?

Yes. The data input sheet is structured to accept SABI (Sistema de Análisis de Balances Ibéricos) exports directly.

How many companies can I analyze with it?

Unlimited. Duplicate the file once per company.

Questions? Contact hello@thenapkincompany.com