Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started