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
Get step-by-step solutions from verified subject matter experts
