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 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

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

Step: 3

blur-text-image

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

Building Financial Models

Authors: John Tjia

2nd Edition

0071608893, 978-0071608893

More Books

Students also viewed these Finance questions

Question

e. What are notable achievements of the group?

Answered: 1 week ago