In previous report Lipitor's expiration: how much will it impact Pfizer's revenue and earnings?, we discussed that Pfizer's (NYSE:PFE) declining drug sales for key products (e.g. Lipitor) would impact its revenues for 2012. We also discussed how the newly approved drugs would eventually contribute to future revenue growth (Could Tofacitinib Save Pfizer?). In this section, we provide our forecast for Pfizer's financial projection and estimated earnings from 2012 to 2016 (see Table 1, Income Statement and Earnings Projection). Using our projected earnings and free cash flow numbers, we derive an estimated fair value for PFE around $28.
Section 3: Financial projection and stock valuation
The 2011 financial data that we utilized for our analysis was provided by the company in its 2011 annual report (PFE 2011 annual financial review). The data for 2012 was mostly based on our own estimates, except for several items (e.g. Lipitor sales, company 2012 guidance) which the company has provided updated information, disclosed in its Q2 2012 report or via news releases (PFE Q22012 earnings report).
Sales and Revenues
Pfizer generated $67.4B sales in 2011. However, Lipitor's patent expiration in 2011 and lost exclusivity of other drugs including Xalatan and Geodon in 2012 will have a significant negative impact on Pfizer's revenues going forward. Although several drugs, including Prevnar and Sutent, have increased sales, they are insufficient to offset the lost revenues from Lipitor. Nor will the recently approved Inlyta and Xalkori make significant contribution to the top line until after 2013: their sales in 2012 are marginal.
Our financial projections estimate that PFE will have a significant reduction in revenue in 2012 compared to 2011. Its 2012 revenues are estimated to be $61.3B, down from $67.4B in 2011. It revenue growth will take until 2015 to restore to its 2011 sales levels of $67B. Its estimated EPS in 2012 is $1.26 compared to $1.27 in 2011.
Based on our revenue projections, PFE's revenue compound annual growth rate (OTCPK:CAGR) is about 3.5%. We will use this growth rate in the stock valuation below.
Expenses and tax
PFE's cost of goods sold (COGS) and selling and general administration (SGA) expenses are about 22% and 29% of net sales, respectively. We used these percentages to derive estimated COGS and SGA expenses.
Pfizer's other expenses include research and development expenses, depreciation and amortization, and restructuring and acquisition related charges. In its 2012 Q2 earnings report, Pfizer expected to incur $800M in U.S. healthcare legislationrelated expenses. We estimate that R&D and amortization is about $15B. Total amount is estimated to be an average of $16B for this category for the next 5 years.
PFE's most recent effective tax rate is 29%.
Interest income, debt, and interest expense
Interest expenses were derived from our projected debt and interest schedules. Overall, PFE's long term debt balance will range from $30B to $35B, while short term debts are expected to be $5B. The average interest rate for these debts is approximately 4.8%.
Overall, PFE has a strong balance sheet. Its total debt ratios are 21% and 19 % in 2010 and 2011, respectively. Over the next five years, PFE's total debt should maintain its 2022% range, unless the company issues new debt for major mergers or acquisitions.
Net income and EPS
Our income statement projects earnings from 2012 to 2016 at $9.4B, $10.0B, $10.8B, $11.6B, and $12.5B respectively (See Table 1, Income Statement and Earnings Projection). With 7,500 million shares currently outstanding and assuming PFE continues to buy back $5B in shares per year, the earnings per share (EPS) will be $1.26 (2012), $1.38 (2013), $1.52 (2014), $1.68 (2015), and $1.87 (2016) (see Table 1).
In its Q2 2012 report, the company provided its earnings guidance for 2012 at $1.23  $1.38 per share, or adjusted earnings per share of $2.14$2.24 (PFE Q22012 earnings report). Its revenue guidance for 2012 is $5860B. Our revenue and earnings projections are in line with the company's guidance.
Cash flows from operations (NASDAQ:CFO)
Pfizer's cash flow from operations were $16.6B (2009), $11.4B (2010), and $20.2B (2011). Our projected CFOs from 2012 to 2016 are $21B, $14.9B, $15.3B, $16.2B, and $17.2B, respectively. Capital expenditures were $1.5B to $1.8B, representing an average of 11% of CFO. We will use these numbers to calculate free cash flow for the purposes of stock valuation (see below).
Dividends and stock repurchases
PFE increased its quarterly dividend 10%, from $0.20 to $0.22 in Q12012, and the dividend growth rate is assumed to be 7% throughout our projected period. Pfizer will pay out a $6.8B dividend in 2012. PFE also issued a stock repurchase program in 2012, and expects to buy back $5 billion of the company's common stock in 2012 and an additional $5B in 2013. However, based on its operating cash flow of $14B15B, it will be a stretch for Pfizer to continue its 10% dividend increase and share repurchase program. We suspect that Pfizer will maintain the dividend increase, but may need to scale back its share repurchase program.
Summary of financial ratios and growth rates
Based on its previous 3year averages, PFE's gross profit margin, earningsbeforetax (EBT) margin, and net profit margin are 78%, 48%, and 15% respectively. Its average return on equity (ROE), return on assets (ROA), and return on invested capital (ROIC) are 11.6%, 5.5%, and 25%, respectively. Overall, these ratios suggest that while Pfizer has great operating efficiencies, its profitability based on ROA and ROE is only average.
PFE's debt is about 20% of its capital structure, with an interest coverage ratio of 17x, suggesting that the company is financially sound.
The company had cash, cash equivalents, and shortterm investments of $26.7B in 2011. Our projections indicate that the cash/investment balance will increase from $31B to $40B between 2012 and 2016.
PFE 

