Diagram · Unit 3 · 3.7

Profit and cash, month by month

SL and HL Fictional figures Change the figures

Change when customers pay and when suppliers are paid; the balances, the chart and the reading follow.

Profit and cash, month by month. A chart of six months for a fictional new business: bars for the bank balance at the end of each month, a line for the profit made so far, and the overdraft limit.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.(10,000)010,00020,000$(2,200)Jan(8,800)Feb(7,800)Mar(6,200)Apr(4,000)May(1,200)JunProfit to date 19,800Bank balance at the end of the monthProfit to dateOverdraft limit (5,000)Fictional figures.
Profit and cash, month by month. A chart of six months for a fictional new business: bars for the bank balance at the end of each month, a line for the profit made so far, and the overdraft limit.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.Bank balance at the end of each monthand the profit made so farJanuaryprofit 1,800(2,200)Februaryprofit 4,200(8,800)Marchprofit 7,200(7,800)Aprilprofit 10,800(6,200)Mayprofit 15,000(4,000)Juneprofit 19,800(1,200)Overdraft limit (5,000)
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
Cash flow forecast ($). Brackets show a negative figure.
MonthCash inCash outClosing balance
January06,200(2,200)
February06,600(8,800)
March8,0007,000(7,800)
April9,0007,400(6,200)
May10,0007,800(4,000)
June11,0008,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.

Profit and cash, month by month A profitable new business can still run out of cash: change the credit terms and see when the money arrives.
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.

Download SVG

Section 01: Where it is used