I need help calculating the financial analysis rations using the below information. I'm not sure how to calculate EBIT, Total Equity etc. I need to calculate the following ratios:
1.Total Debt Ratio
2. Debt-Equity Ratio
3. Equity Multiplier
4. Times Interest Earned Ratio
5. Cash Coverage Ratio
6. Inventory Turnover
7. Day's Sales in Inventory
8. Receivable's Turnover
9. Day's Sales in Receivables
10. Total Asset Turnover
11. Profit Margin
12. Return on Assets
13. Return on Enquiry
14. Earnings Per Share
15. Price-Earnings Ratio
16. Market - to - Book Ratio
Total Debt Ratio | total liabilities / total assets | |
2016 ($) | 2015 ($) | |
total liabilities | 3810.4 | 4926.8 |
total assets | 3418.9 | 3870.4 |
Total Debt Ratio | 1.11 | 1.27 |
Debt-Equity Ratio | total liabilities / total equity | |
2016 ($) | 2015 ($) | |
total liabilities | 3810.4 | 4926.8 |
total equity | -848 | -1070.3 |
Debt-Equity Ratio | -4.49 | -4.60 |
Equity Multiplier | total assets / total equity | |
2016 ($) | 2015 ($) | |
total assets | 3418.9 | 3870.4 |
total equity | -848 | -1070.3 |
Equity Multiplier | -4.03 | -3.62 |
Times Interest Earned Ratio | EBIT / interest expense | |
2016 ($) | 2015 ($) | |
EBIT | 321.9 | 165 |
interest expense | 136.6 | 120.5 |
Times Interest Earned Ratio | 2.36 | 1.37 |
Cash Coverage Ratio | cash and cash equivalent / current liabilities | |
2016 ($) | 2015 ($) | |
cash and cash equivalent | 654.4 | 686.9 |
current liabilities | 1485.7 | 2195.1 |
cash coverage ratio | 0.44 | 0.31 |
Inventory Turnover | cost of goods sold / ending inventory | |
2016 ($) | 2015 ($) | |
cost of goods sold | 2257 | 2445.4 |
ending inventory | 586.4 | 624 |
Inventory Turnover | 3.85 | 3.92 |
Day's Sales in Inventory | 365 days / inventory turnover | |
2016 ($) | 2015 ($) | |
inventory turnover | 3.85 | 3.92 |
Day's Sales in Inventory | 95 | 93 |
Receivable's Turnover | sales / ending receivable | |
2016 ($) | 2015 ($) | |
sales | 5578.8 | 6076.5 |
ending receivables | 458.9 | 443 |
Receivable's Turnover | 12.16 | 13.72 |
Day's Sales in Receivables | 365 days / receivables turnover | |
2016 ($) | 2015 ($) | |
Receivable's Turnover | 12.16 | 13.72 |
Day's Sales in Receivables | 30 | 27 |
Total Asset Turnover | sales / ending total assets | |
2016 ($) | 2015 ($) | |
sales | 5578.8 | 6076.5 |
ending total assets | 3418.9 | 3870.4 |
Total Asset Turnover | 1.63 | 1.57 |
Profit Margin | (net income / sales)*100 | |
2016 ($) | 2015 ($) | |
net income | -107.6 | -1148.9 |
sales | 5578.8 | 6076.5 |
Profit Margin | -1.93% | -18.91% |
Return on Assets | net income / total assets | |
2016 ($) | 2015 ($) | |
net income | -107.6 | -1148.9 |
ending total assets | 3418.9 | 3870.4 |
Return on Assets | -0.03 | -0.30 |
I need help calculating the financial analysis rations using the below information. I'm not sure how...
2015 Analysis and Interpretation of Liquidity and Solvency Refer to the financial information for Target Corporation (TGT), presented below, to answer the following. Target Corporation Balance Sheets January 31, February 1, ($ millions) 2014 Assets Cash and cash equivalents $2,210 $670 Inventory 8,790 8,278 Other current assets 3,087 2,625 Total current assets 14,087 11,573 Property and equipment, net 25,958 26,412 Other noncurrent assets 1,359 6,568 Total assets $41,404 $44,553 Liabilities and shareholders' investment Accounts payable $7,759 $7,335 Accrued and other...
ASSURANCE OF LEARNING EXERCISES 1. conn LO4-1 Using the financial ratios provided in the Appendix and the following financial statement information for Macy's, Inc., calculate the following ratios for Macy's for both 2015 and 2016. 1. Gross profit margin 2. Operating profit margin 3. Net profit margin 4. Times interest earned coverage 5. Return on shareholders' equity 6. Return on assets 7. Long-term debt-to-equity ratio 8. Days of inventory 9. Inventory turnover ratio 10. Average collection period Based on these...
Comparative Analysis Case The Coca-Cola Company and PepsiCo, Inc. The financial statements of Coca-Cola and PepsiCo are presented in Appendices C and D, respectively. The companies' complete annual reports, including the notes to the financial statements, are available online. Instructions Use the companies' financial information to answer the following questions. a. What kind of pension plans do Coca-Cola and PepsiCo provide their employees? b. What net periodic pension expense (cost) did Coca-Cola and PepsiCo report in 2017? c. What is...
Looking for help on the questions below for the financial metrics required. If someone could please also explain why my Liability to Equity ratio for 2016 is incorrect; while my ratio for 2015 is correct and I used the same process to get both numbers? Thanks 550 Consolidated Statements of Earnings Year Ended December 31 (In millions) 2016 2015 Net sales Products $ 40,365 $ 34,868 Services 6,883 5,668 Total net sales 47,248 40,536 Cost of sales Products (36,616) (31,091)...
h. Days of inventory. 1. Inventory turnover ratio. J. Average collection period Based on these ratios, did Macy's financial performance improve, weaken, or remain about the same from 2015 to 2016? (479) 198 Consolidated Statements of Income for Macy's, Inc., 2015-2016 (in millions, except per share amounts) 2016 2015 Net sales $25,778 $27,079 Cost of sales (15,621) (16,496 Gross margin 10,157 10,583 Selling, general and administrative expenses (8,265) (8,256) Impairments, store closing and other costs (288) Settlement charges Operating income...
Instead of “cash,” the company’s balance sheet uses the account name “Cash and cash equivalents.” How does the company define cash equivalents? The annual report has two reports in which management is clearly identified as having for the company’s financial reporting and internal controls. What are the names of these reports and on what pages are they located? For the Fiscal Year 2017 2016 As Adjusted As Adjusted 71,786 $ 69,414 $ 72,714 70,271 2014 2018 74,433 $ 75,356 $...
Compute ROA, Profit Margin, and Asset Turnover Refer to the financial information for Target Corporation, presented below: Target Corporation Balance Sheets January 31, February 1, ($ millions) 2015 2014 Assets Cash and cash equivalents $2,210 $670 Inventory 8,790 8,278 Other current assets 3,087 2,625 Total current assets 14,087 11,573 Property and equipment, net 25,958 26,412 Other noncurrent assets 1,359 6,568 Total assets $41,404 $44,553 Liabilities and shareholders' investment 59 Accounts payable Accrued and other current liabilities Current portion of long-term...
I would like you to perform a ratio analysis on the financial statements. You will want to compute ratios for your company for the last two years. Do not compute each ratio you learned about for your company. There may be some that are not relevant. Rather focus on those eight ratios that you feel are the most important and relevant to analyze how your company is doing. Year ended December 31, 2017 2016 2018 1 2015 2014 15 964...
Nike, Inc., Problem Financial Statement Analysis The financial statements for Nike, Inc., are presented in at the end of the text. The following additional information is available (in thousands): Accounts receivable at May 31, 2013 $ 3,117 Inventories at May 31, 2013 3,484 Total assets at May 31, 2013 17,545 Stockholders' equity at May 31, 2013 11,081 Instructions Determine the following measures for the fiscal years ended May 31, 2015, and May 31. (Round ratios and percentages to one decimal...
Comparative Analysis Casemobivio de The Coca-Cola Company and PepsiCo, Inc. The financial statements of Coca-Cola and PepsiCo are presented in Appendices C and D, respectively. The companies' complete annual reports, including the notes to the financial statements, are available online. Stock price data can be found in the company's annual 10K, filed at the SEC. Instructions Use the companies' financial information to answer the following questions. a. What is the par or stated value of Coca-Cola's and PepsiCo's common or...