DCF Step by Step Template blank.xlsx

DCF Step by Step Template blank.xlsx - Baxter International...

This preview shows page 1 - 5 out of 82 pages.

Baxter International Inc. (NYSE:BAX) > Financials > Key Stats In Millions of the trading currency, except per share items. Currency: Trading Currency Conversion: Today's Spot Rate Order: Latest on Right Units: S&P Capital IQ (Default) Decimals: Capital IQ (Default) Key Financials¹ Currency USD USD USD USD USD USD Total Revenue 9,849.0 10,378.0 11,263.0 12,348.0 12,562.0 12,843.0 Growth Over Prior Year 3.6% 5.4% 8.5% 9.6% 1.7% 2.2% Gross Profit 4,269.0 4,831.0 5,533.0 6,255.0 6,555.0 6,465.0 Margin % 43.3% 46.6% 49.1% 50.7% 52.2% 50.3% EBITDA 2,286.0 2,510.0 2,939.0 3,339.0 3,594.0 3,515.0 Margin % 23.2% 24.2% 26.1% 27.0% 28.6% 27.4% EBIT 1,706.0 1,935.0 2,358.0 2,708.0 2,956.0 2,830.0 Margin % 17.3% 18.6% 20.9% 21.9% 23.5% 22.0% Earnings from Cont. Ops. 958.0 1,398.0 1,721.0 2,025.0 2,215.0 1,427.0 Margin % 9.7% 13.5% 15.3% 16.4% 17.6% 11.1% Net Income 956.0 1,397.0 1,707.0 2,014.0 2,205.0 1,420.0 Margin % 9.7% 13.5% 15.2% 16.3% 17.6% 11.1% Diluted EPS Excl. Extra Items³ 1.52 2.13 2.61 3.16 3.59 2.39 Growth Over Prior Year 145.2% 40.1% 22.5% 21.1% 13.6% (33.4%) ¹All results are taken from the most recently filed statement for each period. When there has been more than one, earlier filings can be viewed on the individual statement ³All forward period figures are consensus mean estimates provided by the brokers and may not be on a comparable basis as financials. †Growth rates for forward periods are calculated against prior period estimates or actual pro forma results as disclosed on the Estimates Consensus page. Current Capitalization (Millions of USD) Currency USD Share Price as of Feb-26-2015 $68.67 Shares Out. 542.6 For the Fiscal Period Ending 12 months Dec-31-2005A 12 months Dec-31-2006A 12 months Dec-31-2007A 12 months Dec-31-2008A 12 months Dec-31-2009A 12 months Dec-31-2010A
Image of page 1

Subscribe to view the full document.

Market Capitalization** 37,259.0 - Cash & Short Term Investments 2,078.0 + Total Debt 9,275.0 + Pref. Equity - + Total Minority Interest 22.0 = Total Enterprise Value (TEV) 44,478.0 Book Value of Common Equity 8,404.0 + Pref. Equity - + Total Minority Interest 22.0 + Total Debt 9,275.0 = Total Capital 17,701.0 Total Liability includes Total Debt, Minority Interest and Pref. Equity. Net Liability includes Total Liability, net of Cash and Short Term Investments. TEV includes Market Cap and Net Liability. Total Capital includes Common Equity and Total Liability. **For companies that have multiple share classes that publicly trade, we are incorporating the different prices to calculate our company level market capitalization. Please click on the value to see the detailed calculation. Prices shown on this page are the close price of the company’s primary stock class. Shares shown on this page are total company as-reported share values.
Image of page 2
Valuation Multiples based on Current Capitalization TEV/Total Revenue 2.9x 2.7x 2.77x 2.67x 2.56x TEV/EBITDA 11.1x 10.3x 11.67x 10.63x 10.00x TEV/EBIT 14.0x 13.4x - - - P/Diluted EPS Before Extra 18.8x 19.3x 16.36x 15.30x 13.91x P/BV 4.4x 4.4x - - - Price/Tang BV 19.0x 16.9x - - - For the Fiscal Period Ending 12 months Dec-31-2013A Press Release 12 months Dec-31-2014A 12 months Dec-31-2015E 12 months Dec-31-2016E 12 months Dec-31-2017E
Image of page 3

Subscribe to view the full document.

USD USD USD USD USD USD USD 13,893.0 14,190.0 15,259.0 16,671.0 16,082.79 16,642.35 17,378.89 8.2% 2.1% 7.5% 9.3% (3.53%) 3.48% 4.43% 4.8% 7,141.0 7,346.0 7,799.0 8,215.0 - - - 51.4% 51.8% 51.1% 49.3% - - - 3,808.0 3,836.0 3,979.0 4,312.0 3,810.36 4,182.61 4,445.84 27.4% 27.0% 26.1% 25.9% 23.69% 25.13% 25.58% 3,138.0 3,124.0 3,156.0 3,316.0 - - - 22.6% 22.0% 20.7% 19.9% - - - 2,256.0 2,326.0 2,012.0 1,946.0 - - - 16.2% 16.4% 13.2% 11.7% - - - 2,224.0 2,326.0 2,012.0 2,497.0 - - - 16.0% 16.4% 13.2% 15.0% - - - 3.88 4.18 3.66 3.56 4.2 4.49 4.94 62.3% 7.7% (12.4%) (2.7%) (14.32%) 6.91% 9.96% t pages.
Image of page 4
Image of page 5
  • Fall '09
  • ?
  • Revenue, Net Income

{[ snackBarMessage ]}

Get FREE access by uploading your study materials

Upload your study materials now and get free access to over 25 million documents.

Upload now for FREE access Or pay now for instant access
Christopher Reinemann
"Before using Course Hero my grade was at 78%. By the end of the semester my grade was at 90%. I could not have done it without all the class material I found."
— Christopher R., University of Rhode Island '15, Course Hero Intern

Ask a question for free

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern