Biogen Valuation Template
Biogen Valuation Template
Biogen Valuation Template
Revenues:
Product, net
Revenues from anti-CD20 therapeutic programs
Other
Total revenues
Cost and expenses:
Cost of sales, excluding amortization and impairment of acquired intangible assets
Research and development
Selling, general and administrative
Amortization and impairment of acquired intangible assets
Collaboration profit (loss) sharing
Loss on divestiture of Hillerød, Denmark manufacturing operations
(Gain) loss on fair value remeasurement of contingent consideration
Restructuring charges
Acquired in-process research and development
Total cost and expenses
Income from operations
Other income (expense), net
Income before income tax expense and equity in loss of investee, net of tax
Income tax expense
Equity in loss of investee, net of tax
Net income
Net income (loss) attributable to noncontrolling interests, net of tax
Net income attributable to Biogen Inc.
Net income per share:
Basic earnings per share attributable to Biogen Inc.
Diluted earnings per share attributable to Biogen Inc.
Weighted-average shares used in calculating:
Basic earnings per share attributable to Biogen Inc.
Diluted earnings per share attributable to Biogen Inc.
Net income attributable to Biogen Inc.
Other comprehensive income:
Unrealized gains (losses) on securities available for sale:
Unrealized gains (losses) recognized during the period, net of tax
Less: reclassification adjustment for (gains) losses included in net income, net of tax
Unrealized gains (losses) on securities available for sale, net of tax
Unrealized gains (losses) on cash flow hedges:
Unrealized gains (losses) recognized during the period, net of tax
Less: reclassification adjustment for (gains) losses included in net income, net of tax
Unrealized gains (losses) on cash flow hedges, net of tax
Gains (losses) on net investment hedges:
Gains (losses) recognized during the period, net of tax
Less: reclassification adjustment for (gains) losses included in net income, net of tax
Gains (losses) on net investment hedges, net of tax
Unrealized gains (losses) on pension benefit obligation, net of tax
Currency translation adjustment
Total other comprehensive income (loss), net of tax
Comprehensive income attributable to Biogen Inc.
Comprehensive income (loss) attributable to noncontrolling interests, net of tax
Comprehensive income
ASSETS
Cash, cash equivalents and marketable securities
Accounts receivable, net
Inventory
Other current assets
Total current assets
Marketable securities
Property, plant and equipment, net
Operating lease assets
Intangible assets, net
Goodwill
Investments and other assets
TOTAL ASSETS
LIABILITIES AND EQUITY
Current portion of notes payable
Other current liabilities
Total current liabilities
Notes payable
Long-term operating lease liabilities
Other long-term liabilities
Equity
TOTAL LIABILITIES AND EQUITY
Net income
Adjustments to reconcile net income to net cash flows from operating activities:
Depreciation, amortization and impairments
Acquired in-process research and development
Share-based compensation
Contingent consideration
Loss on divestiture of Hillerød, Denmark manufacturing operations
Deferred income taxes
Unrealized (gain) loss on strategic investments
Loss on equity method investment
Other
Changes in operating assets and liabilities, net:
Accounts receivable
Due from anti-CD20 therapeutic programs
Inventory
Accrued expenses and other current liabilities
Income tax assets and liabilities
Other changes in operating assets and liabilities, net
Net cash flows provided by operating activities
Cash flows from investing activities:
Proceeds from sales and maturities of marketable securities
Purchases of marketable securities
Contingent consideration paid related to Fumapharm AG acquisition
Acquisition of Nightstar Therapeutics plc, net of cash acquired
Proceeds from divestiture of Hillerød, Denmark manufacturing oper.
Purchases of property, plant and equipment
Acquired in-process research and development
Acquisitions of intangible assets
Proceeds from sales of strategic investments
Other
Net cash flows provided by investing activities
Cash flows from financing activities:
Purchases of treasury stock
Payments related to issuance of stock for share-based compensation arrangements, net
Other
Net cash flows used in financing activities
Net increase (decrease) in cash and cash equivalents
Effect of exchange rate changes on cash and cash equivalents
Cash and cash equivalents, beginning of the period
Cash and cash equivalents, end of the period
TATEMENT OF INCOME (unaudited, in millions, except per share amounts)
1,501.8 1,495.8
3,136.8 3,368.0
4,638.6 4,863.8
4,459.9 4,459.0
403.7 412.7
4,080.1 4,159.7
12,536.9 13,339.1
26,119.2 27,234.3
As of December 31
2019 2018
ASSETS
Current assets:
Cash and cash equivalents 2,913.70 1,224.60
Marketable securities 1,562.20 2,313.40
Accounts receivable, net 1,880.50 1,958.50
Due from anti-CD20 therapeutic programs 590.20 526.90
Inventory 804.20 929.90
Other current assets 631.00 687.60
Total current assets 8,381.80 7,640.90
Marketable securities 1,408.10 1,375.90
Property, plant and equipment, net 3,247.30 3,601.20
Operating lease assets 427.00 0.00
Intangible assets, net 3,527.40 3,120.00
Goodwill 5,757.80 5,706.40
Deferred tax asset 3,232.10 2,153.90
Investments and other assets 1,252.80 1,690.60
Total assets 27,234.30 25,288.90
LIABILITIES AND EQUITY
Current liabilities: 1,495.80 —
Current
Taxes portion of notes payable
payable 71.40 63.50
Accounts payable 530.80 370.50
Accrued expenses and other 2,765.80 2,861.20
Total current liabilities 4,863.80 3,295.20
Notes payable 4,459.00 5,936.50
Deferred tax liability 2,810.80 1,636.20
Long-term operating lease liabilities 412.70 —
Other long-term liabilities 1,348.90 1,389.40
Total liabilities 13,895.20 12,257.30
Commitments and contingencies
Equity:
Biogen Inc. shareholders’ equity
Preferred stock, par value $0.001 per share — —
Common stock, par value $0.0005 per share 0.10 0.10
Additional paid-in capital — —
Accumulated other comprehensive loss -135.20 -240.40
Retained earnings 16,455.40 16,257.00
Treasury stock, at cost; 23.8 million and 23.8 million
shares, respectively
-2,977.10 -2,977.10
Total Biogen Inc. shareholders’ equity 13,343.20 13,039.60
Noncontrolling interests -4.10 -8.00
Total equity 13,339.10 13,031.60
Total liabilities and equity 27,234.30 25,288.90
BIOGEN INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF CASH FLOWS
(In millions)
Another way to calculate the exact present value of debt with more accuracy consists in not approximating the "W.A. Maturity":
Other data value
Risk free rate 0.70%
Marginal tax rate 27%
W.A. Maturity
0.62
2.26
10.87
13.74
Pv of debt
184.94
182.51
180.12
177.75
175.42
173.12 Shares (mln) 174.06
170.85 Current stock price 319.21
168.60 TOTAL mkt value of equity 55,562.97
166.39
164.21
162.05 Mkt value of debt 6,086.20
159.92 PV operating leasing 513.75
157.82 TOTAL mkt value of debt 6,599.95
155.75
3706.74
6086.20
Spread is
0.63%
0.78%
0.98%
1.08%
1.22%
1.56%
2.00%
2.40%
3.51%
4.21%
5.15%
8.20%
8.,64%
11.34%
15.12%
Marginal tax rate 27%
Beta levered 1.57
ERP 5.20%
CRP 0.37%
Risk free rate 0.70%
Cost of equity 9.44%
Market value of equity 55,562.97
After-tax Cost of debt 1%
Market value of debt 6,599.95
WACC 8.54%
To obtain the KE I used the
CAPM’s model, taking into
consideration the CRP value.
Year R&D exp. Accumulated Dep. 31/12/19 Unamortized Portion 31/12/2019 Amortization 31/12/19
% % %
2019 (TTM) 2193.20 10.00% 219.32 90.00% 1973.88 10.00% 219.32
2018 2597.20 20.00% 519.44 80.00% 2077.76 10.00% 259.72
2017 2253.60 30.00% 676.08 70.00% 1577.52 10.00% 225.36
2016 1973.30 40.00% 789.32 60.00% 1183.98 10.00% 197.33
2015 2012.80 50.00% 1006.40 50.00% 1006.40 10.00% 201.28
2014 1893.42 60.00% 1136.05 40.00% 757.37 10.00% 189.34
2013 1444.05 70.00% 1010.84 30.00% 433.22 10.00% 144.41
2012 1334.92 80.00% 1067.94 20.00% 266.98 10.00% 133.49
2011 1219.60 90.00% 1097.64 10.00% 121.96 10.00% 121.96
2010 1248.60 100.00% 1248.60 0.00% 0.00 10.00% 124.86
9399.07 1817.07
Acquired in process,
research &
development - 112.5 120 - -
D&A 680.6 1016.6 1081 682.7 600.4
R&D 2,193.20
Fumapharm AG
acquisition 300 1500 1200 1200 850
Acquisition of Nightstar
Therapeutics 744.4
Purchase of Ionis
Pharmaceuticals, Inc.
stock 462.9
Acquisition
850
1200
1200
1962.9
1044.4
1251.46
Datas taken from the company's Balance Sheet of the last 6 Years
+Capex $ 3,174.10
+ Acquisition 1251.46
-D&A $ 2,453.21
+Ch.WC $ 80.20
Reinvestment Needs $ 2,052.55
Debt/Capital 6.71%
FCFE $ 4,333.59
Net Income $ 6,248.43
Equity Reinvestment Needs $ 1,914.84
Op. income $ 5,647.23 Net income 6,248.43
BV equity 12,536.9 BV equity 12,536.9
BV debt 4,459.90 ROE 50%
Cash 3,860.40 R&D asset 9,399.07
ROC 43% Adj. ROE 28%
R&D asset 9,399.07
Adj. ROC 25%
HIGH-GROWTH PERIOD
Exp Growth 8.7% 8.7% 8.7% 8.7% 8.7%
Year 1 2 3 4 5
Net income 6793.8683874 7386.91922 8031.7386882735 8732.845782 9495.153965
Equity reinv. Rate 31% 31% 31% 31% 31%
FCFE 679356% 738661% 803143% 873254% 949485%
Ke 9% 9.44% 9.44% 9.44% 9.44%
PV FCFE 620776% 567247% 518333% 473638% 432796%
Sum of PV FCFE 26,127.89
TV 129430.71
PV of TV 82456.149467425
Value of Equity 108584.04
Stable-Growth Input
Stable-Growth Rate 0.70%
Beta levered 1.2
Default spread 0.00%
Ke 7.4%
Wacc 6.7%
Stable ROC 6.7%
Stable ROE 7.4%
Reinvestment rate 10.4%
Equity Reinvestment Rate 9.5%
EBIT (1-tax rate) year 6 8793.25
FCFF in year 6 7875.40
Net income year 6 9561.62
FCFFE in year 6 8655.61
Terminal Value (Asset) 131121.46
Terminal Value (Equity) 129430.71
STRATEGY
Value per share < Price, so BUY/HOLD
SAMPLE OF COMPANIES
INDUSTRY COMPANY Beta P/Eps ratio ttmPayout ratio Exp growth rate (5year
New sample of companies added, but nobody of these have a values of P/E ratio