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