Purchase Solution

Herbal Care Corp cash receipts collections budget

Not what you're looking for?

Ask Custom Question

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 been assembled:

a. On July 1, the beginning of the third quarter, the company will have a cash balance of $44,500.
b. Actual sales for the last two months and budgeted sales for the third quarter follow (all sales are on account):

May (actual) $ 250,000
June (actual) $ 300,000
July (budgeted) $ 400,000
August (budgeted) $ 600,000
September (budgeted) $ 320,000

Past experience shows that 25% of a month's sales are collected in the month of sale, 70% in the month following sale, and 3% in the second month following sale. The remainder is uncollectible.

Purchase this Solution

Solution Summary

Your tutoring is in Excel, attached. The cash receipts (collections) budget is created for you and then the start of the cash budget is shown with the given amounts in it and the line items to give you the template for the full complete budget.

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Introduction to Finance

This quiz test introductory finance topics.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.