can you please tell me how to compute Debt-to-Capital ratio for each quarter, Interest Coverage ratio for each quarter and Cash-To-Debt ratio for each quarter between 2011-2012?
AutoSave OD 2 8 + Case_36JC Penney F1720X Excel Search File Home Insert Draw Page Layout Formulas Data Review View Help a X Cut Times New Roman - 12 AA = 23 Wrap Test Copy - BTV - B A E Merge & Center - Format Painter Clipboard Alignment Xf $ % 9 Number 78-98 Font Ethibit 3 J. C. PENNEY COMPANY Quarterly Income Statements, 2011 and 2012 in millions of dollars, except per-share data) 0 Total Reveme 1 Cost of Revenue 3 Gross Profit Operating Expenses Selling. General and Administrative 04 2012 02.2012 02 2012 Q1 2012 04 2011 03 2011 02 2011 01 2011 3,884 2.927 3,022 3.152 5.425 3.086 3.906 3.943 2.960 1975 2,018 1.966 3,788 2.497 2,409 2.348 924 9521 ,004 1,186 1.6371 .489 1.497 1.595 1.209 157 Depreciation and Amortization Other Total Operating Expenses 21 Operating Income 1.087 133 (112) 1.106 (156) 1.050 128 9 1.187 (183) 1.160 125 127 1,412 (226) 1.343 135 232 1.710 1.242 1.243 1.281 127 128 128 2914525 1.660 1.416 1.434 1.669 (745) (171) 81 1 61 57 Interest Expense Income Before Tax Income Tax Expense (211) (241) (282) (802) (250) (130) (226) (83) (143) 10 39 Net Income (552) (123) (147) (163) (87) 14 66 2194 219.3 WL Avg. Shares for Basic EPS-bas Weighted Average Shares-diluted 219.5 219.5 2183 2194 217.4 217.4 2133 2133 216 216 229.2 2017 Basic Emines per Share Diluted Earnings per Shure (52.51) (52.51) (50.56) (5056) (50.67) (50.67) (50.75) (50.75) (50.40) ($0.40) (50.67) (50.67) 0.06 $0.06 0.28 $0.28 Interest Coverage Title Page Exhibit 1 Exhibit 2 Exhibit 3 Exhibit 4 Exhibit 5 Exhibit 6 Exhibit 7 Enter Type here to search O ate - 9 - AutoSave OD R File Home X Cut 2 Insert 8 Draw - Page Layout Case 36 X Porney F1720x . Exced Formulas Data Review Search Help View A A Peste Copy Times New Roman - 12 BIU. w EEE Wrap Test Merge Center Percentage $ % Format Painter A 499 Condition Formatting f =(C301/(C30+C35) Exhibit 4 J. C. PENNEY COMPANY Quarterly Balance Sheets 2011-2012 (in millions of dollars) 04.2012 15 Total Current Assets 16 Property, Plant, and Equipment 17 Other Assets 2012 02 2012 01 2017 04 2011 03 2011 02.2011 1 2011 4,630 4.736 4,682 5 ,081 6.110 5,651 5.633 5,493 5.153 5 .126 5.176 5.242 5.237 5226 767 923 1.231 1.167 1,399 1.541 1.515 10 990 10,812 11.0.39 11.424 12.751 12.429 12374 9,781 1,015 1.022 1.503 1.831 1.404 1,386 138 1.274 1396 19 Total Assets 21 Liabilities 22 Current Liabilities Merchandise Accounts Payable Other Accounts Payable Short-Term and Current Long-Term Debt 27 Total Current Liabilities 28 Long-Term Debt 29 Other Liabilities 30 Deferred Long-Term Liability Charges 32 Total Liabilities 250 23 231 0 0 2.484 2.568 2.956 2,774 2.943 2,437 2.871 2.756 2.871 2901 852 3,466 2.871 2,767 3.099 2.670 3.099 786 904 924 1.152 8,229 1.216 7,726 1.208 7,623 6,610 7,388 7,141 7 ,103 7.414 110 34 Stockholders' Equity 35 Common Stock 36 Retained Earnings 37 Capital Surplus 38 Other Stockholder Equity 40 Total Stockholder Equity 41 Total abilities and Stockholders' Equity 380 3.799 (1.118) 3.171 9,781 110 932 3789 (1.329) 3,502 10,890 109 1.057 3,782 (1.277) 3,671 10.812 109 1.204 3.767 (1.141) 3,0.16 11.039 108 1.412 3.699 (1.209) 4,010 11,434 107 1 541 3.619 (745) 4.522 12.751 107 1.728 3.605 (737) 4,73 12,419 108 1.819 3.587 (763) 4.751 12,374 Debt to Capital Ratio 77.99 45.7% 44.1% 42.2% 41.7% 38.8% 39.79 39.54 Title Page Exhibit 1 Exhibit 2 Exhibit Exhibit 4 Exhibit 5 Exhibit 6 Exhibit 7 Type here to search