Requirements:

1. Complete the financial statement data set by including the 2020 financial statements.
2. Common size all years of the financial statements.
3. Calculate year over year selected accounts needed for your evaluation. Do this step after number 4. and after evaluating the results of the ratios.
4. Prepare a schedule of analytical procedures/ratios for the 6 years of information. (See ratio section below)
5. Evaluate the companys financial position and performance.
   1. Evaluate as follows:
      1. Financial position of the company. Support your position with 1-3 points and an interesting and useful graph.
      2. Performance of the company. Support your position with 1-3 pts and an interesting and useful graph.

Summary Evaluation Requirements:

1. FontCalibri, 1
2. One page for evaluation, 3 points each and graphical exhibits.
3. Submit Excel file with all financial statement data & ratio schedules.

Ratios (Analytical Procedures)

Short-Term Liquidity

Current Ratio:

Current assets/Current liabilities

Quick ratio (acid test ratio):

Cash + equivalenets + A/R/current liabilities

Working Capital: current assets current liabilities

Activitycan be used to evaluate both profitability and short-term liquidity

Accounts Receivable turnover:

Sales/Avg. Accounts Receivable

Days Accounts Receivable

365/Acct Rec turnover

Inventory turnover:

COGS/Avg Inventory

Days inventory:

365/inventory turnover

Asset Turnover:

Net Sales/Total Avg Assets

Consider variations or extensions on AT.

Profitability

Profit Margin

Net income/Net sales

Operating income margin

Operating income/Net sales

Return on Assets

Net income/Total Avg Assets

Solvencylong-term debt paying abilityvery future looking

Debt ratio:

Total Liabilities/Total Assets

