Question

5. You are evaluating a firm’s shares which are currently sold for $22 for investment. You are using 10% of the margin of safety that is applied to the value per share. Use the following information. Last year the firm posted sales of $500 million. You expect sales to grow at 10 percent for 3 years and 8 percent for another two years before the firm matures with a sales growth rate of about 4%. Assume that the company currently has 25% operating margin which will increase to 27% in year 3 and after. Corporate tax rate and will remain at the current rate of 25%. Interest is paid at after-tax cost of debt rate of 5%. The company has $250 million debt which is a quarter of assets. Use CAPM to calculate the company’s cost of equity (Risk free rate is 2%, market risk premium is 8% and the company’s equity beta is 1.20). Capital expenditures will be 10% of sales and depreciation will be 1% of sales every year. Company also invests 0.5% of sales in expanding net working capital every year. The number of shares outstanding is 30 million. Would you invest in this stock? Solve the problem in Excel and copy-paste your tables to your word document – make sure they are organized, properly labeled and readable. (25 points)

Answer 1

Calculation of Cost to Company (Kc)
Cost of Equity (Ke) using CAPM: -
	= Rf + (Rm-Rf)B
	=2%+(8%-2%)*1.2
	9.20%
Cost of Debt post -tax	5%
Market value of: -			Weights
Debt (Quarter of assets)	250		0.25
Equity	750		0.75
	1000
Kc = KeWe + KdWd
= 9.2% * 0.75 + 5% * 0.25
= 8.15%

Free cash flow for firm (FCFF)	($ in millions)
Growth (%)	Sales			10.00%	10.00%	10.00%	8.00%	8.00%	4.00%
Proportion (%)	OM		25.00%	25.00%	25.00%	27.00%	27.00%	27.00%	27.00%
Particulars			Year 0	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6
Sales			500.00	550.00	605.00	665.50	718.74	776.24	838.34
Operating Margin			125.00	137.50	151.25	179.69	194.06	209.58	226.35
Capital Expenditure (CE) (10% of sales)		A	50.00	55.00	60.50	66.55	71.87	77.62	83.83
Depreciation (1% of sales)		B	5.00	5.50	6.05	6.66	7.19	7.76	8.38
Working Capital changes (0.5% of sales)		C	2.50	2.75	3.03	3.33	3.59	3.88	4.19
Net Investment (A-B+C)			47.50	52.25	57.48	63.22	68.28	73.74	79.64
Operating Margin			125.00	137.50	151.25	179.69	194.06	209.58	226.35
Add:- Depreciation			5.00	5.50	6.05	6.66	7.19	7.76	8.38
EBIT			130.00	143.00	157.30	186.34	201.25	217.35	234.73
NOPAT [EBIT * (1-tax rate)]			97.50	107.25	117.98	139.76	150.94	163.01	176.05
Free cash flow for firm (FCFF)			50.00	55.00	60.50	76.53	82.66	89.27	96.41
(NOPAT - Net Investment)
PVF @ 8.15%				0.92	0.85	0.79	0.73	0.68
PV of FCFF for 1 to 5 years @ Kc				50.85	51.72	60.50	60.41	60.33

