Question

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 outstanding on December 31, 20x0, will be recovered and that the recovery will be in January 20x1.

Seventy percent of the merchandise purchases are paid for in the month of purchase; the remaining 30 percent are paid for in the month after acquisition.

The December 31, 20x0, balance sheet disclosed the following selected figures: cash, $75,000; accounts receivable, $195,000; and accounts payable, $72,000.

Mary and Kay, Inc. maintains a $75,000 minimum cash balance at all times. Financing is available (and retired) in $1,000 multiples at an 8 percent interest rate, with borrowings taking place at the beginning of the month and repayments occurring at the end of the month. Interest is paid at the time of repaying principal and computed on the portion of principal repaid at that time.

Additional data:

January February March
Sales revenue $ 510,000 $ 600,000 $ 615,000
Merchandise purchases 330,000 360,000 480,000
Cash operating costs 99,000 78,000 141,000
Proceeds from sale of equipment 21,000

Required:

Prepare a schedule that discloses the firm’s total cash collections for January through March.

Prepare a schedule that discloses the firm’s total cash disbursements for January through March.

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

Prepare a schedule that discloses the firm’s total cash collections for January through March.

January February March
Collection of accounts receivable
Collection of January sales
Collection of February sales
Collection of March sales
Sale of equipment
Total cash collections

Prepare a schedule that discloses the firm’s total cash disbursements for January through March.

January February March
Payment of accounts payable
Payment of January purchases
Payment of February purchases
Payment of March purchases
Cash operating costs
Total cash disbursements

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

January February March
Beginning cash balance
Total receipts
Subtotal
Less: Total disbursements
Cash excess (deficiency) before financing
Financing:
Borrowing to maintain $75,000 balance
Loan principal repaid
Loan interest paid
Ending cash balance

Homework Answers

Answer #1

Solution:

Schedule that discloses the firm’s total cash collections for January through March

January

February

March

Collection of accounts receivable ($195,000*20%)

39000

Collection of January sales

306000

178500

Collection of February sales

360000

210000

Collection of March sales

369000

Sale of equipment

21000

Total cash collections

345000

538500

600000

Schedule that discloses the firm’s total cash disbursements for January through March

January

February

March

Payment of accounts payable

72000

Payment of January purchases

231000

99000

Payment of February purchases

252000

108000

Payment of March purchases

336000

Cash operating costs

99000

78000

141000

Total cash disbursements

402000

429000

585000

Schedule that summarizes the firm’s financing cash flows for January through March

January

February

March

Beginning cash balance

75000

75000

127120

Total receipts

345000

538500

600000

Subtotal

420000

613500

727120

Less: Total disbursements

402000

429000

585000

Cash excess (deficiency) before financing

18000

184500

142120

Financing:

Borrowing to maintain $75,000 balance

57000

0

0

Loan principal repaid

0

-57000

0

Loan interest paid

0

-380

0

Ending cash balance

75000

127120

142120

Hope the above calculations, working and explanations are clear to you and help you in understanding the concept of question.... please rate my answer...in case any doubt, post a comment and I will try to resolve the doubt ASAP…thank you

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
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, Heidi, Steve and, Roger planned to open up a cosmetic distributor outlet in Paris next...
Mary, Heidi, Steve and, Roger planned to open up a cosmetic distributor outlet in Paris next year. They are in the process of assembling a cash budget for the first quarter of the year 2020. They asked you to help them to prepare a cash budget and provide you with the following information: They will start the business in January 2020, with $90,000 cash as the capital. They will rent a double-story building. They need to pay a rental deposit...
Badlands, Inc. manufactures a household fan that sells for $20 per unit. All sales are on...
Badlands, Inc. manufactures a household fan that sells for $20 per unit. All sales are on account, with 40 percent of sales collected in the month of sale and 60 percent collected in the following month. The data that follow were extracted from the company’s accounting records. Badlands maintains a minimum cash balance of $35,000. Total payments in January 20x1 are budgeted at $210,000. A schedule of cash collections for January and February of 20x1 revealed the following receipts for...
Nieto Company’s budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases...
Nieto Company’s budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases January $254,600 $39,100 February 220,900 46,100 March 326,000 48,500 Nieto’s sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale; 4% are uncollectible. Nieto’s purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month of purchase,...
Schedule of Cash Collections of Accounts Receivable Pet Supplies Inc., a pet wholesale supplier, was organized...
Schedule of Cash Collections of Accounts Receivable Pet Supplies Inc., a pet wholesale supplier, was organized on January 1. Projected sales for each of the first three months of operations are as follows: January $230,000 February 350,000 March 530,000 All sales are on account. 57% of sales are expected to be collected in the month of the sale, 38% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash...
The following data relate to the operations of Soper Company, a wholesale distributor of consumer goods...
The following data relate to the operations of Soper Company, a wholesale distributor of consumer goods as of March 31:   Cash $ 8,000   Accounts receivable 20,000   Inventory 36,000   Building and equipment, net 120,000   Accounts payable 21,750   Common shares 150,000   Retained earnings 12,250 a. The gross margin is 25% of sales. b. Actual and budgeted sales data are as follows:   March (actual) $ 50,000   April $ 60,000   May $ 72,000   June $ 90,000   July $ 48,000 c. Sales are 60% for...
The following data relate to the operations of Soper Company, a wholesale distributor of consumer goods...
The following data relate to the operations of Soper Company, a wholesale distributor of consumer goods as of March 31:   Cash $ 8,000   Accounts receivable 20,000   Inventory 36,000   Building and equipment, net 120,000   Accounts payable 21,750   Common shares 150,000   Retained earnings 12,250 a. The gross margin is 25% of sales. b. Actual and budgeted sales data are as follows:   March (actual) $ 50,000   April $ 60,000   May $ 72,000   June $ 90,000   July $ 48,000 c. Sales are 60% for...
Company has prepared the following schedules and additional​ information: LOADING... ​(Click the icon to view the...
Company has prepared the following schedules and additional​ information: LOADING... ​(Click the icon to view the cash receipts​ schedule.)                 LOADING... ​(Click the icon to view the cash payments​ schedule.) LOADING... ​(Click the icon to view the additional​ information.) Complete a cash budget for GrahamGraham Company for JanuaryJanuary​, FebruaryFebruary and MarchMarch. ​(Complete all answer boxes. Enter a​ "0" for any zero balances. Round all amounts entered into the cash budget to the nearest whole dollar. Enter a cash deficiency with...
Schedule of Cash Collections of Accounts Receivable Pet Supplies Inc., a pet wholesale supplier, was organized...
Schedule of Cash Collections of Accounts Receivable Pet Supplies Inc., a pet wholesale supplier, was organized on January 1. Projected sales for each of the first three months of operations are as follows: January $200,000 February 240,000 March 340,000 All sales are on account. 50% of sales are expected to be collected in the month of the sale, 46% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash...
Pet Supplies Inc., a pet wholesale supplier, was organized on January 1. Projected sales for each...
Pet Supplies Inc., a pet wholesale supplier, was organized on January 1. Projected sales for each of the first three months of operations are as follows: January $240,000 February 310,000 March 470,000 All sales are on account. 59% of sales are expected to be collected in the month of the sale, 37% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash collections from sales for January, February, and...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT