Study guide
11.1 Profitability & Return on Capital Employed
AAT Level 3 Diploma in Accounting Q2022
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Accounting Principles & Ethical Framework
1.1 Fundamental Accounting Concepts & Assumptions 1.2 Regulatory Framework & IAS/IFRS Terminology 1.3 Professional Ethics & the AAT Code of Conduct
2 Chapter 2: Advanced Double-Entry Bookkeeping & Control Accounts
2.1 Capital vs. Revenue Expenditure & Prime Entry Books 2.2 Control Accounts & Reconciliation Procedures 2.3 Period-End Routines, Verification & Accounting Software
3 Chapter 3: Accounting Errors & The Suspense Account
3.1 Types of Accounting Errors & Trial Balance Impact 3.2 Correcting Errors & Clearing the Suspense Account
4 Chapter 4: Non-Current Assets: Acquisition, Register & Disposal
4.1 Capitalising Non-Current Assets & The Asset Register 4.2 Disposal of Non-Current Assets & Part-Exchange
5 Chapter 5: Depreciation Methods & Accounting Entries
5.1 Straight-Line & Reducing Balance Depreciation 5.2 Depreciation Accounting Policies & Journal Entries
6 Chapter 6: Period-End Adjustments: Accruals, Prepayments & Inventory
6.1 Accrued & Prepaid Expenses and Income 6.2 Closing Inventory Valuation & IAS 2 Rules
7 Chapter 7: Period-End Adjustments: Irrecoverable Debts & Allowances
7.1 Writing Off Irrecoverable Debts & Debt Recovery 7.2 Allowance for Doubtful Receivables 7.3 Professional Scepticism, Ethics & Period-End Pressures
8 Chapter 8: The Extended Trial Balance (ETB)
8.1 Trial Balance Structure & Initial Preparation 8.2 Recording Adjustments & Completing the Extended Trial Balance
9 Chapter 9: Financial Statements: Sole Traders
9.1 Sole Trader Statement of Profit or Loss 9.2 Sole Trader Statement of Financial Position
10 Chapter 10: Financial Statements: Partnerships
10.1 Partnership Principles & The Partnership Act 1890 10.2 Partnership Appropriation Account & Capital/Current Accounts
11 Chapter 11: Financial Statement Analysis & Ratios
11.1 Profitability & Return on Capital Employed 11.2 Liquidity, Working Capital & Efficiency Ratios
12 Chapter 12: Incomplete Records & Reconstructing Accounts
12.1 The Capital Comparison Method & Cash/Bank Summaries 12.2 Mark-up, Margin & Account Reconstruction 12.3 Testing the Reasonableness of Reconstructed Figures
11.1 Profitability & Return on Capital Employed
Key Takeaways Explain This Topic AI
The AAT FAPS test specification names exactly four profitability ratios: return on capital employed, gross profit margin, net profit margin, and the expense/sales revenue percentage.
AAT’s ROCE formula is profit for the year divided by capital employed times 100, where capital employed equals capital plus non-current liabilities — not operating profit or PBIT.
AAT’s net profit margin is profit for the year divided by sales revenue times 100; the expense/sales revenue percentage applies the same denominator to any specified expense, including cost of sales.
Gross Profit Margin expresses gross profit as a percentage of revenue while Mark-up on Cost expresses it as a percentage of cost of sales, and the two convert using Margin = Mark-up / (1 + Mark-up).
Capital employed can always be cross-checked on the face of the Statement of Financial Position as total assets less current liabilities, which equals capital plus non-current liabilities.
Last updated: August 2026
Profitability & Return on Capital Employed
Financial statements report raw monetary amounts—revenue, costs, assets, and liabilities. However, raw monetary figures in isolation cannot reveal whether a business is operating efficiently, whether its profitability is improving or deteriorating, or how effectively management is deploying the capital entrusted to them. Financial ratio analysis bridges this gap by establishing meaningful mathematical relationships between interconnected figures across the Statement of Profit or Loss (SPL) and the Statement of Financial Position (SFP).
Within the AAT Level 3 Financial Accounting: Preparing Financial Statements (FAPS) syllabus, mastering profitability ratios and capital return metrics is essential. These metrics allow accountants, directors, investors, and lenders to benchmark performance over time ( trend analysis ) and compare businesses of differing sizes within the same industry sector ( cross-sectional analysis ).
The Four Ratios Named in the Official FAPS Test Specification
AAT's Q2022 qualification specification sets Learning Outcome 8 of this unit as "Interpret financial statements using profitability ratios" , and it prints the exact
formulas the computer-marked assessment uses. Learn these versions. A defensible
analyst's variant will produce a different percentage and will not match the marking key.
Official FAPS ratio The formula AAT states
Return on capital employed (ROCE) Profit for the year / Capital employed × 100, where capital employed = capital + non-current liabilities
- Gross profit margin Gross profit / Sales revenue × 100
- Net profit margin Profit for the year / Sales revenue × 100
Expense / sales revenue percentage Specified expense / Sales revenue × 100 (the "specified expense" may be cost of sales or any individual overhead)
Two points to commit to memory before anything else in this section:
- AAT's ROCE and net profit margin both use profit for the year — the bottom line
- of the Statement of Profit or Loss, struck after finance costs — not operating profit
and not PBIT. Many textbooks and every investment website use PBIT. FAPS does not.
- FAPS examines sole traders and partnerships , so "capital" in the ROCE denominator
- means the owner's closing capital balance. For a partnership it is total partners'
funds: the partners' capital account balances plus their current account balances.
Share capital and reserves belong to company accounts, which are a Level 4 topic.
- Sections 5 and 6 explain the PBIT-based variants as well, because you will meet them in
- employment and in Level 4 Drafting and Interpreting Financial Statements . They are
clearly labelled. Do not substitute them in a FAPS task.
1. The Objectives and Framework of Ratio Analysis
Ratio analysis serves four primary analytical objectives:
Standardising Financial Data : Eliminates size disparities so a small enterprise can be evaluated directly against a multi-million-pound competitor.
Evaluating Managerial Efficiency : Measures how effectively management controls production costs, regulates administrative overheads, and utilizes capital assets to generate revenue.
Trend & Pattern Identification : Highlights whether margins, returns, and cost structures are improving, stable, or deteriorating over consecutive accounting cycles.
Facilitating Stakeholder Decisions :
Shareholders / Owners : Assess profitability, return on investment, and dividend security.
Lenders & Creditors : Assess interest coverage, solvency, and debt repayment capability.
Management : Pinpoint operational bottlenecks, pricing deficiencies, and cost overruns.
2. Gross Profit Margin vs. Mark-up on Cost
Gross profit represents the financial surplus generated directly by core buying, manufacturing, and selling activities before deducting administrative and operational overheads. Two complementary ratios measure trading profitability:
A. Gross Profit Margin (Margin on Sales)
The Gross Profit Margin expresses gross profit as a percentage of net sales revenue: Gross Profit Margin (%) = ( Gross Profit Revenue ) × 100 \text{Gross Profit Margin (\%)} = \left( \frac{\text{Gross Profit}}{\text{Revenue}} \right) \times 100 Gross Profit Margin (%) = ( Revenue Gross Profit ) × 100
Interpretation : Represents the pence of gross profit generated for every £1.00 of sales revenue. A 35% margin indicates that £0.35 of each pound of sales is available to cover operating overheads, finance costs, taxation, and net profit.
Causes of an Increase in Gross Profit Margin :
Higher selling prices achieved without a corresponding drop in sales volume.
Negotiating bulk purchase discounts or cheaper supplier sourcing.
Favourable sales mix shift towards higher-margin product lines.
Reductions in direct labour costs, production wastage, or manufacturing scrap.
Causes of a Decrease in Gross Profit Margin :
Price cuts or higher promotional trade discounts offered to stimulate demand.
Cost inflation in raw materials, import duties, or inward carriage not passed on to customers.
Inventory write-downs to Net Realisable Value (NRV) due to damage or obsolescence (IAS 2).
Increased stock shrinkage, theft, or production wastage.
B. Mark-up on Cost
The Mark-up on Cost expresses gross profit as a percentage of the direct cost of sales: Mark-up on Cost (%) = ( Gross Profit Cost of Sales ) × 100 \text{Mark-up on Cost (\%)} = \left( \frac{\text{Gross Profit}}{\text{Cost of Sales}} \right) \times 100 Mark-up on Cost (%) = ( Cost of Sales Gross Profit ) × 100
Interpretation : Represents the percentage added on top of the cost price of goods to arrive at the selling price. A mark-up of 25% means goods costing £100 are sold for £125.
Practical Commercial Use : Widely employed in cost-plus pricing strategies across retail, wholesale, construction, and manufacturing.
3. Mathematical Conversion Between Margin and Mark-up
In accounting practice and AAT examinations, you will frequently be given sales revenue with a mark-up percentage, or cost of sales with a margin percentage, and required to calculate the missing gross profit, revenue, or cost of sales. Understanding the mathematical relationship between the two is vital.
The Fundamental Cost Structure Relationship Cost of Sales (Cost Price) + Gross Profit (Profit) = Sales Revenue (Selling Price)
When working with Mark-up , Cost of Sales is the base (100%) : Cost (100%) + Mark-up (m%) = Selling Price (100 + m)% \text{Cost (100\%)} + \text{Mark-up (m\%)} = \text{Selling Price (100 + m)\%} Cost (100%) + Mark-up (m%) = Selling Price (100 + m)%
When working with Margin , Revenue is the base (100%) : Cost (100 - g)% + Margin (g%) = Selling Price (100%) \text{Cost (100 - g)\%} + \text{Margin (g\%)} = \text{Selling Price (100\%)} Cost (100 - g)% + Margin (g%) = Selling Price (100%)
Conversion Formulas Margin = Mark-up 1 + Mark-up ⟺ Mark-up = Margin 1 − Margin \text{Margin} = \frac{\text{Mark-up}}{1 + \text{Mark-up}} \qquad \Longleftrightarrow \qquad \text{Mark-up} = \frac{\text{Margin}}{1 - \text{Margin}} Margin = 1 + Mark-up Mark-up ⟺ Mark-up = 1 − Margin Margin
The Fraction Conversion Rule
When expressed as simple fractions, converting between margin and mark-up follows a consistent pattern:
If Mark-up is 1 N \frac{1}{N} N 1 , then Margin is 1 N + 1 \frac{1}{N + 1} N + 1 1 .
If Margin is 1 N \frac{1}{N} N 1 , then Mark-up is 1 N − 1 \frac{1}{N - 1} N − 1 1 .
Master Margin / Mark-up Equivalence Table
Mark-up on Cost (Fraction) Mark-up on Cost (%) Gross Profit Margin (Fraction) Gross Profit Margin (%) Cost / Revenue Proportion
- 1 / 1 100.00% 1 / 2 50.00% Cost = 50% of Sales; Profit = 50%
- 1 / 2 50.00% 1 / 3 33.33% Cost = 66.67% of Sales; Profit = 33.33%
- 1 / 3 33.33% 1 / 4 25.00% Cost = 75% of Sales; Profit = 25%
- 1 / 4 25.00% 1 / 5 20.00% Cost = 80% of Sales; Profit = 20%
- 1 / 5 20.00% 1 / 6 16.67% Cost = 83.33% of Sales; Profit = 16.67%
- 1 / 8 12.50% 1 / 9 11.11% Cost = 88.89% of Sales; Profit = 11.11%
- 1 / 9 11.11% 1 / 10 10.00% Cost = 90% of Sales; Profit = 10%
- Worked Practical Example: Missing Inventory Calculation
Facts : A fire destroyed a warehouse on 30 November. Opening inventory was £40,000, purchases to date were £220,000, and sales revenue to date was £300,000. Goods are sold at a standard mark-up of 25% on cost .
Step 1: Convert Mark-up to Margin : Mark-up of 25 % ( 1 4 ) ⟹ Margin of 1 4 + 1 = 1 5 = 20 % \text{Mark-up of } 25\% \left(\frac{1}{4}\right) \implies \text{Margin of } \frac{1}{4+1} = \frac{1}{5} = 20\% Mark-up of 25% ( 4 1 ) ⟹ Margin of 4 + 1 1 = 5 1 = 20%
Step 2: Calculate Gross Profit and Cost of Sales : Gross Profit = 20 % × £ 300 , 000 = £ 60 , 000 \text{Gross Profit} = 20\% \times £300,000 = £60,000 Gross Profit = 20% × £300 , 000 = £60 , 000 Cost of Sales = £ 300 , 000 − £ 60 , 000 = £ 240 , 000 \text{Cost of Sales} = £300,000 - £60,000 = £240,000 Cost of Sales = £300 , 000 − £60 , 000 = £240 , 000 (Alternative check: Cost of Sales = £ 300 , 000 1.25 = £ 240 , 000 \text{Cost of Sales} = \frac{£300,000}{1.25} = £240,000 Cost of Sales = 1.25 £300 , 000 = £240 , 000 )
Step 3: Deduce Closing Inventory Destroyed : Opening Inventory (£40,000) + Purchases (£220,000) − Closing Inventory = Cost of Sales (£240,000) \text{Opening Inventory (£40,000)} + \text{Purchases (£220,000)} - \text{Closing Inventory} = \text{Cost of Sales (£240,000)} Opening Inventory (£40,000) + Purchases (£220,000) − Closing Inventory = Cost of Sales (£240,000) £ 260 , 000 − Closing Inventory = £ 240 , 000 ⟹ Closing Inventory Destroyed = £ 20 , 000 £260,000 - \text{Closing Inventory} = £240,000 \implies \mathbf{\text{Closing Inventory Destroyed} = £20,000} £260 , 000 − Closing Inventory = £240 , 000 ⟹ Closing Inventory Destroyed = £20 , 000
4. Net Profit Margin and the Expense / Sales Revenue Percentage
Gross margin measures the profitability of buying and selling. The net profit margin measures what survives once every overhead and every finance cost has been absorbed. Net Profit Margin (%) = ( Profit for the Year Sales Revenue ) × 100 \text{Net Profit Margin (\%)} = \left( \frac{\text{Profit for the Year}}{\text{Sales Revenue}} \right) \times 100 Net Profit Margin (%) = ( Sales Revenue Profit for the Year ) × 100
Numerator : profit for the year — the figure at the foot of the Statement of Profit
or Loss, after operating expenses and finance costs. This is what AAT specifies.
Interpretation : a net margin of 12% means that 12p of every £1 of sales revenue
ends up as profit for the owner.
- Read it against gross margin. If gross profit margin is flat but net profit margin
- falls, the problem is in overheads or interest, not in trading. If both fall together,
- the problem is in the trading account: selling prices, purchase costs, carriage inwards,
or an inventory write-down to net realisable value under IAS 2.
- The Expense / Sales Revenue Percentage
- The fourth official FAPS ratio identifies which cost moved. Any specified expense —
including cost of sales — is expressed against the same denominator: Expense / Sales Revenue (%) = ( Specified Expense Sales Revenue ) × 100 \text{Expense / Sales Revenue (\%)} = \left( \frac{\text{Specified Expense}}{\text{Sales Revenue}} \right) \times 100 Expense / Sales Revenue (%) = ( Sales Revenue Specified Expense ) × 100
Cost of sales as a percentage of revenue is the mirror image of gross profit margin:
if gross margin is 35%, then cost of sales is 65% of revenue, and the two must add to
100%. Use this as an instant arithmetic check on your gross margin.
Individual overhead percentages pinpoint the drift: Distribution Cost Ratio (%) = ( Distribution Costs Revenue ) × 100 \text{Distribution Cost Ratio (\%)} = \left( \frac{\text{Distribution Costs}}{\text{Revenue}} \right) \times 100 Distribution Cost Ratio (%) = ( Revenue Distribution Costs ) × 100 Administrative Expense Ratio (%) = ( Administrative Expenses Revenue ) × 100 \text{Administrative Expense Ratio (\%)} = \left( \frac{\text{Administrative Expenses}}{\text{Revenue}} \right) \times 100 Administrative Expense Ratio (%) = ( Revenue Administrative Expenses ) × 100
- Worked micro-example : revenue rises from £400,000 to £500,000 while wages rise from
- £60,000 to £80,000. In cash terms wages are "up £20,000", which sounds alarming. As a
percentage of revenue they moved from 15.00% to 16.00% — a one-point deterioration.
The percentage, not the pound movement, is the meaningful comparison.
- Diagnostic rule : if gross profit margin is unchanged but net profit margin falls,
- run the expense percentages across every overhead line. The line whose percentage rose
is the line that caused it.
- Analyst's Variant: Operating Profit Margin (Beyond FAPS)
- Outside this unit you will meet the operating profit margin , which replaces profit for
the year with operating profit (profit before interest and tax, PBIT): Operating Profit Margin (%) = ( Operating Profit (PBIT) Revenue ) × 100 \text{Operating Profit Margin (\%)} = \left( \frac{\text{Operating Profit (PBIT)}}{\text{Revenue}} \right) \times 100 Operating Profit Margin (%) = ( Revenue Operating Profit (PBIT) ) × 100
- Stripping out finance costs lets two businesses with different borrowing levels be
- compared on trading performance alone, which is why it dominates published analysis and
why it is used in AAT Level 4. It is not the formula marked in a FAPS task.
- 5. Return on Capital Employed (ROCE)
- Return on Capital Employed (ROCE) measures how much profit the business generates from
- every £1 of long-term capital tied up in it. For an owner it answers the question that
matters most: is this business a better home for my money than the alternatives?
The AAT FAPS Formula ROCE (%) = ( Profit for the Year Capital Employed ) × 100 \text{ROCE (\%)} = \left( \frac{\text{Profit for the Year}}{\text{Capital Employed}} \right) \times 100 ROCE (%) = ( Capital Employed Profit for the Year ) × 100 where Capital Employed = Capital + Non-Current Liabilities \text{where} \quad \text{Capital Employed} = \text{Capital} + \text{Non-Current Liabilities} where Capital Employed = Capital + Non-Current Liabilities
Numerator : profit for the year, taken straight from the foot of the Statement of
Profit or Loss.
Denominator for a sole trader : the proprietor's closing capital (opening capital
capital introduced + profit − drawings), plus long-term bank loans and mortgages.
- Denominator for a partnership : total partners' funds — every partner's capital
- account balance plus every partner's current account balance, remembering that an
- overdrawn current account is deducted — plus non-current liabilities, which include a
partner's long-term loan to the firm (that loan is debt, not equity: see Section 10.1).
Cross-check on the face of the SFP : capital employed is the same figure as total assets less current liabilities , the subtotal that already appears on a
vertical Statement of Financial Position. The two routes always agree because Total Assets − Current Liabilities = Capital + Non-Current Liabilities \text{Total Assets} - \text{Current Liabilities} = \text{Capital} + \text{Non-Current Liabilities} Total Assets − Current Liabilities = Capital + Non-Current Liabilities .
If your two answers differ, you have made an arithmetic error — find it before you
divide.
- Worked Example: Sole Trader ROCE on the AAT Formula
- Beacon Hill Traders, whose full financial statements were prepared in Sections 9.1 and
9.2, reported:
- Profit for the year: £60,600
- Closing capital at 31 December 20X5: £197,000
Non-current liabilities (8% bank loan repayable 20X9): £25,000 Capital Employed = £ 197 , 000 + £ 25 , 000 = £ 222 , 000 \text{Capital Employed} = £197,000 + £25,000 = \mathbf{£222,000} Capital Employed = £197 , 000 + £25 , 000 = £222 , 000 ROCE = £ 60 , 600 £ 222 , 000 × 100 = 27.30 % \text{ROCE} = \frac{£60,600}{£222,000} \times 100 = \mathbf{27.30\%} ROCE = £222 , 000 £60 , 600 × 100 = 27.30%
Cross-check : Beacon Hill's Statement of Financial Position showed "Total assets less
current liabilities" of £222,000 — the identical figure, arrived at from the asset side.
Every £1 of long-term capital in Beacon Hill produced 27.3p of profit during 20X5.
- Whether that is good is not a question the number answers on its own; it must be compared
- with last year, with a competitor in the same trade, with an industry benchmark, or with
the return the owner could earn by putting the same money elsewhere.
- Analyst's Variant: PBIT-Based ROCE (Beyond FAPS)
- Investment analysts, and AAT Level 4, use a version in which the numerator is operating
profit (PBIT) : ROCE analyst = ( Operating Profit (PBIT) Capital Employed ) × 100 \text{ROCE}_{\text{analyst}} = \left( \frac{\text{Operating Profit (PBIT)}}{\text{Capital Employed}} \right) \times 100 ROCE analyst = ( Capital Employed Operating Profit (PBIT) ) × 100
- The reasoning is that capital employed is funded by owners and long-term lenders, so the
- return should be measured before interest is paid away to the lenders — otherwise a
- business that borrows heavily looks less efficient than an identical business funded by
- equity. That is a sound argument, and for company accounts the denominator is then written
- as total equity (share capital, share premium, retained earnings and reserves) plus
- non-current liabilities. It also produces a materially different percentage . When a
FAPS task says "calculate ROCE", use profit for the year.
6. The DuPont Decomposition of ROCE (Analytical Background — Beyond FAPS)
DuPont analysis is not assessed in FAPS and it is built on the PBIT-based ROCE above rather than on AAT's formula. It is included because it explains why a return moved, which is exactly the kind of narrative comment FAPS does ask for, and because you will use it at Level 4.
Under the classic DuPont Model , ROCE is broken down into two distinct operational drivers: ROCE = Operating Profit Margin × Asset Turnover \text{ROCE} = \text{Operating Profit Margin} \times \text{Asset Turnover} ROCE = Operating Profit Margin × Asset Turnover ( Operating Profit Capital Employed ) = ( Operating Profit Revenue ) × ( Revenue Capital Employed ) \left( \frac{\text{Operating Profit}}{\text{Capital Employed}} \right) = \left( \frac{\text{Operating Profit}}{\text{Revenue}} \right) \times \left( \frac{\text{Revenue}}{\text{Capital Employed}} \right) ( Capital Employed Operating Profit ) = ( Revenue Operating Profit ) × ( Capital Employed Revenue )
Understanding Asset Turnover Asset Turnover (times) = Revenue Capital Employed \text{Asset Turnover (times)} = \frac{\text{Revenue}}{\text{Capital Employed}} Asset Turnover (times) = Capital Employed Revenue
Definition : Measures how many pounds of revenue the business generates for every £1.00 of capital employed invested in net assets.
Significance : Reflects the intensity and efficiency with which capital assets are utilized to generate commercial volume.
Strategic Insights from the DuPont Framework
The DuPont decomposition demonstrates that a business can achieve an attractive ROCE through two radically different strategic commercial models:
Business Model Operating Profit Margin Asset Turnover Target Industry Examples
High Margin, Low Turnover High (e.g. 20% – 30%) Low (e.g. 0.8x – 1.2x) Luxury goods (e.g. Rolex, bespoke fashion), specialized industrial engineering, high-end consulting, pharmaceuticals.
Low Margin, High Turnover Low (e.g. 2% – 5%) High (e.g. 4.0x – 8.0x) Discount food retailers (e.g. Aldi, Costco), high-volume FMCG distributors, budget airlines, bulk commodity traders.
Exam Key Insight : If a company's ROCE increases from 18% to 24%, DuPont analysis reveals whether the improvement was driven by pricing power/cost reduction (margin expansion) or better asset utilization/volume throughput (higher asset turnover).
7. Master Worked Case Study: Comparative Profitability Analysis
Review the following comparative financial statement extracts for Apex Distribution Ltd for the years ended 31 December 20X4 and 31 December 20X5.
- Statement of Profit or Loss Extracts Year ended 31 Dec 20X4 Year ended 31 Dec 20X5
- £ £
- Revenue 600,000 750,000
- Cost of Sales (360,000) (487,500)
- ─────────────────────────────────────────────────────────────────────────────────────────
- Gross Profit 240,000 262,500
- Distribution Costs (48,000) (60,000)
- Administrative Expenses (72,000) (90,000)
- ─────────────────────────────────────────────────────────────────────────────────────────
- Operating Profit (PBIT) 120,000 112,500
- Finance Costs (10% Loan Interest) (8,000) (7,500)
- ─────────────────────────────────────────────────────────────────────────────────────────
- Profit Before Tax 112,000 105,000
- Taxation (22,400) (21,000)
- ─────────────────────────────────────────────────────────────────────────────────────────
- Profit for the Year 89,600 84,000
- Statement of Financial Position Extracts (Year-End) 31 Dec 20X4 31 Dec 20X5
- £ £
- Non-Current Assets 280,000 290,000
- Current Assets 170,000 210,000
- ─────────────────────────────────────────────────────────────────────────────────────────
- Total Assets 450,000 500,000
- ═════════════════════════════════════════════════════════════════════════════════════════
- Current Liabilities 70,000 125,000
- Non-Current Liabilities (10% Bank Loan) 80,000 75,000
- Total Equity (Share Capital + Retained Earnings) 300,000 300,000
- ─────────────────────────────────────────────────────────────────────────────────────────
- Total Liabilities and Equity 450,000 500,000
- Step-by-Step Comparative Ratio Computations
- 1. Capital Employed
20X4 : Equity (£300,000) + Non-Current Liabilities (£80,000) = £ 380 , 000 \text{Equity (£300,000)} + \text{Non-Current Liabilities (£80,000)} = \mathbf{£380,000} Equity (£300,000) + Non-Current Liabilities (£80,000) = £380 , 000 (Check: Total Assets (£450,000) − Current Liabilities (£70,000) = £ 380 , 000 \text{Total Assets (£450,000)} - \text{Current Liabilities (£70,000)} = £380,000 Total Assets (£450,000) − Current Liabilities (£70,000) = £380 , 000 )
20X5 : Equity (£300,000) + Non-Current Liabilities (£75,000) = £ 375 , 000 \text{Equity (£300,000)} + \text{Non-Current Liabilities (£75,000)} = \mathbf{£375,000} Equity (£300,000) + Non-Current Liabilities (£75,000) = £375 , 000 (Check: Total Assets (£500,000) − Current Liabilities (£125,000) = £ 375 , 000 \text{Total Assets (£500,000)} - \text{Current Liabilities (£125,000)} = £375,000 Total Assets (£500,000) − Current Liabilities (£125,000) = £375 , 000 )
2. Gross Profit Margin
20X4 : ( £ 240 , 000 £ 600 , 000 ) × 100 = 40.00 % \left( \frac{£240,000}{£600,000} \right) \times 100 = \mathbf{40.00\%} ( £600 , 000 £240 , 000 ) × 100 = 40.00%
20X5 : ( £ 262 , 500 £ 750 , 000 ) × 100 = 35.00 % \left( \frac{£262,500}{£750,000} \right) \times 100 = \mathbf{35.00\%} ( £750 , 000 £262 , 500 ) × 100 = 35.00%
3. Mark-up on Cost
20X4 : ( £ 240 , 000 £ 360 , 000 ) × 100 = 66.67 % (or 2 3 ) \left( \frac{£240,000}{£360,000} \right) \times 100 = \mathbf{66.67\%} \text{ (or } \frac{2}{3}\text{)} ( £360 , 000 £240 , 000 ) × 100 = 66.67% (or 3 2 )
20X5 : ( £ 262 , 500 £ 487 , 500 ) × 100 = 53.85 % \left( \frac{£262,500}{£487,500} \right) \times 100 = \mathbf{53.85\%} ( £487 , 500 £262 , 500 ) × 100 = 53.85%
4. Operating Profit Margin
20X4 : ( £ 120 , 000 £ 600 , 000 ) × 100 = 20.00 % \left( \frac{£120,000}{£600,000} \right) \times 100 = \mathbf{20.00\%} ( £600 , 000 £120 , 000 ) × 100 = 20.00%
20X5 : ( £ 112 , 500 £ 750 , 000 ) × 100 = 15.00 % \left( \frac{£112,500}{£750,000} \right) \times 100 = \mathbf{15.00\%} ( £750 , 000 £112 , 500 ) × 100 = 15.00%
5. Expense-to-Revenue Breakdown
Distribution Costs / Revenue :
20X4: £ 48 , 000 £ 600 , 000 × 100 = 8.00 % \frac{£48,000}{£600,000} \times 100 = 8.00\% £600 , 000 £48 , 000 × 100 = 8.00%
20X5: £ 60 , 000 £ 750 , 000 × 100 = 8.00 % \frac{£60,000}{£750,000} \times 100 = 8.00\% £750 , 000 £60 , 000 × 100 = 8.00%
Administrative Expenses / Revenue :
20X4: £ 72 , 000 £ 600 , 000 × 100 = 12.00 % \frac{£72,000}{£600,000} \times 100 = 12.00\% £600 , 000 £72 , 000 × 100 = 12.00%
20X5: £ 90 , 000 £ 750 , 000 × 100 = 12.00 % \frac{£90,000}{£750,000} \times 100 = 12.00\% £750 , 000 £90 , 000 × 100 = 12.00%
6. Asset Turnover
20X4 : £ 600 , 000 £ 380 , 000 = 1.58 times \frac{£600,000}{£380,000} = \mathbf{1.58 \text{ times}} £380 , 000 £600 , 000 = 1.58 times
20X5 : £ 750 , 000 £ 375 , 000 = 2.00 times \frac{£750,000}{£375,000} = \mathbf{2.00 \text{ times}} £375 , 000 £750 , 000 = 2.00 times
7. Return on Capital Employed (ROCE)
20X4 : ( £ 120 , 000 £ 380 , 000 ) × 100 = 31.58 % \left( \frac{£120,000}{£380,000} \right) \times 100 = \mathbf{31.58\%} ( £380 , 000 £120 , 000 ) × 100 = 31.58%
20X5 : ( £ 112 , 500 £ 375 , 000 ) × 100 = 30.00 % \left( \frac{£112,500}{£375,000} \right) \times 100 = \mathbf{30.00\%} ( £375 , 000 £112 , 500 ) × 100 = 30.00%
- 8. The Same Case on the AAT FAPS Formulas
- The computations above use the PBIT convention. Recalculated on the formulas AAT prints
for FAPS — profit for the year in both numerators — the answers change:
Net Profit Margin
20X4: ( £ 89 , 600 £ 600 , 000 ) × 100 = 14.93 % \left( \frac{£89,600}{£600,000} \right) \times 100 = \mathbf{14.93\%} ( £600 , 000 £89 , 600 ) × 100 = 14.93%
20X5: ( £ 84 , 000 £ 750 , 000 ) × 100 = 11.20 % \left( \frac{£84,000}{£750,000} \right) \times 100 = \mathbf{11.20\%} ( £750 , 000 £84 , 000 ) × 100 = 11.20%
ROCE (AAT formula)
20X4: ( £ 89 , 600 £ 380 , 000 ) × 100 = 23.58 % \left( \frac{£89,600}{£380,000} \right) \times 100 = \mathbf{23.58\%} ( £380 , 000 £89 , 600 ) × 100 = 23.58%
20X5: ( £ 84 , 000 £ 375 , 000 ) × 100 = 22.40 % \left( \frac{£84,000}{£375,000} \right) \times 100 = \mathbf{22.40\%} ( £375 , 000 £84 , 000 ) × 100 = 22.40%
Cost of Sales / Sales Revenue Percentage (the expense ratio applied to cost of sales)
20X4: ( £ 360 , 000 £ 600 , 000 ) × 100 = 60.00 % \left( \frac{£360,000}{£600,000} \right) \times 100 = \mathbf{60.00\%} ( £600 , 000 £360 , 000 ) × 100 = 60.00% (complement of the 40% gross margin)
20X5: ( £ 487 , 500 £ 750 , 000 ) × 100 = 65.00 % \left( \frac{£487,500}{£750,000} \right) \times 100 = \mathbf{65.00\%} ( £750 , 000 £487 , 500 ) × 100 = 65.00% (complement of the 35% gross margin)
- Note how far apart the two ROCE conventions sit: 31.58% on the PBIT basis against 23.58%
- on the AAT basis for the same year and the same business. The gap is the finance cost and
the tax charge. This is precisely why you must read which formula a task asks for.
- (Apex Distribution Ltd is a limited company, used here because published company figures
- make the DuPont link easy to see. In a FAPS assessment the entity will be a sole trader or
- a partnership, so "capital" in the denominator will be the proprietor's closing capital or
- total partners' funds rather than share capital and retained earnings.)
- 9. DuPont Reconciliation Verification
20X4 : Operating Margin (20.00%) × Asset Turnover (1.5789) = 31.58 % \text{Operating Margin (20.00\%)} \times \text{Asset Turnover (1.5789)} = \mathbf{31.58\%} Operating Margin (20.00%) × Asset Turnover (1.5789) = 31.58%
20X5 : Operating Margin (15.00%) × Asset Turnover (2.0000) = 30.00 % \text{Operating Margin (15.00\%)} \times \text{Asset Turnover (2.0000)} = \mathbf{30.00\%} Operating Margin (15.00%) × Asset Turnover (2.0000) = 30.00%
Analytical Commentary & Managerial Interpretation
Metric 20X4 20X5 Direction & Variance Core Analytical Takeaway
Revenue £600,000 £750,000 +£150,000 (+25.0%) Substantial volume expansion across the trading period.
Gross Profit Margin 40.00% 35.00% -5.00 percentage points Margin compressed significantly; caused by price discounting to capture market share or supplier cost inflation.
Operating Margin 20.00% 15.00% -5.00 percentage points Drop is driven entirely by the gross profit decline; operating overheads remained perfectly controlled at 20.00% of revenue.
Asset Turnover 1.58x 2.00x +0.42 times (+26.6%) Exceptional improvement in capital utilisation; generating £2.00 of sales per £1.00 of capital employed.
ROCE (PBIT basis) 31.58% 30.00% -1.58 percentage points Despite a 25% collapse in operating profit margin (20% to 15%), ROCE fell by only 1.58 percentage points because surging asset turnover largely offset the margin contraction.
Net Profit Margin (AAT formula) 14.93% 11.20% -3.73 percentage points Falls further than the operating margin because finance costs and tax are inside this measure.
ROCE (AAT formula) 23.58% 22.40% -1.18 percentage points The AAT measure moves in the same direction as the PBIT version but from a lower base — the two must never be quoted interchangeably.
Cost of Sales / Revenue 60.00% 65.00% +5.00 percentage points The expense/revenue percentage applied to cost of sales; the exact mirror of the gross margin fall, confirming the arithmetic.
Examiner Note : When drafting commentary on profitability in AAT assessments, do not simply state that ratios changed. You must explain why they changed by connecting the movements in the Statement of Profit or Loss (gross margin compression vs overhead control) to the Statement of Financial Position (asset utilization and capital base).
- Choosing a Valid Comparison, and Interpreting with Scepticism
- A single year's ratio in isolation says almost nothing. AAT expects you to know the three
legitimate bases for comparison, and the limits of each:
Comparison Basis What It Tells You The Catch
A different time period (same business) Whether performance is improving or deteriorating Accounting policies must be unchanged; a switch from straight-line to reducing balance depreciation, or a change in the doubtful-debt percentage, breaks comparability
A different organisation Whether the business is competitive Only valid against a genuinely similar trade, size and business model; a manufacturer and a retailer will never share a benchmark
An industry standard or benchmark Whether the business is normal for its sector Published averages blend very different firms, and lag by a year or more
- Professional scepticism in interpretation. Ratios are calculated from the financial
- statements, so they inherit every judgement inside them. Before drawing a conclusion, ask
what could have produced the movement other than genuine trading performance:
Was the gross margin improvement real, or did closing inventory simply fail to be
written down to net realisable value?
Did net profit margin rise because costs fell, or because a repair was capitalised as an
asset (Section 2.1) and the depreciation on it deferred to later years?
Did ROCE improve because profit rose, or because the owner took large drawings that
shrank the capital employed denominator?
Does the movement agree with what you know independently about the business — new
contracts, lost customers, price rises, a change of premises?
- Professional scepticism means holding a questioning mind, being alert to information that
- contradicts the story the ratios tell, and making a critical assessment of the evidence
- rather than accepting a plausible explanation at face value. It does not mean assuming
dishonesty; it means not assuming honesty either.