Sometimes even the total receivables and payables accounts can’t fill every gap: there is no record of sales, or the inventory has been destroyed. The missing figures can then be worked out from the business’s mark-up or margin, because the relationship between cost of sales, gross profit and revenue is fixed. These techniques also appear on their own in Paper 1 multiple-choice questions.
Mark-up and margin
Mark-up: gross profit as a percentage of cost of sales. Margin (gross profit margin): gross profit as a percentage of revenue.
Mark-up (%) = gross profit ÷ cost of sales × 100
Gross profit margin (%) = gross profit ÷ revenue × 100
Margin = mark-up ÷ (100 + mark-up); mark-up = margin ÷ (100 − margin)
| Mark-up | Margin | Cost : gross profit : revenue |
|---|---|---|
| 25% | 20% | 100 : 25 : 125 |
| 50% | 33⅓% | 100 : 50 : 150 |
| 100% | 50% | 100 : 100 : 200 |
- Write the cost : gross profit : revenue relationship as three numbers. For a mark-up of 25%: cost 100, gross profit 25, revenue 125. For a margin of 25%: revenue 100, gross profit 25, cost 75.
- Find which of the three you know (usually revenue or cost of sales).
- Scale: for example, with a 25% mark-up, cost of sales = revenue × 100 ÷ 125.
- Use the trading account (opening inventory + purchases − closing inventory = cost of sales) to find any other missing figure.
A business makes a gross profit margin of 25%. Revenue was $90,000; inventory was $8,000 at the start of the year and $9,500 at the end. Find the purchases.
Gross profit = 90,000 × 25% = $22,500. Cost of sales = 90,000 − 22,500 = $67,500. Opening inventory + purchases − closing inventory = cost of sales, so purchases = 67,500 + 9,500 − 8,000 = $69,000.
The most common mistake is applying a mark-up to revenue (or a margin to cost). A 25% mark-up on revenue of $90,000 is not $22,500: cost of sales = 90,000 × 100 ÷ 125 = $72,000, so gross profit = $18,000.
Dummy inventory figures
If a question tells you how inventory changed but not what it was (“inventory fell by $2,000 during the year”), make up a dummy opening figure, apply the change, and carry on. The dummy cancels out, because only the difference between opening and closing inventory affects cost of sales.
Purchases were $60,000, inventory fell by $2,000 during the year, and goods are sold at a mark-up of 25%. Find revenue.
Use a dummy opening inventory of $10,000, so closing inventory is $8,000. Cost of sales = 10,000 + 60,000 − 8,000 = $62,000. Revenue = 62,000 × 125 ÷ 100 = $77,500. (Try a dummy of $50,000 and $48,000: the answer is the same.)
Inventory lost in a fire, flood or theft
When inventory is destroyed, the business needs to know how much was lost for its insurance claim. Nobody can count what has gone, so the inventory that should have been there is worked out from the trading account, using the mark-up or margin to find cost of sales.
- Find cost of sales from the sales since the last count, using the mark-up or margin.
- Prepare a trading account from the last inventory count to the date of the loss: opening inventory + purchases (less any goods taken by the owner or returned) − cost of sales = the inventory that should be held.
- Deduct the cost of any goods saved (salvaged).
- The rest is the inventory lost. If it is insured, the insurance company owes the agreed proportion; any uninsured part is a loss (an expense) in the statement of profit or loss.
A fire at Jay’s warehouse on 30 April destroyed most of the inventory. Inventory at 1 January was $14,000 at cost. From 1 January to 30 April, purchases were $46,000 and sales $72,000; Jay took goods costing $600 for personal use. Goods are sold at a mark-up of 50%. Goods costing $2,500 were saved. The insurance company agreed to pay 80% of the loss.
| Trading account for the four months to 30 April | $ | $ |
|---|---|---|
| Revenue | 72 000 | |
| Opening inventory | 14 000 | |
| Purchases (46,000 − 600 taken by Jay) | 45 400 | |
| 59 400 | ||
| Less closing inventory (missing figure) | (11 400) | |
| Cost of sales (72,000 × 100 ÷ 150) | (48 000) | |
| Gross profit (50% of cost) | 24 000 |
| Inventory lost | $ |
|---|---|
| Inventory that should be held at 30 April | 11 400 |
| Less goods salvaged | (2 500) |
| Inventory destroyed | 8 900 |
| Insurance claim (80%) | 7 120 |
| Loss to be borne by the business (expense) | 1 780 |
The $7,120 claim is a current asset (other receivable) until the insurer pays; the $1,780 not covered is charged as an expense. The goods taken by Jay are deducted from purchases because they were never available to sell.
Valuing inventory
Inventory is valued at the lower of cost and net realisable value (NRV = expected selling price less any costs to complete and sell it). This applies the prudence concept: a loss is recognised as soon as it is expected, but a profit only when the goods are sold. Compare cost and NRV item by item, not in total.
| Item | Cost $ | NRV $ | Value $ |
|---|---|---|---|
| Item A | 4 200 | 5 100 | 4 200 |
| Item B (shop-soiled) | 3 000 | 2 400 | 2 400 |
| Item C | 1 800 | 1 650 | 1 650 |
| Total | 9 000 | 9 150 | 8 250 |
Comparing totals (cost $9,000, NRV $9,150) would wrongly give $9,000. Item by item, inventory is $8,250. Overvaluing closing inventory by $750 would overstate profit by $750 this year and understate next year’s, because this year’s closing inventory is next year’s opening inventory.
How cost itself is found (FIFO or AVCO) is covered in costing of materials and labour.
Full records or incomplete records?
| Advantages of full double-entry records | Disadvantages |
|---|---|
| Every transaction is recorded, so figures are accurate and complete; errors and theft are easier to detect | Time-consuming; needs bookkeeping skills or paid staff and software |
| The owner knows at any time who owes what and what is owed; better credit control | The cost may outweigh the benefit for a very small business |
| Statements are quicker and cheaper for the accountant to prepare; reliable evidence for lenders and tax authorities | Errors can still occur in recording |
| Inventory losses can be identified because expected inventory can be compared with actual |
Answering the Paper 1 and 2 questions
Typical questions: “Calculate the cost of inventory destroyed in the fire”; “Calculate the purchases for the year”; “Explain the difference between mark-up and margin”; or “Advise the owner whether the business should maintain a full double-entry system.”
Paper 1 has 30 multiple-choice questions: work each one out on paper before you look at the options, because the wrong options are the answers you get from the common mistakes. Paper 2 has four structured questions (30, 15, 15 and 30 marks): you prepare accounts and calculations, then explain, discuss or advise. The written parts are marked on knowledge, analysis and evaluation. Plan every “discuss”, “advise” or “evaluate” answer in the same five steps, in this order:
- Knowledge: define mark-up and margin, and state the lower of cost and net realisable value rule and the prudence concept.
- Application: use the figures: convert the mark-up or margin correctly and set out the trading account to find the missing figure.
- Analysis: explain what the result means: for example, $8,900 of inventory was destroyed, but only $7,120 will be recovered, so profit falls by $1,780.
- Evaluation: consider how reliable the estimate is (does the business really sell everything at the same mark-up? were there earlier losses or theft?) and what full records would add.
- Conclusion: reach a clear judgement, for example: the business should keep full inventory records, because the claim depends on an estimate that the insurer may challenge.
Check yourself
Cost of sales is $60,000 and the mark-up is 20%. What is revenue?
60,000 × 120 ÷ 100 = $72,000.
Revenue is $120,000 and the margin is 30%. What is cost of sales?
120,000 × 70% = $84,000.
Convert a mark-up of 60% to a margin.
60 ÷ 160 = 37.5%.
Opening inventory $5,000; purchases $40,000; sales $50,000 at a 25% mark-up; goods saved $1,000. How much inventory was lost?
Cost of sales = 50,000 × 100 ÷ 125 = 40,000; inventory that should be held = 5,000 + 40,000 − 40,000 = 5,000; lost = 5,000 − 1,000 = $4,000.
Goods cost $800 and can be sold for $900 after repairs of $250. At what value are they included in inventory?
NRV = 900 − 250 = $650, lower than cost, so $650.
Now practise it
Try the 51 past paper questions on Incomplete records: Further considerations, with mark schemes. Start with the most recent ones; if one goes wrong, come back to the section above that covers it.
Practise Incomplete records: Further considerations questions →