Calculate the Cost of Equity, using the Beta from Yahoo!, then apply Beta to the Equity Risk Premium and add the Risk-Free Rate for the Cost of Equity. 4). Compare your company’s Cost of Equity to its Return on Equity and determine the Spread between them. What does this Spread tell you?

Personal Finance Project

Project Instructions
1). Go to Yahoo! Finance, Mergent or other source to retrieve financial data (Income Statement, Balance Sheet and Statement of Cash Flows) for a company of your choice to analyze.
2). Examine the ratios for your company’s Liquidity, Asset Management, Debt Management and Profitability/Returns.
3). Calculate the Cost of Equity, using the Beta from Yahoo!, then apply Beta to the Equity Risk Premium and add the Risk-Free Rate for the Cost of Equity.
4). Compare your company’s Cost of Equity (from above) to its Return on Equity (from 2 above) and determine the Spread between them. What does this Spread tell you?

In three to five pages, summarize your company’s financial health and comment on whether you think it is adding value through its investments (assets) and financing choices (debt and equity). Use the news articles you researched about your company to give specifics.

Be sure to include pdf’s of the information you retrieved (articles) and the Excel workbook used for your calculations.
Project – Principles – blank.xlsx –
Project – Principles – Starbuck example.xlsx –
Here are the steps to download financial statements from Mergent:
Mergent Steps to download Financial Statements.docx –
Here are the steps to download stock price data from Yahoo! Finance and into your Project.

Steps to download Stock Price information from Yahoo Finance.docx

Here are two parts for video instructions:

Part 1 – https://nv.instructuremedia.com/fetch/QkFoYkIxc0hhUVFoTExjWk1Hd3JCMUhHWW1JPS0tZWNhNGRlYmJhY2YxZjllOWEwYjdlMmY5MGIyMGEyODFjNTM2MjM3Yw.mp4

Part 2 – https://nv.instructuremedia.com/fetch/QkFoYkIxc0hhUVRuRTVZYU1Hd3JCMUhHWW1JPS0tMmU4NTkwOTliZTgxZmJjNzg4ODI4ZTAwNWE1OTk4NTkyM2ZhOWIxOQ.mp4