Question

In: Accounting

Honolua Company is preparing a cash budget for November. The company has $150,000 cash at the...

Honolua Company is preparing a cash budget for November.

  • The company has $150,000 cash at the beginning of November and anticipates total sales of $1,000,000, consisting of 25% cash sales and 75% bank credit-card sales.
  • The bank charges 3% for credit-card deposits.
  • The firm sets its selling price at 160% of the cost of purchases and pays the cost of each month's sales at the end of the month.
  • Operating expenses are $45,000 per month, of which $25,000 is depreciation expense.
  • Selling expenses (commissions) each month amount to 4% of total sales dollars.
  • In addition, a $400,000 note will be due in November for equipment purchased last May. In addition to the principal amount, interest for one month (at 12% per year) will be paid in November.
  • Honolua Company has line of credit (LOC) agreement with its bank to borrow up to $100,000 for operations. The LOC agreement requires Honolua Company to maintain a minimum cash balance of $100,000.

Required: Use the Excel worksheet provided with the exam to provide support for answering the following questions. Be sure to write your answers in the boxes below each question.

1. Prepare in good form a cash budget that shows the amount, if any, that the company must borrow during November. Separate your budget, at a minimum, into the following categories:

Beginning Cash Balance

Operating Cash Flows (Both Inflows and Outflows)

Cash Balance before Financing Effects

Financing Activity

Ending Cash Balance

2. What is Honolua Company’s needed LOC borrowing in November under the above budget?

DATA:
Forecasted Sales $          1,000,000
Cash Sales 25%
Bank Credit-Card Sales 75%
Bank Fee on Credit-Card Sales 3%
Sales Price Markup on Cost 160%
Operating Expenses (including Depreciation) $                45,000
Depreciation $                25,000
Sales Commission Rate (bases on Sales $) 4%
Note Due in November (principal) $             400,000
Interest Rate (annual) 12%
Beginning Cash Balance $             150,000
Minimum Cash Balance per LOC agreement $             100,000

Solutions

Expert Solution

a)

The cash budget is as follows with the appropriate excel formulas.

since the company needs a minimum cash balance of 100000,

the required borrowing = 100000 - 38500 = 61500

this will be shown as a cash inflow from financing activity.

( if you have any doubts leave a comment and let me know)


Related Solutions

Transcript Company is preparing a cash budget for June. The company has $145,000 cash at the...
Transcript Company is preparing a cash budget for June. The company has $145,000 cash at the beginning of the month and anticipates having total sales of $1,222,000, consisting of 25% cash sales and 75% credit card sales. The bank charges 3 percent for credit card deposits. The firm sets its selling price at 150 percent of the cost of purchases and pays the cost of each month's sales at the end of the month. Other cash disbursements are $66,000 per...
Transcript Company is preparing a cash budget for June. The company has $125,000 cash at the...
Transcript Company is preparing a cash budget for June. The company has $125,000 cash at the beginning of the month and anticipates having total sales of $1,222,000, consisting of 25% cash sales and 75% credit card sales. The bank charges 3 percent for credit card deposits. The firm sets its selling price at 150 percent of the cost of purchases and pays the cost of each month's sales at the end of the month. Other cash disbursements are $66,000 per...
A company is preparing completing their Cash Budget. The following data has been prepared for cash...
A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash payments 954,500 1,210,000 1,075,000 The company’s cash balance at January 1st is $290,000. This company desires a minimum cash balance of $340,000. What is the amount of excess cash or deficiency of cash (after considering the minimum cash balance required) for February?
5. ABC Company is preparing their master budget and is preparing a schedule of expected cash...
5. ABC Company is preparing their master budget and is preparing a schedule of expected cash collections from sales for the first quarter of 2019. They expect sales in January to be $400,000, February to be $300,000, and March to be $500,000. !0% of the sales will be paid for in cash. The remainder will be charged on account. From past experience, the company knows their customers take 3 months to pay their bills in total, with 40% of a...
A company is preparing their 4th quarter cash summary budget. Based on their beginning cash balance...
A company is preparing their 4th quarter cash summary budget. Based on their beginning cash balance and anticipated cash receipts and cash disbursements (payments), here are the ending cash balances initially planned each month.  The balances shown below are BEFORE any borrowing of money or repayment of loans and interest. Management wants to keep a minimum cash balance of $20,922. Therefore, they will clearly need to borrow money in November. Luckily, December looks like a good month and they will have...
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter....
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter. They have the following budget information available.   1. Estimated sales for July, August, September, and October will be $210,000, $230,000, $220,000, and $240,000. Accounts receivable from June sales are $136,000. All sales are on credit and collected 35% in the month of sale and 65% in the month following sale. 2. Inventory purchases for July, August, and September are budgeted as $129,600, $136,200, and...
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter....
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter. They have the following budget information available.   1. Estimated sales for July, August, September, and October will be $210,000, $230,000, $220,000, and $240,000. Accounts receivable from June sales are $136,000. All sales are on credit and collected 35% in the month of sale and 65% in the month following sale. 2. Inventory purchases for July, August, and September are budgeted as $129,600, $136,200, and...
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter....
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter. They have the following budget information available.   1. Estimated sales for July, August, September, and October will be $210,000, $230,000, $220,000, and $240,000. Accounts receivable from June sales are $136,000. All sales are on credit and collected 35% in the month of sale and 65% in the month following sale. 2. Inventory purchases for July, August, and September are budgeted as $129,600, $136,200, and...
Assume that The AM Bakery is preparing a budget for the month ending November 30. Management...
Assume that The AM Bakery is preparing a budget for the month ending November 30. Management prepares the budget by starting with the actual results for August that is shown below. Then, management considers what the differences in costs will be between August and November. THE AM BAKERY Bakery sales Actual and Budgeted Costs For the Month Ending August 31 Actual Ingredients Flour $ 3,980 Butter 3,580 Oil 1,940 Fruit 1,540 Nuts 980 Chocolate 1,200 Other 800 Total ingredients $...
A company is preparing the production budget
A company is preparing the production budget for the second quarter Projected sales (in units) are as follows: • April 600 Units • May 680 units • June 750 units The company policy decided at the start of the period on 1 April to have an ending finished goods stocks of 20% of the next month's projected sales. Assuming that there was no opening stock for April, what should be the production quota for May? Select one: O a. 680 units O b. 666 units O c....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT