Complete the following tasks and write a 4–5 page report on your findings, including the analysis in Questions
2 and 3 below.
- Compute ratios by following the below directions:
Navigate to Morningstar | Empowering Investor Success. In the Quote box at the top of the page, enter each
stock symbol, choose your companies, and click on the Financials tab. You will see underneath the Financials
tab the three financial statements (Income Statement, Balance Sheet, and Cash Flow). An Export button is to
the far right. Download the income statement and balance sheet financial statements for each company.
Next, you will need historical data for each stock. Navigate to Yahoo Finance - Stock Market Live, Quotes,
Business & Finance News, enter each stock symbol, click on Historical Data, and select ending date of the
most recent full reported year (for example, if the income statement ending is December 2019, select
December 30 to 31, 2019). Note the company’s stock closing price for the last day of the financial statement
reporting period you will use for this assignment. To determine each organization’s market capitalization at the
closing date of the most recent annual statements you downloaded from Morningstar, multiply the number of
shares outstanding by the stock price you obtained from Yahoo! Finance. Use the number of shares
outstanding by using Basic under Weighted Average Shares Outstanding on the income statement you
downloaded from Morningstar (remember, the share value will be in millions of shares, so make the adjustment
by adding 0s).
Compute the following ratios for F and MSFT (refer back to Week 1) for the most recent year of financial
statements downloaded from Morningstar:
Price-earnings ratio (for EPS, use diluted EPS total).
Market-to-book ratio (aka price-to-book ratio).
Operating margin.
Net profit margin.
Return on equity.
Current ratio.
Quick ratio.
Debt-to-equity (for debt, use long-term debt).
Obtain industry averages for each company by going to Markets & Finance News | Reuters.com. Click the
magnifying glass search icon, enter each company’s name, click on Companies, select each company, and
then the Financials tab. Scroll down under Valuation Ratios and each ratio you calculated to the industry
(ignore the current company ratios as these are not the same as you calculated).
- Analyze the performance of each firm versus the industry, and comment on what you find in terms of
strengths and weaknesses. - Compare and contrast the ratios for F and MSFT.
What might explain the differences between them?
Would you recommend investors buy, hold, or sell F and MSFT, based on your analysis?
Sample Solution