PepsiCo Inc (NYSE:PEP) Earnings Model

Latest Update: June 19, 2016​ 
This model needs an update for the last release...Earnings season got away from us! We will make the updates soon. Sign-up for update alerts below.
​Model Tier: Tier 2, Consensus-based model. 
​Model Created by: Ryan Kilgallen. Ryan is a member of our Penn State Modeling Intern Team. Click here to visit Ryan's contributor page.
​Financial Modeling Approach: This model uses revenue growth rates and operating margin by segment to project future earnings.
PEP Consensus-Based Earnings Model.xlsx
File Size: 88 kb
File Type: xlsx
Download File

    Sign-Up For Pepsi Earnings Model Alerts

    Want to get email alerts when we update our Earnings Model? Submit your email address and we will add you to our distribution list.

    Suggest a Change to This Model

Models From Our Community 

Be the first to submit a model for Pepsi, and we will post it here for our community to download. Use the form to the right to submit a model today.

    Become a PEP Contributor

    There are many ways to break down a company's earnings, and an infinite number of assumptions which can go into an earnings model. Our consensus-based earnings models represent templates which our financial modeling community can use to input their own assumptions and estimates. If you disagree with any of the assumptions, we have made let us know by becoming a contributor. It's simple:
    ​Step 1) Download our model from this page.
    Step 2) Change the input assumptions in the blue cells (or change anything else you see fit).
    Step 3) Submit your model using this form with a summary of the changes you made.

    We will include your model here for our community to download. We will also setup a contributor page to showcase your modeling skills and to track your downloads.
    Max file size: 10MB
    Max file size: 20MB
Share on StockTwits