CACI-U5-L14 · Canadian Accounting Common Core I
Financial statement analysis and integrated case
Learning goals
- Perform horizontal, vertical, ratio, and cash-flow analysis.
- Calculate and interpret liquidity, activity, profitability, and solvency measures.
- Connect ratios to accounting policies, estimates, and business conditions.
- Detect incentives for misstatement and test the underlying records.
- Write a balanced recommendation with limitations and next evidence.
Prerequisite check
- Can rising revenue coexist with falling gross-margin percentage? Give a cause.
- Why might operating cash flow be below profit during rapid growth?
Vocabulary
- Horizontal analysis: change over time in dollars and percentages.
- Vertical/common-size analysis: each statement item as a base amount, such as sales or total assets.
- Current ratio: current assets ÷ current liabilities.
- Gross margin percentage: gross profit ÷ revenue.
- Profit margin: net income ÷ revenue.
- Turnover ratio: flow for a period ÷ relevant average balance.
- Return on assets (ROA): profit measure ÷ average total assets; definitions vary.
- Debt ratio: total liabilities ÷ total assets.
- Quality of earnings: extent to which reported performance is supported by sustainable operations, cash, and credible measurement.
Core idea
No ratio speaks alone. Use a chain:
Business event → accounting treatment → statement amount → ratio → decision.
Compare several periods, budgets, peers with similar policies, and non-financial drivers. Read notes. A ratio may change because operations changed, accounting estimates changed, a denominator moved near zero, or an item was misclassified.
Why this treatment makes sense
Ratios compress information and reveal patterns, but compression loses detail. A current ratio can improve because obsolete inventory rises. ROA can look high because old assets are heavily depreciated. A growing company may have weak operating cash while building valid receivables—or while recording poor-quality sales. Analysis must generate targeted follow-up questions.
A repeatable method
Use CONTEXT–COMPUTE–CONNECT–CHALLENGE–CONCLUDE:
- Context: user, business model, seasonality, framework, policies, and period.
- Compute: show formulas, average balances, units, and consistent definitions.
- Connect: combine liquidity, activity, profitability, solvency, and cash evidence.
- Challenge: inspect notes, estimates, unusual entries, cut-off, and incentives.
- Conclude: state what evidence suggests, what it does not prove, and the next action.
Worked example
Selected data for North Star Wholesale (in $000s):
| Measure | Year 1 | Year 2 |
|---|---|---|
| Revenue | $400 | $460 |
| COGS | 240 | 299 |
| Net income | 32 | 27.6 |
| Operating cash flow | 40 | 18 |
| Current assets | 100 | 112 |
| Current liabilities | 50 | 70 |
| Total assets, ending | 240 | 300 |
| Total liabilities, ending | 120 | 170 |
| Average assets | 200 | 260 |
| Average equity | 100 | 120 |
| Average A/R | 40 | 57.5 |
| Average inventory | 60 | 78 |
Analysis:
| Metric | Year 1 | Year 2 | Signal/question |
|---|---|---|---|
| Revenue growth | — | 15.0% | Strong volume/price growth; is it collected? |
| Gross margin % | 40.0% | 35.0% | Price pressure, mix, cost, shrinkage, or cut-off? |
| Profit margin | 8.0% | 6.0% | Revenue growth did not reach bottom line |
| Current ratio | 2.00 | 1.60 | Lower short-term cushion; composition matters |
| A/R turnover | 10.00x | 8.00x | Collection slowed |
| Approx. collection days | 36.5 | 45.6 | Verify terms, aging, and returns |
| Inventory turnover | 4.00x | 3.83x | Slight slowdown; inspect obsolete stock |
| ROA | 16.0% | 10.62% | Added assets produced weaker current return |
| Debt ratio | 50.0% | 56.67% | More assets financed by liabilities |
| Operating cash / net income | 1.25x | 0.65x | Year 2 profit less supported by current cash |
Conclusion: Year 2 grows but has weaker margins, collection, liquidity, leverage, return, and profit-to-cash conversion. This does not prove manipulation. Request A/R aging, customer concentration/returns, inventory aging/count results, gross-margin by product, debt terms, and three-to-five-year cash trends.
Journal, ledger, and statement connection
Suppose a $15,000 year-end inventory purchase and payable were omitted to keep a 1.50 current-ratio covenant. Before correction, current ratio is $112,000/ $70,000 = 1.60. If goods were received and controlled, correcting Dr Inventory / Cr A/P $15,000 makes it $127,000/$85,000 = 1.494. A balanced omission can therefore hide covenant risk. Trace receiving reports just before/after year-end to invoices and the purchases ledger.
Common mistakes
- Using ending rather than average assets for a turnover/return ratio without disclosing it.
- Comparing entities with different industries, seasons, frameworks, or policies as if identical.
- Saying a higher current ratio is always better.
- Treating correlation as cause: slower turnover does not prove obsolete stock.
- Ignoring signs, units, negative denominators, or one-time items.
- “Normalizing” an inconvenient expense without evidence and consistent criteria.
- Recommending credit solely from ratios without debt terms, forecasts, collateral, governance, and qualitative risk.
Guided practice
A retailer has revenue $600,000, COGS $390,000, net income $42,000, average A/R $50,000, average assets and ending assets both $350,000, average inventory $75,000, current assets $140,000, current liabilities $100,000, liabilities $210,000, and operating cash $34,000. Compute gross margin %, profit margin, A/R turnover and days, inventory turnover, ROA, current ratio, debt ratio, and operating cash/net income.
Independent practice
Analyze two years for Clearwater Services:
| Measure | Prior | Current |
|---|---|---|
| Revenue | $750,000 | $840,000 |
| Net income | 60,000 | 58,800 |
| Operating cash | 66,000 | 39,000 |
| Current assets | 180,000 | 205,000 |
| Current liabilities | 90,000 | 128,000 |
| Average A/R | 75,000 | 105,000 |
| Average assets | 400,000 | 470,000 |
| Ending liabilities | 220,000 | 295,000 |
| Ending assets | 440,000 | 510,000 |
Compute revenue growth, margins, current ratios, A/R turnover/days, ROA, debt ratio, and cash/profit. Write a five-sentence lender memo: two strengths, three risks, one non-conclusion, and three evidence requests.
Self-check and solutions
Guided: Gross margin 35.0%; profit margin 7.0%; A/R turnover 12.0x and days 30.4; inventory turnover 5.2x; ROA 12.0%; current ratio 1.40; debt ratio 60.0%; operating cash/net income 0.81x. Interpretation must connect measures: profitable, but relatively leveraged and current cash conversion merits follow-up.
Independent: Revenue growth 12.0%. Profit margins: 8.0% prior, 7.0% current. Current ratios: 2.00 and 1.60. A/R turnover: 10.0x and 8.0x; days 36.5 and 45.6. ROA: 15.0% and 12.51%. Debt ratio: 50.0% and 57.84%. Cash/profit: 1.10x and 0.66x. A strong memo notes revenue remains a strength and current assets still exceed current liabilities, but margin, collection, liquidity, return, leverage, and cash conversion worsened. Ratios do not prove default or misstatement. Request aging/credit terms, debt maturity/covenants, and cash forecast.
Retrieval practice
- State five ratio categories and one measure in each.
- Why use average balances in turnover ratios?
- Give two benign and two concerning reasons A/R days rise.
- Recite the five-step analysis method.
Exam-style application
A company delays a valid $20,000 supplier invoice for inventory received at year-end. Before correction, current assets are $150,000 and current liabilities $100,000. Explain the entry and calculate current ratio before and after.
Target: Dr Inventory / Cr A/P $20,000. Before 1.50; after $170,000/$120,000 = 1.417. The omission leaves profit unchanged initially if inventory remains unsold, but understates assets and liabilities and misleadingly improves the ratio. If goods were sold, COGS/profit effects also arise.
Lesson summary
Analysis combines trends, common-size data, ratios, cash, notes, and business evidence. Compute consistently, trace suspicious amounts to records, and state both the signal and its limits.