Question

II. Problems dget for May. The following forec May Ancil $ 16,000 $157,500 Beginning Loan Balance Merchandise purchases Opera
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer:

(a) Cash to be received in May:
Particulars Amount ($)
Cash Received for May Sales (50% of current month sales)           78,750
(1,57,500*50%)
Cash Received in May for April Sales (50% of April sales)           66,750
(1,33,500*50%)
Total Cash Collection from customers in May        1,45,500
The above is to be disclosed as "Cash receipts from Sales" in the cash budget
(b) Cash to be paid in May:
Particulars Amount ($)
Cash paid in May for May Purchases (40% of current month purchases)           44,960
(1,12,400*40%)
Cash paid in May for April Purchases (60% of April purchases)           64,200
(1,07,000*60%)
Total Cash paid in May for purchases        1,09,160
The above is to be disclosed as "Cash payments for purchases" in the cash budget
Add a comment
Know the answer?
Add Answer to:
II. Problems dget for May. The following forec May Ancil $ 16,000 $157,500 Beginning Loan Balance...
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
  • TI-1706SV I1. Problems Sweeny Co. is preparing a cash budget for May. The following forecasted data...

    TI-1706SV I1. Problems Sweeny Co. is preparing a cash budget for May. The following forecasted data is available: 1. April May Beginning Loan Balance Sales Merchandise purchases Operating expenses (all paid in cash): Payroll Advertising $36,000 $177,500 132,400 $150,500 $127.000 16,280 7,700 3,500 Rent Additional data: (1) Loan balance at beginning of May is $36,000 (as noted above). Interest due each month is 26 of loan balance. (2) Any cash balance above $40,000 is used to repay as much of...

  • The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING...

    The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash $ 42,000 Accounts receivable 364,000 Raw materials inventory 107,200 Finished goods inventory 349,440 Total current assets 862,640 Equipment, gross 604,000 Accumulated depreciation (152,000) Equipment, net 452,000 Total assets $1,314,640 Liabilities and Equity Accounts payable $ 211,300 Short-term notes payable 14,000 Total current liabilities 225,300 Long-term note payable 510,000 Total liabilities 735,300 Common stock 337,000 Retained earnings...

  • just need help with #8 (the first three pics) Cash budget. (Negative balances and Loan repayment amounts (if an...

    just need help with #8 (the first three pics) Cash budget. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.) Calculation of Cash receipts from customers: April May June Total budgeted sales 40,000 S 124,296 83347 Cash sales 30%| Sales on credit Book 70% Ask Total cash receipts from customers Print April May June Ferences Current month's cash sales Collections of receivables Total cash receipts $ 0 $ ZIGBY MANUFACTURING Cash Budget April, May, and...

  • Check my wor 6 The president of the retailer Prime Products has just approached the company's bank with a request for a $75,000, 90-day loan. The purpose of the loan is to assist the company in a...

    Check my wor 6 The president of the retailer Prime Products has just approached the company's bank with a request for a $75,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April...

  • The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017 ZIGBY MANUFACTURING...

    The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017 ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment, gross Accumulated depreciation Equipment, net Total assets 43,000 432,900 86,198 387,168 949,266 606,000 (153, 000) 453,000 $1,402,266 Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders equity 194,798 15,000 209,798 500,000...

  • The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017 ZIGBY MANUFACTURING...

    The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017 ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment, gross Accumulated depreciation Equipment, net Total assets $ 56,000 341,250 84,200 337,680 819,130 632,000 166,008 466,000 $ 1,285,130 Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total 1iabilities Common stock Retained earnings Total stockholders' equity Total liabilities and...

  • Required 1 Required 2 Calculate the expected cash collections for April, May, and June, and for...

    Required 1 Required 2 Calculate the expected cash collections for April, May, and June, and for the three months in total April Quarter May June Total cash collections Required 1 Required 2 Complete this question by entering your answers in the tabs below Required 1 Required 2 Prepare a cash budget, by month and in total, for the three-month period. (Cash deficiency, repayments and interest should be indicated by a minus sign.) Prime Products Cash Budget April May June Quarter...

  • Minden Company is a wholesale distributor of premium European chocolates. The company's balance sheet on April...

    Minden Company is a wholesale distributor of premium European chocolates. The company's balance sheet on April 30 is as follows: MINDEN COMPANY Balance Sheet April 30 Assets Cash Accounts receivable, customers Inventory Buildings and equipment, net of depreciation $ 15.400 62,000 34,800 239,000 Total assets $351,200 Liabilities and Shareholders' Equity Accounts payable, suppliers $ 72,600 Note payable 17,700 Capital shares, no par 212,000 Retained earnings 48,900 Total liabilities and shareholders' equity $351,200 The company is in the process of preparing...

  • The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING...

    The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash 58,000 484,640 91,290 Accounts receivable Raw materials inventory Finished goods inventory 393,304 Total current assets 1,027,234 Equipment, gross Accumulated depreciation Equipment, net 636,000 168,000) 468,000 $1,495,234 Total assets Liabilities and Equity Accounts payable Short-term notes payable 206,390 30,000 Total current liabilities 236,390 Long-term note payable Total liabilities 525,000 761,390 Common stock 353,000 Retained earnings 380,844 Total...

  • April May June July $710,000 $880,000 $590,000 $490,000 497,000 616,000 413,000 343,000 213,000 264,000 177,000 147,000...

    April May June July $710,000 $880,000 $590,000 $490,000 497,000 616,000 413,000 343,000 213,000 264,000 177,000 147,000 Sales Cost of goods sold Gross margin- Selling and administrative expenses: Selling expense Administrative expense Total selling and administrative expenses Net operating income 89,000 108,000 70,000 49,000 49,500 67,200 43,400 47,000 138,500 175,200 113,400 96,000 $ 74,500 $ 88,800 $ 63,600 $ 51,000 *Includes $31,000 of depreciation each month. b Sales are 20% for cash and 80% on account. b. Sales are 20% for...

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