1. A project has will cost a company $1,000,000 to create. It is expected that in year 1 we will see cash flow as a direct result of the project of $100,000, in year 2 $200,000, year 3 $350,000, and in year 4 $450,000.

   What is the internal rate of return for this scenario. Use a spreadsheet, business calculator, or write a program to perform this calculation.

   In your answer below describe how you did it, the formulas and functions you used, and the IRR.