Eco 500 excel assignment two

Your company asked you to evaluate two potential projects. These projects are active for 10 years and have no salvage life. Both have the same upfront costs, but the revenue stream from each of the projects is subject to variation, so risk is involved.            
You are given the following information:            
  Firm’s cost of capital: 10%          
  Each project will require three years of investment before revenues are generated.           
  The following cost distribution is given:          
  Probability of Outcome Year 1 Investment Costs Year 2 Investment Costs Year 3 Investment Costs Expected Annual Revenues in Year 4 Expected Rate of Increase in Annual Revenues     
 Project 1           
  Outcome A 20% $1,000  $2,000  $1,000  500 2%     
  Outcome B 40% $1,000  $2,000  $1,000  650 3%     
  Outcome C 40% $1,000  $2,000  $1,000  850 4%     
 Project 2           
  Outcome A 10% $1,000  $2,000  $1,000  675 2%     
  Outcome B 50% $1,000  $2,000  $1,000  700 2.40%     
  Outcome C 40% $1,000  $2,000  $1,000  725 2.80%     
In a new worksheet in Excel, answer the following:            
1.       What is the expected value of the NPV for each of the projects?            
2.       What is the standard deviation of the NPV for each of the projects?            
3.       What is the coefficient of variation of the NPV for each of the projects?            
4.       Which project has a higher expected return? Which has more risk?            
5.       Which one would you recommend to your company? How does its attitude toward risk affect your answer?            
Problem 12-01            
Consider the two options in the following table, both of which have random outcomes:            
a. Determine the expected value of each option.
b. Determine the variance and standard deviation of each option.
c. Which option is most risky?

Problem 12-05 (Algo)

A risk-neutral consumer is deciding whether to purchase a homogeneous product from one of two firms. One firm produces an unreliable product and the other a reliable product. At the time of the sale, the consumer is unable to distinguish between the two firms’ products. From the consumer’s perspective, there is an equal chance that a given firm’s product is reliable or unreliable. The maximum amount this consumer will pay for an unreliable product is $0, while she will pay $110 for a reliable product.
a. Given this uncertainty, what is the most this consumer will pay to purchase one unit of this product?
b. How much will this consumer be willing to pay for the product if the firm offering the reliable product includes a warranty that will protect the consumer?

Problem 12-18 (Algo)

Pelican Point Financial Group’s clientele consists of two types of investors. The first type of investor makes many transactions in a given year and has a net worth of over $2 million. These investors seek unlimited access to investment consultants and are willing to pay up to $10,000 annually for no-fee-based transactions, or alternatively, $50 per trade. The other type of investor also has a net worth of over $2 million but makes few transactions each year and therefore is willing to pay $85 per trade.

Problem 12-04

You are the manager of a firm that sells a “commodity” in a market that resembles perfect competition, and your cost function is C(Q) = 2Q + 3Q2. Unfortunately, due to production lags, you must make your output decision prior to knowing for certain the price that will prevail in the market. You believe that there is a 70 percent chance the market price will be $200 and a 30 percent chance it will be $600.
a. Calculate the expected market price.
b. What output should you produce in order to maximize expected profits?
c. What are your expected profits?

Problem 12-12

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes before you learn how strong demand is for homes in this large neighborhood. There is a 60 percent chance of low demand and a 40 percent chance of high demand. The corresponding (inverse) demand functions for these two scenarios are P = 300,000 – 400Q and P = 500,000 – 275Q, respectively. Your cost function is C(Q) = 140,000 + 240,000Q.
How many new homes should you build, and what profits can you expect?


Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Get 20% off your first order