In: Accounting
The Edmonton Fabricating Company (EFC) manufactures snow blowers. EFC is investigating the feasibility of a new line of cordless snow blower.
The new manufacturing equipment to produce the new line of snow blower will cost $700,000. The installation costs are expected to be $50,000, the setup costs are expected to be $30,000 and the training costs are expected to be $20,000. The company has just finished a marketing feasibility and this study strongly endorses going ahead with a further financial study to evaluate the overall feasibility of the project. The cost of the marketing study was $50,000.
The projected useful life of the new equipment is 8 years and the project unit sales are expected to be:
YEAR |
UNIT SALES |
1 |
3,000 |
2 |
3,300 |
3 |
3,500 |
4 |
3,700 |
5 |
4,000 |
6 |
4,250 |
7 |
4,300 |
8 |
4,300 |
The new cordless snow blower would be priced to sell at $300 per unit and the variable operating costs are expected to be 55% of sales. After the first year, the sales price is estimated to increase by 2% every year. The total fixed operating costs are expected to be $150,000 per year and would remain constant over the life of the project.
The project would require $40,000 in working capital at the start (time period zero). The entire amount of working capital will be recovered at the end of the project.
The estimated salvage value of the equipment after 8 years is $150,000. The marginal tax rate is 40%. The CCA rate of the equipment is 20%.
The company uses the DCF model to determine the cost of retained earnings and new common stock.
You have been provided with the following data: D0 = $0.80; P0 = $22.50; g = 8.00% (constant) and F=9.00%.
The company’s 9.25% coupon rate, semi-annual payment, $1,000 par value bond that matures in 20 years sells at a price of $1,075. The new bonds would be privately placed with no flotation costs.
The target capital structure is 40% debt, 40% common equity (retained earnings) and 20% common equity (new common stock).
REQUIRED:
What is the net present value of this project? Should the project be undertaken by Edmonton Fabricating Company (EFC)?
1. Computation of WACC
Semi Annual Cost of Debt = "=RATE(nper,pmt,pv,fv)"
Semi Annual Cost of Debt = "=RATE(20*2,1000*9.25%/2,-1075,1000)"
Semi Annual Cost of Debt = 4.23%
Annual Cost of Debt = Semi Annul Cost * 2 = 4.23 * 2 =8.46%
After Tax Cost of Debt = 8.46% * (1 - 0.40) =
5.076%
Cost of Common Stock (Retained Earnings) = [Dividends * (1 + Growth
Rate) / Price] + Growth Rate
Cost of Common Stock (Retained Earnings) = [0.80 * (1 + 0.08) / 22.50] + 0.08
Cost of Common Stock (Retained Earnings) = 11.84%
Cost of Common Stock (New STock) = [Dividends * (1 + Growth Rate) / Price*(1 - Floatation)] + Growth Rate
Cost of Common Stock (New STock) = [0.80 * (1 + 0.08) / 22.50*0.91] + 0.08
Cost of Common Stock (New STock) = 12.22%
WACC = Weights of Debt * After tax Cost of Debt + Weight of Equity * Cost of Equity
WACC = 0.40 * 5.076% + 0.40 * 11.84% + 0.20 * 12.22%
WACC = 9.21%
2. Computation of NPV
as the NPV is positive it is recommended to invest into the project.