Question

Complete the balance sheet and sales information in the table that follows for J. White Industries...

Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Total assets turnover: 1.8 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 25% Total liabilities-to-assets ratio: 50% Quick ratio: 0.80 Days' sales outstanding (based on 365-day year): 36.5 days Inventory turnover ratio: 3.50 Do not round intermediate calculations. Round your answers to the nearest whole dollar.

Partial Income

Statement
Information

Sales

$  

Cost of goods sold

$  

Balance Sheet

Cash

$  

Accounts payable

$  

Accounts receivable

  

Long-term debt

  50,000

Inventories

  

Common stock

  

Fixed assets

  

Retained earnings

  100,000

Total assets

$  400,000

Total liabilities and equity

$  

Homework Answers

Answer #1

Sales = Total assets * total asset turnover = $400,000 * 1.8 = $720,000

cost of goods sold = Sales - (Sales * gross profit margin)
= $720,000 - ($720,000 * 25%)
= $720,000 - $180,000
= $540,000


Accounts payable = (Total assets * Total liabilities-to-assets ratio) - long term debt
= ($400,000 * 50%) - $50,000
= $200,000 - $50,000
= $150,000

Common stock = $400,000 - ($100,000 + $50,000 + $150,000)
= $400,000- $300,000
= $100,000

Inventory = Cost of goods sold / inventory turnover
= $540,000 / 3.50
= $154,286

Accounts receivable = (Total credit sales / 365) * days sales outstandings
= ($720,000 / 365) * 36.5
= $72,000


Cash = (Current liabilities * quick ratio) - accounts receivable
= ($150,000 * 0.80) - $72,000
= $48,000

