1. NPV Calculation:help with an Excel spreadsheet to calculate the net present value of investing in bottling. Would you or would you not invest in this project?
2. Sensitivity Analysis (interest rates):Calculate NPV if interest rates were 5%, 8%, 10%, and 12%. Discuss how NPV would change and the impact of that change on your decision to invest?
3. Optional: Sensitivity Analysis (price of beer):How sensitive is the investment decision to the price of beer? The owners chose to sell its beer at a high price. Would the investment decision be the same if the beer sold for $1.00 less per six-pack at retail? Recalculate the NPV and be definitive. Would you or would you not invest in this project?