Reference no: EM133014505
Question - Golden Point Company has applied at a local bank for a short-term loan of $150,000 starting on October 1, 2020. The bank's loan officer has requested a cash budget from the company for the quarter ending December 31, 2020. 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 7,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 receivables 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, 2020. Assume that the $150,000 loan will be made on October 1 and will be repaid with interest at 10% on December 31.
b) If the company desires a minimum cash balance of $18,000, will the company be able to repay the loan as planned on December 31?