Use the EXTERNAL RATE OF RETURN method to answer this question. Assume 15% cost of capital. Consider a project with the cash flows described below, and assume the REINVESTMENT rate is equal to 10% (projects cash flows can be reinvested at 10%). Should the project be accepted? Why?

Year Cash Flow

0 -300,000

1 140,000

2 100,000

3 70,000

4 50,000

5 40,000

6 40,000

The answer should be in excel and please show the function that used in excel