Question

Harrys Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mb. Prepare a schedule of monthly cash payments for January, February, and March. Harrys Carryout Stores Cash Payments Schedu

0 0
Add a comment Improve this question Transcribed image text
✔ Recommended Answer
Answer #1
a. Cash receipts schedule
November December January February March
Sales 240000 260000 320000 360000 370000
Credit sales (40% of sales) 96000 104000 128000 144000 148000
Cash sales (60% of sales) 192000 216000 222000
One month after sale 31200 38400 43200
(104000*30%) (128000*30%) (144000*30%)
Two months after sale 67200 72800 89600
(96000*70%) (104000*70%) (128000*70%)
Total cash receipts 290400 327200 354800
b. Cash payments schedule
January February March
Payments for purchases (Note:1) 96000 108000 111000
Labor expense (40% of sales) 128000 144000 148000
Selling and administrative (15% of sales) 48000 54000 55500
Overhead 22000 22000 22000
Taxes 8200
Dividends 3000
Total cash payments 302200 328000 339500
Note:1
Payments for purchases:
December January February March
Next month sales a 320000 360000 370000 360000
Material cost b=a*30% 96000 108000 111000 108000
Payment:
One month after purchase 96000 108000 111000
c. Cash budget
January February March
Total cash receipts 290400 327200 354800
Total cash payments 302200 328000 339500
Net cash flow -11800 -800 15300
Beginning cash balance 84000 79000 79000
Cumulative cash balance 72200 78200 94300
Monthly loan (or repayment) 6800 800 -7600
(79000-72200) (79000-78200)
Ending cash balance 79000 79000 86700
Cumulative loan balance 6800 7600 0
I appreciate your ratings
Add a comment
Know the answer?
Add Answer to:
Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do t...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and...

    Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecast sales figures: Actual Forecast Additional Information November $240,000 January $320,000 April forecast $360,000 December 260,000 February 360,000 March 370,000 Of the firm's sales, 60 percent are for cash and the...

  •      Harry's Carryout Stores has eight locations, The firm wishes to expand by two more stores...

         Harry's Carryout Stores has eight locations, The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecasted sales figures: Actual Forecast Additional Information November 360,000 January 440,000 April forecast December 380,000 February480,000 $420,000 March 430,000 Of the firm's sales, 50 percent are for cash and ther...

  • Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and...

    Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecast sales figures: Actual Forecast Additional Information November $280,000 January $360,000 April forecast $380,000 December 300,000 February 400,000 March 390,000 Of the firm's sales, 40 percent are for cash and the...

  • Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and...

    Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this, Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three month financial plan for January through March. The following are actual and forecast sales figures: Actual Forecast Additional Information November $340,000 January $420,000 April forecast $410,000 December 360,000 February 460,000 March 420,000 Of the firm's sales, 30 percent are for cash and...

  • please help Che Harry's Carryout Stores has eight locations. The firm wishes to expand by two...

    please help Che Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecast sales figures: Actual Forecast Additional Information November $240, 8 January $320,000 April forecast $360,000 December 260,00 February 360,000 March 370,000 of the firm's sales, 60 percent are...

  • Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and...

    Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecasted sales figures Actual Forecast Additional Information November $560,000 January S640,000ADr December 580,000 February 680,000 $520,000 forecast March 530,000 Of the firm's sales, 50 percent are for cash and the remaining...

  • Harry’s Carryout Stores has eight locations. The firm wishes to expand by two more stores and nee...

    Harry’s Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecasted sales figures:      Actual Forecast Additional Information November $460,000 January $540,000 April forecast $470,000 December 480,000 February 580,000 March 480,000 Of the firm’s sales, 50 percent are for cash and the...

  • Harry’s Carryout Stores has eight locations. The firm wishes to expand by two more stores and...

    Harry’s Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecasted sales figures:      Actual Forecast Additional Information November $420,000 January $500,000 April forecast $450,000 December 440,000 February 540,000 March 460,000 Of the firm’s sales, 40 percent are for cash and...

  • The firm wishes to expand by tao more stores and neods a bank loan to do...

    The firm wishes to expand by tao more stores and neods a bank loan to do this. Mr. Wison, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecasted sales figures: Actual Forecast Addiiona November$680,000 Janwary $760,000 Apni forecast December700,000 February 800,000 $580,000 March 590,000 45 percent are for cash and the remaining 55 percent are on credit. Of credit sales, 40 percent are paid...

  • Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and...

    Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecasted sales figures: Of the firm's sales, 60 percent are for cash and the remaining 40 percent are on credit. Of credit sales, 20 percent are paid in the month after...

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