Required Budgets are as prepared below:
Herbal Care Corp. | ||||
Schedule of expected Cash collections | ||||
Particulars | July | August | September | Quarter |
From Account Receivable: | ||||
May Sales | 11,100 | |||
June Sales | 287,000 | 12,300 | 299,300 | |
From budgeted sales: | ||||
July Sales | 132,500 | 371,000 | 15,900 | 519,400 |
August Sales | 185,000 | 518,000 | 703,000 | |
September sales | 95,000 | 95,000 | ||
Total cash collections | 430,600 | 568,300 | 628,900 | 1,616,700 |
Herbal Care Corp. | ||||
Cash Budget | ||||
Particulars | July | August | September | Quarter |
Beginning Cash balance | 51,500 | 1,100 | 42,400 | 51,500 |
Add: Collection from customers | $430,600 | $568,300 | $628,900 | 1,627,800 |
Total cash available | $482,100 | $569,400 | $671,300 | $1,679,300 |
Less: cash Disbursements | ||||
Merchandise purchase | ($246,000) | ($318,000) | ($444,000) | -1,008,000 |
Salaries and wages | -46,000 | -60,000 | -61,000 | -167,000 |
Advertising | -210,000 | -140,000 | -101,000 | -451,000 |
Rent payments | -9,000 | -9,000 | -9,000 | -27,000 |
Equipment purchase | -10,000 | -10,000 | ||
Total cash disbusrement | -521,000 | -527,000 | -615,000 | -1,663,000 |
Excess (deficiency) of cash available over disbursement | -38,900 | 42,400 | 56,300 | 16,300 |
Financing | ||||
Borrowing | 40,000 | 40,000 | ||
Repayment | -40,000 | -40,000 | ||
Interest | -1,200 | -1,200 | ||
Total Financing | 40,000 | 0 | -41,200 | -1,200 |
Ending cash balance | 1,100 | 42,400 | 15,100 | 15,100 |
Herbal Care Corp., a distributor of herb-based sunscreens, is ready to begin its third quarter, in...
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...
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...
Problem 8 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 $20,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...
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...
1. 2. A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $5,000 to start each quarter. Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.) Cash Budget 1 Quarter (000 omitted) 2 3 4 Year Cash balance, beginning Add collections from customers Total cash available 99 348 I Less disbursements: Purchase...