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 BudgetA 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...
Step by Step Answer:
Accounting
ISBN: 978-1118608227
9th edition
Authors: Lew Edwards, John Medlin, Keryn Chalmers, Andreas Hellmann, Claire Beattie, Jodie Maxfield, John Hoggett