Reference no: EM131394010
Spreadsheet Exercise
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.
Requirement 1: 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).
A - Project 1: In Year 0 (this year), the Marine Park will cost $1.250 billion to construct. Each year (including Year 0), 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.
B - 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 0) 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: 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.
Requirement 3: List and describe other costs and benefits not reflected in the above given information that should be included in the analysis. Be sure to describe the ways used to gather this data and quantify it in monetary terms.
Requirement 4: Describe how your choice of project changed depending upon the two given discount rates (5% or 10%). Explain some criteria for selecting a discount rate, and how you would justify them to a public official.
Attachment:- Spreadsheet Exercise.rar
|
What are george and mary strongest legal arguments explain
: Do George and Mary have a case? What are their strongest legal arguments? Explain. What defense(s), if any, do the school and the restaurant have? Explain.
|
|
Explain how the issue has affected the sport organization
: Select an issue from the list provided in the Module One discussion and one real sport organization that has faced the issue. Explain how the issue has affected the sport organization.
|
|
Develop a customer service training implementation plan
: Develop a customer service training implementation plan and determine the method of training (i.e., presentation, discussion, case study, discovery, role play, simulation, modeling, or on-the-job training).
|
|
Determine the topics that should be covered in the seminar
: COM/295- Imagine you are a new employee in a human resource (HR) department. Your first task is to develop a stress management seminar for the employees. Determine the topics that should be covered in the seminar.
|
|
Build a npv spreadsheet to determine economic value
: ECON3320 Spreadsheet Exercise. 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 ye..
|
|
Explain senior managements role in preparing organization
: Explain senior management's role in preparing the organization for its most recent change. Provide evidence of whether the transition was seamless or problematic from a management perspective.
|
|
Describe the health concerns of the community
: Describe the health concerns of the community. Identify current environmental risk assessment methods which apply to public health issues. Suggest a modifier or new prevention or intervention program based on your research.
|
|
Resolve the given dispute using steps in mediation process
: Resolve this dispute using the Steps in the Mediation Process and the Mediator's guide which follows the role information. Detail what takes place at each step. In the end, describe the outcome for all parties.
|
|
How do state and local health departments interface
: Which federal department in the United States is the government's principal agency for protecting the health of all Americans and for providing essential human services, especially to those who are least able to help themselves? What major service..
|