Question

In: Finance

Bavarian Sausage, Inc. posted the following balance sheet and income statement: Balance Sheet Cash $  50,000 Accounts...

Bavarian Sausage, Inc. posted the following balance sheet and income statement:

Balance Sheet

Cash

$  50,000

Accounts Payable

$185,000

Accounts Receivable

125,000

Notes Payable

125,000

Inventories

225,000

Long-term debt

115,000

Net Plant and

Equipment

  525,000

Common Stock

350,000

Retained earnings

  150,000

Total Assets

$925,000

Total liabilities and

Stockholders’ Equity

$925,000

Income Statement

Sales

$525,000

Cost of goods sold

215,000

Depreciation

    65,000

Earnings before

interest and taxes

245,000

Interest expense

35,000

Net profit before

taxes

210,000

Taxes (@ 40%)

    84,000

Net income

$126,000

What is Bavarian Sausage, Inc.’s quick ratio?  (Show your work. Four decimal places required. Highlight or bold your answer.)
What is Bavarian Sausage, Inc.’s net profit margin?  (Show your work. Label %. No decimal places required. Highlight or bold your answer.)
What is Bavarian Sausage, Inc.’s debt-equity ratio?  (Show your work. Two decimal places required. Highlight or bold your answer.)
Calculate Bavarian Sausage, Inc.’s return on assets.  (Show your work. Label %. Two decimal places required. Highlight or bold your answer.)
Calculate Bavarian Sausage, Inc.’s inventory turnover.  (Show your work. Two decimal places required. Highlight or bold your answer.)
Calculate Bavarian Sausage, Inc.’s return on equity.  (Show your work. Label %. Two decimal places required. Highlight or bold your answer.)

Solutions

Expert Solution

(a) Quick ratio = Current assets – Inventories – Prepaid expenses / Current liabilities

Current assets = Cash + Accounts receivable + Inventories

Current assets = $50000 + $125000 + $225000 = $400000

Current liabilities = Accounts payable = $185000

Inventories = $225000

Putting the values in the quick ratio formula, we get,

Quick ratio = ($400000 - $225000) / $185000

Quick ratio = $175000 / $185000 = 0.9459

Quick ratio = 0.9459

(b) Net Profit margin = Net income / Sales * 100

Net income = $126000, Sales = $525000

Net Profit margin = $126000 / $525000 * 100 = 24%

Net Profit margin = 24%

(c) Debt equity ratio = Total liabilities / Shareholder's equity

Total liabilities = Accounts payable + Notes payable + Long term debt

Total liabilities = $185000 + $125000 + $115000 = $425000

Shareholder's equity = Common stock + Retained earnings

Shareholder's equity = $350000 + $150000 = $500000

Putting these values in the debt equity ratio formula above, we get

Debt equity ratio = $425000 / $500000 = 0.85

Debt equity ratio = 0.85

(d) Return on assets (ROA) = Net income / Total assets * 100

Net income = $126000, Total assets = $925000

Now, putting these values in the above ROA formula, we get,

Return on assets (ROA) = $126000 / $925000 * 100 = 13.62%

Return on assets = 13.62%

(e) Inventory turnover ratio = Cost of the goods sold / Inventory

Cost of the goods sold = $215000, Inventory = $225000

Putting these values in the inventory turnover ratio formula, we get,

Inventory turnover ratio = $215000 / $225000 = 0.96

Inventory turnover ratio = 0.96

(f) Return on equity (ROE) = Net income / Stockholder's equity * 100

Net income = $126000,

Stockholder's equity = Common stock + Retained earnings = $350000 + $150000 = $500000

Now, putting these values in the above ROE formula, we get,

Return on equity (ROE) = $126000 / $500000 * 100 = 25.2%

Return on equity = 25.2%


Related Solutions

Muscarella Inc. has the following balance sheet and income statement data: Cash $ 14,000 Accounts payable...
Muscarella Inc. has the following balance sheet and income statement data: Cash $ 14,000 Accounts payable $ 42,000 Receivables 70,000 Other current liabilities 28,000 Inventories 210,000 Total CL $ 70,000 Total CA $294,000 Long-term debt 70,000 Net fixed assets 126,000 Common equity 280,000 Total assets $420,000 Total liab. and equity $420,000 Sales $280,000 Net income $ 21,000 The new CFO thinks that inventories are excessive and could be lowered sufficiently to cause the current ratio to equal the industry average,...
Jordan Inc has the following balance sheet and income statement data: Cash $14,000 Accounts payable $42,000...
Jordan Inc has the following balance sheet and income statement data: Cash $14,000 Accounts payable $42,000 Receivables 70,000 Other current liabilities 28,000 Inventories 280,000 Total CL $70,000 Total CA $364,000 Long-term debt 140,000 Net fixed assets 126,000 Common equity 280,000 Total assets $490,000 Total liab. and equity $490,000 Sales $280,000 Net income 21,000 The new CFO thinks that inventories are excessive and could be lowered sufficiently to cause the current ratio to equal the industry average, 2.25, without affecting either...
The balance sheet and income statement shown below are for Byrd Inc. BALANCE SHEET Cash $...
The balance sheet and income statement shown below are for Byrd Inc. BALANCE SHEET Cash $ 140.0 Accounts payable $800.0 Accts. Receivable 880.0 Notes payable ` 600.0 Inventories 1,320.0 Accruals 400.0 Total current assets 2,340.0 Total current liabilities 1,800.0 Long-term bonds 1,000.0 Total debt 2,800.0 Common stock 200.0 (50,000 shares) Retained earnings 1,000.0 Net plant & equip 1,660.0 Total common equity 1,200.0 Total assets $4,000.0 Total liabilities & equity $4,000.0 INCOME STATEMENT Net sales $6,000.0 Operating costs 5,599.8 Depreciation 100.2...
A scrambled list of accounts from the income statement and balance sheet of​ Belmond, Inc. is...
A scrambled list of accounts from the income statement and balance sheet of​ Belmond, Inc. is found​ here:   a.  How much is the​ firm's net working​ capital? b.  Complete an income statement and a balance sheet for Belmond. c. If you were asked to respond to parts ​(a​) and (b​) as part of a training​ exercise, what could you tell your boss about the​ company's financial condition based on your​ answers? SHEET Inventory 6,510 Common stock 45,100 Cash 16,590 Operating...
A scrambled list of accounts from the income statement and balance sheet of? Belmond, Inc. is...
A scrambled list of accounts from the income statement and balance sheet of? Belmond, Inc. is found? here: Inventory   $6,450 Common stock   45,010 Cash   16,550 Operating expenses   1,390 Short-term notes payable   560 Interest expense   920 Depreciation expense    530 Sales   12,750 Accounts receivable   9,560 Accounts payable   4,840 Long-term debt   55,160 Cost of goods sold   5,720 Buildings and equipment   122,050 Accumulated depreciation   34,400 Taxes   1,440 General and administrative expense   810 Retained earnings   ? ?? a.??How much is the? firm's net working?...
A scrambled list of accounts from the income statement and balance sheet of​ Belmond, Inc. is...
A scrambled list of accounts from the income statement and balance sheet of​ Belmond, Inc. is found​ here:   Inventory 6,490 Common stock 45,000 Cash 16,550 Operating expenses 1,400 ​Short-term notes payable 570 Interest expense 850 Depreciation expense 470 Sales 12,710 Accounts receivable 9,630 Accounts payable 4,770 ​Long-term debt 54,610 Cost of goods sold 5,780 Buildings and equipment 121,650 Accumulated depreciation 33,790 Taxes 1,440 General and administrative expense 850 Retained earnings ​?  a.  How much is the​ firm's net working​ capital?...
A scrambled list of accounts from the income statement and balance sheet of​ Belmond, Inc. is...
A scrambled list of accounts from the income statement and balance sheet of​ Belmond, Inc. is found​ here:  . Inventory 6,460 Common stock 44,950 Cash 16,580 Operating expenses 1,350 ​Short-term notes payable 630 Interest expense 850 Depreciation expense 450 Sales 12,710 Accounts receivable 9,560 Accounts payable 4,760 ​Long-term debt 55,420 Cost of goods sold 5,740 Buildings and equipment 122,330 Accumulated depreciation 33,580 Taxes 1,490 General and administrative expense 880 Retained earnings ​?   a.  How much is the​ firm's net working​...
Cash Budget, Income Statement and Balance Sheet
The following information is available in the question attached:
Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows Assume the following are the...
Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows Assume the following are the financial statements of Nike, Inc. Consolidated Statements of Income Year ended May 31 In Millions 2011 2010 Revenues $ 21,862 $ 20,014 Cost of sales 11,354 10,214 Gross profit 10,508 9,800 Demand creation expense 3,248 2,356 Operating overhead expense 4,345 3,970 Total selling and administrative expense 7,593 6,326 Interest expense (income), net 4 6 Other (income) (33) (49) Income before income taxes 2,944 3,517...
Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows Assume the following are the...
Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows Assume the following are the financial statements of Nike, Inc. Consolidated Statements of Income Year ended May 31 In Millions 2011 2010 Revenues $ 21,862 $ 19,014 Cost of sales 11,354 10,214 Gross profit 10,508 8,800 Demand creation expense 2,948 2,356 Operating overhead expense 4,845 3,970 Total selling and administrative expense 7,793 6,326 Interest expense (income), net 4 6 Other (income) (33) (49) Income before income taxes 2,744 2,517...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT