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 Credit Sales January $ 300,000 (actual) February 400,000 (actual) March 629,000 (estimated) April 571,000 (estimated) May 800,000 (estimated) The company's collection activity on credit sales historically has been as follows. Collections in the month of the sale 50 % Collections one month after the sale 30 Collections two months after the sale 15 Uncollectible accounts 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.

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 Credit Sales January $ 300,000 (actual) February 400,000 (actual) March 629,000 (estimated) April 571,000 (estimated) May 800,000 (estimated) The company's collection activity on credit sales historically has been as follows. Collections in the month of the sale 50 % Collections one month after the sale 30 Collections two months after the sale 15 Uncollectible accounts 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.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

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.
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total cash receipts $ 320,000 $ 440,000 $ 370,000 $ 390,000 Total cash disbursements $ 372,000 $ 342,000 $ 332,000 $ 352,000 The company’s beginning cash balance for the upcoming fiscal year will be $27,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Prepare the company’s cash budget for the upcoming fiscal year.
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…
The controller of Optimum wishes to improve the company's control system by preparing a monthly cash budget. The following information relates to the month ending July 31, 2021: June 30, 2021, cash balance Dividends were declared on June 15* $130,000 44, 000 83,600 13,000 198,000 122,400 47,000 70, 000 Cash expenditures to be paid in July for operating expenses Depreciation expense Cash collections to be received Merchandise purchases to be paid in cash Equipment to be purchased for cash Optimum wishes to maintain a minimum cash balance of *Dividends are payable to shareholders of record on declaration date, 30 days after declaration. Required: 1. Prepare a cash budget for the month ending July 31, 2021, indicating how much, if anything, Optimum will need to borrow to meet its minimum cash requirement. (Leave no cells blank - enter "O" wherever required).
The Overland Company is preparing its cash budget for the month of June. The following information is available concerning its accounts receivable: $304,000 229,000 Estimated credit sales for June Actual credit sales for May Estimated collections in June for credit sales in June Estimated collections in June for credit sales in May Estimated collections in June for credit sales prior to May 25% 65% $ 22,000 16,000 14,000 Estimated write-offs in June for uncollectible credit sales Estimated provision for bad debts in June for credit sales in June What are the estimated cash receipts from accounts receivable collections in June?
Valley Trails is preparing the Cash Budget for the upcoming period, and is concerned about their ability to meet their financial obligations in the short term. Following is information relating to Valley's financial performance: Beginning-of-period balances: Accounts Receivable: $108,000 Accounts Payable: $54,000 Accumulated Factory Depreciation: $576,000 Cash: $27,000 Estimates for end-of-period balances: Accounts Receivable: $135,000 Accounts Payable: $36,000 Accumulated Factory Depreciation: $592,000 Budgeted activity levels for the period: Sales: $500,000 Purchases of Direct Materials: $89,600 Direct Labor Wages: $150,000 Manufacturing Overhead: $50,000 Selling and Administrative Expenses: $84,000 Except for purchases of direct materials, all expenses are paid as incurred. What is the budgeted ending cash balance for the period? Select one: O O O a. $178,400 b. $140,400 $152 400
The following data are from the budget of Ritewell Publishers. Half the company's sales are transacted on a cash basis. The other half are paid for with a 1-month delay. The company pays all of its credit purchases with a 1-month delay. Credit purchases in January were $140, and total sales in January were $290. TT February March $ 420 April Total sales $ 440 $ 400 125 135 115 Cash purchases Credit purchases Labor and administrative purchases Taxes, interest, and dividends Capital expenditures 95 85 95 85 85 85 65 65 65 210 Complete the following cash budget. (Leave no cells blank. Enter '0' when necessary. Negative amounts should be indicated by a minus sign.) February March Aprit Sources of cash Collections on current sales Collections on amounts receivable Total sources of cash 0 $ Uses of cash Payments of accounts payable Cash purchases o search
Peach Corporation's only cash receipts are those derived from customer sales. Peach makes both cash sales and sales on account. For its credit sales, Peach collects 50% in the month of the sale, 40% in the month following the sale, and 10% in the second month following the sale. Peach is preparing its cash budget for the upcoming year. Sales on account for the month of March are budgeted at $150,000. The budgeted accounts receivable balance on March 1 is $113,000, of which $90,000 represents uncollected sales made in February and $23,000 represents uncollected sales made in January. If Peach's total cash receipts for the month of March are budgeted at $205,000, what are Peach's budgeted cash sales during March? O $17,000 O $35,000 $53,000 $71,000 O None of the above