Please note that you should send in the excel file or share excel sheets with me via email epapiashvili@ibsu.edu.ge no later than the end of the exam! The files should include detailed calculations. No files submitted after the deadline or lacking the formulas will be automatically marked with 0.

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 companys 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	2	3	4
Sales (units/year)	200,000	310,000	325,000	200,000
Selling price ($/unit)	125	130	135	120
Variable cost ($/unit)	71	71	80	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 Cos investment project.