Finance Desk

Will the cash last the winter?

A profitable business can still run out of cash. Read a six-month forecast laid out as the IB lays it out, find the month the money runs short, explain why the profit does not help, then change the plan and watch the forecast change with it.

Section 01: The situation

It is the end of October at Atelier Barro, the fictional ceramics studio in Porto. Inês has accepted the hotel group's order of 300 mugs at €11, to be made in November and paid for on the hotel's usual terms, 60 days after delivery. The busy season is coming: about 830 mugs in November and 1,020 in December.

With the hotel likely to order again next year, Inês plans to buy a second kiln in January, for €18,000, and pay for it from the bank account. Her accountant has asked to see a cash flow forecast first. The studio has €1,500 in the bank and an agreed overdraft of €2,000.

Subtopic 3.7, Cash flow (guide, pp. 29 to 30): the difference between profit and cash flow; working capital; liquidity position; cash flow forecasts; the relationship between investment, profit and cash flow; strategies for dealing with cash flow problems. The forecast follows the layout of the guide's cash flow forecast (figure 10, p. 63). Verification: Verified

Section 02: The lab

Interaction

Atelier Barro's cash flow, November to April

Source: Simulated data

Answer three questions from the forecast as it stands. Then choose how to pay for the kiln, add any working capital measures, and compare the results.

1. Read the forecast

Answer from the forecast as it stands, before changing anything.

  1. In the forecast as it stands, in which month does the closing balance first go beyond the overdraft limit?

    An answer
  2. Over the six months the studio makes a profit of €11,976, yet its net cash flow is a negative €5,424. What explains most of the difference?

    An answer
  3. Which way of paying for the kiln deals with the problem, rather than moving it?

    An answer

Choose an answer for each item, then open its answer to compare. 3 to do. Choose your answers, then check each one or check them all.

2. The forecast

The balance goes beyond the €2,000 overdraft limit in January, and is beyond it in 4 of the 6 months.

The lowest closing balance is −€6,020.80 in February. The bank would not honour payments past the limit, so the forecast needs a change before January.

Closing balance each month against the overdraft limitNovember: €3,755.60, in credit. December: €10,732.00, in credit. January: €(5,290.80), beyond the overdraft limit. February: €(6,020.80), beyond the overdraft limit. March: €(5,268.80), beyond the overdraft limit. April: €(3,924.00), beyond the overdraft limit. Overdraft limit €2,000.(10,000)(5,000)05,00010,00015,00020,000Closing balance, €Overdraft limit (2,000)3,756Nov10,732Dec(5,291)Jan(6,021)Feb(5,269)Mar(3,924)AprMonth
Chart Closing balance each month: blue in credit, brass overdrawn within the limit, red beyond it; the dashed line is the overdraft limit. Simulated teaching data; the forecast table below has every figure.
Lowest closing balance
−€6,020.80February
Months beyond the limit
4Jan, Feb, Mar, Apr
Profit, November to April
€11,976.00accruals basis
Net cash flow, November to April
−€5,424.00cash basis
Cash flow forecast for Atelier Barro, November to April. Simulated data. Negative figures in brackets.
All figures in € NovemberDecemberJanuaryFebruaryMarchApril
Opening balance1,500.003,755.6010,732.00(5,290.80)(6,020.80)(5,268.80)
Cash inflows
Cash sales18,260.0022,440.0010,120.0011,000.0013,200.0014,080.00
Casa Alfama Hotels order0.000.003,300.000.000.000.00
Total cash inflows18,260.0022,440.0013,420.0011,000.0013,200.0014,080.00
Cash outflows
Rent1,900.001,900.001,900.001,900.001,900.001,900.00
Kiln lease450.00450.00450.00450.00450.00450.00
Salaries4,700.004,700.004,700.004,700.004,700.004,700.00
Throwers' piece rates2,712.002,448.001,104.001,200.001,440.001,536.00
Clay and glaze2,599.002,346.001,058.001,150.001,380.001,472.00
Electricity1,187.501,105.00685.00715.00790.00820.00
Packaging825.50867.00391.00425.00510.00544.00
Card and platform fees730.40897.60404.80440.00528.00563.20
Marketing480.00480.00480.00480.00480.00480.00
Insurance, website and software270.00270.00270.00270.00270.00270.00
Custom stamp for the order150.000.000.000.000.000.00
Second kiln0.000.0018,000.000.000.000.00
Total cash outflows16,004.4015,463.6029,442.8011,730.0012,448.0012,735.20
Net cash flow2,255.606,976.40(16,022.80)(730.00)752.001,344.80
Closing balance3,755.6010,732.00(5,290.80)(6,020.80)(5,268.80)(3,924.00)
Against the overdraft limit of 2,000In creditIn creditBeyond the overdraft limitBeyond the overdraft limitBeyond the overdraft limitBeyond the overdraft limit

3. Change the plan

Pay for the second kiln
Working capital measures (any number)

