need detailed calculations; answer needs to be in excel

X Co is a large company listed on a major stock exchange. In recent years, the board of X Co has been criticized for weak corporate governance and two of the company's non-executive directors have just resigned. A recent story in the financial media has criticised the performance of X Co and claims that the company is failing to satisfy the objectives of its key stakeholders. X Co is appraising an investment project which it hopes will boost its performance. The project will cost $30m, payable in full at the start of the first year of operation. The project life is expected to be four years. Forecast sales volumes, selling price, variable cost and fixed costs are as follows: Year 1 3 Sales (units/year) 200,000 310,000325,000 200,000 Selling price ($/unit) 125 130 135 120 Variable cost ($/unit) 71 71 180 71 Fixed costs ($'000/year) 3,000 3,100 3,300 3,100 Selling price and cost information are in current price terms, before applying selling price inflation of 3% per year, variable cost inflation of 5% per year and fixed cost inflation of 7% per year. X Co pays corporation tax of 35%, with the tax liability being settled in the year in which it arises. The company can claim tax-allowable depreciation on the full initial investment of $30m on a 25% reducing balance basis. The investment project is expected to have residual value of $5m at the end of four years. X Co has a nominal after-tax cost of capital of 15%. Required: Calculate the nominal net present value of X Co's investment project