Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is In the process of assembling a cash budget for the first quarter of

$20$x$1.$ 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 anticlpated, and management believes that only $20$ percent of

Seventy percent of the merchandlse purchases are pald for In the month of purchase; the remaining $30$ percent are pald for In the

month after acquisition.

The December $31,20$x$0,$ balance sheet disclosed the following selected figures: cash, $$100,000$; accounts recelvable, $$215,000$;

and accounts payable, $$76,000.$

Mary and Kay, Inc., malntains a $$100,000$ min$$mum cash balance at all times. Financing is avallable $($and retired$)$ In $$1,000$ multiples

at an $9$ percent Interest rate, with borrowings taking place at the beginning of the month and repayments occurring at the end of the

month. Interest is pald at the time of repaying princlpal and computed on the portion of principal repald at that time.

Additional data:

Required:

Prepare a schedule that discloses the firm's total cash collectlons 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.

Complete this question by entering your answers in the tabs below.

Required $1$

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