Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sheet 2: Common-size analysis- Given the information presented on Sheet 1, a) Complete these tables using common-size analysis; b) Summarize the highlights from common-size analysis

image text in transcribed

Sheet 2: Common-size analysis- Given the information presented on Sheet 1, a) Complete these tables using common-size analysis; b) Summarize the highlights from common-size analysis for Under Armour and indicate possible red flags following the tables.

Sheet 3: Given the information presented on Sheet 1, calculate the DuPont Model for Under Armour for the year ended at Dec. 31, 2015. Show calculations following the table.

image text in transcribed UNDER ARMOUR INC. Consolidated Statement of Income For 12 Months Ended ($ in 000s) Net revenues Cost of goods sold Gross profit Selling, general and administrative expenses Income from operations Interest expense, net Other expense, net Income before income taxes Provision for income taxes Net income 12/31/2015 $ 3,963,313 (2,057,766) 1,905,547 (1,497,000) 408,547 (14,628) (7,234) 386,685 (154,112) $ 232,573 UNDER ARMOUR INC. Consolidated Balance Sheet $ in 000s Assets Cash and cash equivalents Accounts receivable, net Inventories Prepaid expenses and other current assets Deferred income taxes Total Current Assets Property and equipment, net Goodwill Intangible assets, net Deferred income taxes Other long-term assets Total Assets Liabilities and Stockholders' Equity Accounts payable Accrued expenses Current maturities of long term - debt Other current liabilities Total Current Liabilities Long-term debt, net of current maturities Long-term line of credit, noncurrent Other long-term liabilities Total Liabilities 12/31/2015 12/31/2014 129,852 $ 433,638 783,031 152,242 1,498,763 538,531 585,181 75,686 92,157 78,582 $ 2,868,900 $ 593,175 279,835 536,714 87,177 52,498 1,549,399 305,564 123,256 26,230 33,570 57,064 2,095,083 $ $ 200,460 $ 192,935 42,000 43,415 478,810 352,000 275,000 94,868 1,200,678 210,432 147,681 28,951 34,563 421,627 255,250 67,906 744,783 Stockholders' Equity Additional paid-in capital Retained earnings Accumulated other comprehensive loss Total Stockholders' Equity 636,630 1,076,533 (44,941) 1,668,222 508,350 856,687 (14,737) 1,350,300 Total Liabilities and Stockholders' Equity $ 2,868,900 $ 2,095,083 Name: Student ID: Common-size analysis- Given the information presented on Sheet 1, a) Complete these tables using common-si analysis; b) Summarize the highlights from common-size analysis for Under Armour and indicate possible red following the tables. Income statement - Common Size UNDER ARMOUR For year ended Net revenues Cost of goods sold Gross profit Selling, general and administrative expenses Income from operations Interest expense, net Other expense, net Income before income taxes Provision for income taxes Net income Balance sheets - Common Size UNDER ARMOUR For year ended Assets Cash and cash equivalents Accounts receivable, net Inventories Prepaid expenses and other current assets Deferred income taxes Total Current Assets Property and equipment, net Goodwill Intangible assets, net Deferred income taxes Other long-term assets Total Assets Liabilities and Stockholders' Equity Accounts payable Accrued expenses Current maturities of long term - debt Other current liabilities Amounts (in 000s) 12/31/2015 $ 3,963,313 (2,057,766) 1,905,547 (1,497,000) 408,547 (14,628) (7,234) 386,685 (154,112) $ 232,573 Percentages 12/31/2015 100% Amounts (in 000s) 12/31/2015 12/31/2014 $ $ $ 129,852 $ 433,638 783,031 152,242 1,498,763 538,531 585,181 75,686 92,157 78,582 2,868,900 $ 593,175 279,835 536,714 87,177 52,498 1,549,399 305,564 123,256 26,230 33,570 57,064 2,095,083 200,460 $ 192,935 42,000 43,415 210,432 147,681 28,951 34,563 Total Current Liabilities Long-term debt, net of current maturities Long-term line of credit, noncurrent Other long-term liabilities Total Liabilities 478,810 352,000 275,000 94,868 1,200,678 421,627 255,250 67,906 744,783 Stockholders' Equity Additional paid-in capital Retained earnings Accumulated other comprehensive loss Total Stockholders' Equity 636,630 1,076,533 (44,941) 1,668,222 508,350 856,687 (14,737) 1,350,300 2,868,900 $ 2,095,083 Total Liabilities and Stockholders' Equity $ te these tables using common-size mour and indicate possible red flags Percentages 12/31/2015 12/31/2014 100% 100% 100% 100% Name: Student ID: (2) Given the information presented on Sheet 1, calculate the DuPont Model for Under Armour for the year ended at Dec. 31, 2015. Show calculations following the table. Under Armour INC. Profit Margin (PM) Asset Turnover (AT) Return on Assets (ROA) Financial Leverage (FL) Return on Equity (ROE)

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

Intermediate Accounting

Authors: James D. Stice, Earl K. Stice, Fred Skousen

17th Edition

032459237X, 978-0324592375

Students also viewed these Accounting questions