Question

Lois Bragg owns a small restaurant in Boston. Ms. Bragg provided her accountant with the following...

Lois Bragg owns a small restaurant in Boston. Ms. Bragg provided her accountant with the following summary information regarding expectations for the month of June. The balance in accounts receivable as of May 31 is $55,000. Budgeted cash and credit sales for June are $148,000 and $581,000, respectively. Credit sales are made through Visa and MasterCard and are collected rapidly. Eighty percent of credit sales is collected in the month of sale, and the remainder is collected in the following month. Ms. Bragg's suppliers do not extend credit. Consequently, she pays suppliers on the last day of the month. Cash payments for June are expected to be $717,000. Ms. Bragg has a line of credit that enables the restaurant to borrow funds on demand; however, they must be borrowed on the last day of the month. Interest is paid in cash also on the last day of the month. Ms. Bragg desires to maintain a $37,000 cash balance before the interest payment. Her annual interest rate is 11 percent.

Required

  1. Compute the amount of funds Ms. Bragg needs to borrow for June.

  2. Determine the amount of interest expense the restaurant will report on the June pro forma income statement.

  3. What amount will the restaurant report as interest expense on the July pro forma income statement? (Round your answers to 2 decimal places.)

Homework Answers

Answer #1

Note

If you have any queries kindly post a comment, i will solve it earliest.

If you satisfied with my answer, kindly give a thumbs up, it will help to encourage me.

Know the answer?
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
Similar Questions
Genesis Corp. is a traditional retailer that recently also started an Internet-based subsidiary that sells its...
Genesis Corp. is a traditional retailer that recently also started an Internet-based subsidiary that sells its product online. Its sales in September 2017 were $700,000. Tom Scott, the company president, is preparing for a meeting with Dan Harris, a loan officer with Mojito Bank, to review year end financing requirements. After discussions with the company’s marketing and finance managers, sales over the next three months were forecasted as follows. Sales in October 2017: $2,500,000, sales in November 2017: $3,500,000 and...
Beech’s managers have made the following additional assumptions and estimates: 1. Estimated sales for July, August,...
Beech’s managers have made the following additional assumptions and estimates: 1. Estimated sales for July, August, September, and October will be $280,000, $300,000, $290,000, and $310,000, respectively. 2. All sales are on credit and all credit sales are collected. Each month’s credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at June 30 will be collected in July. 3. Each month’s ending inventory must equal 25%...
Aztec Company sells its product for $180 per unit. Its actual and budgeted sales follow. Units...
Aztec Company sells its product for $180 per unit. Its actual and budgeted sales follow. Units Dollars April (actual) 4,500 $ 810,000 May (actual) 2,200 396,000 June (budgeted) 7,500 1,350,000 July (budgeted) 5,000 900,000 August (budgeted) 3,600 648,000 All sales are on credit. Recent experience shows that 30% of credit sales is collected in the month of the sale, 40% in the month after the sale, 29% in the second month after the sale, and 1% proves to be uncollectible....
Harlan Venture Inc. (HV) operates a restaurant named Harlan's in Toronto. The shareholder, Stephen Painter, is...
Harlan Venture Inc. (HV) operates a restaurant named Harlan's in Toronto. The shareholder, Stephen Painter, is concerned whether the system and controls in place at the restaurant are appropriate to monitor and control the operations of the restaurant and to make sure that employees don't steal. He provides the following information: Restaurant operations The restaurant manager's duties include looking after reservations, seating customers, and managing the restaurant's operations. Servers take the customer orders and enter them into a system that...
Beech’s managers have made the following additional assumptions and estimates: 1. Estimated sales for July, August,...
Beech’s managers have made the following additional assumptions and estimates: 1. Estimated sales for July, August, September, and October will be $210,000, $230,000, $220,000, and $240,000, respectively. 2. All sales are on credit and all credit sales are collected. Each month’s credit sales are collected 45% in the month of sale and 55% in the month following the sale. All of the accounts receivable at June 30 will be collected in July. 3. Each month’s ending inventory must equal 20%...
Required information [The following information applies to the questions displayed below.] Hamby Corporation is a merchandising...
Required information [The following information applies to the questions displayed below.] Hamby Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Hamby Corporation Balance Sheet June 30 Assets Cash $ 81,000 Accounts receivable 132,000 Inventory 56,250 Plant and equipment, net of depreciation 214,000 Total assets $ 483,250 Liabilities and Stockholders’ Equity Accounts payable $ 75,000 Common stock 346,000 Retained...
The city of Charleston had the following sales of water for the selected months of 2017:...
The city of Charleston had the following sales of water for the selected months of 2017: Month Sales February $60,000 March 45,000 April 60,000 May 42,500 June                    100,000 July 120,000 All sales are on credit. Historically, 60 percent is collected in the month of sale, 30 percent during the first month following the sale, and 10percent in the second month following the sale. Water purchases by month are as follows: Month February $60,000 March 40,000 April 45,000 May 59,750 June...
Consider the following information provided by a Travel Agency: Sales (€) June July August September October...
Consider the following information provided by a Travel Agency: Sales (€) June July August September October November 180 000 220 000 220 000 310 000 500 000 200 000 60% of the sales are for credit and are collected one month after the sale. Other receipts: €60 000 in October Monthly Gross Margin of 30% Fixed Costs: €8 000 Taxes in July: €75 000 Debt repayment in November: €400 000 Cash at the Beginning of June: €50 000 Minimum operating...
Required information [The following information applies to the questions displayed below.] Hamby Corporation is a merchandising...
Required information [The following information applies to the questions displayed below.] Hamby Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Hamby Corporation Balance Sheet June 30 Assets Cash $ 81,000 Accounts receivable 132,000 Inventory 56,250 Plant and equipment, net of depreciation 214,000 Total assets $ 483,250 Liabilities and Stockholders’ Equity Accounts payable $ 75,000 Common stock 346,000 Retained...
COURSE PROJECT 1 INSTRUCTIONS You have just been contracted as a new management trainee by Earrings...
COURSE PROJECT 1 INSTRUCTIONS You have just been contracted as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT