Course: Financial Accountingn504 Project
Use this Excel spreadsheet to compute ratios; show your computations for all ratios on this tab and also include your commentary.
The financial statements used to calculate these ratios are available in Appendix A and Appendix B of your textbook. Kohl’s J.C. Penney Interpretation and Comparison between the two companies' ratios (Reading the Appendix of Chapter 13 will help you prepare the commentary) Earnings per share As given in the income statement $3.67 Basic Common $1.60 Earning per share express net income earned on a per share basis which provides a useful information for shareholders to determin profitability .Kohl's earning per share is lot higher than JC Penne. Current ratio Current assets $5,645 = 2.08 $6,370 = 2.41 Current liabilities $2,710 $2,647 The current ratio is used to measure and determine the company’s short-term debt-paying ability. JC Penne has a higher ratio than Kohl's.
Gross Profit Ratio Gross profit $7,032 = 38.2% $6,960 = 39.2% Net Sales $18,391 $17,759 Gross profit ratio measures the margin by which selling price exceeds cost of goods sold. JC Pennee has a slightly higher ration than Kohl's.
Profit margin ratio Net Income $1,114 = 6.1% $389 = 2.2% Net Sales $18,391 $17,759 profit margin ratio is a measure of the percentage of each dollar of sales that results in net income. Kohl's ratio is three time higher than JC Penne.
Inventory Turnover Cost of Goods Sold $11,359 3.8 $10,799 3.5 Average Inventory $2,980 times $3,119 times Inventory turn over ratio measures the number of times average inventory was sold during the period. Kohl's inventory ratio is slightly higher than JC Penne's.
Days in Inventory 365 days 365 = 96 365 = 105 Inventory turnover 3.8 days 3.5 days It measures the average number of days inventory is held. JC Penne hold their
The financial statements used to calculate these ratios are available in Appendix A and Appendix B of your textbook. Kohl’s J.C. Penney Interpretation and Comparison between the two companies' ratios (Reading the Appendix of Chapter 13 will help you prepare the commentary) Earnings per share As given in the income statement $3.67 Basic Common $1.60 Earning per share express net income earned on a per share basis which provides a useful information for shareholders to determin profitability .Kohl's earning per share is lot higher than JC Penne. Current ratio Current assets $5,645 = 2.08 $6,370 = 2.41 Current liabilities $2,710 $2,647 The current ratio is used to measure and determine the company’s short-term debt-paying ability. JC Penne has a higher ratio than Kohl's.
Gross Profit Ratio Gross profit $7,032 = 38.2% $6,960 = 39.2% Net Sales $18,391 $17,759 Gross profit ratio measures the margin by which selling price exceeds cost of goods sold. JC Pennee has a slightly higher ration than Kohl's.
Profit margin ratio Net Income $1,114 = 6.1% $389 = 2.2% Net Sales $18,391 $17,759 profit margin ratio is a measure of the percentage of each dollar of sales that results in net income. Kohl's ratio is three time higher than JC Penne.
Inventory Turnover Cost of Goods Sold $11,359 3.8 $10,799 3.5 Average Inventory $2,980 times $3,119 times Inventory turn over ratio measures the number of times average inventory was sold during the period. Kohl's inventory ratio is slightly higher than JC Penne's.
Days in Inventory 365 days 365 = 96 365 = 105 Inventory turnover 3.8 days 3.5 days It measures the average number of days inventory is held. JC Penne hold their