Question

24. Project Evaluation This is a comprehensive project evaluation problem bringing together much of what you have learned in this and previous chapters. Suppose you have been hired as a financial consultant to Defense Electronics, Inc. (DEI), a large, publicly traded firm that is the market share leader in radar detection systems (RDS). The company is looking at setting up a manufacturing plant overseas to produce a new line of RDSs. This will be a 5-year project. The company bought some land three years ago for $7.3 million in anticipation of using it as a toxic dump site for waste chemicals, but it built a piping system to safely discard the chemicals instead. (for $7.5 million. In five years, the aftertax value of the land will be $7.9 million, but the company expects to keep the land for a future project. The company wants to build its new manufacturing plant on this land; the plant and equipment will cost $55 million to build. The following market data on DEI's securities is current: Page 426 Debt: 130.000 6.1 percent coupon bonds outstanding, 25 years to maturity, selling for 104 percent of par; the bonds have a par value of $2.000 and make semiannual payments. Common stock: 9,900,000 shares outstanding, selling for $68 per share the beta is 1.20. Preferred stock: 400,000 shares of 4.20 percent preferred stock outstanding, selling for $87 per share and having a par value of $100. Market: 7 percent expected market risk premium: 3.1 percent risk-free rate. DEI uses G.M. Wharton as its lead underwriter. Wharton charges DEI spreads of 6.5 percent on new common stock issues, 4.5 percent on new preferred stock issues, and 3 percent on new debt issues. Wharton has included all direct and indirect issuance costs (along with its profit) in setting these spreads. Wharton has recommended to DEI that it raise the funds needed to build the plant by issuing new shares of common stock. DEI's tax rate is 25 percent. The project requires $2.5 million in initial net working capital investment to get operational. Assume Wharton raises all equity for new projects externally. a. Calculate the project's initial Year 0 cash flow, taking into account all side effects. b. The new RDS project is somewhat riskier than a typical project for DEI, primarily because the plant is being located overseas. Management has told you to use an adjustment factor of +2 percent to account for this increased riskiness. Calculate the appropriate discount rate to use when evaluating DEI's project. c. The manufacturing plant has an 8-year tax life and DEI uses straight-line depreciation. At the end of the project i.e., the end of Year 5), the plant and equipment can be scrapped for $8.9 million. What is the aftertax salvage value of this plant and equipment? d. The company will incur $8.1 million in annual fixed costs. The plan is to manufacture 18,500 RDSs per year and sell them at $11,600 per machine; the variable production costs are $9,750 per RDS. What is the annual operating cash flow (OCF) from this project? e. DEI's comptroller is primarily interested in the impact of DEI's investments on the bottom line of reported accounting statements. her is the accounting break-even quantity of RDSs sold for this project? f. Finally, DEI's president wants you to throw all your calculations, assumptions, and everything else into the report for the chief financial officer; all he wants to know is what the RDS project's internal rate of return (IRR) and net present value (NPV) are. What will you report?

Answer 1

a & b

B19 - : X fi =B17+B18 1 Plant & Equipment cost 2 Number of bonds 3 Coupon rate 4. Par Value 5 Semi-annual coupon rate 6 Market price 7 Maturity in year 8 Number of periods 9 Yield of bond 10 Annual Yield 11 Spread on bonds 12 Market Value of Debt 13 Weight of debt 14 Cost of debt 15 Tax rate 16 Total Capital 17 WACC 18 Rsik premium for project 19 Disocunt rate B 55000000 130000 0.061 2000 =(B3/2)*B4 =104%*B4 25 =B7*2 =RATE(B8,B5,-B6,B4) =B9*2 0.03 =B6*B2 =B12/$B$16 =B10+B11 0.25 =B12+D10+F10 =B13*B14*(1-B15)+D11*D9+F11*79 0.02 =B17+B18 Number of common shares outstanding 9900000 Price per share 68 Beta 1.2 Risk free rate 0.031 Risk premium 0.07 Spread on Common stocks 0.065 CAPM rate =D5+D4*D6 Cost of equity =D8+D7 Market Value of Common shares =D2*D3 Weight of common shares =D10/$B$16 Number of common shares outstanding 400000 Coupon rate 0.042 Par Value 100 Coupon paid =F3*F4 Market value per preferred share 87 Yield of preferred share =F5/F6 Spread for preferred share 0.045 Cost of preferred shares =F8+F7 Market Value of preferred shares =F6*F2 Weight of preferred shares =F10/$B$16 21 Initial Working Capital requirement 2500000 22 Total Cash Outflow in Year 0 =B1+B21