In: Accounting
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 $7 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. If the land were sold today, the net proceeds would be $7.65 million after taxes. In five years, the land will be worth $7.95 million after taxes. The company wants to build its new manufacturing plant on this land; the plant will cost $13.2 million to build. The following market data on DEI's securities are current: Debt: 45,500 6.8 percent coupon bonds outstanding, 20 years to maturity, selling for 94.5 percent of par; the bonds have a $1,000 par value each and make semiannual payments. Common stock: 755,000 shares outstanding, selling for $94.50 per share the beta is 1.25. Preferred stock: 35,500 shares of 6.2 percent preferred stock outstanding, selling for $92.50 per share. Market: 7 percent expected market risk premium; 5.2 percent risk-free rate. DEI's tax rate is 35 percent. The project requires $850,000 in initial networking capital investment to get operational. a. Calculate the project's Time 0 cash flow, taking into account all side effects. Assume that any NWC raised does not require floatation costs. (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, e.g., 1,234,567.) Time 0 cash flow 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 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.) Discount rate The manufacturing plant has an eight-year tax life, and DEI uses straight-line depreciation. At the end of the project (i.e., the end of Year 5), the plant can be scrapped for $1.55 million. What is the aftertax salvage value of this manufacturing plant? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, e.g., 1,234,567.) Aftertax salvage value S The company will incur $2,350,000 in annual fixed costs. The plan is to manufacture 13,500 RDSs per year and sell them at $10,900 per machine; the variable production costs are $10,100 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, e.g., 1,234,567.) Operating cash flow Calculate the project's net present value. (Enter your answer in dollars, not millions of dollars, e.g., 1,234,567. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Net present value $ Calculate the project's internal rate of return. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Internal rate of return
a) | ||||
Initial Cash Flow | ||||
Cost of Land | -$7,650,000.00 | |||
Cost of Plant (calculated below) | -$13,200,000.00 | |||
Net Working Capital | -$850,000.00 | |||
Cash flow at Time 0 | -$21,700,000.00 | |||
weighted Floatation Cost | ||||
Market Value (calculated below) | Weights | Floatation Cost | Weighted flotation cost | |
Debt | $42,997,500.00 | 36.55% | 0.00% | 0.00% |
Common Stock | $71,347,500.00 | 60.65% | 0.00% | 0.00% |
Preferred Stock | $3,283,750.00 | 2.79% | 0.00% | 0.00% |
Total | $117,628,750.00 | 100.00% | 0.00% | |
Amount raised for cost of Plant = Amount raised (1-0%) =13,200,000 | $13,200,000.00 | |||
b. The new XYZ project is somewhat riskier than a typical project for ASE primarily because the plant is being located overseas. Management has told you to use an adjustment factor of 3 percent to account for this increased riskiness. Calculate the appropriate discount rate to use when evaluating AESI’s project. | ||||
First Compute WACC | ||||
Market Value | Weights | Cost | WACC | |
Debt | $42,997,500.00 | 36.55% | 4.76% | 1.74% |
Common Stock | $71,347,500.00 | 60.65% | 13.95% | 8.46% |
Preferred Stock | $3,283,750.00 | 2.79% | 6.70% | 0.19% |
Total | $117,628,750.00 | 100.00% | 10.39% | |
WACC | 10.39% | |||
Adjustment factor | 1.00% | |||
Discount rate | 11.39% | |||
Debt | ||||
Face Value | $1,000.00 | |||
Coupon Payment = 1000 x 6.8%/2 | $34.00 | |||
Nper = 20 x 2 | 40 | |||
Present Value = $1000 x 94.5% | 945 | |||
Semi Annual Cost of Debt = YTM = Rate | 3.66% | |||
Annual Cost of Debt after tax =2 x 3.65% x (1-35%) | 4.76% | |||
Market Value = 45,500 x $945 | $42,997,500.00 | |||
Common Stock | ||||
Cost of Equity = Risk free rate + Beta x Market Risk Premium = 5.2% + 1.25 x 7% | 13.95% | |||
Market Value = 755,000 shares x $94.50 | $71,347,500.00 | |||
Preferred Stock | ||||
Cost of Preferred = Dividend/ Price = $100 x 6.2% / $92.50 | 6.70% | |||
Market Value = 35,500 shares x $92.50 | $3,283,750.00 | |||
c.The manufacturing plant has an eight-year tax life, and DEI uses straight-line depreciation. At the end of the project (i.e., the end of Year 5), the plant can be scrapped for $1.55 million. What is the aftertax salvage value of this manufacturing plant? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, e.g., 1,234,567.) | ||||
Annual depreciation for the equipment = $13200000 /8 | $1,650,000.00 | |||
Book value = $13200000 - (5 x 1650000) | $4,950,000.00 | |||
Aftertax salvage value = $1,550,000 + (35% x (4,950,000 - 1,550,000) | $2,740,000.00 | |||
d) The company will incur $2,350,000 in annual fixed costs. The plan is to manufacture 13,500 RDSs per year and sell them at $10,900 per machine; the variable production costs are $10,100 per RDS. What is the annual operating cash flow, OCF, from this project? | ||||
OCF = [(P – v)Q – FC](1 – t) + tCD | ||||
OCF = [($10,900 – 10,100)(13,500) – 2,350,000](1 – .35) + .35($13.20M/8) | $6,070,000.00 | |||
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. | ||||
Year | Cashflow | PV @11.39% | Present Value | |
0 | -$21,700,000.00 | 1.0000 | -$21,700,000.00 | |
1 | $6,070,000.00 | 0.8977 | $5,449,339.34 | |
2 | $6,070,000.00 | 0.8060 | $4,892,141.56 | |
3 | $6,070,000.00 | 0.7235 | $4,391,917.54 | |
4 | $6,070,000.00 | 0.6496 | $3,942,841.68 | |
5 | $17,610,000.00 | 0.5831 | $10,269,165.81 | |
NPV | $7,245,405.93 | |||
IRR | 21.91% | |||
Cashflow in 5th year = OCF + NWC + Residual value + aftertax value of the land | ||||