Financial Analysis Report Example: Ratio Analysis of a FTSE 100 Company

Executive Summary

This report analyses the financial performance and position of Albion Retail Group plc (ARG), a representative FTSE 100 general retailer, for the two financial years ended 31 January 2023 and 31 January 2024. ARG and its results are fictional and have been constructed purely to illustrate the technique of ratio analysis; the figures should not be read as those of any real listed company. Drawing on the company’s summarised income statement and statement of financial position, the report calculates and interprets ratios across five families: profitability, liquidity, efficiency, gearing and investor returns.

The findings indicate that ARG improved its headline profitability over the period. The operating margin rose from 7.2% to 7.5% and return on capital employed (ROCE) increased from 14.3% to 14.8%, while revenue grew by 5.3% and outpaced the growth in the cost of sales. Liquidity remained tight, as is typical of a high-volume retailer: the current ratio stood at 1.03 and the quick ratio at 0.39 in 2024, both close to the prior year. Gearing was moderate, with a debt-to-equity ratio of 54% and interest cover of 7.8 times, which suggests that borrowings are comfortably serviced. Investor ratios were broadly stable, with earnings per share (EPS) of 30.75 pence and a dividend yield of 3.0%.

Overall, the analysis concludes that ARG is a profitable, cash-generative business operating a conventional retail working-capital model. The principal watch points are the thin quick ratio and the reliance on supplier financing. The report recommends continued margin discipline, cautious management of gearing and closer monitoring of inventory to protect liquidity.

Introduction

Ratio analysis is one of the most widely used techniques for interpreting a set of financial statements. By expressing one figure as a proportion of another, ratios convert the absolute numbers in the accounts into comparable measures that can be tracked over time and set against competitors or sector norms (Atrill and McLaney, 2019). This report demonstrates how a structured programme of ratios can be used to assess the performance, position and prospects of a large listed retailer, and how the resulting evidence can be organised into clear conclusions and recommendations.

Company Background and Report Objectives

Albion Retail Group plc is presented here as a FTSE 100 constituent that operates a national chain of general-merchandise and food stores, supported by a growing online channel. For the purposes of this worked example, it competes in a mature, price-sensitive market characterised by high sales volumes, low unit margins and rapid inventory turnover. The objectives of the report are to: (1) calculate a representative set of financial ratios from ARG’s reported accounts; (2) interpret those ratios in the context of the retail sector; (3) identify the key strengths and risks revealed by the analysis; and (4) make evidence-based recommendations for the board and for prospective investors. The report is intended as a model of analytical method and should be read as reference material, not as advice on any actual investment.

Scope and Structure

The analysis covers the two most recent financial years, which allows trends to be identified while keeping the discussion focused. It draws on the summarised income statement and statement of financial position reproduced in the findings section. Following this introduction, the report sets out its methodology, presents the underlying financial statements, calculates and comments on each group of ratios in turn, discusses the results as a whole, acknowledges the limitations of the technique, and closes with recommendations and a conclusion.

Methodology and Approach

The report adopts a quantitative, ratio-based approach grounded in the conventions of financial statement analysis described by Elliott and Elliott (2022) and Robinson et al. (2020). Ratios are grouped into five families – profitability, liquidity, efficiency (or activity), gearing (or solvency) and investor ratios – because each family answers a distinct question about the business. Profitability ratios ask how effectively the company converts sales and capital into profit; liquidity ratios ask whether short-term obligations can be met; efficiency ratios examine how well working capital and assets are managed; gearing ratios assess financial risk and the balance between debt and equity; and investor ratios translate performance into measures that matter to shareholders.

Each ratio has been calculated directly from the figures in the summarised accounts, and the formula used is stated alongside the result so that the calculations are transparent and reproducible. Where a ratio can be defined in more than one way – gearing being the clearest example – the definition applied is made explicit. Two forms of comparison are used throughout. Trend analysis compares the 2024 result with 2023 to reveal the direction of travel, while benchmark analysis compares ARG’s ratios with illustrative sector norms. The sector figures quoted are indicative teaching benchmarks rather than audited market data, and they are used only to give the reader a sense of what a typical retail ratio might look like.

