Calculate the inventory turnover, pay sales outstanding, days payable outstanding, days payable merchandise outstanding for each quarter.
Fantastic news! We've Found the answer you've been seeking!
Question:
Calculate the inventory turnover, pay sales outstanding, days payable outstanding, days payable merchandise outstanding for each quarter. Explain how these ratios can answer question 2.2.How has J.C. Penney managed its working capital accounts over the past eight quarters? Is there an opportunity to squeeze more cash from any of these accounts?
Transcribed Image Text:
EXHIBIT 36.41 Quarterly Balance Sheets 2011-2012 (in millions of dollars) Q4 2012 Q3 2012 Q2 2012 Q1 2012 Q4 2011 Q3 2011 Q2 2011 Q1 2011 Assets Current assets Cash and cash equivalents 930 525 888 839 1507 1085 1551 1767 Inventory 2,341 3,362 2993 3084 2916 4376 3572 3408 Other current assets 412 743 855 759 658 649 528 458 Total Current Assets 3,683 4,630 4,736 4,682 5,081 6,110 5,651 5,633 Property, plant, and equipment 5,353 5,493 5,153 5,126 5,176 5,242 5,237 5,226 Other assets 745 767 923 1,231 1,167 1,399 1,541 1,515 Total assets 9,781 10,890 10,812 11,039 11,424 12,751 12,429 12,374 Liabilities Current liabilities Merchandise accounts payable 1,162 1,408 1,015 984 1,022 1,831 1,386 1,274 Other accounts payable 1,380 1,344 1,219 1,222 1,503 1,404 1,381 1,396 Short-term and current long-term debt 26 22 250 231 231 231 0 0 Total current liabilities 2,568 2,774 2,484 2,437 2,756 3,466 2,767 2,670 Long-term debt 2,956 2,943 2901 2,871 2,871 2,871 3,099 3,099 Other liabilities 698 885 852 871 899 740 644 646 Deferred long-term liability charges 388 786 904 924 888 1,152 1,216 1,208 Total liabilities 6,610 7,388 7,141 7,103 7,414 8,229 7,726 7,623 Stockholders' equity Common stock 110 110 109 109 108 107 107 108 Retained earnings Capital surplus 380 932 1,057 1,204 1,412 1,541 1,728 1,819 3,799 3789 3,782 3,767 3,699 3,619 3,605 3,587 Other stockholder equity (1,118) (1,329) (1,277) (1,144) (1,209) (745) (737) (763) Total stockholder equity 3,171 3,502 3,671 3,936 4,010 4,522 4,703 4,751 Total liabilities and stockholders' equity 9,781 10,890 10,812 11,039 11,424 12,751 12,429 12,374 EXHIBIT 36.3 | Quarterly Income Statements, 2011 and 2012 (in millions of dollars, except per-share data) Q4 2012 Q3 2012 Q2 2012 Q1 2012 Q4 2011 Q3 2011 Q2 2011 Q1 2011 Total revenue 3,884 2,927 3,022 3,152 5,425 3,986 3,906 3,943 Cost of revenue 2,960 1,975 2,018 1,966 3,788 2,497 2,409 2,348 Gross profit 924 952 1,004 1,186 1,637 1,489 1,497 1,595 Operating expenses Selling, general and administrative 1,209 1,087 1,050 1,160 1,343 1,242 1,243 1,281 Depreciation and amortization 157 133 128 125 135 127 128 128 Other 303 (112) 9 127 232 291 45 25 Total operating expenses 1,669 1,108 1,187 1,412 1,710 1,660 1,416 1,434 Operating income Interest expense (745) (156) (183) (226) (73) (171) 81 161 57 55 58 56 57 55 57 58 Income before tax (802) (211) (241) (282) (130) (226) 24 103 Income tax expense (250) (88) (94) (119) (43) (83) 10 39 Net income (552) (123) (147) (163) (87) (143) 14 64 Wt. avg. shares for basic EPS-basic 219.5 219.4 219.3 218.3 217.4 213.3 216 229.2 Weighted average shares-diluted 219.5 219.4 219.3 218.3 217.4 213.3 216 231.7 Basic earnings per share ($2.51) ($0.56) ($0.67) ($0.75) ($0.40) ($0.67) $0.06 $0.28 Diluted earnings per share ($2.51) ($0.56) ($0.67) ($0.75) ($0.40) ($0.67) $0.06 $0.28 EXHIBIT 36.41 Quarterly Balance Sheets 2011-2012 (in millions of dollars) Q4 2012 Q3 2012 Q2 2012 Q1 2012 Q4 2011 Q3 2011 Q2 2011 Q1 2011 Assets Current assets Cash and cash equivalents 930 525 888 839 1507 1085 1551 1767 Inventory 2,341 3,362 2993 3084 2916 4376 3572 3408 Other current assets 412 743 855 759 658 649 528 458 Total Current Assets 3,683 4,630 4,736 4,682 5,081 6,110 5,651 5,633 Property, plant, and equipment 5,353 5,493 5,153 5,126 5,176 5,242 5,237 5,226 Other assets 745 767 923 1,231 1,167 1,399 1,541 1,515 Total assets 9,781 10,890 10,812 11,039 11,424 12,751 12,429 12,374 Liabilities Current liabilities Merchandise accounts payable 1,162 1,408 1,015 984 1,022 1,831 1,386 1,274 Other accounts payable 1,380 1,344 1,219 1,222 1,503 1,404 1,381 1,396 Short-term and current long-term debt 26 22 250 231 231 231 0 0 Total current liabilities 2,568 2,774 2,484 2,437 2,756 3,466 2,767 2,670 Long-term debt 2,956 2,943 2901 2,871 2,871 2,871 3,099 3,099 Other liabilities 698 885 852 871 899 740 644 646 Deferred long-term liability charges 388 786 904 924 888 1,152 1,216 1,208 Total liabilities 6,610 7,388 7,141 7,103 7,414 8,229 7,726 7,623 Stockholders' equity Common stock 110 110 109 109 108 107 107 108 Retained earnings Capital surplus 380 932 1,057 1,204 1,412 1,541 1,728 1,819 3,799 3789 3,782 3,767 3,699 3,619 3,605 3,587 Other stockholder equity (1,118) (1,329) (1,277) (1,144) (1,209) (745) (737) (763) Total stockholder equity 3,171 3,502 3,671 3,936 4,010 4,522 4,703 4,751 Total liabilities and stockholders' equity 9,781 10,890 10,812 11,039 11,424 12,751 12,429 12,374 EXHIBIT 36.3 | Quarterly Income Statements, 2011 and 2012 (in millions of dollars, except per-share data) Q4 2012 Q3 2012 Q2 2012 Q1 2012 Q4 2011 Q3 2011 Q2 2011 Q1 2011 Total revenue 3,884 2,927 3,022 3,152 5,425 3,986 3,906 3,943 Cost of revenue 2,960 1,975 2,018 1,966 3,788 2,497 2,409 2,348 Gross profit 924 952 1,004 1,186 1,637 1,489 1,497 1,595 Operating expenses Selling, general and administrative 1,209 1,087 1,050 1,160 1,343 1,242 1,243 1,281 Depreciation and amortization 157 133 128 125 135 127 128 128 Other 303 (112) 9 127 232 291 45 25 Total operating expenses 1,669 1,108 1,187 1,412 1,710 1,660 1,416 1,434 Operating income Interest expense (745) (156) (183) (226) (73) (171) 81 161 57 55 58 56 57 55 57 58 Income before tax (802) (211) (241) (282) (130) (226) 24 103 Income tax expense (250) (88) (94) (119) (43) (83) 10 39 Net income (552) (123) (147) (163) (87) (143) 14 64 Wt. avg. shares for basic EPS-basic 219.5 219.4 219.3 218.3 217.4 213.3 216 229.2 Weighted average shares-diluted 219.5 219.4 219.3 218.3 217.4 213.3 216 231.7 Basic earnings per share ($2.51) ($0.56) ($0.67) ($0.75) ($0.40) ($0.67) $0.06 $0.28 Diluted earnings per share ($2.51) ($0.56) ($0.67) ($0.75) ($0.40) ($0.67) $0.06 $0.28
Expert Answer:
Related Book For
Posted Date:
Students also viewed these finance questions
-
Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...
-
In our class discussion on Financial Distress, we listed some events that usually befall companies in financial distress. Which of the events that we discussed are also faced by JCP in the case? (5)...
-
Investors should expect to be compensated for bearing_____ risk, but they should not expect to be compensated for bearing_____ risk. a. Unsystematic: systematic b. Unsystematic; co-movement c....
-
Prove that a parallelogram is a rhombus, a parallelogram with four equal sides, if and only if its diagonals are orthogonal.
-
Consider the graph of the parabola y = x. (a) Find the radius r of the largest possible circle centered on the y-axis that is tangent to the parabola at the origin, as shown in the figure. This...
-
In February 2007, The Elliot Group, Inc., an Illinois real estate developer, made a deal with the Village of Arlington Heights to develop property in that village. Arlington Market, LLC, was...
-
Minden Company is a wholesale distributor of premium European chocolates. The companys balance sheet as of April 30 is given below: The company is in the process of preparing budget data for May. A...
-
RELATIONAL DATABASE CONCEPTS: Describe the basic steps required to install the Oracle, SQL Server, and MySQL relational database management systems (RDBMSs) and the major challenges that the user may...
-
Comparative statements of shareholders? equity for Anaconda International Corporation were reported as follows for the fiscal years ending December 31, 2021, 2022, and 2023. Required: 1. Infer from...
-
9. Let G be the grammar 1. SaS 2. S AB 3. A bAa 4. A a 5. BbB 6. Bb. a) Give a set-theoretic definition for L(G). b) Give the tree built by the top-down parse of baab. c) Give the tree built by the...
-
What are the metabolic adaptations underlying cancer metabolism, including the Warburg effect, glutamine addiction, and alterations in nucleotide metabolism, and how do these metabolic rewiring...
-
How does functionalism contribute to our understanding of social institutions such as family, education, religion, and government, by examining their roles in maintaining social order, stability, and...
-
How do metabolic flux analysis techniques, such as isotopic labeling, metabolomics, and flux balance analysis, provide quantitative insights into metabolic pathway activity, metabolic flux...
-
what ways does metabolic modeling and computational systems biology facilitate the integration of multi-omic data, network inference, and predictive modeling to elucidate the emergent properties of...
-
Catherine Lafferty recently inherited $1,000,000 in cash from her mother's estate and has come to you as a CFA for investment advice. Both Catherine and her husband, Bill, are 35 years old. Bill...
-
Differentiate among the types of SQL Server statements listed below and provide a scenario in which use of each type would be appropriate. SELECT INSERT UPDATE DELETE
-
In Problem use geometric formulas to find the unsigned area between the graph of y = f(x) and the x axis over the indicated interval. f(x) = x + 5; [0, 4]
-
What are the features of a legal risk management plan?
-
What are residual powers? Concurrent powers?
-
Why have business enterprises adopted codes of conduct?
Study smarter with the SolutionInn App