BTEC Business: Cash-Flow Forecasts and Break-Even Charts

This material trains content area E of Unit 3, Personal and Business Finance, in the Pearson BTEC Level 3 National Business qualifications: cash-flow forecasts and break-even analysis. The specification asks you to prepare, complete, analyse, revise and evaluate both, and it states that the formulas for this topic are not given in the external assessment, so they have to be known.

The cash-flow questions follow one invented business through three months. You calculate net cash flow from receipts and payments, carry the closing balance forward, and work backwards to a missing total when the closing balance is known. You decide in which month credit sales are received and credit purchases paid, recognise that depreciation never appears in a forecast because no cash moves, and decide what to do when a forecast shows a short overdraft. Items from the specification's lists appear in the figures, including loans received, purchase of assets, rent, wages and VAT.

The break-even questions start from a chart described in words: you read the price and the variable cost from the lines, find where total revenue meets total cost, and then calculate the margin of safety in units and in sales value and the profit at the expected level of sales. You also predict how the chart changes when the price rises, identify a semi-variable cost, and pick out the genuine limitations of break-even analysis.

The quiz has twelve questions, each with a full worked explanation, so a wrong answer shows exactly which step went wrong. The flashcards hold the formulas and the rules for reading a chart. The written work has eight longer tasks marked against key points: completing a three-month forecast, working out receipts when part of each month's sales is on credit, revising a forecast when a customer pays late, full break-even calculations, the effect of a rent increase, describing how to draw a break-even chart, and evaluating how useful break-even is for a new café, which is the kind of extended answer Unit 3 rewards. Because this is a calculation topic, there is no oral exam in this material.

All businesses and figures are invented, and the questions are original practice material, not taken from Pearson papers or mark schemes.

• Calculate net cash flow and opening and closing balances in a monthly cash-flow forecast
• Find a missing figure in a cash-flow forecast and revise a forecast when receipts are delayed
• Place credit sales and credit purchases in the month the cash moves, and exclude non-cash items
• Read break-even output, break-even revenue and the areas of profit and loss from a break-even chart
• Calculate contribution, margin of safety in units and value, and profit
• Explain how changes in price or fixed costs move the chart, and the limitations of cash-flow forecasts and break-even

Practice material written by Zestly, based on Pearson BTEC Level 3 National Business (2016 suite), Unit 3 Personal and Business Finance, content area E: E1 Cash flow forecasts and E2 Break-even analysis (specification Issue 15, April 2023).