Select a publicly traded U.S. company that has paid a dividend for at least the last three years, and conduct a financial ratio analysis. You will be using this company for other assignments in this course; thus, please spend adequate time locating a company. Please consider reviewing http://finance.yahoo.com to locate a company. The company must have data available for you to conduct a financial ratio analysis. It's important to select a company in an industry that has industry ratio numbers. You cannot select a privately held company.
Calculate all the following ratios for the company for the past three years and compare them to the appropriate industry benchmarks:
Asset Management ratios:
Total assets turnover
Fixed assets turnover
Days sales outstanding
Debt Management ratios:
Total debt to total assets
Return on common equity
Return on total assets
Basic earning power
Profit margin on sales
Market Value ratios:
Complete the following in a Word document covering 3-4 pages:
Create a table that contains the ratios for the various years. Then analyze the information. Look at the trends in the ratios and comment on how they compare to the industry benchmarks. Which ratios are strong? Which ratios need improvement? If you were a stock investor, would you buy the company's common stock? Why or why not? If you were a bond investor, would you buy the company's bonds? Why or why not?© BrainMass Inc. brainmass.com October 25, 2018, 10:01 am ad1c9bdddf
Apple, Inc.: Stock Analysis
Below is a chart of Apple, Inc.'s (NasdaqGS: AAPL) cash dividends for the last 3 decades.
Year Cash Dividends
2014 $ 1.84571
2013 $ 1.68570
2012 $ 0.75714
1995 $ 0.01716
1994 $ 0.01716
1993 $ 0.01716
1992 $ 0.01716
1991 $ 0.01716
1990 $ 0.01608
1989 $ 0.01464
1987 $ 0.00714
Source: Yahoo! Finance
Apple, Inc.'s stock prices:
September 27, 2014 $100.32 (Yahoo! Finance)
September 28, 2013 $67.15 (Yahoo! Finance)
September 29, 2012 $90.63 (Yahoo! Finance)
Based on Yahoo! Finance, Apple, Inc. together with Blackberry, Google, and Hewlett-Packard belongs to the Electronic Equipment industry. Industry data was sourced from Yahoo!'s industry center. Only a few of the industry statistics pertaining to the ratios are available.
Apple, Inc.'s interest income is much larger than the company's interest expense resulting to a positive other income. Also, in computing for the company's EBITDA coverage, since the depreciation and amortization expenses were not reported in the face of the income statement, I used the company's operating income instead of its EBITDA. When computing the company's price/cash flows ratio, the cash flows provided by the company's operating activities was used.
2014 2013 2012 Industry
Current 0.57 0.88 ...
Apple, Inc: Stock price analysis is given.
Calculating P/E ratios and Profit Margin for Dell and Apple. Which is stronger?
Please see file attached.
Using the financial information of http://www.sec.gov/edgar.shtml as of December 31 of each year, calculate the P/E ratios each year for the last four quarters for Dell and Apple. Which company has made the strongest recovery in terms of profit margin and which has had the strongest growth in P/E ratio. Discuss why these results might be very different with reference to corporate finance policy.
Grading Criteria Maximum Points
Correctly located the Q1 and Q2 2004 10-Qs for each company. 15
Correctly located the corresponding stock price. 15
Correctly calculated a P/E ratio for Dell as of July 30 and April 30 versus the ratio for Apple as of June 27 and March 27. 25
Noted items in the company's reports that can be directly linked to higher valuations. 25