Paste u B I U tu Clipboard Font Alignment N18 Columni Column 2 Income Statement Column3 Columns Columns Column Use 2018 Column 2 Column3 G 2018 5 Sales 6 COGS 7 GrossMargin ROE 900 550 350 2017 Sales COGS GrossMargin 800 500 300 EPS 95&G 200 S&G 200 10 150 EBIT 100 Current ratio 11 EBIT 12 13 Interest Exp 14 Taxes 20 15 Interest Exp Coverage ratio 16 Net Income 115 Net Income Debt to EBITDA 67 Cash Flow 19 Shares 400 Shares 400 Free Cash Flow Questionssyr 2018 1. Did the firm issue or buy back stock? 2. Did the firm issue or buy back debt? 2. Can firm cover it's dividend with FCF2 income statement balance sheet cash flow Type here to search Clipboard Font Alignment C18 X fr =SUBTOTAL(109,C15:C17) A 1 Column1 B C Column 2 Column 3 Balance Sheet D Col F E Columns Column Columi 2018 4 5 Cash 6 Accounts receivable 7 Inventory 8 Total current assets 400 200 100 700 2017 Cash Accounts receivable Inventory Total current assets 300 200 100 600 600 700 500 800 100 2100 Long Term Investments Property Plant and Equip Goodwill Total Assets Total Assets 100 2000 10 Long Term Investments 11 Property Plant and Equip 12 Goodwill 13 Total Assets 14 15 Accounts Payable 16 Total current a liabilities 17 Long Term Debt 18 Total Liabilities 19 20 Stockholders' Equity 21 Total Stockholder Equity 22 Net Tangible Assets 220 300 1200 1720 Accounts Payable Total current liabilities Long Term Debt Total Liabilities 230 230 1450 1910 380 280 Stockholders' Equity Total Stockholder Equity Net Tangible Assets 90 - 10 income statement balance sheet cash flow Type here to search Home Insert Draw Page Layout Formulas Data Review Vie Calibri = = abe General 11 - A A - A Paste BIU - $ % Clipboard F Font Alignment Number P14 1 Column 1 Column 2 Column3 2 Statement of Cash Flows Column LolunColumns Columns Columns Columns Column 2018 2017 6 Net inome 7 Depreciation 8 Total Cash Flow From Operating Activities 115 250 365 Net income Depreciation Total Cash Flow From Operating Activities 67 250 317 -250 10 Capital Expenditures 11 Investments 12 Total Cash Flows From Investing Activities 100 Capital Expenditures Investments Total Cash Flows From Investing Activities -200 -100 -300 -150 14 Dividends Paid 15 Sale Purchase of Stock 16 Net Borrowings 17 Total Cash Flows From Financing Activities -200 -50 200 Dividends Paid Sale Purchase of Stock Net Borrowings Total Cash Flows From Financing Activities - 150 100 -250 -300 -50 19 Change in Cash and Cash Equivalents 165 Change in Cash and Cash Equivalents 283 income statement balance sheet cash flow
