Answered step by step
Verified Expert Solution
Link Copied!

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

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_2

Step: 3

blur-text-image_3

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

An Introduction To Personal Finance

Authors: Anne Marie Ward

2nd Edition

1907214267, 978-1907214264

More Books

Students also viewed these Finance questions

Question

Writing a Strong Introduction

Answered: 1 week ago