Income Statement | |
Revenue | |
Total revenue | $470,100 |
Cost of Revenue | $149,700 |
Gross Profit | $320,100 |
Operating Exp | |
Selling General & Admin | $57,800 |
other | $17,400 |
Total Operating Exp | $269,900 |
Operating Income or Loss | $200,200 |
Income from Continuing Operations | |
Expenses Net/Total other Income | $114,400 |
Earnings before Int & Tax | $200,200 |
Interest Exp | -$32,200 |
Income before Tax | $314,600 |
Income Tax Exp | $100 |
Minority Interest | $23,300 |
Net Income from Continuing Ops | $314,500 |
Net Income | $295,300 |
Net Income applicable to common shares | $230,700 |
Balance Sheet | |
Current Assets | |
Cash and Cash Equ | $137,700 |
Net Receivables | $41,000 |
Inventory | $12,400 |
Total current assets | $203,600 |
Long term investments | $424,700 |
Property Plant & Equipment | $736,500 |
Other Assets | $1,700 |
Total Assets | $1,366,500 |
Current Liabilities | |
Accounts Payable | $15,600 |
Other Current Liabilities | $19,400 |
Total Current Liabilities | $54,900 |
Long term debt | $1,844,000 |
Other Liabilities | $9,200 |
Minority Interest | $23,300 |
Total Liabilities | $1,932,400 |
Stockholders' Equity | |
Common Stock | -$589,200 |
Total Stockholder Equity | -$589,200 |
Net Tangible assets | -$589,200 |
Based on the income statement and balance sheet above, answer the following (show work and formulas please)
1. Current Ratio = CA/CL =
2. Inventory Turnover
3. Total asset utilization (turnover)
4. Debt Ratio = Total debt (Liabilities)/ Total Assets
5. Debt to Equity ratio
6. Basic earning power
7. ROE
Current ratio | 3.71 | times | Current assets/Current liabilities | =203600/54900 |
Inventory turnover | 37.91 | times | Sales/Inventory | =470100/12400 |
Total assets turnover | 0.34 | times | Sales/Total assets | =470100/1366500 |
Debt ratio | 1.41 | times | Total debt/Total assets | =1932400/1366500 |
Income Statement Revenue Total revenue $470,100 Cost of Revenue $149,700 Gross Profit $320,100 Operating Exp Selling...
Income Statement Sales/Revenue Total revenue 76,480,000,000 Cost of Revenue 25,110,000,000 Gross Profit 51,370,000,000 Operating Exp 31,810,000,000 Selling General & Admin - Other Operating Expense 3,390,000,000 Unusual Expense 16,180,000,000 EBIT after Unusual Expense 2,130,000,000 Non Operating Income/Expense 385,000,000 Equity in Affiliates (Pretax) 1,020,000,000 Interest Expense 17,670,000,000 Pretax Income 16,370,000,000 Other After Tax Income (Expense) 1,300,000,000 Consolidated Net Income - Minority Interest Expense 1,300,000,000 Net Income - Discontinued Operations 1,300,000,000 Net Income After Extraordinaries - Preferred Dividends 1,300,000,000 Net Income Available to...
Given the Balance Sheet and Income Statement calculate the follow ratios (must include calculations): profit ratio, liquidity ratio, activity ratio, leverage ratio, shareholder return ratio Balance Sheet All numbers in thousands A Get access to 15+ years of historical data with Yahoo Financ Breakdown 12/31/2019 v Assets v Current Assets v Cash Cash And Cash Equivalents 2,594,000 Short Term Investments Total Cash 2,594,000 Net Receivables 25,429,000 Inventory 1,422,000 Other Current Assets Total Current Assets 37,473,000 Total Current Assets 37,473,000 Non-current...
11 pts INCOME STATEMENT Sales/Revenue COGS excluding D&A Depreciation & Amortization Expense Gross Income EBIT SG&A Expense Unusual Expense Interest Expense Pretax Income Income Tax - Current Domestic Consolidated Net Income 2020 19,974 11,990 1,067 6,917 5,705 104 207 901 159 691 2019 20,229 12,199 964 7,066 5,601 167 256 1,042 272 801 5-step DuPont CALCULATE DUPONT FOR 2020 ONLY Ue AVG Assets, Equity 2020 ONLY AVG ASSET TURNOVER INTEREST BURDEN TAX BURDEN EBIT MARGIN EQUITY MULTIPLIER BALANCE SHEET Cash...
Sales Revenues Cost of Goods Sold Gross Profit s 1,000 600 400 Depreciation Expense Other Operating Expenses S 100 50 Total Operating Expenses Earnings Before Interest& Taxes (EBIT) Interest Expense Eamings Before Taxes Income Tax Expense Net Income 150 250 50 200 100 S 100 Beginning Owner's Equity Net Income Dividends Ending Owner's Equity s 2,950 100 50 S 3,000 Cash Receivables Inventory s 1,000 100 900 Current Assets Long-Term Assets Total Assets s 2,000 7,000 S 9,000 Current Liabilities...
Income Statement Sales revenue $50 Cost of goods sold 30 Gross profit (gross margin) 20 Selling and administrative expenses 10 Income before taxes A Income tax expense 4 Net Income $6 Earnings per share E Balance Sheet Cash $2 Liabilities: Inventory 5 Accounts payable $1 Current assets B Equipment, at cost 10 Shareholders’ Equity: Less: accumulated depreciation C Common stock, $1 par value per share 10 Equipment, net of depreciation 6 D Total assets $13 Total liabilities and s/equity $13...
Calculate the ratio of the following: Marnus Inc Income Statement For the Financial Year ended 12/31/19 $150,000,000 ($130,000,000) $20,000,000 12/31/18 $140,000,000 ($123,000,000) $17,000,000 $9,000,000 $10,000,000 Statement values in 000's Period Ending: Total Revenue (Net Revenue) Cost of Revenue (COGS) Gross Profit Operating Expenses Sales, General and Admin. Other Operating Items Total Operating Exp Operating Income (or loss) Interest Expense Earnings Before Tax Income Tax Net Income (or loss) $0 $0 | ($9,000,000) $11,000,000 ($1,000,000) $10,000,000 ($5,000,000) $5,000,000 ($10,000,000) $7,000,000 ($800,000)...
1/ Given the following data: sales $1,500,000; gross profit $640,000; net income after tax $40,000 and income tax expense $35,000. What is the common-size percentage for operating expenses? 37.7% 42.7% 95.0% 97.3% 2/ To best interpret the accounts receivable turnover ratio, the days in accounts receivable should be compared to the company's inventory turnover. sales revenue. credit terms. accounts receivable balance. 3/ The quick ratio will be negatively impacted by tying up cash in inventory. increasing accounts receivable. decreasing the...
Solve for the missing numbers. Total Liabilities And Equity ________, Revenue ________ , Gross Property, Plant & Equipment ________, Depreciation ________ , Inventory ________ , Net Income ________ , Interest Expense ________ , Goodwill ________ , Income Taxes Payable ________ , Deferred Tax Liability, Non-Current ________ , Selling & Admin Expense 3,754, Retained Earnings 111, R & D Expense 31, Total Current Assets 4,967, Total Liabilities 33,618, Other Operating Expense 74, Operating Income 2,403, Other Non-Current Liabilities 1,086, Other Current...
Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Income Statement Data for Year $66,800 $413,000 46,000 308,000 14,400 77,000 680 1,800 (90) (380) 1,400 6,900 $4,230 $18,920 Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Balance Sheet Data (End of Year) $18,000 $47,000 27,500 121,000 $45,500 $168,000 $11,000 $54,000 16,800 45,000 17,700 69,000 $45,500 $168,000 Total assets Total...
Calculate the RATIO of the following: Marnus Inc Income Statement For the Financial Year ended 12/31/19 $150,000,000 ($130,000,000) $20,000,000 12/31/18 $140,000,000 ($123,000,000) $17,000,000 $9,000,000 $10,000,000 Statement values in 000's Period Ending: Total Revenue (Net Revenue) Cost of Revenue (COGS) Gross Profit Operating Expenses Sales, General and Admin. Other Operating Items Total Operating Exp Operating Income (or loss) Interest Expense Earnings Before Tax Income Tax Net Income (or loss) $0 $0 | ($9,000,000) $11,000,000 ($1,000,000) $10,000,000 ($5,000,000) $5,000,000 ($10,000,000) $7,000,000 ($800,000)...