We will do this in 2 steps. You will compare 2 companies. All the following must be
Question:
We will do this in 2 steps. You will compare 2 companies. All the following must be provided for both companies. I prefer showing both in the same charts/graphs, but they can be shown separately. We will work with these 2 companies:
Macy's - Inline XBRL Viewer (sec.gov) (Links to an external site.)
Nordstroms -Inline XBRL Viewer (sec.gov) (Links to an external site.)
The links will take you to their most recent annual reports. These were issued in March of this year.
Both companies are retailers that often compete in the same mall or locations. They are both "legacy" businesses - that is they've been around for a while - but both have evolved to online offerings. The ultimate project which we will complete next week is to compare the two and make a recommendation as to which you would suggest a client to invest in.
All the information to complete the requested items are in the statements. You can use search (control f) to find some of these. Some will have to be calculated. I have posted a discussion board for any questions/answers or other comments.
Excel Workbook
You will submit one Excel workbook which will contain three worksheets. The first worksheet will include the financial data needed for each corporation. You will find this information by looking up each corporation’s annual report on the Internet. Use the 2018 and 2019 year-end data. Use only the annual report for the financial statements. The second worksheet will be the required ratio calculations for each corporation utilizing formulas in Excel. The third worksheet will be graphs
Required Financial information to graph/chart
- Stock price on December 31st 2019 and December 31st 2018
- Annual
- Earnings per share
- Revenue
- Net Income
- Total Assets
- Total Equity
- Total Liabilities
- Dividends per share
Required Ratios:
- Current Ratio
- Profit Margin
- Price to Earnings
- Return on Equity
- Return on Total Assets
- Debt Ratio
Required Graphs
- Annual revenue for 3 years
- Earnings per share for 3 years
- Return on equity for 3 years
Fundamentals of corporate finance
ISBN: 978-0470876442
2nd Edition
Authors: Robert Parrino, David S. Kidwell, Thomas W. Bates