Financial Statement Analysis
AI-Assisted Ratio Analysis with US GAAP & IFRS
Reading the Story Behind the Numbers
Financial statements are not just tables of numbers — they tell the story of a business. Is the company growing or shrinking? Can it pay its debts? Is it earning enough on its investments? Are costs under control? A skilled accountant reads financial statements the way a doctor reads an X-ray — the numbers reveal the health of the business.
The problem is that reading financial statements well takes time. Calculating ratios, comparing them across years, benchmarking against industry peers, and spotting trends — all of this is essential but time-consuming. AI does not replace your interpretation, but it can do the calculation, comparison, and trend-spotting in minutes, so you spend your time on the interpretation that actually matters.
Understanding the Financial Statements
Before we bring in AI, let us make sure the building blocks are clear.
The Balance Sheet (Statement of Financial Position)
A balance sheet shows what a business owns, what it owes, and what belongs to the owners — at a specific date. Think of it as a photograph, not a video.
Open data/balance-sheets.json in the code panel. You will see three years (FY24, FY25, FY26) of balance sheet data for "Apex Commercial Corp." — a mid-size US distribution company. The structure follows US GAAP format:
| Section | What It Includes | Example from the Data |
|---|---|---|
| Non-Current Assets | Property, plant & equipment, intangibles, goodwill, long-term investments | Warehouse, delivery fleet, customer list from acquisition |
| Current Assets | Inventory, accounts receivable, cash, prepaid expenses | Merchandise inventory, trade receivables, bank balance |
| Stockholders' Equity | Common stock + retained earnings + AOCI | Paid-in capital of $2M, accumulated profits |
| Non-Current Liabilities | Long-term debt, deferred tax liabilities, lease liabilities | Bank term loan ($1.5M, 7-year), operating lease obligations |
| Current Liabilities | Accounts payable, accrued expenses, current portion of long-term debt, sales tax payable | Trade payables, payroll accrual, current loan payments |
The fundamental equation: Assets = Stockholders' Equity + Liabilities. If this equation does not balance, something is wrong with the data.
The Income Statement (Profit & Loss)
While the balance sheet is a photograph, the income statement is a video — it shows what happened over a period (usually a quarter or a year). How much did the business earn? What did it spend? What is left?
Open data/profit-loss-statements.csv to see three years of quarterly income statement data. The flow is:
| Line Item | What It Means | Watch For |
|---|---|---|
| Net Revenue | Sales of goods/services (net of returns, discounts, sales tax) | Is it growing year-over-year? |
| Other Income | Interest income, gains on investments, miscellaneous | If large relative to revenue, the core business may be weak |
| Cost of Goods Sold (COGS) | Direct costs of goods sold (materials, labor, freight-in) | Rising faster than revenue? Margins are shrinking |
| Gross Profit | Revenue minus COGS | The most fundamental profitability measure |
| Operating Expenses (SG&A) | Salaries, rent, utilities, marketing, insurance, travel | Growing in line with revenue or faster? |
| EBITDA | Earnings before interest, tax, depreciation, amortization | Shows operating efficiency independent of capital structure |
| Depreciation & Amortization | Non-cash charge for asset usage and intangible amortization | Relevant for capital-intensive and acquisition-heavy businesses |
| Interest Expense | Cost of borrowed funds | High interest costs relative to EBITDA signal debt stress |
| Pretax Income | What the business earned before paying taxes | The number most analysts focus on |
| Income Tax Expense | Federal + state income tax (current + deferred) | Effective tax rate should be close to the statutory rate (21% federal + state) |
| Net Income | The bottom line — what is actually left for shareholders | The ultimate measure of profitability |
Key Financial Ratios
Ratios turn raw numbers into meaningful comparisons. Instead of saying "the company has $3.2M in current assets," you say "the current ratio is 1.8, which means for every $1 of short-term debt, the company has $1.80 in short-term assets." That is far more useful.
Liquidity Ratios (Can the business pay its short-term debts?)
| Ratio | Formula | What It Tells You | S&P 500 Median |
|---|---|---|---|
| Current Ratio | Current Assets / Current Liabilities | Can the business meet short-term obligations? | ~1.5 |
| Quick Ratio | (Current Assets - Inventory) / Current Liabilities | Same, but excludes inventory (which may not sell quickly) | ~1.0 |
| Cash Ratio | Cash & Equivalents / Current Liabilities | Can it pay debts with cash right now? | ~0.3 |
Profitability Ratios (Is the business earning enough?)
| Ratio | Formula | What It Tells You | S&P 500 Median |
|---|---|---|---|
| Gross Margin | Gross Profit / Revenue x 100 | How much profit is left after direct costs? | ~40-50% |
| Net Margin | Net Income / Revenue x 100 | How much of every dollar of revenue becomes profit? | ~10-12% |
| Return on Equity (ROE) | Net Income / Stockholders' Equity x 100 | What return are shareholders getting? | ~15-18% |
| Return on Assets (ROA) | Net Income / Total Assets x 100 | How efficiently does the business use all its assets? | ~6-8% |
Leverage Ratios (How much debt is the business carrying?)
| Ratio | Formula | What It Tells You | Healthy Range |
|---|---|---|---|
| Debt-to-Equity | Total Debt / Stockholders' Equity | How leveraged is the business? | 0.5 - 1.5 |
| Interest Coverage | EBIT / Interest Expense | Can the business comfortably pay its interest? | > 3.0 |
Efficiency Ratios (How well is the business using its resources?)
| Ratio | Formula | What It Tells You | Healthy Range |
|---|---|---|---|
| Inventory Turnover | COGS / Average Inventory | How many times inventory is sold and replaced per year | Industry-dependent (4-12) |
| Days Sales Outstanding (DSO) | (Accounts Receivable / Revenue) x 365 | How quickly customers are paying (in days) | 30-60 days |
| Days Payable Outstanding (DPO) | (Accounts Payable / COGS) x 365 | How quickly the business pays its suppliers (in days) | 30-90 days |
Open data/ratio-benchmarks.json — this file contains industry-average ratios for 10 major sectors (retail, technology, healthcare, financial services, manufacturing, consumer goods, energy, real estate, utilities, and professional services). Comparing your calculated ratios against these benchmarks tells you whether the business is performing above or below its industry peers.
SEC Filings: The Data Source for Public Companies
For publicly traded US companies, the SEC (Securities and Exchange Commission) requires standardized filings that are a goldmine for AI-assisted analysis:
| Filing | Frequency | What It Contains |
|---|---|---|
| 10-K | Annual | Full financial statements, MD&A (management discussion), risk factors, auditor's report |
| 10-Q | Quarterly | Condensed financial statements, interim MD&A, updated risk factors |
| 8-K | Event-driven | Material events (M&A, executive changes, restatements) |
| Proxy Statement (DEF 14A) | Annual | Executive compensation, board composition, shareholder proposals |
Prompt for SEC analysis: "Download Apple's latest 10-K filing. Extract the following from the financial statements: revenue, net income, total assets, total stockholders' equity, and long-term debt for the last three fiscal years. Calculate ROE, net margin, and debt-to-equity for each year. Present the results in a table and identify the most significant trend."
AI can parse these filings in seconds. Tools like Calcbench, Intrinio, and even Claude can read XBRL-tagged SEC filings and extract any financial data point you need.
US GAAP vs. IFRS: Key Differences That Affect Ratios
If you work with both US and international companies, you need to know where GAAP and IFRS diverge — because the differences affect ratio calculations:
| Area | US GAAP | IFRS | Impact on Ratios |
|---|---|---|---|
| Inventory Valuation | LIFO allowed | LIFO prohibited | LIFO reduces inventory value and COGS timing differs — affects gross margin and inventory turnover |
| R&D Costs | Expensed as incurred | Development costs can be capitalized | Capitalizing R&D increases assets — affects ROA |
| Lease Accounting | ASC 842: operating and finance leases on balance sheet | IFRS 16: single model, all leases on balance sheet | Differences in lease classification affect leverage ratios |
| Revenue Recognition | ASC 606 | IFRS 15 | Largely converged, but implementation differences exist |
| Impairment | Two-step test, no reversal | One-step test, reversal allowed | Reversals can inflate asset values under IFRS |
Always specify the reporting standard in your AI prompts. A prompt like "analyze this balance sheet" will produce US GAAP assumptions by default. If you are working with IFRS data, say so explicitly.
How AI Automates Ratio Analysis
Instead of manually extracting numbers and punching them into a calculator, you give AI the data and ask specific questions.
Naive prompt (do not do this): "Analyze this balance sheet."
Better prompt: "Using the balance sheet and income statement data for FY26 from Apex Commercial Corp., calculate these ratios: current ratio, quick ratio, debt-to-equity ratio, ROE, and net margin. For each ratio, show the formula, the numbers you used, the result, and a one-sentence interpretation. Compare each result with the S&P 500 median for the distribution industry."
Trend Analysis: The Real Power
Ratios for a single year are useful. Ratios across three years are powerful. Trends tell you whether the business is getting stronger or weaker, and in which specific area.
Prompt for trend analysis: "Compare the current ratio, gross margin, net margin, and debt-to-equity ratio for Apex Commercial Corp. across FY24, FY25, and FY26. Present the results in a table. For each ratio, note whether it improved, declined, or stayed stable, and suggest one possible reason for the trend."
The Three-Question Framework
For any financial statement analysis, train yourself to ask these three questions:
AI is excellent at Question 1, helpful for Question 2 (if you give it context), and only a starting point for Question 3 (which requires your professional judgment and knowledge of the specific business).
Common Pitfalls in AI-Assisted Analysis
Key Takeaways
This is chapter 3 of AI for Commerce & Finance (Global).
Get the full hands-on course — free during early access. Build the complete system. Your projects become your portfolio.
View course details