a) Macy's and JC Penney - Questions (revised) (1)
docx
keyboard_arrow_up
School
University of Texas, Dallas *
*We aren’t endorsed by this school
Course
6301
Subject
Finance
Date
Apr 3, 2024
Type
docx
Pages
5
Uploaded by GeneralFoxMaster1044
Macy’s & JC Penney - Questions
1.
Using the guidelines provided below, compute financial ratios for fiscal years 2009, 2010, and 2011 (ending on January 30, 2010, January 30, 2011, and January 2012, respectively). Macy’s □ Details of Macy's Financial Ratios
Financial Ratio
Year
Macy's (Ticker: M)
Return on Equity
2011
0.219
= 1256/(0.5*(5933+5530))
2010
0.166
= 847/(0.5*(5530+4653))
2009
0.070
= 329/(0.5*(4701+4646))
Profit Margin
2011
0.048
= 1256/26405
2010
0.034
= 847/25003
2009
0.014
= 329/23489
Gross Margin
2011
0.404
= (26405-15738)/26405
2010
0.407
= (25003-14824)/25003
2009
0.405
= (23489-13973)/23489
Asset Turnover
2011
1.236
= 26405/(0.5*(22095+20631))
2010
1.193
= 25003/(0.5*(20631+21300))
2009
1.081
= 23489/(0.5*(21300+22145))
A/R Turnover
2011
74.802
= 26405/(0.5*(368+338))
2010
66.675
= 25003/(0.5*(392+358))
2009
65.429
= 23489/(0.5*(358+360))
Inventory Turnover
2011
3.187
= 15738/(0.5*(5117+4758))
2010
3.163
= 14824/(0.5*(4758+4615))
2009
2.978
= 13973/(0.5*(4615+4769))
Debt-Equity Ratio
2011
2.724
= (22095-5933)/5933
2010
2.731
= (20631-5530)/5530
2009
3.531
= (21300-4701)/4701
Current Ratio
2011
1.401
=8777/6263
2010
1.362
= 6899/5065
2009
1.545
= 6882/4454
Quick Ratio
2011
0.510
= (2827+368)/6263
2010
0.366
= (1464+392)/5065
2009
0.459
= (1686+358)/4454
Times Interest Earned
2011
5.403
= (1256+712+447)/447
2010
3.280
= (847+473+579)/579
2009
1.902
= (329+178+562)/562
□ Details of JCPenny Financial Ratios
Financial Ratio
Year
Macy's (Ticker: M)
Return on Equity
2011
0.0321
= 152/(0.5*(4010+5460))
2010
0.0756
= 389/(0.5*(5460+4778))
2009
0.0562
= 251/(0.5*(4778+4155))
Profit Margin
2011
0.0088
= 152/17260
2010
0.022
= 389/17759
2009
0.014
= 251/17556
Gross Margin
-
2011
0.360
= (17260-11042)/ 17260
2010
0.392
= (17759-10799)/ 17759
2009
1.606
= (17556-10646)/ 17556
Asset Turnover
2011
1.409
= 17260/(0.5*(11424+13068))
2010
1.385
= 17759/(0.5*(13068+12581))
2009
1.428
= 17556/(0.5*(12581+12011))
A/R Turnover
2011
Missing
Data
2010
2009
Inventory Turnover
2011
3.603
= 11042/(0.5*(2916+3213))
2010
3.463
= 10799/(0.5*(3213+3024))
2009
3.389
= 10646/(0.5*(3024+3259))
Debt-Equity Ratio
2011
1.849
= (11424-4010)/4010
2010
1.389
= (13042-5460)/5460
2009
1.633
= (12581-4778)/4778
Current Ratio
2011
1.540
=11424/7414
2010
1.720
= 13042/7582
2009
1.612
= 12581/7803
Quick Ratio
2011
1.208
= (2916+413)/2756
2010
1.339
= (3213+334)/2647
2009
1.052
= (3024+395)/3249
Times Interest Earned
2011
2.009
= (152+77+227)/227
2010
3.515
= (378+203+231)/231
2009
2.550
= (249+154+260)/260
2.
Based on past profitability ratios, which firm is likely to be more profitable in the future and why? Discuss in detail. Use the component ratios of return on equity to explain the reasons for the difference in profitability across the two firms. In other words, is profit margin, asset turnover, and/or financial leverage responsible for the difference in profitability? Based on the profitability ratios Macy’s seems to be more profitable than JCPenney due to the profit margin being
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
higher than JCPenney. This shows that Macy’s has a better handle on cost management and is efficient in controlling costs. Compared to JCPenney the fluctuation of profitability increasing and decreasing seems to be unsteady and cause instability in profits. One main reason could be the higher net income in Macy’s compared to JCPenney that can
contribute to the difference in profitability between the two companies. As for whether or not the profit margin, asset turnover and financial leverage affect profitability all the factors to affect the profitability. JCPenney have a consistently higher asset turnover that help with the ROE as well as a low debt to equity ratio. This shows that JCPenney is more efficient with assets for sales. 3.
Based on the risk ratios, which firm is likely to be more risky in the future and why? Based on the risk ratios Macy’s is most likely to be a riskier firm than JCPenney because Macy’s has a higher risk
ratio compared to JCPenney. However while JCPenney is relatively low at the moment the risk ratio does show an
increase in overall risk ratio so based on future predications it could be that JCPenney can be become more risky of a company if the trend continues. And while Macy’s is relatively high at the moment, it does show an eventually decrease so future predictions could indicate that the risk ratio maybe lower than JCPenney in the near future. 4.
Based on the information contained in the Statement of Cash Flows, which firm faces greater liquidity risk? Discuss in detail by considering separately cash flows from operations, investment and financing activities, and the major components contained within each of these activities.
The firm with the greater risk of liquidity risk would be JCPenney due to the decline in cash over the period of three years. Comparing the operating activities from Macy’s to JCPenney, Macy’s net cash provided by operating activities has increased over the years, most notably the increase in merchandise and in accounts payable contribute greatly to the net cash showing a positive increase. With JCPenney the net cash in operating activities declined in 2010 but increase by roughly $300 in 2011 however not as much as in 2009 where the total was $1573. The sudden decrease in cash seems to have been contributed by merchandise accounts payable. When comparing the investing activities, Macy’s has an increasing spending in investing activities over the years as well
as JCPenney. Much of the spending has been for property and equipment. From financing activities, Macy’s has been able to decrease the amount they spend on financing over the years while JCPenney spending has significantly increased contributed to less cash on hand. 5.
Use the information in notes 17 and 20 of the 2011 fiscal year financial statements of JC Penney for evaluating its risk.
There seems to be a high risk with JCPenney looking at the financial statements we can see that there are many financial, operational and industry risks that are associated. There seems to be a decrease in net income in the lat quarter of 2011 that seem to hinder the stability of profitability within the company. There also seems to be challenges in managing properties. There also seems to be fluctuations within the company with stock prices and can be due to a multitudes of issues. Overall JCPenney has a higher risk than Macy’s
6.
As a potential investor, what other information you would be useful to you, and where is it available?
Potential investors would benefit from additional information such as key financial data and company performance metrics. This information can be found in company filings, external databases, and sources for investment, and other financial providers. By leveraging these resources, investors can thoroughly analyze a company's financial status, industry
comparisons, and performance metrics to make informed investment decisions.
Guidelines to compute ratios for JC Penney & Macy’s
-
Return on Equity = Net income/Avg. Total Equity
-
Profit Margin = Net income/Sales
-
Gross Margin = (Net sales – Cost of Sales)/Net Sales
-
Total Asset Turnover = Net sales/Avg. Total Assets
-
Accounts Receivable Turnover = Sales/Avg. Accounts Receivable
-
Inventory Turnover Ratio = Cost of Goods Sold/Avg. Inventory
-
Debt to Equity Ratio = Total Liabilities/Total Equity
-
Total Liabilities = Total Assets – Total Equity
-
Current Ratio = Current Assets/Current Liabilities
-
Quick Ratio = (Cash + Marketable Securities + Accounts Receivable)/Current Liabilities
-
Times Interest Earned = Income before Interest and Taxes/Interest Expense
Note: JC Penney does not provide a separate amount for Accounts Receivables (it is included in “Cash in banks and in transit). You may just indicate missing data for Accounts Receivable Turnover ratio.
Related Documents
Related Questions
Please provide answer this accounting question
arrow_forward
Some recent financial statements for Smolira Golf Corporation follow.
Find the following financial ratios for Smolira Golf Corporation (use year-end figures rather than average values where appropriate): (Enter the profitability ratio answers as a percent rounded to 2 decimal places, e.g., 32.16. Round the remaining answers to 2 decimal places, e.g., 32.16.)
1.
Long-term Solvency Ratios
2020
2021
Total debt ratio
times
times
Debt-equity ratio
times
times
Equity multiplier
times
times
2.
Times interest earned
times
Cash coverage ratio
times
3.
Profitability Ratios
Profit margin
%
Return on Assets
%
Return on Equity
%
arrow_forward
Find the following financial ratios for LVMH Moet Hennessy Louis Vuitton SA (use year-end figures rather than average values where appropriate) (Round your answers to 2 decimal places (e.g., 32.16).) :
2015
2016
Short-term solvency ratios:
Current ratio
Quick ratio
Cash ratio
Asset utilization ratios:
Total asset turnover
Inventory turnover
Receivables turnover
Long-term solvency ratios:
Total debt ratio
Debt–equity ratio
Equity multiplier
Times interest earned ratio
Profitability ratios:
Profit margin
%
%
Return on assets
%
%
Return on equity
%
%
arrow_forward
1. Using the financial statements for the following three companies calculate their current and quick ratios.
wsj.com/market-data/quotes/CA/RUS/financials/annual/balance-sheet (Russel Metals Inc.)
https://finance.yahoo.com/quote/AAPL/balance-sheet?p=AAPL (Apple)
https://finance.yahoo.com/quote/AMZN/balance-sheet?p=AMZN (Amazon)
2. After calculating the ratio assess each firm's liquidity and how they compare/contrast
3. if you were going to invest in one of these companies, which one would you choose and why?
arrow_forward
Compute DuPont Analysis Ratios
Selected balance sheet and income statement information for Humana Inc., a health and well-being company, follows.
2018
2017
Company
($ millions) Ticker Revenue income Assets Assets
Humana Inc HUM $66,832 $11,603 $35,333 $37,098
2018
Compute the following 2018 ratios for Humana.
a. Return on equity (ROE)
$
$
Note: 1. Select the appropriate numerator and denominator used to compute ROE from the drop-down menu options. 2. Enter the numerator and denominator amounts to compute ROE.
Numerator
Denominator
0 $
$
2018
Net 2018 2017 Stockholders' Stockholders'
0 $
♦
0
b. Profit margin (PM)
Note: 1. Select the appropriate numerator and denominator used to compute PM from the drop-down menu options. 2. Enter the numerator and denominator amounts to compute PM.
Numerator
Denominator
0 $
◆
Equity
$20,081
0
ROE
0
PM
c. Financial leverage (FL)
Note: 1. Select the appropriate numerator and denominator used to compute FL from the drop-down menu options. 2. Enter the…
arrow_forward
Please fill in blanks
arrow_forward
Using the data in exhibits C2.1 and C2.3, calculate and analyze the firm’s 2012 and 2013 ratios. Enter the ratios in the table below in the 2012 and 2013 columns, respectively:
Ratio Type
2012
2013
Current (times)
3.40
3.43
Quick (times)
2.18
1.83
Debt (%)
Times interest earned (times)
Inventory turnover (times)
Total asset turnover (times)
Average collections period (days)
Return on equity (%)
arrow_forward
Required 1. Compute each year’s current ratio. Round ratios to one decimal. 2. Express the income statement data in common-size percents. Round percents to two decimals. 3. Express the balance sheet data in trend percents with 2017 as the base year. Round percents to two decimals. Analysis Component 4. Comment on any significant relations revealed by the ratios and percents computed.
arrow_forward
Compute the following ratios for the most recent two years, show all values in the computations:
1.Current ratio
2.Accounts receivable turnover
3.Debt ratio(TotalLiabilities/Total Assets, as a percentage)
4.Debt-to-equity ratio
Based on the results above,
what conclusions can you make about the liquidity and solvency of the
company?
arrow_forward
correct answer please
arrow_forward
Comparative financial statement data of Garfield, Inc. follow:
Market price of Garfield’s common stock: $69.36 at December 31, 2018, and $38.04 at December 31, 2017.
Common shares outstanding: 14,000 on December 31, 2018 and 12,000 on December 31, 2017 and 2016.
All sales are on credit.
Compute the following ratios for 2018 and 2017:
2018
2017
a. Current ratio
b. Cash ratio
c. Times-interest-earned ratio
d. Inventory turnover
e. Gross profit percentage
f. Debt to equity ratio
g. Rate of return on common stockholders’ equity
h. Earnings per share of common stock
i. Price/earnings ratio
Decide (a) whether Garfield’s ability to pay debts and to sell inventory improved or deteriorated during 2018 and (b) whether the investment attractiveness of its common stock appears to have increased or decreased.
arrow_forward
A. Use the preceding financial statements to complete the following table. Assume that the industry averages given in the table are applicable for both 2002 and 2003. Thank you
arrow_forward
1. Compute the following ratios for the comparative periods (2018 and 2019). The company used 365 days in its computation for some of the ratios. Show your solution.
d. Accounts Receivable Turnover Ratio
e. Average Collection Period
f. Inventory Turnover Ratio
g. Average Days in Inventory
h. Number of days in Operating Cycle
i. Debt to Total Assets Ratio
j. Debt to Equity Ratio
k. Times Interest Earned Ratio
l. Gross Profit Ratio
m. Profit Margin Ratio
n. Return on Assets
o. Return on Equity
p. Assets Turnover Ratio
arrow_forward
Required:
Compute the following: (For Requirements 1 to 4, enter your percentage answers rounded to 2 decimal places (i.e., 0.1234 should
be entered as 12.34).)
1. Gross margin percentage.
2. Net profit margin percentage.
3. Return on total assets.
4. Return on equity.
5. Was financial leverage positive or negative for the year?
1. Gross margin percentage
%
2. Net profit margin percentage
%
3. Return on total assets
%
4. Return on equity
%
5. Financial Leverage
arrow_forward
Compute the following ratios for 2025 and 2024.
a. Currentratio
b. Inventory turnover. (Inventory on December 31,2023 , was$400.)
c. Profit margin.
d. Return on assets. (Assets on December 31, 2023, were$2,300.)
e. Return on common stockholders' equity. (Stockholders' equity-common on December 31,2023, was$950.)
f. Debt to assets ratio.
g. Times interest earned.
arrow_forward
Using available data in the case, calculate the requested financial ratios. Round all numbers to the nearest hundredth. For example,
answers should look like -0.05 or 1.33.
Use the following table to calculate Current Ratios for the years 2014, 2015, and 2016:
Year
2014
2015
2016
Current Assets Current Liabilities
6,086
5,914
8,137
ROA
ROE
Current Ratio
2016
0.78
%
%
8,532
8,516
10,397
2015
0.69
%
%
2014
0.71
%
%
arrow_forward
Do npt give image format
arrow_forward
Use the financial ratios of company A and company B to answer the questions below.
Company A Company B
Yr t+1 Year t Yr t+1 Year t
Current ratio 0.55 0.59 0.56 0.55
Accounts receivable turnover 6.22 6.25 5.06 4.87
Debt to total assets 40.5% 40% 67.8% 65.9%
Times interest earned 8.80 30.6 5.97 6.33
Free cash flows (in millions) ($3,819) $3,173 $168 $550
Return on stockholders’equity 7.7% 7.7% 26.6% 23.3%
Return on assets 4.3% 4.3% 8.9% 7.9%
Profit margin…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning

Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning

Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Related Questions
- Please provide answer this accounting questionarrow_forwardSome recent financial statements for Smolira Golf Corporation follow. Find the following financial ratios for Smolira Golf Corporation (use year-end figures rather than average values where appropriate): (Enter the profitability ratio answers as a percent rounded to 2 decimal places, e.g., 32.16. Round the remaining answers to 2 decimal places, e.g., 32.16.) 1. Long-term Solvency Ratios 2020 2021 Total debt ratio times times Debt-equity ratio times times Equity multiplier times times 2. Times interest earned times Cash coverage ratio times 3. Profitability Ratios Profit margin % Return on Assets % Return on Equity %arrow_forwardFind the following financial ratios for LVMH Moet Hennessy Louis Vuitton SA (use year-end figures rather than average values where appropriate) (Round your answers to 2 decimal places (e.g., 32.16).) : 2015 2016 Short-term solvency ratios: Current ratio Quick ratio Cash ratio Asset utilization ratios: Total asset turnover Inventory turnover Receivables turnover Long-term solvency ratios: Total debt ratio Debt–equity ratio Equity multiplier Times interest earned ratio Profitability ratios: Profit margin % % Return on assets % % Return on equity % %arrow_forward
- 1. Using the financial statements for the following three companies calculate their current and quick ratios. wsj.com/market-data/quotes/CA/RUS/financials/annual/balance-sheet (Russel Metals Inc.) https://finance.yahoo.com/quote/AAPL/balance-sheet?p=AAPL (Apple) https://finance.yahoo.com/quote/AMZN/balance-sheet?p=AMZN (Amazon) 2. After calculating the ratio assess each firm's liquidity and how they compare/contrast 3. if you were going to invest in one of these companies, which one would you choose and why?arrow_forwardCompute DuPont Analysis Ratios Selected balance sheet and income statement information for Humana Inc., a health and well-being company, follows. 2018 2017 Company ($ millions) Ticker Revenue income Assets Assets Humana Inc HUM $66,832 $11,603 $35,333 $37,098 2018 Compute the following 2018 ratios for Humana. a. Return on equity (ROE) $ $ Note: 1. Select the appropriate numerator and denominator used to compute ROE from the drop-down menu options. 2. Enter the numerator and denominator amounts to compute ROE. Numerator Denominator 0 $ $ 2018 Net 2018 2017 Stockholders' Stockholders' 0 $ ♦ 0 b. Profit margin (PM) Note: 1. Select the appropriate numerator and denominator used to compute PM from the drop-down menu options. 2. Enter the numerator and denominator amounts to compute PM. Numerator Denominator 0 $ ◆ Equity $20,081 0 ROE 0 PM c. Financial leverage (FL) Note: 1. Select the appropriate numerator and denominator used to compute FL from the drop-down menu options. 2. Enter the…arrow_forwardPlease fill in blanksarrow_forward
- Using the data in exhibits C2.1 and C2.3, calculate and analyze the firm’s 2012 and 2013 ratios. Enter the ratios in the table below in the 2012 and 2013 columns, respectively: Ratio Type 2012 2013 Current (times) 3.40 3.43 Quick (times) 2.18 1.83 Debt (%) Times interest earned (times) Inventory turnover (times) Total asset turnover (times) Average collections period (days) Return on equity (%)arrow_forwardRequired 1. Compute each year’s current ratio. Round ratios to one decimal. 2. Express the income statement data in common-size percents. Round percents to two decimals. 3. Express the balance sheet data in trend percents with 2017 as the base year. Round percents to two decimals. Analysis Component 4. Comment on any significant relations revealed by the ratios and percents computed.arrow_forwardCompute the following ratios for the most recent two years, show all values in the computations: 1.Current ratio 2.Accounts receivable turnover 3.Debt ratio(TotalLiabilities/Total Assets, as a percentage) 4.Debt-to-equity ratio Based on the results above, what conclusions can you make about the liquidity and solvency of the company?arrow_forward
- correct answer pleasearrow_forwardComparative financial statement data of Garfield, Inc. follow: Market price of Garfield’s common stock: $69.36 at December 31, 2018, and $38.04 at December 31, 2017. Common shares outstanding: 14,000 on December 31, 2018 and 12,000 on December 31, 2017 and 2016. All sales are on credit. Compute the following ratios for 2018 and 2017: 2018 2017 a. Current ratio b. Cash ratio c. Times-interest-earned ratio d. Inventory turnover e. Gross profit percentage f. Debt to equity ratio g. Rate of return on common stockholders’ equity h. Earnings per share of common stock i. Price/earnings ratio Decide (a) whether Garfield’s ability to pay debts and to sell inventory improved or deteriorated during 2018 and (b) whether the investment attractiveness of its common stock appears to have increased or decreased.arrow_forwardA. Use the preceding financial statements to complete the following table. Assume that the industry averages given in the table are applicable for both 2002 and 2003. Thank youarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning

Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning

Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning