Tableau Dashboard Activity 4-3 Financial Statements-Income Statement The COVID-19 pandemic affected companies in the food industry in unique ways, particularly during 2020. Ruth's Hospitality Group (Ticker: RUTH) develops and operates fine dining restaurants under the trade name Ruth's Chris Steak. Sprouts Farmers Market (Ticker: SFM) offers a healthy grocery store experience. Wendy's Company (Ticker: WEN) is primarily engaged in the business of operating, developing and franchising a system of distinctive quick-service restaurants. In answering the following questions, consider the impact that the COVID-19 pandemic would have on each company's business model. Company Ruth's Hospitality Group (RUTH) Sprouts Farmers Market (SFM) Wendy's Company (WEN) Income Statement For the year ended: ($ in thousands) 40 40 Market Value to Net Income (also known as Price to Earnings ratio) Revenues Costs and expenses: Food and beverage costs Dec. 2019 $468,026 Dec. 2020 $277,748 Dec. 2021 $429,123 20 127,597 75,831 128,450 Restaurant operating expenses 214,715 150,420 179,671 Marketing and advertising 15,432 6,859 13,464 Dec. 2019 Dec. 2020 Dec. 2021 General and administrative costs 34,643 33,248 32,531 Depreciation and amortization expenses 21,354 21,964 20,487 Net Income (Loss) Pre-opening costs 1,824 1,633 1,894 ($ in Thousands) Loss (gain) on lease modifications (206) 1,058 $300,000 Loss on impairment 16,548 1,854 Total costs and expenses 415,565 306,297 Operating income (loss) Other income (expense) 52,461 (28,549) 379,409 49,714 $200,000 $100,000 Interest expense, net Other (2.197) 115 CA 3270 1233041 (4,681) 26 (3.478) 102 30 A330 Inrama nee) from continuing naratin Operating Income (Loss) to Total Revenues 0.2 01 0.0 0.10 0.05 0.00 -0.05 Net Income (Loss) to Total Revenues 02 0.1 Dec. 2021 Dec. 2019 Dec. 2020 Income Taxes to Pretax Income Prev 1 of 1 Next Pre-opening costs 1,824 1,633 1,894 ($ in Thousands) Loss (gain) on lease modifications (206) 1,058 $300,000 Loss on impairment 16,548 1,854 Total costs and expenses 415,565 306,297 379,409 $200,000 Operating income (loss) 52,461 (28,549) 49,714 Other income (expense): $100,000 Interest expense, net (2.197) (4,681) (3,478) Other 115 26 102 50 Inenma (Ince) fem rontinunn nnaratin < 370 (22204) 230 Dec. 2019 Dec. 2020 Dec. 2021 Operating Income (Loss) to Total Revenues 0.2 0.1 0.0 -0.1 0.10 0.05 -0.00 -0.05 Net Income (Loss) to Total Revenues 22 0.2 0.1 10 Income Taxes to Pretax Income -0.10 0.0 Dec. 2019 Dec. 2020 Dec. 2021 Dec. 2019 Dec. 2020 Dec. 2021 Dec. 2019 Dec 2020 Dec. 2021 +ableau Required: Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required B Which company experienced a significant increase in revenue in 2020? ORuth's Sprouts Wendy's Required Required 2 > Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 Which company's revenue was most negatively affected by the COVID-19 pandemic in 2020? ORuth's OSprouts OWendy's Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 Which company has the highest ratio of operating income to total revenues in 2021? ORuth's OSprouts OWendy's Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required B What is the ratio of net income to total revenues for Sprouts in 2021? Note: Round your answer to two decimal places. What is the ratio of net income to total revenues for Sprouts in 20217 Complete this question by entering your answers in the tabs below. Required 11 Required 2 Required 3 Required 4 Requbed 5 Required 6 Required 7 Required 8 What nonoperating item has the largest magnitude for Wendy's in 20217 OCost of sales ODepreciation and amortization Ointerest expense, net OProvision for income taxes Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Requid 6 Required 7 Required 8 Which company tends to have lowest ratio of income tax expense to pretax income (effective tax rate) over the 2019-2021 period? ORuth's OSprouts Wendy's < Required 5 Required 7 > Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 equirep 7 Required 8 Determine the following amounts for Sprouts in 2021 (Sprouts uses a slightly different naming convention for some of these amounts. Enter amounts in thousands as shown.) a. Gross profit b. Operating income: c. Pretax income d. Net income Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required Based on the ratio of market value to net income in 2021 (also known as the Price to Earnings ratio), which company do Investors value relatively more based on 2021 net income? ORuth's OSprouts Owendy's