1.Schedule of Expected Cash Collections:
July |
August |
September |
Total |
|
25% in the month of Sale |
87,500 |
93,750 |
55,000 |
236,250 |
70% in following month |
175,000 |
245,000 |
262,500 |
682,500 |
3% in second month following the same |
6,000 |
7,500 |
10,500 |
24,000 |
Expected Cash Collections |
268,500 |
346,250 |
328,000 |
942,750 |
2. Cash Budget:
July |
August |
September |
Total |
|
Opening Balance |
24,000 |
11,000 |
15,250 |
24,000 |
Add: Cash Collections |
268,500 |
346,250 |
328,000 |
942,750 |
Loan Taken |
20,000 |
20,000 |
||
Total Available Cash |
312,500 |
357,250 |
343,250 |
986,750 |
Less: Merchandise Payments |
157,500 |
210,000 |
218,750 |
586,250 |
Salaries and Wages |
52,000 |
54,000 |
53,000 |
159,000 |
Advertising |
65,000 |
72,000 |
40,000 |
177,000 |
Rent Payments |
6,000 |
6,000 |
6,000 |
18,000 |
Equipment purchase |
21,000 |
21,000 |
||
Repayment of Loan |
20,000 |
20,000 |
||
Interest on Loan |
600 |
600 |
||
Total Payments |
301,500 |
342,000 |
338,350 |
981,850 |
Ending Cash Balance |
11,000 |
15,250 |
4,900 |
4,900 |
Depreciation is a non-cash expenditure, it is not considered in cash budget.
3.If the company needs a minimum cash balance of $10,000 each month, the loan cannot be repaid as planned. Since after paying the loan, the cash balance will reach $4,900
Problem 8 Herbal Care Corp., a distributor of herb-based sunscreens, is ready to begin its third...
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...
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...
Herbal Care Corp., a distributor of herb-based sunscreens, is ready to begin its third quarter, in which peak sales o cour. 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...
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...
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...
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...
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...
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 McClain Corp. is a distributor of hair care products and is ready to start the third quarter, in which its peak sales occur. The company has requested a $ 75,000, 90-day loan from its bank to help them meet their cash requirements for the third quarter. Because McClain Corp has experienced difficulty in paying off their loans in previous years, the loan officer has requested the company to prepare a cash budget for the third quarter. The following data...
Please show workings! I want to understand this problem. Thank you so much, I'll be sure to give a thumbs up as I know it help you guys. 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...