Place your order today at 15% discount
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? 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? 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
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? 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? 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?
