Cash Budget | First | Second | Third | Fourth | Year |
Cash beginning balance | 40000 | 52000 | 43500 | 59600 | 40000 |
Add: collections from sale | 430200 | 528200 | 626200 | 618600 | 2203200 |
Total cash available | 470200 | 580200 | 669700 | 678200 | 2243200 |
Less: Disbursements | |||||
Merchandise purchases | 302000 | 377500 | 429000 | 460500 | 1569000 |
Operating expenses | 103200 | 111200 | 119200 | 109600 | 443200 |
Dividends | 13000 | 13000 | 13000 | 13000 | 52000 |
Land | 85000 | 48900 | 133900 | ||
Total Disbursements | 418200 | 586700 | 610100 | 583100 | 2198100 |
Excess/(Deficiency) of receipts over disbursements | 52000 | -6500 | 59600 | 95100 | 45100 |
Financing: | |||||
Borrowings | 50000 | 50000 | |||
repayments | -50000 | -50000 | |||
Interest | -1500 | -1500 | |||
Total Financing | 50000 | 50000 | |||
Cash balance , ending | 52000 | 43500 | 59600 | 43600 | 43600 |
Interest = 50000 * 1% * 3 months = 1500
1. The president of Univax, Inc, has just approached the company's bank seeking short-term financ...
The president of Univax, Inc., has just approached the company's bank seeking short-term financing for the coming year, Year 2. Univax is a distributor of commercial vacuum cleaners. The bank has stated that the loan request must be accompanied by a detailed cash budget that shows the quarters in which financing will be needed, as well as the amounts that will be needed and the quarters in which repayments can be made To provide this information for the bank, the...
The president of Univax, Inc., has just approached the company's bank seeking short-term financing for the coming year, Year 2. Univax is a distributor of commercial vacuum cleaners. The bank has stated that the loan request must be accompanied by a detailed cash budget that shows the quarters in which financing will be needed, as well as the amounts that will be needed and the quarters in which repayments can be made. To provide this information for the bank, the...
solve question 1&2&3 please.
as it is able, repay the loan plus accumulated interest at the end of the quarter. 1. Prepare a schedule of expected cash collections for July, August, and September and for the quarter in total. (Leave no cells blank-be certain to enter "0" wherever required. Do not round intermediate calculations. Omit the "S" sign in your response.) Schedule of Expected Cash Collections Cash sales Sales on account: May June July August Total cash collections 2. Prepare...
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 $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...
Herbal Care Corp., a distributor of herb-based sunscreens, is ready to begin its third quarter, in which peak sales occur. The company has requested a $55,600, 90-day loan from its bank to help meet cash requirements during the quarter. Since Herbal Care has experienced difficulty in paying off its loans in the past, the loan officer at the bank has asked the company to prepare a cash budget for the quarter. In response to this request, the following data have...
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...
Problem 8-28 Cash Budget with Supporting Schedules [LO8-2, LO8-4, LO8-7, LO8-8] pothes Westex Products is a wholesale distributor of industrial cleaning products. When the treasurer of Westex Products approached the company's bank late in the current year seeking short-term financing, he was told that money was very tight and that any borrowing over the next year would have to be supported by a detailed statement of cash collections and disbursements. The treasurer also was told that it would be very...