Please answer all parts and make a full table.

Problem 1. 30pts10pts ea. Note: None of the cash flows below can be solved analytically (by computation). You'll need to use Excel or Sheets to determine the i to be used in your calculations. Therefore, for each problem, please include your Excel or Sheets spreadsheet showing how you calculated i* and/or the "true" IRR (IRR function; trial-and-error; graphing; or Goal Seek) and your result(s), as well as the Formula View that shows the formulas used. Use the examples from lecture. For each project Net Cash Flow below, a. Identify whether the cash flow is a simple or non-simple investment. b. Determine the possible \# of real, positive i"s. Show how you arrived at that number. c. Determine i. If i is not the true IRR, determine the true IRR. d. Assuming this firm has a MARR of 15%, would you accept or reject the project? Cash Flow 1: a. Simple or non-simple investment? b. Determine the possible \# of real, positive is. at that number. Show how you arrived c. Determine i* d. In this case, is i the same as the IRR? Why or why not? e. If not, determine the "true" IRR. f. Based on an MARR of 15%, would you accept or reject this project