Value of firm at horizon period start from 6 year
Vf = FCFF6 / Kc-g
= 96.41 / 0.0815 - 0.04
= $ 2,323.1325 Million
PV of 2,323.1325 @ Kc = Vf / (1+Kc)^5
= $ 1,579.73 Million
Value of firm = 50.85+51.72+60.5+60.41+60.33+1579.73
= $ 1,863.54 Millions
Less:- Debt = $ 250 Millions
Value of Equity = $ 1,613.54 Millions
No. of Share    jeff jeffy Next > < Previous Related Solutions Suppose that managers of XYZ think their firm’s shares are currently overvalued and suppose that their... Suppose that managers of XYZ think their firm’s shares are currently overvalued and suppose that their sole objective is to maximize value for their ongoing, long-term share-holders. Assume that managers of XYZ decide to raise some capital through either (a) equity or (b) debt. Which will they prefer? Why? Under policy (a) in part (a), how would new shareholders be affected in the long-run? Discuss some empirical evidence that is consistent with your prediction (by empirical evidence, I mean some... You are evaluating to make an investment in a small biotechstart-up which will require an... You are evaluating to make an investment in a small biotech start-up which will require an investment of $1.4 million. The start-up is expecting to generate free cash flows of $200,000 during the first year.After one year, the insurance companies will decide if the start-up’s drug will be cover in their plans or not. If they decide to not cover the drug, the company will be able to generate free cash flows of $400,000 during the next 12 years (the... . ESS is currently trading at $235/share. You bought 200 shares of ESS and sold 2... . ESS is currently trading at $235/share. You bought 200 shares of ESS and sold 2 CALL-option contracts on ESS with a strike price of $230 for $15 each. a. What will be your total $ and % gain/loss if ESS price is $250 at the expiration date? b. What will be your total $ and % gain/loss if ESS price is $230 at the expiration date? c. What will be your total $ and % gain/loss if ESS price... The firm’s CFO is currently considering a transaction to repurchase shares using excess cash of $800,000.   The firm’s CFO is currently considering a transaction to repurchase shares using excess cash of $800,000. The value of the firm’s other assets is $5,200,000. The firm has 600,000 shares outstanding and the total value of equity is worth $6,000,000. Assume the book value of assets equals the market value. The firm has a net income of $700,000. If the firm spends all of its excess cash on a share repurchase program, how many shares of stock will be... You are the Chief Investment Officer of a large Australian investment fund which is currently invested... You are the Chief Investment Officer of a large Australian investment fund which is currently invested in a broadly diversified portfolio of Australian bonds (40 per cent) and Australian shares (60 per cent). You believe that further diversification through the addition of other asset classes would both reduce portfolio risk and increase portfolio return. Analysis presented to you shows that depressed conditions in Australian real estate markets are offering opportunities for property acquisitions at levels of expected return that are... You are evaluating to make an investment in a small biotech start-up which will require an... You are evaluating to make an investment in a small biotech start-up which will require an investment of $1.7 million. The start-up is expecting to generate free cash flows of $200,000 during the first year. After one year, the insurance companies will decide if the start-up’s drug will be cover in their plans or not. If they decide to not cover the drug, the company will be able to generate free cash flows of $400,000 during the next 12 years... You are evaluating to make an investment in a small biotech start-up which will require an... You are evaluating to make an investment in a small biotech start-up which will require an investment of $2.1 million. The start-up is expecting to generate free cash flows of $200,000 during the first year. After one year, the insurance companies will decide if the start-up’s drug will be cover in their plans or not. If they decide to not cover the drug, the company will be able to generate free cash flows of $400,000 during the next 12 years... You are evaluating to make an investment in a small biotech start-up which will require an... You are evaluating to make an investment in a small biotech start-up which will require an investment of $1.7 million. The start-up is expecting to generate free cash flows of $200,000 during the first year. After one year, the insurance companies will decide if the start-up’s drug will be cover in their plans or not. If they decide to not cover the drug, the company will be able to generate free cash flows of $400,000 during the next 12 years... You are evaluating a capital project with a Net Investment of $400,000, which includes an increase... You are evaluating a capital project with a Net Investment of $400,000, which includes an increase in net working capital of $16,000. The project has a life of 12 years with an expected salvage value of $3,000. The project will be depreciated via simplified straight-line depreciation. Revenues are expected to increase by $90,000 per year and operating expenses by $8,000 per year. The firm's marginal tax rate is 40 percent and the cost of capital for this project is 15%.... You are evaluating a capital project with a Net Investment of $800,000, which includes an increase... You are evaluating a capital project with a Net Investment of $800,000, which includes an increase in net working capital of $8,000. The project has a life of 20 years with an expected salvage value of $100,000. The project will be depreciated via simplified straight-line depreciation. Revenues are expected to increase by $120,000 per year and operating expenses by $14,000 per year. The firm's marginal tax rate is 40 percent and the cost of capital for this project is 12%.... ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions Subject sociology Write a two page paper on gun control in today’s society 3. We wish to determine the thermal conductivity of an apple (= 950 kg/m3, Cp =... The specialization of jobs in our society today and brought out some consequences of this trend.... Write a program to draw a Pentagon with blue color inside a window. Using C ++... electrical resistance 1. The high-resistance paper has a resistivity of 1:25 Ωm. How do your values... DecourcyW Inc. recently hired you as a consultant to estimate the company’s WACC. You have obtained... Walmart is a huge retailer but gets only about a quarter of its sales from outside... ADVERTISEMENT About @ 2020 WizEdu