1. Innovation Company is thinking about marketing a new software product. Upfront costs to market and develop the product are $5 million. The product is expected to generate profits of $1 million per year for 10 years. The company will have to provide product support expected to cost $100,000 per year in perpetuity. Assume all profits and expenses occur at the end of the year.

A.) How many IRRs does this investment opportunity have? (You need to draw the NPV plot using excel.)

*would like to know how to plot the NPV graph in excel to find the multiple IRR's