Suppose the rates of return were 100% in the 1st year, -50% in the 2nd year.

If you had invested at the beginning of 1st year $1,000 and another $1,000 at the beginning of the

second year, what would have been the internal rate of return over the two-year span?

Please show work in a spreadsheet and thank you!