Question

Paste u B I U tu Clipboard Font Alignment N18 Columni Column 2 Income Statement Column3 Columns Columns Column Use 2018 Colum


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 Co
Home Insert Draw Page Layout Formulas Data Review Vie Calibri = = abe General 11 - A A - A Paste BIU - $ % Clipboard F Font A
0 0
Add a comment Improve this question Transcribed image text
Answer #1
ROE(2018)-- Return on equity= Net income/ Av. Equity
where, av. Equity=(Beginning+Ending equity)/2
115/(90+380)/2=
12.23%
EPS (2018)= Net income/No.of shares o/s
115/400=
0.2875
Current ratio=Current assets/Current Liabilities
2018 2017
1.Current assets 700 600
2.Current liabilities 520 460
Current ratio(1/2) 1.35 1.30
Coverage ratio
EBIT/Interest expense
EBIT 150 100
Interest Expense 20 19
EBIT/Interest expense(times) 7.5 5.3
Debt to EBITDA
Debt(total liabilities) 1720 1910
EBITDA(EBIT+depn. From CFS) 400 350
Debt to EBITDA 4.3 5.5
Cash flow(from CFS) 165 -283
FCF=OCF+/-CAPEX
OCF 365 317
CAPEX,net -150 -300
FCF 215 17
a..The company bought-back & sold --stock , resulting in a net cash outflow $ 50 (CFS--financing activity-- $-50 --as explained below:
2017 balance of ST. equity 90
Add: Net income--2018 115
Less: dividends paid 200
Less: 2018 balance of St. equity 380
Difference(380+200-90-115) 375
But --Net sale/purchase of stock(as per CFS) -50 Net cash outflow
Hence , we can only conclude that there is net Cash outflow, meaning share re-purchase or buy-back for $ 50 in 2018
b.The company issued new debt   for $200 (CFS--financing activity-- $200
2017 balance of LT debt 1450
Less: 2018 balance of St. equity 1200
Difference -250
But---Net borrowings (as per CFS) 200 Net cash inflow
Hence , we can only conclude that there is net Cash inflow, meaning issue of new debt to the tune of $ 200 in 2018
c.YES. FCF is $ 215 for 2018 ---enough to cover dividends of $ 200 (CFS--financing activity section)
Add a comment
Know the answer?
Add Answer to:
Paste u B I U tu Clipboard Font Alignment N18 Columni Column 2 Income Statement Column3...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • statement of cash flow, balance sheet, income statement and changes in stockholder's equity Font Alignment Clipboard...

    statement of cash flow, balance sheet, income statement and changes in stockholder's equity Font Alignment Clipboard A1 * A B 1 Given Data P07-24A: Font f 'Given Data P07-24A: D E C F G NORTHWEST SALES 9 10 11 12 Transactions for Year 1: 1. Cash received from sale of stock. 2. Purchase merchandise for cash. 3a.Cash sales. 3b.Credit card sales (4% service fee) 3c Sales on account. 3d Cost of Goods Sold 4. Collected receivables from credit card sales....

  • Income Statement Sales 900 COGS 550 Gross Margin 350 S&G 200 EBIT 150 Interest Exp 20...

    Income Statement Sales 900 COGS 550 Gross Margin 350 S&G 200 EBIT 150 Interest Exp 20 Taxes 15 Net Income 115 # Shares 400 Balance Sheet Cash 400 Account Receivable 200 Inventory 100 Total Current Assets 700 Long Term Investments 500 Property Plant and Equipment 800 Goodwill 100 Total Assets 2100 Accounts Payable 220 Total Current Liabilities 300 Total Liabilities 1720 Stockholders' Equity Total Stockholders' Equity 380 Net Tangible Assets 280 Cash Flow Net Income 115 Depreciation 250 Total Cash...

  • Need formulas for everything in green. Le Capy Wap Tent - pont Alignment Clipboard SI ODOS...

    Need formulas for everything in green. Le Capy Wap Tent - pont Alignment Clipboard SI ODOS Cash Flow Identity Exercise Complete the CFI using the given income statements and other information below 2019 2018 Assets Current Assets Cash & Equivalents Short term investments Accounts receivable inventories Other current assets Total current assets Comparative Balance Sheets 2019 2018 Liabilities Current Liabilities 2.500 2.550 Accounts payable 1,834 2.400 Accruals and other 5,672 4.966 Total current liabilities 2.700 2.675 Bonds Payable 1,001 941...

  • Clipboard 5 Font Cell Styles Alignment For A49 Number 5 Styles Target 32 Current assets 33...

    Clipboard 5 Font Cell Styles Alignment For A49 Number 5 Styles Target 32 Current assets 33 Noncurrent assets 34 Total assets 35 Current liabilities 36 Long-term liabilities 37 Total stockholders' equity 38 Total liabilities and stockholders' equity Wal-Mart Balance Sheet Data (End of Year) $19,680 $ 46,980 33,000 122.000 $52,680 $168.980 $12,000 $ 54,000 24 876 47,388 15,804 67,592 $52,680 $168.980 $4,600 $23,000 $3,400 $11.700 $530 $3,500 650 2,650 40 Net cash provided by operating activities 41 Cash paid for...

  • plug infromation in income statement,balance sheet Formatting Alignment Number Clipboard 1 * A Given Data P07-21A...

    plug infromation in income statement,balance sheet Formatting Alignment Number Clipboard 1 * A Given Data P07-21A f 'Given Data P07-21A: EFGHIJK SHERMAN EQUIPMENT CO. $ Salaries Expense Common Stock Notes Receivable (short term) Allowance for Doubtful Accounts Uncollectible Accounts Expense Supplies Interest Revenue Sales Revenue Dividends Interest Receivable (short term) Beginning Retained Earnings 69,000 Operating Expenses 100.000 Cash Flow from Investing Activities 24.000 Prepaid Rent 7,800 Land 8,100 Cash 1.200 Inventory 5,400 Accounts Payable 320,000 Salaries Payable 3.500 Cost of...

  • 7.pts Compute "Common Size Statement" for Financial Statement data, enter answers in right column Income Statement...

    7.pts Compute "Common Size Statement" for Financial Statement data, enter answers in right column Income Statement Revenue Cost of goods GROSS PROFIT COMPUTE COMMON SIZE STATEMENT BELOW 280 195 85 Sell + Admin Exps Depreciation Exps EBIT Interest Expense Income before Tax Income Tax NET INCOME 30 5 50 4 46 16 30 BALANCE SHEET Cash Accts Receivable Inventory Tot Current Assets Plant & Equipment Total Assets Current Liabilities Long Term Debt Total Liabilities Shareholder Equity TOT. LIABS + EQUITY...

  • Here are the recent financial statements for Snyder Foods: 2017 Income Statement Sales 2,000 COGS 1,500...

    Here are the recent financial statements for Snyder Foods: 2017 Income Statement Sales 2,000 COGS 1,500 EBIT 500 Interest expense 20 Taxable income 480 Taxes 192 Net Income 288 2017 Balance Sheet Cash 100 Accounts payable 150 Accounts receivable 70 Total current liabilities 150 Inventory 130 Total current assets 300 Long-term debt 250 Common stock 100 Fixed assets 700 Retained earnings 500 Total stockholders equity 600 Total 1000 Total 1000 2017 Statement of Cash Flows Operating activities: Net Income 288...

  • The goal is to calculate the boxes that is highlighted Font Clipboard N1 Alio Alignment Balance...

    The goal is to calculate the boxes that is highlighted Font Clipboard N1 Alio Alignment Balance Sheet e Current Assets Cash Marketable Securities Accs Receivable Promissory Notes Inventory.raw material, goods in process & Finsihed goods TIL Current Assets 5.000.00 45,000.00 30,000.00 15,000.00 Income Statement Income Sales Revenue $ 195,000.00 Returns & Allowances $ 13,500.00 Investment Income $ 45,000.00 Net Kevcu 20,000.00 10 Non-Current Assets Plant & Equipment Bldg & Land Depreciation 14 TIL Non-Current Assets penses Directly related to Production...

  • trouble with statement of cash flows Income Statement WFH Bookstore Income Statement Income Statement Sales Less:...

    trouble with statement of cash flows Income Statement WFH Bookstore Income Statement Income Statement Sales Less: Cost of Goods Sold Gross Profit Less: Other Operating Expenses EBITDA (Earnings Before Interest, Taxes, Depreciation & Amz) Less: Depreciation & Amortization EBIT (Earnings Before Interest & Taxes) Less: Interest EBT(Earnings Before Taxes, i.e. Taxable income) Less: Taxes Net Income Less: Common Stock Dividends Addition to Retained Earnings 2018 $ 325 $ (81) $ 244 $ (125) $ 119 $ (50) 69 $ (35)...

  • 1.) Use the Income Statement and Balance Sheet below to calculate the companies free cash flow....

    1.) Use the Income Statement and Balance Sheet below to calculate the companies free cash flow. Income Statement 2017 Net Sales 675 Cost of goods sold 210 Depreciation 50 EBIT 415 Interest Paid 15 EBT 400 Taxes (30%) 120 Net Income 280 Dividends 105 Addition to Retained Earnings 175 Assets 2016 2017 Liabilities and Shareholders equity 2016 2017 Current Assets Current Liabilities Cash 100 125 Accounts Payable 200 250 Accounts Receivable 250 350 Notes Payable 150 225 Inventory 400 375...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT