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

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 06, 2024

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