Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need the following ratios computed 2017 Ratio Calculations Equations Current ratio / = current assets / current liabilities Debt/equity ratio / = % total

I need the following ratios computed

2017
Ratio Calculations Equations
Current ratio / = current assets / current liabilities
Debt/equity ratio / = % total liabilities / total equity
Free cash flow - = $ total operating cash flow - capital expenditures
Earnings per share / = $ net income / common shares outstanding
Price/earnings ratio (Stock price 3.16) / = stock price / earnings per share
Return on equity / = % net income / total equity
Net profit margin / = % net income / total revenue
2016
Ratio Calculations Equations
Current ratio / = current assets / current liabilities
Debt/equity ratio / = % total liabilities / total equity
Free cash flow - = $ total operating cash flow - capital expenditures
Earnings per share / = $ net income / common shares outstanding
Price/earnings ratio (Stock Price 8.31) / = stock price / earnings per share
Return on equity / = % net income / total equity
Net profit margin / = % net income / total revenue
2015
Ratio Calculations Equations
Current ratio / = current assets / current liabilities
Debt/equity ratio / = % total liabilities / total equity
Free cash flow - = $ total operating cash flow - capital expenditures
Earnings per share / = $ net income / common shares outstanding
Price/earnings ratio (Stock Price 6.66) / = stock price / earnings per share
Return on equity / = % net income / total equity
Net profit margin / = % net income / total revenue

3 year balance sheet

Report Date 02/03/2018 01/28/2017 01/30/2016
Currency USD USD USD
Audit Status Not Qualified Not Qualified Not Qualified
Consolidated Yes Yes Yes
Scale Thousands Thousands Thousands
Cash in banks & in transit 116000 125000 119000
Cash short-term investments 342000 762000 781000
Cash & cash equivalents 458000 887000 900000
Merchandise inventory 2762000 2854000 2721000
Deferred taxes - 196000 231000
Prepaid expenses & other current assets 190000 160000 166000
Total current assets 3410000 4097000 4018000
Land 245000 249000 272000
Buildings 4750000 4859000 4877000
Furniture & equipment 1603000 1963000 2064000
Leasehold improvements 1068000 1254000 1244000
Capital leases (equipment) 115000 116000 116000
Accumulated depreciation 3500000 3842000 3757000
Property & equipment 4281000 4599000 4816000
Prepaid pension 61000 - -
Capitalized software, net 300000 265000 232000
Indefinite-lived intangible assets, net 275000 275000 268000
Revolving credit facility unamortized costs, net 28000 30000 42000
Interest rate swaps 9000 - -
Realty investments 5000 13000 31000
Other assets 44000 35000 35000
Other assets 661000 618000 608000
Total assets 8413000 9314000 9442000
Merchandise accounts payable 973000 977000 925000
Accrued salaries, vacation & bonus 193000 204000 326000
Customer gift cards 203000 215000 222000
Taxes other than income taxes 102000 127000 110000
Occupancy & rent-related 28000 35000 40000
Interest payable 67000 78000 88000
Advertising 77000 82000 76000
Current portion of workers' compensation & general liability insurance 44000 47000 55000
Restructuring & management transition 26000 29000 46000
Current portion of retirement plan liabilities 29000 26000 46000
Capital expenditures 58000 33000 13000
Unrecognized tax benefits - 3000 3000
Other accounts payable & accrued expenses 292000 285000 335000
Other accounts payable & accrued expenses 1119000 1164000 1360000
Current portion of capital leases & note payable - 15000 26000
Current portion of capital leases, financing obligation & note payable 8000 - -
Current maturities of long-term debt 232000 263000 101000
Total current liabilities 2332000 2419000 2412000
Long-term capital leases & note payable - 219000 10000
Long-term capital leases, financing obligation & note payable 212000 - -
Senior notes 1613000 1953000 1500000
Notes 502000 502000 502000
Debentures 323000 543000 634000
Term loan 1625000 1667000 2194000
Total long-term debt, including current maturities 4063000 4665000 4830000
Unamortized debt issuance costs -51000 -63000 -61000
Total debt, excluding capital leases & note payable - 4602000 4769000
Less: current maturities 232000 263000 101000
Long-term debt 3780000 4339000 4668000
Deferred taxes 143000 400000 425000
Supplemental pension & other postretirement benefit plan liabilities 153000 126000 138000
Long-term portion of workers' compensation & general liability insurance 121000 131000 153000
Deferred developer/tenant allowances 139000 143000 113000
Deferred rent liability 97000 97000 91000
Primary pension plan - 18000 40000
Interest rate swaps - 10000 28000
Unrecognized tax benefits - 1000 4000
Restructuring & management transition 15000 2000 5000
Other liabilities 42000 55000 46000
Other liabilities 567000 583000 618000
Total liabilities 7034000 7960000 8133000
Common stock 156000 154000 153000
Additional paid-in capital 4705000 4679000 4654000
Reinvested earnings (accumulated deficit) -3122000 -3006000 -3007000
Net actuarial gain (loss) -330000 -421000 -423000
Prior service credit (cost) -26000 -33000 -38000
Foreign currency translation - -2000 -2000
Gain (loss) on cash flow hedges -4000 -17000 -28000
Accumulated other comprehensive income (loss) -360000 -473000 -491000
Total stockholders' equity 1379000 1354000 1309000

