Part A: Investment Decision - project evaluation (using Excel) (10 marks) PIA Ltd manufactures a variety of snacks. The company is considering introducing a new product. The company's manager has been provided with the following information by their business analyst. An environmental impact study has been undertaken at a cost of $800,000. This indicates that the project is environmentally sustainable, but the project still needs to be evaluated to see if it is economically viable. The project will require the use of storage capacity owned by the company. If not used for the project, this could be rented out for $110,000 per year. The project will generate waste products which can be used by another of the firm's operations, saving that operation $98,000 per year in raw material purchases. The project has an anticipated economic life of 10 years. The Company plans to spend $2,300,000 on advertising campaign to boost sales. The Company's interest expense each year will be $1,380,000. The Company is required to purchase a new machine to produce the new product. The machine's initial cost is $12,800,000. The machine will be depreciated on a straight - line basis over 6