Flextronics Corporation

Flextronics stock price had been lagging its industry averages, so its board of directors brought in a new CEO, John Lee. Lee had brought in Ashley Novak; finance MBA who had been working for a consulting company, to replace the old CFO, and Lee asked Ashley to develop the financial planning section of the strategic plan. In her previous job, Novaks primary task had been to help clients understand and interpret financial statements and develop financial forecasts.

Novak began as she always did, by comparing Flextronicss financial ratios to the industry averages. If any ratio was substandard, she discussed it with the responsible manager to see what could be done to improve the situation. The following data shows Flextronicss latest financial statements plus some ratios and other data that Novak plans to use in her analysis.

Flextronics (Millions of Dollars Except Per Share Data)
Balance Sheet, 12/31/2013				Income Statement, Year Ending 2013
Cash		$ 20		Sales		$2,000
Accts. rec.		280		Op. costs (excl. depr.)		1,800
Inventories		400		Depreciation		50
Total CA		$ 700		EBIT		$ 150
Net fixed assets		500		Interest		40
Total assets		$1,200		Pretax earnings		$ 110
				Taxes (40%)		44
Accts. pay. & accruals		$ 80		Net income		$ 66
Line of credit		$0
Total CL		$ 80		Dividends		$20.0
Long-term debt		500		Add. to RE		$46.0
Total liabilities		$ 580		Common shares		10.0
Common stock		420		EPS		$6.60
Retained earnings		200		DPS		$2.00
Total common equ.		$620		Ending stock price		$52.80
Total liab. & equity		$1,200
Selected Additional Data for 2013
	Flextronics		Industry				Flextronics		Industry
Op. costs/Sales	90.0%		88.0%		Total liability/Total assets		48.3%		36.7%
Depr./FA	10.0%		12.0%		Times interest earned		3.8		8.9
Cash/Sales	1.0%		1.0%		Return on assets (ROA)		5.5%		10.2%
Receivables/Sales	14.0%		11.0%		Profit margin (M)		3.30%		4.99%
Inventories/Sales	20.0%		15.0%		Sales/Assets		1.67		2.04
Fixed assets/Sales	25.0%		22.0%		Assets/Equity		1.94		1.56
Acc. pay. & accr. / Sales	4.0%		4.0%		Return on equity (ROE)		10.6%		16.1%
Tax rate	40.0%		40.0%		P/E ratio		8.0		16.0
ROIC	8.0%		12.5%
NOPAT/Sales	4.5%		5.6%
Total op. capital/Sales	56.0%		45.0%

Note: Flextronics was operating at full capacity in 2013. Also, you may observe small differences in items like the ROE

when calculated in different ways. Any such differences are due to rounding, and they can be ignored.

Using Flextronicss data and its industry averages, how well run would you say Flextronics appears to be in comparison with other firms in its industry? What are its primary strengths and weaknesses? Be specific in your answer, and point to various ratios that support your position. Also, use the Du Pont equation as one part of your analysis.

Du Pont equation = (Profit margin) (total assets turnover) (equity multiplier) = Net income/ Sales x Sales /total sales x Total Assets/ common equity

Use the following table below answer the questions:

	Actual	Forecast
Inputs	2013	2014	2015	2016	2017
Sales growth rate:		10%	8%	5%	5%
Op. costs/Sales:	90%	90%	90%	90%	90%
Depr./FA	10%	10%	10%	10%	10%
Cash/Sales:	1%	1%	1%	1%	1%
Acct. rec. /Sales	14%	14%	14%	14%	14%
Inv./Sales:	20%	20%	20%	20%	20%
FA/Sales:	25%	25%	25%	25%	25%
AP & accr. / Sales:	4%	4%	4%	4%	4%
Tax rate:	40%	40%	40%	40%	40%
Rate on all debt		8.0%	8%	8%	8%
Div. growth rate:	5%	10%	10%	10%	10%
Target WACC		9%

For each of the next four years, forecast the items in the above table.

Using the forecasted items in the section a, calculate for each of the next four years the net operating profit after taxes (NOPAT), net operating working capital, total operating capital, free cash flow (FCF).

What does the forecasted free cash flow in the first year imply about the need for external financing?

Assuming that FCF will continue to grow at the growth rate for the last year in the forecast horizon (Hint: 5%).

What is the terminal value at 2017?

What is the present value of the terminal value?

What is the present value of the forecasted FCF?

What is the current value of firm?

Using information from the 2013 financial statements, what is the current intrinsic stock price?