Please solve on excel

Question 1 (40 points]: Lululemon is considering investing in new machinery that will generate sustainably created athleisure shirts and pants. The discount rate is 10%, and the initial investment in equipment $12.5 million. The machinery's economic life is 25 years and the equipment will be depreciated on a straight-line basis over the project's life and has no salvage value. The following financial information is estimated for production from the machinery: Sales price per shirt: $65 Sales price per pant: $115 Variable Costs per shirt: $2.75 Variable Costs per pant: $5.00 Fixed Costs of production per Year: $140,000 Tax Rate=21% Number of shirts sold per year: 10,100 Number of pants sold per year: 9,750 1. What is the accounting break-even level for production of a) shirts, and b) pants? [5 points] 2. What is the financial break-even level for production of a) shirts, and b) pants? [5 points] 3. What is the base-cash cash flow of this project (i.e., accounting for both shirts and pants)? [5 points] 4. What is the base-case NPV of this project? [5 points] 5. Assume that your projection for price of shirts, fixed costs, and variable costs of pants were only accurate within +/- 15%. Calculate the best-case and worst-case NPV figures. Do you think Lululemon should take on this project? Why or why not? [15 points] 6. What is the sensitivity of the NPV to changes in the fixed costs? Explain what your answer tells you about a $10,000 increase in projected fixed costs for pants. [5 points) Note: When calculating break-evens for each product type, view each product in isolation (e.g., for shirts, assume that all depreciation and costs are attributed to shirts and ignore all pant specific figures. This solves for a world where only shirts are produced and no pants are produced)