Under Armour Financial Ratins Using the data from the enclosed financial statements prepare the ratios as noted below. All ratios should be calculated using Excel formulas thatrefer to the data in the financial statements. Setup formulas in the mostefficient manner - example use relative/absolute cell references when possible. See instructions on the nextpage for graphing your data Ratio Ratio/Measure Which Financial Statement Formula Format 2015 2014 2013 Conditional Formatting (If noted) Liquidity and Solvency Analysis Current Ratio Working Capital Operating Cash Flow Ratio Number,carry to two decimal places $, no decimal places Number, carry to two decimal places N/A NIA NIA Balance Sheet Current Assets/Current Liabilities Balance Sheet Current Assets - Current Liabilities Cash Flow and Balance Sheet NetCash provided by operating activities/Current Liabilities Cash Flow NetCash Provided By Operating Activities Balance Sheet Total liabilities/Total Stockholders Equity Cash Flow from Operations $.no decimal places $ NIA DebvEquity Number,carry to two decimal places NIA Profitability Analysis Gross Proft Ratio Income Statement Gross ProfiNet Revenues %, carry to two decimal places Apply Color Scale - Green Yellow Red Apply Color Scale - Green Yellow Red Profit Margin Ratio Income Statement Net Income/NetRevenues %, carry to two decimal places Return on Assets Income from operations/Total Assets Income Statement and Balance Sheet %, carry to two decimal places NIA Common Size Income Statement Income Statement Common Size Income Statement- Sparkline's Insert Three Year trend Sparkline For each year provided, calculate %, carry to one decimal place each item as a percentofNet Revenues - example Net Revenues/Netrevenues, Costof Goods Sold/NetRevenues - Note Net revenues will always be in the denominator, and the numerator will For each line item on=n the income = statementshow a three year trend Line Sparkline Calculate the percent %, carry to one decimal place increaseldecrease ofeach line item on the income statement from each year to the next Example (Netrevenues 2015 minus NetRevenues 2014)/Net Revenues 2014 Calculate % Change - Income Statement Income Statement Common Size Common Size Common Common Size % Change % Change Size Three Year Trend (Sparkline) () 2015 2014 2013 2015 from 2014 from |2014 2013 100.0% 51.9% 100.0% 51.0% 49.0% 37.6% 100.0% % 51.3% % 48.7% 37.4% 28.5% 30.9% 26.0% 29.2% 32.3% 31.5% 33.0% 32.9% 48.1% 37.8% Natrevenues Costofgoods sold Gross profit Selling, general and administrative expenses Income from operations Interestexpense, net Other expense, net Income before income taxes Provision for income taxes Netincome 10.3% -0.2% 98% 3.9% 5.9% 11.5% -0.2% -0.2% 11.1% 4.3% 114% -0.1% -0.19% 11.2% 42% 70% 15.49% 174.2% 12.9% 13.0% 14.9% 118% 33.5% 81.9% 446.9% 31.1% 36.0% 28.2% 6.7% Under Armour Financial Ratins Using the data from the enclosed financial statements prepare the ratios as noted below. All ratios should be calculated using Excel formulas thatrefer to the data in the financial statements. Setup formulas in the mostefficient manner - example use relative/absolute cell references when possible. See instructions on the nextpage for graphing your data Ratio Ratio/Measure Which Financial Statement Formula Format 2015 2014 2013 Conditional Formatting (If noted) Liquidity and Solvency Analysis Current Ratio Working Capital Operating Cash Flow Ratio Number,carry to two decimal places $, no decimal places Number, carry to two decimal places N/A NIA NIA Balance Sheet Current Assets/Current Liabilities Balance Sheet Current Assets - Current Liabilities Cash Flow and Balance Sheet NetCash provided by operating activities/Current Liabilities Cash Flow NetCash Provided By Operating Activities Balance Sheet Total liabilities/Total Stockholders Equity Cash Flow from Operations $.no decimal places $ NIA DebvEquity Number,carry to two decimal places NIA Profitability Analysis Gross Proft Ratio Income Statement Gross ProfiNet Revenues %, carry to two decimal places Apply Color Scale - Green Yellow Red Apply Color Scale - Green Yellow Red Profit Margin Ratio Income Statement Net Income/NetRevenues %, carry to two decimal places Return on Assets Income from operations/Total Assets Income Statement and Balance Sheet %, carry to two decimal places NIA Common Size Income Statement Income Statement Common Size Income Statement- Sparkline's Insert Three Year trend Sparkline For each year provided, calculate %, carry to one decimal place each item as a percentofNet Revenues - example Net Revenues/Netrevenues, Costof Goods Sold/NetRevenues - Note Net revenues will always be in the denominator, and the numerator will For each line item on=n the income = statementshow a three year trend Line Sparkline Calculate the percent %, carry to one decimal place increaseldecrease ofeach line item on the income statement from each year to the next Example (Netrevenues 2015 minus NetRevenues 2014)/Net Revenues 2014 Calculate % Change - Income Statement Income Statement Common Size Common Size Common Common Size % Change % Change Size Three Year Trend (Sparkline) () 2015 2014 2013 2015 from 2014 from |2014 2013 100.0% 51.9% 100.0% 51.0% 49.0% 37.6% 100.0% % 51.3% % 48.7% 37.4% 28.5% 30.9% 26.0% 29.2% 32.3% 31.5% 33.0% 32.9% 48.1% 37.8% Natrevenues Costofgoods sold Gross profit Selling, general and administrative expenses Income from operations Interestexpense, net Other expense, net Income before income taxes Provision for income taxes Netincome 10.3% -0.2% 98% 3.9% 5.9% 11.5% -0.2% -0.2% 11.1% 4.3% 114% -0.1% -0.19% 11.2% 42% 70% 15.49% 174.2% 12.9% 13.0% 14.9% 118% 33.5% 81.9% 446.9% 31.1% 36.0% 28.2% 6.7%