Scribd Logo
Upload

Welcome to Scribd!

  • 160 views

    Income Statement - PEPSICO

    Uploaded by

    Adriana Martinez
    The document provides financial statement information for PepsiCo for the years 2019, 2018, and 2017. It includes income statements which show revenue, costs, expenses, profits, and earnings per share. It also includes balance sheets which break down assets, liabilities, and shareholder equity. The financial statements provide key metrics to understand PepsiCo's financial performance and position over recent years for the purposes of valuation.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Income Statement - PEPSICO

    Uploaded by

    Adriana Martinez
    160 views11 pages
    The document provides financial statement information for PepsiCo for the years 2019, 2018, and 2017. It includes income statements which show revenue, costs, expenses, profits, and earnings per share. It also includes balance sheets which break down assets, liabilities, and shareholder equity. The financial statements provide key metrics to understand PepsiCo's financial performance and position over recent years for the purposes of valuation.

    Original Title

    FINANCE STATEMENT

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides financial statement information for PepsiCo for the years 2019, 2018, and 2017. It includes income statements which show revenue, costs, expenses, profits, and earnings per share. It also includes balance sheets which break down assets, liabilities, and shareholder equity. The financial statements provide key metrics to understand PepsiCo's financial performance and position over recent years for the purposes of valuation.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    160 views11 pages

    Income Statement - PEPSICO

    Uploaded by

    Adriana Martinez
    The document provides financial statement information for PepsiCo for the years 2019, 2018, and 2017. It includes income statements which show revenue, costs, expenses, profits, and earnings per share. It also includes balance sheets which break down assets, liabilities, and shareholder equity. The financial statements provide key metrics to understand PepsiCo's financial performance and position over recent years for the purposes of valuation.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 11

    FINANCIAL STATEMENTS USED IN VALUATION

    Value in Billions

    Income Statement - PEPSICO

    Year 2019 2018


    Total Revenue 67,161 64,661
    Cost of Revenue 30,132 29,381
    Gross Profit 37,029 35,280
    Operating Expenses 56,870 54,551
    Research and Development - -
    SG&A Expenses 26,738 25,170
    Other Operating Income or Expenses - -
    Operating Income 10,291 10,110
    Total Non-Operating Income/Expense - 979 - 921
    Pre- Tax Income 9,312 9,189
    Income Tax 1,959 - 3,370
    Income After Taxes 7,353 12,559
    Corporate Tax 21.04% -36.67%
    Other Income - -
    Income From Continous Operations 7,353 12,559
    Income From Discontinued Operations - -
    Net Income 7,909 12,515
    EBITDA 12,723 12,509
    Interest Expenses 275 1,027
    EBIT 10,291 10,110
    Dividends 800 1,415
    Shares Outstanding 1,407 1,425
    Basic EPS 5.23 8.84
    Earnings per share (EPS) 5.2 8.78

    Dividend per share (DPS) 0.96 0.93


    Return of Equity (ROE) 50.95% 108.36%

    Balance sheet- PEPSICO

    2019 2018
    Current Assets
    Cash and Cash Equivalents 5,509 10,718
    Short-Term Investments 229 272
    Net Receivables 7,822 7,142
    Inventory 3,338 3,128
    Other Current Assets 692 586
    Total Current Assets 17,590 21,846
    Net Property, Plant & Equipment 20,853 17,589
    Property, Plant & Equipment Gross 44,551 40,164
    Buildings 9,314 8,941
    Land & Improvements 113 1,078
    Machinery & Equipment 2,939 27,715
    Construction in Progress 3,169 243
    Accumulated Depreciation 23,698 22,575
    Total Investments and Advances 2,683 2,409
    LT Investment 2,683 2,409
    Long-Term Note Receivable 85 86
    Fixed Assets 31,544 30,633
    Net Goodwill 15,501 14,808
    Net Other Intangibles 16,043 15,825
    Other Assets LT 1,433 721
    Deferred Charges 1,048 428
    Tangible Other Assets 385 293
    Total Assets 78,547 77,648
    ST Debt & Current Portion LT Debt 3,362 4,026
    Short Term Debt 514 73
    Current Portion of Long Term Debt 2,848 3,953
    Accounts Payable 8,013 7,213
    Accounts Payable Growth 11.09% 7.22%
    Other Current Liabilities 9,086 10,899
    Dividends Payable 1,351 1,329
    Accrued Expenses 1,835 1,755
    Miscellaneous Current Liabilities 59 7,815
    Total Current Liabilities 20,461 22,138
    Current Ratio 0.86 0.99
    Quick Ratio 0.70 0.85
    Cash Ratio 0.28 0.50
    Long-Term Debt 30,266 28,295
    Long-Term Debt excl. Capitalized Leases 29,148 28,295
    Non-Convertible Debt 29,148 28,295
    Provision for Risks & Charges 3,767 32

    Deferred Taxes - 268 - 865

    Deferred Taxes - Credit 4,091 3,499


    Deferred Taxes - Debit 4,359 4,364
    Other Liabilities 5,094 5,914
    Other Liabilities (excl. Deferred Income) 5,094 5,914
    Total Liabilities 63,679 63,046
    Total Liabilities / Total Assets 81.07% 81.19%

    Preferred Stock (Carrying Value) - -

    Redeemable Preferred Stock - -

    Common Equity (Total) 14,786 14,518


    Common Stock Par/Carry Value 23 23
    Additional Paid-In Capital/Capital Surplus 3,886 3,953
    Retained Earnings 61,946 59,947
    Cumulative Translation Adjustment/Unrealized
    - 1,129 - 11,918
    For. Exch. Gain

    Unrealized Gain/Loss Marketable Securities - 2

    Other Appropriated Reserves - 301 - 3,203


    Treasury Stock - 36,769 - 34,286

    Common Equity / Total Assets 18.82% 18.70%


    Total Shareholders' Equity 14,786 14,518
    Total Shareholders' Equity / Total Assets 18.82% 18.70%
    Accumulated Minority Interest 82 84
    Total Equity 14,868 14,602
    Liabilities & Shareholders' Equity 78,547 77,648
    Source:

    https://www.nasdaq.com/es/market activity/stocks/
    https://www.macrotrends.net/stocks/charts/PEP/pe
    statement
    https://www.wsj.com/market-data/quotes/PEP/fina
    2017 2016 2015
    63,525 62,799 63,056
    28,796 28,222 28,731
    34,729 34,577 34,325
    53,249 52,995 54,703
    - - -
    24,453 24,773 24,613
    - - -
    10,276 9,804 8,353
    - 674 - 1,251 - 911
    9,602 8,553 7,442
    4,694 2,174 1,941
    4,908 6,379 5,501
    48.89% 25.42% 26.08%
    - - -
    4,908 6,379 5,501
    - - -
    4,857 6,329 5,452
    12,645 12,172 10,769
    1,019 1,003 859
    10,276 9,804 8,353
    1,425 1,439 1,469
    1,438 1,452 1,485
    3.40 4.39 3.71
    3.38 4.36 3.67

    0.81 0.76 0.70


    39.97% 53.27% 37.56%

    2017 2016 2015

    10,610 9,158 9,096


    8,900 6,967 2,913
    7,024 6,694 6,437
    2,947 2,723 2,720
    1,500 1,515 1,825
    30,981 27,057 22,991
    1,724 16,591 16,317
    39,106 36,818 35,747
    8,796 8,306 8,061
    1,148 1,153 1,184
    27,018 25,277 24,764
    2,144 2,082 1,738
    21,866 20,227 1,943
    2,042 195 2,311
    2,042 195 2,311
    59 105 140
    28,582 27,863 27,258
    14,744 1,443 14,177
    13,838 13,433 13,081
    900 563 650
    554 225 259
    346 338 391
    81,756 76,870 72,483
    5,485 6,892 4,071
    1,465 2,491 962
    402 4,401 3,109
    6,727 6,158 5,546
    9.24% 11.03% -
    829 8,085 7,961
    1,161 1,097 1,041
    1,785 1,770 1,759
    5,344 5,218 5,161
    20,502 21,135 17,578
    1.51 1.28 1.31
    1.37 1.15 1.15
    0.95 0.76 0.68
    33,796 30,053 29,213
    33,796 30,053 29,213
    33,796 30,053 29,213
    2,521 3,857 324

    3,242 5,073 4,959

    5,194 7,814 7,775


    1,952 2,741 2,816
    8,762 2,812 2,647
    8,762 2,812 2,647
    70,775 65,671 60,453
    86.57% 85.43% 83.40%

    -156 -151 -145

    -156 -151 -145

    11,045 11,246 12,068


    24 24 24
    3,996 4,091 4,076
    52,839 52,518 50,472

    - 10,277 - 11,386 - 1,108

    -4 64 88

    - 2,776 - 2,597 - 2,327


    - 32,757 - 31,468 - 29,185

    13.51% 14.63% 16.65%


    10,889 11,095 11,923
    13.32% 14.43% 16.45%
    92 104 107
    10,981 11,199 12,030
    81,756 76,870 72,483
    q.com/es/market activity/stocks/pep/dividend-history
    otrends.net/stocks/charts/PEP/pepsico/roe https://www.macrotrends.net/stocks/charts/PEP/pepsico/income-

    om/market-data/quotes/PEP/financials/annual/balance-sheet
    Approach 1 2019
    EBIT (1-Tax rate) 8,126
    Add Depreciation 1,123
    Less Change in Working capital 3,430
    Less Capital expenditure 1,897
    Add preference dividend 800
    FCFF 4,722
    Less Interest (1- tax rate) 217
    Less preference dividend 800
    Add net borrowing 2,771
    FCFE (1) 6,476
    Approach 2 2019
    Net Profit 7,909
    Add Interest expenses 275
    Add preference dvidend 800
    Less Net capital expenditure 774
    Less Net Change in working capital 3,430
    Less Tax Shield on interest 58
    FCFF 4,722

    Calculation of FCFE (2) 2019


    Net Income (NI) 7,909
    Add depreciation 1,123
    Less capital investment 1,897
    Less change working capital 3,430
    Add net Borrowing 2,771
    FCFE 6,476

    You might also like