Question

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. The company bought some land three years ago for $2.9 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. The land was appraised last week for $6 million on an aftertax basis. In five years, the aftertax value of the land will be $6.4 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 $32.6 million to build. The following market data on DEI’s securities are current:

Debt: 245,000 bonds with a coupon rate of 6 percent outstanding, 23 years to maturity, selling for 105 percent of par; the bonds have a $1,000 par value each and make semiannual payments.

Common stock: 9,500,000 shares outstanding, selling for $73.10 per share; the beta is 1.2.

Preferred stock: 465,000 shares of 3.8 percent preferred stock outstanding, selling for $83.00 per share. The par value is $100. Market: 6 percent expected market risk premium; 2.9 percent risk-free rate.

DEI uses G.M. Wharton as its lead underwriter. Wharton charges DEI spreads of 7 percent on new common stock issues, 4.5 percent on new preferred stock issues, and 2.5 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 22 percent. The project requires $1,475,000 in initial net working capital investment to get operational. Assume DEI raises all equity for new projects externally and that the NWC does not require floatation costs..

a. Calculate the project’s initial Time 0 cash flow, taking into account all side effects. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to the nearest whole dollar amount, e.g., 1,234,567.)

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 +1.5 percent to account for this increased riskiness. Calculate the appropriate discount rate to use when evaluating DEI’s project. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)

c. The manufacturing plant has an eight-year tax life, and DEI uses straight-line depreciation to a zero salvage value. At the end of the project (that is, the end of Year 5), the plant and equipment can be scrapped for $5.2 million. What is the aftertax salvage value of this plant and equipment? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to the nearest whole dollar amount, e.g., 1,234,567.)

d. The company will incur $7,500,000 in annual fixed costs. The plan is to manufacture 19,550 RDSs per year and sell them at $11,070 per machine; the variable production costs are $9,700 per RDS. What is the annual operating cash flow (OCF) from this project? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to the nearest whole dollar amount, e.g., 1,234,567.)

e. DEI’s comptroller is primarily interested in the impact of DEI’s investments on the bottom line of reported accounting statements. What will you tell her is the accounting break-even quantity of RDSs sold for this project? (Do not round intermediate calculations and round your answer to nearest whole number, e.g., 32.)

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. (Do not round intermediate calculations. Enter your NPV in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89. Enter your IRR as a percent rounded to 2 decimal places, e.g., 32.16.)

Answer 1

Part a)

The value of initial time 0 cash flow is determined as below:

Initial Cash Flow at Time 0 = -(Appraised Value of Land + Cost of Building Plant and Equipment + Net Working Capital)

Substituting values in the above formula, we get,

Initial Cash Flow at Time 0 = -(6,000,000 + 32,600,000 + 1,475,000) = -$40,075,000 (answer for Part a)

_____

Part b)

Step 1: Calculate Weights of Different Sources of Finance

To calculate the weight of different sources of finance, we need to determine the market value of each form of finance as below:

Market Value of Debt = Number of Bonds*Par Value*Current Selling Price Percentage = 245,000*1,000*105% = $257,250,000

Market Value of Common Stock = Number of Shares*Current Selling Price = 9,500,000*73.10 = $694,450,000

Market Value of Preferred Stock = Number of Shares*Current Selling Price = 465,000*83 = $38,595,000

Total Market Value of Firm = Market Value of Debt + Market Value of Common Stock + Market Value of Preferred Stock = 257,250,000 + 694,450,000 + 38,595,000 = $990,295,000

Now, we can calculate weights as follows:

Weight of Debt = Market Value of Debt/Total Market Value of Firm = 257,250,000/990,295,000

Weight of Equity = Market Value of Equity/Total Market Value of Firm = 694,450,000/990,295,000

Weight of Preferred Stock = Market Value of Preferred Stock/Total Market Value of Firm = 38,595,000/990,295,000

_____

Step 2: Calculate After-Tax Cost of Debt

The after-tax cost of debt can be calculated with the use of Rate function/formula of EXCEL/Financial Calculator. The function/formula for Rate is Rate(Nper,PMT,-PV,FV) where Nper = Period, PMT = Payment (here, Coupon Payment), PV = Present Value (here, Current Selling Price) and FV = Future Value (here, Face Value of Bonds).

Here, Nper = 23*2 = 46, PMT = 1,000*6%*1/2 = $30, PV = 1,000*105% = $1,050 and FV = $1,000

