Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
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
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 | ||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started