1.Financial Analysis Paper on Molson Coors

The paper needs a thorough financial analysis of an assigned publicly traded corporation.The project deliverables will be:

Structured Word Document.

Paper requirements must include the following analysis:

a.Description of the corporation: its products, markets, subsidiaries (if any), risks, public highlights, and financial highlights.

b.Overall trend assessment of the company's balance sheet and income statement for the last three to five years.Including graphs and/or charts.

c.Provide ratios fully calculated using your assigned corporations actual balance sheet and income statement data within formulas in excel.Also provide an analysis discussion of the same ratio trends included in a word document.Ratio categories must include

i.Short Term Solvency aka Liquidity

ii.Long Term Solvency aka Financial Leverage

iii.Asset Management aka Turnover

iv.Profitability

v.Market Value

Select and analyze at least three ratios from each category, 15 ratios minimum.A three-year ratio analysis is the minimum expectation.A five-year analysis receives preferred grading.

d.Trend analysis of the company's stock price, PE ratio, and EPS trends for the last three to five years with comparisons of each to competitors.

e.Evaluation of the firm's posted Beta (do not calculate Beta, it will be posted in financial websites such as money.msn.com online) in relation to competitors.

f.Assessment of the firm's capital structure (D/E Ratio) including any significant changes in the firm's capital structure over the last three to five years (Week 2 Discussion Board).

(Continued on next page)

g.Two excel WACC (weighted average cost of capital) calculations, one using the Cost of Equity from the SML (aka CAPM) Approach and another WACC calculation using the Dividend Growth Model Approach for Cost of Equity.Include a discussion explaining which Approach you prefer for WACC and why (Section 14.2 of the text provides advantages and disadvantages for each approach).Most assigned corporations will not have preferred stock, therefore ignore any preferred stock.All of these variables are defined in Chapter 14.There is an Eastman Chemical WACC calculation example on pages 468 - 471 in the text.

Corporate tax rate

WACC = (E/V)*Re + (P/V)*Rp + (D/V)*Rd * (1-Tc)

% of financing that is equity

% of financing that is debt

Cost of Preferred Stock

% of financing preferred stock

Cost of debt

Cost of equity

h.Assessment of the firm's statement of cash flows and determination of the firm's free cash flow over the last three to five years.

i.Closing summary of the firm's financial health in relation to the overall economy and within its industry. Explain why or why not someone should invest in this firm.Also show current analyst recommendations as a guide with a discussion of supporting facts and financial data.