1-blank_model_template_1.xlsx - By obtaining this model you...

This preview shows page 1 - 2 out of 6 pages.

Gutenberg Research LLC prohibits the redistribution of this document in whole or part without the written permission. © Gutenberg Research LLC 2016. Blue cells = Primary model estimates Purple cells = Company guidance (updated xx/xx/xxxx) Orange cells = Consensus estimates (Updated x/xx/xxxx) Implied P/E 12-month target value #VALUE! Implied DCF 12-month target value #DIV/0! Implied 50/50 average target value #VALUE! Implied target price band #VALUE! Income Statement Mar-15 June-15 Sept-15 Dec-15 Dec-15 Mar-16 June-16 Sept-16 Dec-16 Dec-16 Mar-17 June-17 Sept-17 Dec-17 Dec-17 Mar-18 June-18 Sept-18 Dec-18 Dec-18 Mar-19 June-19 (Dollars in millions, except per share data) 1Q15 2Q15 3Q15 4Q15 2015 1Q16 2Q16 3Q16 4Q16 2016 1Q17 2Q17 3Q17E 4Q17E 2017E 1Q18E 2Q18E 3Q18E 4Q18E 2018E 1Q19E 2Q19E Sales - - <Sales should link to the segment details beginning in row 36> - Cost of sales - - #VALUE! - #VALUE! - - - - - - - Gross Profit - - - - - - - - - - - - #VALUE! - #VALUE! - - - - - - - Operating Expense 1 - - #VALUE! - #VALUE! - - - - - - - Operating Expense 2 - - #VALUE! - #VALUE! - - - - - - - Total operating expenses - - - - - - - - - - - - #VALUE! - #VALUE! - - - - - - - Operating Income - - - - - - - - - - - - #VALUE! - #VALUE! - - - - - - - Interest and dividend income - - - #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Interest expense - - - #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! Other income/(expense) - - #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Total other income/(expense) - - - - - - - - - - - - #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Income before income taxes - - - - - - - - - - - - #VALUE! #DIV/0! #VALUE! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Provisions for income tax - - #VALUE! #DIV/0! #VALUE! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Net income - - - - - - - - - - - - #VALUE! #DIV/0! #VALUE! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Basic shares outstanding #DIV/0! #DIV/0! - - #VALUE! - - - - #DIV/0! - - Diluted shares outstanding #DIV/0! #DIV/0! - - #VALUE! - - - - #DIV/0! - - Basic EPS #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #VALUE! #DIV/0! #VALUE! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Diluted EPS #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #VALUE! #DIV/0! #VALUE! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Dividends per share - - #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Dividend growth rate (YoY) #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Segment & Product Data Mar-15 June-15 Sept-15 Dec-15 Dec-15 Mar-16 June-16 Sept-16 Dec-16 Dec-16 Mar-17 June-17 Sept-17 Dec-17 Dec-17 Mar-18 June-18 Sept-18 Dec-18 Dec-18 Mar-19 June-19 1Q15 2Q15 3Q15 4Q15 2015 1Q16 2Q16 3Q16 4Q16 2016 1Q17 2Q17 3Q17E 4Q17E 2017E 1Q18E 2Q18E 3Q18E 4Q18E 2018E 1Q19E 2Q19E Ratio Analysis Revenue growth rate (year over year) #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #VALUE! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #VALUE! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Revenue growth rate (quarter over quarter) #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #VALUE! #VALUE! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Gross margin percentage (GAAP) #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #VALUE! #DIV/0!

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture