2023 Q16 (c) Mount Rangers GAA Club prepare a cash flow budget each year. (i) Using the following information complete the cash flow budget below. Estimated Expenditure: Purchases: June €172; July €58; August €135 New equipment: June €450 Administration costs: June €20; July €26; August €18
Details
Receipts Grant
Fundraising Total Receipts
Payments Purchases
New equipment
Administration costs
Total Payments Net Cash
Opening Cash Closing Cash
Mount Rangers Cash Flow Budget June (€)
July (€)
€250 €150 €400
€172 €450
€20 €642
(€242) €175
(€67)
€250 €350 €600
€58 -
€26 €84
€516 (€67) €449
August (€)
€250 €250 €500
€135 -
€18
€153 €347 €449 €796
Total (June–August) (€)
€750 €750
€1,500
€365 €450
€64
€879 €621 €175 €796
(ii) Based on your above cash flow budget, what advice would you give to the club regarding their closing cash position in June?
Advice: Mount Rangers GAA Club has a negative closing cash of (€67) in June.
To avoid this deficit, the club could spread the payments out over a number of months by taking out a loan for the new equipment, rather than paying €450 in one lump sum in June.
The advice question in 2023 specifically asked about the closing cash position TOP TIP
in June so refer to the closing cash figure calculated in your answer. Then name a specific cause (the equipment purchase) and specific advice to fix it (eg spreading out the payments over months instead of a one-off payment).
255
STRAND 2 CHAPTER 24: Sources of finance and the cash flow budget