Common-size analysis- Given the information presented a) Complete these tables u
ID: 2438518 • Letter: C
Question
Common-size analysis- Given the information presented a) Complete these tables using common-size analysis; b) Summarize the highlights from common-size analysis for Under Armour and indicate possible red flags underneath the financial stataments. Income statement - Common Size UNDER ARMOUR Amounts (in 000s) Percentages For year ended 12/31/2015 12/31/2015 Net revenues $3,963,313 100% Cost of goods sold (2,057,766) ?% Gross profit 1,905,547 ?% Selling, general and administrative expenses (1,497,000) ?% Income from operations 408,547 ?% Interest expense, net (14,628) ?% Other expense, net (7,234) ?% Income before income taxes 386,685 ?% Provision for income taxes (154,112) ?% Net income $232,573 ?% Balance sheets - Common Size UNDER ARMOUR Amounts (in 000s) Percentages For year ended 12/31/2015 12/31/2014 12/31/2015 12/31/2014 Assets Cash and cash equivalents $ 129,852 $ 593,175 ?% ?% Accounts receivable, net 433,638 279,835 ?% ?% Inventories 783,031 536,714 ?% ?% Prepaid expenses and other current assets 152,242 87,177 ?% ?% Deferred income taxes - 52,498 ?% ?% Total Current Assets 1,498,763 1,549,399 ?% ?% Property and equipment, net 538,531 305,564 ?% ?% Goodwill 585,181 123,256 ?% ?% Intangible assets, net 75,686 26,230 ?% ?% Deferred income taxes 92,157 33,570 ?% ?% Other long-term assets 78,582 57,064 ?% ?% Total Assets $ 2,868,900 $ 2,095,083 100% 100% Liabilities and Stockholders' Equity Accounts payable $ 200,460 $ 210,432 ?% ?% Accrued expenses 192,935 147,681 ?% ?% Current maturities of long term - debt 42,000 28,951 ?% ?% Other current liabilities 43,415 34,563 ?% ?% Total Current Liabilities 478,810 421,627 ?% ?% Long-term debt, net of current maturities 352,000 255,250 ?% ?% Long-term line of credit, noncurrent 275,000 - ?% ?% Other long-term liabilities 94,868 67,906 ?% ?% Total Liabilities 1,200,678 744,783 ?% ?% Stockholders' Equity Additional paid-in capital 636,630 508,350 ?% ?% Retained earnings 1,076,533 856,687 ?% ?% Accumulated other comprehensive loss (44,941) (14,737) ?% ?% Total Stockholders' Equity 1,668,222 1,350,300 ?% ?% Total Liabilities and Stockholders' Equity $ 2,868,900 $ 2,095,083 100% 100% (2) Given the information presented above, calculate the DuPont Model for Under Armour for the year ended at Dec. 31, 2015. Must show equations and detailed calculations underneath the table. Under Armour INC. Profit Margin (PM) Asset Turnover (AT) Return on Assets (ROA) Financial Leverage (FL) Return on Equity (ROE) Common-size analysis- Given the information presented a) Complete these tables using common-size analysis; b) Summarize the highlights from common-size analysis for Under Armour and indicate possible red flags underneath the financial stataments. Income statement - Common Size UNDER ARMOUR Amounts (in 000s) Percentages For year ended 12/31/2015 12/31/2015 Net revenues $3,963,313 100% Cost of goods sold (2,057,766) ?% Gross profit 1,905,547 ?% Selling, general and administrative expenses (1,497,000) ?% Income from operations 408,547 ?% Interest expense, net (14,628) ?% Other expense, net (7,234) ?% Income before income taxes 386,685 ?% Provision for income taxes (154,112) ?% Net income $232,573 ?%Explanation / Answer
Solution:
Income statement - Common Size UNDER ARMOUR Amounts (in 000s) Percentages For year ended 12/31/2015 12/31/2015 Net revenues 39,63,313 100% Cost of goods sold -20,57,766 -51.92% Gross profit 19,05,547 48.08% Selling general and administrative expenses -14,97,000 -37.77% Income from operations 4,08,547 10.31% Interest expense net -14,628 -0.37% Other expense net -7,234 -0.18% Income before income taxes 3,86,685 9.76% Provision for income taxes -1,54,112 -3.89% Net income 2,32,573 5.87% Balance sheets - Common Size UNDER ARMOUR Amounts (in 000s) Percentages For year ended 12/31/2015 12/31/2014 12/31/2015 12/31/2014 Assets Cash and cash equivalents 129852 593175 4.53% 28.31% Accounts receivable net 433638 279835 15.12% 13.36% Inventories 783031 536714 27.29% 25.62% Prepaid expenses and other current assets 152242 87177 5.31% 4.16% Deferred income taxes 0 52498 0.00% 2.51% Total Current Assets 1498763 1549399 52.24% 73.95% Property and equipment net 538531 305564 18.77% 14.58% Goodwill 585181 123256 20.40% 5.88% Intangible assets net 75686 26230 2.64% 1.25% Deferred income taxes 92157 33570 3.21% 1.60% Other long-term assets 78582 57064 2.74% 2.72% Total Assets 2868900 2095083 100% 100% Liabilities and Stockholders' Equity Accounts payable 200460 210432 6.99% 10.04% Accrued expenses 192935 147681 6.73% 7.05% Current maturities of long term - debt 42000 28951 1.46% 1.38% Other current liabilities 43415 34563 1.51% 1.65% Total Current Liabilities 478810 421627 16.69% 20.12% Long-term debt net of current maturities 352000 255250 12.27% 12.18% Long-term line of credit noncurrent 275000 0 9.59% 0.00% Other long-term liabilities 94868 67906 3.31% 3.24% Total Liabilities 1200678 744783 41.85% 35.55% Stockholders' Equity Additional paid-in capital 636630 508350 22.19% 24.26% Retained earnings 1076533 856687 37.52% 40.89% Accumulated other comprehensive loss -44941 -14737 -1.57% -0.70% Total Stockholders' Equity 1668222 1350300 58.15% 64.45% Total Liabilities and Stockholders' Equity 2868900 2095083 100% 100%Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.