Prepare a budgeted balance sheet at March 31 using the following information from Zimmer Company. a. The cash budget for March shows an ending loan balance of $20,000 and an ending cash balance of $75,000. b. The sales budget for March shows sales of $140,000. Accounts receivable at the end of March are budgeted to be 60% of March sales. c. The merchandise purchases budget shows that $91,000 in merchandise will be purchased on credit in March. Purchases on credit are paid 100% in the month following the purchase. d. Ending merchandise inventory for March is budgeted to be 800 units at a cost of $35 each. e. Income taxes payable of $28,000 are budgeted at the end of March. f. Accounting records at the end of March show budgeted equipment of $82,000 with accumulated depreciation of $35,000. g. Common stock of $35,000 and retained earnings of $60,000 are budgeted at the end of March.

Prepare a budgeted balance sheet at March 31 using the following information from Zimmer Company. a. The cash budget for March shows an ending loan balance of $20,000 and an ending cash balance of $75,000. b. The sales budget for March shows sales of $140,000. Accounts receivable at the end of March are budgeted to be 60% of March sales. c. The merchandise purchases budget shows that $91,000 in merchandise will be purchased on credit in March. Purchases on credit are paid 100% in the month following the purchase. d. Ending merchandise inventory for March is budgeted to be 800 units at a cost of $35 each. e. Income taxes payable of $28,000 are budgeted at the end of March. f. Accounting records at the end of March show budgeted equipment of $82,000 with accumulated depreciation of $35,000. g. Common stock of $35,000 and retained earnings of $60,000 are budgeted at the end of March.

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