Using these values in the above function/formula for Rate, we get,

Pre-Tax Cost of Debt = Rate(46,30,-1050,1000)*2 = 5.61%

After-Tax Cost of Debt = Pre-Tax Cost of Debt*(1-Tax Rate) = 5.61%*(1-22%) = 4.38%

______

Step 3: Calculate Cost of Preferred Stock

The cost of preferred stock is determined as below:

Cost of Preferred Stock = Annual Dividend/Current Stock Price*100 = (3.8%*100)/83*100 = 4.58%

______

Step 4: Calculate Cost of Equity

The cost of equity is arrived as below:

Cost of Equity = Risk Free Rate + Beta*(Market Risk Premium) = 2.9% + 1.2*(6%) = 10.10%

______

Step 5: Calculate Discount Rate

The value of discount rate is calculated as follows:

Discount Rate = (Weight of Debt*After-Tax Cost of Debt + Weight of Preferred Stock*Cost of Preferred Stock + Weight of Equity*Cost of Equity) + Appropriate Risk Adjustment Factor

Substituting values in the above formula, we get,

Discount Rate = (257,250,000/990,295,000*4.38% + 38,595,000/990,295,000*4.58% + 694, 450,000/990,295,000*10.10%) + 1.5% = 9.90% (answer for Part b)

______

Part c)

The after-tax salvage value of the plant is arrived as below:

Annual Depreciation = Cost of Plant and Equipment/Useful Life = 32,600,000/8 = $4,075,000

Book Value of Plant and Equipment After 5 Years = Cost of Plant and Equipment - Annual Depreciation*5 = 32,600,000 - 4,075,000*5 = $12,225,000

Loss on Sale of Plant and Equipment = Book Value of Plant and Equipment After 5 Years - Salvage Value = 12,225,000 - 5,200,000 = $7,025,000

After-Tax Salvage Value = Salvage Value + Loss on Sale of Plant and Equipment*Tax Rate = 5,200,000 + 7,025,000*22% = $6,745,500 (answer for Part c)

______

Part d)

The annual operating cash flow (OCF) is determined as follows:

Sales Value (19,550*11,070)	216,418,500
Less Variable Costs (19,550*9,700)	189,635,000
Fixed Costs	7,500,000
Depreciation	4,075,000
EBT	15,208,500
Less Taxes	3,345,870
EAT	11,862,630
Add Depreciation	4,075,000
Operating Cash Flow	$15,937,630

Answer for Part d) is $15,937,630.

______

Part e)

The accounting break-even quantity is calculated as follows:

Accounting Break-Even Quantity = (Fixed Cost + Depreciation)/(Selling Price - Variable Cost)

Substituting values in the above formula, we get,

Accounting Break-Even Quantity = (7,500,000 + 4,075,000)/(11,070 - 9,700) = 8,449 units (answer for Part e)

______

Part f)

IRR

IRR is the minimum rate of return acceptable from a project. It can be calculated with the use of IRR function/formula of EXCEL/Financial Calculator. The basic formula for calculating IRR is given below:

NPV = 0 = Cash Flow Year 0 + Cash Flow Year 1/(1+IRR)^1 + Cash Flow Year 2/(1+IRR)^2 + Cash Flow Year 3/(1+IRR)^3 + Cash Flow Year 4/(1+IRR)^4 + Cash Flow Year 5/(1+IRR)^5

IRR is calculated with the use of EXCEL as below:

where

IRR = RR(B2:B7) = 33.16%

______

NPV

The NPV can be calculated with the use of following formula:

NPV = Cash Flow Year 0 + Cash Flow Year 1/(1+Discount Rate)^1 + Cash Flow Year 2/(1+Discount Rate)^2 + Cash Flow Year 3/(1+Discount Rate)^3 + Cash Flow Year 4/(1+Discount Rate)^4 + Cash Flow Year 5/(1+Discount Rate)^5

Substituting values in the above formula, we get,

NPV = -40,075,000 + 15,937,630/(1+9.90%)^1 + 15,937,630/(1+9.90%)^2 + 15,937,630/(1+9.90%)^3 + 15,937,630/(1+9.90%)^4 + (15,937,630 + 6,745,500 + 1,475,000 + 6,400,000)/(1+9.90%)^5 = $29,619,521.66

______

Notes:

There can be a slight difference in final answers on account of rounding off values.