(Please show how to do on excel)

Your company is considering investing in a new product line. Initial Investment in the product line is expected to be 1.2 million dollars. You expect the first months sales to be 1,000 units per month and then increase each month by 125 units. Variable costs start at $50 per unit but are expected to go down to $45 when the number of units goes above 1,500. Advertising costs are expected to be 10,000 a month.

1. Suppose you would like to recover your investment within the first year. Disregard time value of money and taxes. What should be the price charged in order to breakeven (round to the nearest dollar)?

2. Now suppose you are considering different scenarios of sales. Pattern of increase over the months stays the same but initial months sales are either +/- 20%. Assume price of the product is the same throughout the year and stands at $120. What is the maximum dollar return you can expect on your investment? (Dollar return = total income initial investment).

3. Consider a different cash flow alternative: you invest 1,200,000 in a high risk opportunity which yields $150,000 each year for the next 10 years (10 payments the first received in 12 months). What would be the IRR of this investment? (enter your answer in percentages - round to two digits after the decimal point 9.2582% will be entered as 9.26)