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
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) 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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started