Group Project Berk DeMarzo Data Case chapter 10 1. Collect price information for each stock from Yahoo! Finance Professor has provided it for us. The specific data of question 2-4 is in the appendix. We only include the functions and simple answers below every question. 2. Return=(P2-P1)/P1 3. mean monthly returns, standard deviations for the monthly returns and annual statistics Ticker | AAPL | ADM | BA | C | CAT | DE | HSY | MOT | PG | SIRI | WMT | YHOO | Mean | 8.39% | 3.70% | 2.68% | -0.26% | 2.87% | 3.40% | 0.43% | 0.48% | 1.25% | 3.34% | 0.69% | 2.22% | SD | 0.1584 | 0.1050 | 0.0697 | 0.0709 | 0.0742 | 0.0867 | 0.0491 | 0.0934 | 0.0455 | 0.1963 | 0.0477 | 0.1299 | Annual Mean | 1.0068 | 0.4444 …show more content…
3.60 | Dec-04 | 19.41 | 8.46 | -2.28 | 1.81 | -8.22 | -6.67 | 5.30 | -8.50 | -2.92 | -13.12 | -0.78 | -6.56 | -1.17 | Jan-05 | 16.67 | -0.09 | 9.15 | -1.85 | 6.66 | 2.40 | 8.10 | -0.47 | -0.27 | -15.86 | -1.51 | -8.35 | 1.22 | Feb-05 | -7.11 | 2.01 | 6.35 | -5.82 | -3.79 | -5.16 | -4.03 | -4.19 | -0.17 | 0.90 | -2.62 | 5.05 | -1.55 | Mar-05 | -13.46 | -26.80 | 1.82 | 5.49 | -3.27 | -6.84 | 5.69 | 2.47 | 2.70 | -15.30 | -5.93 | 1.77 | -4.31 | Apr-05 | 10.26 | 10.81 | 7.80 | 0.30 | 6.89 | 5.77 | 0.81 | 13.29 | 1.85 | 26.26 | 0.50 | 7.83 | 7.70 | May-05 | -7.42 | 7.71 | 3.28 | -1.85 | 1.28 | -0.53 | -3.28 | 5.35 | -4.36 | 7.82 | 2.05 | -6.85 | 0.27 | Jun-05 | 15.87 | 7.31 | 0.02 | -4.98 | 13.64 | 12.29 | 2.84 | 15.98 | 6.01 | 5.25 | 2.39 | -3.78 | 6.07 | Jul-05 | 9.94 | -1.49 | 1.91 | 0.62 | 2.93 | -11.09 | -7.10 | 3.28 | -0.26 | 0.88 | -8.62 | -0.06 | -0.76 | Aug-05 | 14.33 | 9.56 | 1.39 | 4.01 | 5.88 | -5.92 | -4.72 | 0.87 | 7.16 | -4.94 | -2.53 | 1.56 | 2.22 | Sep-05 | 7.42 | -1.17 | -4.87 | 0.56 | -10.09 | -0.85 | 0.94 | 0.57 | -5.36 | -4.74 | 7.96 | 9.25 | -0.03 | Oct-05 | 17.76 | -2.93 | 5.88 | 7.09 | 9.87 | 14.30 | -4.16 | 8.74 | 2.14 | 14.77 | 2.65 | 8.82 | 7.08 | Nov-05 | 6.00 | 4.59 | 3.02 | -0.05 | -0.02 | -1.25 | 1.89 | -6.07 | 1.21 | -6.29 | -3.34 | -2.61 | -0.24 | Dec-05 | 5.04 | 27.73 | -2.76 | -4.01 | 18.01 | 5.37 | -7.33 | 0.51 | 2.82 | -15.37 | -1.46 | -12.25 | 1.36 | Jan-06 | -9.30 | 1.05 | 6.86 | 0.62 | 7.63 | 6.30 | 0.37 |
3. Understanding that HIV is a retrovirus (a virus that uses reverse transcriptase), answer the following questions:
You are the investment banker assigned with the task of setting the IPO price for Boston Beer Company (BBC). Prepare a research report to support your recommendation. As you prepare this report, you may find that you would like to have more field information than what the case offers you. However, the case contains critical information that gives you a reasonable basis to compute its valuation. In addition use the following information for 1995.1 Sales ($ millions) Redhook Pete’s BBC 25.89 59.17 151.31 EPS .75 .25 .40 Book value/share 7.70 4.33 3.00 Price 27.00 24.75 ?
3. Wasserstein, Perella & Co. established a valuation range of $68-$80 per common share for Interco. Show that this valuation range can follow from the assumptions described in the discounted cash flow analysis section of Exhibit 12. As a member of Interco’s board, which assumptions would you have questioned? Why?
2.52 0.63 49.19 3.50 74.31 39.83 69.86 96.97 5.34 1.46 0.65 0.57 5.73 1.47 35.22% 13.06% 7.01% 12.42% 29.41%
31. A new weight-watching company, Weight Reducers International, advertises that those who join will lose, on the average, 10 pounds the first two weeks with a standard deviation of 2.8 pounds. A random sample of 50 people who joined the new weight reduction program revealed the mean loss to be 9 pounds. At the .05 level of significance, can we conclude that those joining Weight Reducers on average will lose less than 10 pounds? Determine the p-value.
1. To begin, assume that it is now January 1, 1993, and that each bond in Table 1 matures on December 31 of the year listed. Further, assumes that each bond has $1,000 par value, each had a 30-year maturity when it was issued, and the bonds currently have a 10 percent required nominal rate or return.
(The Table value for significance at 0.05 level with df 2 and 57 and 2 and 56 are 3.14 and 3.15 respectively)
The thought of alcohol being involved in fatal crashes brings about an emotional response. Recently, there has been a movement based on emotion rather than logic to change a certain drinking and driving law. This involves lowering the Blood Alcohol Content (BAC) from 0.10% to 0.08% nationwide. However, this attention is misdirected. By looking at my personal experiences, statistics, and current laws, it is clear that there is no need for lowering the BAC.
Anyway, according to 2010 numbers, when we check the graph we can see that, the
31. A new weight-watching company, Weight Reducers International, advertises that those who join will lose, on the average, 10 pounds the first two weeks with a standard deviation of 2.8 pounds. A random sample of 50 people who joined the new weight reduction program revealed the mean loss to be 9 pounds. At the .05 level of significance, can we conclude that those joining Weight Reducers on average will lose less than 10 pounds? Determine the p-value.
Data collection has been around for years in one form or another. The implementation of the No Child Left Behind Act stimulated dedicated educators to learn the correlation between data driven decision-making and successful school improvement plans. The legislative goal was to ensure academic success across all socioeconomic frontiers. Districts across the country were steered into driving their instruction with data and teacher collaboration. This has lead to districts that have successfully found the correlation between data driven decision-making and success.
The second example is a bar graph, which show descriptive statistics. It is about Facebook’s Company Valuation from December 2010 till August 2011, skipping the months of February and May horizontally and the valuation in billions on the vertical axis starting from $55 to $90, increasing by multiples of five. The month of December has a value of $60B, following with $66.2 in January, $79.2 and $81.6 for March, April has $76.8, $79.2 and $84 for June, July follows with $84, $84, $81.6, and lastly August has $79.2. They used
Summary statistics, using the observations 2012/01/02 - 2013/12/02 for the variable 'R_i ' (101 valid observations)
then it comes with a lag of 2 months (e.g. figures for quarter Jan-Mar 2008
|0.51 |-0.2 | |130 |123 |123.391 |0.32 |-0.4 | |140 |116 |116.788 |0.67 |-0.7 | |150 |108 |107.812 |0.17 |-1 | |160 |97 |96.656 |0.36 |-1 | |170 |83 |83.799 |0.95 |-1.4 | |180 |69 |70 |1.43 |-1.3 | |190 |55 |56.201 |2.14 |-1.4 | |200 |42 |43.344 |3.1 |-1.4 | |210 |32 |32.188 |0.58 |-1 | |220 |23 |23.212 |0.91 |-0.9 |