Question: Defense Electronics This is a comprehensive project evaluation problem bringing together much of what you have learned in this and previous chapters. Suppose you have
Defense Electronics
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 (RDSs). The company is looking at setting up a manufacturing plant overseas to produce a new line of RDSs. This will be a five-year project. In order to facilitate this project, DEI purchased some land where they will build their new manufacturing plant, which cost $4.4 million on an after-tax basis. In five years, the after-tax value of the land will be $4.8 million. The plant and equipment will cost $37 million to build.
DEIs tax rate is 32 percent. The project requires $1,300,000 in initial net working capital investment to get operational. The manufacturing plant has an eight-year tax life, and DEI uses straight-line depreciation. At the end of the project (that is, the end of Year 5), the plant and equipment can be scrapped for $5.1 million.
The company will incur $6,700,000 in annual fixed costs. The plan is to manufacture 15,300 RDSs per year and sell them at $11,450 per machine; the variable production costs are $9,500 per RDS.
The following market data on DEIs securities are current:
Debt: 210,000 6.4% coupon bonds outstanding, 25 years to maturity, selling for 110 percent of par; the bonds have a $1,000 par value each and make semiannual payments.
Common stock: 8,300,000 shares outstanding, selling for $68 per share; the beta is 1.3.
Preferred stock: 450,000 shares of preferred stock outstanding, selling for $79 per share with a dividend of $4.50.
Market: 6 percent expected market risk premium; 3.5 percent risk-free rate.
DEI uses HSOB as its lead underwriter. HSOB charges DEI 10% flotation costs on new common stock issues, 6% on new preferred stock issues, and 4% on new debt issues. Assume DEI raises all equity for new projects externally.
Calculate the NPV and the IRR of the proposed project.
Some notes that will help you with this case:
- When calculating the free cash flow for time 0, remember to include flotation costs as described above. The total cost will be the cost of the land, the cost of the building, the cost of the increase in working capital, and the flotation costs. Even though we already own the land and it might appear to be a sunk cost, remember that if we werent building the plant on the land we could use it for something else, meaning that there is an opportunity cost associated with it. Because of this, the cost of the land should be included. Be sure to put this cost under the tax line as we are dealing with after tax values.
The cost of the building and working capital will require new financing and therefore financing costs. Thus the building and working capital must be adjusted for the flotation costs as discussed in section 14-7 of the 11th edition and 14-6 of the 10th edition of the text. It is not necessary to adjust the land costs since we already own the land.
- The appropriate amount to depreciate is just the cost of the building (37,000,000). Financing costs and the cost of the land should not be included.
- In year 5, remember to include the salvage value of the land. Because the value that you are given is an after tax amount, be sure to put it under the tax line. Also remember that although the working capital will be recovered at the end of the project, the financing costs from working capital will not.

Fill out the excel sheets. This is what is needed
H6 8300000 1 Defense Electronics 2 Cost of Capital DATA 5 Debt 6 # of bonds Preferred Stock # of shares price per share Common Stock # of shares price per share beta market risk prer risk free rate 210,000 6.4% 450,000 8,300,000 68 1.3 6,0% 3.5% coupon rate 8 years to maturity 4.50 PV as a % of par 10 par value 11 , # payments per ye 2 Tax COSTS Rate of Preferred 14 Rate of Debt Rate of Equit 16 | # of payments 17 Future Value 18 Present Value 19 Coupon payment 20 Rp 21 Ater Tax Beta Market Risk Premium Risk Free Rate Price at 0 Rps Yeighted Average Cost of Capital Market Val Weigh 24 Source 25 Debt 26 Preferred 27 Equity Cost Weighted Cost 23 Total WACC Yeighted Average Flotation Costs 32 Source 33 Debt 34 Preferred 35 Equity Market Val Weight Flotation Cos Weighted Cost 0.00% 0,00% 0.00% 37 Total 0.00% WAFC Cost of Capa Capital Budgeting 1 1 Defense Electronics 2 Capital Budgeting 5 life of praject 6 Cartaf Pl 7 Incraroin W Amount Nooded Amount Rairoi FlotationCart Manufacturina Plant Warkina Capital InitialCartafLa 9 Saluaae vale afland 1,300,000 4,400,000 4,800,000 e of machine in yearr Thir ir th value thatrhouldbeured far floatation cart an lin&39. 11 Depreciation 5,100,000 Saluaa val of mahin 13 Baok alue af machine 14 Annual fixod cart rellinapriee per RD ariable cartperR 11,450 19R(WACCfram COCShoot) 22 Warkina Capital 23 Chanin uarkinq capital 2 Depreciatinn 33 AfterT 34 Depreciation 35 +Baok Value 36 CapEx ation Cortr Cost of Capital | Capital Budgeting H6 8300000 1 Defense Electronics 2 Cost of Capital DATA 5 Debt 6 # of bonds Preferred Stock # of shares price per share Common Stock # of shares price per share beta market risk prer risk free rate 210,000 6.4% 450,000 8,300,000 68 1.3 6,0% 3.5% coupon rate 8 years to maturity 4.50 PV as a % of par 10 par value 11 , # payments per ye 2 Tax COSTS Rate of Preferred 14 Rate of Debt Rate of Equit 16 | # of payments 17 Future Value 18 Present Value 19 Coupon payment 20 Rp 21 Ater Tax Beta Market Risk Premium Risk Free Rate Price at 0 Rps Yeighted Average Cost of Capital Market Val Weigh 24 Source 25 Debt 26 Preferred 27 Equity Cost Weighted Cost 23 Total WACC Yeighted Average Flotation Costs 32 Source 33 Debt 34 Preferred 35 Equity Market Val Weight Flotation Cos Weighted Cost 0.00% 0,00% 0.00% 37 Total 0.00% WAFC Cost of Capa Capital Budgeting 1 1 Defense Electronics 2 Capital Budgeting 5 life of praject 6 Cartaf Pl 7 Incraroin W Amount Nooded Amount Rairoi FlotationCart Manufacturina Plant Warkina Capital InitialCartafLa 9 Saluaae vale afland 1,300,000 4,400,000 4,800,000 e of machine in yearr Thir ir th value thatrhouldbeured far floatation cart an lin&39. 11 Depreciation 5,100,000 Saluaa val of mahin 13 Baok alue af machine 14 Annual fixod cart rellinapriee per RD ariable cartperR 11,450 19R(WACCfram COCShoot) 22 Warkina Capital 23 Chanin uarkinq capital 2 Depreciatinn 33 AfterT 34 Depreciation 35 +Baok Value 36 CapEx ation Cortr Cost of Capital | Capital Budgeting
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
