Question

In: Accounting

Macy's, Inc. (NYSE:M) > Financials > Key Stats In Millions of the trading currency, except per...

Macy's, Inc. (NYSE:M) > Financials > Key Stats
In Millions of the trading currency, except per share items. Currency: Trading Currency Conversion: Today's Spot Rate
Order: Latest on Right Units: S&P Capital IQ (Default)
Decimals: Capital IQ (Default) Dilution: Basic
Key Financials¹
For the Fiscal Period Ending 12 months
Jan-30-2016A
12 months
Jan-28-2017A
12 months
Feb-03-2018A
12 months
Feb-02-2019A
LTM²
12 months
Nov-02-2019A
Currency USD USD USD USD USD
Total Revenue                   27,079.0                   26,564.0                   25,641.0                   25,739.0                         25,449.0
Net Income                     1,072.0                        627.0                     1,566.0                     1,108.0                              964.0
Total Assets                   20,576.0                   19,851.0                   19,583.0                   19,194.0                         22,547.0
Total Liabilities                   16,323.0                   15,529.0                   13,850.0                   12,758.0                         16,490.0
Total Equity                     4,253.0                     4,322.0                     5,733.0                     6,436.0                           6,057.0
Total Debt                     7,802.0                     7,045.0                     6,072.0                     4,931.0                           7,816.0
  1. What is the ROA in last 5 years and the ROE in last 5 years?
  2. What is theRevenue and revenue growth in last 5 years?
  3. What is the Profit (net income) and profit growth in last 5 years?
  4. What is the Financial leverage and financial leverage growth in last 5 years?
  5. Any other financial information?

Solutions

Expert Solution

ROA and ROE

return on asset is the total profit the company generates as a percentage of value of assets.

ROA = (Net Income/ Total Value of Assets)*100

return on equity is how effective the management is in using a a company's asset to create profit

ROE = (Net Income/Average Shareholder Equity)*100

YEAR NET INCOME TOTAL ASSET AVG SHAREHOLDER EQUITY ROA ROE
2016 1072 20576 4253 5.2% 25.2%
2017 627 19851 4322 3.16% 14.5%
2018 1566 19583 5733 8% 27.32%
2019 1108 19194 6436 5.77% 17.22%
2019 (LTM) 964 20547 6057 4.7% 4.69%

Revenue and revenue growth

Revenue for the period are given

revenue growth is the percentage change in the revenue from previous year

revenue growth = [(current period revenue - previous year revenue )/ previous year revenue ]*100

YEAR Current PERIOD REVENUE PREVIOUS PERIOD REVENUE DIFFERENCE   REVENUE GROWTH
2016 27079 - - -
2017 26564 27079 (515) -1.9%
2018 25641 26564 (923) -3.47%
2019 25739 25641 98 0.38%
2019 LTM 25449 25739 (290) -1.13%
2019-2016 25739 27079 (1340) -4.94

there is a drop of 4.94 percent revenue as compared to 2016 period

net profit and profit growth in 5 years

net profit for the years are given it is the net amount the company earns after deducted its expenses.

profit growth is the percentage change in the profit in two given period of time that is current period and previous period.

profit growth = [(current year net profit - previous year net profit)/previous year net profit ]*100

YEAR Current PERIOD NET PROFIT PREVIOUS PERIOD NET PROFIT DIFFERENCE   PROFIT GROWTH
2016 1072 -
2017 627 1072 (445) -41.51%
2018 1566 627 939 149.76%
2019 1108 1566 (458) -29.25%
2019 LTM 964 1108 (144) -14.94%
2019-2016 964 1072 (108) -10%

the net profit in the last 5 years has decreased by 10 % when we compare 2016 to 2019 LTM

Financial leverage and Financial leverage growth in 5 years

Financial leverage is the use of debts to buy assets. It increases the return on equity

Financial leverage = Total Debt/Total Equity

Financial leverage growth is the change in the financial leverage during two period of time.

Financial leverage growth = [(Current year financial leverage - previous year financial leverage )/previous year financial leverage ]*100

YEAR TOTAL DEBT TOTAL EQUITY CURRENT FINANCIAL LEVERAGE PREVIOUS YEAR FINANCIAL LEVERAGE DIFFERENCE FINANCIAL LEVERAGE GROWTH
2016 4253 7802 0.56 -
2017 4322 7045 0.61 0.56 0.05 8.93%
2018 5733 6072 0.94 0.61 0.33 54%
2019 6436 4931 1.3 0.94 0.36 38.29%
2019 LTM 6057 7816 0.77 1.3 (0.53) 40.77%
2016-2019 LTM 6057 7816 0.77 0.56 0.21 37.5%

THE FINANCIAL LEVERAGE HAS INCREASED BY 37.5 WHEN COMPARED TO 2016.


Related Solutions

