Advice:
- Obtain financing for the deficit in January (Bank overdraft, ST loan)
- Arrange for purchases to be paid off over a longer period of time
,CLASS EXERCISE– CASH BUDGETING
The following cash budget is given to you:
• The company requires a closing cash balance of R10 000 at the end of each year.
• Assume that all cash deficits will be financed by means of short-term loans.
• Any cash surpluses will first be used to redeem the previous years’ financing.
• Any additional cash surpluses that may remain can then be utilised to purchase
marketable securities.
Year 1: Obtain ST loan of R40 000
Year 2: Obtain ST loan of R10 000
Year 3: Reduce ST loan by R45 000
Year 4: Reduce ST loan by R5 000 + buy marketable securities of R35 000
,PROBLEM 2 - CASH BUDGETING
Sales 60% during month, 30% following month, 10% 2 months after
2.1
KONTANT ONTVANGSTES
JAN FEB MAR
CASH RECEIPTS
Nov 22 500
Des 121 500 40 500
Jan 108 000 54 000 18 000
Feb 135 000 67 500
Mar 162 000
252 000 229500 247 500
JAN FEB MAR
Expected sales 200 000 250 000 300 000
Shoplifting (20 000) (25 000) (30 000)
Realised Sales 180 000 225 000 270 000
Current month: 60% 108 000 135 000 162 000
Next month: 30% 121 500 54 000 67 500
Two months: 10% 22 500 40 500 18 000
Total cash sales 252000 229500 247500
Purchases = (cost of sales + CB inventory) – OB inventory
Dec Purchases = [(70% x 450 000) + (30% x 450 000)] – (30% x 250 000)
= 375 000 (next 60% = 225 000 Jan)
Jan Purchases = [(70% x 200 000) + (30% x 200 000)] – (30% x 250 000)
= 65 000 (cur 40% =26 000 Jan) (next 60% =39 000 Feb)
Feb Purchases = (70% x 250 000) + (30% x 250 000)] – (30% x 200 000)
= 190 000 (cur 40% =76 000 Feb) (next 60% =114 000 Mar)
Mar Purchases = [(70% x 300 000) + (30% x 300 000)] – (30% x 250 000)
=225 000 (cur 40% = 90 000 Mar)
, KONTANT BETALINGS
JAN FEB MAR
CASH PAYMENTS
Purchases
Current month: 40% 26 000 76 000 90 000
Following month: 60% 225 000 39 000 114 000
Operating expenses 24 000 24 000 24 000
Equipment 20 000
Interest 25 000
Income tax 35 000
Total Cash Payments 295 000 164 000 263 000
JAN FEB MAR
Dec 375 000 225 000
Jan 65 000 26 000 39 000
Feb 190 000 76000 114 000
Mar 225 000 90 000
251 000 115 000 204 000
JAN FEB MAR
Total cash receipts 252 000 229 500 247 500
Total cash payments 295 000 164 000 263 000
Cash Generated (43 000) 65 500 (15 500)
Cash opening balance 40 000 (3 000) 62 500
Cash closing balance (3 000) 62 500 47 000
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Studynotes101. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $5.07. You're not tied to anything after your purchase.