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 $57,000. Budgeted cash and credit sales for June are $145,000 and $586,000, respectively. Credit sales are made through Visa and MasterCard and are collected rapidly. Sixty 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 $707,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 $34,000 cash balance before the interest payment. Her annual interest rate is 9 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 answer to 2 decimal places.)

a. Amount to be borrowed
b. Interest expense (June)
c. Interest expense (July)
0 0
Add a comment Improve this question Transcribed image text
Answer #1

a)

Cash collection:
A Collection from May's receivables balance $57,000
B Collection from June's credit sales ($586,000 × 60%) $351,600
C Cash sales from June $145,000
D Total cash receipts (A+ B + C) $553,600
E Desired cash balance $34,000
F Cash Disbursement $707,000
G Total cash needs (E+F) $741,000
H Cash Shortage (G - D) $187,400

$187,400 is the amount of funds Ms. Bragg needs to borrow for June.

_______________________________________________________________________

b)

Interest expense (June) = $0, because amount is borrowed on the last day in the month of june.

______________________________________________________________________

c)

Interest expene (July) = Amount borrowed  \times 9% \times 1/12 months

= $187,400 \times 9% \times 1/12

= $1,405.5

Add a comment
Know the answer?
Add Answer to:
Lois Bragg owns a small restaurant in Boston. Ms. Bragg provided her accountant with the following...
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
  • 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 $57,000. Budgeted cash and credit sales for June are $144,000 and $581,000, respectively. Credit sales are made through Visa and MasterCard and are collected rapidly. Sixty percent of credit sales is collected in the month of sale, and the remainder is collected in the following...

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

    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 $59,000. Budgeted cash and credit sales for June are $146,000 and $582,000, respectively. Credit sales are made through Visa and MasterCard and are collected rapidly. Seventy five percent of credit sales is collected in the month of sale, and the remainder is collected in the...

  • help please Lols Bragg owns a small restaurant in Boston. Ms. Bragg provided her accountant with...

    help please Lols 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 $58,000. Budgeted cash and credit sales for June are $149,000 and $580,000, respectively. Credit sales are made through Visa and MasterCard and are collected rapidly. Seventy percent of credit sales is collected in the month of sale, and the remainder is collected in...

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

    Lois Braggs 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 the cash account as of May 31 is $50,000. Budgeted sales for June are $310,000. Ms. Braggs is required to pay her suppliers on the last day of each month; cash payments for June are expected to be $350,000. Ms. Braggs has a line of credit that enables the restaurant to borrow...

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

    Lois Braggs 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 the cash account as of May 31 is $50,000. Budgeted sales for June are $310,000. Ms. Braggs is required to pay her suppliers on the last day of each month; cash payments for June are expected to be $350,000. Ms. Braggs has a line of credit that enables the restaurant to borrow...

  • The accountant for Gibson’s Dress Shop prepared the following cash budget. Gibson’s desires to maintain a...

    The accountant for Gibson’s Dress Shop prepared the following cash budget. Gibson’s desires to maintain a cash cushion of $22,000 at the end of each month. Funds are assumed to be borrowed and repaid on the last day of each month. Interest is charged at the rate of 1 percent per month. Required Complete the cash budget by filling in the missing amounts. Determine the amount of net cash flows from operating activities Gibson’s will report on the third quarter...

  • The accountant for Perez's Dress Shop prepared the following cash budget. Perez's desires to maintain a...

    The accountant for Perez's Dress Shop prepared the following cash budget. Perez's desires to maintain a cash cushion of $15,000 at the end of each month. Funds are assumed to be borrowed and repaid on the last day of each month. Interest is charged at the rate of 1 percent per month. Required a. Complete the cash budget by filling in the missing amounts. b. Determine the amount of net cash flows from operating activities Perez's will report on the...

  • The accountant for Rundle’s Dress Shop prepared the following cash budget. Rundle’s desires to maintain a...

    The accountant for Rundle’s Dress Shop prepared the following cash budget. Rundle’s desires to maintain a cash cushion of $16,000 at the end of each month. Funds are assumed to be borrowed and repaid on the last day of each month. Interest is charged at the rate of 2 percent per month. Required Complete the cash budget by filling in the missing amounts. Determine the amount of net cash flows from operating activities Rundle’s will report on the third quarter...

  • The accountant for Franklin's Dress Shop prepared the following cash budget. Franklin's desires to maintain a...

    The accountant for Franklin's Dress Shop prepared the following cash budget. Franklin's desires to maintain a cash cushion of $21,000 at the end of each month. Funds are assumed to be borrowed and repaid on the last day of each month. Interest is charged at the rate of 3 percent per month. Required a. Complete the cash budget by filling in the missing amounts b. Determine the amount of net cash flows from operating activities Franklin's will report on the...

  • The accountant for Vernon’s Dress Shop prepared the following cash budget. Vernon’s desires to maintain a...

    The accountant for Vernon’s Dress Shop prepared the following cash budget. Vernon’s desires to maintain a cash cushion of $21,000 at the end of each month. Funds are assumed to be borrowed and repaid on the last day of each month. Interest is charged at the rate of 1 percent per month. Required Complete the cash budget by filling in the missing amounts. Determine the amount of net cash flows from operating activities Vernon’s will report on the third quarter...

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