3 year income statement

Report Date 02/03/2018 01/28/2017 01/30/2016
Currency USD USD USD
Audit Status Not Qualified Not Qualified Not Qualified
Consolidated Yes Yes Yes
Scale Thousands Thousands Thousands
Total net sales 12506000 12547000 12625000
Cost of goods sold 8174000 8071000 8074000
Gross margin - 4476000 4551000
Selling, general & administrative expenses 3468000 3538000 3775000
Pension income (expense) -21000 -19000 -162000
Depreciation & amortization expenses 570000 609000 616000
Net gain from sale of non-operating assets - 5000 9000
Investment income from home office land joint venture 31000 28000 41000
Net gain from sale of operating assets 119000 73000 9000
Store & other asset impairments - - 20000
Other real estate other expense (income) 4000 -5000 42000
Real estate & other income (expense), net 146000 111000 3000
Restructuring & management transition 303000 26000 84000
Total costs & expenses 12390000 - -
Total operating expenses - 4081000 4640000
Operating income (loss) 116000 395000 -89000
Gain (loss) on extinguishment of debt -33000 -30000 -10000
Net interest income (expense) -325000 -363000 -405000
Income (loss) before income taxes -242000 2000 -504000
Current federal & foreign income tax expense (benefit) -64000 -12000 5000
Current state & local income tax expense (benefit) 22000 4000 6000
Total current income tax expense (benefit) -42000 -8000 11000
Deferred federal & foreign income tax expense (benefit) -59000 9000 -1000
Deferred state & local income tax expense (benefit) -25000 - -1000
Total deferred income tax expense (benefit) -84000 9000 -2000
Income tax expense (benefit) -126000 1000 9000
Net income (loss) -116000 1000 -513000
Weighted average shares outstanding - basic 311100 308100 305900
Weighted average shares outstanding - diluted 311100 313000 305900
Year end shares outstanding 312000 308300 306100
Net earnings (loss) per share - basic -0.37 0 -1.68
Net earnings (loss) per share - diluted -0.37 0 -1.68
Total number of employees 98000 106000 105000
Number of common stockholders 21995 23320 24791
Foreign currency translation adjustments 2000 - -

3 year cash flow

Report Date 02/03/2018 01/28/2017 01/30/2016
Currency USD USD USD
Audit Status Not Qualified Not Qualified Not Qualified
Consolidated Yes Yes Yes
Scale Thousands Thousands Thousands
Net income (loss) -116000 1000 -513000
Restructuring & management transition 74000 -1000 10000
Asset impairments & other charges 6000 3000 25000
Net loss (gain) on sale or redemption of non-operating assets - -5000 -9000
Net loss (gain) on sale of operating assets -119000 -73000 -9000
Loss on extinguishment of debt 33000 30000 10000
Depreciation & amortization 570000 609000 616000
Benefit plans expense (income) 106000 -39000 127000
Stock-based compensation 25000 35000 44000
Other comprehensive income tax expense (benefits) -60000 -12000 -
Deferred taxes -63000 9000 -
Inventory 92000 -133000 -69000
Prepaid expenses & other assets -15000 11000 19000
Merchandise accounts payable -4000 52000 -72000
Income taxes -12000 -6000 4000
Accrued expenses & other liabilities -63000 -147000 257000
Net cash flows from operating activities 454000 334000 440000
Capital expenditures -395000 -427000 -320000
Proceeds from sale or redemption of non-operating assets - 2000 13000
Proceeds from sale of operating assets 154000 96000 11000
Joint venture return of investment 9000 13000 -
Insurance proceeds received for damage of property & equipment 3000 - -
Net cash flows from investing activities -229000 -316000 -296000
Proceeds from issuance of long-term debt - 2188000 -
Proceeds from borrowings under the credit facility 804000 667000 -
Payments of borrowings under the credit facility -804000 -667000 -
Net proceeds from financing obligation - 216000 -
Premium on early retirement of debt -30000 - -
Payments of capital leases & note payable - -29000 -33000
Payments of capital leases, financing obligation & note payable -16000 - -
Payments of long-term debt -599000 -2349000 -520000
Financing costs -9000 -49000 -4000
Proceeds from stock options exercised - 2000 -
Proceeds from stock issued under stock plans 5000 - -
Tax withholding payments for vested restricted stock -5000 -10000 -5000
Net cash flows from financing activities -654000 -31000 -562000
Net increase (decrease) in cash & cash equivalents -429000 -13000 -418000
Cash & cash equivalents at beginning of period 887000 900000 1318000
Cash & cash equivalents at end of period 458000 887000 900000
Income taxes paid (received), net 9000 10000 5000
Interest paid, net 302000 344000 33

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

Students also viewed these Finance questions

Question

find all matrices A (a) A = 13 (b) A + A = 213

Answered: 1 week ago