Preview

Fin515 Project 2

Powerful Essays
Open Document
Open Document
608 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Fin515 Project 2
(13-10) Corporate Valuation The financial statements of Lioi Steel Fabricators are shown below—both the actual results for 2010 and the projections for 2011. Free cash flow is expected to grow at a 6% rate after 2011. The weighted average cost of capital is 11%

Income Statements for the Year Ending December 31 (Millions of Dollars Except for Per Share Data) Actual 2010 Projected 2011 500.00 $ 530.00 360.00 381.60 37.50 39.80 397.50 $ 421.40 102.50 $ 108.60 13.90 16.00 88.60 $ 92.60 $35.44 53.16 6.00 47.16 $ $ $37.04 55.56 7.40 48.16 29.70 18.46 10 2.97

Balance Sheet, December 21, 2010 Actual 2010 Projected 2011 $ 5.60 51.90 56.20 112.40 226.10 397.50 623.60

Net sales Costs (except depreciation) Depreciation Total operating costs Earnings before interest and taxes Less interest Earnings before taxes Taxes (40%) Net income before preferred dividends Preferred dividends Net income available for common dividends Common dividends Addition to retained earnings Number of shares Dividends per share

$

$ $ $ $ $ $ $ $

Assets Cash Marketable securities Accounts receivable Inventories Total current assets Net plant and equipment Total assets Liabilities and Equity Accounts payable Notes payable Accruals Total current liabilities Long-term bonds Preferred stock Common stock (par plus PIC) Retained earnings Common equity Total liabilities and equity

$

$ $

5.30 49.90 53.00 106.00 214.20 375.00 589.20

$ $

$

9.60 69.90 27.50 107.00 140.80 35.00 160.00 146.40 306.40 589.20

$

11.20 74.10 28.10 113.40 148.20 37.10 160.00 164.90 324.90 623.60

40.80 $ 6.36 $ 10 4.08 $

$

$

$ $

$ $

a. If operating capital as of 12/31/2010 is $502.2 million, what is the free cash flow for 12/31/2011?
(in millions) 65.16 134.90 532.40 30.20 34.96

NOPAT = EBIT (1-Tax Rate) NOWC =Operating Current assets - Operating Current Liabilities Total net operating capital = NOWC + Operating long-term assets Net investment in operting capital = NOC 2011 -

