The course project will require students to complete a thorough financial analysis of an assigned publicly traded corporation. The project deliverable will be a structured Word document that included embedded Excel spreadsheets

During Week 1 students will be given a publicly traded company to research. Project requirements must include the following analysis:
i. One page description of the corporation, its products and market.
ii. Overall trend assessment of the company’s balance sheet, income statement, and state of cash flows for the last three years.
iii. Selected ratio ad trend analysis. Ratios must include liquidity, asset management, solvency, profitability, and market value ratios. A three year ratio analysis is the minimum expectation.
iv. Analysis of the company’s stock price and EPS trends for at last three years. Analysis must include comparisons to key market competitors.
v. Evaluation of the firm’s Beta in relation to a specified market index (e.g. S&P 500, Nasdaq 100, Dow 30)
vi. Assessment of the firm’s capital structure including any significant change in the firm’s capital structure over the last three to five years.
vii. Calculate the WACC (weighted average cost of capital) based upon the most recent balance sheet data.
viii. Assessment of the firm’s cash flow and determination of the firm’s free cash flow over the last three years.
ix. Closing summary of the firm’s financial health in relation to the overall economy and within ins industry.

i. Financial analysis Word file is to be a MAXIMUM 9 pages in length. This does not include a cover page and supporting references and appendices.
ii. Paper Format: APA required
iii. Supporting financial data prepared using Excel and embedded into the Word file
iv. Student may include additional reference material such as financial statement.
v. Students are not to copy and paste financial statement or any other material directly from the web into their analysis (Word) file.
vi. Reference page include all references cited. APA format for references.

Grading Criteria Maximum Points
Description of the firm’s market, products and financial highlights. (1 page maximum) 5
Financial statement assessment (1 page maximum). 10
Ratio and trend analysis prepared with supporting analysis (3 page maximum) 30
Stock Price and EPS analysis ( 1 page maximum) 10
Capital Structure analysis and calculated WACC (1 page maximum) 15
Cash Flow analysis (1 page maximum) 10
Conclusion. summary of financial condition of the firm 5
Excel documents concise, clear, supports narrative and requirements 5
Perfect spelling, punctuation, grammar, APA, concise business style writing 10
Total 100

the paper should show three years of current/ Quick & cash ratios
1 Leverage raion and 1 Profitability ratio for three years