Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PLEASE HELP CALCULATING THE RATIOS. 4 Ratio Analysis 2017 2016 5 6 7 Liquidity Ratios Current Ratio Quick Ratio Cash Flow Liquidity Ratio 8 9
PLEASE HELP CALCULATING THE RATIOS.
4 Ratio Analysis 2017 2016 5 6 7 Liquidity Ratios Current Ratio Quick Ratio Cash Flow Liquidity Ratio 8 9 10 11 12 13 Activity Ratios Acct Receivable Turnover Days Sales Outstanding Inventory Turnover Acct Payable Turnover Days Payable Outstanding 14 15 16 17 18 19 Leverage Ratios Debt Ratio Debt to Equity Times Interest Earned 20 21 22 23 24 25 26 Profitablity Ratios Gross Profit Margin Operating Profit Margin Net Profit Margin Cash Flow Margin Return on Total Assets Return on Equity 27 28 29 30 31 32 Market Ratios Earning per Share Price to Earnings Ratio Dividend Yield 33 34 7 2017 2016 8 9 10 11 Assets Cash & Equivalents Merchandise Inventory Other Total Current Assets Property & Equipment Other Assets Total Assets 12 1,074 3,795 378 5,247 8,103 224 13,574 7.9% 28.0% 2.8% 38.7% 59.7% 1.7% 100.0% 707 4,038 331 5,076 8,308 222 13,606 5.2% 29.7% 2.4% 37.3% 61.1% 1.6% 100.0% 13 14 15 16 17 18 11.1% 9.2% 1,507 1,224 19 20 112 21 Liabilities Accounts payable Accrued liabilities Income taxes payable Current portion of capital lease and financing obligatic Total current liabilities Long-term capital leases, financing obligation and note Long term debt Deferred income taxes Other long-term liabilities Total liabilities 9.0% 0.8% 1.0% 21.9% 12.4% 22 1,251 1,206 130 127 2,714 1,789 2,792 257 563 8,115 23 131 2,974 1,685 2,795 272 671 8,397 8.9% 1.0% 0.9% 19.9% 13.1% 20.5% 1.9% 4.1% 59.6% 24 25 20.6% 2.0% 4.9% 61.9% 26 27 28 4 4 29 Stockholders' equity 30 Common Stock 31 Paid-in capital 32 Treasury stock 33 Accumulated other comprehensive loss 34 Retained earnings 35 Total stockholders' equity 36 Total liabilities and stockholders' equity 3,003 -10,338 -14 12,522 5,177 13,574 0.0% 22.1% -76.2% -0.1% 92.2% 38.1% 100.0% 2,944 -9,769 -17 12,329 5,491 13,606 0.0% 21.6% -71.8% -0.1% 90.6% 40.4% 100.0% UJ 2017 2016 % Change B 1 1,074 3,795 378 5,247 8,103 224 13,574 707 4,038 331 5,076 8,308 222 13,606 51.9% -6.0% 14.2% 3.4% -2.5% 0.9% -0.2% 3 6 1,507 1,224 112 1,251 1,206 130 Assets Cash & Equivalents Merchandise Inventory 0 Other Total Current Assets 2 Property & Equipment Other Assets 4 Total Assets 5 Liabilities 7 Accounts payable 8 Accrued liabilities Income taxes payable 0 Current portion of capital lease and financing obligations -1 Total current liabilities 2 Long-term capital leases, financing obligation and note payable 3 Long term debt 4 Deferred income taxes 5 Other long-term liabilities 6 Total liabilities 7 8 Stockholders' equity 9 Common Stock 0 Paid-in capital -1 Treasury stock 2 Accumulated other comprehensive loss 3 Retained earnings 4 Total stockholders' equity 5 Total liabilities and stockholders' equity 20.5% 1.5% -13.8% 3.1% 9.6% -5.8% 131 2,974 1,685 2,795 272 671 8,397 127 2,714 1,789 2,792 257 563 8,115 0.1% 5.8% 19.2% 3.5% 4 4 3,003 -10,338 -14 12,522 5,177 13,574 2,944 -9,769 -17 12,329 5,491 13,606 0.0% 2.0% 5.8% -17.6% 1.6% -5.7% -0.2% Net Revenues 2014 19,023 12,098 2015 19,204 12,265 100.0% 100.0% 63.6% 2016 18,686 11,944 100.0% Cost of Merchandise Sold 63.9% 63.9% =Gross Profit 6,925 36.4% 6,939 36.1% 6,742 36.1% 22.9% 23.2% 23.7% 4,350 886 4,452 934 4,435 938 Sell, Gen & Admin Exp Depreciation and amortization Impairments, store closing and other costs =Operating Income 186 1,689 8.9% 1,553 8.1% 1,183 6.3% 340 1.8% 327 1.7% 308 1.6% Interest Expense Other Expense 0.0% 169 0.9% 0 0.0% =Income before taxes 1,349 7.1% 1,057 5.5% 875 4.7% Provision for income taxes 482 2.5% 384 2.0% 319 1.7% =Net Income 867 4.6% 673 3.5% 556 3.0% 6 2014 19,023 12,098 % Change 1.0% 7 2015 19,204 12,265 Net Revenues Cost of Merchandise Sold % Change -2.7% 2016 18,686 11,944 8 1.4% -2.6% 9 10 =Gross Profit 6,925 6,939 0.2% 6,742 -2.8% 11 12 2.3% -0.4 4,350 886 4,452 934 13 Sell, Gen & Admin Exp Depreciation and amortization Impairments, store closing and other costs =Operating Income 4,435 938 186 14 15 1,689 1,553 -8.1% 1,183 -31.3% 16 17 340 327 (3.8%) 308 -5.8 Interest Expense Other Expense 18 0 169 0 -100.0 19 20 =Income before taxes 1,349 1,057 -21.6% 875 -17.2% 21 22 Provision for income taxes 482 384 -20.3% 319 -16.9 23 24 =Net Income 867 673 -22.4% 556 -17.4 $ 556 $ 673 $ 867 938 41 (5) 13 934 48 (10) (38) 24 169 886 48 (3) 49 30 31 57 249 (45) 256 81 (23) 2,148 (215) 43 (260) 53 53 1,474 68 (30) 146 30 (68) 2,024 (768) (690) Operating activities Net income Adjustments to reconcile net income to net cash provided by operating activities: Depreciation and amortization Share-based compensation Excess tax benefits from share-based compensation Deferred income taxes Other non-cash expenses, net Loss on extinguishment of debt Impairments, store closing and other costs Changes in operating assets and liabilities: Merchandise inventories Other current and long-term assets Accounts payable Accrued and other long-term liabilities Income taxes Net cash provided by operating activities Investing activities Acquisition of property and equipment Sales of investments in auction rate securities Other Net cash used in investing activities Financing activities Treasury stock purchases Shares withheld for taxes on vested restricted shares Dividends paid Proceeds from issuance of debt, net Reduction of long-term borrowings Premium paid on redemption of debt Capital lease and financing obligation payments Proceeds from stock option exercises Excess tax benefits from share-based compensation Proceeds from financing obligations Net cash used in financing activities Net increase (decrease) in cash and cash equivalents Cash and cash equivalents at beginning of period Cash and cash equivalents at end of period Supplemental information Interest paid, net of capitalized interest Income taxes paid Non-Cash investing and financing activities Property and equipment acquired through additional liabilities (682) 82 7 (593) 12 (756) 9 (681) (557) (1,001) (677) (17) (27) (19) (358) (349) (317) 1,088 (1,085) (163) (127) (114) (114) 18 147 123 5 10 3 11 6 (1,025) (1,493) (995) 367 (700) 436 707 1,407 971 $ 1,074 $ 707 $ 1,407 1 $ 299 $ 314 318 $ 372 329 502 $ 54 $ 63 $ 41 4 Ratio Analysis 2017 2016 5 6 7 Liquidity Ratios Current Ratio Quick Ratio Cash Flow Liquidity Ratio 8 9 10 11 12 13 Activity Ratios Acct Receivable Turnover Days Sales Outstanding Inventory Turnover Acct Payable Turnover Days Payable Outstanding 14 15 16 17 18 19 Leverage Ratios Debt Ratio Debt to Equity Times Interest Earned 20 21 22 23 24 25 26 Profitablity Ratios Gross Profit Margin Operating Profit Margin Net Profit Margin Cash Flow Margin Return on Total Assets Return on Equity 27 28 29 30 31 32 Market Ratios Earning per Share Price to Earnings Ratio Dividend Yield 33 34 7 2017 2016 8 9 10 11 Assets Cash & Equivalents Merchandise Inventory Other Total Current Assets Property & Equipment Other Assets Total Assets 12 1,074 3,795 378 5,247 8,103 224 13,574 7.9% 28.0% 2.8% 38.7% 59.7% 1.7% 100.0% 707 4,038 331 5,076 8,308 222 13,606 5.2% 29.7% 2.4% 37.3% 61.1% 1.6% 100.0% 13 14 15 16 17 18 11.1% 9.2% 1,507 1,224 19 20 112 21 Liabilities Accounts payable Accrued liabilities Income taxes payable Current portion of capital lease and financing obligatic Total current liabilities Long-term capital leases, financing obligation and note Long term debt Deferred income taxes Other long-term liabilities Total liabilities 9.0% 0.8% 1.0% 21.9% 12.4% 22 1,251 1,206 130 127 2,714 1,789 2,792 257 563 8,115 23 131 2,974 1,685 2,795 272 671 8,397 8.9% 1.0% 0.9% 19.9% 13.1% 20.5% 1.9% 4.1% 59.6% 24 25 20.6% 2.0% 4.9% 61.9% 26 27 28 4 4 29 Stockholders' equity 30 Common Stock 31 Paid-in capital 32 Treasury stock 33 Accumulated other comprehensive loss 34 Retained earnings 35 Total stockholders' equity 36 Total liabilities and stockholders' equity 3,003 -10,338 -14 12,522 5,177 13,574 0.0% 22.1% -76.2% -0.1% 92.2% 38.1% 100.0% 2,944 -9,769 -17 12,329 5,491 13,606 0.0% 21.6% -71.8% -0.1% 90.6% 40.4% 100.0% UJ 2017 2016 % Change B 1 1,074 3,795 378 5,247 8,103 224 13,574 707 4,038 331 5,076 8,308 222 13,606 51.9% -6.0% 14.2% 3.4% -2.5% 0.9% -0.2% 3 6 1,507 1,224 112 1,251 1,206 130 Assets Cash & Equivalents Merchandise Inventory 0 Other Total Current Assets 2 Property & Equipment Other Assets 4 Total Assets 5 Liabilities 7 Accounts payable 8 Accrued liabilities Income taxes payable 0 Current portion of capital lease and financing obligations -1 Total current liabilities 2 Long-term capital leases, financing obligation and note payable 3 Long term debt 4 Deferred income taxes 5 Other long-term liabilities 6 Total liabilities 7 8 Stockholders' equity 9 Common Stock 0 Paid-in capital -1 Treasury stock 2 Accumulated other comprehensive loss 3 Retained earnings 4 Total stockholders' equity 5 Total liabilities and stockholders' equity 20.5% 1.5% -13.8% 3.1% 9.6% -5.8% 131 2,974 1,685 2,795 272 671 8,397 127 2,714 1,789 2,792 257 563 8,115 0.1% 5.8% 19.2% 3.5% 4 4 3,003 -10,338 -14 12,522 5,177 13,574 2,944 -9,769 -17 12,329 5,491 13,606 0.0% 2.0% 5.8% -17.6% 1.6% -5.7% -0.2% Net Revenues 2014 19,023 12,098 2015 19,204 12,265 100.0% 100.0% 63.6% 2016 18,686 11,944 100.0% Cost of Merchandise Sold 63.9% 63.9% =Gross Profit 6,925 36.4% 6,939 36.1% 6,742 36.1% 22.9% 23.2% 23.7% 4,350 886 4,452 934 4,435 938 Sell, Gen & Admin Exp Depreciation and amortization Impairments, store closing and other costs =Operating Income 186 1,689 8.9% 1,553 8.1% 1,183 6.3% 340 1.8% 327 1.7% 308 1.6% Interest Expense Other Expense 0.0% 169 0.9% 0 0.0% =Income before taxes 1,349 7.1% 1,057 5.5% 875 4.7% Provision for income taxes 482 2.5% 384 2.0% 319 1.7% =Net Income 867 4.6% 673 3.5% 556 3.0% 6 2014 19,023 12,098 % Change 1.0% 7 2015 19,204 12,265 Net Revenues Cost of Merchandise Sold % Change -2.7% 2016 18,686 11,944 8 1.4% -2.6% 9 10 =Gross Profit 6,925 6,939 0.2% 6,742 -2.8% 11 12 2.3% -0.4 4,350 886 4,452 934 13 Sell, Gen & Admin Exp Depreciation and amortization Impairments, store closing and other costs =Operating Income 4,435 938 186 14 15 1,689 1,553 -8.1% 1,183 -31.3% 16 17 340 327 (3.8%) 308 -5.8 Interest Expense Other Expense 18 0 169 0 -100.0 19 20 =Income before taxes 1,349 1,057 -21.6% 875 -17.2% 21 22 Provision for income taxes 482 384 -20.3% 319 -16.9 23 24 =Net Income 867 673 -22.4% 556 -17.4 $ 556 $ 673 $ 867 938 41 (5) 13 934 48 (10) (38) 24 169 886 48 (3) 49 30 31 57 249 (45) 256 81 (23) 2,148 (215) 43 (260) 53 53 1,474 68 (30) 146 30 (68) 2,024 (768) (690) Operating activities Net income Adjustments to reconcile net income to net cash provided by operating activities: Depreciation and amortization Share-based compensation Excess tax benefits from share-based compensation Deferred income taxes Other non-cash expenses, net Loss on extinguishment of debt Impairments, store closing and other costs Changes in operating assets and liabilities: Merchandise inventories Other current and long-term assets Accounts payable Accrued and other long-term liabilities Income taxes Net cash provided by operating activities Investing activities Acquisition of property and equipment Sales of investments in auction rate securities Other Net cash used in investing activities Financing activities Treasury stock purchases Shares withheld for taxes on vested restricted shares Dividends paid Proceeds from issuance of debt, net Reduction of long-term borrowings Premium paid on redemption of debt Capital lease and financing obligation payments Proceeds from stock option exercises Excess tax benefits from share-based compensation Proceeds from financing obligations Net cash used in financing activities Net increase (decrease) in cash and cash equivalents Cash and cash equivalents at beginning of period Cash and cash equivalents at end of period Supplemental information Interest paid, net of capitalized interest Income taxes paid Non-Cash investing and financing activities Property and equipment acquired through additional liabilities (682) 82 7 (593) 12 (756) 9 (681) (557) (1,001) (677) (17) (27) (19) (358) (349) (317) 1,088 (1,085) (163) (127) (114) (114) 18 147 123 5 10 3 11 6 (1,025) (1,493) (995) 367 (700) 436 707 1,407 971 $ 1,074 $ 707 $ 1,407 1 $ 299 $ 314 318 $ 372 329 502 $ 54 $ 63 $ 41Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started