Cashback Offer (15th - 25th November 2020). Get Flat 10% Cashback credited in your account on a minimum transaction of $80. Post Your Question

Question DetailsNormal
$ 30.00

Using Thomson ONE Business School Edition download ten years of stock price Solution

Question posted by
Online Tutor Profile
request

BACKGROUND FOR PAPER:
Legal Name of Company – Molson Coors Brewing Company
Ticker Symbol – TAP
Fiscal Year End – December 31

Financial Reporting Framework – U.S. GAAP
Opinion on Financials by Auditors – Unqualified for Year Ending December 29, 2012
Brief Description of Company’s Business Activities – Molson Coors Brewing Company is a manufacturer and distributer of beer and other beverage products. The company sells its products under various labels (i.e. Coors, Miller, Molson, Rickard’s, Carling, etc.) and is licensed to brew and distribute under other labels (i.e. Heineken, Amstel, Foster’s, Cobra, etc.).

REQUIRED SOURCES:
1)Thomson ONE Business School Edition- http://tobsefin.swlearning.com/
(In addition you may also use http://moneycentral.msn.com or http://finance.yahoo.com/
These sites have lots of industry ratios available.) A PASSCODE AND USERNAME WILL BE NEEDED TO ACCESS THE THOMSON ONE SITE. I WILL PROVIDE THIS INFORMATION ONCE IT IS PROVIDED TO ME ASAP.

2)Value Line Investment Survey. Use both the company and industry pages. If you don’t know how to use this service, visit:
http://www.valueline.com/Tools/How_To_Use_Value_Line_Pages.aspx.

3)As far as where to find the financial statements, they can be found on the Molson-coors website http://phx.corporate-ir.net/phoenix.zhtml?c=101929&p=irol-IRHome and also from the SEC website: http://www.sec.gov/edgar/searchedgar/companysearch.html



THE ASSIGNMENT:

1.Using Thomson ONE Business School Edition download ten years of stock price and market index information. Use Excel’s “Slope” function to estimate a beta with these data. Next, using Value Line find an estimate of the company’s beta.
a. Try to think of reasons why your beta estimate would be different than that of ValueLine.
b. Explain, what the figure you found (don’t forget to give credit) tells you about the company’s risk. Is the beta positive or negative?
i. If negative, is it smaller or larger than -1.0?
ii. If positive, is it smaller or larger than 1.0?

2.Quality of Earnings: The value of a stock depends among other things on the income that the company generates in future periods. (E.g. P/E ratio, NOPAT in corporate valuation method.) Compare the income for each of the three years presented in the financial statements. Are there any non-recurring items, such as adjustments for changes in accounting methods or estimates, changes in valuation allowances, extraordinary gains/losses or income/losses from discontinuing operations that should be excluded from an estimate of future income or cash flows from this company? Can you develop an estimate of recurring income from operations?

3. Calculate the company’s Free Cash Flow and compare it to the total dividends paid in the most recent year. Explain how and why you calculated NOPAT the way you did. Could the company increase dividends? Why or why not?


a. To do this you must first estimate your company’s tax rate by comparing pretax income to income tax expense and rounding this number. If your company has a loss, you may have to make an assumption regarding carry backs or carry forwards. If you assume a carryback is done, you may want to look at previous years incomes to see, if you have something to carryback to.
 

Available Answer
$ 30.00

[Solved] Using Thomson ONE Business School Edition download ten years of stock price Solution

  • This Solution has been Purchased 3 time
  • Submitted On 04 Dec, 2014 10:10:18
Answer posted by
Online Tutor Profile
solution

This tutorial is rat...

Buy now to view the complete solution
Other Similar Questions
User Profile
Guard...

Using Thomson ONE Business School Edition download ten years of stock price Solution

This tutorial is rated A+ previously,if you have any question than you can contact me.

...

The benefits of buying study notes from CourseMerit

homeworkhelptime
Assurance Of Timely Delivery
We value your patience, and to ensure you always receive your homework help within the promised time, our dedicated team of tutors begins their work as soon as the request arrives.
tutoring
Best Price In The Market
All the services that are available on our page cost only a nominal amount of money. In fact, the prices are lower than the industry standards. You can always expect value for money from us.
tutorsupport
Uninterrupted 24/7 Support
Our customer support wing remains online 24x7 to provide you seamless assistance. Also, when you post a query or a request here, you can expect an immediate response from our side.
closebutton

$ 629.35