As a Division Manager you have $250,000 to invest in a newproject. The Maverick Project Teams says that if you invest withthem the company will receive returns of $70,000 after a year,$120,000 after two years and $120,000 after three years. The BullProject Team says that if you invest with them the company willreceive nothing for the first two years and then $370,000 at theend of the third year. The current annual discount rate is 6%.Create a worksheet that determines which project team offers thebetter financial return on the investment.
