Build a npv spreadsheet to determine economic value

Assignment Help Financial Econometrics
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

Reference no: EM131394010

Questions Cloud

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..

Reviews

Write a Review

 

Financial Econometrics Questions & Answers

  Determine how long will it be until clive run out of money

Clive has a total of $411,016 in his retirement savings and has the funds invested such that he expects to earn an average of 7.10%, compounded monthly, on this money throughout his retirement years.

  Compute the present value of the cash flows at interest rate

Suppose you are going to receive $ 15,000 per year for 9 years at the beginning of each year. Compute the present value of the cash flows if the appropriate interest rate is 11 percent.

  What is probability that at least respondents have boycotted

A survey on British Social Attitudes asked respondents if they had ever boycotted goods for ethical reasons (Statesman, January 28, 2008). The survey found that 21% of the respondents have boycotted goods for ethical reasons.

  Why is relaxation bounding unhelpful in given algorithm

In what way does generation of offspring produce a relaxation of the current restriction?- Why is relaxation bounding, however, unhelpful in this algorithm?

  Determine what is the projects internal rate of return irr

A project that costs $2,200 to install will provide annual cash flows of $720 for each of the next 5 years. Calculate the NPV if the opportunity cost of capital is 10%

  Explain why starting large number of wafers into production

The company uses a process costing system and has always made the simplifying assumption that wafers in production, but not yet finished, are 50 percent complete with respect to conversion costs.

  Graph the relationship between option price and stock price

Use the software to value the option and graph the relationship between the option price and the stock price, the delta and the stock price, the option price and the time to maturity, and the option price and the volatility.

  What are the total state and federal unemployment taxes

Morris Leste, owner of Carlson Company, has three employees who earn $400, $500, and $700 per week. What are the total state and federal unemployment taxes that Morris owes for the first 11 weeks of the year and for week 30

  Define an analog of unit resolution

Generalize the resolution algorithm to obtain a complete inference method for multivalent clauses, and prove completeness. - Define an analog of unit resolution.

  Calculate the process for the forward bond price

Calculate the process for the forward bond price in terms of α, αy, y, and G(y). - The forward bond price should follow a martingale in the world considered. Use this fact to calculate an expression for α.

  Determine what would the account be worth in 35 years

If you deposit $3,500 today into an accoun earning an 11 percent annual rate of return, what would your account be worth in 35 years (assuming no further deposits). In 40 years.

  What is amount of the margin call for maintenance margin

You own 300 shares of stock which dropped drastically in value today down to $13.50 a share. You have a margin loan of $2,880. What is the amount of your margin call if the maintenance margin is 40 percent

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd