Reference no: EM13482241

A company is negotiating with the bank for a $200,000/ 90 day/12% loan effective July 1 of the current year. If the bankgrants the loan, the proceeds will be $194,000 which the companyintends to use on July 1 as follows: pay accounts payable$150,000; purchase equipment $160,000; add to bank balance $28,000.

The current working capital position, according to financialstatements as of June 30 as follows:

cash inbank.......................................................................$20,000
receivables(net of allowance for doubtfullaccounts............ 160,000
merchandiseinvnetory....................................................... 90,000
total currentassets............................................................$270,000
accounts payable(includes accrued operatingexpense)...... 150,000
workingcapital.................................................................$120,000

These estimates have been made, which are to be used in a 3month cash budget:

sales(all accounts) for July $300,000, August $360,000 Sept$270,000 Oct $200,000

Past experience shows that 80% of the receivables, in anymonth will be collected in the month following the sale. 19%will be collected in the second month following the sale and the 1%will prove uncollectible. They expect to collect $120,00 ofthe June30 receivables in July and the remaining $40,000 inAugust.

Cost of goods sold has averaged about 65% of sales. Operating expenses are budgeted at $36,000 per month plus 8% ofsales. With the exception of $4,400 per monthdepreciation expense, all operating expenses and purchases are inaccount and paid in the month following their occurance.

Prepare a monthly cash budget showing estimated cash receipts and cash payments for July, Aug, and Sept. and the cashbalance at the end of each month. Supporting schedules shouldbe prepared for estimated for collections onreceivables, merchandise purchases, and payments for operating expenses and of account payable for merchandise purchase.