Question: Financial Analysis Simulation: Data Detective (Case Study) Below is the financials assumed for Chipotle. Analyse the financials to identify if company matches the financial statements.

Financial Analysis Simulation: Data Detective (Case Study) Below is the financials assumed for Chipotle. Analyse the financials to identify if company matches the financial statements. Provide final answers, rationale, and confidence level!

Balance Sheet in %
Cash, Cash Equivalents & ST Investments 13
Accounts Receivable 2.6
Other Receivables 0
Total Receivable 2.6
Inventory 1.7
Other Current Assets 1.8
Total Current Assets 19.2
Property, Plant & Equipment 70.2
Long-term investments & other LT Assets 5.1
Goodwill & Other Intangibles 5.5
Total Assets 100
Accounts Payable 5.3
Accrued Expenses 7.1
Unearned Revenue 13.8
Other Current Liablities 1.4
Total Current Liabilities 27.5
Long-term debt 13.3
Capital Leases 0
Other Non-current liabilities 17.7
Total Liablities 58.5
Common Stock 3.2
Additional Paid in Capital 5.8
Retained Earnings 58.2
Treasury Stock -25.7
Comprehensive Income & Other 0
Total Equity 41.5
Total Liabilities & Equity 100
Income Statement
Revenue 100
Cost of Goods Sold 65.7
Selling, General & Admin Exp 1.1
R&D Exp 0
Depreciation & Amort 5.8
Other Operating Expenses/Income 11.2
Interest Expense -0.1
Other Expenses & Revenues -0.8
Income tax expense -1.1
Other 0
Net Income 16.5
Ratios
ROE 37
Profit Margin 16.5
Asset Turnover 0.9x
ROA 8.9
LT Asset Turnover 1.3x
Inventory Turnover 36.7x
Days Inventory held 9.9
AR Turnover 32x
Days Sales Outstanding 11.4
AP Turnover 11.2x
Days Payable Outstanding 32.6
Working Capital Turnover -0.17
Leverage Ratio 1.4x
Current Ratio 0.7x
Quick Ratio 0.6x

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!