
The following data relate to the operations of Shilow Company, a wholesale distributor of con-sumer goods:
Current assets as of March 31:
Cash .............................. $8,000
Inventory........................... $36,000
Buildings and equipment, net...........$120,000
Accounts payable ..................... $21,750
Capital stock..........................$150,000
- The gross margin is 25% of sales. b. Actual and budgeted sales data:
March (actual) ...................$50,000
April . . . . . . . . . . . . . . . .$60,000
May ..................................$72,000
June..................................$90,000
July ..................................$48,000
- Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are a result of March credit sales.
- Each month’s ending inventory should equal 80% of the following month’s budgeted cost of goods sold.
- One-half of a month’s inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. The accounts payable at March 31 are the result of March purchases of inventory.
- Monthly expenses are as follows: commissions, 12% of sales; rent, $2,500 per month; other expenses (excluding
depreciation ), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $900 per month (includes depreciation on new assets). - Equipment costing $1,500 will be purchased for cash in April.
- Management would like to maintain a minimum cash balance of at least $4,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $20,000. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter.
- Complete the following schedule:
Schedule of Expected Cash Collections
April May June Quarter
Cash sales ............$36,000 ------- -------- ---------
Credit sales............ 20,000 -------- -------- ---------
Total collections........$56,000 -------- -------- ---------
- Complete the following:
Merchandise Purchases Budget
April May June Quarter
Budgeted cost of goods sold ...........$45,000* $54,000
Add desired ending inventory.......... 43,200† ------ ------ -------
Total needs............................................. 88,200 ------ -------- --------
Less beginning inventory................... 36,000 ------- ------- --------
Required purchases ............................$52,200 ------- -------- -------
*For April sales: $60,000 sales × 75% cost ratio = $45,000.†$54,000 × 80% = $43,200
Schedule of Expected Cash Disbursements—Merchandise Purchases
April May June Quarter
March purchases...................... $21,750 -------- -------- $21,750
April purchases....................... 26,100 $26,100 -------- 52,200
May purchases........................ ------- ------- -------- -------
June purchases....................... ------ ------- -------- ------
Total disbursements ...............$47,850 -------- ------- -------
3,Complete the following
Cash Budget
April May June Quarter
Beginning cash balance................$8,000 ------- ------- --------
Add cash collections...................56,000 ------- -------- --------
Total cash available ...................64,000 -------- -------- --------
Less cash disbursements:
For inventory....................... 47,850 ------- ------ ------
For expenses....................... 13,300 -------- ----- ------
For equipment ...................... 1,500 -------- ------- -------
Total cash disbursements...............62,650 ------ ------ -------
Excess (deficiency) of cash.............. 1,350 --------- --------- --------
FinancingEtc.
- Prepare an absorption costing income statement, similar to the one shown in Schedule 9 in the chapter, for the quarter ended June 30.
- Prepare a
balance sheet as of June 30.

Trending nowThis is a popular solution!
Step by stepSolved in 3 steps

