hosp1

profilewzy19961214
HOSP4060AssignmentFinancialStatementAnalysis.xlsx
Home>English homework help>hosp1

Sheet1

Section 1: 2019 Financial Statements Section 2: 2019 Financial Analysis Section 3: 2019 Financial Strengths and Weaknesses
Landry's Restaurant , Inc Landry's Restaurant , Inc Use Excel formulas to compute the following 2019 ratios from Section 1: Financial Statements Based on the financial analysis, list and briefly explain 3 financial strengths and 3 financial weaknesses.
Consolidated Balance Sheets Consolidated Statements of Income 2019 2018 Competitors 2019
Current Ratio 2.19 1.03 Strengths
December 31, 2019 December 31, 2019 Inventory Turnover 5.9 8.4 1
2019 2018 2019 2018 Profit Margin 5.7% 3.1% 2
Assets Revenues 1,254,805,671 1,167,475,165 Return on Assets 6.35% 6.12% 3
Currrent Assets Operating Costs and Expenses Return on Stockholders Equity 11.1% 12.3%
Cash 39,215,562 201,394,032 Cost of Goods Sold 333,027,693 326,108,007 Debt to Total Asset Ratio 71.03% 73.20% Weaknesses
Accounts Receivable 21,973,228 18,595,531 Labor 377,215,289 337,633,530 1
Inventories 59,716,920 55,004,153 Other Operating Expenses 311,647,878 282,411,954 Percent Changes Revenue Result 2
Deferred Taxes 12,763,948 10,859,160 General and Administrative Expenses 57,693,473 58,319,642 Enter 2018 Revenue 3
Other Current Assets 12,768,611 11,630,527 Depreciation and Amortization 63,492,747 57,294,123 Enter 2019 Revenue ERROR:#DIV/0!
Total Current Assets 146,438,269 297,483,403 Asset Impairment Expense 0 1,708,654 Revenue Result
Property and Equipment 1,380,258,684 1,007,296,936 Preopening Expenses 4,772,425 5,203,518 Enter 2018 Net Income
Goodwill and Trademarks 46,716,151 20,225,297 Total Operating Costs and Expenses 1,147,849,505 1,068,679,428 Enter 2019 Net Income ERROR:#DIV/0!
Other Intangible Assets 3,459,417 216,806 Operating Income 106,956,166 98,795,737
Other Assets 35,706,292 19,729,829 Other Expense
Total Asets 1,612,578,813 1,047,468,868 Interest Expense 41,437,790 15,185,605
Other 95,196 13,543,626
Liabilities and Stockholder Equity Income Before Income Tax 65,423,180 70,066,506
Current Liabilities Income Tax 20,608,144 3,544,778
Accounts Payable 90,489,190 48,341,318 Net Income 44,815,036 66,521,728
Accrued Liabilities 123,098,491 84,955,488
Income Taxes Payable 5,060,885 971,175
Current Portion of Long Term Notes 1,851,741 1,700,496
Total Current Liabilities 220,500,307 135,968,477
Long Term Notes 816,043,799 559,545,092
Deffered Taxes 21,635,903 13,343,631
Other Liabilities 37,628,343 35,198,105
Total Liabilities 1,095,808,352 744,055,305
Stockholders Equity
Common Stock ($0.1 Par Value,
60,000,000 shares authorized,
21,593,823 and 25,607,573
issued and outstanding, respectively) 215,938 256,076
Additional paid-in Capital 324,570,406 401,228,736
Deffered Stock Compensation -6,392,177 -4,281,670
Retained Earnings 198,376,294 203,693,824
Total Stockholders Equity 516,770,461 600,896,966
Total Liabilities and Stockholders Equity 1,612,578,813 1,344,952,271