Questions
This course is about Understanding Finanical Statement. There are two companies which are competitors(same SIC classifications)....

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

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

  • Calculate the proportion of the class that graduates each year.
  • What kind of control chart should be used in this situation? pChart Justify Why.
  • Compute the 3 sigma control limits

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

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

  1. Calculate GDP for the years 2005 and 2004.You have just calculated nominal GDP.

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

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:

  Year  

  Rate %  

  2001  

  1.6  

  2002  

  2.4  

  2003  

  1.9  

  2004  

  3.3  

  2005  

  3.4  

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

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

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

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

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

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

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