- Selected current year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31 of the prior year were inventory, $46,900; total assets, $179,400; common stock, $88,000; and retained earnings, $31,286.) Assets Cash Short-term investments Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets CABOT CORPORATION Income Statement Cost of goods sold Gross profit For Current Year Ended December 31 Sales Operating expenses Interest expense Income before taxes Income tax expense Net income $ 18,000 9,000 33,800 Req 1 and 2 Reg 3 Req 4 Compute the debt-to-equity ratio. Numerator: $ 455,600 298,150 157,450 98,500 4,000 54,950 22,136 $ 32,814 30,150 3,050 154,300 Retained earnings $ 248,300 Total liabilities and equity 1 CABOT CORPORATION Balance Sheet December 31 of current year Liabilities and Equity Accounts payable Accrued wages payable Income taxes payable Complete this question by…arrow_forwardA company reports the following: Sales $572,320Average accounts receivable (net) 20,440arrow_forwardUse the following information for Jones Inc. FY 2018 Revenue ...............................................$1,000,000 Cost of Goods Sold ................................. 500,000 Total Operating Expenses .......................300,000 Tax ...............................................................70,000 Net Income ..............................................130,000 The net profit margin ratio for Jones Corporation for 2018 is: (A) 10% (B) 13% (C) 7% (D) 50% The operating profit margin ratio for Jones Corporation for 2018 is: (A) 50% (B) 14% (C) 20% (D) 7%arrow_forward
- Excerpts from Sydner Corporation's most recent balance sheet appear below: Current assets: Cash Accounts receivable, net Inventory Prepaid expenses Total current assets Total current liabilities Year 2 Year 1 $ 140 $ 160 210 230 240 200 10 10 $ 600 $ 600 $360 $ 330 Sales on account in Year 2 amounted to $1,390 and the cost of goods sold was $900. The accounts receivable turnover for Year 2 is closest to:arrow_forwardEMM, Inc. has the following balance sheet: EMM, Incorporated Balance Sheet as of 12/31/X0 Assets Liabilities and Equity Cash $ 1,200 Accounts payable $ 4,900 Accounts receivable 8,900 Bank note payable 7,700 Inventory 6,100 Long-term assets 4,400 Equity 8,000 $ 20,600 $ 20,600 It has estimated the following relationships between sales and the various assets and liabilities that vary with the level of sales: Accounts receivable = $3,560 + 0.35 Sales, Inventory = $2,356 + 0.28 Sales, Accounts payable = $1,449 + 0.20 Sales. If the firm expects sales of $27,000, what are the forecasted levels of the balance sheet items above? Round your answers to the nearest dollar. Accounts receivable: $ Inventory: $ Accounts payable: $ Will the expansion in accounts payable cover the expansion in inventory and accounts receivable? Round your answers to the nearest dollar. The expansion in accounts payable of $ the total…arrow_forwardPrecious Products Ltd.Income StatementFor the year ended xxxxSales.................................................................... $______Cost of goods sold:Finished goods inventory, beginning.................... $ ______Add: Cost of goods manufactured ....................... ______Goods available for sale...................................... ______Deduct: Finished goods inventory, ending............ ______ ______Gross margin........................................................ ______Selling and administrative expenses:Selling expenses................................................. ______Administrative expenses ..................................... ______ ______Operating income ................................................. $ , .3. Direct labour: $______÷ 10,000 units = $______per unit.Insurance: $______÷ 10,000 units = $______per unit.4. Direct materials:Unit cost: $: $______÷ 10,000 units = $______per unit.Total cost: ______units × $______ per unit =…arrow_forward
- Vishnuarrow_forwardForten Company's current year income statement, comparative balance sheets, and additional information follow. For the year, (1) all sales are credit sales, (2) all credits to Accounts Receivable reflect cash receipts from customers, (3) all purchases of inventory are on credit, and (4) all debits to Accounts Payable reflect cash payments for inventory. FORTEN COMPANY Income Statement For Current Year Ended December 31 Sales $ 582,500 Cost of goods sold 285,000 Gross profit 297,500 Operating expenses (excluding depreciation) $ 132,400 Depreciation expense 20,750 153,150 Other gains (losses) Loss on sale of equipment (5,125) Income before taxes 139,225 Income taxes expense 24,250 Net income $ 114,975 FORTEN COMPANY Comparative Balance Sheets December 31 Current Year Prior Year Assets Cash $ 49,800 $ 73,500 Accounts receivable 65,810 50,625 Inventory 275,656 251,800 Prepaid expenses 1,250 1,875 Total current assets 392,516 377,800 Equipment 157,500 108,000 Accumulated…arrow_forwardUse the following Company A Balance Sheet for the next questions 8 and 9 ASSETS Cash Accounts Receivable, net Inventory Other Current Assets Property, Plant and Equipment, net Other Total Assets 1. 1. 2. 3. The Common Size entry for Inventory for Company A is: 54% 33% 18% S 16% $ LIABILITIES AND EQUITY Accounts Payable Accrued Expenses Current portion of LTD Other 1,400,000 1,600,000 1,800,000 500,000 5,300,000 20%Current Liabilities 3,700,000 Long Term Debt 1,000,000 Shareholder's Equity 10,000,000 100% Total Liabilities and Equity 1,200,000 1,500,000 300,000 400,000 3,400,000 2,800,000 3,800,000 $ 10,000,000arrow_forward
- The following selected account balances appeared on the financial statements of Washington Company: Accounts Receivable, January 1 Accounts Receivable, December 31 Accounts Payable, January 1 Accounts Payable, December 31 $14,013 6,449 5,841 7,294 10,420 15,188 Sales 62,580 Cost of Merchandise Sold 36,279 Washington Company uses the direct method to calculate net cash flow from operating activities. Cash payments for merchandise were Merchandise Inventory, January 1 Merchandise Inventory, December 31 a. $42,500 Ob. $30,058 c. $39,594 Od. $65,895 Check My Work 1 more Check My Work uses remaining. Previousarrow_forwardThe following information relates to SE10-5 through SE10-7: (in millions) Net sales... Cost of goods sold SE10-7. Gross profit. Selling and administrative expenses Income from operations Interest expense.. EVANS & SONS, INC. Income Statement For Years Ended December 31, 2019 and 2018 Income before income taxes Income tax expense. Net income (in millions) Assets Current assets Cash and cash equivalents Accounts receivable Inventory.. Other current assets. Total current assets Property, plant, & equipment (net) Other assets. Total Assets Liabilities and Stockholders' Equity Current liabilities. Long-term liabilities. Total liabilities.. EVANS & SONS, INC. Balance Sheet December 31, 2019 and 2018 Stockholders' equity - common. Total Liabilities and Stockholders' Equity.. 2019 9,800 (5,500) 4,300 (2,800) 1,500 (300) $ 1,200 2019 100 900 500 400 2018 1,900 2,600 5,700 $10,200 9,300 (5,200) 4,100 (2,700) (220) (200) $980 $950 1,400 $ (250) 1,150 2018 300 800 650 250 2,000 2,500 5,900 $10,400…arrow_forwardJune 1, Cline Co. paid $800,000 cash for all of the issued and outstanding common stock of Renn Corp. The carrying values for Renn’s assets and liabilities on June 1 follow: Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $150,000 Accounts receivable . . . . . . . . . . . . . . . . . . . 180,000 Capitalized software costs. . . . . . . . . . . . . . . 320,000 Goodwill . . . . . . . . . . . . . . . . . . . . . . . . . . . 100,000 Liabilities . . . . . . . . . . . . . . . . . . . . . . . . . . . (130,000) Net assets . . . . . . . . . . . . . . . . . . . . . . . . . … $620,000 On June 1, Renn’s accounts receivable had a fair value of $140,000. Additionally, Renn’s in process research and development was estimated to have a fair value of $200,000. All other items were stated at their fair values. On Cline’s June 1 consolidated balance sheet, how much is reported for goodwill? A. $320,000. B. $20,000. C. $80,000. D $120,000. E.Non of the Abovearrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education





