Data Project

One of the documents are the instuctions and the other document is the chart that you fill in! Please let me know if you have any questions, i will tip for good work!

ACCT7080-M50 Fall 2023
Project #1 (45 Points)
In this deliverable we will focus on the application of the material you are studying by analyzing the
financial performance of your favorite publicly held company over the last 13 months.
Our focus will be on the latest annual report filed with the SEC and the previous annual report. You
should use the SEC search engine called EDGAR to gather the information from the annual reports. We
will also use Yahoo Finance to discover certain financial performance measurements related to your
company.
Only use a company that files their statements in US dollars and in accordance with GAAP.
Complete the attached Excel spreadsheet. For the amounts, be sure to read the financial statement to
make sure you understand what is represented by each $1. It could be $1, $1,000, $1,000,000 or
$1,000,000,000.
Also, on the Excel Spreadsheet please provide the link to the two annual reports on line 7. For example,
if Federal Express was your company, you would supply this link to its latest annual report:
https://www.sec.gov/ix?doc=/Archives/edgar/data/1048911/000095017022012762/fdx-20220531.htm
Project #1 is due on 10/25/2023 by 11:59 pm. Upload your submission (Excel Spreadsheet provided)
to Canvas.
1
2
3
4
Company Name:
Stock Exchange:
Stock Symbol
Stock Price @9/1/2022
Stock Price @9/30/2023
5
Link
Most Recent Annual Report
Date:
6
7
8
9
10
11
12
13
14
15
16
Cash
Accounts Receivable
Inventory
Net Property And Equipment
Goodwill
Total Assets
Total Liabilities
Owner’s Equity
Total Revenue
Net Income after Income & Taxes
17
Did your company have Goodwill on the
balance sheet? If so, what caused it?
18
Using the Cash Flow Statement in the
latest Annual Report answer the following
questions. What is happening to the
company’s Cash position? Increasing or
decreasing? What is the major cause of
the increase/decrease?
19
Did Net Income after Income & Taxes
increase or decrease in the latest annual
report? What was the major reason for
change?
20
Using Yahoo Finance website (Summary
Tab) what is the current EPS (Earnings Per
Share)?
21
Using Yahoo Finance website (Summary
Tab) what is the current PE Ratio (Price
Earnings Ratio)?
22
Using Yahoo Finance website (Statistics
Tab) what is the Profit Margin?
23
Using Yahoo Finance website (Statistics
Tab) what is the Return on Assets?
24
Using Yahoo Finance website (Statistics
Tab) what is the Return on Equity?
25
Has your company been buying back its
own stock? If so, why would they do that?
Would you buy stock today in your
company? Why or why not?
Link
Previous Annual Report
Date:
Percent
Change
*
* Percent Change = (Most Recent Annual Report – Previous Annual Report)/Previous Annual Report