Gross profit margin 
77.83% 
Operating profit margin 
48.75% 
EBIT margin 
48.75% 
EBITDA margin 
58.75% 
EBT (pretax) margin 
20.65% 
Net profit margin 
15.40% 
Return on equity (ROE) 
11.60% 
Return on assets (ROA) 
5.12% 
Return on invested capital 
25.75% 
Overall Valuation
We used three models to derive an intrinsic value for PFE's stock.
(I) Using different P/E multiples, we estimated the stock prices below. With a P/E of 15, the stock's target price is $20 based on 2013 earnings. Pfizer also provided adjusted earnings in which noncash charges were added back to its reported earnings. If we added back onetime charges including Acquisitionrelated costs and Loss (income) from operation, estimated to be ~$4B net of tax, then the adjusted EPS for 2013 is about ~$1.92. With a P/E of 15, the stock's target price is $28.8.
PFE 
2012 
2013 
2014 
2015 
2016 
Earnings 
$1.26 
$1.38 
$1.52 
$1.68 
$1.87 
P/E multiples 

13 
$16.37 
$17.88 
$19.75 
$21.90 
$24.27 
14 
$17.62 
$19.25 
$21.27 
$23.59 
$26.13 
15 
$18.88 
$20.63 
$22.79 
$25.27 
$28.00 
16 
$20.14 
$22.00 
$24.30 
$26.96 
$29.87 
(II) Dividend Discount Model
Pfizer's dividend per share for 2012 is $0.91. If we assume a dividend growth rate of 7% per year, we can derive stock values using the dividend discount model with varying required rates of return (R). At 10% rate of return, its current value is $30.
PFE 
DDM valuation 

2012 
2013 
2014 
2015 
2016 

Dividend 
$0.91 
$1.01 
$1.11 
$1.22 
$1.34 
r= 

9.5% 
$36.57 
$40.20 
$44.23 
$48.70 
$53.66 
10.0% 
$30.48 
$33.50 
$36.86 
$40.58 
$44.72 
10.5% 
$26.12 
$28.72 
$31.59 
$34.78 
$38.33 
(III) Free Cash Flow (FCF) Discount Model
The FCF discount model utilizes the free cash flows derived from the projected CFO from 2012 to 2016: $21B, $14.9B, $15.3B, $16.2B, and $17.2B. We assumed that capital expenditures are about 11% of CFO. Therefore, the equity values derived from the FCF are shown in the table. PFE's intrinsic value is ~$28, based on a revenue growth rate of 3.5%.
PFE 
FCF valuation 

r= 
g=3.5% 
g=5% 
9.5% 
$30.28 
$34.54 
10.0% 
$27.99 
$31.16 
10.5% 
$26.03 
$28.39 
In summary, the P/E multiple method suggests a price target of about $20 (based on estimated 2013 reported) or $28.8 (based on adjusted earnings), with a 15x multiple. The intrinsic values derived from both the dividend discount and free cash flow models are $30 and $28, respectively. At the current price level of $2526, PFE stock is trading close to its intrinsic value.
Disclosure: I have no positions in any stocks mentioned, and no plans to initiate any positions within the next 72 hours. I wrote this article myself, and it expresses my own opinions. I am not receiving compensation for it (other than from Seeking Alpha). I have no business relationship with any company whose stock is mentioned in this article.