Kingston budgets total sales for June and July of $430,000 and $338,000, respectively. Cash sales are 65% of total sales. Of the credit sales, 25% are collected in the month of sale, 65% are collected during the first month after the sale, and the remaining 10% are collected in the second month after the sale. Determine the amount of accounts receivable reported on the company’s budgeted balance sheet as of July 31. Hint: Determine the percent of June and July sales that are uncollected at July 31. As of July 31 Sales month Total Sales Credit Sales Percent Uncollected Amount Uncollected June $430,000 July 338,000 Total
Assume the following budgeted information for a merchandising company: Budgeted sales (all on credit) for November, December, and January are $248,000, $218,000, and $209,000, respectively. • Cash collections related to credit sales are expected to be 70% in the month of sale, 30% in the month following the sale. • The cost of goods sold is 70% of sales. • Each month's ending inventory equals 20% of next month's cost of goods sold. • 30% of each month's merchandise purchases are paid in the current month and the remainder is paid in the following month. • Monthly selling and administrative expenses that are paid in cash in the month incurred total $25,000. • Monthly depreciation expense is $9.000. . The budgeted net operating income for December would be: Multiple Choice $40,400 $25,734 $16,734 $31,400
Prepare the following budgets for the months of April, May, and June: 1. Sales budget. 2. Production budget.3. Direct materials budget. The management of Zigby Manufacturing prepared the following balance sheet for March 31. ZIGBY MANUFACTURING Balance Sheet March 31 Assets Liabilities and Equity Cash $ 65,000 Liabilities Accounts receivable 399,000 Accounts payable $ 204,500 Raw materials inventory 90,200 Loan payable 27,000 Finished goods inventory 308,028 Long-term note payable 500,000 $ 731,500 Equipment $ 630,000 Equity Less: Accumulated depreciation 165,000 465,000 Common stock 350,000 Retained earnings 245,728 595,728 Total assets $ 1,327,228 Total liabilities and equity $ 1,327,228 To prepare a master budget for April, May, and June, management gathers the following information. Sales for March total 22,800 units. Budgeted sales in units follow: April, 22,800; May, 16,000; June, 23,000; and July, 22,800.…
Kingston budgets total sales for June and July of $470,000 and $348,000, respectively. Cash sales are 65% of total sales. Of the credit sales, 20% are collected in the month of sale, 60% are collected during the first month after the sale, and the remaining 20% are collected in the second month after the sale. Determine the amount of accounts receivable reported on the company's budgeted balance sheet as of July 31. Hint: Determine the percent of June and July sales that are uncollected at July 31. As of July 31 Sales month Total Sales Credit Sales Percent Uncollected Amount Uncollected June $ 470,000 July 348,000 Total
D. Tomlinson Retail seeks your assistance in developing cash and other budget information for May, June, and July. The store expects to have the following balances at the end of April: $ 5,100 478,000 327,500 146,579 Cash Accounts receivable Inventories Accounts payable The firm follows these guidelines in preparing its budgets: Sales. All sales are on credit with terms of 3/10, n/30. Tomlinson bills customers on the last day of each month. The firm books receivables at gross amounts and collects 60% of the billings within the discount period, 25% by the end of the month, and 9% by the end of the second month. The firm's experience suggests that 6% is likely to be uncollectible and is written off at the end of the third month. Purchases and expenses. All purchases and expenses are on open account. The firm pays its payables over a 2-month period with 54% paid in the month of purchase. Each month's units of ending inventory should equal 125% of the next month's cost of sales. The cost…
Mass Company has $9,500 in cash on hand on January 1 and has collected the following budget data: E (Click the icon to view the budget data) Assume Mass has cash payments for selling and administrative expenses including salaries of $60,000 plus commissions of 1% of sales, all paid in the month of sale. The company requires a minimum cash balance of $9,000 Prepare a cash budget for January and February. Will Mass need to borrow cash by the end of February? Begin by preparing the cash budget for January, then prepare the cash budget for February (Complete all input fields. Enter a "0" for any zero balances.) Mass Company Cash Budget Two Months Ended January 31 and February 28 January Beginning cash balance Cash receipts Data Table Cash available Cash payments: Purchases of merchandise inventory January February Selling and administrative expenses Sales 1.340,000 $ 690,000 Total cash payments Cash receipts from customers 851 420 871,100 Ending cash balance before financing Cash payments…
In May 2022, the budget committee of Crane Stores assembles the following data in preparation of budgeted merchandise purchases for the month of June. 1. 2. 3. 4. (a) Expected sales: June $400,000, July $480,000. Cost of goods sold is expected to be 75% of sales. Desired ending merchandise inventory is 30% of the following (next) month's cost of goods sold. The beginning inventory at June 1 will be the desired amount. Compute the budgeted merchandise purchases for June. CRANE STORES Merchandise Purchases Budget $ $
Ivanhoe Design provided the following budgeted information for April through July: April May June July Projected sales $112320 $132840 $124200 $142560 Projected merchandise purchases $88560 $99360 $84240 $71280 The cash balance on June 1 is $12960. The company pays 40% of merchandise purchases in the month purchased and 60% in the following month. General operating expenses are budgeted to be $33480 per month of which depreciation is $3240 of this amount. Management pays operating expenses in the month incurred. The company makes loan payments of $4320 per month of which $648 is interest and the remainder is principal. How much are budgeted cash disbursements for June? $111024. $127872. $93312. $68256.
Riverbed Inc. provided the following information: April Projected merchandise purchases $92,500 Calculate budgeted cash disbursements for May. May $82,000 Total budgeted cash disbursements $ June Riverbed pays for 40% of merchandise purchases in the month of the purchase and 60% in the following month. General operating expenses are budgeted to be $34,500 per month of which depreciation is $3,400 of this amount. Riverbed pays operating expenses in the month incurred. Riverbed makes loan payments of $5,000 per month of which $550 is interest and the remainder is principal. $69,000
The treasurer of U Co. has accumulated the budget information presented in the table for the months of March and April pertaining to cash payments. Forty percent of the merchandise costs are expected to be paid in the month they are incurred and the remaining sixty percent in the following month. All of the operating expenses are paid for by cash in the month they are incurred. The accounts payable balance on March 1 is $60,000. What is the amount to include in the Cash Budget for the month of April for the Merchandise Costs (which does include the balance from March + Cost for April)? MARCH APRIL Merchandise costs $120,000 $132,000 Operating expenses 100,000 110,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, $43,000. b. Budgeted cash receipts from September sales, $259,000. c. Direct materials are purchased on credit. Purchase amounts are August (actual), $77,000, and September (budgeted), $104,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, $35,000. e. Budgeted depreciation expense for September, $3,200. 1. Budgeted cash payment for dividends In September, $55,000. g. Budgeted cash payment for Income taxes in September, $10,900. h. Budgeted cash payment for loan Interest in September, $1,600. PTO COMPANY Cash Budget Beginning cash balance Add: Cash receipts from sales Total cash available Add: Cash payments for Direct materials Direct labor Dividends Income taxes Interest on loan Total cash…
Assume the following budgeted information for a merchandising company: Budgeted sales (all on credit) for November, December, and January are $248,000, $218,000, and $209,000, respectively. Cash collections of credit sales are expected to be 70% in the month of sale and 30% in the month following the sale. The cost of goods sold is always 70% of sales. Each month’s ending inventory equals 20% of next month’s cost of goods sold. 30% of each month’s merchandise purchases are paid in the current month and the remainder is paid in the following month. Monthly selling and administrative expenses that are paid in cash in the month incurred total $25,000. Monthly depreciation expense is $24,500. The expected cash collections from customers in December are: Multiple Choice $258,900. $215,300. $229,730. $227,000.