Hello, I need some help with one of my assignments that must be done on Excel. I must complete three years of income statements, three years of balance sheets, a vertical analysis, horizontal analysis, all ratios and three years of statement of cash flows all for the company Shake Shack using their actual records. If anyone would be so kind as to help me with this assignment I would be eternally grateful since I am completely lost.

I have attached the income statement, balance sheet, and statement of cash flows that Shake Shack provides online. These will be the financials used in the assignment. The assignment does not need all of the information they provide on the website, but if someone could aid in me in figuring out how to format the important information, I would deeply appreciate it.

Annual Financials for Shake Shack Inc. CI A # View Ratios Fiscal year is January-December. All values USD millions. 2015 2016 2017 2018 2019 5-year trend + Sales/Revenue 190.59M 268.48M 358.81M 459.31M 594.52M # Cost of Goods Sold (COGS) incl. D&A 140.57M 200.56M 275.78M 361.68M 487.31M COGS excluding D&A 130.35M 186.06M 254.08M 332.68M 446.61M Depreciation & Amortization Expense 10.22M 14.5M 21.7M 29M 40.7M Depreciation 10.22M 14.5M 21.7M 29M 40.39M Amortization of Intangibles 312,000 + Gross Income 50.03M 67.92M 83.03M 97.63M 107.21M 2015 2016 2017 2018 2019 5-year trend + SG&A Expense 43.26M 40.08M 39M 52.72M 65.34M Research & Development Other SG&A 43.26M 40.08M 39M 52.72M 65.34M ul Other Operating Expense Unusual Expense 61,000 (194,000) EBIT after Unusual Expense 44.85M 42.07M Non Operating Income/Expense (17,000) 943,000 117.84M (11.63M) (14.12M) Non-Operating Interest Income 7.000 88.000 77.000 9.000 Non Operating Income/Expense (17,000) 943,000 117.84M (11.63M) (14.12M) Non-Operating Interest Income 7,000 88,000 77,000 9,000 IL Equity in Affiliates (Pretax) + Interest Expense 332,000 374,000 1.64M 2.42M 434.000 Gross Interest Expense 440,000 374,000 1.81M 2.57M 434,000 Interest Capitalized 108,000 164,000 157,000 + Pretax Income 6.43M 28.5M 160.29M 30.81M 2751M 1-11- Income Tax 3.3M 6.35M 151.41M 8.86M 3.39M Income Tax - Current Domestic 3.61M 6.21M 4.13M 6.14M 7.27M Income Tax - Current Foreign 433,000 667,000 942,000 1.94M 2.18M Income Tax - Deferred Domestic (734,000) (523,000) 146.33M 788,000 (6.06M) Income Tax - Deferred Foreign Income Tax Credits Equity in Affiliates Other After Tax Income (Expense) Consolidated Net Income 3.12M 22.15M 8.88M 21.95M 24.13M LI Minority Interest Expense 11.9M 9.7M 9.2M 6.77M 4.3M + Net Income (8.78M) 12.45M (320,000) 15.18M 19.83M Minority Interest Expense 11.9M 9.7M 9.2M 6.77M 4.3M Net Income (8.78M) 12.45M (320,000) 15.18M 19.83M Extraordinaries & Discontinued Operations Extra Items & Gain/Loss Sale Of Assets Cumulative Effect - Accounting Chg Discontinued Operations Net Income After Extraordinaries (8.78M) 12.45M (320,000) 15.18M 19.83M Preferred Dividends Net Income Available to Common (8.78M) 12.45M (320,000) 15.18M 19.83M EPS (Basic) (0.65) 0.54 (0.01) 0.54 0.63 Basic Shares Outstanding 13.59M 22.96M 25.88M 28.3M 31.38M EPS (Diluted) (0.65) 0.53 (0.01) 0.52 0.61 Diluted Shares Outstanding 13.59M 23.45M 25.88M 29.18M 32.25M EBITDA 16.99M 42.34M 65.73M 73.91M 82.58M Copyright 2020 FactSet Research Systems Inc. All rights reserved. Source FactSet Fundamentals. Income Statement Balance Sheet Cash Flow Statement Annual Financials Annual Financials for Shake Shack Inc. CI A + View Ratios Assets Fiscal year is January-December. All values USD millions. 2015 2016 2017 2018 2019 5-year trend + Cash & Short Term Investments 71.12M 75.45M 84.54M 86.86M 73.61M Cash Only 70.85M 11.61M 21,51M 24.75M 37.1M L. Short-Term Investments 275,000 63.85M 63.04M 62.11M 36.51M + Total Accounts Receivable 4.22M 6.02M 5.66M 10.56M 9.97M Accounts Receivables, Net 4.07M 5.48M 5.12M 9.56M 7.93M Accounts Receivables, Gross 4.07M 5.48M 5.12M 9.56M 7.93M Bad Debt/Doubtful Accounts Other Receivables 145,000 533,000 541,000 1M 2.04M Inventories 543,000 806,000 1.26M 1.75M 2.22M Finished Goods 543,000 806,000 1.26M 1.75M 2.22M Work in Progress Raw Materials Progress Payments & Other Other Current Assets 3.05M 1.67M 1.74M 1.95M 1.88M Miscellaneous Current Assets 3.05M 1.67M 1.74M 1.95M 188M Total Current Assets 78.93M 83.94M 93.2M 101.12M 87.68M 2015 2016 2017 2018 2019 5-year trend Net Property, Plant & Equipment 93.04M 136.26M 187.1M 261.85M 589.29M Property, Plant & Equipment - Gross 116.56M 173.39M 245.35M 347.3M 711.07M Buildings 7.47M 15.6M Land & Improvements Computer Software and Equipment 5.2M 8.71M 12.72M 19.01M 24.23M Other Property, Plant & Equipment 87.87M 127.97M 177.09M 242,51M 320.29M Accumulated Depreciation 23.52M 37.12M 58.26M 85.45M 121.79M Total Investments and Advances 2.11M 639,000 Other Long-Term Investments 2.11M 639,000 Long-Term Note Receivable Intangible Assets 701,000 701,000 894,000 1.16M 1.44M Net Goodwill Net Other Intangibles 701,000 701,000 894,000 1.16M 1.44M Other Assets 2.8M 3.44M 3.5M 3.87M 10.05M Tangible Other Assets 2.8M 2.8M 3.44M 3.5M 3.87M 10.05M Liabilities & Shareholders' Equity 2015 2016 2017 2018 2019 5-year trend ST Debt & Current Portion LT Debt 31,88M Short Term Debt 30M Current Portion of Long Term Debt 1.87M + Accounts Payable 6.79M 6.92M 8.21M 12.47M 14.3M Income Tax Payable 1.07M 1.32M 1.81M Other Current Liabilities 16.15M 23.47M 24M 47.48M 53.22M Dividends Payable Accrued Payroll 5.8M 6.08M 6.23M 10.65M 11.45M Miscellaneous Current Liabilities 10.34M 17.39M 17.77M 36.83M 41.77M + Total Current Liabilities 24.01M 31.72M 34.02M 59.95M 99.39M Long-Term Debt 313,000 2.01M 14.52M 20.85M 308.56M Long-Term Debt excl. Capitalized Leases 313,000 Non-Convertible Debt 313,000 Convertible Debt Capitalized Lease Obligations 2.01M 14.52M 20.85M 3.64M Provision for Risks & Charges Deferred Taxes (201.96M) (313.21M) (185.91M) (242.53M) (279.82M) Deferred Taxes (201.96M) (313.21M) (185.91M) (242.53M) (279.82M) Deferred Taxes - Credit 316,000 370,000 673,000 1.44M 4.54M Deferred Taxes - Debit 202.27M 313.56M 186.59M 243.97M 284.36M Other Liabilities 198.21M 303.12M 197.59M 256.28M 238.33M Other Liabilities (excl. Deferred Income) 198.21M 303.12M 197.59M 256.28M 227.02M Deferred Income 11.31M + Total Liabilities 222.84M 337.21M 246.8M 338.51M 650.82M Non-Equity Reserves Preferred Stock (Carrying Value) Redeemable Preferred Stock -- Non-Redeemable Preferred Stock # Common Equity (Total) 100.62M 152.19M 169.49M 226.08M 298.82M Common Stock Par/Carry Value 36,000 36,000 37,000 38,000 38,000 Retained Earnings 4.27M 16.72M 16.4M 30.4M 54.37M ESOP Debt Guarantee Cumulative Translation Adjustment/Unrealized For. Exch. Gain 2,000 Unrealized Gain/Loss Marketable Securities Revaluation Reserves Treasury Stock + Total Shareholders' Equity 100.62M 152.19M 169.49M 226.08M 298.82M ***** Accumulated Minority Interest 56.4M 49.17M 54.99M 47.38M 23.17M Total Shareholders' Equity 100.62M 152.19M 169.49M 226.08M 298.82M Accumulated Minority Interest 56.4M 49.17M 54.99M 47.38M 23.17M Total Equity 157.02M 201.35M 224.48M 273.46M 321.99M Liabilities & Shareholders' Equity 379.86M 538.56M 471.28M 611.97M 972.81M Income Statement Balance Sheet Cash Flow Statement Annual Financials Annual Financials for Shake Shack Inc. CI A + View Ratios Operating Activities Fiscal year is January-December. All values USD millions. 2015 2016 2017 2018 2019 5-year trend + Net Income before Extraordinaries (8.78M) 22.15M 8.88M 21.95M 24.13M Depreciation, Depletion & Amortization 10.22M 14.5M 21.7M 29M 40.7M Depreciation and Depletion 10.22M 14.5M 21.7M 29M 40.39M Amortization of Intangible Assets 312,000 Deferred Taxes & Investment Tax Credit (734,000) (523,000) 146.33M 788,000 (6.06M) Deferred Taxes (734,000) (523,000) 146.33M 788,000 (6.06M) Investment Tax Credit Other Funds 28.87M 4.99M (120.67M) 7.74M 48.26M L- Funds from Operations 29.58M 41.11M 56.25M 59.48M 107.02M Extraordinaries Changes in Working Capital 11.68M 13.17M 14.62M 25.92M 19.86M Receivables 775,000 2.97M 6.42M 5.53M 10.73M Accounts Payable 201,000 839,000 1.24M 3.16M 4.25M Receivables 775,000 2.97M 6.42M 5.53M 10.73M Accounts Payable 201,000 839,000 1.24M 3.16M 4.25M Other Assets/Liabilities 408,000 366,000 1.88M 4.07M (5.3M) + Net Operating Cash Flow 41.26M 54.29M 70.88M 85.4M 126,88M Investing Activities 2015 2016 2017 2018 2019 5-year trend + Capital Expenditures (32.12M) (54.43M) (61.53M) (87.53M) (106.51M) Capital Expenditures (Fixed Assets) (32.12M) (54.43M) (61.53M) (87.53M) (106,51M) Capital Expenditures (Other Assets) Net Assets from Acquisitions Sale of Fixed Assets & Businesses Purchase/Sale of Investments (2.4M) (60.33M) (410,000) 921,000 25.82M Purchase of Investments (2.4M) (61.27M) (7.86M) (1.22M) (1.18M) Sale/Maturity of Investments 938,000 7.45M 2.14M 27M Other Uses Other Sources + Net Investing Cash Flow (34,51 M) (114.76M) (61.94M) (86.6M) (80.69M) Other Sources + Net Investing Cash Flow (34.51M) (114.76M) (61.94M) (86.6M) (80.69M) 11 Financing Activities 2015 2016 2017 2018 2019 5-year trend Cash Dividends Paid - Total (11.13M) Common Dividends (11.13M) Preferred Dividends Change in Capital Stock 109.29M 3.19M 7.59M 4.52M 9.2M Repurchase of Common & Preferred Stk. Sale of Common & Preferred Stock 109.29M 3.19M 7.59M 4.52M 9.2M Proceeds from Stock Options 109.29M (949,000) Other Proceeds from Sale of Stock 3.19M 7.59M 5.47M 9.2M Issuance/Reduction of Debt, Net (32.1M) (313,000) 917,000 680,000 (39.23M) Change in Current Debt (37.31M) Change in Long-Term Debt (32.1M) (313,000) 917,000 680,000 (1.93M) Issuance of Long-Term Debt 3.9M 1.18M 1.38M Reduction in Long-Term Debt (36M) (313,000) (266,000) (702,000) (1.93M) Other Funds (4.64M) (1.65M) (7.54M) (751,000) (3.81M) Other Uses (4.64M) (1.75M) (7.54M) (751,000) (3.81M) Other Sources 98,000 Net Financing Cash Flow 61.43M 1.23M 965,000 4.45M (33.84M) Exchange Rate Effect Miscellaneous Funds Net Change in Cash 68.17M (59.24M) 9.9M 3.24M 12.35M Free Cash Flow 9.14M (148,000) 9.35M (2.13M) 20.37M Annual Financials for Shake Shack Inc. CI A # View Ratios Fiscal year is January-December. All values USD millions. 2015 2016 2017 2018 2019 5-year trend + Sales/Revenue 190.59M 268.48M 358.81M 459.31M 594.52M # Cost of Goods Sold (COGS) incl. D&A 140.57M 200.56M 275.78M 361.68M 487.31M COGS excluding D&A 130.35M 186.06M 254.08M 332.68M 446.61M Depreciation & Amortization Expense 10.22M 14.5M 21.7M 29M 40.7M Depreciation 10.22M 14.5M 21.7M 29M 40.39M Amortization of Intangibles 312,000 + Gross Income 50.03M 67.92M 83.03M 97.63M 107.21M 2015 2016 2017 2018 2019 5-year trend + SG&A Expense 43.26M 40.08M 39M 52.72M 65.34M Research & Development Other SG&A 43.26M 40.08M 39M 52.72M 65.34M ul Other Operating Expense Unusual Expense 61,000 (194,000) EBIT after Unusual Expense 44.85M 42.07M Non Operating Income/Expense (17,000) 943,000 117.84M (11.63M) (14.12M) Non-Operating Interest Income 7.000 88.000 77.000 9.000 Non Operating Income/Expense (17,000) 943,000 117.84M (11.63M) (14.12M) Non-Operating Interest Income 7,000 88,000 77,000 9,000 IL Equity in Affiliates (Pretax) + Interest Expense 332,000 374,000 1.64M 2.42M 434.000 Gross Interest Expense 440,000 374,000 1.81M 2.57M 434,000 Interest Capitalized 108,000 164,000 157,000 + Pretax Income 6.43M 28.5M 160.29M 30.81M 2751M 1-11- Income Tax 3.3M 6.35M 151.41M 8.86M 3.39M Income Tax - Current Domestic 3.61M 6.21M 4.13M 6.14M 7.27M Income Tax - Current Foreign 433,000 667,000 942,000 1.94M 2.18M Income Tax - Deferred Domestic (734,000) (523,000) 146.33M 788,000 (6.06M) Income Tax - Deferred Foreign Income Tax Credits Equity in Affiliates Other After Tax Income (Expense) Consolidated Net Income 3.12M 22.15M 8.88M 21.95M 24.13M LI Minority Interest Expense 11.9M 9.7M 9.2M 6.77M 4.3M + Net Income (8.78M) 12.45M (320,000) 15.18M 19.83M Minority Interest Expense 11.9M 9.7M 9.2M 6.77M 4.3M Net Income (8.78M) 12.45M (320,000) 15.18M 19.83M Extraordinaries & Discontinued Operations Extra Items & Gain/Loss Sale Of Assets Cumulative Effect - Accounting Chg Discontinued Operations Net Income After Extraordinaries (8.78M) 12.45M (320,000) 15.18M 19.83M Preferred Dividends Net Income Available to Common (8.78M) 12.45M (320,000) 15.18M 19.83M EPS (Basic) (0.65) 0.54 (0.01) 0.54 0.63 Basic Shares Outstanding 13.59M 22.96M 25.88M 28.3M 31.38M EPS (Diluted) (0.65) 0.53 (0.01) 0.52 0.61 Diluted Shares Outstanding 13.59M 23.45M 25.88M 29.18M 32.25M EBITDA 16.99M 42.34M 65.73M 73.91M 82.58M Copyright 2020 FactSet Research Systems Inc. All rights reserved. Source FactSet Fundamentals. Income Statement Balance Sheet Cash Flow Statement Annual Financials Annual Financials for Shake Shack Inc. CI A + View Ratios Assets Fiscal year is January-December. All values USD millions. 2015 2016 2017 2018 2019 5-year trend + Cash & Short Term Investments 71.12M 75.45M 84.54M 86.86M 73.61M Cash Only 70.85M 11.61M 21,51M 24.75M 37.1M L. Short-Term Investments 275,000 63.85M 63.04M 62.11M 36.51M + Total Accounts Receivable 4.22M 6.02M 5.66M 10.56M 9.97M Accounts Receivables, Net 4.07M 5.48M 5.12M 9.56M 7.93M Accounts Receivables, Gross 4.07M 5.48M 5.12M 9.56M 7.93M Bad Debt/Doubtful Accounts Other Receivables 145,000 533,000 541,000 1M 2.04M Inventories 543,000 806,000 1.26M 1.75M 2.22M Finished Goods 543,000 806,000 1.26M 1.75M 2.22M Work in Progress Raw Materials Progress Payments & Other Other Current Assets 3.05M 1.67M 1.74M 1.95M 1.88M Miscellaneous Current Assets 3.05M 1.67M 1.74M 1.95M 188M Total Current Assets 78.93M 83.94M 93.2M 101.12M 87.68M 2015 2016 2017 2018 2019 5-year trend Net Property, Plant & Equipment 93.04M 136.26M 187.1M 261.85M 589.29M Property, Plant & Equipment - Gross 116.56M 173.39M 245.35M 347.3M 711.07M Buildings 7.47M 15.6M Land & Improvements Computer Software and Equipment 5.2M 8.71M 12.72M 19.01M 24.23M Other Property, Plant & Equipment 87.87M 127.97M 177.09M 242,51M 320.29M Accumulated Depreciation 23.52M 37.12M 58.26M 85.45M 121.79M Total Investments and Advances 2.11M 639,000 Other Long-Term Investments 2.11M 639,000 Long-Term Note Receivable Intangible Assets 701,000 701,000 894,000 1.16M 1.44M Net Goodwill Net Other Intangibles 701,000 701,000 894,000 1.16M 1.44M Other Assets 2.8M 3.44M 3.5M 3.87M 10.05M Tangible Other Assets 2.8M 2.8M 3.44M 3.5M 3.87M 10.05M Liabilities & Shareholders' Equity 2015 2016 2017 2018 2019 5-year trend ST Debt & Current Portion LT Debt 31,88M Short Term Debt 30M Current Portion of Long Term Debt 1.87M + Accounts Payable 6.79M 6.92M 8.21M 12.47M 14.3M Income Tax Payable 1.07M 1.32M 1.81M Other Current Liabilities 16.15M 23.47M 24M 47.48M 53.22M Dividends Payable Accrued Payroll 5.8M 6.08M 6.23M 10.65M 11.45M Miscellaneous Current Liabilities 10.34M 17.39M 17.77M 36.83M 41.77M + Total Current Liabilities 24.01M 31.72M 34.02M 59.95M 99.39M Long-Term Debt 313,000 2.01M 14.52M 20.85M 308.56M Long-Term Debt excl. Capitalized Leases 313,000 Non-Convertible Debt 313,000 Convertible Debt Capitalized Lease Obligations 2.01M 14.52M 20.85M 3.64M Provision for Risks & Charges Deferred Taxes (201.96M) (313.21M) (185.91M) (242.53M) (279.82M) Deferred Taxes (201.96M) (313.21M) (185.91M) (242.53M) (279.82M) Deferred Taxes - Credit 316,000 370,000 673,000 1.44M 4.54M Deferred Taxes - Debit 202.27M 313.56M 186.59M 243.97M 284.36M Other Liabilities 198.21M 303.12M 197.59M 256.28M 238.33M Other Liabilities (excl. Deferred Income) 198.21M 303.12M 197.59M 256.28M 227.02M Deferred Income 11.31M + Total Liabilities 222.84M 337.21M 246.8M 338.51M 650.82M Non-Equity Reserves Preferred Stock (Carrying Value) Redeemable Preferred Stock -- Non-Redeemable Preferred Stock # Common Equity (Total) 100.62M 152.19M 169.49M 226.08M 298.82M Common Stock Par/Carry Value 36,000 36,000 37,000 38,000 38,000 Retained Earnings 4.27M 16.72M 16.4M 30.4M 54.37M ESOP Debt Guarantee Cumulative Translation Adjustment/Unrealized For. Exch. Gain 2,000 Unrealized Gain/Loss Marketable Securities Revaluation Reserves Treasury Stock + Total Shareholders' Equity 100.62M 152.19M 169.49M 226.08M 298.82M ***** Accumulated Minority Interest 56.4M 49.17M 54.99M 47.38M 23.17M Total Shareholders' Equity 100.62M 152.19M 169.49M 226.08M 298.82M Accumulated Minority Interest 56.4M 49.17M 54.99M 47.38M 23.17M Total Equity 157.02M 201.35M 224.48M 273.46M 321.99M Liabilities & Shareholders' Equity 379.86M 538.56M 471.28M 611.97M 972.81M Income Statement Balance Sheet Cash Flow Statement Annual Financials Annual Financials for Shake Shack Inc. CI A + View Ratios Operating Activities Fiscal year is January-December. All values USD millions. 2015 2016 2017 2018 2019 5-year trend + Net Income before Extraordinaries (8.78M) 22.15M 8.88M 21.95M 24.13M Depreciation, Depletion & Amortization 10.22M 14.5M 21.7M 29M 40.7M Depreciation and Depletion 10.22M 14.5M 21.7M 29M 40.39M Amortization of Intangible Assets 312,000 Deferred Taxes & Investment Tax Credit (734,000) (523,000) 146.33M 788,000 (6.06M) Deferred Taxes (734,000) (523,000) 146.33M 788,000 (6.06M) Investment Tax Credit Other Funds 28.87M 4.99M (120.67M) 7.74M 48.26M L- Funds from Operations 29.58M 41.11M 56.25M 59.48M 107.02M Extraordinaries Changes in Working Capital 11.68M 13.17M 14.62M 25.92M 19.86M Receivables 775,000 2.97M 6.42M 5.53M 10.73M Accounts Payable 201,000 839,000 1.24M 3.16M 4.25M Receivables 775,000 2.97M 6.42M 5.53M 10.73M Accounts Payable 201,000 839,000 1.24M 3.16M 4.25M Other Assets/Liabilities 408,000 366,000 1.88M 4.07M (5.3M) + Net Operating Cash Flow 41.26M 54.29M 70.88M 85.4M 126,88M Investing Activities 2015 2016 2017 2018 2019 5-year trend + Capital Expenditures (32.12M) (54.43M) (61.53M) (87.53M) (106.51M) Capital Expenditures (Fixed Assets) (32.12M) (54.43M) (61.53M) (87.53M) (106,51M) Capital Expenditures (Other Assets) Net Assets from Acquisitions Sale of Fixed Assets & Businesses Purchase/Sale of Investments (2.4M) (60.33M) (410,000) 921,000 25.82M Purchase of Investments (2.4M) (61.27M) (7.86M) (1.22M) (1.18M) Sale/Maturity of Investments 938,000 7.45M 2.14M 27M Other Uses Other Sources + Net Investing Cash Flow (34,51 M) (114.76M) (61.94M) (86.6M) (80.69M) Other Sources + Net Investing Cash Flow (34.51M) (114.76M) (61.94M) (86.6M) (80.69M) 11 Financing Activities 2015 2016 2017 2018 2019 5-year trend Cash Dividends Paid - Total (11.13M) Common Dividends (11.13M) Preferred Dividends Change in Capital Stock 109.29M 3.19M 7.59M 4.52M 9.2M Repurchase of Common & Preferred Stk. Sale of Common & Preferred Stock 109.29M 3.19M 7.59M 4.52M 9.2M Proceeds from Stock Options 109.29M (949,000) Other Proceeds from Sale of Stock 3.19M 7.59M 5.47M 9.2M Issuance/Reduction of Debt, Net (32.1M) (313,000) 917,000 680,000 (39.23M) Change in Current Debt (37.31M) Change in Long-Term Debt (32.1M) (313,000) 917,000 680,000 (1.93M) Issuance of Long-Term Debt 3.9M 1.18M 1.38M Reduction in Long-Term Debt (36M) (313,000) (266,000) (702,000) (1.93M) Other Funds (4.64M) (1.65M) (7.54M) (751,000) (3.81M) Other Uses (4.64M) (1.75M) (7.54M) (751,000) (3.81M) Other Sources 98,000 Net Financing Cash Flow 61.43M 1.23M 965,000 4.45M (33.84M) Exchange Rate Effect Miscellaneous Funds Net Change in Cash 68.17M (59.24M) 9.9M 3.24M 12.35M Free Cash Flow 9.14M (148,000) 9.35M (2.13M) 20.37M