50.1K

Verified Solution

Link Copied!

Marnus Inc Income Statement For the Financial Year ended Statement values in 000's Period Ending: 12/31/19 12/31/18 Total Revenue (Net Revenue) $150,000,000 $140,000,000 Cost of Revenue (CoGS) ($130,000,000) ($123,000,000) $20,000,000 $17,000,000 Gross Profit Operating Expenses Sales, General and Admin. $9,000,000 $10,000,000 $0 $0 Other Operating Items Total Operating Exp ($9,000,000) ($10,000,000) $11,000,000 $7,000,000 Operating Income (or loss) Interest Expense ($1,000,000) ($800,000) $10,000,000 $6,200,000 Earnings Before Tax ($4,000,000) ($5,000,000) Income Tax Net Income (or loss) $5,000,000 $2,200,000 12/31/19 12/31/18 Dividends declared and paid 500,000 $ $ Preferred 400,000 1,000,000 $ 1,000,000 $ Ordinary 1,000,000 1,000,000 Ord Shares OS as of given date $60.00 $40.00 Stock Price as of given date Marnus Inc Balance Sheet As of Dec 31st Statement values in 000's Period Ending: 12/31/18 12/31/19 Current Assets Cash and Cash Equivalents $15,000,000 $10,000,000 $8,000,000 $12,000,000 Short-Term Investments $28,000,000 $24,000,000 Net Receivabl es $12,000,000 $10,000,000 Inventory Other Current Assets $5,000,000 $3,000,000 Total Current Assets $68,000,000 $59,000,000 Long-Term Assets $30,000,000 $25,000,000 Long-Term Investments $80,000,000 $76,000,000 Fixed Assets $8,000,000 $6,000,000 Intangible Assets $5,000,000 Other Assets $4,000,000 $191,000,000 $170,000,000 Total Assets Current Liabilities $34,000,000 $30,000,000 Accounts Payable $16,000,000 $15,000,000 Short-Term Debt $9,500,000 $8,000,000 Other Current Liabilities $59,500,000 $53,000,000 Total Current Liabilities Long-Term Debt $45,000,000 $40,000,000 Other Liabilities $32,000,000 $30,000,000 $136,500,000 $123,000,000 Total Liabilities Stock Holders Equity $24,000,000 Common Stocks $20,000,000 Retained Earni ngs $30,500,000 $27,000,000 Total Equity $54,500,000 $47,000,000 Total Liabiliti es & Equity $191,000,000 $170,000,000 Compute the fol lowing ratios using Excel for the year 2019. Tests of Profitability Return on Equity (ROE)-(Net Income - Pref Div/ Average Stock Holders Equity) Return on Assets (ROA) (Net income /Average Total Assets) Earnings per share (EPS)- (Net Income Weighted Ave no of shares outstanding) 1. 2. 3. Sales Margin - Net Income / Net Sales Revenue 4. Asset Turnover - Net Sales Revenue / Average Total Assets. 5

Answer & Explanation Solved by verified expert

See Answer