The data are taken from a single source, ARG’s own financial statements, so the internal consistency of the figures is assured even though the usual caveats about reported accounts still apply. To support meaningful comparison, each ratio is calculated on the same basis in both years, and closing balances rather than averages of opening and closing balances have been used throughout, so that every figure can be reproduced directly from the two statements presented. Results have been rounded to one or two decimal places for readability, which means that recalculating a ratio from the rounded inputs may occasionally produce a figure that differs very slightly from the one shown.

Several deliberate simplifications have been made. The accounts are condensed, taxation is treated as a single line, and non-recurring items are ignored. These choices keep the focus on method; the limitations section returns to their implications.

Findings: Summary Financial Statements

The ratios that follow are derived from the condensed financial statements set out below. All amounts are stated in millions of pounds sterling (£m) unless otherwise indicated, and all figures are illustrative.

Table 1 – Summarised Income Statement (£m)

Table 2 – Summarised Statement of Financial Position (£m)

For the investor ratios it is further assumed that ARG had 2,000 million ordinary shares of 25 pence in issue throughout both years, that the year-end share price was 410 pence in 2024 and 365 pence in 2023, and that total ordinary dividends declared were £246m in 2024 and £220m in 2023. Capital employed, used in the ROCE calculation, is taken as total assets less current liabilities: £6,270m in 2024 (8,470 − 2,200) and £5,960m in 2023 (8,050 − 2,090).

Ratio Analysis

The five sections below present each family of ratios in a results table, state the formula applied, and interpret the figures in both trend and benchmark terms.

Profitability Ratios

ARG’s profitability strengthened modestly across the period. The gross margin rose by half a percentage point to 33.0%, because the cost of sales grew more slowly than revenue (4.5% against 5.3%), implying some combination of better buying terms, a richer sales mix or reduced markdown activity. Although operating expenses increased by 6.4%, slightly faster than revenue, the stronger gross profit meant that operating profit climbed by 9.4% and the operating margin edged up to 7.5%. For a general retailer, a single-digit operating margin is normal: the sector earns its returns from volume and asset efficiency rather than from high margins on each sale. ROCE of 14.8% comfortably exceeds the kind of weighted average cost of capital a large listed retailer would typically face, which indicates that the company is creating value for its providers of long-term finance (Watson and Head, 2019). The gap between ROCE and ROE reflects the modest contribution of gearing, discussed further below.

Liquidity Ratios

At first sight ARG’s liquidity looks weak. The current ratio of 1.03 is well below the figure of around 1.5 to 2.0 often cited in textbooks, and the quick ratio of 0.39 shows that liquid assets cover only about two-fifths of current liabilities (Weetman, 2019). Interpreted in context, however, these figures are characteristic of a successful food and general retailer rather than a warning sign. Such businesses hold large volumes of inventory that sell quickly for cash, generate very little in trade receivables, and fund much of their stock through supplier credit. The low quick ratio is therefore a structural feature of the operating model, not evidence of distress. The important observation for the analyst is the stability of these ratios year on year: liquidity has held steady, so there is no deterioration to raise concern. Even so, because the margin of cover is slim, the company has limited room for a shock to sales or a tightening of supplier terms, a point revisited in the recommendations.

Efficiency and Working Capital Ratios

The efficiency ratios reinforce the picture of a classic retail working-capital cycle. Inventory is held for roughly 62 days, receivables are collected in about nine days (reflecting predominantly cash and card sales), and suppliers are paid after approximately 78 days. Combining these gives a cash conversion cycle of about −6.6 days in 2024 (62.2 + 9.1 − 77.9) and −7.5 days in 2023. A negative cycle is a notable strength: suppliers effectively finance the company’s working capital, so growth releases rather than consumes cash (Arnold and Lewis, 2019). The small lengthening of the inventory period, from 60.8 to 62.2 days, is worth watching, as slower-moving stock ties up cash and raises the risk of markdowns, but the movement is marginal. Asset turnover held firm at 1.47 times, meaning the company generated £1.47 of sales for every pound of assets, which is consistent with an efficient, asset-light use of its store and logistics base.

