Diagram · Unit 3 · 3.7
Profit and cash, month by month
Change when customers pay and when suppliers are paid; the balances, the chart and the reading follow.
- Profit over the six months
- $19,800
- Bank balance at the end of June
- −$1,200
- Lowest balance
- −$8,800 (February)
- Customers still owe (debtors)
- $25,000
- Owed to suppliers (creditors)
- $0
| Month | Cash in | Cash out | Closing balance |
|---|---|---|---|
| January | 0 | 6,200 | (2,200) |
| February | 0 | 6,600 | (8,800) |
| March | 8,000 | 7,000 | (7,800) |
| April | 9,000 | 7,400 | (6,200) |
| May | 10,000 | 7,800 | (4,000) |
| June | 11,000 | 8,200 | (1,200) |
Larkfield Cycles makes a profit every month, $19,800 in all. Its balance goes beyond the $5,000 overdraft limit in February, March and April, so it would need more finance or would have to change its credit terms. Profit counts a sale when it is made; cash arrives only when the customer pays. Closing balance = opening $4,000 + profit $19,800 − debtors $25,000 + creditors $0 = −$1,200.
The figures above are the example’s. With JavaScript on, they can be changed here.
Text description
Larkfield Cycles, a fictional new business, sells on 2 months' credit and pays its suppliers after 0 months, starting with $4,000 in the bank and an overdraft limit of $5,000. Closing bank balances: January (2,200), overdrawn, within the limit; February (8,800), beyond the overdraft limit; March (7,800), beyond the overdraft limit; April (6,200), beyond the overdraft limit; May (4,000), overdrawn, within the limit; June (1,200), overdrawn, within the limit. Profit to date climbs every month to $19,800 by June. At the end customers still owe $25,000 and the business owes suppliers $0.
Section 01: Where it is used
- 3.7 Cash flow On the subtopic’s page, with its other diagrams
Arjun Agrawal | The Business Brief, https://the-business-brief-dun.vercel.app/diagrams/cash-flow-timeline/. Original teaching material, not an IB publication. The organizations in the teaching cases are fictional unless a case says otherwise.