Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Usingthe financial statements shown below, calculate net operatingworking capital, total net operating capital, net operating profitafter taxes, free cash flow, and return on invested capital

Usingthe financial statements shown below, calculate net operatingworking capital, total net operating capital, net operating profitafter taxes, free cash flow, and return on invested capital for themost recent year.
Lan & Chen Technologies:Income Statements for Year Ending December 31
(Thousands ofDollars) 20132012
Sales $945,000$900,000
Expenses excludingdepreciation and amortization812,700774,000
EBITDA $132,300$126,000
Depreciation andamortization 33,10031,500
EBIT $99,200$94,500
Interest Expense 10,4708,600
EBT $88,730$85,900
Taxes (40%) 35,49234,360
Net income $53,238$51,540
Common dividends $43,300$41,230
Addition to retainedearnings $9,938$10,310
Lan & Chen Technologies:December 31 Balance Sheets
(Thousands of Dollars)
Assets 20132012
Cash and cash equivalents $47,250$45,000
Short-term investments 3,8003,600
Accounts Receivable 283,500270,000
Inventories 141,750135,000
Total currentassets $476,300$453,600
Net fixed assets 330,750315,000
Total assets $807,050$768,600
Liabilities and equity
Accounts payable $94,500$90,000
Accruals 47,25045,000
Notes payable 26,2629,000
Total currentliabilities $168,012$144,000
Long-term debt 94,50090,000
Total liabilities $262,512$234,000
Common stock 444,600444,600
Retained Earnings 99,93890,000
Total commonequity $544,538$534,600
Total liabilities andequity $807,050$768,600
Key Input Data
Tax rate 40%
Net operating workingcapital
2013NOWC = Operating current assets-Operating current liabilities
2013NOWC = -
2013NOWC =
2012NOWC = Operating current assets-Operating current liabilities
2012NOWC = -
2012NOWC =
Total net operatingcapital
2013TOC = NOWC+Fixed assets
2013TOC = +
2013TOC =
2012TOC = NOWC+Fixed assets
2012TOC = +
2012TOC =
Investment in total netoperating capital
2013 2012
2013Inv. In TOC = TOC-TOC
2013Inv. In TOC = -
2013Inv. In TOC =
Net operating profit aftertaxes
2013NOPAT = EBITx( 1 - T )
2013NOPAT = x
2013NOPAT =
Free cash flow
2013FCF = NOPAT-Net investment in operating capital
2013FCF = -
2013FCF =
Return on investedcapital
2013ROIC = NOPAT/Total net operating capital
2013ROIC = /
2013ROIC =

Assume that there were 15 million shares outstanding at the endof the year, the year-end closing stock price was $65 per share,and the after-tax cost of capital was 8%. Calculate EVA and MVA forthe most recent year.

Additional Input Data
Stock price per share$65.00
# of shares (inthousands)15,000
After-tax cost of capital8.0%
Market Value Added
MVA = Stock pricex# of shares-Total common equity
MVA = x -
MVA = -
MVA =
Economic Value Added
EVA = NOPAT-(Operating Capital xAfter-tax cost of capital)
EVA = - x
EVA = -
EVA =

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Derivatives Markets

Authors: Rober L. Macdonald

4th edition

321543084, 978-0321543080

More Books

Students also viewed these Finance questions