Homework Answers
1]
GP margin = gross margin / net sales
2015 = 10,157 / 25,778 = 39.40%
2016 = 10,583 / 27,079 = 39.08%
2]
operating profit margin = operating income / net sales
2015 = 1,315 / 25,778 = 5.10%
2016 = 2,039 / 27,079 = 7.53%
3]
net profit margin = net income / net sales
2015 = 611 / 25,778 = 2.37%
2016 = 1,070 / 27,079 = 3.95%
4]
times interest earned coverage = operating income / interest expense
2015 = 1,315 / -367 = -3.58 times
2016 = 2,039 / -363 = -5.62 times
Add Answer to:
ASSURANCE OF LEARNING EXERCISES 1. conn LO4-1 Using the financial ratios provided in the Appendix and...
h. Days of inventory. 1. Inventory turnover ratio. J. Average collection period Based on these ratios,...
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...
Ratios 2016 2015 a. Gross profit margin (%) 39.4 39.1 b. Operating profit margin (%) 5.1...
Ratios
2016
2015
a.
Gross profit margin (%)
39.4
39.1
b.
Operating profit margin (%)
5.1
7.5
c.
Net profit margin (%)
2.4
4.0
d.
Return on shareholders' equity (%)
14.1
25.2
e.
Return on assets (%)
3.1
5.2
f.
Times interest earned coverage
3.6
5.6
g.
Long-term debt-to-equity ratio
1.5
3.8
h.
Days of inventory
126.2
121.8
i.
Inventory turnover ratio
2.9
3.0
j.
Average collection
period
7.4
7.5
1-From 2015 to 2016, Macy’s, Inc., return on equity and...
success. It involves using the results of both industry and competitive analysis and com pany situation...
success. It involves using the results of both industry and competitive analysis and com pany situation analysis to identify a "worry list" of issues to be resolved for the company to be financially and competitively successful in the years ahead. Actually deciding upon a strategy and what specific actions to take comes after the list of strategic issues and prob- lems that merit front-burner management attention has been developed. Good company situation analysis, like good industry and competitive analysis, is...
11) Consider a retail firm with a net profit margin of 3.5%, a total asset turnover...
11) Consider a retail firm with a net profit margin of 3.5%, a total asset turnover of 1.8, total assets of $44 million, and a book value of equity of $18 million. a. What is the firm's current ROE? b. How does it compare with Macy's data for 2018? c. If the firm increased its net profit margin to 4%, what would its ROE be? CIS, C . CONSOLIDATED STATEMENTS OF INCOME (millions, except per share data) 2018 24,971 $...
I was provided both the Balance Sheet and Statement of income from which I am supposed...
I was provided both the Balance Sheet and Statement of income
from which I am supposed to calculate the inventory turnover ratio.
But the balance sheet only has the inventory values for 2016 and
2015, while the statement of income only states the cost of sales
for 2015, 2014, and 2013.
So:
Merchandise inventory (from balance sheet):
January 30, 2016 = $5,506
January 31, 2015 = $5,417
Cost of Sales (from income statement):
2015 = $16,496
2014 = $16,863
2013...
What is the inventory turnover rate of this company? January 30, 2016 January 31, 2015 $...
What is the inventory turnover rate of this company?
January 30, 2016 January 31, 2015 $ $ 2,246 424 1,109 558 5,506 479 7,652 7,616 3,897 514 897 20,576 5,417 493 8.580 7.800 3,743 496 711 21,330 $ $ S ASSETS Current Assets Cash and cash equivalents Receivables Merchandise inventories Prepaid expenses and other current assets Total Current Assets Property and Equipment - net Goodwill Other Intangible Assets-net Other Assets Total Assets LIABILITIES AND SHAREHOLDERS' EQUITY Current Liabilities: Short-term debt...
Using the financial ratios provided in Table 4.1 and the financial statement infor- mation presented below...
Using the financial ratios provided in Table 4.1 and the financial statement infor- mation presented below for Costco Wholesale Corporation, calculate the follow ing ratios for Costco for both 2013 and 2014: a. Gross profit margin b. Operating profit margin c. Net profit margin d. Times-interest-earned (or coverage) ratio e. Return on stockholders' equity 1. 1 f. Return on assets g. Debt-to-equity ratio h. Days of inventory . Inventory turnover ratio j. Average collection period Based on these ratios, did...
Compute the following ratios for 2014 and 2013 using apples financial statements found in Appendix A...
Compute the following ratios for 2014 and 2013 using apples
financial statements found in Appendix A and attached:
Current ratio
Quick (or acid-test ratio)
Profit margin
Return on total assets (ROA) [Sept 29, 2012, total assets
equaled $176,064]
Price-earnings ratio
Stock price – 9/27/14: $100.75
Stock Price – 9/28/13: $68.96
September 27,2014 September 28,2013 ASSETS: Current assets: Cash and cash equivalents Short-term marketable securitics Accounts receivable, less allowances of $86 and $99, respectively 3,844 S 11,233 17,460 13,102 3,453 7,539...
Using the following information: Calculate the following ratios for Urban Outfitters for both 2016 and 2017...
Using the following information:
Calculate the following ratios for Urban Outfitters for
both 2016 and
2017 (show calculations):
a. Gross profit margin
b. Operating profit margin
c. Net profit margin
d. Times interest earned coverage
e. Return on shareholders’ equity
f. Return on assets
g. Debt-to-equity ratio
h. Days of inventory
i. Inventory turnover ratio
j. Average collection period
Consolidated Income Statements for Urban ters, Inc. 2016 2017 $3.545.794 $3,445,134 Net sales (total revenue) 2,301,181 2,243,232 Cost of sales 906,086...
Complete Assurance of Learning Exercise 4C: Financial Ratio Analysis for PepsiCo. Financial Ratios for PepsiCo (2012)...
Complete Assurance of Learning Exercise 4C: Financial Ratio
Analysis for PepsiCo.
Financial Ratios for PepsiCo (2012) use the below information to
find
Liquidity Ratios:
- Current ratio:
- Quick ratio:
Leverage Ratios:
- Debt-to-total-assets ratio:
- Debt-to-equity ratio:
- Long-term debt-to-equity ratio:
- Times-earned-interest ratio: Profits before interest and
taxes/Total interest charges
Activity Ratios:
- Inventory turnover:
- Fixed assets turnover:
- Total assets turnover:
- Accounts receivable turnover:
Profitability Ratios:
- Gross profit margin:
- Operating profit margin:
-...
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...
Ratios
2016
2015
a.
Gross profit margin (%)
39.4
39.1
b.
Operating profit margin (%)
5.1
7.5
c.
Net profit margin (%)
2.4
4.0
d.
Return on shareholders' equity (%)
14.1
25.2
e.
Return on assets (%)
3.1
5.2
f.
Times interest earned coverage
3.6
5.6
g.
Long-term debt-to-equity ratio
1.5
3.8
h.
Days of inventory
126.2
121.8
i.
Inventory turnover ratio
2.9
3.0
j.
Average collection
period
7.4
7.5
1-From 2015 to 2016, Macy’s, Inc., return on equity and...
success. It involves using the results of both industry and competitive analysis and com pany situation analysis to identify a "worry list" of issues to be resolved for the company to be financially and competitively successful in the years ahead. Actually deciding upon a strategy and what specific actions to take comes after the list of strategic issues and prob- lems that merit front-burner management attention has been developed. Good company situation analysis, like good industry and competitive analysis, is...
11) Consider a retail firm with a net profit margin of 3.5%, a total asset turnover of 1.8, total assets of $44 million, and a book value of equity of $18 million. a. What is the firm's current ROE? b. How does it compare with Macy's data for 2018? c. If the firm increased its net profit margin to 4%, what would its ROE be? CIS, C . CONSOLIDATED STATEMENTS OF INCOME (millions, except per share data) 2018 24,971 $...
I was provided both the Balance Sheet and Statement of income
from which I am supposed to calculate the inventory turnover ratio.
But the balance sheet only has the inventory values for 2016 and
2015, while the statement of income only states the cost of sales
for 2015, 2014, and 2013.
So:
Merchandise inventory (from balance sheet):
January 30, 2016 = $5,506
January 31, 2015 = $5,417
Cost of Sales (from income statement):
2015 = $16,496
2014 = $16,863
2013...
What is the inventory turnover rate of this company?
January 30, 2016 January 31, 2015 $ $ 2,246 424 1,109 558 5,506 479 7,652 7,616 3,897 514 897 20,576 5,417 493 8.580 7.800 3,743 496 711 21,330 $ $ S ASSETS Current Assets Cash and cash equivalents Receivables Merchandise inventories Prepaid expenses and other current assets Total Current Assets Property and Equipment - net Goodwill Other Intangible Assets-net Other Assets Total Assets LIABILITIES AND SHAREHOLDERS' EQUITY Current Liabilities: Short-term debt...
Using the financial ratios provided in Table 4.1 and the financial statement infor- mation presented below for Costco Wholesale Corporation, calculate the follow ing ratios for Costco for both 2013 and 2014: a. Gross profit margin b. Operating profit margin c. Net profit margin d. Times-interest-earned (or coverage) ratio e. Return on stockholders' equity 1. 1 f. Return on assets g. Debt-to-equity ratio h. Days of inventory . Inventory turnover ratio j. Average collection period Based on these ratios, did...
Compute the following ratios for 2014 and 2013 using apples
financial statements found in Appendix A and attached:
Current ratio
Quick (or acid-test ratio)
Profit margin
Return on total assets (ROA) [Sept 29, 2012, total assets
equaled $176,064]
Price-earnings ratio
Stock price – 9/27/14: $100.75
Stock Price – 9/28/13: $68.96
September 27,2014 September 28,2013 ASSETS: Current assets: Cash and cash equivalents Short-term marketable securitics Accounts receivable, less allowances of $86 and $99, respectively 3,844 S 11,233 17,460 13,102 3,453 7,539...
Using the following information:
Calculate the following ratios for Urban Outfitters for
both 2016 and
2017 (show calculations):
a. Gross profit margin
b. Operating profit margin
c. Net profit margin
d. Times interest earned coverage
e. Return on shareholders’ equity
f. Return on assets
g. Debt-to-equity ratio
h. Days of inventory
i. Inventory turnover ratio
j. Average collection period
Consolidated Income Statements for Urban ters, Inc. 2016 2017 $3.545.794 $3,445,134 Net sales (total revenue) 2,301,181 2,243,232 Cost of sales 906,086...
Complete Assurance of Learning Exercise 4C: Financial Ratio
Analysis for PepsiCo.
Financial Ratios for PepsiCo (2012) use the below information to
find
Liquidity Ratios:
- Current ratio:
- Quick ratio:
Leverage Ratios:
- Debt-to-total-assets ratio:
- Debt-to-equity ratio:
- Long-term debt-to-equity ratio:
- Times-earned-interest ratio: Profits before interest and
taxes/Total interest charges
Activity Ratios:
- Inventory turnover:
- Fixed assets turnover:
- Total assets turnover:
- Accounts receivable turnover:
Profitability Ratios:
- Gross profit margin:
- Operating profit margin:
-...
Most questions answered within 3 hours.
-
Write a program to prompt the user for hours and rate per hour
using input to...
asked 5 minutes ago -
Hi, please help
1)Draw two molecules that could hydrogen bond with each other.
Draw and indicate...
asked 9 minutes ago -
Using Java, I created 3 files, Pizza,PizzaOrder, and
PizzaOrder_Demo that I attached down below. But I...
asked 8 minutes ago -
a. An 8-bit successive approximation ADC has a reference voltage
of 10 V. Calculate the resolution...
asked 18 minutes ago -
The distance between the two hydrogen nuclei in the H2 molecule
is 110 pm (picometer). How...
asked 19 minutes ago -
write an article about drone effect on
construction safety.
asked 23 minutes ago -
Consider the following data for a dependent variable y and two
independent variables, x1 and x2....
asked 1 hour ago -
what is the most likely shape for a distribution with a mean of
40 and a...
asked 34 minutes ago -
The work function, Φ0 (or W0), for cesium is 3.43×10−19 J. The
frequency of a photon...
asked 40 minutes ago -
18.54----At the surface of Venus the average temperature is a
balmy 460 ∘C due to the...
asked 39 minutes ago -
#1. A food has been ingested. Identify all of the anatomic
structures and substructures it travels...
asked 32 minutes ago -
Grommit Engineering expects to have net income next year of $
29.71 million and free cash...
asked 41 minutes ago