Question
Financial Analysis Simulation: Data Detective (Case Study) Below is the financials assumed for DavidsTea. Analyse the financials to identify if company matches the financial statements.
Financial Analysis Simulation: Data Detective (Case Study) Below is the financials assumed for DavidsTea. Analyse the financials to identify if company matches the financial statements. Provide final answers, rationale, and confidence level!
DavidsTea is a branded retailer of specialty tea, offering over 135 premium loose-leaf teas, pre-packaged teas, tea sachets, tea-related gifts, accessories, food, and beverages. The company sells its products primarily through its ecommerce site and its 240 company-operated stores in both the United States and Canada. DavidsTea operates in a competitive industry that is highly fragmented and is subject to seasonal sales fluctuations. The company has plans to continue its investment in its digital platform and marketing and advertising campaign to enhance customers shopping experience and to grow further sales. DavidsTea owns several protected trademarks and trade secrets to maintain its competitive edge. The company has never declared or paid regular dividends, but DavidsTea is open to pay dividends to its shareholders in the future depending on a number of factors, including the companys future earnings.
Balance Sheet | in % |
Cash, Cash Equivalents & ST Investments | 11.5 |
Accounts Receivable | 5.9 |
Other Receivables | 1.6 |
Total Receivable | 7.5 |
Inventory | 8.9 |
Other Current Assets | 1.6 |
Total Current Assets | 29.6 |
Property, Plant & Equipment | 67.5 |
Long-term investments & other LT Assets | 2 |
Goodwill & Other Intangibles | 1 |
Total Assets | 100 |
Accounts Payable | 6.7 |
Accrued Expenses | 7.7 |
Unearned Revenue | 1 |
Other Current Liablities | 2.5 |
Total Current Liabilities | 17.9 |
Long-term debt | 0 |
Capital Leases | 0 |
Other Non-current liabilities | 7.8 |
Total Liablities | 25.6 |
Common Stock | 0 |
Additional Paid in Capital | 65.4 |
Retained Earnings | 9.1 |
Treasury Stock | 0 |
Comprehensive Income & Other | -0.2 |
Total Equity | 74.3 |
Total Liabilities & Equity | 100 |
Income Statement | |
Revenue | 100 |
Cost of Goods Sold | 41.9 |
Selling, General & Admin Exp | 38.4 |
R&D Exp | 0 |
Depreciation & Amort | 5.9 |
Other Operating Expenses/Income | 0.2 |
Interest Expense | 0 |
Other Expenses & Revenues | -0.3 |
Income tax expense | 2 |
Other | 0 |
Net Income | 11.7 |
Ratios | |
ROE | 22.8 |
Profit Margin | 11.7 |
Asset Turnover | 1.5x |
ROA | 12.5 |
LT Asset Turnover | 2.2x |
Inventory Turnover | 8x |
Days Inventory held | 45.4 |
AR Turnover | 24.5x |
Days Sales Outstanding | 14.9 |
AP Turnover | 10.5x |
Days Payable Outstanding | 34.8 |
Working Capital Turnover | 5.48x |
Leverage Ratio | 0.3x |
Current Ratio | 1.7x |
Quick Ratio | 1.1x |
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