Please use excel, need help with functions and setting up cash flows in Excel because I am only used to using a financial calculator, thanks!

In this exercise we solve iteratively for the internal rate of return. Consider an investment which costs 800 and has cash flows of 300, 200, 150, 122, 133 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): Basic Financial Calculations 1 IRR? 10.00% Division of payment between: LOAN TABLE PrincipalPayment Year Cash flow Year at beginning at end of Interest Principal 800 300 200 150 122 133 of year 800.00 580.00 438.00 331.80 242.98 134.28