Gutenberg Research
  • Home
  • Models
  • Education
    • Cooperative Education Program >
      • Enroll Today >
        • Program Enrollment (Virtual)
        • Program Enrollment (Bootcamp - Boston)
        • Program Enrollment (Bootcamp - New York)
      • Training Hub (Winter'22-'23) >
        • Meetings >
          • Kick-off Call/Orientation (Winter'22-'23)
          • Meeting 1: Building the Model (Winter'22-'23)
          • Meeting 2: Entering Your Forecast Into The Model (Winter'22-'23)
          • Meeting 3: Target Valuation (Winter'22-'23)
          • Meeting 4: Live Starbucks Release (Winter'22-'23)
          • Meeting 5: Live FOMC Policy Release & ERP Update (Winter'22-'23)
        • Classes >
          • Class 1 - Introduction to Financial Modeling (Winter'22-'23)
          • Class 2 - Building the Income Statement (Winter'22-'23)
          • Class 3 - Balance Sheet and Cash Flow Modeling (Winter'22-'23)
          • Class 4 - Model Calibration & Forecasting (Winter'22-'23)
          • Class 5 - The DCF Inputs: Beta, ERP, CAPM, & WACC (Winter'22-'23)
          • Class 6 - Discounted Cash Flow Valuation (Winter'22-'23)
          • Class 7 - Market Multiple-Based Valuation (Winter'22-'23)
          • Class 8 - How to Use Your Earnings Model (Winter'22-'23)
        • Other Program Links >
          • About the Exam
          • Co-op Program Exam
          • Model Submission (Winter'22-'23)
          • Co-op Bio Form
          • Co-op Q&A (Winter'22-'23)
    • Books >
      • Procrastinator's Guide - SBUX >
        • Templates - SBUX
      • Book Registration - Third Edition >
        • Templates - Third Edition
      • Book Registration - Second Edition >
        • Templates - Second Edition
  • About
    • Contact
    • Email Distribution Sign-up
    • Terms of Use
    • Privacy Policy

Ryan Kilgallen's Contributor Page


Picture
Ryan Kilgallen is a junior Finance major at Penn State in the Smeal College of Business from Rockaway Beach, Queens New York. He currently serves as Vice President of his fraternity and was a starting player for Penn States division 1 mens Rugby team. Ryan is an active member in the Penn State Investment Association and a founding member of the Penn State Energy Marketing Association. In his free time Ryan enjoys playing basketball, surfing, and working out.
​

​Gutenberg Company Assignments: PepsiCo Inc (NYSE:PEP) 
Contributor Type: Intern, Senior Research Associate.
Team: Ryan is a member of the Gutenberg Research team at Penn State University.

Ryan's Models

PepsiCo Inc (NYSE:PEP)
Latest Update: June 19, 2016.
Model Summary: This model uses revenue growth rates and operating margin by segment to project future earnings.
PEP Model 6-19-2016.xlsx
File Size: 88 kb
File Type: xlsx
Download File


Ryan's Articles

Will Global Macro Headwinds Overshadow North American Strength?
PepsiCo Inc (NYSE:PEP) will report second quarter results on Thursday. Investors will be watching for signs of continued momentum from health and wellness products, which drove a 1.5% increase in net sales for the North American Beverage division last quarter. On the first quarter earnings call Chairman and CEO Indra Nooyi highlighted the success of the everyday nutrition line: “The growth of our everyday nutrition products, which accounts for a quarter of our global net revenue, is outpacing the growth of the balance of the portfolio.”

Despite the strong domestic trends, the continued weakness in global macroeconomic conditions, and the impact on currency translation remains a focus for analysts. On Thursday’s earnings call management will likely give some early indications of the expected impact from Britain’s planned exit from the European Union, as the U.K. is PepsiCo’s fifth largest market. Click here to continue reading.
Gutenberg Research is a media and education company. The information presented on our website and within Gutenberg Research models, files, or other content does not represent investment advice. Data and information presented on this website, or on third party websites posted by us, within our models, files, and other content is for demonstration only, and is presented “as is”. Neither Gutenberg Research nor any Gutenberg Research agents or associates are liable for any errors, delays, incompleteness of data presented, or for actions taken based on reliance on any information contained on this website or within Gutenberg Research models or other content. Investors should consult a professional investment adviser prior to making investment decisions. By accessing this site and/or receiving our models or other content you are deemed to have read and agreed to our Terms of Use posted on this website. This website uses Cookies, refer to our Privacy Policy for details. The Gutenberg Research logo is among the registered and unregistered trademarks of Gutenberg Research LLC. © Gutenberg Research LLC 2023. All Rights Reserved.