i need some help with this assignment. the Requirements are on the first page and a need to enter the data in the excel sheet.

ECON3320 Spreadsheet Exercise (100 points) Background: The State of Florida is considering the economic impact of developing a portion of their coastline. They have tw with varying objectives. Project #1 is to develop a marine park with a new beach, set of condominiums, boardw marina. Project #2 is a coastal mining project that will harvest limestone from an area of old coral reefs. The co years ago due to ocean acidification and physical damage from boating and scuba diving. The dead coral reef ar limestone for construction materials, provide for the harvesting of calcium supplements from dead corals, and r coral reefs which are under constant threat from souvenirs hunters looking to make jewelry. The dead coral reef a coastal erosion barrier. Instructions: Use the template on the next sheet. Enter your answers in the shaded green boxes. Put your mouse over them will appear that identifies the answer required. Requirement #1 (80 points) Build a Net-Present Value (NPV) spreadsheet to determine the economic value of both alternatives. For each po spreadsheet should combine the annual estimated costs and benefits for the next TEN years with two potential 10%). Use discrete discounting (not continuous). Req 1A (40 points) Project #1: In Year 0 (this year), the Marine Park will cost $1.250 billion to construct. Each ye the Marine Park will also incur a foregone annual recreation cost of $20 million, and starting in Year 1 through Ye annual recurring cost of $130 million. The project will yield annual benefits in increased tourism revenue of $30 Year 0 and continuing through Year 10. Req 1B (40 points) Project #2: In Year 0, the mining project will cost $3 billion in extraction costs. Also, the proj million each year (starting in Year 0) to abate coastal erosion due to the missing coral reefs. The project will gen revenue in Year 0 only. Requirement #2 (5 points) Conducting a sensitivity analysis with your discount rate, determine the approximate rate (to the thousandths pl you indifferent between the two potential projects. Requirement #3 (5 points) List and describe other costs and benefits not reflected in the above given information that should be included i to describe the ways used to gather this data and quantify it in monetary terms. Requirement #4 (10 points) Describe how your choice of project changed depending upon the two given discount rates (5% or 10%). Explain selecting a discount rate, and how you would justify them to a public official. ECON3320 Cost-Ben Requirement #1A. Sunshine 0 1 125 20 125 130 20 300 300 445.00 445.00 445.00 445.00 423.81 404.55 Costs (millions of $) Construction Recurring Costs Foregone Recreation Benefits (millions of $) Increased tourism revenue Net NPV @ NPV @ 5.00% 10.00% 3881.17 3179.33 Requirement #1B. Sunshine 0 1 300 200 300 200 450 450 950.00 950.00 950.00 950.00 904.76 863.64 Costs (millions of $) Extraction Costs Abate cost of coastal erosion Benefits (millions of $) Revenues from mining Net NPV @ NPV @ Requirement #2. Indifferent Rate (5 points) 5.00% 10.00% 8285.65 6787.34 Requirement #3. (5 points) Requirement #4. (10 points) ECON3320 Cost-Benefit Analysis Template uirement #1A. Sunshine State Marine Park (40 points) 2 3 4 Years 5 125 130 20 125 130 20 125 130 20 125 130 20 125 130 20 125 130 20 125 130 20 300 300 300 300 300 300 300 445.00 403.63 367.77 445.00 384.41 334.34 445.00 366.10 303.94 445.00 348.67 276.31 445.00 332.07 251.19 445.00 316.25 228.36 445.00 301.19 207.60 6 7 8 6 7 8 irement #1B. Sunshine State Coastal Mining (40 points) 2 3 4 Years 5 300 200 300 200 300 200 300 200 300 200 300 200 300 200 450 450 450 450 450 450 450 950.00 861.68 785.12 950.00 820.65 713.75 950.00 781.57 648.86 950.00 744.35 589.88 950.00 708.90 536.25 950.00 675.15 487.50 950.00 643.00 443.18 9 10 125 130 20 125 130 20 300 300 445.00 286.85 188.72 445.00 273.19 171.57 9 10 300 200 300 200 450 450 950.00 612.38 402.89 950.00 583.22 366.27 PV $20.67