SHOW FORMULAS

THANKS,

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 25,$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. Question 18 What is the value of this investment opportunity to you? (use the NPV function in Excel) Answer Question 19 What is the net present value of this investment opportunity to you? (use the NPV function in Excel) Answer Question 20 What is the internal rate of return of this investment opportunity? (use the IRR function in Excel) Answer Question 21 Would you say yes or no to this opportunity based on the NPV? (use the IF function in Excel)