Problem 2 Read through Problem 9 of Chapter 8. Verify that the spreadsheet I've provided represents the problem statement. Note that l've labeled the spreadsheet case the "Base Case". This will be the set of economics you will use to start the "breakeven" analysis". Answer the following questions (A) If the number of snowmobiles went from 100 units per year being sold in the Base Case to 150 per year, what is the new NPV at the minimum acceptable return of 10%? (B) Using the spreadsheet for the Base Case (number of snowmobiles sold per year is $100): What is the IRR of the business? From the Base Case, how low can the number of snowmobile sales go to in order to have an NPV of zero? Ths is called the breakeven point. i. ii. ii. You get good news from your team ! Your marketing team forecasts that sales of the snowmobiles will be 120 per year which is better than in the Base Case. Hghw much can you now afford to invest and still get a 10% return