You May Also Find These Documents Helpful

  • Powerful Essays

    Debt to Equity ratio | 0.34 | 0.001 | | | | Current asset | 501,192 | 406,221 | Current liabilities | 157,453 | 123,054 | Working capital | 343,739 | 282,554 | Current ratio | 3.3 | 3.18 | Acid test ratio | 0.55 | 0.26 |…

    • 1971 Words
    • 8 Pages
    Powerful Essays
  • Good Essays

    Hcs/405 Week 4 Lt Ratios

    • 633 Words
    • 3 Pages

    2008 Ratio (unaudited) 2009 Ratio (unaudited) 2008 Ratio (audited) 2009 Ratio (audited) Current Ratio Current Ratio Current Ratio Current Ratio $130,026 Assets $8,380 Liabilities 15.52 to 1 $128,867 Assets $23,807 Liabilities 5.41 to 1 $130,026 Assets $8,380 Liabilities 15.52 to 1 $128,867 Assets $ 23,807 Liabilities 5.37 to 1 Quick Ratio Quick Ratio Quick Ratio Quick Ratio $41,851 $37,666 $79,517 / $8,380 9.49 to 1 $22,995 $59,787 $82,782 / $23,807 3.48 to 1 $41,851 + $37,666 / $8380 9.49 to 1 $22,995 + $58,787 / $23,807 3.44 to 1 Days Cash on Hand Days Cash on Hand Days Cash on Hand Days Cash on Hand $437,424 ($24,955) $412,469 / 365 = $1,130.05 $41,851 / $ 1,130.05 = 37.04 days $462,293 ($36,036)…

    • 633 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Use the financial statements from the most recent year to fill in the table below.…

    • 572 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    3/31/86 Assets Current Assets Cash Receivables, Net Inventories Prepaid Expenses Total Current Assets Fixed Assets Plant, Property, & Equipt (Less) accum depreciation Total Net Fixed Assets Other Assets Total Assets Liabilities and Stockholders' Equity Current Liabilities Accounts Payable Notes Payable - banks Income Taxes Payable Current Installments - lt debt Total Current Liabilities Long Term Debt Term Loan Notes Payable to Bank Total Liabilities Stockholders' Equity Common Stock Additional Paid in Capital Retained Earnings Total Stockholders' Equity Total Liabilities and Equity…

    • 618 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    that would appear on the balance sheet and the income statement at the end of 2010 and 2011.…

    • 916 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    Fin 571

    • 439 Words
    • 2 Pages

    What is the market value of stockholders’ equity at end of the previous and last years?…

    • 439 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    QUESTION 2 Financial Statement Analysis (8 marks) BPS Ltd, a supplier of telecommunications equipment, retails its products through suburban outlets. Shown below are the calculations of some of its key financial ratios for 2011 and 2012. 2012 2011 Return on Equity 13% 12% Return on Assets 8% 9% Profit margin 20% 18% Asset turnover 0.40 0.50 Days in inventory 72 days 55 days Days in debtors 42 days 42 days Current ratio 1.6 1.5 Quick ratio 0.7 1.1 Debt-to-Equity ratio 1.4 1.0…

    • 1403 Words
    • 8 Pages
    Powerful Essays
  • Good Essays

    |[pic]|[pic]|the company’s retained earnings for Year 8 would be $15 million (net income of $25 million less dividend payments of $10|…

    • 2790 Words
    • 12 Pages
    Good Essays
  • Satisfactory Essays

    Week 7

    • 406 Words
    • 2 Pages

    3. Net Capital for 2011 is calculated the sum of NOWC (already shown as) 134.9 million + Net Fixed Assets (2011 Projected PP&E) of 397.5 = Net Capital for 2011 of = $134.9 + $397.5 = $532.4 million.…

    • 406 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Financial Statements Balance Sheet Income Statement Cash Flow Statement Stockholders’ Equity Financial Ratios Accounting Principles Bookkeeping, Debits and Credits Accounting Equation Adjusting Entries Bank Reconciliation Petty Cash Accounts Receivable and Bad Debts Expense Inventory and Cost of Goods Sold Depreciation Accounts Payable Cost Behavior and Break-even Point Payroll Accounting Standard Costing Accounting Pronouncements Organizations…

    • 5433 Words
    • 22 Pages
    Powerful Essays
  • Better Essays

    Operating cash flow shows increases from 2010 to 2011 and increased again from 2011 to 2012 including the change in non-working capital. However, looking at the net cash flow trend from 2011 to 2012 with working capital changes removed, the value of 2012 is slightly lower than 2011. The changes in non-cash working capital have been adjusted at an…

    • 1595 Words
    • 5 Pages
    Better Essays
  • Satisfactory Essays

    Exercise 1

    • 442 Words
    • 5 Pages

    May 4 Supplies $700 Accounts Payable $700 7 Accounts Receivable $6,800 Service Revenue $6,800 8 Accounts Payable $850 Supplies $850 9 Cash $1,000 Equipment $1,000 17 Salary $530 Expense $530 29 Cash $1200 Prepaid Insurance $1200 3-5A Journalize Date ____ Account Title ____ Debit Credit______ April 2012 1 Cash $18,000 Common Stock $18,000 2 Cash $900 Expenses…

    • 442 Words
    • 5 Pages
    Satisfactory Essays
  • Powerful Essays

    quiz3 2014Fa

    • 373 Words
    • 3 Pages

    Consider a portfolio consisting of a long call with an exercise price of X, a short position in a non-dividend paying stock at an initial price of S0, and the purchase of riskless bonds with a face value of X and maturing when the call expires. What should such a portfolio be worth?…

    • 373 Words
    • 3 Pages
    Powerful Essays
  • Good Essays

    AMFAC Inc.

    • 653 Words
    • 5 Pages

    Accounts receivable and inventory remained relatively constant during the year. Assets at the beginning of the year totalled $250,000 and the stockholders’ equity at the beginning of the year amounted to $180,000. Preferred stock did not change during the year. There are no convertible securities.…

    • 653 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    Sport Drink Report

    • 405 Words
    • 2 Pages

    $ 18.3 3.4 7.5 6.5 7.6 4.2 3.2 5.2 3.2 4.7 4.4 7.5 6.5 3.4 3.2 8.9 4.7 5.0 6.2 4.5 4.7 2.8 2.7 5.6 5.2 5.2 6.3 5.2 5.0…

    • 405 Words
    • 2 Pages
    Satisfactory Essays