1.
Schedule of Cash Collections | ||||
April | May | June | Quarter | |
Collected in same month @30% | $ 1,12,500 | $ 1,23,600 | $ 1,00,800 | $ 3,36,900 |
Collected in following month @60% | $ 1,34,400 | $ 2,25,000 | $ 2,47,200 | $ 6,06,600 |
Collected in following next month @8% | $ 17,920 | $ 30,000 | $ 47,920 | |
Total Cash Collections | $ 2,46,900 | $ 3,66,520 | $ 3,78,000 | $ 9,91,420 |
2.
Cash Budget | ||||
April | May | June | Quarter | |
Beginning Cash Balance | $ 26,000 | $ 43,400 | $ 53,920 | $ 26,000 |
Add receipts: | ||||
Collections from Customers | $ 2,46,900 | $ 3,66,520 | $ 3,78,000 | $ 9,91,420 |
Total cash available | $ 2,72,900 | $ 4,09,920 | $ 4,31,920 | $ 10,17,420 |
Less Cash Disbursements | ||||
Merchandise Purchase | $ 1,66,500 | $ 2,38,000 | $ 1,55,000 | $ 5,59,500 |
Payroll | $ 18,800 | $ 18,800 | $ 22,500 | $ 60,100 |
Lease Payments | $ 24,400 | $ 24,400 | $ 24,400 | $ 73,200 |
Advertising | $ 74,800 | $ 74,800 | $ 50,420 | $ 2,00,020 |
Equipment Purchases | $ 1,06,500 | $ 1,06,500 | ||
Total Cash Disbursements | $ 2,84,500 | $ 3,56,000 | $ 3,58,820 | $ 9,99,320 |
Excess (Deficiency) of cash | $ -11,600 | $ 53,920 | $ 73,100 | $ 18,100 |
Financing | ||||
Borrowing | $ 55,000 | $ 55,000 | ||
Repayment | $ -55,000 | $ -55,000 | ||
Interest | $ -900 | $ -900 | ||
Total financing | $ 55,000 | $ - | $ -55,900 | $ -900 |
Ending Cash balance | $ 43,400 | $ 53,920 | $ 17,200 | $ 17,200 |
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 $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 $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 $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 $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 $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 $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...
please answer fast The president of the retailer Prime Products has just approached the company's bank with a request for a $85,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...
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...
The president of the retailer Prime Products has just approached the company’s bank with a request for a $83,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...
Check my wor 6 The president of the retailer Prime Products has just approached the company's bank with a request for a $75,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...