Question

Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the firsRequired: 1. Prepare a schedule that discloses the firms total cash collections for January through March. 2. Prepare a scheRequired: 1. Prepare a schedule that discloses the firms total cash collections for January through March. 2. Prepare a scheComplete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Prepare a schedule that s

0 0
Add a comment Improve this question Transcribed image text
✔ Recommended Answer
Answer #1
1) Cash collections: January February March
Collection of accounts receivable ($175,000*20/100) $35,000
Add: Collection of January Sales ($470,000*60/100); ($470,000*35/100) $282,000 $164,500
Add: Collection of February Sales ($560,000*60/100); ($560,000*35/100) $336,000 $196,000
Add: Collection of March Sales ($575,000*60/100) $345,000
Add: Sale of equipment $17,000
Total Cash Collections $317,000 $500,500 $558,000
2) Cash disbursements: January February March
Payment of accounts payable $68,000
Add: Payment of January purchases ($290,000*70/100); ($290,000*30/100) $203,000 $87,000
Add: Payment of February purchases ($320,000*70/100); ($320,000*30/100) $224,000 $96,000
Add: Payment of March purchases ($440,000*70/100) $308,000
Add: Cash operating costs $95,000 $74,000 $137,000
Total Cash disbursements $366,000 $385,000 $541,000
3) Cash Budget January February March
Beginning cash balance $65,000 $65,000 $131,133
Add: Total receipts $317,000 $500,500 $558,000
   Subtotal $382,000 $565,500 $689,133
Less: Total disbursements ($366,000) ($385,000) ($541,000)
Cash excess (deficiency) before financing $16,000 $180,500 $148,133
Financing:
   Borrowing to maintain $65,000 balance ($65,000 - $16,000) $49,000 $0 $0
   Loan principal repaid $0 ($49,000) $0
   Loan interest paid ($49,000*9/100*1/12 months) $0 ($367.50) $0
Ending cash balance $65,000 $131,133 $148,133
Add a comment
Know the answer?
Add Answer to:
Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for th...
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
  • Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling...

    Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company's accounting records: • All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 35 percent are collected in the following month. Uncollectibles amounting to 5 percent of sales are anticipated, and management believes that only 20 percent of the...

  • Mary and Kay, Inc, a distributor of cosmetics throughout Florida, is in the process of assembling...

    Mary and Kay, Inc, a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of All sales are on account. Sixty percent of customer accounts are collected in the month of sale: 35 percent are collected in the ·Sixty percent of the merchandise purchases are paid for in the month of purchase, the remaining 40 percent are paid for in the 20x1. The following information has been extracted from the company's...

  • Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling...

    Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company’s accounting records: All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 30 percent are collected in the following month. Uncollectibles amounting to 10 percent of sales are anticipated, and management believes that only 20 percent of the accounts...

  • Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling...

    Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company’s accounting records: All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 35 percent are collected in the following month. Uncollectibles amounting to 5 percent of sales are anticipated, and management believes that only 20 percent of the accounts...

  • Mary and Kay, Inc, a distributor of cosmetics throughout Florida, is in the process of assembling...

    Mary and Kay, Inc, a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company's accounting records: All sales are on account. Sixty percent of customer accounts are collected in the month of sale: 35 percent are collected in the following month. Uncollectibles amounting to 5 percent of sales are anticipated, and management believes that only 20 percent of the accounts...

  • Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling...

    Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company's accounting records: All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 30 percent are collected in the following month. Uncollectibles amounting to 10 percent of sales are anticipated, and management believes that only 20 percent of the accounts...

  • Prepare a schedule that summarizes the firm’s financing cash flows for January through March. Mary and...

    Prepare a schedule that summarizes the firm’s financing cash flows for January through March. Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company's accounting records: • All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 30 percent are collected in the following month. Uncollectibles amounting to 10...

  • that only 20 percent of the on 40 percent are paid for in the month after...

    that only 20 percent of the on 40 percent are paid for in the month after . The the month, I 300,000 330,000 450,00e Required: 3. Prepare a schedule that the firm's financing cash flows for January through March . The 31, 20x0 e sheet disclosed the following selected figures cash, $60.000; accounts receivable. $180.000: the month. I s paid at the time of repaying principal and computed on the portion of principal repaid at that time. Required: t Prepare...

  • You have been asked to prepare a December cash budget for Ashton Company, a distributor of...

    You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 will be $39,000. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October $ 65,000 397,000 November $ 65,000 522,000 December $ 82,600 598,000 Sales on account are collected over a three-month period in the...

  • in the and management believes that only 20 percent of 17 . The at all times....

    in the and management believes that only 20 percent of 17 . The at all times. Financing is available (and retired) in $1,000 multiples . Additional data 478,880 113,000 155,808 Reterences Required: of January sales the accounts outstanding on December 31, 20x0, will be recovered and that the recovery will be in January 20xt . The 31, 20x0 . Mary and Kay, Inc. the month. Interest is paid at the time of repaying principal and computed on the portion of...

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