1. Provide common-size analysis of your companys income statement and balance sheet for the 2 most recent years (must be done using Excel with formulas). My company is Chipotle Mexican Grill.

CHIPOTLE MEXICAN GRILL, INC. CONSOLIDATED BALANCE SHEETS (in thousands, except per share data) December 31, 2019 2018 $ 480,626 $ 249,953 80,545 62,312 26,096 21,555 57,076 54,129 27,705 400.156 426,845 1.072,204 814,794 1,458,690 1379,254 27,855 30,199 2,505,466 18,450 19,332 21,939 21.939 $5,104,604 $ 2,265,518 $ Assets 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 Liabilities and shareholders' equity 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 115,816 $ 126,600 155,843 95,195 173.139 113,071 113,467 147,849 70,474 5,129 449,990 666,593 330,985 2,678,374 37,814 38.797 3,421,578 11,566 31.638 824.179 363 1,465,697 360 1,374,154 (2,699,119) (2.500.556) (5,363) (6.236) 2,921,44B 2,573,617 1,683,026 1.441,339 $5,104,604 $ 2,265,518 ITEM 6. SELECTED FINANCIAL DATA Our selected consolidated financial data shown below should be read together with item 7. "Management's Discussion and Analysis of Financial Condition and Results of Operations and our consolidated financial statements and respective notes included in Item 8. "Financial Statements and Supplementary Data." The data shown below are not necessarily indicative of results to be expected for any future period (dollar and share amounts in thousands, except per share data) Year ended December 31 2019 2018 2017 2016 2015 Statement of Income: Revenue $5,586,369 $4,864,985 $4,476,412 $3,904,384 $4.501,223 Food, beverage and packaging costs 1,847,916 1.600,760 1,535,428 1,365,580 1,503,835 Labor costs 1,472,060 1,326,079 1,205,992 1,105,001 1,045,726 Occupancy costs 363,072 347,123 327,132 293,636 262,412 Other operating costs 760,831 680,031 651,644 641,953 514.963 General and administrative expenses 451,552 375,460 296,388 276,240 250,214 Depreciation and amortization 212,778 201,979 163,348 146,368 130,368 Pre-opening costs 11,108 8,546 12,341 17.162 16,922 Impairment, closure costs and asset disposals 23.094 66.639 13,345 23,877 13,194 Total operating expenses 5,142,411 4,606,617 4,205,618 3,869,817 3,737,634 Income from operations 443,958 258,368 270,794 34567 763,589 Interest and other income, net 14,327 10,068 4,949 4.172 6,278 Income before income taxes 458,285 268,436 275,743 38,739 769,867 Provision for income taxes (108,127) (91,883) (99,490) (15,801) (294,265) Net income $ 350,158 $ 176,553 $ 176,253 $ 22,938 $ 475,602 Earnings per share: Basic $ 12.62 $ 6.35 $ 6.19 $ 0.78 $ 15.30 Diluted $ 12.38 $ 6.31 $ 6.17 $ 0.77 $ Weighted average common shares outstanding Basic 27,740 27.823 28.491 29,265 31,092 Diluted 28,295 27,962 28.561 29,770 31,494 15.10 December 31, 2017 2019 2018 2016 2015 Balance Sheet Data: Total current assets Total assets Total current liabilities Total liabilities Total shareholders' equity $1,072 204 $ 814,794 $ 629,535 $ 522,374 $ 814,647 $5,104,604 $2,265,518 $2,045,692 $2,026,103 $2,725,066 $ 666,593 $ 449.990 $ 323,893 $ 281,793 $ 279,942 $3,421,578 $ 824,179 $ 681247 $ 623,610 $ 597,092 $1,683,026 $1.441,339 $1,364,445 $1,402,493 $ 2,127,974