Need proforma statement for the following below 
| Assumptions for Income statement: | Sales Change | 8% | | | | |
| | Margins stay the same | | | | | |
| | Tax Rate is 21%,No dividends, shares outstanding remains the same | | | | |
| | Future dividend payout | 10% | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | Consolidated Statements of Income - USD ($) shares in Thousands, $ in Thousands | 12 Months Ended | | | | 12 Months Ended |
| | Dec. 31, 2019 | | | | 31-Dec-20 |
| | Consolidated Statements of Income [Abstract] | | | | | |
| | Revenue/Sales | $ 5,586,369 | | | | |
| | Restaurant operating costs (exclusive of depreciation and amortization shown separately below): | | | | | |
| | Food, beverage and packaging | 1,847,916 | | | | |
| | Labor | 1,472,060 | | | | |
| | Occupancy | 363,072 | | | | |
| | Gross Expenses | 3,683,048 | | | | |
| | Gross Income | 1,903,321 | | | | |
| | Other operating costs | 760,831 | | | | |
| | General and administrative expenses | 451,552 | | | | |
| | Depreciation and amortization | 212,778 | | | | |
| | Pre-opening costs | 11,108 | | | | |
| | Impairment, closure costs, and asset disposals | 23,094 | | | | |
| | Total operating expenses | 5,142,411 | | | | |
| | Income from operations | 443,958 | | | | |
| | Interest and other income, net | 14,327 | | | | |
| | Income before income taxes | 458,285 | | | | |
| | Provision for income taxes | (108,127) | | | | |
| | Net income | $ 350,158 | | | | |
| | | | | | | |
| | Future Dividend: | | | | | |
| | Retained Earnings: | | | | | |
| | | | | | | |
| | Earnings per share: | $ 12.62 | | | | |
| | | | | | | |
| | Weighted-average common shares outstanding: | 27,740 | | | | 27,740 |
| | | | | | | |
| | | | | | | |
| Assumptions for Balance sheet: | A/R, Inventory, A/P, all accurred liabilities change with sales | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | Consolidated Balance Sheets - USD ($) $ in Thousands | Dec. 31, 2019* | | 31-Dec-20 | | |
| | Current assets: | | | | | |
| | Cash and cash equivalents | $ 480,626 | | | | |
| | Accounts receivable, net | 80,545 | | | | |
| | Inventory | 26,096 | | | | |
| | Prepaid expenses and other current assets | 57,076 | | | | |
| | Income tax receivable | 27,705 | | | | |
| | Investments | 400,156 | | | | |
| | Total current assets | 1,072,204 | | | | |
| | Leasehold improvements, property and equipment, net | 1,458,690 | | | | |
| | Restricted cash | 27,855 | | | | |
| | Operating lease assets | 2,505,466 | | | | |
| | Other assets | | | | | |
| | Goodwill | 21,939 | | | | |
| | Total assets | 5,104,604* | | | | |
| | | | | | | |
| | Current liabilities: | | | | | |
| | Accounts payable | 115,816 | | | | |
| | Accrued payroll and benefits | 126,600 | | | | |
| | Accrued liabilities | 155,843 | | | | |
| | Unearned revenue | 95,195 | | | | |
| | Current operating lease liabilities | 173,139 | | | | |
| | Income tax payable | 0 | | - | | |
| | Total current liabilities | 666,593 | | | | |
| | Commitments and contingencies (Note 13) | | | | | |
| | Deferred rent | 0 | | | | |
| | Long-term operating lease liabilities | 2,678,374 | | | | |
| | Deferred income tax liabilities | 37,814 | | | | |
| | Other liabilities | 38,797 | | | | |
| | Total liabilities | 3,421,578 | | | | |
| | | | | | | |
| | ADDITIONAL FUNDS NEEDED/(EXCESS) | | | | | |
| | | | | | | |
| | Shareholders' equity: | | | | | |
| | Preferred Stock | 0 | | 0 | | |
| | Common Stock | 363 | | | | |
| | Additional paid-in capital | 1,465,697 | | | | |
| | Treasury Stock | (2,699,119) | | | | |
| | Accumulated other comprehensive loss | (5,363) | | | | |
| | Retained earnings | 2,921,448 | $ - | | | |
| | Total shareholders' equity | 1,683,026 | | | | |
| | Total liabilities and shareholders' equity | 5,104,604* | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | *Noted that the statement from the website does not add up in excel | | | | |
| | it is off by 18,450 | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
File Format Tools Data Window Help Edit View Insert OFFBE finance homework - Saved to m AutoSave Draw Formulas Data nsert Review View Page Layout Tell me Calibri (Body) 11 Wrap Text General - A A A BIU W Merge & Center 969 x & fx AN income statement Sales Change Marginstay the Tax Rates 21%. No dividends, shares outstanding remains the same Future dividend payout 10% 12 Months Ended 12 Months Ended Dec 31, 2019 31-Dec 20 35.586.369 Consolidated Statements of income USD ($) shares in Thousandi. $ In Thousands Consolidated Statements of income Astral Revenue/Sales Restaurant operating costs exclusive of depreciation and amortization shown separately below: Food, beverage and packaging Labor Occupancy Gross Expenses Gross Income Other operating costs General and administrative expenses Depreciation and amortization Pre-opening costs Impairment, closure cout, and asset disposals Total operating expenses Income from operations Interest and other income, net Income before income taxes Provision for income Net income 1.847,916 1472.000 072 3,04 1 001121 760,831 451,552 212,778 11,100 23,094 S 142,411 41 14327 458,285 (108,1271 $ Future Dividend Earnings per share: $12.62 Weld-overage common shares outstanding 27,740 27,740 AVR, intry. A/P accurred as change with sales Contated Balance Sheets. Use Thousands D11.2019 Consolidated Statements of Inco Consolidated Balance Sheets 31-Dec-20 MARGIN ANALYSIS ASSIGNMENT PROFORMA 20 cel File Tools Data Window Help Edit View Insert Format OFF BESU AutoSave finance homework - Saved Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 y A A 2. Wrap Text General B I I u v v Merge & Center $ % ) x & fx for Balance sheet A/R, Inventory.ccurred liabilities change with sales Dec 31, 2019 31-Dec-20 Consolidated Balance Sheets - USD 15 in Thousands Currentes: Cash and cash equivalents Accounts receivabinet Inventory Prepaid expenses and other current assets Income tax receivable Investments Total currentes Leasehold improvements, property and equipment, net Restricted cash Operating lease assets Other assets Goodwill Toast $ 480,626 80,545 26.096 57,076 27,705 400.156 1072204 1.458690 27,855 2,505466 21,939 5,104,604 Current Accounts payable Accrued payroll and benefits Accrued as Uneamed revenue Current operating lease abilities Income tax payable Total currentes Commitments and contingencies Note 13) Deferrent Long-term operating teases Deferred income taxes Other lates Totales 115 316 126.00 155.143 95,195 173, 139 9 64.593 0 2,678,374 37854 38,797 3,421,578 ADDITIONAL FUNDS NEEDED/EXCESS) Shares Preferred Stock Common Stod Additional paid in capital Treasury Stock Retained eaming Consolidated Statements of Inco 363 1,465,697 (2,699,119) 15,753 2.921.441 Consolidated Balance Sheets MARGIN ANALYSIS ASSIGNMENT PROFORMA 20 AutoSave OFF o finance homework Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) 11 A Wrap Text MIDI Genera B I y y Merge & Center $ v x fx 27.855 2,505,466 Restricted cash Operating lease assets Other assets Goodwie Totalasses 21,939 5,104,604" Current abilities: Accounts payable Accrued payroll and benefits Accrued abilities Uneamed revenue Current operating lease abilities Income tax payable Total current liabilities Commitments and contingences (Note 13) Deferred rent Long-term operating lease abilities Deferred income tax abilities Other Babilities Total Babies 115,816 126,600 155,843 95,195 173,139 O 666,593 2,678,374 37,814 38,797 3,421,578 ADOITIONAL FUNDS NEEDED/EXCESS) Shareholders Preferred Stock Common Stock Additional paid in capital Treasury Stock Acumulated other comprehensive loss Retained emings Total shareholders Toales and shareholders 0 363 1,465,697 2,699,119) 2.921.4485 1.683.025 5,104,50 Noted that the statement from the web does not add up incel is off by 18.450 Consolidated Statements of Inco Consolidated Balance Sheets ar MARGIN ANALYSIS ASSIGNMENT PROF 20 Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 Wrap Text ' a. Av BIU v ilil Merge & Center x fx C Dec 31, 2019 Dec 31, 2018 Consolidated Balance Sheets - USD ($) $ in Thousands urrent assets: ash and cash equivalents accounts receivable, net nventory repaid expenses and other current assets ncome tax receivable investments Total current assets Leasehold improvements, property and equipment, net Restricted cash Operating lease assets Other assets Goodwill Total assets $ 480,626 80,545 26,096 57,076 27,705 400,156 1,072,204 1,458,690 27,855 2,505,466 18,450 21,939 5,104,604 $ 249,953 62,312 21,555 54,129 0 426,845 814,794 1,379,254 30,199 0 19,332 21,939 2,265,518 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 115,816 126,600 155,843 95,195 173,139 0 666,593 113,071 113,467 147,849 70,474 0 5,129 449,990 O 2,678,374 37,814 38,797 3,421,578 330,985 0 11,566 31,638 824,179 Shareholders equity Preferred Stock 0 Common Stock 363 Additional pald-in capital 1,465,697 Treasury Stock 12,699,119) Accumulated other comprehensive loss (5,363) Retained earnings 2,921,448 Total shareholders' eauty 1.683.026 Consolidated Statements of Inco Consolidated Balance Sheets lect destination and press ENTER or choose Paste O 360 1,374,154 (2,500,556) (6,236) 2,573,617 1.441.339 MARGIN ANALYSIS ASSIGNMENT 20 Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF finance homewe me Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) 11 = 2 Wrap Text Ge - A A iste BIU v V Merge & Center $ $ 3 D x fx B Leasehold improvements, property and equipment, net Restricted cash Operating lease assets Other assets Goodwill Total assets 1,458,690 27.855 2,505,466 18,450 21,939 5,104,604 1,379,254 30,199 0 19,332 21.939 2,265,518 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 abilities 115,816 126,600 155,843 95,195 173,139 0 666,593 113,071 113,467 147,849 70,474 0 5,129 449,990 0 2,678,374 37,814 38,797 3,421,578 330,985 0 11,566 31,638 824,179 Shareholders equity Preferred Stock Common Stock Additional paid in capital Treasury Stock Accumulated other comprehensive loss Retained earnings Total shareholders' equity Total abilities and shareholders equity 0 363 1,465,697 12.699,119) 15,363) 2,921,448 1,683,026 $ 5,104,604 0 360 1,374,154 12,500,556) (5,236) 2,573,617 1.441,339 $ 2,265,518 Consolidated Statements of Inco Consolidated Balance Sheets Select destination and press ENTER or choose Paste MARGIN ANALYSIS ASSIGNMENT 20 File Edit View Insert Format Tools AutoSave OFF Data Window Help 2 finance homework - Saved to my Mac Review View Tell me sert Draw Page Layout Formulas Data General Calibri (Body) 16 A A 2 Wrap Text A Merge & Center x fx Consolidated Statements of Income - USD ($) shares in Thousands, $ in Thousands $ - % 428-98 D 12 Months Ended Dec 31, 2018 Dec 31, 2019 Dec 31, 2017 $5,586,369 $4,864,985 $ 4,476,412 Consolidated Statements of Income - USD ($) shares in Thousands, Sin Thousands onsolidated Statements of Income (Abstract] evenue estaurant operating costs (exclusive of depreciation and amortization hown separately below): mood, beverage and packaging abor Occupancy Gross Expenses Bross income Other operating costs General and administrative expenses Depreciation and amortization Pre-opening costs Impairment, closure costs, and asset disposals Total operating expenses Income from operations Interest and other income, net Income before income taxes Provision for income taxes Net Income Earnings per share: Basic 1,847,916 1,472,060 363,072 3,683,048 1,903,321 760,831 451,552 212,778 11,108 23,094 5,142,411 443,958 14,327 458,285 (108,127) $ 350,158 1,600,760 1,326,079 347,123 3,273,962 1,591,023 680,031 375,460 201,979 8,546 66,639 4,606,617 258,368 10,068 268,436 (91,883) $ 176,553 1,535,428 1,205,992 327,132 3,068,552 1,407,860 651,644 296,388 163,348 12,341 13,345 4,205,618 270,794 4,949 275,743 (99,490) $ 176,253 $ 12.62 $6.35 $6.19 Weighted average common shares outstanding: Basic 27,740 27,823 28.491 Consolidated Statements of Inco Consolidated Balance Sheets MARGIN ANALYSIS ASSIGNMENT estination and press ENTER or choose Paste PROFORMA ASSIG Average: 10571 20 File Format Tools Data Window Help Edit View Insert OFFBE finance homework - Saved to m AutoSave Draw Formulas Data nsert Review View Page Layout Tell me Calibri (Body) 11 Wrap Text General - A A A BIU W Merge & Center 969 x & fx AN income statement Sales Change Marginstay the Tax Rates 21%. No dividends, shares outstanding remains the same Future dividend payout 10% 12 Months Ended 12 Months Ended Dec 31, 2019 31-Dec 20 35.586.369 Consolidated Statements of income USD ($) shares in Thousandi. $ In Thousands Consolidated Statements of income Astral Revenue/Sales Restaurant operating costs exclusive of depreciation and amortization shown separately below: Food, beverage and packaging Labor Occupancy Gross Expenses Gross Income Other operating costs General and administrative expenses Depreciation and amortization Pre-opening costs Impairment, closure cout, and asset disposals Total operating expenses Income from operations Interest and other income, net Income before income taxes Provision for income Net income 1.847,916 1472.000 072 3,04 1 001121 760,831 451,552 212,778 11,100 23,094 S 142,411 41 14327 458,285 (108,1271 $ Future Dividend Earnings per share: $12.62 Weld-overage common shares outstanding 27,740 27,740 AVR, intry. A/P accurred as change with sales Contated Balance Sheets. Use Thousands D11.2019 Consolidated Statements of Inco Consolidated Balance Sheets 31-Dec-20 MARGIN ANALYSIS ASSIGNMENT PROFORMA 20 cel File Tools Data Window Help Edit View Insert Format OFF BESU AutoSave finance homework - Saved Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 y A A 2. Wrap Text General B I I u v v Merge & Center $ % ) x & fx for Balance sheet A/R, Inventory.ccurred liabilities change with sales Dec 31, 2019 31-Dec-20 Consolidated Balance Sheets - USD 15 in Thousands Currentes: Cash and cash equivalents Accounts receivabinet Inventory Prepaid expenses and other current assets Income tax receivable Investments Total currentes Leasehold improvements, property and equipment, net Restricted cash Operating lease assets Other assets Goodwill Toast $ 480,626 80,545 26.096 57,076 27,705 400.156 1072204 1.458690 27,855 2,505466 21,939 5,104,604 Current Accounts payable Accrued payroll and benefits Accrued as Uneamed revenue Current operating lease abilities Income tax payable Total currentes Commitments and contingencies Note 13) Deferrent Long-term operating teases Deferred income taxes Other lates Totales 115 316 126.00 155.143 95,195 173, 139 9 64.593 0 2,678,374 37854 38,797 3,421,578 ADDITIONAL FUNDS NEEDED/EXCESS) Shares Preferred Stock Common Stod Additional paid in capital Treasury Stock Retained eaming Consolidated Statements of Inco 363 1,465,697 (2,699,119) 15,753 2.921.441 Consolidated Balance Sheets MARGIN ANALYSIS ASSIGNMENT PROFORMA 20 AutoSave OFF o finance homework Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) 11 A Wrap Text MIDI Genera B I y y Merge & Center $ v x fx 27.855 2,505,466 Restricted cash Operating lease assets Other assets Goodwie Totalasses 21,939 5,104,604" Current abilities: Accounts payable Accrued payroll and benefits Accrued abilities Uneamed revenue Current operating lease abilities Income tax payable Total current liabilities Commitments and contingences (Note 13) Deferred rent Long-term operating lease abilities Deferred income tax abilities Other Babilities Total Babies 115,816 126,600 155,843 95,195 173,139 O 666,593 2,678,374 37,814 38,797 3,421,578 ADOITIONAL FUNDS NEEDED/EXCESS) Shareholders Preferred Stock Common Stock Additional paid in capital Treasury Stock Acumulated other comprehensive loss Retained emings Total shareholders Toales and shareholders 0 363 1,465,697 2,699,119) 2.921.4485 1.683.025 5,104,50 Noted that the statement from the web does not add up incel is off by 18.450 Consolidated Statements of Inco Consolidated Balance Sheets ar MARGIN ANALYSIS ASSIGNMENT PROF 20 Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 Wrap Text ' a. Av BIU v ilil Merge & Center x fx C Dec 31, 2019 Dec 31, 2018 Consolidated Balance Sheets - USD ($) $ in Thousands urrent assets: ash and cash equivalents accounts receivable, net nventory repaid expenses and other current assets ncome tax receivable investments Total current assets Leasehold improvements, property and equipment, net Restricted cash Operating lease assets Other assets Goodwill Total assets $ 480,626 80,545 26,096 57,076 27,705 400,156 1,072,204 1,458,690 27,855 2,505,466 18,450 21,939 5,104,604 $ 249,953 62,312 21,555 54,129 0 426,845 814,794 1,379,254 30,199 0 19,332 21,939 2,265,518 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 115,816 126,600 155,843 95,195 173,139 0 666,593 113,071 113,467 147,849 70,474 0 5,129 449,990 O 2,678,374 37,814 38,797 3,421,578 330,985 0 11,566 31,638 824,179 Shareholders equity Preferred Stock 0 Common Stock 363 Additional pald-in capital 1,465,697 Treasury Stock 12,699,119) Accumulated other comprehensive loss (5,363) Retained earnings 2,921,448 Total shareholders' eauty 1.683.026 Consolidated Statements of Inco Consolidated Balance Sheets lect destination and press ENTER or choose Paste O 360 1,374,154 (2,500,556) (6,236) 2,573,617 1.441.339 MARGIN ANALYSIS ASSIGNMENT 20 Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF finance homewe me Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) 11 = 2 Wrap Text Ge - A A iste BIU v V Merge & Center $ $ 3 D x fx B Leasehold improvements, property and equipment, net Restricted cash Operating lease assets Other assets Goodwill Total assets 1,458,690 27.855 2,505,466 18,450 21,939 5,104,604 1,379,254 30,199 0 19,332 21.939 2,265,518 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 abilities 115,816 126,600 155,843 95,195 173,139 0 666,593 113,071 113,467 147,849 70,474 0 5,129 449,990 0 2,678,374 37,814 38,797 3,421,578 330,985 0 11,566 31,638 824,179 Shareholders equity Preferred Stock Common Stock Additional paid in capital Treasury Stock Accumulated other comprehensive loss Retained earnings Total shareholders' equity Total abilities and shareholders equity 0 363 1,465,697 12.699,119) 15,363) 2,921,448 1,683,026 $ 5,104,604 0 360 1,374,154 12,500,556) (5,236) 2,573,617 1.441,339 $ 2,265,518 Consolidated Statements of Inco Consolidated Balance Sheets Select destination and press ENTER or choose Paste MARGIN ANALYSIS ASSIGNMENT 20 File Edit View Insert Format Tools AutoSave OFF Data Window Help 2 finance homework - Saved to my Mac Review View Tell me sert Draw Page Layout Formulas Data General Calibri (Body) 16 A A 2 Wrap Text A Merge & Center x fx Consolidated Statements of Income - USD ($) shares in Thousands, $ in Thousands $ - % 428-98 D 12 Months Ended Dec 31, 2018 Dec 31, 2019 Dec 31, 2017 $5,586,369 $4,864,985 $ 4,476,412 Consolidated Statements of Income - USD ($) shares in Thousands, Sin Thousands onsolidated Statements of Income (Abstract] evenue estaurant operating costs (exclusive of depreciation and amortization hown separately below): mood, beverage and packaging abor Occupancy Gross Expenses Bross income Other operating costs General and administrative expenses Depreciation and amortization Pre-opening costs Impairment, closure costs, and asset disposals Total operating expenses Income from operations Interest and other income, net Income before income taxes Provision for income taxes Net Income Earnings per share: Basic 1,847,916 1,472,060 363,072 3,683,048 1,903,321 760,831 451,552 212,778 11,108 23,094 5,142,411 443,958 14,327 458,285 (108,127) $ 350,158 1,600,760 1,326,079 347,123 3,273,962 1,591,023 680,031 375,460 201,979 8,546 66,639 4,606,617 258,368 10,068 268,436 (91,883) $ 176,553 1,535,428 1,205,992 327,132 3,068,552 1,407,860 651,644 296,388 163,348 12,341 13,345 4,205,618 270,794 4,949 275,743 (99,490) $ 176,253 $ 12.62 $6.35 $6.19 Weighted average common shares outstanding: Basic 27,740 27,823 28.491 Consolidated Statements of Inco Consolidated Balance Sheets MARGIN ANALYSIS ASSIGNMENT estination and press ENTER or choose Paste PROFORMA ASSIG Average: 10571 20
