In light of the increased awareness for the need to adapt to climate change, you have been asked to determine the viability of an investment of $410,000,000 in Environ4Us Ltd which manufactures large batteries for storing solar energy.You have obtained the following data about their main project which is expected to operate for 5 years. Specifically, you are required to use 2 different financial modelling techniques to evaluate this possible investment.

YearCash SalesCash Expenses DepreciationNet Profit before TaxTax @ 30%Annual Cash Flow

($000s)($000s)($000s) ($000s)($000s)($000s)

1450,000290,00070,000

2525,000305,00060,000

3550,000320,000 50,000

4595,000400,00045,000

5620,000440,00040,000

You have been advised that the minimum after tax rate of return is 10% and the tax rate is 30%.

(a)Complete the table above and calculate the net present value

(b)Based solely on your Net Present Value calculation, would you recommend an investment in Environ4Us Ltd project? Explain.

(c)Calculate the Payback period

(d)If the investment team base their decision solely on requiring a payback period of no more than 2 years, would you recommend an investment in Environ4Us Ltd project?Explain.

(e)Name another financial modelling technique that could be used to assess the viability of an investment project?