Skip to content

Preparing statements for analysis

An analyst's framework

Five questions that structure any analysis — and a first look at Rawdah Home Retail Co.

14 minintermediateFree lesson

Learning objectives

  • Structure an analysis around growth, profitability, efficiency, risk and cash
  • Calculate one headline metric for each lens from a set of statements
  • Identify which lens raises the most important question for a company

A set of accounts holds hundreds of numbers. Analysts who start by calculating every ratio they know end up with a long table and no conclusion. A lender, an investor and a CFO all need the same thing: a short list of questions, answered with evidence.

Throughout this track you'll analyse one company: Rawdah Home Retail Co., a fictional home-furnishings retailer. Its three years of statements (FY2023–FY2025, SAR millions) balance and reconcile exactly, so every ratio you build ties back to the accounts. By the final lesson you'll have built a complete analysis and reached a conclusion.

Five lenses cover almost every analysis:

  1. Growth — is the business getting bigger, and is the growth healthy?
  2. Profitability — how much of each riyal of sales becomes profit, and how much capital does it take?
  3. Efficiency — how hard do assets and working capital work?
  4. Risk — can the company meet its obligations: liquidity in the short term, leverage in the long term?
  5. Cash — do profits turn into cash, and where does the cash go?

Each lens has a few core ratios, which the rest of this track covers in detail. The skill is to read them together, across time (trend) and against peers (benchmark).

How the lenses connect. The lenses are not independent. Growth needs stock, customer credit and new stores (efficiency); if operations don't generate enough cash to pay for them (cash), borrowing fills the gap (risk); and the interest on that borrowing comes out of profit (profitability). So a practitioner reads the lenses as a loop, not a checklist, and looks for the lens that disagrees with the others.

A credit analyst reviewing a retailer's annual accounts typically starts with exactly this pass: one headline number per lens, three years side by side, before calculating anything detailed. The first pass doesn't produce the answer; it produces the question worth an afternoon of work. The detailed tools follow in this track: common-size and trend analysis next, then margins, returns, working capital, leverage, cash flow and earnings quality, and finally peers, the lender's view and a full case.

Three headline metrics

Growth = Revenueₜ ÷ Revenueₜ₋₁ − 1 Margin = Profit measure ÷ Revenue Net debt = Debt − Cash

t, t−1
the current and the prior year
Profit measure
gross profit, EBITDA, EBIT or net income, depending on the question
Net debt
borrowings less cash; negative means a net cash position
Calculation
Exercise 1

Calculate

Rawdah's revenue was 1,386.0 in FY2024 and 1,497.0 in FY2025 (SAR millions). What was revenue growth in FY2025? Give a percentage to two decimal places.

Concept check
Exercise 2

Check your understanding

In FY2025 Rawdah grew revenue 8.0% and earned net income of 95.2, but cash from operations was only 83.0, inventory grew 18.4% and net debt rose to 267.5. Which question should the analysis prioritise?

Select one answer
Worksheet
Exercise 3

Challenge: Rawdah's five-lens dashboard

Using the FY2024 and FY2025 figures (SAR millions), calculate one FY2025 metric for each lens in C10:C14. Link every formula to the data — no typed numbers.

0/5 cells entered · Ctrl+. jumps to the next empty cell
C10
ABC
1Rawdah, SAR mFY2024FY2025
2Revenue1,386.01,497.0
3Inventory (year-end)226.6268.4
4EBITDA187.1
5Net income95.2
6Cash from operations83.0
7Debt355.0
8Cash87.5
9LensMetricFY2025
10GrowthRevenue growth
11ProfitabilityEBITDA margin
12EfficiencyInventory growth
13CashCFO ÷ net income
14RiskNet debt (SAR m)
InputYou build (dashed while empty)Given, lockedFY2025 · Growth

You're learning as a guest — exercises are checked, but progress isn't saved. Create a free account to keep it.