On March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget for March, April, and May. All of the company's sales are made on account. The following information has been provided by Spicer's management. Month January February March April May Credit Sales $300,000 (actual) 400,000 (actual) 473,000 (estimated) 671,000 (estimated) 800,000 (estimated) The company's collection activity on credit sales historically has been as follows. Collections in the month of the sale Collections one month after the sale Collections two months after the sale Uncollectible accounts 50% 30 15 5 Spicer's total cash expenditures for March, April, and May have been estimated at $1,200,000 (an average of $400,000 per month). Its cash balance on March 1 of the current year is $500,000. No financing or investing activities are anticipated during the second quarter. Compute Spicer's budgeted cash balance at the ends of March, April, and May. Answer is complete but not entirely correct. Cash balance on March 31 $ 456,500 Cash balance on April 30 $ 533,900 Cash balance on May 31 $ 735,200

On October 1 of the current year, Molloy Corporation prepared a cash budget for October, November, and December. All of Molloy's sales are made on account. The following information was used in preparing estimated cash collections: August sales (actual) September sales (actual) October sales (estimated) November sales (estimated) December sales (estimated) $ 40,000 $ 50,000 $ 20,000 $ 70,000 $ 60,000 Approximately 60% of all sales are collected in the month of the sale, 30% is collected in the following month, and 10% is collected in the month thereafter. Budgeted collections from customers in October total:

Budget balance help!

Use the following information to prepare the September cash budget for PTO Company. Ignore the “Loan activity” section of the budget. Beginning cash balance, September 1, $47,000. Budgeted cash receipts from September sales, $262,000. Direct materials are purchased on credit. Purchase amounts are August (actual), $77,000; and September (budgeted), $103,000. Payments for direct materials follow: 60% in the month of purchase and 40% in the first month after purchase. Budgeted cash payments for direct labor in September, $35,000. Budgeted depreciation expense for September, $3,400. Budgeted cash payment for dividends in September, $57,000. Budgeted cash payment for income taxes in September, $10,900. Budgeted cash payment for loan interest in September, $1,100.

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 is $56,600. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October $ 71,200 $ 440,000 November $ 73,400 December $ 86,200 $ 576,000 $ 639,000 Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18% collected in the second month following sale. The remaining 2% is uncollectible. c. Purchases of inventory will total $315,000 for December. Thirty percent of a month's inventory purchases are paid during the month of purchase. The accounts payable remaining from November's inventory purchases total $181,500, all of which will be paid in December. d. Selling and administrative expenses are budgeted at $522,000…

Use the following information to prepare the September cash budget for PTO Company. Ignore the "Loan activity" section of the budget. a. Beginning cash balance, September 1, $44,000. b. Budgeted cash receipts from September sales, $261,000. c. Direct materials are purchased on credit. Purchase amounts are August (actual), $78,000; and September (budgeted), $106,000. Payments for direct materials follow: 65% in the month of purchase and 35% in the first month after purchase. d. Budgeted cash payments for direct labor in September, $34,000. e. Budgeted depreciation expense for September, $3,300. f. Budgeted cash payment for dividends in September, $54,000. g. Budgeted cash payment for income taxes in September, $10,200. h. Budgeted cash payment for loan interest in September, $1,200. PTO COMPANY Cash Budget September Beginning cash balance Total cash available 0 Total cash payments 0 Ending cash balance $ 0

2 Arrangon Ltd. is a company that manufactures and sells a single product called Zoltar. For planning and control purposes they utilize a monthly master budget, which is developed in advance of the budget year. Their fiscal year end is September 30. A listing of the estimated ledger balances for the company's current year of September 30, 2024 is given below: Cash Accounts receivable Inventory-raw materials Inventory-finished goods Capital assets (net) $370,058 674,730 420,090 453,122 2,632,000 $4,550,000 The sales forecast consisted of these few lines: Accounts payable $719,488 Income tax payable 42,000 Capital stock Retained earnings 2.000.000 1,788,512 $4,550,000 • For the year ended September 30, 2024: 450,000 units at $42.00 each* For the year ended September 30, 2025: 475,000 units at $43.00 each . For the year ended September 30, 2026: 500,000 units at $44.00 each *Sales for the year ended September 30, 2024 are based on actual sales to date and budgeted sales for the duration…

Papst Company is preparing its cash budget for the month of May. The following information is available concerning its accounts receivable (based on sales made to customers on open account): Actual credit sales for March Actual credit sales for April Estimated credit sales for May Estimated collections in the month of sale Estimated collections in the first month after the month of sale Estimated collections in the second month after the month of sale Estimated provision for bad debts (made in the month of sale) $225,000 $ 293,000 $ 438,000 25% 60% 10% 5% The firm writes off all uncollectible accounts at the end of the second month after the month of sale. Required: Determine for Papst Company for the month of May: 1. The estimated cash receipts from accounts receivable collections. 2. The gross amount of accounts receivable at the end of the month (after appropriate write-off of uncollectible accounts). 3. The net amount of accounts receivable at the end of the month. 4. Recalculate…

[The following information applies to the questions displayed below.]   Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below:   Beech Corporation Balance Sheet June 30 Assets   Cash $ 76,000 Accounts receivable 137,000 Inventory 86,100 Plant and equipment, net of depreciation 230,000 Total assets $ 529,100 Liabilities and Stockholders’ Equity   Accounts payable $91,000 Common stock 312,000 Retained earnings 126,100 Total liabilities and stockholders’ equity $ 529,100   Beech’s managers have made the following additional assumptions and estimates:   Estimated sales for July, August, September, and October will be $410,000, $430,000, $420,000, and $440,000, respectively. All sales are on credit and all credit sales are collected. Each month’s credit sales are collected 35% in the month of sale and 65% in the month…

Sonoma Housewares Inc. Cash Budget For the Three Months Ending July 31 May June July Estimated cash receipts from: Cash sales $ $ Collection of accounts receivable Total cash receipts $ Estimated cash payments for: Manufacturing costs Selling and administrative expenses Capital expenditures Other purposes: Income tax Dividends Total cash payments Cash increase or (decrease) $ bala at beginning Cash balance at end of month Minimum cash balance Excess (deficiency) $