Your supervisor needs some help performing financial analysis concerning two companies-Ford (F) and Microsoft (MSFT). She...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Your supervisor needs some help performing financial analysis concerning two companies-Ford (F) and Microsoft (MSFT). She asked you to: 1. Download each company's annual income statements, balance sheets and cash flow statements for the last four fiscal years. Your supervisor suggested you get the financial statements on MarketWatch (www.morningstar.com). Enter each company's stock symbol and then go to Financials. Export the statements to Excel by clicking the export button. 2. Find historical stock prices for each firm for the dates of each financial statement. Your supervisor recommended you get the historical stock prices for each firm on Yahoo! Finance (www.finance.yahoo.com). Enter the stock symbol, click "Historical Prices" in the left column, and enter the proper date range to cover the last day of the month corresponding to the date of each financial statement. Use the closing stock prices (not the adjusted close prices). To calculate the firm's market capitalization (or market value of equity) at each date needed below, multiply the number of shares outstanding by the firm's historical stock price. To get the number of shares outstanding (see "Basic" on the income statement under "Weighted Average Shares Outstanding") by the firm's historical stock price also on MarketWatch (www.morningstar.com). 3. For each of the four years of statements, compute the following ratios for each firm: Operating Margin equals Operating Income divided by Sales. Net Profit Margin equals Net Income divided by Sales. Return on Equity equals Net Income divided by Book Value of Equity. Current Ratio equals Current Assets divided by Current Liabilities. Book Debt-to-Equity Ratio equals Total Debt divided by Total Equity. Interest Coverage Ratio equals EBIT divided by Interest Expense. Price-Earnings (P/E) Ratio equals Market Capitalization divided by Net Income. Another way of calculating the P/E Ratio is by dividing the Share Price by Earnings per share (EPS). Note: for EPS, use Diluted EPS Total. Market-to-Book Ratio equals Market Value of Equity divided by the Book Value of Equity. Enterprise Value to EBITDA equals Enterprise Value divided by Earnings Before Interest, Taxes, Depreciation and Amortization. Where EBITDA equals EBIT (Earnings Before Interest and Taxes)+ Depreciation and Amortization. While Enterprise Value = Market Capitalization + Debt-Cash. For Debt, include Long-Term Debt and Short-Term Debt. For Cash, include Marketable Securities. 4. Your supervisor told you she must conduct a comparative analysis using your calculated values. Thus, she asked you to obtain industry averages for each firm from Reuters.com (www.cnbc.com). Search for the stock symbol, click the "Peers" tab, then the "Key Measures" tab. (She told you to ignore the company's column as your calculations will differ.) You wanted to impress her for future employment or letters of recommendation, so you told her you wanted to give the comparative analysis a shot to learn more about it. So, she asked you to: Compare each firm's ratios for the most recent year to the available industry ratios (automobile manufacturers and systems software). Analyze each firm's performance versus the industry and comment on trends in each firm's performance. Identify any strengths or weaknesses you find in each firm. Examine the Market-to-Book ratios you calculated for each firm. Which of the two firms can be considered "growth firms," and which can be considered "value firms"? Compare the valuation ratios across the two firms. How do you interpret the difference between them? Consider the enterprise value of each firm for each of the four years. How have the values of each firm changed over time? Your supervisor needs some help performing financial analysis concerning two companies-Ford (F) and Microsoft (MSFT). She asked you to: 1. Download each company's annual income statements, balance sheets and cash flow statements for the last four fiscal years. Your supervisor suggested you get the financial statements on MarketWatch (www.morningstar.com). Enter each company's stock symbol and then go to Financials. Export the statements to Excel by clicking the export button. 2. Find historical stock prices for each firm for the dates of each financial statement. Your supervisor recommended you get the historical stock prices for each firm on Yahoo! Finance (www.finance.yahoo.com). Enter the stock symbol, click "Historical Prices" in the left column, and enter the proper date range to cover the last day of the month corresponding to the date of each financial statement. Use the closing stock prices (not the adjusted close prices). To calculate the firm's market capitalization (or market value of equity) at each date needed below, multiply the number of shares outstanding by the firm's historical stock price. To get the number of shares outstanding (see "Basic" on the income statement under "Weighted Average Shares Outstanding") by the firm's historical stock price also on MarketWatch (www.morningstar.com). 3. For each of the four years of statements, compute the following ratios for each firm: Operating Margin equals Operating Income divided by Sales. Net Profit Margin equals Net Income divided by Sales. Return on Equity equals Net Income divided by Book Value of Equity. Current Ratio equals Current Assets divided by Current Liabilities. Book Debt-to-Equity Ratio equals Total Debt divided by Total Equity. Interest Coverage Ratio equals EBIT divided by Interest Expense. Price-Earnings (P/E) Ratio equals Market Capitalization divided by Net Income. Another way of calculating the P/E Ratio is by dividing the Share Price by Earnings per share (EPS). Note: for EPS, use Diluted EPS Total. Market-to-Book Ratio equals Market Value of Equity divided by the Book Value of Equity. Enterprise Value to EBITDA equals Enterprise Value divided by Earnings Before Interest, Taxes, Depreciation and Amortization. Where EBITDA equals EBIT (Earnings Before Interest and Taxes)+ Depreciation and Amortization. While Enterprise Value = Market Capitalization + Debt-Cash. For Debt, include Long-Term Debt and Short-Term Debt. For Cash, include Marketable Securities. 4. Your supervisor told you she must conduct a comparative analysis using your calculated values. Thus, she asked you to obtain industry averages for each firm from Reuters.com (www.cnbc.com). Search for the stock symbol, click the "Peers" tab, then the "Key Measures" tab. (She told you to ignore the company's column as your calculations will differ.) You wanted to impress her for future employment or letters of recommendation, so you told her you wanted to give the comparative analysis a shot to learn more about it. So, she asked you to: Compare each firm's ratios for the most recent year to the available industry ratios (automobile manufacturers and systems software). Analyze each firm's performance versus the industry and comment on trends in each firm's performance. Identify any strengths or weaknesses you find in each firm. Examine the Market-to-Book ratios you calculated for each firm. Which of the two firms can be considered "growth firms," and which can be considered "value firms"? Compare the valuation ratios across the two firms. How do you interpret the difference between them? Consider the enterprise value of each firm for each of the four years. How have the values of each firm changed over time?
Expert Answer:
Related Book For
Fundamentals Of Corporate Finance
ISBN: 9780137852581
6th Edition
Authors: Jonathan Berk, Peter DeMarzo, Jarrad Harford
Posted Date:
Students also viewed these finance questions
-
The manufacturers of Cortez automotive oil wish to estimate the mean number of miles that motorist drive between oil changes. A random sample of 54 motorists has a mean of 5900 miles driven between...
-
This is your second interview with a prestigious brokerage firm for a job as an equity analyst. You survived the morning interviews with the department manager and the Vice President of Equity....
-
This is your second interview with a prestigious brokerage firm for a job as an equity analyst. You survived the morning interviews with the department manager and the Vice President of Equity....
-
Use PrecisionTree to create and solve the influence diagram that corresponds to the decision tree in Figure 4.44. A1 S8 SO A2 $4 0.45 $10 S0
-
After viewing a slide show on endangered species, second and fifth graders in Lizzie and Joey's school were asked to remember as many animals as they could. Explain why fifth graders recalled much...
-
What is the likely source rock of petroleum and natural gas?
-
Briefly describe data analytics.
-
The following information is available for Reinsch Corporation for the year ended December 31, 2014: cost of goods sold $205,000, sales revenue $350,000, other revenues and gains $50,000 and...
-
Why is it important to continuously manage and control your portfolio? Explain Is it possible that a positive alpha will be associated with inferior performance? Explain.
-
Simplify the given expression. The result will be one of sin x, cos x, tan x, cotx, sec x, or csc x. - cos X+ sec x tan x cos X+ sec x tan x =
-
Florence, age 55, is an attorney who is self-employed. Her assistant, Joy, has worked with her for five years. Florence is establishing a SEP for this year and is willing to make a contribution of 10...
-
In 2010 a major European car manufacturer (the Company) exported 120,000 vehicles to the UK. The cars are transported by RO/RO ships from the continental ports to discharge at two UK ports...
-
Limited partners try to get a better understanding of the distributions for the fund they invested in. Assume that they contributed $200 million in the first year to fund an investment and that the...
-
be a real number and f be 2 with Que (9) =) am Let entire function, such that for all 121 sufficiently 1-Fezs A+B 121 of is 9 LaJ. large we have A, B.S0. Then forove that degree at most for some...
-
12. In a furnace, the inner and outer sides of the brick wall (k = 2.5 W/mK) are maintained at 1100C and 700C respectively as shown in figure. Appris G 1100C Brick wall k = 2.5 W/m.K 700C 200C Heat...
-
. AFN equation Broussard Skateboard's sales are expected to increase by 15% from $7.2 million in 2019 to $8.28 million in 2020. Its assets totaled $3 million at the end of 2019. Broussard is...
-
On October 31 Juanita Ortega, owner of Outback Guide Service, received a bank statement dated October 30. Juanita found the following: 1. The checkbook has a balance of $2,551.34. 2. The bank...
-
Using the data in Your Turn 13.5, how much water would be saved in a month if one-third of a town's population of 15,000 turned the faucet off when brushing their teeth except when rinsing?
-
Using the data in Example 13.5, how much water would be saved in a year if one-sixth of the population of the state of Florida, which is approximately 21.6 million people, turned the faucet off when...
-
Hurd Inc. prepays rent every three months on March 1, June 1, September 1, and December 1. Rent for the three months totals \(\$ 3,600\). On December 31, 2018, Hurd will report Prepaid Rent of: a....
Study smarter with the SolutionInn App