Fixed assets = Total assets - (cash + accounts receivable + inventories)
= $400,000 - ($48,000 + $72,000 + $154,286)
= $400,000 - $274,286
= $125,714

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.3x Days sales outstanding: 38 daysa Inventory turnover ratio: 4x Fixed assets turnover: 2.5x Current ratio: 2.3x Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 30% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answer to the nearest cent. Balance Sheet Cash $   Current liabilities $   Accounts receivable    Long-term debt 65,000...
Sandhill Automotive’s balance sheet at the end of its most recent fiscal year shows the following...
Sandhill Automotive’s balance sheet at the end of its most recent fiscal year shows the following information: Sandhill Automotive Balance Sheet as of March 31, 2017 Assets: Liabilities and Equity: Cash and marketable sec. $38,000 Accounts payable and accruals $163,000 Accounts receivable 166,000 Notes payable 28,000 Inventory 227,000 Total current assets $431,000 Total current liabilities $191,000 Long-term debt 166,000 Total liabilities $357,000 Net plant and equipment 710,000 Common stock 310,000 Goodwill and other assets 99,000 Retained earnings 573,000 Total assets...
The balance sheet and income statement for the A. Thiel Mfg. Company are as follows: Balance...
The balance sheet and income statement for the A. Thiel Mfg. Company are as follows: Balance Sheet ($000) Cash $ 500 Accounts receivable 2,000 Inventories 1,000 Current assets $3,500 Net fixed assets 4,500 Total assets $8,000 Accounts payable $1,100 Accrued expenses 600 Short-term notes payable 300 Current liabilities $2,000 Long-term debt 2,000 Owners’ equity 4,000 Total liabilities and owners’ equity $8,000 Income Statement ($000) Sales (all credit) $8,000 Cost of goods sold (3,300) Gross profit $4,700 Operating expenses (includes $500...
The Balance Sheet and the Income Statement for ABC Manufacturing Corporation are as follows: DATA (All...
The Balance Sheet and the Income Statement for ABC Manufacturing Corporation are as follows: DATA (All amounts in SAR unless otherwise indicated, all sales are on credit and no hard keys.) Balance Sheet: ABC Corporation Balance Sheet Other current assets Total current assets Gross fixed assets Accumulated depreciation Net fixed assets Total assets LIABILITIES (DEBT) AND EQUITY Accounts payable Short-term notes payable Total current liabilities Long-term debt Total liabilities Common stock (par & paid in capital) Retained earnings Total common...
​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance...
​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance sheet for​ Karen's Beauty​ Products, Inc.: ​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance sheet for​ Karen's Beauty​ Products, Inc.: Total asset turnover 1.6 times Average collection period​ (assume 365-day​ year) 14 days Fixed asset turnover 6 times Inventory turnover​ (based on cost of goods​ sold) 3 times Current ratio 1.9 times Sales​ (all on​ credit)...
The following table shows income statement and balance sheet data for five U.S. industries in 2017....
The following table shows income statement and balance sheet data for five U.S. industries in 2017. INCOME STATEMENT AND BALANCE SHEET FOR 2017 SELECTED U.S. INDUSTRIES FOR 2017 (Figures in $ billions) Food Pharmaceuticals Oil and Coal Computers and Peripherals Food Stores Income Statement Data: Sales $ 683.9 $ 444.5 $ 819.0 $ 233.0 $ 491.2 Cost of goods sold 613.1 369.4 774.8 223.7 468.0 Balance Sheet Data: Inventory $ 84.8 $ 73.8 $ 61.2 $ 28.3 $ 44.9 Accounts...
The balance sheet for Stud Clothiers is shown next. Sales for the year were $3,700,000, with...
The balance sheet for Stud Clothiers is shown next. Sales for the year were $3,700,000, with 75 percent of sales sold on credit. STUD CLOTHIERS Balance Sheet 20X1 Assets Liabilities and Equity Cash $ 70,000 Accounts payable $ 296,000 Accounts receivable 358,000 Accrued taxes 164,000 Inventory 245,000 Bonds payable (long-term) 139,000 Plant and equipment 423,000 Common stock 100,000 Paid-in capital 150,000 Retained earnings 247,000 Total assets $ 1,096,000 Total liabilities and equity $ 1,096,000 Compute the following ratios: (Use a...
The balance sheet for K company is given below. Sales for the year were $3,070,000, with...
The balance sheet for K company is given below. Sales for the year were $3,070,000, with 75 percent of sales sold on credit. total assets equal their total liabilities at $1110000. Accounts include: Cash $50,000 Inv 365,000 Plant and Eqip 425,000 Accounts rec. 270,000 Acct payable 235,000 Long term - bonds payable 180,000 Common stock 310,000 Accrued taxes 45,000 Retained earnings 340,000 Calculate: Current ratio, Asset turnover, Debt to total assets ratio, Quick ratio, Average collection period
Blackwell Automotive’s balance sheet at the end of its most recent fiscal year shows the following...
Blackwell Automotive’s balance sheet at the end of its most recent fiscal year shows the following information: Flying Roos Corporation Balance Sheet as of December 31, 2014 Assets: Liabilities and Equity: Cash and marketable sec. $23,015 Accounts payable and accruals $163,257 Accounts receivable $141,258 Notes payable $21,115 Inventories $212,444 Total current liabilities $184,372 Total current assets $387,940 Long-term debt $168,022 Total liabilities $352,394 Net plant and equipment $711,256 Common stock $313,299 Goodwill and other assets $78,656 Retained earnings $512,159 Total...
Consider the following company’s balance sheet and income statement. Balance Sheet Assets Liabilities and Equity Cash...
Consider the following company’s balance sheet and income statement. Balance Sheet Assets Liabilities and Equity Cash $ 10,000 Accounts payable $ 31,000 Accounts receivable 72,000 Notes payable 25,000 Inventory 53,000 Total current assets 135,000 Total current liabilities 56,000 Fixed assets 81,000 Long-term debt 30,000 Equity 130,000 Total assets $ 216,000 Total liabilities and equity $ 216,000 Income Statement Sales (all on credit) $ 290,000 Cost of goods sold 180,000 Gross margin 110,000 Selling and administrative expenses 43,000 Depreciation 7,000 EBIT...