Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Background: The State of Florida is considering the economic impact of developing a portion of their coastline. They have two potential projects with varying objectives.

image text in transcribed

Background: The State of Florida is considering the economic impact of developing a portion of their coastline. They have two potential projects with varying objectives. Project #1 is to develop a marine park with a new beach, set of condominiums, boardwalk, and a boat marina. Project #2 is a coastal mining project that will harvest limestone from an area of old coral reefs. The coral reefs died many years ago due to ocean acidification and physical damage from boating and scuba diving. The dead coral reef area will yield significant limestone for construction materials, provide for the harvesting of calcium supplements from dead corals, and reduce pressure on live coral reefs which are under constant threat from souvenirs hunters looking to make jewelry. The dead coral reef area is also serving as 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 and a comment box 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 potential project, the spreadsheet should combine the annual estimated costs and benefits for the next TEN years with two potential discount rates (5% & 10%). Use discrete discounting (not continuous). Reg 1A (40 points) Project #1: In Year 0 (this year), the Marine Park will cost $1.250 billion to construct. Each year (including Year O), the Marine Park will also incur a foregone annual recreation cost of $20 million, and starting in Year 1 through Year 10, there is an annual recurring cost of $130 million. The project will yield annual benefits in increased tourism revenue of $300 million starting in Year 0 and continuing through Year 10. Reg 1B (40 points) Project #2: In Year 0, the mining project will cost $3 billion in extraction costs. Also, the project will cost $200 million each year (starting in Year O) to abate coastal erosion due to the missing coral reefs. The project will generate $4.5 billion in revenue in Year 0 only. Requirement #2 (5 points) Conducting a sensitivity analysis with your discount rate, determine the approximate rate (to the thousandths place) that will make you indifferent between the two potential projects. Background: The State of Florida is considering the economic impact of developing a portion of their coastline. They have two potential projects with varying objectives. Project #1 is to develop a marine park with a new beach, set of condominiums, boardwalk, and a boat marina. Project #2 is a coastal mining project that will harvest limestone from an area of old coral reefs. The coral reefs died many years ago due to ocean acidification and physical damage from boating and scuba diving. The dead coral reef area will yield significant limestone for construction materials, provide for the harvesting of calcium supplements from dead corals, and reduce pressure on live coral reefs which are under constant threat from souvenirs hunters looking to make jewelry. The dead coral reef area is also serving as 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 and a comment box 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 potential project, the spreadsheet should combine the annual estimated costs and benefits for the next TEN years with two potential discount rates (5% & 10%). Use discrete discounting (not continuous). Reg 1A (40 points) Project #1: In Year 0 (this year), the Marine Park will cost $1.250 billion to construct. Each year (including Year O), the Marine Park will also incur a foregone annual recreation cost of $20 million, and starting in Year 1 through Year 10, there is an annual recurring cost of $130 million. The project will yield annual benefits in increased tourism revenue of $300 million starting in Year 0 and continuing through Year 10. Reg 1B (40 points) Project #2: In Year 0, the mining project will cost $3 billion in extraction costs. Also, the project will cost $200 million each year (starting in Year O) to abate coastal erosion due to the missing coral reefs. The project will generate $4.5 billion in revenue in Year 0 only. Requirement #2 (5 points) Conducting a sensitivity analysis with your discount rate, determine the approximate rate (to the thousandths place) that will make you indifferent between the two potential projects

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Institutions Management

Authors: Anthony Saunders

1st Edition

0256110565, 9780256110562

More Books

Students also viewed these Finance questions

Question

Decision Making in Groups Leadership in Meetings

Answered: 1 week ago