Forecasting, NPV Analysis, Scenario Analysis

The question is about building scenario analysis based on NPV for Carven cottages business to build a new stand for a football stadium. The answer is revealing which option is better for Carven Cottages owner to go with.

The project presents the forecast for the sales and revenue for the construction of riverside stands. Since the demand is limited, we are to find the optimal level of construction that could generate maximum profit. The Excel sheet contains detailed calculations about

- Revenue forecast

- Fixed cost and step fixed cost forecast

- Variable cost forecast

- Forecasted cash flows

- NPV of different scenarios.

and the word file represents the interpretation of the calculation done in the Excel sheet and also reveals the discussion about the decision.

You can contact me to discuss more about the project to make it clear to you. Even I can explain the project calculation and other stuff on Zoom calls.

You can also ask me to prepare a new project similar to this.

thanks.