Scribd Logo
Upload

Welcome to Scribd!

  • 24 views

    Financial Analysis Excel

    Uploaded by

    Charles Tulip
    This document contains financial statements and metrics for the years 2019, 2018 and 2017. It includes the consolidated statements of income, balance sheets, and key financial metrics such as net profit margin, gross profit margin, return on equity, current ratio, days to collect, days to sell inventory, and debt to assets ratio. Revenue increased from $4.5B in 2017 to $5.6B in 2019. Net income grew from $176M in 2017 to $350M in 2019, resulting in an improved net profit margin from 3.63% in 2018 to 6.27% in 2019.

    Copyright:

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

    Financial Analysis Excel

    Uploaded by

    Charles Tulip
    24 views5 pages
    This document contains financial statements and metrics for the years 2019, 2018 and 2017. It includes the consolidated statements of income, balance sheets, and key financial metrics such as net profit margin, gross profit margin, return on equity, current ratio, days to collect, days to sell inventory, and debt to assets ratio. Revenue increased from $4.5B in 2017 to $5.6B in 2019. Net income grew from $176M in 2017 to $350M in 2019, resulting in an improved net profit margin from 3.63% in 2018 to 6.27% in 2019.

    Original Description:

    j

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains financial statements and metrics for the years 2019, 2018 and 2017. It includes the consolidated statements of income, balance sheets, and key financial metrics such as net profit margin, gross profit margin, return on equity, current ratio, days to collect, days to sell inventory, and debt to assets ratio. Revenue increased from $4.5B in 2017 to $5.6B in 2019. Net income grew from $176M in 2017 to $350M in 2019, resulting in an improved net profit margin from 3.63% in 2018 to 6.27% in 2019.

    Copyright:

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

    Financial Analysis Excel

    Uploaded by

    Charles Tulip
    This document contains financial statements and metrics for the years 2019, 2018 and 2017. It includes the consolidated statements of income, balance sheets, and key financial metrics such as net profit margin, gross profit margin, return on equity, current ratio, days to collect, days to sell inventory, and debt to assets ratio. Revenue increased from $4.5B in 2017 to $5.6B in 2019. Net income grew from $176M in 2017 to $350M in 2019, resulting in an improved net profit margin from 3.63% in 2018 to 6.27% in 2019.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 5

    Consolidated Statements of Income - USD ($) shares in Thousands, $ in Thousands

    Consolidated Statements of Income [Abstract]


    Revenue
    Restaurant operating costs (exclusive of depreciation and amortization shown separately
    below):
    Food, beverage and packaging
    Labor
    Occupancy
    Other operating costs
    General and administrative expenses
    Depreciation and amortization
    Pre-opening costs
    Impairment, closure costs, and asset disposals
    Total operating expenses
    Income from operations
    Interest and other income, net
    Income before income taxes
    Provision for income taxes
    Net income
    Earnings per share:
    Basic
    Diluted
    Weighted-average common shares outstanding:
    Basic
    Diluted
    12 Months Ended
    Dec. 31, 2019 Dec. 31, 2018 Dec. 31, 2017

    $ 5,586,369 $ 4,864,985 $ 4,476,412

    1,847,916 1,600,760 1,535,428


    1,472,060 1,326,079 1,205,992
    363,072 347,123 327,132
    760,831 680,031 651,644
    451,552 375,460 296,388
    212,778 201,979 163,348
    11,108 8,546 12,341
    23,094 66,639 13,345
    5,142,411 4,606,617 4,205,618
    443,958 258,368 270,794
    14,327 10,068 4,949
    458,285 268,436 275,743
    (108,127) (91,883) (99,490)
    $ 350,158 $ 176,553 $ 176,253

    $ 12.62 $ 6.35 $ 6.19


    $ 12.38 $ 6.31 $ 6.17

    27,740 27,823 28,491


    28,295 27,962 28,561
    Consolidated Balance Sheets - USD ($) $ in Thousands
    Current assets:
    Cash and cash equivalents
    Accounts receivable, net
    Inventory
    Prepaid expenses and other current assets
    Income tax receivable
    Investments
    Total current assets
    Leasehold improvements, property and equipment, net
    Restricted cash
    Operating lease assets
    Other assets
    Goodwill
    Total assets
    Current liabilities:
    Accounts payable
    Accrued payroll and benefits
    Accrued liabilities
    Unearned revenue
    Current operating lease liabilities
    Income tax payable
    Total current liabilities
    Commitments and contingencies (Note 13)
    Deferred rent
    Long-term operating lease liabilities
    Deferred income tax liabilities
    Other liabilities
    Total liabilities
    Shareholders' equity:
    Preferred stock, $0.01 par value, 600,000 shares authorized, no shares issued as of December 31,
    2019 and 2018, respectively
    Common stock, $0.01 par value, 230,000 shares authorized, 36,323 and 35,973 shares issued as of
    December 31, 2019 and 2018, respectively
    Additional paid-in capital
    Treasury stock, at cost, 8,568 and 8,276 common shares as of December 31, 2019 and 2018,
    respectively
    Accumulated other comprehensive loss
    Retained earnings
    Total shareholders' equity
    Total liabilities and shareholders' equity
    Dec. 31, 2019 Dec. 31, 2018 Dec. 31, 2017

    $ 480,626 $ 249,953 $184,569


    80,545 62,312 40,453
    26,096 21,555 19,860
    57,076 54,129 50,918
    27,705 0 9,353
    400,156 426,845 324,382
    1,072,204 814,794 629,535
    1,458,690 1,379,254 1,338,366
    27,855 30,199 29,601
    2,505,466 0 0
    18,450 19,332 26,251
    21,939 21,939 21,939
    5,104,604 2,265,518 2,045,692

    115,816 113,071 82,028


    126,600 113,467 82,541
    155,843 147,849 95,679
    95,195 70,474 63,645
    173,139 0
    0 5,129
    666,593 449,990 323,893

    0 330,985 316,498
    2,678,374 0
    37,814 11,566 814
    38,797 31,638 40,042
    3,421,578 824,179 681,247

    0 0 0

    363,000 360,000 359,000

    1,465,697 1,374,154 1,305,090


    (2,699,119) (2,500,556) (2,334,409)

    (5,363) (6,236) (3,659)


    2,921,448 2,573,617 2,397,064
    1,683,026 1,441,339 1,364,445
    $ 5,104,604 $ 2,265,518 $ 2,045,692
    Calculation Name Formula 2019 2018
    Net Profit Margin Net Income/Revenues 6.27% 3.63%
    Gross Profit Margin (Net Sales Revenue - COGS) / Net Sales Revenue 20.45% 18.73%
    ROE Net Income /Average Common Stockholders' Equity 22.41% 12.58%
    Current Ratio Current Assets / Current Liabilities 1.61 1.81
    Days to Collect 365 / Receivables Turnover 4.67 3.86
    Days to Sell 365/Inventory Turnover 1.96 1.91
    Debt to Assets Total Liabilities / Total Assets 0.67 0.36

    You might also like