Financial ratios turn the raw numbers on a balance sheet and an income statement into a quick read on how a business is doing: whether it can pay its bills, how much profit it keeps, and how much it leans on debt. Excel is the natural place to calculate them because once the statements are sitting in cells as real numbers, every ratio is one short formula away. The work is mostly in the setup, not the math.
This guide walks through the ratios that matter most, the exact Excel formulas, and the two mistakes that quietly break the results. It assumes your statements are already in the sheet as numbers. If yours are still locked in a PDF, convert the financial report PDF to Excel first so the figures land numeric, then come back to this.
How do you calculate financial ratios in Excel?
Put the statement figures in one tab and your ratios on another that references those cells with formulas, so the ratios update whenever the underlying numbers change. A ratio is just one value divided by another, so most are a single division like =B5/B12. The discipline that keeps it reliable is referencing cells rather than typing numbers in, locking the references you copy across periods, and formatting the result as a number or a percentage rather than leaving it raw.
Lay the income statement and balance sheet down the rows with each period in its own column. Then in a ratios block, write each formula once and fill it across the period columns. Because every ratio points back to the source cells, correcting a figure or adding a new quarter reflows the whole analysis with no retyping.
What are the most important financial ratios?
The core set covers four areas: liquidity (can it cover short-term bills), profitability (how much it earns on sales and on capital), leverage (how much debt it carries), and efficiency (how well it uses assets). For most reviews, six ratios tell the story: current ratio, quick ratio, gross and net margin, return on equity, and debt-to-equity. The sections below give the Excel formula for each, using cell references you would swap for your own.
How do I calculate the current ratio in Excel?
The current ratio is current assets divided by current liabilities, so in Excel it is =CurrentAssets/CurrentLiabilities, for example =B8/B15. A result above 1 means the company has more short-term assets than short-term obligations. The quick ratio is the stricter version that drops inventory: =(CurrentAssets-Inventory)/CurrentLiabilities, or =(B8-B6)/B15. Both come straight off the balance sheet, which is why getting it in as clean data matters; you can convert a balance sheet PDF to Excel in one step.
How do you calculate profit margin in Excel?
A profit margin is a profit figure divided by revenue, formatted as a percentage. Gross margin is =GrossProfit/Revenue, for example =B4/B3; net margin is =NetIncome/Revenue, or =B11/B3. Select the cells and apply Percent format, or wrap them so they read cleanly. To find the period-over-period change, subtract one column from the next and divide by the earlier value: =(C3-B3)/B3. These ratios let you compare a small company against a large one fairly, because they normalize everything to a share of sales.
How do I calculate the debt-to-equity ratio in Excel?
Debt-to-equity is total liabilities divided by shareholders' equity: =TotalLiabilities/TotalEquity, or =B16/B20. It shows how much of the business is financed by debt against owners' capital, and lenders watch it closely. Two related leverage checks are return on equity, =NetIncome/TotalEquity, and interest coverage, =OperatingIncome/InterestExpense, which tells you how many times over the company can pay its interest bill. All three pull from figures that need to be true numbers, not text, or the division fails.
Why is my ratio showing a #VALUE! or #DIV/0! error?
A #VALUE! error almost always means one of the cells is text, not a number, which happens constantly when figures are copied out of a PDF and the commas, currency signs, or parentheses ride along as characters. A #DIV/0! error means the denominator is zero or blank. Fix the text problem at the source by keeping numbers numeric on conversion, covered in why numbers come in as text, and guard the division with =IFERROR(B16/B20,"") so an empty period does not litter the sheet with errors. If a SUM of a column returns zero, that is the same text problem showing up in your subtotals.
Can I build a financial ratio template in Excel?
Yes, and it pays off the moment you analyze more than one company or period. Build a statements tab with a fixed layout, a ratios tab that references it by cell, and label every formula so the next person can follow it. When a new set of financials arrives, you drop the numbers into the same cells and every ratio recalculates. The catch is keeping the layout identical each time, which is far easier when each report is converted to the same column structure rather than copied by hand. For teams doing this every month, the wider PDF to Excel workflow for finance teams keeps the inputs consistent.
Keeping the inputs clean
Every ratio on this page is only as good as the numbers feeding it. Two habits protect the analysis. First, never hardcode a figure into a ratio formula; always point at the statement cell so a correction flows through. Second, confirm the figures are stored as numbers before you start, because a single text cell will break a division or quietly understate a total. If you handle prior-year statements, the guide on consolidating financial statements in Excel shows how to line several periods up so the ratios trend cleanly.
This is the same discipline credit teams apply when they spread a borrower's financials and compute coverage and leverage ratios to size a loan; tools like AI lender document analysis software automate that spread for underwriting. And when the statements arrive across dozens of filings at once, enterprise document data extraction pulls the figures out at scale so they are ready to drop into a model. For accuracy-sensitive work where the ratios feed a real decision, start the data side with the accurate PDF to Excel converter so what reaches your formulas already ties out.
Once the statements are in Excel as clean numbers, financial ratios take minutes. The hard part is never the division; it is getting trustworthy figures into the cells in the first place. Convert the report once, keep the numbers numeric, and the same ratio template serves you every period after that.