Please verify that work is correct and give answer to #21 using excel if function.

Use the following information for the remaining questions. You are considering investing in a real estate project that requires an equity investment of $30,000. The project is expected to generate annual cash flows to you of: $4,500 in year 1, $5,000 in years 2-5, $8,000 in year 6 and $17,000 in year 7. Your required rate of return for projects with similar risk is 10.5% annually. Year 0 Rate 10.5% 1 2 3 4 Cash Flow -$30,000.00 $4,500.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $8,000.00 $17,000.00 5 6 7 Question 18 What is the value of this investment opportunity to you? (use the NPV function in Excel) Answer $31,107.47 Question 19 What is the net present value of this investment opportunity to you? (use the NPV function in Excel) Answer $1,107.47 Question 20 What is the internal rate of return of this investment opportunity? (use the IRR function in Excel) Answer 2.17% Question 21 Would you say yes or no to this opportunity based on the NPV? (use the IF function in Excel)