A company has purchased a lot of beach front property in Miami, Florida but is now worried about the risk of hurricanes from climate change. The company wants to sell the property for the NPV of the future income potential. They 3 scenarios: Scenario #1 - Over the next 5 years (Yr. 1-5), there are no hurricanes and they make $8,000,000 per year. Scenario #2: Over the next 5 years, there are 2 hurricanes that cause minor disruption in their business. They assume those hurricanes occur in years 2 and 4 and for both years, the company makes $1,000,000 below their previous projection. Scenario #3: Over the next 5 years, their property is destroyed by heavy hurricane damage in year 3 eliminating 30% of their profit in years 3-5. If the company wants to make 8% return over the 5 years, how much should they sell their property for today if each scenario is equally likely?

Please show work and calculations on excel