4. If you have the following information about an investment opportunity:
   1. Initial investment (cash out- required capital) is $ 500,000
   2. Expected operating cash inflows( after considering taxes) in year (1) $ 200,000, in year (2) $ 260,000, in year (3) $ 250,000, & in year (4) $ 150,000

Calculate the payback period, the net present value if the cost of capital is % 15%, & also calculate the internal rate of return?

Excel will do