With JavaScript off, the forecast shows the original plan only. The answers to the questions above explain what each choice would do.

4. Profit is not cash

Profit counts revenue when it is earned and costs when they are incurred. The forecast counts cash when it moves. The reconciliation explains every euro of the difference.

Profit for the period

Profit for the period, accruals basis, in €
Revenue earned92,400.00
Production: piece rates, clay and glaze, electricity(25,747.50)
Packaging and card fees(7,126.50)
Rent, kiln lease, salaries and overheads(43,920.00)
Marketing(2,880.00)
Custom stamp for the order(150.00)
Depreciation of the second kiln(600.00)
Profit11,976.00

From profit to cash

Reconciliation of profit to net cash flow, in €
Profit11,976.00
Second kiln: cash paid out, but it is an asset, not an expense(18,000.00)
Depreciation: an expense, but no cash leaves the business600.00
Net cash flow(5,424.00)

Profit €11,976.00, net cash flow −€5,424.00.

5. The working: January's closing balance

Given
  • Opening balance, January: €10,732.00
  • Total cash inflows: €13,420.00
  • Total cash outflows: €29,442.80
Formula
Net cash flow = total cash inflows − total cash outflows; closing balance = opening balance + net cash flow
Substitution
Net cash flow = €13,420.00 − €29,442.80; closing balance = €10,732.00 + (−€16,022.80)
Working
€13,420.00 − €29,442.80 = −€16,022.80
€10,732.00 + (−€16,022.80) = −€5,290.80
Answer
€(5,290.80)

Negative figures are shown in brackets, as in the guide’s cash flow forecast.

Unit
€ in the bank at the end of January
Interpretation
At the end of January the account is overdrawn by €5,290.80, which is €3,290.80 beyond the €2,000.00 limit.
Business implication
The bank need not honour payments beyond the limit: wages, rent or the supplier could go unpaid even though the business is profitable.

Section 03: The calculations

Each with a worked example from the forecast.

Cash flow

Net cash flow

SL and HL Verification: Verified IB 3.7

Formula

Net cash flow = total cash inflows − total cash outflows

NCF
Net cash flow (currency per month)
CI
Total cash inflows (currency per month)
CO
Total cash outflows (currency per month)

Unit. currency per month

Whether more cash came in than went out in the month. A negative net cash flow is not a loss; it can come from buying an asset or from customers paying late.

Worked example: from the case Atelier Barro

Atelier Barro: January, with the second kiln bought outright

Given
  • Total cash inflows in the month: €13,420.00
  • Total cash outflows in the month: €29,442.80
Formula
Net cash flow = total cash inflows − total cash outflows
Substitution
= €13,420.00 − €29,442.80
Working
€13,420.00 − €29,442.80 = −€16,022.80
Answer
−€16,022.80

A negative net cash flow is written in brackets in a forecast.

Unit
currency per month
Interpretation

In January €16,022.80 more leaves the bank than comes in, because the €18,000 kiln is paid in a quiet month.

Business implication

The studio needs finance matched to the kiln's long life, or the balance breaks the overdraft limit.

Errors that cost marks
  • Counting a sale made on credit as a cash inflow in the month of the sale.
  • Leaving an asset purchase out of the forecast because it is not an expense.
  • Writing a negative figure with a minus sign in a forecast laid out in the IB format, which uses brackets.

3.7: Cash flow forecasts (AO2, AO4); the forecast's layout is the guide's figure 10 (p. 63)

Cash flow

Closing balance

SL and HL Verification: Verified IB 3.7

Formula

Closing balance = opening balance + net cash flow

CB
Closing balance (currency at the end of the month)
OB
Opening balance (currency at the start of the month)
NCF
Net cash flow (currency per month)

Unit. currency at the end of the month

The cash the business has at the end of the month, which becomes the next month's opening balance. A negative closing balance means the account is overdrawn.

Worked example: from the case Atelier Barro

Atelier Barro: January, with the second kiln bought outright

Given
  • Opening balance: €10,732.00
  • Total cash inflows: €13,420.00
  • Total cash outflows: €29,442.80
Formula
Closing balance = opening balance + net cash flow
Substitution
= €10,732.00 + (€13,420.00 − €29,442.80)
Working
€13,420.00 − €29,442.80 = −€16,022.80
€10,732.00 + (−€16,022.80) = −€5,290.80
Answer
−€5,290.80

The closing balance is the next month’s opening balance.

Unit
currency at the end of the month
Interpretation

The account ends January overdrawn by €5,290.80, which is €3,290.80 beyond the €2,000 limit.

Business implication

Payments due in January could be refused, though the studio is profitable over the winter.

Errors that cost marks
  • Starting each month from the same opening balance instead of carrying the previous closing balance forward.
  • Adding a negative net cash flow as if it were positive.

3.7: Cash flow forecasts (AO2, AO4); the forecast's layout is the guide's figure 10 (p. 63)

Back: break-even The Finance Desk