Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Complete the balance sheet and sales information in the table that follows for Isberg Industries using the following financial data: Debt ratio: 50% Quick ratio:

Complete the balance sheet and sales information in the table that follows for Isberg Industries using the following financial data:

Debt ratio: 50%

Quick ratio: 0.80x

Total assets turnover: 1.5x

Days sales outstanding: 36.0 days

Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 25%

Inventory turnover ratio: 5.0x

Balance Sheet:

1.CashAccounts payable

2.Accounts receivableLong-term debt$ 60,000

3.InventoriesCommon stock

4.Fixed assetsRetained earnings$ 97,500

5.Total assets$300,000Total liabilities and equity

6.SalesCost of goods sold

Campsey Computer Company: Balance Sheet as of December 31

Cash$ 77,500Accounts payable$129,000

Receivables336,000Notes payable84,000

Inventories241,500Other current liabilities117,000

Total current assets$655,000Total current liabilities$330,000

Net fixed assets292,500Long-term debt256,500

Common equity361,000

Total assets$947,500Total liabilities and equity $947,500

Campsey Computer Company: Income Statement for Year Ended December 31

Sales$1,607,500

Cost of goods sold(1,353,000)

Gross profit$254,500

Fixed operating expenses except depreciation(143,000)

Earnings before interest, taxes, depreciation,

and amortization (EBITDA)$111,500

Depreciation(41,500)Earnings before interest and taxes (EBIT)$70,000

Interest(24,500)Earnings before taxes (EBT)$45,500

Taxes (40%)(18,200)

Net income$27,300

Using the information above, calculate the following ratios:

7.Current ratio

8.Days sales outstanding

9.Inventory turnover

10.Total assets turnover

11.Net profit margin

12.Return on assets (ROA)

13.Return on equity (ROE)

14.Debt ratio

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elements Of Chemical Reaction Engineering

Authors: H. Fogler

6th Edition

013548622X, 978-0135486221

Students also viewed these Finance questions