Environmental Finance Analysis Paper

All i am trying to do thus far is to do calculations and an executive summary i also need a detailed explanation of how these calculations were done. i am not even sure how to request this?You will need to follow these steps in order to complete the project:

Download the case study KEL430 from the Harvard site. All students need to purchase Harvard Business case KEL430 available at a special discount from https://hbsp.harvard.edu/import/724446 (Links to an external site.) (Expires Nov 30, 2020)
The required spreadsheet is not available from the Harvard link; instead, the spreadsheet file is provided here with permission from Harvard: KEL432-XLS-ENG completed original spreadsheet from Harvard.xlsPreview the document
Perform a detailed reading of the case study.
The spreadsheet calculates the financial and environmental impact for what we will call "Scenario 1, Base Case".
Next, conduct research to determine revised (current) assumptions for the annual price escalation rates. These will be required for the second scenario.
Enter the revised (current) assumptions for the annual price escalation rates in the spreadsheet (Pro Forma tab) from the research in step 5. Only change these rates in the Pro Forma; however, it will be necessary to modify the Pro Forma and Environmental Impact Analysis tables as additional projects become viable. This will be Scenario 2.
Once the two spreadsheet analysis are complete, the team will prepare and submit a summary investment recommendations report (the paper) uploaded here with the two Excel spreadsheet scenarios.
Assignment Requirements:

This assignment is to provide a succinct set of focused recommendations. As part of your team's analysis and discussion, the team should include responses to each of the following questions:

Is a 9.5 percent discount rate appropriate? Why or why not? How do your recommendations change when you vary this rate? (Do not change the 9.5% rate in the spreadsheet, as the sensitivity analysis tables cover a wide range.)
Are the different annual price escalation rate assumptions for water, wastewater, gas, electricity, item replacements, and maintenance costs appropriate? Why or why not? How do your recommendations change when you change these rates?
Is the 7.5 percent increase in value (exit cap) over ten years a reasonable rate of value increase? Why or why not? (Do not change the 7.5% rate in the spreadsheet, as the sensitivity analysis tables cover a wide range.)
How do the environmental impacts of each option vary? How are they similar?
How do your recommendations provide a reasonable financial return as well as a positive overall environmental impact?
Assumptions:
Use the following assumptions for the Base Case scenario:

Cost/Saving Type Price Escalation
Water 2.0%
Wastewater 1.5%
Gas 2.5%
Electricity 2.0%
Lifecycle 3.0%
Maintenance 3.5%








Assignment Format:

The paper must conform to University College Format and Style RequirementsPreview the document Turabian 2018 9th ed. and include at least five references in addition to the case study. Text citations must be used as appropriate. The content of the paper must be structured as follows:

I. Title page

II. Executive Summary (Note: an executive summary is not the same as an abstract. Present hard facts succinctly that are important to executives, e.g., issues, results, recommendations, conclusions, implications)


Useful sites:

City of Denton 2018-2019 Utility Rate Brochure (Links to an external site.)

Generally, natural gas prices are determined on a State basis, so search for Texas. Here are a few links to get started:

Natural Gas Prices: https://www.eia.gov/dnav/ng/NG_PRI_SUM_DCU_STX_M.htm (Links to an external site.)
Links to an external site.

Texas Industrial (historical trend): https://www.eia.gov/dnav/ng/hist/n3035tx3m.htm.Links to an external site.

Factors (explanation): https://www.eia.gov/energyexplained/index.cfm?page=natural_gas_factors_affecting_prices.

1. Your assumptions for water, wastewater, electricity, natural gas, lifecycle, and maintenance. Briefly explain how you came to these assumptions including your sources for your data.
2. Your escalation rates for water, wastewater, electricity, natural gas, lifecycle, and maintenance. Briefly explain your calculations, you can also submit a spreadsheet if you'd like.
3. Based on the outline Professor provided, please write what sections you feel most comfortable writing and contributing to as well as any additional roles you feel we will need (editor role, spreadsheet master, etc).