please use goal seek and provide instructions snd formulas thank you!

C D E F G H Instructions: Use Goal Seek and calculate IRR and fill in the Division of Payment Table I J K L M N In this exercise we solve iteratively for the internal rate of return. Consider an investment which costs 1000 and has cash flows of 400, 300,250, 150, 125 in years 1-5. Setting up the loan table below shows that 10% is greater than the IRR (since the return of principal at the end of year 5 is less than the principal at the beginning of the year): USE: Goal Seek IRR? NPV Year LOAN TABLE Division of payment Principal Payment Year at beginning at end of Interest Principal of year year Cash flow OLD OUT