User Account

All Pages

Create a graph with the cumulative distribution functions

Assignment Help Finance Basics
Reference no: EM13844854

a) Calculate the average rates from your samples. Make sure that the average rate is what you expect. Using the average rates of return (not individual samples), what is (are) the best the investment (s)?

b) Use the 5000 sample rates to perform a Monte Carlo Estimate. Below the last sampe of returns for each investment, calculate the mean return using the "average()" function, and select the entire column of sample returns. Based on the expected value of the net profit after 10 years, which investment is the best choice?

c) Create a graph with the Cumulative Distribution Functions (CDFs) of the three investments on a single graph, by following these steps:

a. Copy the 5000 samples of returns from the three investment choices at the same time, select a new worksheet, and "paste-as-values". This should give you three columns with 5000 rows. Make sure if click on one of the cells, it is a number, not a formula.

b. Sort each of the columns from smallest to largest. Sort the columns independently, not at the same time.

c. Create a fourth column for the cumulative probability, or "P". The first row should contain "=1/5000". The remaining rows should contain the formula for "= <cell above me> + 1/5000". This should produce a column of numbers that increase linearly to a value of "1.0".

d. Insert a chart in excel: choose "scatterplot" type, "scatter with straight lines" subtype. Plot each column of sorted returns vs. P, all on the same chart.

e. To make it easier to analyze the graph, use the "Format Axis" dialog for the X-Axis, and make the maximum value "50000".

Question: Are any of the investment choices stochastically dominant? Looking at this graph, can you imagine a reason why you might choose

a different investment than the one with the highest mean return - if so, what is it and why?

d) Go back to the original worksheet with the samples of returns. Create a table of summary statistics for the three investments starting at worksheet row "5008" or anywhere below the last row of samples, and after your calculation of the mean for part a). Calculate each of the following using the indicated excel function. <Range> means select the entire column of 5000 samples, and use the cell range in the formula.

a. P0.05 (5th percentile): "=percentile(<Range>,0.05)"

b. P0.5 (median): "=percentile(<Range>,0.5)"

c. P0.95 (5th percentile): "=percentile(<Range>,0.05)"

d. Number of cases that lose money (i.e., returns are less than the original $10,000):
"countif(<Range>,"<10000")

e. Fraction of cases that lose money (i.e., returns are less than the original $10,000):
Divide the cell above by 5000.

Question: Would any of this information change your recommendation for the best investment from your answer in part a)? If so, what information and why? Explain your reasoning.

e) Create another column that indicates the best investment with "H"=High-risk stock, "L"=low-risk stock, "S"=savings (hint, if your resulting earnings were in cells F4, F5, and F6, respectively, then the formula would be "=IF(AND((F4>F5),(F4>F6)),"H",IF((F5>F6),"L","S"))".

Is the savings account ever the best investment for a particular sample? If so, what is the probability that the savings account is the best choice? Does this change your recommendation for which investment to choose?

Reference no: EM13844854

Questions Cloud

Violations of the false claims act in his private practice : You are the Compliance Officer of a 230-bed teaching hospital. You have just read a newspaper article reporting that a physician on the hospital's medical staff has been charged with violations of the False Claims Act in his private practice. When yo..
Affected by the organizational environment : Managers are affected by the organizational environment, and help to create it. Their role is instrumental in a successful organizational culture. In this week’s class discussion, you will define the manager’s role as it relates to various organizati..
Project development activities-what is the critical path : Hamilton County Parks is planning to develop a new park and recreational area on a recently purchased 100-acre tract. Project development activities include clearing playground and picnic areas, constructing roads, constructing a shelter house, purch..
Identify the personality disorder diagnosis : Describe the character in adequate detail so that the reader knows who you are discussing; provide a sense of the character's disorder. Identify the personality disorder diagnosis that you think is appropriate for this character
Create a graph with the cumulative distribution functions : Create a graph with the Cumulative Distribution Functions (CDFs) of the three investments on a single graph. would any of this information change your recommendation for the best investment from your answer in part a)? If so, what information and ..
Analysis of the symptoms of a member of aforementioned group : Analysis of the symptoms of a member of the aforementioned groups above versus those of schizophrenic patients who suffer from delusions
What would be the budgeted cash disbursements for purchases : The company pays for 40% of its purchases in the month of purchase and 60% in the month following purchase. What would be the budgeted cash disbursements for purchases of inventory in December?
What rights does a fetus have during each month : Write an essay of 1,000-1,500 words in which you answer the following questions: What rights does a fetus have during each month of the prenatal period? Should the development of the child's senses be considered part of the prochoice/prolife debate
What is the maximum authorized router inventory : Lou’s Bakery has established that JIT should be used for chocolate chips due to the high probability of the kitchen heat melting the chips. The average demand is 130 cups of chocolate chips per week. The average setup and processing time is day. How ..

Reviews

Write a Review

 

Finance Basics Questions & Answers

  Exercise an american call before expiration

What would be your cash proceeds if you exercise the option on October 1 (index options are settled by cash)?

  Prepare a bond discount amortization schedule

Travis Corporation sold $2,000,000 9% 20 year bonds on Jan 1, 2006. The bonds were dated Jan. 1, 2006 and pay interest on Jan 1 and July 1. Travis Corporation uses the straight line method to amortize bond premium or discount.

  Techniques that can be used to adjust for these differences

Financial mangers make decisions today that will affect the firm in the future. What are some of the techniques that can be used to adjust for these differences

  Evaluating the quality of a firm financial statement

Discuss the importance of quality in a firm's financial statements and how you would go about evaluating the quality of a firm's financial statement. What do you consider to be the four main pro forma financial statements to financial forecasting,..

  Prepare a multiple step income statement

Which of the following statements is NOT an objective of financial reporting? An increase in inventory balance would be reported in a statement of cash flows using the indirect method

  Determine what order quantity is optimal

Lott Manufacturing Corporation has been ordering parts for its production process in lots of 10,000 units. Each order costs the company $50 to place, and holding costs per unit average $3.

  Why does most interbank currency trading worldwide involve

why does most interbank currency trading worldwide involve the u.s.

  You read in a newspaper that the nominal interest rate is

you read in a newspaper that the nominal interest rate is 12 percent per year in canada and 8 percent per year in the

  How is the break-even point calculated

Willington rings produces class rings that sell for $75.00 ea and cost $35.00 to produce. they havea fixed cost of $50,000. How is the break-even point calculated?

  Writing a letter of advice to a senior finance manager

You are to select an organization and prepare an assignment on how risk management is practiced in that organization.

  Estimate the value of a share of stock

Estimate the value of a share of stock given the following information: a forward PE ration of 12, current (year 0) EPS of $1 and analyst expectation of EPS growth of 10% over the next 2 years.  Need step by step details for solution

  Multilateral and regional financial institutions

How do multilateral and regional financial institutions promote global business? How do global companies protect themselves against foreign exchange risk and other financial risks?

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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