Gearing and Solvency Ratios

Gearing is moderate and improving. On a debt-to-equity basis, borrowings fell from 56.9% to 54.3% of equity, and on the alternative debt-to-capital measure they represent just over a third of long-term finance. The reduction arises because retained earnings grew the equity base faster than borrowings increased. Interest cover of 7.8 times shows that operating profit is almost eight times the finance charge, giving a substantial cushion against a fall in earnings or a rise in interest rates (Brealey, Myers and Allen, 2020). A moderate level of debt is generally considered prudent for a retailer, because the sector is sensitive to the economic cycle and heavy fixed financing costs can magnify the effect of a downturn. ARG’s position suggests that financial risk is well controlled and that the company retains the capacity to borrow should it wish to fund further investment.

Investor Ratios

From a shareholder’s perspective, ARG delivered steady progress. EPS rose by 9.4% to 30.75 pence, mirroring the growth in profit for the year, and the dividend per share increased in line, so the dividend yield held at 3.0%. Dividend cover of 2.5 times means that earnings are two and a half times the amount distributed, leaving ample profit to reinvest and providing a buffer that makes the payout sustainable (Atrill and McLaney, 2019). The price/earnings ratio of 13.3 indicates that investors were willing to pay about thirteen times current earnings for the shares; a P/E at this level is consistent with a mature business expected to grow steadily rather than rapidly. Taken together, the investor ratios portray a dependable income stock with modest but reliable growth, which is likely to appeal to income-oriented investors.

Analysis and Discussion

Viewed as a whole, the ratios tell a coherent story. ARG is a high-volume, low-margin retailer that generates attractive returns on capital by using its asset base efficiently and by financing a large part of its working capital through suppliers. The relationship between the profitability measures can be made explicit through a DuPont decomposition, which breaks return on equity into three drivers: net profit margin, asset turnover and financial leverage. For 2024, a net margin of 4.9%, an asset turnover of 1.47 times and an equity multiplier of 2.19 (total assets of £8,470m divided by equity of £3,870m) multiply together to give an ROE of approximately 15.9%. The decomposition confirms that ARG’s returns rest primarily on turnover and operating efficiency rather than on high margins or aggressive borrowing, which is exactly what one would expect of a well-run general retailer.

Setting the results against the illustrative sector benchmarks used in this report sharpens the interpretation. ARG’s operating margin of 7.5% and ROCE of 14.8% both sit a little above the notional sector averages of roughly 6% and 12% respectively, which positions the company as an above-average performer on profitability. Its current ratio of 1.03 is broadly in line with a benchmark of about 1.1 for food-led retailers, confirming that its slim liquidity is a sector norm rather than a company-specific weakness. Gearing, at just over a third of capital employed, is a touch below a typical benchmark of around 40%, reinforcing the view that ARG is conservatively financed. Benchmarking in this way guards against drawing conclusions from a single company’s numbers in isolation, although the comparison is only as good as the benchmarks chosen.

The trend across the two years is gently positive on almost every measure: margins widened, ROCE improved, gearing eased and earnings grew. The one area that calls for attention is liquidity. The thin quick ratio and the negative cash conversion cycle are strengths in normal trading, but they leave little slack if sales were to fall or if suppliers were to shorten their credit terms. The slight lengthening of the inventory period is an early signal worth monitoring for the same reason. None of this undermines the overall conclusion that the business is financially sound; rather, it identifies where management should concentrate its risk management.

Limitations of Ratio Analysis

Although ratio analysis is a powerful tool, its conclusions must be treated with care. First, ratios are only as reliable as the accounts from which they are drawn. Financial statements are prepared under historic cost conventions and are not adjusted for inflation, so comparisons over longer periods can be distorted (Elliott and Elliott, 2022). Second, differences in accounting policy – for example, in depreciation methods or in the treatment of leases – can make comparisons between companies misleading, even within the same sector. Third, a single year-end balance sheet may not represent the position during the year, and the practice sometimes called window dressing can flatter liquidity ratios on the reporting date. Fourth, ratios describe symptoms rather than causes: a falling margin tells the analyst that something has changed, but not why, so ratios should prompt further investigation rather than substitute for it. Finally, the benchmarks used in this report are illustrative, and ratios ignore important qualitative factors such as brand strength, management quality, the competitive environment and economic conditions. For these reasons, the analysis above should be seen as one input to a judgement, complemented by the narrative in the annual report and by wider market information.

Recommendations

On the basis of the analysis, the following recommendations are made for the board and for prospective investors.

1. Protect and extend the margin gains. The improvement in gross and operating margins should be consolidated through continued discipline over buying terms and operating costs, while guarding against the temptation to chase volume with discounting that would erode the gains.
2. Monitor inventory closely. The lengthening inventory period should be reversed or at least contained, because slower stock turnover ties up cash and increases markdown risk. Tighter range management and stronger demand forecasting would help.
3. Preserve the liquidity buffer. Given the slim quick ratio, management should maintain committed borrowing facilities and avoid any material shortening of supplier payment terms, so that the business can absorb a trading shock.
4. Keep gearing moderate. With interest cover comfortable and gearing falling, the company has the capacity to fund investment from a mix of retained earnings and modest additional debt, but it should resist a sharp increase in leverage that would raise financial risk in a cyclical sector.
5. For investors, ARG presents as a stable, income-generating holding with sustainable dividend cover; it is better suited to an income-focused strategy than to investors seeking rapid capital growth.

Conclusion

This report has applied ratio analysis to the summarised accounts of Albion Retail Group plc, a representative FTSE 100 retailer, across two financial years. The evidence shows a profitable and well-managed business: margins and returns on capital improved, the company operates an efficient working-capital cycle in which suppliers help to fund its stock, gearing is moderate and falling, and shareholder returns are modest but dependable. The principal area for vigilance is liquidity, where structurally low ratios, although normal for the sector, leave limited headroom against adverse trading conditions. The analysis also underlines that ratios must be read in context and alongside qualitative information, since they reveal patterns rather than explain them. Used in this disciplined way, ratio analysis provides a clear and defensible basis for assessing performance, identifying risk and informing both management decisions and investment judgements. As a model answer, the report illustrates how financial data can be organised, calculated transparently and interpreted into actionable conclusions at undergraduate level.

References

• Arnold, G. and Lewis, D. (2019) Corporate Financial Management. 6th edn. Harlow: Pearson.
• Atrill, P. and McLaney, E. (2019) Accounting and Finance for Non-Specialists. 11th edn. Harlow: Pearson.
• Brealey, R.A., Myers, S.C. and Allen, F. (2020) Principles of Corporate Finance. 13th edn. New York: McGraw-Hill Education.
• Elliott, B. and Elliott, J. (2022) Financial Accounting and Reporting. 20th edn. Harlow: Pearson.
• Financial Reporting Council (2022) FRS 102: The Financial Reporting Standard Applicable in the UK and Republic of Ireland. London: FRC.
• Penman, S.H. (2013) Financial Statement Analysis and Security Valuation. 5th edn. New York: McGraw-Hill.
• Robinson, T.R., Henry, E., Pirie, W.L. and Broihahn, M.A. (2020) International Financial Statement Analysis. 4th edn. Hoboken, NJ: Wiley.
• Watson, D. and Head, A. (2019) Corporate Finance: Principles and Practice. 8th edn. Harlow: Pearson.
• Weetman, P. (2019) Financial and Management Accounting: An Introduction. 8th edn. Harlow: Pearson.