PLEASE USE EXCEL

i. To start the new business, you will have to invest $1,000,000 today, $1,500,000 at the end of year 1 , and $2,000,000 at the end of year 2 . ii. In year 3 the business will make you a profit of $2,000,000, in year 4 the business will make you a profit of $4,000,000, and in year 5 the business will make you a profit of $6,000,000. 1. All profits provide cash flows. iii. At the end of year 5, you will sell the business for $1,000,000. iv. You require a 20% return on your investment. v. Ignore income taxes. c. Create a timeline of the cash flows related to the business. d. Calculate the NPV of business opportunity. e. Calculate the IRR of the business opportunity. f. Create a formula that determines if you should start the business or not. i. Your formula must make the decision using both the NPV and IRR calculations in a single formula. ii. Based on the evaluation of the business' NPV and IRR, your formula should either say "Start the business!" or "DON'T start the business