In: Accounting
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 (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 $4.5 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 $5.3 million. In five years, the aftertax value of the land will be $5.7 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 million to build. The following market data on DEI’s securities are current:
DEI uses G.M. Wharton as its lead underwriter. Wharton charges DEI spreads of 8 percent on new common stock issues, 6 percent on new preferred stock issues, and 4 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 35 percent. The project requires $1,300,000 in initial net working capital investment to get operational. Assume Wharton raises all equity for new projects externally.
Answer | In Million $ | ||||||||
1 | Initial Cashflow | ||||||||
Inflow from Shares | 32 | ||||||||
Outflow for Purchase of Plant | -32 | ||||||||
Initial Working capital by issue on shares | 1.3 | ||||||||
Net cash inflow | 1.3 | ||||||||
2 | Discount rate used while evaluation of project | 2% | |||||||
3 | Salvage Value | ||||||||
Cost | 4.5 | ||||||||
Depreciation per year Cost/No of years = 4.5million/8 | 0.5625 | ||||||||
Depreciation for 5 year | 2.8125 | ||||||||
Balance cost | 1.6875 | ||||||||
Scrap Value | 4.5 | ||||||||
Balance cost minus Scrap vale Profit | 2.8125 | ||||||||
Tax @35% on profit | 0.984375 | ||||||||
Balance After tax Profit | 1.828125 | ||||||||
4 | Annual Operating Cashflow of Project | ||||||||
Sales 17000units @ 10800p u | 183.6 | ||||||||
Less : Variable Production cost @ 9400 p u | 159.8 | ||||||||
Contribution | 23.8 | ||||||||
Less: Fixed Costs | 68 | ||||||||
Operating Cash flow | -44.2 | ||||||||
5 | IRR and NPV | ||||||||
NPV of Cash flow @ 2% | |||||||||
NPV ofOperating Cash flow Congtribution @2% | |||||||||
years | Cash flow | Fixed cost | |||||||
0 | -1.3 | -1.3 | |||||||
1 | 23.8 | 68 | -44.2 | ||||||
2 | 23.33 | 68 | -44.67 | ||||||
3 | 22.43 | 68 | -45.57 | ||||||
4 | 21.99 | 68 | -46.01 | ||||||
5 | 21.13 | 68 | -42.37 | ||||||
Salvage value | 4.5 | ||||||||
Net cashflow | -224.12 | ||||||||
npv of cash inflow | initial investment | ||||||||
IRR | Npv of cash inflow/investment*100 | -227.32 | 33.3 | -682.643 | |||||
Npv of cashflows | 23.8+22.31+21.88+20.43+20 |