2015 2016 2017 2019 2019 2020 248,005 S 87,880 $ 184,569 $ 249,953 $ 490,626 S 38,283 40,451 40,453 62,312 90,545 15,043 15,019 19,860 21,555 26,096 39,965 44,080 50,918 54,129 57,076 58,152 5. 108 9,353 27,705 415,199 329,836 324,392 426,845 400,156 814,647 522,374 629,535 814,794 1,072,204 1,217,220 1.303,558 1,338,366 1,379,254 1,458.690 622,939 125, OSS 30,199 27,855 2.505,466 48,321 53, 177 55,852 19,332 18,450 21.939 21.939 21,939 21.939 21.939 2,725, 066 $ 2,026,103 $2,045, 692 $ 2.265,518 $ 5.104,604 $ GO7.987 104.900 26,445 54,906 282,783 343,616 1,420,237 1.584,311 102.328 27 849 2,767,185 59,047 21.939 5.992 996 85,709 S 64,958 129,275 78,363 $ 76,301 127, 129 82,028 $ 113,071 S 82.541 113,467 159, 324 147,849 70,474 115,816 S 126,600 155,843 95,195 173.139 121.990 203.054 164,649 127,790 204,756 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 equipe Long tem investments 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 operatinglease liabilities Deferred income tax liabilities Other liabilities Total liabilities Shareholdes'equity: Preferred stock, $0.01 par value, 600,000shares authorized, moshares issued as of December 31, 2019 and 2018, respectively Common stock, 50.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 stack, at cost, 8,568 and 8,276common shares as of December 31, 2019 and 2018 respectively Accumulated other comprehensive loss Retained earnings Total shareholdes' equity Total liabilities and shareholders' equity $ 5,129 449,990 279,942 281,793 323,893 666,593 222,199 2,952,296 251,962 288,927 316, 498 330,985 - 32305 32.883 597,092 18,944 33.946 623.610 814 40,042 681,247 11.566 31,638 824,179 2.678.374 37 814 38.797 3,421,578 149,422 38,844 3.962,761 358 1.172.628 358 1,238,875 359 1.305,090 360 1,374,154 363 1,465,697 367 1,549,909 (1.234,612) (2,049,399 (2,334,409) (2,500,556) (2.699,119) (8.273) (8.162) (3,659) (6,236 (5,363) 2,197 873 2.220,811 2,397,064 2,573,617 2.921.448 2,127,974 1,402, 493 1,364, 445 1,441,339 1.683.026 2,725, 066 $ 2,026,103 $ 2,045, 692 $ 2,265,518 $ 5,104,604 $ (2.902.075) (4,229) 3.276,163 2,020,135 5.982.896 Year ended December 31, 2015 2016 2017 2018 2019 Revenue $ 4,501,223 $ 3,904,384 $ 4,476, 412 $ 4,864,985 $ 5,586,369 Restaurant operating costs (exclusive of depreciation and amortization shown separately below: Food, beverage and packaging 1,503.835 1,365, 580 1.535,428 1,600,760 1,847,916 S Labor 1,045,726 1.105.001 1,205,992 1.326,079 1,472.0GO Ocupancy 262,412 293,636 327,132 347,123 363,072 Other operating costs 514.963 641,953 651,644 680,031 760,831 General and administrative experises 250,214 276, 240 296,388 375,460 451.552 Depreciation and amortization 130.368 146, 3G8 163,348 201,979 212,778 Pre-opening costs 16,922 17,162 12.341 8.546 11,108 Impairment, dosure costs, and asset disposals 13,194 23.877 13,345 66,639 23,094 Total operating expenses 3,737,634 3,869, 817 4,205,618 4,606,617 5,142,411 Income from operations 763.589 34,567 270,794 258,368 443.958 Interest and other income, net 6.278 4,172 4,949 10,068 14,327 Income before income taxes 769,867 38,729 275,743 268,436 458,285 Provision for income taxes (294, 265) (15,801) (99.490) (91,883) (108,127 Net income $ 475, 602 S 22,938 $ 176,253 $ 176,553 $ 350,158S 5,920,545 1.593,013 387,762 1,030,012 466,291 238.534 15,515 30,577 5,694,470 290,164 3,617 293,781 61.995 355,766 Earnings pershare: S S 15.30 S 15.10 S 0.78 0.77 5 6.19 $ 6.17 S 6.35 $ 6.31 S 12.625 12.38 S 12.74 12.52 Diluted Weighted-average common shares outstanding: Basic Diluted 31,092 31.494 29,265 29,770 27 917 28,491 28,561 27,823 27,962 27,740 28,295 28,416 2015 2016 2017 2018 2019 2020 Trend Summary ST-Liquidity Current ratio Quick ratio Working capital Activity Accounts Rec Turn Accounts Rec days Inventory turnover Inventory days Profitability Profit margin ROA Asset turnover Solvency Debt ratio 2015 2016 2017 2019 2019 2020 248,005 S 87,880 $ 184,569 $ 249,953 $ 490,626 S 38,283 40,451 40,453 62,312 90,545 15,043 15,019 19,860 21,555 26,096 39,965 44,080 50,918 54,129 57,076 58,152 5. 108 9,353 27,705 415,199 329,836 324,392 426,845 400,156 814,647 522,374 629,535 814,794 1,072,204 1,217,220 1.303,558 1,338,366 1,379,254 1,458.690 622,939 125, OSS 30,199 27,855 2.505,466 48,321 53, 177 55,852 19,332 18,450 21.939 21.939 21,939 21.939 21.939 2,725, 066 $ 2,026,103 $2,045, 692 $ 2.265,518 $ 5.104,604 $ GO7.987 104.900 26,445 54,906 282,783 343,616 1,420,237 1.584,311 102.328 27 849 2,767,185 59,047 21.939 5.992 996 85,709 S 64,958 129,275 78,363 $ 76,301 127, 129 82,028 $ 113,071 S 82.541 113,467 159, 324 147,849 70,474 115,816 S 126,600 155,843 95,195 173.139 121.990 203.054 164,649 127,790 204,756 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 equipe Long tem investments 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 operatinglease liabilities Deferred income tax liabilities Other liabilities Total liabilities Shareholdes'equity: Preferred stock, $0.01 par value, 600,000shares authorized, moshares issued as of December 31, 2019 and 2018, respectively Common stock, 50.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 stack, at cost, 8,568 and 8,276common shares as of December 31, 2019 and 2018 respectively Accumulated other comprehensive loss Retained earnings Total shareholdes' equity Total liabilities and shareholders' equity $ 5,129 449,990 279,942 281,793 323,893 666,593 222,199 2,952,296 251,962 288,927 316, 498 330,985 - 32305 32.883 597,092 18,944 33.946 623.610 814 40,042 681,247 11.566 31,638 824,179 2.678.374 37 814 38.797 3,421,578 149,422 38,844 3.962,761 358 1.172.628 358 1,238,875 359 1.305,090 360 1,374,154 363 1,465,697 367 1,549,909 (1.234,612) (2,049,399 (2,334,409) (2,500,556) (2.699,119) (8.273) (8.162) (3,659) (6,236 (5,363) 2,197 873 2.220,811 2,397,064 2,573,617 2.921.448 2,127,974 1,402, 493 1,364, 445 1,441,339 1.683.026 2,725, 066 $ 2,026,103 $ 2,045, 692 $ 2,265,518 $ 5,104,604 $ (2.902.075) (4,229) 3.276,163 2,020,135 5.982.896 Year ended December 31, 2015 2016 2017 2018 2019 Revenue $ 4,501,223 $ 3,904,384 $ 4,476, 412 $ 4,864,985 $ 5,586,369 Restaurant operating costs (exclusive of depreciation and amortization shown separately below: Food, beverage and packaging 1,503.835 1,365, 580 1.535,428 1,600,760 1,847,916 S Labor 1,045,726 1.105.001 1,205,992 1.326,079 1,472.0GO Ocupancy 262,412 293,636 327,132 347,123 363,072 Other operating costs 514.963 641,953 651,644 680,031 760,831 General and administrative experises 250,214 276, 240 296,388 375,460 451.552 Depreciation and amortization 130.368 146, 3G8 163,348 201,979 212,778 Pre-opening costs 16,922 17,162 12.341 8.546 11,108 Impairment, dosure costs, and asset disposals 13,194 23.877 13,345 66,639 23,094 Total operating expenses 3,737,634 3,869, 817 4,205,618 4,606,617 5,142,411 Income from operations 763.589 34,567 270,794 258,368 443.958 Interest and other income, net 6.278 4,172 4,949 10,068 14,327 Income before income taxes 769,867 38,729 275,743 268,436 458,285 Provision for income taxes (294, 265) (15,801) (99.490) (91,883) (108,127 Net income $ 475, 602 S 22,938 $ 176,253 $ 176,553 $ 350,158S 5,920,545 1.593,013 387,762 1,030,012 466,291 238.534 15,515 30,577 5,694,470 290,164 3,617 293,781 61.995 355,766 Earnings pershare: S S 15.30 S 15.10 S 0.78 0.77 5 6.19 $ 6.17 S 6.35 $ 6.31 S 12.625 12.38 S 12.74 12.52 Diluted Weighted-average common shares outstanding: Basic Diluted 31,092 31.494 29,265 29,770 27 917 28,491 28,561 27,823 27,962 27,740 28,295 28,416 2015 2016 2017 2018 2019 2020 Trend Summary ST-Liquidity Current ratio Quick ratio Working capital Activity Accounts Rec Turn Accounts Rec days Inventory turnover Inventory days Profitability Profit margin ROA Asset turnover Solvency Debt ratio