Note: You have to calculate the WACC first before you work on this question. If possible, can you do it on excel (Its okay if you can't)

-----

Marshall Industries Limited is a large publicly listed company and is the market leader in vacuum cleaner manufacturing in New Zealand. The company is undertaking a six-year project to set up a manufacturing plant overseas to produce a new line of commercial vacuum cleaners. The company bought a piece of land four years ago for $ 8 million in anticipation of using it for its proposed manufacturing plant. If the company sold the land today, it would receive $ 9.75 million after taxes. In six years, the land can be sold for $14 million after taxes and reclamation costs. The manufacturing plant will cost $275 million to build. The following market data on Marshall Industries Ltd are current: Debt $120,000,000,7.25% coupon bonds outstanding with 20 years to maturity redeemable at par, selling for 95 per cent of par; the bonds have a $1000 par value each and make semi-annual coupon payments. 15,000,000ordinary shares, selling for $55 per share 12,000,000 shares (par value $ 10 per share) with 6.5% dividends (after taxes), selling for $32 per share Equity Non-redeemable Preference shares The following information is relevant: Marshall Industries Limited's tax rate is 28% The company had been paying dividends on its ordinary shares consistently. Dividends paid during the past six years is as follows Year (-5) ($) 4.5 Year (-4) ($) 4.7 Year (-3) ($) 5.0 Year (-2) ($) 5.3 Year (-1) ($) 5.5 Year (0) ($) 6.0 The project requires $ 8.25 million in initial net working capital investment in year zero. Question: Compute the weighted average cost of capital (WACC) and assuming the following, compute the project's Net Present Value (NPV), Internal Rate of Return (IRR), Payback Period and the Profitability Index (PI). a. The manufacturing plant has a ten-year tax life, and Marshall Industries Ltd uses Diminishing value method of depreciation for the plant using a 25% depreciation rate per annum. At the end of the project, (i.e., at the end of year 6), the plant can be scrapped for $ 22 million. b. The project will incur $250 million per annum in fixed costs C. Marshall Industries Ltd will manufacture 300,000 commercial vacuum cleaners per year in each of the years and sell them at $ 2,200 per vacuum cleaner. d. The variable production costs are $ 950 per vacuum cleaner. e. At the end of year 6, the company will sell the land