Question

Complete the excel.

INCOME STATEMENT 1 Sales 2 COGS 3 Depreciation expense 4 Total operating costs 5 EBIT 6 Less interest 7 Earnings before taxes

Optimal Capital Structure % Financed with Debt 0% 20% 30% EBIT, Last years EBIT Shares Outstanding (no) = P. - stock price T

OPTIMAL DEBT LEVEL 16 points Calculate the cost of Equity at each debt level. DIS = D/E Equity Beta BL W 0% 20% 30% 40% 50% 5

RECAPITALIZATION PROCESS 20 points First, find the debt at each capital structure. O O wa DVD 0% 20% 30% 40% 50% Before Debt

0 0
Add a comment Improve this question Transcribed image text
Answer #1

A) Optimal Debt level:

Cost of equity at each level of Debt:

wd D/E \betalevered = \beta unlevered[1+ (D/E)(1-T)] rs =  rf + \beta ( rmarket risk premium)
0% 0 1.25 13.5
20% 0.25 1.4375 15
30% 0.43 1.5725 15.58
40% 0.67 1.7525 17.02
50% 1 0.75 9

B) FCFF = EBIT (1 - tc) + Depreciation - Capital expenditures - Increase in NWC

FCFF = 1500 x 0.60 + 375 = 1275

Add a comment
Know the answer?
Add Answer to:
Complete the excel. INCOME STATEMENT 1 Sales 2 COGS 3 Depreciation expense 4 Total operating costs...
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
  • 11 pts INCOME STATEMENT Sales/Revenue COGS excluding D&A Depreciation & Amortization Expense Gross Income EBIT SG&A...

    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...

  • Use the following financial information for questions 2-4 below: From the income statement: Depreciation expense Interest...

    Use the following financial information for questions 2-4 below: From the income statement: Depreciation expense Interest expense Income tax Net income $112,000 25,000 45,000 53,000 From the balance sheet: Current liabilities Long-term debt Deferred income taxes Total Liabilities Preferred stock Common stock Premium on common stock Retained earnings Total Stockholders' Equity Total Liabilities &Stockholders' Equity $80,000 400,000 15,000 495,000 75,000 157,000 185,000 245,000 2. What is the Times Interest Earned ratio? 3. What is the Debt/Assets (Debt) ratio? 4. What...

  • 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)...

  • Sales Revenues Cost of Goods Sold Gross Profit s 1,000 600 400 Depreciation Expense Other Operating...

    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...

  • Answer 1&2 plz Ecologic Co. Ltd's income statement is given below: Sales Operating costs excluding D&A...

    Answer 1&2 plz Ecologic Co. Ltd's income statement is given below: Sales Operating costs excluding D&A D&A EBIT Interest EBT Taxes (40%) Net Income 15,000,000 6,000,000 9,000,000 4,000,000 5,000,000 1,500,000 3,500,000 1400,000 2,100,000 The firm's balance sheet is given below: Assets Liabilities and Equity Cash 500,000 Accounts receivable 1,630,000 2,880,000 5,010,000 32,500,000 37,510,000 Accounts payable Notes Payable Accruals Total curret liabilities Long term liabilities Total Liabilties Total Common Equity Total Liabilities and Equity 690,000 800,000 1,020,000 2,510,000 9,900,000 12,410,000 25.100,000...

  • Module 2 Assignment ABC Inc. 2020 sales are $1,000,000. Operating costs (excluding depreciation) are 65% of...

    Module 2 Assignment ABC Inc. 2020 sales are $1,000,000. Operating costs (excluding depreciation) are 65% of sales. Net fixed assets are $195,000. Depreciation amounted to 12% of net fixed assets. Interest expenses are $105,000. The tax bill must be calculated using the corporate income tax table in the text, and ABC Inc. paid 8% of net income in dividends. Prepare ABC Inc.’s income statement for 2018: ABC Inc. Income Statement 2020 Sales Operating costs (excluding depreciation) EBITDA Depreciation EBIT Interest...

  • Use the below information to answer the following question Net sales COGS Depreciation Income Statement For...

    Use the below information to answer the following question Net sales COGS Depreciation Income Statement For the Year $631,000 442.220 28.100 EBIT Interest $160.700 14.900 Taxable income $145 800 Taxes 49,600 Net income $96.200 Balance Sheet Cash Accounts receivable Inventory Net fixed assets Beginning End of Year of Year $ 38,200 $43,700 91,400 86,150 203,900 214,600 516,100 | 537,950 Total assets $849,800 $882,400 Accounts payable Long-term debt Common stock ($1 par value) Retained earnings $136.100 329,500 75,000 309.000 $104.300 298,200...

  • Complete a vertical and horizontal analysis on the tabs labeled "Balance Sheet" and "Income Statement," use total assets on the balance sheet and net sales on the income statement for...

    Complete a vertical and horizontal analysis on the tabs labeled "Balance Sheet" and "Income Statement," use total assets on the balance sheet and net sales on the income statement for your vertical analysis. Consolidated Balance Sheets (USD $) In Millions, unless o Feb. 01,2015 Vertical AnalysisFeb. 01,2014Vertical AnalysisHorizontal Analysis therwises fied Current Assets: Cash and Cash Equivalents Receivables, net Merchandise Inventories Other Current Assets Total Current Assets $1.723 1484 11079 1016 15302 38.513 $1929 1.398 11,057 895 15,279 39,064 at...

  • 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...

  • 511770 367062 10000 5000 29408 1000 Sales Operating Costs Depreciation Expense Interest Expense Tax Expense Cash...

    511770 367062 10000 5000 29408 1000 Sales Operating Costs Depreciation Expense Interest Expense Tax Expense Cash Receivables Inventories Fixed Assets, Net Payables Accrued Expenses Long-Term Loan Common Equity 30000 61177 50000 11000 10000 50000 71177 1. Current ratio 2. Quick ratio 3. NWC-to-total-Assets (Working capital to assets) 4. Ratio of total debt and liabilities to total assets 5. Ratio of total debt and liabilities to shareholder's equity 6. Interest coverage 7. Net profit margin 8. Sales to total assets (Asset...

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
ADVERTISEMENT