The following financial information (in millions except for per share amounts) is for two major corporations...
The following financial information (in millions except for per share amounts) is for two major corporations for the three fiscal years ended December 31 as follows: Canadian Pacific Railway Limited 2017 2016 2015 Weighted average number of common shares 145.9 149.6 159.7 Profit $2,405 $1,599 $1,352 Dividends $319 $274 $221 Market price per share (December 31) $229.66 $191.56 $176.73 Canadian National Railway Company 2017 2016 2015 Weighted average number of common shares 753.6 776.0 800.7 Profit $5,484 $3,640 $3,538 Dividends...
Apple Inc. CONSOLIDATED BALANCE SHEETS (In millions, except number of shares which are reflected in thousands...
Apple Inc. CONSOLIDATED BALANCE SHEETS (In millions, except number of shares which are reflected in thousands and par value) September 30, 2017 (LEFT) September 24, 2016 (RIGHT) ASSETS Current assets Cash and cash equivalents $ 20,289 $ 20,484 Short-term marketable securities 53,892 46,671 Accounts receivable, less allowances of $58 and $53, respectively 17,874 15,754 Inventories 4,855 2,132 Vendor non-trade receivables 17,799 13,545 Other current assets 13,936 8,283 Total current assets 128,645 106,869 Long-term marketable securities 194,714 170,430 Property, plant and...
1)Describe the key differences between currency futures and options. 2)Dec. 2020 Euro futures is now trading...
1)Describe the key differences between currency futures and options. 2)Dec. 2020 Euro futures is now trading at $1.1650.  If you buy one Euro futures contract (size = C$100,000) at this price and sold it at expiration when its price settles at $1.1720, what is your profit/loss from this transaction?
Cash Flow Flag INCOME STATEMENT Fiscal year ends in December. USD in millions except per share...
Cash Flow Flag INCOME STATEMENT Fiscal year ends in December. USD in millions except per share data. 2013-12 2014-12 2015-12 2016-12 2017-12 TTM Revenue 220156 200494 129925 110215 134674 154945 Cost of revenue 148882 136464 90788 78778 95114 110718 Gross profit 71274 64030 39137 31437 39560 44227 Costs and expenses Sales, General and administrative 4510 4494 4443 4684 4448 4358 Interest expense 201 307 731 Other operating expenses 30859 28334 29852 28712 25584 21980 Total costs and expenses 35369 32828...
XYZ, Inc has $300 millions of shares outstanding trading at$20/share. The company has a beta...
XYZ, Inc has $300 millions of shares outstanding trading at $20/share. The company has a beta of 1.2 and the expected market is 8%. T bill rate is 2.5%. The company has $25 million in interest expenses and a book value of debt of $135 millions. The debt will mature in 12 years and it has a BB rating. The spread for a BB rating is 3.5% and the long term T Bonds yield 5%. The company has an effective...
Key Figures Apple Google Net income (in millions) $ 45,687 $ 19,478 Cash dividends declared per...
Key Figures Apple Google Net income (in millions) $ 45,687 $ 19,478 Cash dividends declared per common share $ 2.18 $ - Common shares outstanding (in millions) 5,336.166 691.293 Weighted-average common shares outstanding (in millions) 5,470.820 687.782 Market value (price) per share $ 112.71 $ 771.82 Equity applicable to common shares (in millions) $ 128,249 $ 139,036 Required: 1. Compute the book value per common share for each company using these data. 2. Compute the basic EPS for each company...
The stock of Robotic Atlanta Inc. is trading at $ 29.48 per share. In the past,...
The stock of Robotic Atlanta Inc. is trading at $ 29.48 per share. In the past, the firm has paid a constant dividend of $ 5.52 per share and it has just paid an annual dividend (i.e., D0 = 5.52 ). However, the company will announce today new investments that the market did not know about. It is expected that with these new investments, the dividends will grow at 3.4 % forever. Assuming that the discount rate remains the same,...
Sears, Inc. common stock is currently trading on the NYSE at a price of $30 per...
Sears, Inc. common stock is currently trading on the NYSE at a price of $30 per share with 24,000,000 shares outstanding. Dividend just paid is $1.50 per share and is forecasted to grow at a constant rate of 12% in the future. U.S. 10-year Treasury Notes are currently yielding 2.5% and Sear’s outstanding 10-year debt with a face value of $50 million is currently trading at 96% of face value and pays annual interest of 10%. The expected rate of...
Financial statements for Steele Inc. follow. Steele Inc. Consolidated Income Statements (in thousands except per share...
Financial statements for Steele Inc. follow. Steele Inc. Consolidated Income Statements (in thousands except per share amounts) 2019 2018 2017 Net sales $7,245,088 $6,944,296 $6,149,218 Cost of goods sold (5,286,253) (4,953,556) (4,355,675) Gross margin $1,958,835 $1,990,740 $1,793,543 General and administrative expenses (1,259,896) (1,202,042) (1,080,843) Special and nonrecurring items 2,617 0 0 Operating income $701,556 $788,698 $712,700 Interest expense (63,685) (62,398) (63,927) Other income 7,308 10,080 11,529 Gain on sale of investments 0 9,117 0 Income before income taxes $645,179 $745,497...
The stock of DT Corp was trading at $21 per share when BW Inc. announced a...
The stock of DT Corp was trading at $21 per share when BW Inc. announced a deal to buy DT Corp for $28 per share. On the news, shares of DT moved up to $27 per share. However, deal might fall through due to regulatory concerns. If the EMV of buying the stock at $27 is zero, what is the probability that the deal will go through at $28 per share? [Assume that if the deal is blocked, the stock...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT