Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started