Need help with the calculations for the financial ratios document. There are two Jc Penny statements and the financial ratio chart

Financial Ratios Chart Liquidity Current ratio 2011 1.84361393 Industr y average 2012 2013 1.42586 1.69817 2.4 Cash ratio 0.9 Asset Management Inventory turnover in days 3.8 3.8 2.85 57 A/R turnover in days 14 A/P turnover in days 25 Cash conversion cycle 46 Fixed asset turnover ration 3.4 Total asset turnover ration 2.03 Long-Term Debt-Paying Ability Long-term debt to total capitalization 21% Effective interest rate 7.3% Profitability Gross profit margin 27% Operating profit margin 5.8% Net profit margin 2.6% ROA 6.5% ROE 17.1% 1 Financial Ratio Formulas Liquidity Formula Current ratio Current assets / current liabilities Cash ratio (Cash + marketable securities) / current liabilities Asset Management Inventory turnover ratio Cost of goods sold / inventories (average) Inventory turnover in days 365 / inventory turnover ratio 365 / AR turnover A/R turnover in days [AR turnover = net credit sales / average AR] 365 / AP turnover A/P turnover in days [AP turnover = cost of goods sold / Average AP] Cash conversion cycle Inventory turnover in days - AP turnover in days + AR turnover in days Fixed asset turnover ratio Net sales / average fixed (capital) assets Total asset turnover ratio Net sales / average total assets Long-Term Debt Paying Ability Long-Term debt to total capitalization Long-term debt / (long-term debt + common/preferred shares) Effective interest rate Interest expense / total long-term debt Profitability Gross profit margin Gross Profits / Net Sales Operating profit margin Operating income (EBIT) / Net Sales Net profit margin Net income / net sales ROA (return on assets) Net income / total assets Net income / shareholders' equity ROE (return on equity) [shareholders' equity = share capital + retained earnings] 2 3 JC PENNEY CO INC (JCP) All amounts in USD millions. BALANCE SHEETS no data Calendar Year Assets Cash and cash equivalents Short-term investments Total cash Receivables Inventories Deferred income taxes Prepaid expenses Total current assets Non-current assets Property, plant and equipment Land Fixtures and equipment Other properties Property and equipment, at cost Accumulated depreciation Property, plant and equipment, net Intangible assets Prepaid pension costs Other long-term assets Total non-current assets Total assets 2011 no data $ 175 $ 1,332 $ 1,507 $ 413 $ 2,916 $ $ $ $ $ $ $ $ $ $ $ 245 5,081 no data 312 2,173 5,656 8,141 (2,965) 5,176 n no no data 1,167 6,343 11,424 no data 2012 no data $ 121 $ 809 $ 930 $ 57 $ 2,341 $ 106 $ 249 $ 3,683 no data no data $ 310 $ 2,132 $ 5,791 $ 8,233 $ (2,880) $ 5,353 no data no data $ 745 $ 6,098 $ 9,781 no data 2013 no data $ 113 $ 1,402 $ 1,515 $ 4 $ 2,935 $ 193 $ 186 $ 4,833 no data no data $ 309 $ 2,356 $ 6,269 $ 8,934 $ (3,315) $ 5,619 $ 535 $ 663 $ 151 $ 6,968 $ 11,801 Calendar Year Liabilities Short-term debt Capital leases Accounts payable Taxes payable Accrued liabilities Other current liabilities Total current liabilities Non-current liabilities Long-term debt Capital leases Deferred taxes liabilities Pensions and other benefits Other long-term liabilities Total non-current liabilities Total liabilities Stockholders' equity Common stock Additional paid-in capital Retained earnings Accumulated other comprehensive income Total stockholders' equity Total liabilities and stockholders' equity Financial data reporting dates: 2011 $ 231 $ $ $ $ $ 1,022 111 1,038 354 2,756 $ 2012 2013 $ $ 26 1,162 $ $ 1,395 2,583 2,871 $ 2,956 $ 888 $ 388 $ $ $ 899 4,658 7,414 $ $ $ 683 4,027 6,610 $ 108 $ 3,699 $ 1,412 $ (1,209) $ 4,010 $ 11,424 2012-01 $ 110 $ 3,799 $ 380 $ (1,118) $ 3,171 $ 9,781 2013-01 JCP fiscal year is Feb-Jan, so Jan reports reflect mostly prior calendar year financial data. For Financial Ratios calculations please use Calendar Year information listed in this table. $ $ $ $ $ 673 27 948 91 1,107 $ 2,846 $ $ $ $ $ $ $ 4,839 62 335 187 445 5,868 8,714 $ 152 $ 4,571 $ (1,008) $ (628) $ 3,087 $ 11,801 2014-01 JC PENNEY CO INC (JCP) INCOME STATEMENTS All amounts in USD millions. Calendar Year 2011 2012 2013 Revenue $ 17,260 $ 12,985 $ 11,859 Cost of revenue (cost of goods sold) $ 11,042 $ 8,919 $ 8,367 Gross profit $ 6,218 $ 4,066 $ 3,492 Operating expenses No data No data No data Sales, General and administrative $ 5,251 $ 4,535 $ 4,096 Other operating expenses $ 969 $ 841 $ 816 Total operating expenses $ 6,220 $ 5,376 $ 4,912 Operating income $ (2) $ (1,310) $ (1,420) Interest Expense $ 227 $ 226 Other income (expense) No data No data $ (466) Income before income taxes $ (229) $ (1,536) $ 1,886) Provision for income taxes $ (77) $ (551) $ (498) Net income from continuing operations $ (152) $ (985) $ (1,388) Net income from discontinuing ops No data No data No data Net income $ (152) $ (985) $ (1,388) Net income available to common shareholders $ (152) $ (985) $ (1,388) EBITDA $ 516 $ (767) $ (819) Financial data reporting dates: 2012-01 2013-01 JCP fiscal year is Feb-Jan, so Jan reports reflect mostly prior calendar year financial data. For Financial Ratios calculations please use Calendar Year information listed in this table. No data 2014-01