This course is about Understanding Finanical Statement.
There are two companies which are competitors(same SIC classifications). The Coca Cola Company will be a publicly-traded U.S. company which reports under GAAP and Coca- Cola European Partners will be a foreign competitor, also publicly-traded, which reports under IFRS. Here is the requirement: briefly describe, in your own words and citing company literature where appropriate, the companies under consideration. Finally “which company would be the better investment?” based upon your ratio analysis.
In: Accounting
A program at SF State is concerned about their graduation rates. Every year they enroll 400 junior-level students, and they’ve been tracking the percent who manage to finish (graduate from) the program in a timely manner. Below are the data for the past 8 years. Express all calculations to 3 significant figures: ie. 12.3% or 0.123 (also 3-decimal spaces).
|
year |
2000 |
2001 |
2002 |
2003 |
2004 |
2005 |
2006 |
2007 |
|
ontime grads |
230 |
215 |
250 |
225 |
245 |
220 |
235 |
205 |
Are we in control, give the control
In: Operations Management
You are Given the Following Information for an OECS country for the years 2005 and 2004:
|
GDP Component (EC$MN) |
2005 |
2004 |
|
Personal consumption |
2949.9 |
2920.4 |
|
Government expenditure |
1098.3 |
933.6 |
|
Investment |
629.7 |
623.4 |
|
Exports of goods and services |
2590.7 |
2538.8 |
|
Imports of goods and services |
2305.2 |
2259.1 |
2.You are told that inflation in 2005 was approximately 2%,what would be your initial estimate of real GDP growth in 2025?Briefly outline the difference between nominal and real GDP.
In: Economics
Please show excel sheets for the following, answers are provided
The CPI-U for Americans 62 years of age and older (some of your professors and some of your authors are interested in this!) present the following annual inflation rates in percent:
|
| a. |
Assuming the index value in year 2000 was 100.0, determine the index for each year from 2001 to 2005 to one place after the decimal. 101.6, 104.0, 106.0, 109.5, 113.2 |
| b. |
Since inflation, like interest, is compounded from period to period (e.g., year to year), estimate the overall annual inflation rate per year from 2002 to 2006. Suggestion! Do not simply average the rates given above. 2.51744% |
In: Economics
Compare the disclosure requirements of the publicly traded company between the united states and the United Kingdom
In: Finance
USE THE INFORMATION BELOW FOR PROBLEMS 1-4
An analyst wishes to estimate the share price for Ashley Corporation. The following information
is made available:
Estimated profit margin = 15%
Total asset turnover = 2
Financial leverage = 1.2
Estimated dividend payout ratio = 75%
Required rate of return = 14%
Estimated EPS = $2.50
1. Calculate the firm's ROE.
2. Calculate the firm's sustainable growth rate.
3. Calculate the firm’s P/E multiple.
4. Calculate the firm’s estimated share price.
USE THE INFORMATION BELOW FOR PROBLEMS 5-8
At the end of the year 2004 the Office Equipment Industry had free cash flow to equity (FCFE)
of $2.50 per share. The following annual growth rates in FCFE are projected:
Year
Growth Rate
2005
10%
2006
15%
2007
20%
2008
25%
2009
20%
2010
15%
2011
10%
2012
7%
From year 2013 onward growth in FCFE is expected to remain constant at 5% per year. The
industry has a beta of 0.90 and the current industry price is $105. Currently the yield on 10-year
Treasury notes is 5% and the equity risk premium is 4%
5. Calculate the required rate of return on equity. (Hint: derived from CAPM)
6. Calculate the present value now (Year 2004) of FCFE during the period of increasing growth
(that is for years 2005 to 2008).
7. Calculate the present value now (Year 2004) of FCFE during the period of constant growth
(that is for years 2013 onwards).
8. Calculate the intrinsic value of the industry now (Year 2004).
In: Finance
1.)Coffey's Coffee Shop was organized on January 1, 2005 and was authorized to issue 200,000 shares of $2 par value common stock and 100,000 shares of $100, 6% cumulative preferred stock. The preferred stock is convertible to common at the rate of 1 preferred share to 4 shares of common. The conversion rate is restated for all stock dividends and splits. Coffee had the following stock transactions in 2005:
1/1/2005 - Sold 30,000 shares of common stock at $20 per share.
1/1/2005 - Sold 10,000 shares of preferred stock at $100 per share.
4/1/2005 - Issued at 50 percent stock dividend when the market price is $26 per share.
9/1/2005 - Purchased 4,000 treasury shares at $30 per share.
10/1/2005 - Sold 1,000 of the treasury shares at $32 per share.
11/1/2005 - Sold 2,000 of the treasury shares at $25 per share.
12/1/2005 - Issued a 2-1 for stock split.
12/20/2005 - Declared the required dividend to preferred stock holders and a $.25 per share dividend to common stockholders. Dividends are payable on 12/31/2005.
12/31/2005 - Paid dividends declared on 12/20/2005.
Prepare journal entries to record all of the above business events
2.)
(A) Welson Co. is being sued for illness caused to local residents as a result of negligence on the company's part in permitting the local residents to be exposed to highly toxic chemicals from its plant. Welson's lawyer states that it is probable that Welson will lose the suit and be found liable for a judgment costing Welson anywhere from $400,000 to $2,000,000. However, the lawyer states that the most probable cost is $1,200,000. As a result of the above facts, Welson should accrue and what should be disclosed?
(B) On August 1, 2006, the Frost Company purchased property from Anderson that had a fair value of $399,271. Frost gave Anderson a $500,000 noninterest-bearing note payable in five equal annual installments of $100,000 with the first payment due July 31, 2007. What is the amount of interest expense that should be recognized by Frost in 2007, using the effective interest method?
(C) Pryor Corporation issued a 2-for-1 stock split of its common stock which had a par value of $10 before and after the split. At what amount should retained earnings be capitalized for the additional shares issued?
(D) On January 2, 2004, a calendar-year corporation sold 8% bonds with a face value of $1,500,000. These bonds mature in five years, and interest is paid semiannually on June 30 and December 31. The bonds were sold for $1,384,000 to yield 10%. Using the effective interest method of computing interest, how much should be charged to interest expense in 2004?
(E) On its December 31, 2002, balance sheet, the Forge Corporation reported the following as investments in marketable equity securities which are classified as available for sale: Investment in marketable equity securities at cost $500,000 Less: valuation allowance 40,000 $460,000 At December 31, 2003, the market valuation of the portfolio was $490,000. What should Forge include in net income for 2003 as a result of the change in the market value of its investments?
(F) On February 10, 2005, after issuance of its financial statements for 2004, Goll Company entered into a financing agreement with Lebo Bank, allowing Goll Company to borrow up to $4,000,000 at any time through 2009. Amounts borrowed under the agreement bear interest at 2% above the bank's prime interest rate and mature two years from the date of loan. Goll Company presently has $1,500,000 of notes payable with First National Bank maturing March 15, 2005. The company intends to borrow $2,500,000 under the agreement with Lebo and liquidate the notes payable to First National. The agreement with Lebo also requires Goll to maintain a working capital level of $6,000,000 and prohibits the payment of dividends on common stock without prior approval by Lebo Bank. From the above information only, the total short-term debt of Goll Company as of the December 31, 2004 balance sheet date is __________________.
In: Accounting
please asnwer all parts of question 5
| Date | Yearmonth | SP500 | WMT | MSFT | MGM | CERN | XOM |
| 12/3/2012 | 201212 | 1426.19 | 65.33 | 25.39 | 11.64 | 38.76 | 82.52 |
| 11/1/2012 | 201211 | 1416.18 | 68.58 | 25.31 | 10.15 | 38.61 | 84.03 |
| 10/1/2012 | 201210 | 1412.16 | 71.43 | 26.91 | 10.31 | 38.1 | 86.38 |
| 9/4/2012 | 201209 | 1440.67 | 70.27 | 28.06 | 10.75 | 38.69 | 86.65 |
| 8/1/2012 | 201208 | 1406.58 | 69.13 | 29.06 | 9.86 | 36.57 | 82.72 |
| 7/2/2012 | 201207 | 1379.32 | 70.49 | 27.61 | 9.52 | 36.96 | 81.76 |
| 6/1/2012 | 201206 | 1362.16 | 66.03 | 28.66 | 11.16 | 41.33 | 80.55 |
| 5/1/2012 | 201205 | 1310.33 | 62.34 | 27.34 | 10.83 | 38.98 | 74.02 |
| 4/2/2012 | 201204 | 1397.91 | 55.42 | 29.8 | 13.42 | 40.56 | 80.72 |
| 3/1/2012 | 201203 | 1408.47 | 57.57 | 30.02 | 13.62 | 38.08 | 81.09 |
| 2/1/2012 | 201202 | 1365.68 | 55.21 | 29.54 | 13.77 | 36.92 | 80.87 |
| 1/3/2012 | 201201 | 1312.41 | 57.34 | 27.3 | 13.05 | 30.44 | 77.86 |
| 12/1/2011 | 201112 | 1257.6 | 55.84 | 24 | 10.43 | 30.62 | 78.81 |
| 11/1/2011 | 201111 | 1246.96 | 54.7 | 23.65 | 10.29 | 30.49 | 74.8 |
| 10/3/2011 | 201110 | 1253.3 | 52.67 | 24.44 | 11.52 | 31.72 | 72.18 |
| 9/1/2011 | 201109 | 1131.42 | 48.2 | 22.84 | 9.29 | 34.26 | 67.13 |
| 8/1/2011 | 201108 | 1218.89 | 49.39 | 24.41 | 11.07 | 32.98 | 68.42 |
| 7/1/2011 | 201107 | 1292.28 | 48.6 | 24.99 | 15.11 | 33.24 | 73.27 |
| 6/1/2011 | 201106 | 1320.64 | 48.99 | 23.71 | 13.21 | 30.56 | 74.73 |
| 5/2/2011 | 201105 | 1345.2 | 50.91 | 22.81 | 15.07 | 30.02 | 76.65 |
| 4/1/2011 | 201104 | 1363.61 | 50.36 | 23.48 | 12.66 | 30.05 | 80.33 |
| 3/1/2011 | 201103 | 1325.83 | 47.67 | 23 | 13.15 | 27.8 | 76.82 |
| 2/1/2011 | 201102 | 1327.22 | 47.28 | 24.08 | 13.94 | 25.11 | 78.1 |
| 1/3/2011 | 201101 | 1286.12 | 51 | 24.97 | 14.83 | 24.71 | 73.28 |
| 12/1/2010 | 201012 | 1257.64 | 49.05 | 25.14 | 14.85 | 23.68 | 66.42 |
| 11/1/2010 | 201011 | 1180.55 | 48.93 | 22.75 | 12.22 | 21.97 | 63.18 |
| 10/1/2010 | 201010 | 1183.26 | 49 | 23.87 | 10.93 | 21.96 | 60.02 |
| 9/1/2010 | 201009 | 1141.2 | 48.41 | 21.92 | 11.28 | 21 | 55.77 |
| 8/2/2010 | 201008 | 1049.33 | 45.35 | 21.01 | 9.01 | 18.21 | 53.35 |
| 7/1/2010 | 201007 | 1101.6 | 46.03 | 22.98 | 10.86 | 19.36 | 53.49 |
| 6/1/2010 | 201006 | 1030.71 | 43.23 | 20.49 | 9.64 | 18.97 | 51.15 |
| 5/3/2010 | 201005 | 1089.41 | 45.47 | 22.97 | 12.46 | 20.93 | 54.18 |
| 4/1/2010 | 201004 | 1186.69 | 47.96 | 27.07 | 15.89 | 21.19 | 60.33 |
| 3/1/2010 | 201003 | 1169.43 | 49.71 | 25.96 | 12 | 21.23 | 59.62 |
| 2/1/2010 | 201002 | 1104.49 | 48.07 | 25.41 | 10.54 | 20.74 | 57.86 |
| 1/4/2010 | 201001 | 1073.87 | 47.5 | 24.86 | 11.06 | 18.92 | 56.98 |
| 12/1/2009 | 200912 | 1115.1 | 47.52 | 26.89 | 9.12 | 20.61 | 60.31 |
| 11/2/2009 | 200911 | 1095.63 | 48.26 | 25.95 | 10.57 | 18.82 | 66.39 |
| 10/1/2009 | 200910 | 1036.19 | 43.95 | 24.36 | 9.27 | 19.01 | 63.02 |
| 9/1/2009 | 200909 | 1057.08 | 43.43 | 22.59 | 12.04 | 18.7 | 60.33 |
| 8/3/2009 | 200908 | 1020.62 | 45 | 21.65 | 8.47 | 15.43 | 60.8 |
| 7/1/2009 | 200907 | 987.48 | 43.88 | 20.54 | 7.23 | 16.27 | 61.52 |
| 6/1/2009 | 200906 | 919.32 | 42.62 | 20.76 | 6.39 | 15.57 | 61.1 |
| 5/1/2009 | 200905 | 919.14 | 43.76 | 18.25 | 7.46 | 14.57 | 60.61 |
| 4/1/2009 | 200904 | 872.81 | 44.1 | 17.58 | 8.38 | 13.45 | 57.92 |
| 3/2/2009 | 200903 | 797.87 | 45.59 | 15.94 | 2.33 | 10.99 | 59.16 |
| 2/2/2009 | 200902 | 735.09 | 42.85 | 14.02 | 3.5 | 9.15 | 58.99 |
| 1/2/2009 | 200901 | 825.88 | 41 | 14.74 | 8 | 8.43 | 66.11 |
| 12/1/2008 | 200812 | 903.25 | 48.78 | 16.76 | 13.76 | 9.61 | 69 |
| 11/3/2008 | 200811 | 896.24 | 48.42 | 17.43 | 11.98 | 8.99 | 69.28 |
| 10/1/2008 | 200810 | 968.75 | 48.35 | 19.12 | 16.46 | 9.31 | 63.7 |
| 9/2/2008 | 200809 | 1166.36 | 51.89 | 22.85 | 28.5 | 11.16 | 66.75 |
| 8/1/2008 | 200808 | 1282.83 | 51.18 | 23.37 | 35.19 | 11.51 | 68.77 |
| 7/1/2008 | 200807 | 1267.38 | 50.59 | 21.94 | 29.02 | 11.16 | 68.77 |
| 6/2/2008 | 200806 | 1280 | 48.5 | 23.46 | 33.89 | 11.3 | 75.36 |
| 5/1/2008 | 200805 | 1400.38 | 49.83 | 24.15 | 49.21 | 11.34 | 75.9 |
| 4/1/2008 | 200804 | 1385.59 | 49.82 | 24.23 | 51.15 | 11.57 | 79.23 |
| 3/3/2008 | 200803 | 1322.7 | 45.27 | 24.12 | 58.77 | 9.32 | 72 |
| 2/1/2008 | 200802 | 1330.63 | 42.41 | 23.11 | 61.59 | 10.86 | 74.07 |
| 1/2/2008 | 200801 | 1378.55 | 43.4 | 27.59 | 72.72 | 13.1 | 72.64 |
| 12/3/2007 | 200712 | 1468.36 | 40.65 | 30.13 | 84.02 | 14.1 | 79.41 |
| 11/1/2007 | 200711 | 1481.14 | 40.78 | 28.44 | 86.5 | 14.94 | 75.57 |
| 10/1/2007 | 200710 | 1549.38 | 38.49 | 31.05 | 91.61 | 14.89 | 77.67 |
| 9/4/2007 | 200709 | 1526.75 | 37.16 | 24.85 | 89.44 | 14.95 | 78.15 |
| 8/1/2007 | 200708 | 1473.99 | 37.15 | 24.24 | 83.97 | 14.26 | 72.39 |
| 7/2/2007 | 200707 | 1455.27 | 38.93 | 24.37 | 73.11 | 13.22 | 71.59 |
| 6/1/2007 | 200706 | 1503.35 | 40.76 | 24.78 | 82.48 | 13.87 | 70.54 |
| 5/1/2007 | 200705 | 1530.62 | 40.32 | 25.8 | 79.53 | 14.2 | 69.94 |
| 4/2/2007 | 200704 | 1482.37 | 40.41 | 25.09 | 67.25 | 13.31 | 66.47 |
| 3/1/2007 | 200703 | 1420.86 | 39.59 | 23.35 | 69.52 | 13.61 | 63.18 |
| 2/1/2007 | 200702 | 1406.82 | 40.54 | 23.61 | 71.06 | 13.03 | 60.02 |
| 1/3/2007 | 200701 | 1438.24 | 40.02 | 25.77 | 69.97 | 11.23 | 61.79 |
| 12/1/2006 | 200612 | 1418.3 | 38.75 | 24.94 | 57.35 | 11.38 | 63.9 |
| 11/1/2006 | 200611 | 1400.63 | 38.54 | 24.52 | 53.77 | 12.01 | 64.05 |
| 10/2/2006 | 200610 | 1377.94 | 41.2 | 23.89 | 43.02 | 12.08 | 59.29 |
| 9/1/2006 | 200609 | 1335.85 | 41.24 | 22.76 | 39.49 | 11.35 | 55.71 |
| 8/1/2006 | 200608 | 1303.82 | 37.39 | 21.39 | 35.68 | 11.52 | 56.18 |
| 7/3/2006 | 200607 | 1276.66 | 37.07 | 19.95 | 35.54 | 10.12 | 55.98 |
| 6/1/2006 | 200606 | 1270.2 | 40.12 | 19.32 | 40.8 | 9.28 | 50.7 |
| 5/1/2006 | 200605 | 1270.09 | 40.36 | 18.78 | 41.46 | 9.49 | 50.33 |
| 4/3/2006 | 200604 | 1310.61 | 37.38 | 19.95 | 44.9 | 9.91 | 51.87 |
| 3/1/2006 | 200603 | 1294.87 | 39.21 | 22.47 | 43.09 | 11.86 | 50.04 |
| 2/1/2006 | 200602 | 1280.66 | 37.51 | 22.19 | 36.97 | 10.41 | 48.82 |
| 1/3/2006 | 200601 | 1280.08 | 38.13 | 23.17 | 37.06 | 11.25 | 51.32 |
| 12/1/2005 | 200512 | 1248.29 | 38.7 | 21.53 | 36.67 | 11.36 | 45.94 |
| 11/1/2005 | 200511 | 1249.48 | 40.04 | 22.79 | 38.11 | 12.05 | 47.46 |
| 10/3/2005 | 200510 | 1207.01 | 39.01 | 21.09 | 37.37 | 10.56 | 45.68 |
| 9/1/2005 | 200509 | 1228.81 | 36.13 | 21.12 | 43.77 | 10.87 | 51.71 |
| 8/1/2005 | 200508 | 1220.33 | 37.07 | 22.47 | 42.26 | 9.85 | 48.74 |
| 7/1/2005 | 200507 | 1234.18 | 40.56 | 20.96 | 45.45 | 9.43 | 47.57 |
| 6/1/2005 | 200506 | 1191.33 | 39.61 | 20.33 | 39.58 | 8.5 | 46.54 |
| 5/2/2005 | 200505 | 1191.5 | 38.82 | 21.11 | 38.09 | 8.17 | 45.51 |
| 4/1/2005 | 200504 | 1156.85 | 38.62 | 20.64 | 34.9 | 7.26 | 45.95 |
| 3/1/2005 | 200503 | 1180.59 | 41.05 | 19.72 | 35.41 | 6.56 | 48.02 |
| 2/1/2005 | 200502 | 1203.6 | 42.16 | 20.52 | 37.08 | 6.51 | 51.01 |
| 1/3/2005 | 200501 | 1181.27 | 42.8 | 21.37 | 35.9 | 6.22 | 41.37 |
| 12/1/2004 | 200412 | 1211.92 | 43.15 | 21.73 | 36.37 | 6.65 | 41.1 |
| 11/1/2004 | 200411 | 1173.82 | 42.42 | 21.8 | 29.15 | 6.59 | 41.09 |
| 10/1/2004 | 200410 | 1130.2 | 43.94 | 20.41 | 26.9 | 5.64 | 39.25 |
| 9/1/2004 | 200409 | 1114.58 | 43.35 | 20.18 | 24.83 | 5.41 | 38.54 |
| 8/2/2004 | 200408 | 1104.24 | 42.92 | 19.92 | 20.67 | 5.48 | 36.76 |
| 7/1/2004 | 200407 | 1101.72 | 43.09 | 20.73 | 22.08 | 5.62 | 36.7 |
| 6/1/2004 | 200406 | 1140.84 | 42.68 | 20.78 | 23.47 | 5.57 | 35.2 |
| 5/3/2004 | 200405 | 1120.68 | 45.31 | 19.08 | 22.2 | 5.35 | 34.28 |
| 4/1/2004 | 200404 | 1107.3 | 46.23 | 19.01 | 22.91 | 5.35 | 33.51 |
| 3/1/2004 | 200403 | 1126.21 | 48.41 | 18.14 | 22.67 | 5.64 | 32.76 |
| 2/2/2004 | 200402 | 1144.94 | 48.2 | 19.3 | 21.77 | 5.59 | 33.21 |
| 1/2/2004 | 200401 | 1131.13 | 43.58 | 20.12 | 20.2 | 4.9 | 31.93 |
| 12/1/2003 | 200312 | 1111.92 | 42.93 | 19.91 | 18.81 | 4.73 | 32.09 |
| 11/3/2003 | 200311 | 1058.2 | 44.95 | 18.7 | 18.74 | 5.58 | 28.33 |
| 10/1/2003 | 200310 | 1050.71 | 47.62 | 19.02 | 17.75 | 5.3 | 28.43 |
| 9/2/2003 | 200309 | 995.97 | 45.04 | 20.11 | 18.27 | 3.86 | 28.45 |
| 8/1/2003 | 200308 | 1008.01 | 47.72 | 19.19 | 18.13 | 4.41 | 29.3 |
| 7/1/2003 | 200307 | 990.31 | 45.09 | 19.11 | 17.15 | 3.96 | 27.47 |
| 6/2/2003 | 200306 | 974.5 | 43.29 | 18.55 | 17.09 | 2.85 | 27.72 |
| 5/1/2003 | 200305 | 963.59 | 42.36 | 17.8 | 14.12 | 2.64 | 28.1 |
| 4/1/2003 | 200304 | 916.92 | 45.35 | 18.5 | 14.21 | 2.5 | 26.98 |
| 3/3/2003 | 200303 | 848.18 | 41.89 | 17.52 | 14.62 | 4.05 | 26.79 |
| 2/3/2003 | 200302 | 841.15 | 38.63 | 17.15 | 12.81 | 4.15 | 26.08 |
| 1/2/2003 | 200301 | 855.7 | 38.42 | 17.11 | 13.1 | 4.61 | 26 |
| 12/2/2002 | 200212 | 879.82 | 40.6 | 18.64 | 16.49 | 3.91 | 26.6 |
| 11/1/2002 | 200211 | 936.31 | 43.26 | 20.8 | 16.91 | 4.11 | 26.49 |
| 10/1/2002 | 200210 | 885.76 | 42.98 | 19.28 | 15.55 | 4.45 | 25.46 |
| 9/3/2002 | 200209 | 815.28 | 39.52 | 15.77 | 18.65 | 4.4 | 24.13 |
| 8/1/2002 | 200208 | 916.07 | 42.87 | 17.7 | 17.75 | 4.67 | 26.81 |
| 7/1/2002 | 200207 | 911.62 | 39.42 | 17.3 | 17.5 | 5.43 | 27.63 |
| 6/3/2002 | 200206 | 989.82 | 44.09 | 19.72 | 16.88 | 5.98 | 30.75 |
| 5/1/2002 | 200205 | 1067.14 | 43.31 | 18.36 | 18.84 | 6.8 | 30.01 |
| 4/1/2002 | 200204 | 1076.92 | 44.72 | 18.84 | 20.08 | 6.64 | 30.01 |
| 3/1/2002 | 200203 | 1147.39 | 49.07 | 21.75 | 18.11 | 5.96 | 32.75 |
| 2/1/2002 | 200202 | 1106.73 | 49.58 | 21.04 | 17.2 | 5.43 | 30.86 |
| 1/2/2002 | 200201 | 1130.2 | 47.96 | 22.97 | 16.28 | 6.05 | 29.01 |
| 12/3/2001 | 200112 | 1148.08 | 46.01 | 23.89 | 14.44 | 6.24 | 29.19 |
| 11/1/2001 | 200111 | 1139.45 | 44.04 | 23.15 | 13.18 | 6.61 | 27.78 |
| 10/1/2001 | 200110 | 1059.78 | 41.04 | 20.97 | 11.15 | 6.72 | 29.13 |
| 9/4/2001 | 200109 | 1040.94 | 39.53 | 18.45 | 11.24 | 6.19 | 29.09 |
| 8/1/2001 | 200108 | 1133.58 | 38.31 | 20.57 | 14.57 | 6.06 | 29.65 |
| 7/2/2001 | 200107 | 1211.23 | 44.57 | 23.87 | 15.45 | 7.04 | 30.67 |
| 6/1/2001 | 200106 | 1224.38 | 38.91 | 26.32 | 14.98 | 5.25 | 32.07 |
| 5/1/2001 | 200105 | 1255.82 | 41.2 | 24.94 | 15.72 | 5.24 | 32.58 |
| 4/2/2001 | 200104 | 1249.46 | 41.19 | 24.43 | 15.03 | 5.63 | 32.36 |
| 3/1/2001 | 200103 | 1160.33 | 40.21 | 19.72 | 12.55 | 4.28 | 29.59 |
| 2/1/2001 | 200102 | 1239.94 | 39.82 | 21.27 | 13.44 | 6.4 | 29.61 |
| 1/2/2001 | 200101 | 1366.01 | 45.16 | 22.02 | 14.53 | 6.04 | 30.58 |
Question 5: Use Data5 Sheet
This sheet reports monthly value of SP500 index and prices of 5 stocks.
REMEMBER to check the timeline order.
Based on the whole data, create a table reporting the average monthly Return and Total Risk for each of the following stocks:
Put both Risk and Return in percentage format (say 12.56%)
|
WMT |
MSFT |
MGM |
CERN |
XOM |
(For Total Risk, you use the Standard Deviation based on a Sample – STDEV.S)
Return=Price(t)/Price(t-1)-1
5a. Report ticker of the stock with the highest average monthly return
5b. Report ticker of the stock with the highest total risk
5c. If you can only invest in 01 stock for only 1 month, which stock and which yearmonth will you choose to maximize your return.
Put in the answer sheet that the ticker (in Cap) and year month continuously, say MGM200103.
In: Finance
A magazine published data on the best small firms in a certain year. These were firms that had been publicly traded for at least a year, have a stock price of at least $5 per share, and have reported annual revenue between $5 million and $1 billion. The table below shows the ages of the corporate CEOs for a random sample of these firms. 47 58 52 62 56 59 74 63 53 50 59 60 60 57 46 55 63 57 47 55 57 43 61 62 49 67 67 55 55 49 Use this sample data to construct a 90% confidence interval for the mean age of CEO's for these top small firms. Use the Student's t-distribution. (Round your answers to two decimal places.)
In: Statistics and Probability
A magazine published data on the best small firms in a certain year. These were firms that had been publicly traded for at least a year, have a stock price of at least $5 per share, and have reported annual revenue between $5 million and $1 billion. The table below shows the ages of the corporate CEOs for a random sample of these firms. 49 57 51 60 57 59 74 63 53 50 59 60 60 57 46 55 63 57 47 55 57 43 61 62 49 67 67 55 55 49 Use this sample data to construct a 90% confidence interval for the mean age of CEO's for these top small firms. Use the Student's t-distribution. (Round your answers to two decimal places.) ,
In: Statistics and Probability