Financial Statement Analysis
AI-Assisted Ratio Analysis & Trend Detection
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 the industry, 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 (Position Statement)
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 "Bharat Trading Co." — a mid-size Indian trading company. The structure follows Ind AS (Indian Accounting Standards) format:
| Section | What It Includes | Example from the Data |
|---|---|---|
| Non-Current Assets | Property, plant & equipment, intangibles, long-term investments | Factory building, delivery vehicles, goodwill |
| Current Assets | Inventory, trade receivables, cash, bank balances, short-term loans | Stock-in-trade, debtors, bank balance |
| Equity | Share capital + retained earnings (reserves & surplus) | Paid-up capital of ₹50 lakh, accumulated profits |
| Non-Current Liabilities | Long-term borrowings, deferred tax | Bank term loan (₹30 lakh, 5-year tenure) |
| Current Liabilities | Trade payables, short-term borrowings, provisions, current tax | Creditors, overdraft, GST payable, salary payable |
The fundamental equation: Assets = Equity + Liabilities. If this equation does not balance, something is wrong with the data.
The Profit & Loss Statement (Income Statement)
While the balance sheet is a photograph, the P&L 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 P&L data. The flow is:
| Line Item | What It Means | Watch For |
|---|---|---|
| Revenue from Operations | Sales of goods/services (net of GST) | Is it growing year-over-year? |
| Other Income | Interest income, rent received, miscellaneous | If this is large relative to revenue, the core business may be weak |
| Cost of Goods Sold (COGS) | Purchase cost of goods sold | Rising faster than revenue? Margins are shrinking |
| Gross Profit | Revenue minus COGS | The most fundamental profitability measure |
| Operating Expenses | Salaries, rent, utilities, marketing, travel | Are these growing in line with revenue or faster? |
| EBITDA | Earnings before interest, tax, depreciation, amortization | Shows operating efficiency independent of capital structure |
| Depreciation | Non-cash charge for asset wear and tear | Relevant for capital-intensive businesses |
| Interest | Cost of borrowed funds | High interest costs relative to EBITDA signal debt stress |
| Profit Before Tax (PBT) | What the business earned before paying the government | The number most owners focus on |
| Tax | Income tax provision (current + deferred) | Effective tax rate should be close to the statutory rate |
| Profit After Tax (PAT) | The bottom line — what is actually left for the owners | The ultimate measure of profitability |
Key Financial Ratios
Ratios turn raw numbers into meaningful comparisons. Instead of saying "the company has ₹80 lakh in current assets," you say "the current ratio is 1.6, which means for every ₹1 of short-term debt, the company has ₹1.60 in short-term assets." That is far more useful.
Here are the ratios every commerce student and accountant should know:
Liquidity Ratios (Can the business pay its short-term debts?)
| Ratio | Formula | What It Tells You | Healthy Range |
|---|---|---|---|
| Current Ratio | Current Assets ÷ Current Liabilities | Can the business meet its short-term obligations? | 1.5 - 2.5 |
| Quick Ratio | (Current Assets − Inventory) ÷ Current Liabilities | Same as above, but excludes inventory (which may not sell quickly) | 1.0 - 1.5 |
| Cash Ratio | Cash & Bank ÷ Current Liabilities | Can it pay debts with cash right now? | 0.2 - 0.5 |
Profitability Ratios (Is the business earning enough?)
| Ratio | Formula | What It Tells You | Healthy Range |
|---|---|---|---|
| Gross Margin | Gross Profit ÷ Revenue × 100 | How much profit is left after direct costs? | Industry-dependent (20-60%) |
| Net Margin | PAT ÷ Revenue × 100 | How much of every rupee of revenue becomes profit? | 5-20% for most industries |
| Return on Equity (ROE) | PAT ÷ Shareholders' Equity × 100 | What return are owners getting on their investment? | 15-25% is strong |
| Return on Capital Employed (ROCE) | EBIT ÷ (Total Assets − Current Liabilities) × 100 | How efficiently is the business using all its capital? | 15-30% |
Leverage Ratios (How much debt is the business carrying?)
| Ratio | Formula | What It Tells You | Healthy Range |
|---|---|---|---|
| Debt-to-Equity | Total Debt ÷ Shareholders' 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) |
| Debtors Turnover | Credit Sales ÷ Average Trade Receivables | How quickly customers are paying | 6-12 times (30-60 days) |
| Creditors Turnover | Credit Purchases ÷ Average Trade Payables | How quickly the business pays its suppliers | 4-8 times (45-90 days) |
Open data/ratio-benchmarks.json — this file contains industry-average ratios for 10 Indian industries (trading, manufacturing, IT services, FMCG, pharmaceuticals, textiles, construction, hospitality, logistics, and agriculture). Comparing your calculated ratios against these benchmarks tells you whether the business is performing above or below its industry peers.
How AI Automates Ratio Analysis
Instead of manually extracting numbers from financial statements and punching them into a calculator, you give AI the data and ask specific questions.
The Basic Approach
Naive prompt (do not do this): "Analyze this balance sheet."
Why it fails: Too vague. AI will give you a generic overview that you could have written yourself.
Better prompt: "Using the balance sheet data for FY26 from Bharat Trading Co., calculate these ratios: current ratio, quick ratio, debt-to-equity ratio, and return on equity. For each ratio, show the formula, the numbers you used, the result, and a one-sentence interpretation. Compare each result with the industry benchmark for trading companies."
This prompt tells AI exactly what to calculate, what format to use, and what benchmark to compare against. The output is immediately useful — you can paste it into a report or share it with a client.
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 Bharat Trading Co. 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."
AI can spot patterns that busy accountants miss — like a gradually declining gross margin that suggests the business is facing pricing pressure, or a steadily improving current ratio that signals better working capital management.
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).
Generating Management Reports
Once you have the ratios and trends, AI can draft the management summary that would normally take you an hour to write.
Prompt: "Based on the 3-year financial analysis of Bharat Trading Co., write a 250-word management summary for the board of directors. Use professional but accessible language. Highlight: (1) overall financial health assessment, (2) key strengths, (3) areas of concern, (4) two specific recommendations for the next financial year. Use Indian business context and INR figures."
The key is to review and customize the AI draft. Add details only you know — maybe the revenue decline in Q3 FY26 was because a major customer delayed orders due to their own cash crunch, or the increase in inventory is deliberate because management expects a price rise in raw materials. These context-specific insights transform a generic report into a valuable advisory document.
Common Pitfalls in AI-Assisted Analysis
Key Takeaways
This is chapter 3 of AI for Commerce & Finance.
Get the full hands-on course — free during early access. Build the complete system. Your projects become your portfolio.
View course details