Skip to content
Tutorials Center
My learning

Topics

Lesson 37 of 37 ยท Projects and Practice

Project: Ratio Analysis Report

Write a ratio analysis of a small company over two years: compute profitability, liquidity, efficiency and gearing ratios in code, then interpret what changed and why.

Analysts write short reports that turn statements into a story: what changed, why, and what should we ask next? In this project you analyze a fictional company, Northern Outdoors, over two years. All figures are invented.

The data

Year 1 Year 2
Net sales 400,000 470,000
Cost of goods sold 240,000 290,000
Operating expenses 120,000 135,000
Interest expense 6,000 8,000
Tax rate 20% 20%
Inventory (closing) 40,000 70,000
Receivables 50,000 90,000
Cash 20,000 10,000
Property and equipment (net) 150,000 170,000
Payables 30,000 35,000
Bank loan 60,000 90,000

Opening inventory in year 1 was $30,000; in year 2 it equals year 1 closing. Treat payables as the only current liability, and all sales as credit sales.

Step 1: compute the ratios

Python Two-year ratio table

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Run it and note which ratios moved most. Before you read on, write down your own interpretation.

Step 2: look for the story

The computation above reveals a pattern worth discussing (check it against your output):

  • Sales grew 17.5% (470,000 / 400,000 โˆ’ 1) and profit rose, but the gross margin slipped from 40.0% in year 1 to 38.3% in year 2, so the cost of goods grew faster than sales.
  • Working capital absorbed cash. Inventory rose from 40,000 to 70,000 and receivables from 50,000 to 90,000, while cash fell from 20,000 to 10,000. Receivable days lengthened from about 45.6 to about 69.9.
  • Borrowing increased. The loan rose by 30,000 and interest cover fell.
  • Liquidity looks better on paper (the current ratio rose from 3.67 to 4.86), but the quality is weaker: the rise comes from stock and unpaid invoices while cash halved.

Step 3: test one explanation

Suppose management says the extra sales came from offering longer credit terms. Test what would happen if year 2 receivable days had stayed at year 1 levels.

Python What if customers still paid in 45.6 days?

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Roughly $31,000 is tied up because customers pay more slowly, about the size of the $30,000 extra loan. That is a hypothesis to test, not a proven cause: ask management for the credit terms and the ageing schedule (bad debts and ageing).

Step 4: write the report

A good short report has four parts:

  1. Headline: one sentence on overall performance.
  2. Evidence: three to five ratios with the numbers.
  3. Explanation: possible causes, labelled as possibilities.
  4. Questions and recommendations: what to check next.

Example headline: "Northern Outdoors grew sales 17.5% in year 2, but cash fell and borrowing rose because customers took longer to pay and inventory increased."

Your extensions

  • Add asset turnover and the cash conversion cycle (efficiency ratios).
  • Compute EPS if there are 50,000 shares (investor ratios).
  • Imagine a year 3 with receivables back at 45 days and see what happens to cash.

Check your understanding

Quick check ยท 3 questions

of 3 answered You scored / 3 ยท perfect!

  1. 1. Sales rise while cash falls and receivables rise sharply. What is the most likely explanation to investigate?

    Higher receivables tie up cash, so credit terms and collection are the first places to look.
  2. 2. Why is a ratio report better with two years of data than one?

    Comparison reveals whether performance is improving or deteriorating.
  3. 3. What should a report do with a possible cause it cannot prove?

    Ratios suggest questions; further evidence confirms causes.

Summary

  • Compute ratios for several years, then compare trends.
  • Look for linked changes: sales, receivables, inventory, cash and borrowing move together.
  • Treat explanations as hypotheses and test them with extra data.
  • A clear report states the headline, evidence, possible causes and next questions.

You have finished this track. Return to the Financial Accounting track page.