Financial Analysis Simulation: Data Detective homework

The Companies:: ( 10)

Below is the list of companies you will need to match to the financials on the Analyze page. Select one or more companies to read their descriptions. Use this information, together with your analysis of the financials on the Analyze page, to identify the company that matches the financial statements. Be sure to only use the information provided to you in this assignment. Submit your final answers, rationale, and confidence level on the Decide page.

Amazon.com

A giant among online retailers, Amazon.com, Inc., is also a major provider of web and cloud infrastructure services and a producer of consumer electronics such Kindle and Fire tablets. The company has entered brick and mortar retailing with its acquisition of Whole Foods and with the introduction of physical-location bookstores called Amazon Books. Amazon facilitates ecommerce for third-party sellers who sell their products on amazon.com, and the company operates a network of fulfillment and delivery services for physical products sold domestically and internationally. Its popular Amazon Pime is a paid subscription service that gives customers free two-day delivery on products. Amazons research and development activities have spawned the technology for Alexa, a virtual assistant capable of voice interaction, music playback, and providing real-time audio of news and weather reports. Its acquisition strategies have brought innovative companies on board such as Audible, a producer of digital audiobooks, magazines, and newspapers. The company is headquartered in Seattle, Washington.

American Express

American Express, founded in 1850, is a Manhattan-based financial services firm organized as a bank holding company. A Dow component and Big Board listed, American Express is a financial force known around the globe, providing services to consumers, small businesses, mid-size firms, and large corporations. Its wide-ranging array of services includes credit cards and other financing products, network services, point-of-sale marketing and information services, expense management, and travel-related services.

AB InBev

Anheuser-Busch InBev is a leading global brewer with over 500 beer brands sold in more than 150 countries. It is one of the largest consumer products companies worldwide and has a significant market share in the beer industry. Anheuser-Busch InBev remains a profitable company in its industry. The company addresses market demand by maintaining a strong beer brand portfolio with global brands, multi-brands, and local brands. Anheuser-Busch InBev developed a cost-connect-win model to minimize cost, maximize sales, connect with consumers, and win market share for long-term growth. In recent years, the company has invested in additional brewing, packaging, and distribution capabilities in multiple countries to meet future market demand. Anheuser-Busch InBev has accumulated a significant amount of goodwill from various acquisitions. Although the company has a strong cash position, Anheuser-Busch InBev acknowledges that the company may face financial risks in the future and even a potential downgrading of its credit ratings because of the level of debt the company has incurred.

Apple Inc.

Apple Inc., designs, manufactures, and markets mobile communication and media devices and personal computers. The company sells a variety of related software, services, accessories, networking solutions, and third-party digital content and applications. Apple sells its products worldwide through its retail stores, online stores, and direct sales force, as well as through third-party cellular network carriers, wholesalers, and retailers. Its end consumers include individuals, small and mid-sized businesses, and education, enterprise, and government customers. Apple also sells and delivers digital content and applications through its online platform and sells a variety of third-party products that are compatible with its main products through its retail and online stores. Substantially all of Apples hardware products are currently manufactured by outsourcing partners that are located primarily in Asia, with some Mac computers manufactured in the United States and Ireland.

Hanesbrands

Hanesbrands, Inc., is a leading manufacturer and marketer of everyday basic innerwear and active wear apparel under a variety of clothing brands. Its products are mainly marketed to US and international wholesalers, including mass market retailers, department stores, specialty stores, and third-party ecommerce sites. Hanesbrands also sells its products directly to the individual consumer via over 700 company-branded and outlet stores, and through its ecommerce sites. Hanesbrands owns and operates its own manufacturing facilities in different countries and more than 70% of the apparel units that it sells are manufactured in its own plants or with dedicated manufacturers.

Samsung

Samsung Electronics Co., Ltd., is an innovative and multinational electronics and information technology company headquartered in Suwon, South Korea. Its products include home appliances and air conditioners, computers, digital televisions, mobile phones, monitors, printers, semiconductors, and telecommunications networking equipment. Its popular Galaxy smartphones and tablets have propelled Samsung into a leadership role for both product categories. Samsung is also a manufacturer of memory chips and semiconductors along with electronic components such as batteries, flash memory, and hard drive devices. Its customer base for electronic components includes Apple and Sony. In Canada, the company operates Samsung Experience stores where customers can test and purchase the latest Samsung products and connect with tech experts. The company operates assembly plants and sales networks in many countries and employs hundreds of thousands of people. Samsung Electronics stock is listed on South Koreas stock exchange, Korea Exchange.

Tapestry, Inc.

Tapestry, Inc., is a multinational luxury fashion company whose premium womens and mens handbags, accessories, and footwear are sold in company branded stores and outlets and by merchandisers such as Macys, Bloomingdales, Nordstrom, and Neiman Marcus. With its highly respected brands such as Coach, Kate Spade, and Stuart Weitzman, Tapestrys products are attractively styled and made of high quality leather, fabric, and other materials. The companys competitive advantages are in its ability to design and market products and manage an extensive supply chain; however, its manufacturing is handled by well-controlled third party producers located in many parts of the world including Vietnam, China, and the United States. Tapestry operates a large distribution center in Jacksonville, Florida, and has established regional distribution centers operated by partners located throughout the world. While most of its revenues are from sales, Tapestry generates licensing revenue through the Coach brand and its relationship with producers of eyewear, watches, and fragrances. The company is headquartered in New York City.

Target

Target Corporation is a mass merchant retailer that offers everyday essentials and fashionable, differentiated merchandise at discounted prices. A significant portion of Targets sales come from national branded merchandise, while approximately one-third comes from Targets own exclusive brands. Target operates over 1,800 stores and 41 distribution centers in the United States. Targets stores fall into two main categories, large stores that offer a full line of food items comparable to traditional supermarkets and smaller stores that offer curated general merchandise and food assortments. As a part of its effort to expand its ecommerce and delivery options, in December 2017, Target acquired Shipt, an online delivery service platform. Target also has an agreement with CVS Pharmacy, which enables CVS to operate pharmacies and clinics inside Target stores under a perpetual operating agreement.

Boston Beer Co

The Boston Beer Company is one of the largest craft beer brewers in the United States. With headquarters and a brewery in Boston, Massachusetts, its award-winning flagship brand is named after Samuel Adams, an American Revolutionary War hero. While the company is known for producing high quality products that appeal to the US beer drinker, it is also the maker of non-beer alcoholic beverages such as Angry Orchard (hard cider) and numerous flavored malts under the Twisted Tea brand. Recognizing the competitiveness of the craft beer market, Boston Beer Company has a reputation for innovation and creativity. It sponsors A&S Brewing, a craft beer incubator that encourages the development of locally brewed craft beers. The company operates its main breweries in Massachusetts, Ohio, and Pennsylvanian, and smaller breweries spawned by its incubator in various locations in the United States. Boston Beer Company has been effective at increasing consumer product and company awareness through advertising, point-of-sale promotional programs, and drinker education. Most of the companys sales are through a network of beverage distributors located throughout the United States and in some foreign markets.

Wells Fargo

Wells Fargo & Company is a diversified financial services company. It provides retail, commercial, and corporate banking services through banking locations and offices, the internet, and other distribution channels to individuals, businesses, and institutions in the United States and in other countries. Wells Fargo also provides other financial services through subsidiaries engaged in various businesses, principally wholesale banking, mortgage banking, consumer finance, equipment leasing, agricultural finance, commercial finance, securities brokerage and investment banking, computer and data processing services, trust services, investment advisory services, mortgage-backed securities servicing, and venture capital investment. Wells Fargo has three operating segments for management reporting purposes: community banking, wholesale banking, and wealth and investment management.

