Solution:
Part 1 –
Schedule of Expected Cash Collections |
||||
April |
May |
June |
Quarter |
|
From Accounts Receivable |
$162,000 |
$27,400 |
||
From April Sales |
$90,600 |
$181,200 |
$24,160 |
|
From May Sales |
$125,400 |
$250,800 |
||
From June Sales |
$83,100 |
|||
Total Cash Collections |
$252,600 |
$334,000 |
$358,060 |
$944,660 |
Part 2
Prime Products |
||||
Cash Budget |
||||
April |
May |
June |
Quarter |
|
Beginning cash balance |
$33,400 |
$23,900 |
$20,300 |
$33,400 |
Add: Receipts |
||||
Collection from customers |
$252,600 |
$334,000 |
$358,060 |
$944,660 |
Total cash available |
$286,000 |
$357,900 |
$378,360 |
$978,060 |
Less: Cash disbursements |
||||
Merchandise Purchases |
$160,500 |
$206,000 |
$134,500 |
$501,000 |
Payroll |
$29,800 |
$29,800 |
$24,500 |
$84,100 |
Lease payments |
$28,200 |
$28,200 |
$28,200 |
$84,600 |
Advertising |
$73,600 |
$73,600 |
$43,680 |
$190,880 |
Equipment purchases |
$98,000 |
$98,000 |
||
Total Cash disbursements |
$292,100 |
$337,600 |
$328,880 |
$958,580 |
Excess (deficiency) of cash available over disbursements |
-$6,100 |
$20,300 |
$49,480 |
$19,480 |
Financing |
||||
Borrowings |
$30,000 |
$0 |
$30,000 |
|
Repayments |
$0 |
$0 |
-$30,000 |
-$30,000 |
Interest |
$0 |
$0 |
-$1,240 |
-$1,240 |
Total Finiancing |
$30,000 |
$0 |
-$31,240 |
-$1,240 |
Ending Cash Balance |
$23,900 |
$20,300 |
$18,240 |
$18,240 |
Hope the above calculations, working and explanations are clear to you and help you in understanding the concept of question.... please rate my answer...in case any doubt, post a comment and I will try to resolve the doubt ASAP…thank you
The president of the retailer Prime Products has just approached the company's bank with a request...
The president of the retailer Prime Products has just approached the company's bank with a request for a $59,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which...
The president of the retailer Prime Products has just approached the company's bank with a request for a $73,000.90 day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which...
The president of the retailer Prime Products has just approached the company’s bank with a request for a $59,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which...
The president of the retailer Prime Products has just approached the company's bank with a request for a $55.000, 90- day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months Aprill through June, during...
The president of the retailer Prime Products has just approached the company's bank with a request for a $87,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which...
The president of the retailer Prime Products has just approached the company's bank with a request for a $47,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which...
The president of the retailer Prime Products has just approached the company's bank with a request for a $55,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which...
The president of the retailer Prime Products has just approached the company's bank with a request for a $47,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which...
The president of the retailer Prime Products has just approached the company’s bank with a request for a $30,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which...
The president of the retailer Prime Products has just approached the company’s bank with a request for a $71,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which...