Financial Analysis and Firm Strategies Project

Financial Analysis and Firm Strategies Project

Please perform a financial analysis on two public companies in the same industry and interpret the firm policies and strategies. You only need to perform the analysis on one-year data. Here is the requirement for the final project. Please
note: The financial statements you look at must be issued after June 30th, 2020.

Content
Description of Content
Points
Part 1 Basic Information
In this part, please provide information about the firms and the source of the data. (15 points)
Company Name
Identify the two firm names.
5
Basic
Information
Including the firm industry, the firm location and other general information of the firms.
5
Source of the
Financial Data
Provide the link of the source data. For example, Walmart financial data is from: https://www.sec.gov/cgi-bin/viewer?action=view&cik=104169&accession_number=0000104169-19-000016&xbrl_type=v#
5

Part 2 Dupont Analysis Ratio
In this part, please calculate the DuPont analysis ratios for both of the firms for the most recent fiscal year. Please refer to the slides how to put the DuPont analysis together. (40 points)
ROE
Return on Equity=Net Income/Avg. Total Stockholder’s Equity
6
ROA
Return on Asset=Net Income/Avg. Total Asset
6
Financial
Leverage
Financial Leverage=Average Asset/Avg. Stockholder’s Equity
6
ROS
Return on sales =Net Income/Sales
6
Asset Turnover
Asset Turnover=Sales/ Avg. Total Asset
6
Put the ratios
under Dupont Analysis Framework and make comparison of the two firms.
ROE = ROS x Asset Turnover x Financial Leverage
(You need to interpret the performance of the two firms based on the numbers.)
10
Part 3 Horizontal Analysis (30 points)
In this part, please perform horizontal analysis on both of the companies.
Income statement
Horizontal analysis on Income Statement for both of the companies on the most two recent fiscal years (e.g. 2018 & 2019) financial statement.
10
Balance Sheet
Horizontal analysis on Balance Sheet for both of the companies on the most two recent fiscal years financial statement.
10
Interpretation
Interpretation of the horizontal analysis. The interpretation includes but is not limited to the following questions. How the sales increased/decreased in the past year? How have components of net income changes in the past year? Which company’s performance is improving? Were the companies expanding in the past year?
10
Part 4 Accounting Policies
Please select TWO accounts in the list and find the accounting policies in the financial statement notes of both firms. Please copy and paste the accounting policies into the project to see if the two firms have similar policies. (10 Points)
Account List
Revenue (Sales), Accounts Payable, Accounts Receivable, Long-term Liabilities (Bonds or Notes payable) , Inventories, Properties, Plant and Equipment, Intangibles, Contingencies.
Part 5 Strategies
Do the firms disclose their strategies about profitability, efficiency, or leverage? If they do, please paste it into the project. If there is no information about the strategies, please interpret the difference of the strategies of the two firms by using the financial ratios. If you believe the two firms have very similar strategies about profitability, efficiency, and leverage, please state your reasons. (5 points)

Hints to the Project:
1. Where to find the firm financial data?
The last topic in Module 1 provides the information. To be brief, you can easily find the information either from SEC
Edgar or the official website of the company.
2. There is so much information online, which information I should use for our project?
We should use the Annual Report for the firms. If you get information from SEC Edgar website, you should use 10-K
information. 10-K is annual report filings.
3. How do I know the two firms are in the same industry?
Here is the Standard Industrial Classification Codes (SIC code) list for the public firms. If the two firms have the same
SIC code, they are in the same industry. You only need the first three digits of the code match to be the same industry.
You can find firm’s SIC code by simply google “Kroger (Firm Name) SIC Code”.
4. A lot of ratios use average. How do I get the average?
Average is last years’ data add current years’ data divided by two. Here is the example:
Average Asset of 2018= (Asset at end of 2017 + Asset at end of 2018)/2
5. What do you mean accounting policies? Where do I find it?
Accounting policies are how the firms apply accounting standards and report the financial statement. We used a lot of
examples during the class. You can simply find this information under “Notes to Consolidated Financial Statements”.
You can only copy the critical information for each of the accounts. It is not necessary to paste the tables or lists in the
financial statement notes to the project.
For example, I find the following information for Walmart inventories:
“The Company values inventories at the lower of cost or market as determined primarily by the retail inventory method
of accounting, using the last-in, first-out (“LIFO”) method for Walmart U.S. segment’s inventories. The inventory at the
Walmart International segment is valued primarily by the retail inventory method of accounting, using the first-in, first-
out (“FIFO”) method. The retail inventory method of accounting results in inventory being valued at the lower of cost or market, since permanent markdowns are immediately recorded as a reduction of the retail value of inventory. The
inventory at the Sam’s Club segment is valued using the weighted-average cost LIFO method. On January 31, 2018 and January 31, 2017, the Company’s inventories valued at LIFO approximated those inventories as if they were valued at
FIFO.”
6. Where do I find firm strategies?
Firms usually discuss their strategies in the first part of the annual report, the general information about the business.
Firms also discuss their strategies in “item 7. Management’s Discussion and Analysis of Financial Condition and Results
of Operations” in the annual report.
For example, I find following information in Walmart annual report “Our objective of prioritizing strong, efficient growth
means we will focus on increasing comparable sales and eCommerce sales growth while slowing the rate of growth of
new stores and clubs. At times, we make strategic investments which are focused on the long-term growth of the
Company, which may not benefit comparable sales in the near term.”
You can use Ctrl + F to search “strategy” in the annual report. It is normal that the information is not about profitability,
efficiency or leverage. If you cannot find any information, just write your interpretation based on the ratios.
7. Which firm or which industry should I choose?
You can present any public firms. Not necessarily the firms we mentioned in the class. You can select the firms you
familiar with or the firms you interested in.

Last Completed Projects

topic title academic level Writer delivered