Golden State Company has applied at a local bank for a short-term loan of $150,000 starting on October 1, 2014. The banks loan officer has requested a cash budget from the company for the quarter ending December 31, 2014. The following information is needed to prepare the cash budget:

Sales	$600,000
Purchases	350,000
Salaries and wages to be paid	125,000
Rent payments	125,000
Supplies (payments for)	4,500
Insurance payments	1,500
Other cash payments	22,000

A cash balance of $24,000 is planned for October 1. Accounts receivable are expected to be $48,000 on October 1. All of these accounts will be collected in the quarter ending December 31. In general, sales are collected as follows: 90% in the quarter of sale, and 10% in the quarter after sale. Accounts payable will be $480,000 on October 1 and will be paid during the quarter ending December 31. All purchases are paid in the quarter after purchase.

Required:

a. Prepare a cash budget for the quarter ending December 31, 2014. Assume that the $150,000 loan will be made on October 1 and will be repaid with interest at 10% on December 31.

b. Will the company be able to repay the loan on December 31? If the company desires a minimum cash balance of $18,000, will the company be able to repay the loan as planned?