Please give positive ratings so I can keep answering. Thanks! |
Cash collection schedule | Year 2- Qtr. 1 | Year 2- Qtr. 2 | Year 2- Qtr. 3 | Year 2- Qtr. 4 | Total | Particulars | Year 1- Qtr. 4 | Year 2- Qtr. 1 | Year 2- Qtr. 2 | Year 2- Qtr. 3 | Year 2- Qtr. 4 | Total | Note C | |
Year-1 Fourth Qtr. Sales | 200,000.00 | 200,000.00 | Note C | Sales revenue | 400,000.00 | 500,000.00 | 600,000.00 | 700,000.00 | 580,000.00 | 2,380,000.00 | ||||
Year-2 First Qtr. Sales | 240,000.00 | 250,000.00 | 490,000.00 | Note C | Collection in Same qtr.- 48% | 192,000.00 | 240,000.00 | 288,000.00 | 336,000.00 | 278,400.00 | 1,142,400.00 | |||
Year-2 Second Qtr. Sales | 288,000.00 | 300,000.00 | 588,000.00 | Note C | Collection in next qtr.- 50% | 200,000.00 | 250,000.00 | 300,000.00 | 350,000.00 | 290,000.00 | 1,190,000.00 | |||
Year-2 Third Qtr. Sales | 336,000.00 | 350,000.00 | 686,000.00 | Note C | ||||||||||
Year-2 Fourth Qtr. Sales | 278,400.00 | 278,400.00 | Note C | Merchandise purchases | 300,000.00 | 380,000.00 | 430,000.00 | 490,000.00 | 460,000.00 | 1,760,000.00 | Note D | |||
Total cash collections | 440,000.00 | 538,000.00 | 636,000.00 | 628,400.00 | 2,242,400.00 | Paid in Same qtr.- 15% | 45,000.00 | 57,000.00 | 64,500.00 | 73,500.00 | 69,000.00 | 264,000.00 | ||
Paid in next qtr.- 85% | 255,000.00 | 323,000.00 | 365,500.00 | 416,500.00 | 391,000.00 | 1,496,000.00 | ||||||||
Cash disbursement for purchases | Year 2- Qtr. 1 | Year 2- Qtr. 2 | Year 2- Qtr. 3 | Year 2- Qtr. 4 | Total | |||||||||
Year-1 Fourth Qtr. Purchases | 255,000.00 | 255,000.00 | Note D | Selling & admin | 64,000.00 | 64,000.00 | 64,000.00 | 64,000.00 | 256,000.00 | Note E | ||||
Year-2 First Qtr. Purchases | 57,000.00 | 323,000.00 | 380,000.00 | Note D | Sales commission at 8% | 40,000.00 | 48,000.00 | 56,000.00 | 46,400.00 | 190,400.00 | ||||
Year-2 Second Qtr. Purchases | 64,500.00 | 365,500.00 | 430,000.00 | Note D | Total Operating Expenses | 104,000.00 | 112,000.00 | 120,000.00 | 110,400.00 | 446,400.00 | ||||
Year-2 Third Qtr. Purchases | 73,500.00 | 416,500.00 | 490,000.00 | Note D | ||||||||||
Year-2 Fourth Qtr. Purchases | 69,000.00 | 69,000.00 | Note D | |||||||||||
Total cash disbursements | 312,000.00 | 387,500.00 | 439,000.00 | 485,500.00 | 1,624,000.00 | |||||||||
Cash disbursement for Selling | Year 2- Qtr. 1 | Year 2- Qtr. 2 | Year 2- Qtr. 3 | Year 2- Qtr. 4 | Total | |||||||||
Year-2 First Qtr. | 104,000.00 | 112,000.00 | 120,000.00 | 110,400.00 | 446,400.00 | Note E | ||||||||
Cash flow schedule | January | February | March | Total | ||||||||||
Beginning cash balance | 41,000.00 | 54,000.00 | 45,500.00 | 41,300.00 | ||||||||||
Add: Collection from sales | 440,000.00 | 538,000.00 | 636,000.00 | 628,400.00 | 2,242,400.00 | |||||||||
Total cash available | 481,000.00 | 592,000.00 | 681,500.00 | 669,700.00 | ||||||||||
Less: Disbursement | ||||||||||||||
Merchandise Purchases | 312,000.00 | 387,500.00 | 439,000.00 | 485,500.00 | 1,624,000.00 | |||||||||
Operating Expenses | 104,000.00 | 112,000.00 | 120,000.00 | 110,400.00 | 446,400.00 | |||||||||
Dividends | 11,000.00 | 11,000.00 | 11,000.00 | 11,000.00 | 44,000.00 | |||||||||
Land | - | 86,000.00 | 49,000.00 | - | 135,000.00 | |||||||||
Total Disbursements | 427,000.00 | 596,500.00 | 619,000.00 | 606,900.00 | ||||||||||
Cash excess (deficiency) before financing | 54,000.00 | (4,500.00) | 62,500.00 | 62,800.00 | ||||||||||
Financing: | ||||||||||||||
Borrowing to maintain $39,000 balance | - | 50,000.00 | - | - | 50,000.00 | |||||||||
Loan principal repaid | - | - | 20,000.00 | 20,000.00 | 40,000.00 | |||||||||
Loan interest paid | - | - | 1,200.00 | 1,800.00 | 3,000.00 | |||||||||
Ending cash balance | 54,000.00 | 45,500.00 | 41,300.00 | 41,000.00 | ||||||||||
Interest on loan will be 1% of 20,000 for each month for 6 months i.e. 20,000*1%*6= $ 1,200. | ||||||||||||||
Interest on loan will be 1% of 20,000 for each month for 9 months i.e. 20,000*1%*9= $ 1,800. | ||||||||||||||
Full loan us not repaid because company has to keep minimum of $ 39,000 cash balance. |
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 b...
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...
1. The president of Univax, Inc, has just approached the company's bank seeking short-term financing for the coming year, 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. Year 2. Univax is a distributor of commercial vacuum cleaners. The bank has stated that the To provide this information for the bank,...
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 $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...
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...
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...
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 $40,000, 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...