Linked here is a PDF copy of my analysis of
Eli Lilly and Co. (LLY) (
alt.1,
alt.2). Below are some highlights from the above linked analysis:
Company Description: Eli Lilly and Company discovers, develops, manufactures and sells prescription drugs that offers a wide range of treatments for neurological disorders, diabetes, cancer, and other conditions. The company also sells animal health products.
Fair Value: I consider four calculations of fair value, see page 2 of the linked PDF for a detailed description:
- Avg. High Yield Price
- 20-Year DCF Price
- Avg. P/E Price
- Graham Number
LLY is trading at a discount to 1.) and 3.) above. If I exclude the high and low valuation, and average the remaining two valuations, LLY is trading at a 9.3% premium. A Star is deducted since LLY is trading at a premium in excess of 5%.
Dividend Analytical Data: In this section I consider five factors, see page 2 of the linked PDF for a detailed description:
- Rolling 4-yr Div. > 15%
- Dividend Growth Rate
- Years of Div. Growth
- 1-Yr. > 5-Yr Growth
- Payout 15% of avg.
LLY earned two Stars in this section for 3.) and 4.) above. It has paid a cash dividend to shareholders every year since 1885 and has increased its quarterly cash dividend payments for 40 consecutive years. The 1-Yr. > 5-Yr Growth metric indicates that dividend growth has been accelerating.
Dividend Income vs. MMA: Why would you assume the equity risk and invest in a dividend stock if you could earn a better return in a much less risky money market account (MMA)? This section compares the earning ability of this stock with a high yield MMA. Two items are considered in this section, see page 2 of the linked PDF for a detailed description:
- NPV MMA Diff.
- Years to >MMA.