Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your submission should be an Excel file page containing the problem numbers and your final answers. I must be able to see your calculations when

Your submission should be an Excel file page containing the problem numbers and your final answers. I must be able to see your calculations when I click in the cells. Do so by replicating the Ratios Chart below. Use the attached financial statements to complete the ratios chart. Then complete the analysis chart based on the ratios chart. In the second chart, then indicate whether the 2019 Ratios are acceptable, then whether the trend is headed in the right direction Ratios Chart 2019. 2018 2017 Current 0.52 0.59 Quick 0.42 0.50 OCF 309,124 316,381 FCF (146,091) (146,935) D-E 0.02 0.02 EM 3.96 2.51 TAT 1.90 1.76 PM 0.07 0.06 ROA 0.12 0.11 ROE 0.26 0.23

Ratio Trend/jump/drop indicating problem (inc. years) Problem indicated by trend/jump/drop Current Quick OCF FCF D-E EM TAT PM ROA ROE

BALANCE SHEET - USD Thousands INCOME STATEMENT CASH FLOW STATEMENT Current assets: Revenues $ 2,332,331 Cash flows from operating activities: Cash and cash equivalents $ 26,578 Cost of sales 532,880 Net income $ 99,035 Accounts receivable 20,928 Labor expenses 834,134 Depreciation and amortization expenses 95,976 Other 68,193 Other expenses 566,825 Deferred income taxes (5,510) Inventories 38,886 Gen. & admin. exp. 154,770 Impairment of assets 16,411 Prepaid expenses 40,645 Dep. & amor. exp. 95,976 Stock-based compensation 19,988 Total current assets 195,230 Impairment of assets 17,861 Loss from investments 4,754 Property and equipment, net 913,275 Preopening costs 10,937 Accounts receivable (1,018) Total other assets 205,628 Total 2,213,383 Other receivables 4,698 Total assets 1,314,133 Income from ops 118,948 Inventories 3,667 Current liabilities: Loss on investments (4,754) Prepaid expenses 6,262 Accounts payable 49,071 Interest exp., net (6,783) Other assets 7,406 Income taxes payable 712 Income before taxes 107,411 Accounts payable 5,601 Gift card liability 172,336 Tax provision 8,376 Income taxes receivable/payable 15,729 Other accrued expenses 194,381 Net income $ 99,035 Other accrued expenses 18,316 Total current liabilities 416,500 Cash provided by operating activities 291,315 Deferred income taxes 52,123 Cash flows from investing activities: Deferred rent liabilities 79,697 Additions to property and equipment (102,909) Deemed landlord fin. liability 113,095 Additions to intangible assets (3,020) Long-term debt 10,000 Investments in unconsolidated affiliates (25,000) Other noncurrent liabilities 71,659 Proceeds from life insurance contract 540 Stockholders' equity: Cash used in investing activities (130,389) Common stock, $.01 par value 967 Cash flows from financing activities: Additional paid-in capital 828,676 Deemed landlord financing proceeds 16,660 Retained earnings 1,384,494 Proceeds from exercise of stock options 8,576 Treasury stock (1,642,140) Cash dividends paid (56,251) Acc. comp. loss (938) Treasury stock purchases (109,276) Total stockholders' equity 571,059 Cash used in financing activities (140,291) Total liabilities & equity $1,314,133 Foreign currency translation adjustment (65) Net change in cash and cash equivalents 20,570 Cash & equivalents at start of period 6,008 Cash & equivalents at end of period 26,5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Forensic Accounting

Authors: Greg Shields

1st Edition

1727480988, 978-1727480986

More Books

Students also viewed these Accounting questions

Question

Describe the new structures for the HRM function. page 724

Answered: 1 week ago