Balance Sheet Cash, Cash Equivalents & ST Investments Accounts Receivable Other Receivables Total Receivables Inventory Other Current Assets Total Current Assets Property, Plant & Equipment Long-term Investments and other LT Assets Goodwill & Other Intangibles Total Assets Accounts Payable Accrued Expenses Unearned Revenue Other Current Liabilities Total Current Liabilities Long-Term Debt Capital Leases Other Non-Current Liabilities Total Liabilities Common Stock Additional Paid In Capital Retained Earnings Treasury Stock Comprehensive Income and Other Total Equity Total Liabilities and Equity 28.0% 4.6% 0.6% 5.3% 8.9% 1.7% 43.9% 11.7% 2.3% 42.1% 100.0% 3.1% 9.0% 0.0% 11.0% 23.1% 25.1% 0.1% 12.2% 60.6% 0.0% 40.9% -0.5% 0.0% -1.0% 39.4% 100.0% 6.1% 13.1% 0.0% 13.1% 27.2% 2.7% 49.1% 9.1% 4.6% 37.3% 100.0% 12.6% 4.4% 0.0% 8.8% 25.8% 53.7% 0.0% 10.6% 90.0% 0.1% 3.9% 12.3% 0.0% -6.4% 10.0% 100.0% 6.8% 0.0% 2.4% 2.4% 22.2% 0.9% 32.2% 64.2% 1.8% 1.8% 100.0% 22.2% 6.1% 1.9% 3.6% 33.8% 29.0% 0.0% 7.1% 70.0% 0.1% 15.0% 16.8% 0.0% -1.9% 30.0% 100.0% 11.5% 5.9% 1.6% 7.5% 8.9% 1.6% 29.6% 67.5% 2.0% 1.0% 100.0% 6.7% 7.7% 1.0% 2.5% 17.9% 0.0% 0.0% 7.8% 25.6% 0.0% 65.4% 9.1% 0.0% -0.2% 74.3% 100.0% 18.1% 0.0% 72.4% 72.4% 0.0% 0.6% 91.1% 2.4% 4.4% 2.2% 100.0% 8.1% 3.1% 0.0% 4.8% 16.0% 30.8% 0.0% 43.2% 89.9% 0.1% 6.7% 4.6% 0.0% -1.3% 10.1% 100.0% 12.4% 1.4% 0.0% 1.4% 0.0% 2.0% 15.8% 0.8% 81.3% 2.0% 100.0% 60.2% 2.9% 0.0% 16.9% 79.9% 11.7% 0.0% 0.4% 92.0% 0.4% 0.0% 6.1% -1.2% 2.6% 8.0% 100.0% 23.6% 10.0% 0.0% 10.0% 12.2% 0.0% 45.8% 37.2% 4.2% 12.7% 100.0% 26.4% 6.8% 6.2% 4.7% 44.1% 18.8% 10.0% 5.9% 78.9% 0.0% 16.3% 6.6% -1.4% -0.4% 21.1% 100.0% 4.8% 2.0% 0.9% 2.9% 1.7% 0.4% 9.7% 11.0% 3.3% 75.9% 100.0% 6.2% 2.9% 0.0% 5.6% 14.7% 44.2% 0.1% 8.4% 67.4% 0.7% 7.2% 11.5% -3.6% 16.8% 32.6% 100.0% 19.0% 5.8% 6.8% 12.5% 1.1% 2.8% 35.4% 8.3% 54.4% 2.0% 100.0% 15.5% 6.4% 2.0% 4.6% 28.5% 25.5% 0.0% 11.5% 65.5% 9.0% 0.0% 25.7% 0.0% -0.2% 34.5% 100.0% 27.6% 9.2% 1.4% 10.5% 8.3% 2.3% 48.7% 37.0% 9.7% 4.6% 100.0% 3.0% 4.6% 0.0% 14.6% 22.3% 0.9% 0.0% 5.7% 28.9% 0.3% 1.5% 71.5% -2.1% -0.1% 71.1% 100.0% Income Statement Revenue Cost of Goods Sold Selling, General & Admin Exp. R&D Exp. Depreciation & Amort. Other Operating Expenses/Income Interest Expense Other Expenses & Revenues Income Tax Expense Other 100.0% 33.8% 50.3% 0.0% 0.0% 0.0% -1.1% -3.1% 5.6% 0.0% 6.1% 100.0% 58.7% 24.1% 1.0% 1.9% 3.1% 2.7% 3.3% 7.3% -9.8% 1.0% 100.0% 71.1% 19.7% 0.0% 3.1% 0.0% -0.8% -0.3% 1.0% 0.0% 4.1% 100.0% 41.9% 38.4% 0.0% 5.9% 0.2% 0.0% -0.3% 2.0% 0.0% 11.7% 100.0% 0.0% 49.3% 0.0% 3.7% -23.9% 4.1% 1.8% 13.1% 0.0% 7.6% 100.0% 0.0% 5.7% 0.0% 0.0% -18.2% 0.0% -2.8% 5.7% -41.5% 26.1% 100.0% 56.8% 21.9% 12.7% 6.1% 0.1% 0.5% 0.2% 0.4% 0.0% 1.8% 100.0% 37.9% 32.2% 0.0% 0.0% -1.3% -8.2% -3.3% 3.4% -2.1% 14.2% 100.0% 57.6% 6.7% 5.1% 4.4% 0.0% 1.3% 2.7% 7.2% 0.6% 21.2% 100.0% 54.0% 16.3% 6.8% 0.4% 0.2% 0.5% 0.6% 5.8% -0.4% 17.3% Net Income Ratios ROE Profit Margin Asset Turnover 37.10% 21.2% (RRRRRR 11.00% 26.1% 0.046258661x 1.20% 4.662672161x ROA 0 LT Asset Turnover Inventory Turnover Days Inventory held AR Turnover Days Sales Outstanding AP Turnover Days Payables Outstanding o Working Capital Turnover Leverage ratio Current Ratio Quick Ratio RRRRR 11.10% 6.1% 0.9x 8.50% 6.9x 3.1x 117 16.9x 21.6 10.1x 36 0.24x 1.5x 1.8x 1.4x 6.70% 1.0% 0.90%x 8.40% 9.8x 2.1x 172.8 7.4x 48.9 4.9x 75.1 0.23x 9.Ox 1.9x 0.7x 14.10% 7.6% 0.2x 1.60% Ox 0 0 0.0x 25.80% 4.1% 1.9x 7.20% 2.9x 6x 61.6 Ox 0 6.4x 57.4 -0.57x 2.3x 1x 0.3x 22.80% 11.7% 1.5x 12.50% 2.2x 8x 45.4 24.5x 14.9 10.5x 34.8 5.48x 0.3x 1.7x 1.1x 12.90% 1.8% 1.7x 2.40% 4.6x 8.1x 44.8 16.5x 22.1 3.9x 93.9 0.16x 3.7x 1x 0.8x 0.530202273x 131.82 0.0x 0 0.00x 11.5x 0.198058802x 0.172923649x 11.30% 14.2% 0.2x 4.40% 2.1x 5.3x 68.3 11.9x 30.8 1.5x 247.5 -0.03x 2.1x 0.7x 0.5x 0.6x 10.90% 7.9x 41.3x 8.8 12.8x 28.5 2.9x 124 0.01x 1.9x 1.2x 1.1x 20.70% 17.3% 0.8x 11.90% 2.4x 6x 61.2 9.2x 39.6 17.5x 20.9 0.00x 0.4x 2.2x 1.7x 0 0.00x 8.9x 1.8x 1.8x IK IK The Decision Review your matches, enter your rationale, and select a confidence level in each match. Once you are ready, submit your decisions. Good luck! Rationale Confidence Level A SELECT LOW HIGH B SELECT LOW HIGH C SELECT LOW HIGH D SELECT LOW HIGH E SELECT LOW HIGH F. SELECT LOW HIGH G SELECT LOW HIGH H SELECT LOW HIGH I SELECT LOW HIGH SELECT LOW HIGH Return to Analyze Submit Decisions Balance Sheet Cash, Cash Equivalents & ST Investments Accounts Receivable Other Receivables Total Receivables Inventory Other Current Assets Total Current Assets Property, Plant & Equipment Long-term Investments and other LT Assets Goodwill & Other Intangibles Total Assets Accounts Payable Accrued Expenses Unearned Revenue Other Current Liabilities Total Current Liabilities Long-Term Debt Capital Leases Other Non-Current Liabilities Total Liabilities Common Stock Additional Paid In Capital Retained Earnings Treasury Stock Comprehensive Income and Other Total Equity Total Liabilities and Equity 28.0% 4.6% 0.6% 5.3% 8.9% 1.7% 43.9% 11.7% 2.3% 42.1% 100.0% 3.1% 9.0% 0.0% 11.0% 23.1% 25.1% 0.1% 12.2% 60.6% 0.0% 40.9% -0.5% 0.0% -1.0% 39.4% 100.0% 6.1% 13.1% 0.0% 13.1% 27.2% 2.7% 49.1% 9.1% 4.6% 37.3% 100.0% 12.6% 4.4% 0.0% 8.8% 25.8% 53.7% 0.0% 10.6% 90.0% 0.1% 3.9% 12.3% 0.0% -6.4% 10.0% 100.0% 6.8% 0.0% 2.4% 2.4% 22.2% 0.9% 32.2% 64.2% 1.8% 1.8% 100.0% 22.2% 6.1% 1.9% 3.6% 33.8% 29.0% 0.0% 7.1% 70.0% 0.1% 15.0% 16.8% 0.0% -1.9% 30.0% 100.0% 11.5% 5.9% 1.6% 7.5% 8.9% 1.6% 29.6% 67.5% 2.0% 1.0% 100.0% 6.7% 7.7% 1.0% 2.5% 17.9% 0.0% 0.0% 7.8% 25.6% 0.0% 65.4% 9.1% 0.0% -0.2% 74.3% 100.0% 18.1% 0.0% 72.4% 72.4% 0.0% 0.6% 91.1% 2.4% 4.4% 2.2% 100.0% 8.1% 3.1% 0.0% 4.8% 16.0% 30.8% 0.0% 43.2% 89.9% 0.1% 6.7% 4.6% 0.0% -1.3% 10.1% 100.0% 12.4% 1.4% 0.0% 1.4% 0.0% 2.0% 15.8% 0.8% 81.3% 2.0% 100.0% 60.2% 2.9% 0.0% 16.9% 79.9% 11.7% 0.0% 0.4% 92.0% 0.4% 0.0% 6.1% -1.2% 2.6% 8.0% 100.0% 23.6% 10.0% 0.0% 10.0% 12.2% 0.0% 45.8% 37.2% 4.2% 12.7% 100.0% 26.4% 6.8% 6.2% 4.7% 44.1% 18.8% 10.0% 5.9% 78.9% 0.0% 16.3% 6.6% -1.4% -0.4% 21.1% 100.0% 4.8% 2.0% 0.9% 2.9% 1.7% 0.4% 9.7% 11.0% 3.3% 75.9% 100.0% 6.2% 2.9% 0.0% 5.6% 14.7% 44.2% 0.1% 8.4% 67.4% 0.7% 7.2% 11.5% -3.6% 16.8% 32.6% 100.0% 19.0% 5.8% 6.8% 12.5% 1.1% 2.8% 35.4% 8.3% 54.4% 2.0% 100.0% 15.5% 6.4% 2.0% 4.6% 28.5% 25.5% 0.0% 11.5% 65.5% 9.0% 0.0% 25.7% 0.0% -0.2% 34.5% 100.0% 27.6% 9.2% 1.4% 10.5% 8.3% 2.3% 48.7% 37.0% 9.7% 4.6% 100.0% 3.0% 4.6% 0.0% 14.6% 22.3% 0.9% 0.0% 5.7% 28.9% 0.3% 1.5% 71.5% -2.1% -0.1% 71.1% 100.0% Income Statement Revenue Cost of Goods Sold Selling, General & Admin Exp. R&D Exp. Depreciation & Amort. Other Operating Expenses/Income Interest Expense Other Expenses & Revenues Income Tax Expense Other 100.0% 33.8% 50.3% 0.0% 0.0% 0.0% -1.1% -3.1% 5.6% 0.0% 6.1% 100.0% 58.7% 24.1% 1.0% 1.9% 3.1% 2.7% 3.3% 7.3% -9.8% 1.0% 100.0% 71.1% 19.7% 0.0% 3.1% 0.0% -0.8% -0.3% 1.0% 0.0% 4.1% 100.0% 41.9% 38.4% 0.0% 5.9% 0.2% 0.0% -0.3% 2.0% 0.0% 11.7% 100.0% 0.0% 49.3% 0.0% 3.7% -23.9% 4.1% 1.8% 13.1% 0.0% 7.6% 100.0% 0.0% 5.7% 0.0% 0.0% -18.2% 0.0% -2.8% 5.7% -41.5% 26.1% 100.0% 56.8% 21.9% 12.7% 6.1% 0.1% 0.5% 0.2% 0.4% 0.0% 1.8% 100.0% 37.9% 32.2% 0.0% 0.0% -1.3% -8.2% -3.3% 3.4% -2.1% 14.2% 100.0% 57.6% 6.7% 5.1% 4.4% 0.0% 1.3% 2.7% 7.2% 0.6% 21.2% 100.0% 54.0% 16.3% 6.8% 0.4% 0.2% 0.5% 0.6% 5.8% -0.4% 17.3% Net Income Ratios ROE Profit Margin Asset Turnover 37.10% 21.2% (RRRRRR 11.00% 26.1% 0.046258661x 1.20% 4.662672161x ROA 0 LT Asset Turnover Inventory Turnover Days Inventory held AR Turnover Days Sales Outstanding AP Turnover Days Payables Outstanding o Working Capital Turnover Leverage ratio Current Ratio Quick Ratio RRRRR 11.10% 6.1% 0.9x 8.50% 6.9x 3.1x 117 16.9x 21.6 10.1x 36 0.24x 1.5x 1.8x 1.4x 6.70% 1.0% 0.90%x 8.40% 9.8x 2.1x 172.8 7.4x 48.9 4.9x 75.1 0.23x 9.Ox 1.9x 0.7x 14.10% 7.6% 0.2x 1.60% Ox 0 0 0.0x 25.80% 4.1% 1.9x 7.20% 2.9x 6x 61.6 Ox 0 6.4x 57.4 -0.57x 2.3x 1x 0.3x 22.80% 11.7% 1.5x 12.50% 2.2x 8x 45.4 24.5x 14.9 10.5x 34.8 5.48x 0.3x 1.7x 1.1x 12.90% 1.8% 1.7x 2.40% 4.6x 8.1x 44.8 16.5x 22.1 3.9x 93.9 0.16x 3.7x 1x 0.8x 0.530202273x 131.82 0.0x 0 0.00x 11.5x 0.198058802x 0.172923649x 11.30% 14.2% 0.2x 4.40% 2.1x 5.3x 68.3 11.9x 30.8 1.5x 247.5 -0.03x 2.1x 0.7x 0.5x 0.6x 10.90% 7.9x 41.3x 8.8 12.8x 28.5 2.9x 124 0.01x 1.9x 1.2x 1.1x 20.70% 17.3% 0.8x 11.90% 2.4x 6x 61.2 9.2x 39.6 17.5x 20.9 0.00x 0.4x 2.2x 1.7x 0 0.00x 8.9x 1.8x 1.8x IK IK The Decision Review your matches, enter your rationale, and select a confidence level in each match. Once you are ready, submit your decisions. Good luck! Rationale Confidence Level A SELECT LOW HIGH B SELECT LOW HIGH C SELECT LOW HIGH D SELECT LOW HIGH E SELECT LOW HIGH F. SELECT LOW HIGH G SELECT LOW HIGH H SELECT LOW HIGH I SELECT LOW HIGH SELECT LOW HIGH Return to Analyze Submit Decisions