Question

Herbal Care Corp., a distributor of herb-based sunscreens, is ready to begin its third quarter, in which peak sales o cour. T2. Prepare a cash budget, by month and in total, for the third quarter. (Cash deficiency, repayments and interest should be i

0 0
Add a comment Improve this question Transcribed image text
Answer #1
1. Herbal Care Corp.
Schedule of Expected Cash Collections
July August September Quarter
From Account receivables:
May sales 12300 12300
June sales 315000 13500 328500
From budgeted sales
July sales 142500 399000 17100 558600
August sales 195000 546000 741000
September Sales 100000 100000
Total cash collections 469800 607500 663100 1740400
2. Herbal Care Corp.
Cash Budget
July August September Quarter
Beginning cash balance 53500 1000 46700 53500
Add receipts: Collection and customers 469800 607500 663100 1740400
Total cash available 523300 608500 709800 1793900
Less cash disbursements:
merchandise purchases $   270.000,00 $ 342.000,00 $ 468.000,00 $ 1.080.000,00
Salaries and wages $      42.500,00 $    64.000,00 $   65.000,00 $     171.500,00
Advertising $   230.000,00 $ 146.000,00 $ 106.000,00 $     482.000,00
Rent payments $        9.800,00 $       9.800,00 $     9.800,00 $       29.400,00
Equipment purchases $      10.000,00 $                   -   0 $       10.000,00
Total Cash disbursements $   562.300,00 $ 561.800,00 $ 648.800,00 $ 1.772.900,00
Excess (deficiency) of cash available over disbursements $    -39.000,00 $    46.700,00 $   61.000,00 $       21.000,00
Financing   
Borrowings 40000 $    0 40000
Repayments $    40000 $       40.000,00
Interest $    1200 $         1.200,00
Total financing 40000 0 -41200 -1200
Ending cash balance $        1.000,00 $    46.700,00 $   19.800,00 $       19.800,00

Working notes

a. opening balance 53500
b. Actual sales for last two months and budgeted sales for the 3rd Quarter
may June July august september
Sales $ 410.000,00 $     450.000,00 $ 570.000,00 $ 780.000,00 $ 400.000,00
current month receipt 25 $ 102.500,00 25 $     112.500,00 25 $ 142.500,00 25 $ 195.000,00 25 $ 100.000,00
previous months receipt 70 $     287.000,00 70 $ 315.000,00 70 $ 399.000,00 70 $ 546.000,00
2month back 3 $   12.300,00 3 $   13.500,00 3 $   17.100,00
Cash collected from sales $ 469.800,00 $ 607.500,00 $ 663.100,00
uncollectable 2 $   11.400,00 2 $   15.600,00 2 $     8.000,00
Cash collected from sales $ 469.800,00 + $ 607.500,00 + $ 663.100,00
c. Purchases and budgeted expenses for the 3rd Quarter
june july august september
Merchandise purchases 270000 $ 270.000,00 $ 342.000,00 $ 468.000,00
Salaries and wages $   42.500,00 $     64.000,00 $   65.000,00
Advertising $ 230.000,00 $ 146.000,00 $ 106.000,00
Rent payments $     9.800,00 $       9.800,00 - $     9.800,00 -
d equipment cost
July $    10.000,00 -
e. Loan made
July $    40.000,00 +
September $    40.000,00 -
interest $       1.200,00 -
Add a comment
Know the answer?
Add Answer to:
Herbal Care Corp., a distributor of herb-based sunscreens, is ready to begin its third quarter, in...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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)....

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT