show excel formulas please

1. Compute the percentage change for each of the following categories of revenues and expenses from 2017 to 2018, and from 2018 to 2019: Total revenues Domestic Company-owned restaurant expenses North America commissary expenses International expenses Other expenses General and administrative expenses Depreciation and amortization Prepare the analysis in MS Excel displaying the categories above with the corresponding data and calculations. Once you have calculated these percentage changes, calculate the average of the changes for each item. You will end up with average percentage change from 2017-2019 for each line item above. Consider the following as a possible layout in Excel for this requirement: * Change from % Change from Average % Change Revenue/Expense Category 2017 to 2018 2018 to 2019 2020 2019 2018 2017 2017-2019 2. Now, with this data in hand...... Prepare a budgeted income statement (utilizing ONLY the revenue and expense categories identified in 1. above), and compare the budgeted data to the actual results for 2020. To calculate budgeted amounts, apply the calculated average percentage change from 1. above to the 2019 actual numbers (your base year). This will represent the budgeted amount for each category for 2020. Subtract the actual 2020 results (as reported in the Annual Report/10-K) from the calculated budgeted results and determine the dollar and percentage variance from budget. Consider the following as a possible layout in Excel for this requirement: Average % 2020 Percentage Revenue/Expense Category Actual 2019Change 2017- Actual 2020 Variance from Budget (in dollars) Budget 2020 Variance from Calculated Budget 2020 2019 3. Finally, within the 2020 Annual Report/10-K, do topside search to determine why the 2020 actual results for international expenses are higher than 2019 actual (and our calculated 2020 budget). Do suppose that Papa John's executives views this as a positive or negative aspect of its income statement and overall financial performance? Explain your reasoning Dec, 27, 2020 52 weeks (In thousands except per share data) Year Ended (0) Dec. 30, 2018 52 weeks Dec. 29. 2019 52 weeks Dec. 31, 2017 53 weeks Dec. 30, 2016 52 weeks Income Statement Data Revenues Domestic Company-owned restaurant sales North America franchise royalties and fees (2) North America commissary revenues International revenues (3) Other revenues Total revenues Refranchising and impairment gains/losses), net Operating income (4) Legal settlement Investment income Interest expense Income before income taxes Income tax expense (benefit) Net income before attribution to noncontrolling interests Net income attributable to noncontrolling interests (5) Net income attributable to the Company $ 700,757 $ 652,053 $ 692,380 S 816,718 S 815,931 96,732 71,828 79,293 106,729 102,980 680.793 612,652 609,866 673,712 623,883 123,963 102,924 110,349 114,021 100,904 210.989 179.791 170.983 72.179 69.922 1.813.234 1,619.248 1,662,871 1.783.359 1,713,620 4,739 (289) (1.674) 10,222 90.253 24,535 31,553 151,017 164,523 898 2.131 1,104 817 608 785 (17.022) (20.593) (25,673) (11.283) (7.397) 75,362 5.046 6,697 140,342 158,809 14.748 (611) 2,624 33817 49.717 60.614 5,657 4,073 106.525 109,092 (2,682) 57,932 (791 4.866 S S (1.999) (4.233) (6.272) 2.474 S 102.292 S 102.820 $ S S 41.737 (2633) S 1.29 S (024) S 1.28 S (0.24) S 2.474 0.08 0.08 Net income (los) attributable to common shareholders Basic earnings (loss) per common share Diluted earnings (loss) per common share Basic weighted average common shares outstanding Diluted weighted average common shares outstanding Dividends declared per common share $ 103,288 S 102.967 S 2.86 S 2.76 S 2.83 S 2.74 32421 31.632 32.083 36,083 37,253 32,717 0.90 S 31.632 0.90 32,299 0.90 36 522 0.85 37,608 0.75 Dec. 29 2019 52 week) Year Faded) Dec 30, 2018 (52 weeks) (Note) Dec. 31, 2017 (53 weeks) 40.3% 4.4 37,8 6.4 11.1 100.0 41.6% 4.8 36.7 6.6 103 100.0 ***** 45.8% 6.0 37,8 6.4 4.0 100.0 Income Statement Data: Revenues Domestic Company-owned restaurant sales North America franchise royalties and fees North America commissary International Other revenues Total revenues Costs and expenses: Operating costs (excluding depreciation and amortization shown separately below) Domestic Company-owned restaurant operating expense (2) North America commissary (3) International operating expense (4) Other expenses (5) I General and administrative expenses Depreciation and amortization Total costs and expenses Refranchising and impairment gains (losses), net Operating income Net interest expense Income before income taxes Income tax expense Net income before attribution to noncontrolling interests Net income attributable to noncontrolling interests Net income attributable to the Company 80.7 92.9 56.1 977 13.8 2.9 988 03 1.5 (12) 03 83.4 94.3 614 998 116 28 98.1 81.4 93.7 61.9 96.1 8.5 2.4 91.4 (0.1) 8.5 (06) 7.9 1.9 6.0 (0.3) 5.794 1.9 (1.5) 04 02 02 (0.1 019 0.3 0.34 Note: The year ended December 30, 2018 has been restated to reflect the correction of an immaterial error to consolidate the operations of PIMF, as discussed in more detail in "Note 2 Note 5" and "Note 27" of "Notes to Consolidated Financial Statements 1. Compute the percentage change for each of the following categories of revenues and expenses from 2017 to 2018, and from 2018 to 2019: Total revenues Domestic Company-owned restaurant expenses North America commissary expenses International expenses Other expenses General and administrative expenses Depreciation and amortization Prepare the analysis in MS Excel displaying the categories above with the corresponding data and calculations. Once you have calculated these percentage changes, calculate the average of the changes for each item. You will end up with average percentage change from 2017-2019 for each line item above. Consider the following as a possible layout in Excel for this requirement: * Change from % Change from Average % Change Revenue/Expense Category 2017 to 2018 2018 to 2019 2020 2019 2018 2017 2017-2019 2. Now, with this data in hand...... Prepare a budgeted income statement (utilizing ONLY the revenue and expense categories identified in 1. above), and compare the budgeted data to the actual results for 2020. To calculate budgeted amounts, apply the calculated average percentage change from 1. above to the 2019 actual numbers (your base year). This will represent the budgeted amount for each category for 2020. Subtract the actual 2020 results (as reported in the Annual Report/10-K) from the calculated budgeted results and determine the dollar and percentage variance from budget. Consider the following as a possible layout in Excel for this requirement: Average % 2020 Percentage Revenue/Expense Category Actual 2019Change 2017- Actual 2020 Variance from Budget (in dollars) Budget 2020 Variance from Calculated Budget 2020 2019 3. Finally, within the 2020 Annual Report/10-K, do topside search to determine why the 2020 actual results for international expenses are higher than 2019 actual (and our calculated 2020 budget). Do suppose that Papa John's executives views this as a positive or negative aspect of its income statement and overall financial performance? Explain your reasoning Dec, 27, 2020 52 weeks (In thousands except per share data) Year Ended (0) Dec. 30, 2018 52 weeks Dec. 29. 2019 52 weeks Dec. 31, 2017 53 weeks Dec. 30, 2016 52 weeks Income Statement Data Revenues Domestic Company-owned restaurant sales North America franchise royalties and fees (2) North America commissary revenues International revenues (3) Other revenues Total revenues Refranchising and impairment gains/losses), net Operating income (4) Legal settlement Investment income Interest expense Income before income taxes Income tax expense (benefit) Net income before attribution to noncontrolling interests Net income attributable to noncontrolling interests (5) Net income attributable to the Company $ 700,757 $ 652,053 $ 692,380 S 816,718 S 815,931 96,732 71,828 79,293 106,729 102,980 680.793 612,652 609,866 673,712 623,883 123,963 102,924 110,349 114,021 100,904 210.989 179.791 170.983 72.179 69.922 1.813.234 1,619.248 1,662,871 1.783.359 1,713,620 4,739 (289) (1.674) 10,222 90.253 24,535 31,553 151,017 164,523 898 2.131 1,104 817 608 785 (17.022) (20.593) (25,673) (11.283) (7.397) 75,362 5.046 6,697 140,342 158,809 14.748 (611) 2,624 33817 49.717 60.614 5,657 4,073 106.525 109,092 (2,682) 57,932 (791 4.866 S S (1.999) (4.233) (6.272) 2.474 S 102.292 S 102.820 $ S S 41.737 (2633) S 1.29 S (024) S 1.28 S (0.24) S 2.474 0.08 0.08 Net income (los) attributable to common shareholders Basic earnings (loss) per common share Diluted earnings (loss) per common share Basic weighted average common shares outstanding Diluted weighted average common shares outstanding Dividends declared per common share $ 103,288 S 102.967 S 2.86 S 2.76 S 2.83 S 2.74 32421 31.632 32.083 36,083 37,253 32,717 0.90 S 31.632 0.90 32,299 0.90 36 522 0.85 37,608 0.75 Dec. 29 2019 52 week) Year Faded) Dec 30, 2018 (52 weeks) (Note) Dec. 31, 2017 (53 weeks) 40.3% 4.4 37,8 6.4 11.1 100.0 41.6% 4.8 36.7 6.6 103 100.0 ***** 45.8% 6.0 37,8 6.4 4.0 100.0 Income Statement Data: Revenues Domestic Company-owned restaurant sales North America franchise royalties and fees North America commissary International Other revenues Total revenues Costs and expenses: Operating costs (excluding depreciation and amortization shown separately below) Domestic Company-owned restaurant operating expense (2) North America commissary (3) International operating expense (4) Other expenses (5) I General and administrative expenses Depreciation and amortization Total costs and expenses Refranchising and impairment gains (losses), net Operating income Net interest expense Income before income taxes Income tax expense Net income before attribution to noncontrolling interests Net income attributable to noncontrolling interests Net income attributable to the Company 80.7 92.9 56.1 977 13.8 2.9 988 03 1.5 (12) 03 83.4 94.3 614 998 116 28 98.1 81.4 93.7 61.9 96.1 8.5 2.4 91.4 (0.1) 8.5 (06) 7.9 1.9 6.0 (0.3) 5.794 1.9 (1.5) 04 02 02 (0.1 019 0.3 0.34 Note: The year ended December 30, 2018 has been restated to reflect the correction of an immaterial error to consolidate the operations of PIMF, as discussed in more detail in "Note 2 Note 5" and "Note 27" of "Notes to Consolidated Financial Statements