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

McFarland Company makes 70 percent of its sales in cash. Credit sales are collected as follows: 70 percent in the month of sale and 30 percent in the month following the sale. McFarland's budgeted sales for upcoming months follow: $ 24,200 42,000 40,000 38,000 June July August September Required: Compute McFarland's expected cash receipts for August Budgeted Cash Receipts
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…
The following information is provided to assist in the preparation of the Cash Budget for Ding Ltd. for May 2020. The cash balance at 1 May 2020 is $30,000. Budgeted Sales ($) Budgeted Purchases ($) April 170,000 64,000 May 140,000 68,000 All sales are on cash basis and will be collected in the same month the sale is made. All purchases are made on credit and payments are made as follows: 60% of purchases are paid for in the month of purchase. 40% of purchases are paid for in the month following the purchase. The business plans to take out a small business loan of $50,000 at the end of May 2020 and will be repaying it back in July 2020. Selling and administrative expenses each month are $45,000. The selling and administrative expenses include monthly depreciation expense of $6,000. Sales commission is 15% of the total monthly sales, and paid to the staff at the end of every month. Equipment costing $35,000 is expected to be bought in May and paid in…
Evergreen Furniture, a retailing company, is preparing the cash budget for August. The following inventory information is available: Estimated payments in August for purchases in August Estimated purchases for August Estimated cost of goods sold for August Estimated payments in August for purchases in July Estimated payments in August for purchases prior to July Inventories at beginning of August Required: What are the estimated cash disbursements in August? Estimated cash disbursements 70% $ 2,428,000 2,560,000 672,000 160,000 658,000
Kingston budgets total sales for June and July of $330,000 and $408,000, respectively. Cash sales are 65% of total sales. Of the credit sales, 15% are collected in the month of sale, 65% 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. Sales month Total Sales June July Total S 330,000 408,000 Credit Sales As of July 31 Percent Uncollected Amount Uncollected
Floss Company has $13,000 in cash on hand on January 1 and has collected the following budget data: Assume Floss has cash payments for selling and administrative expenses including salaries of $66,000 plus commissions of 2% of sales, all paid in the month of sale. The company requires a minimum cash balance of $11,000. Prepare a cash budget for January and February. Will Floss need to borrow cash by the end of February? Beginning bye preparing the cash budget for January, then the cash budget for February. (Complete all input fields. Enter a “0” for any zero balances. )
Mitchell Company had the following budgeted sales for the first half of next year: The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: Assume that the accounts recelvable balance on January 1 was $76,000. Of this amount, $60,000 represented uncollected December sales and $16,000 represented uncollected November sales. Glven these data, the total cash collected during January would be: Multiple Choice $138.000 $100,000 $196,000 $197,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
Jasper Company has sales on account and for cash. Specifically, 61% of its sales are on account and 39% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $526,000 for April, $536,000 for May, and $561,000 for June. The beginning balance of Accounts Receivable is $299,400 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June. April May June Cash sales 39% Sales on account 61% Total sales $ O $ JASPER COMPANY Schedule of Cash Receipts For April, May, and June April May June Cash receipts from: Cash sales Collection of accounts receivable Total budgeted cash receipts
Assume the following budgeted information for a merchandising company: Budgeted sales (all on credit) for November, December, and January are $241,000, $211,000, and $202,000, respectively. Cash collections of credit sales are expected to be 75% in the month of sale and 25% in the month following the sale. The cost of goods sold is always 65% of sales. Each month’s ending inventory equals 20% of next month’s cost of goods sold. 40% 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 $21,500. Monthly depreciation expense is $21,000. The expected cash collections from customers in December are:
The Panda Company has budgeted its activity for October according to the following information: Sales are budgeted at $392,000 and all sales are for cash. All purchases of merchandise inventory are for cash. Merchandise inventory was $150,000 on September 30 and the planned merchandise inventory on October 31 is $140,000. All merchandise is sold at 40% above cost. The selling and administrative expenses are budgeted at $92,000 for the month. All of these expenses are paid for in cash except for depreciation of $12,000. What is the budgeted net income for October?
The budgeted sales of Kelley, SA for the given months are as follows: Cash Sales Credit Sales April $38,000 $256,000 May $54,000 $250,000 June $36,000 $192,000 July $33,000 $190,000 August $35,000 $287,000 To prepare a cash budget, the company needs to determine the expected cash collections each month, and has provided the following additional information: The Accounts Receivable balance on April 1 was $82,015. Of this amount, $57,015 represented uncollected March sales and $25,000 represented uncollected February sales. Collections on Credit sales: 65% in month of sale 30% in month following sale 5% in second month following sale Part 1: What should the April cash collected be? $BLANK Part 2: For August 1, what is budgeted Accounts Receivable? (76,100, 100,300, 109,950, 144950, OR 79,700)