please help showing steps and formula on excel if applicable. thank you so much!!

4. Suppose you own an oil platform and want to make a pipe line from the platform to the shore. You need to invest a substantial amount. The longer you wait, the higher the investment required. On the other hand, oil prices may rise as you wait, and the extraction of oil will keep increasing, although at a gradually decreasing rate. Let us suppose that the net present value of making the pipe at different future dates is as: Year of Pipe Construction 2 3 4 5 Net future value 52 66 79 91 102 111 (S millions) As you can see the longer you defer the construction of the pipe, the more money you will make. However, your concern is with the date that maximizes the net present value of your investment, that is, its contribution to the value of your firm today. If the discount rate is 15%, what is the optimal point to make the pipe? 0 1