Brockbank Builders Ltd is preparing a cash budget for May and June of 2016. Past records reveal

Question:

Brockbank Builders Ltd is preparing a cash budget for May and June of 2016. Past records reveal that 20% of all credit sales are collected during the month of sale, 60% in the month following the sale, 10% in the second month following the sale and 10% in the third month following the sale. The company pays for 75% of purchases in the month after purchase, and the balance is paid in the month following that.

Selling expenses amount to $6600 per month plus 15% of monthly sales. Administrative expenses are estimated to be $13200 per month, which includes $4800 of depreciation expense. Finance expenses are $1200 per month. All selling and distribution, administrative, and finance and other expenses (except depreciation) are paid for when incurred.

It is planned to purchase equipment during May 2016 at a cost of $6600. A $9000 loan payable will be repaid during June 2016. The interest due at maturity will be $1650. The company’s expected Cash at Bank balance at 1 May 2016 is $13500.

Estimated sales and purchases data are as follows:




Sales


Purchases



2016

February

March

April

May

June



$75000

66000

88000

60500

71500



$


38500

33000

55000

27500

38500













Required

Ignoring GST, prepare a cash budget for May and June 2016, by month and in total.

Cash Budget
A cash budget is an estimation of the cash flows for a business over a specific period of time. These cash inflows and outflows include revenues collected, expenses paid, and loans receipts and payment.  Its primary purpose is to provide the...
Maturity
Maturity is the date on which the life of a transaction or financial instrument ends, after which it must either be renewed, or it will cease to exist. The term is commonly used for deposits, foreign exchange spot, and forward transactions, interest...
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  answer-question

Accounting

ISBN: 978-1118608227

9th edition

Authors: Lew Edwards, John Medlin, Keryn Chalmers, Andreas Hellmann, Claire Beattie, Jodie Maxfield, John Hoggett

Question Posted: