Financial Ratios for Publicly Traded Companies

This assignment is an individual project where you will be focusing on financial ratios for publicly traded companies.

Step 1:

The textbook authors discuss a variety of financial ratios. Choose three ratios and calculate the financial ratios from each category for your company for the last five quarters. Select ratios that affect the company stock price and explain your reasoning.

Step 2:

Identify your company’s competitor, calculate the same ratios for that competitor, and contrast the results for the two companies over the most recent years. Explain why you selected this competitor. Describe how the decisions made by management impact your financial ratios.
Include a graph comparing each ratio for your companies side-by-side. Step 3:
Which company looks like a better investment? What financial ratios are more relevant given your analysis (parts one and two).

The list below contains the top 25 large-cap companies. Although you do not have to pick a company from this list, gathering information from these companies should be more accessible.

AAPL Apple Inc
MSFT Microsoft Corp
AMZN Amazon.com Inc
NVDA NVIDIA Corp
GOOGL Alphabet Inc
GOOG Alphabet Inc
TSLA Tesla Inc
META Meta Platforms Inc

BRK.B Berkshire Hathaway
Inc
XOM Exxon Mobil Corp
LLY Eli Lilly and Co

UNH UnitedHealth Group
Inc

JPM JPMorgan Chase &
Co
V Visa Inc

JNJ Johnson & Johnson
PG Procter & Gamble Co
AVGO Broadcom Inc
MA Mastercard Inc
HD The Home Depot Inc
CVX Chevron Corp
MRK Merck & Co Inc
ABBV AbbVie Inc
ADBE Adobe Inc

COST Costco Wholesale
Corp
PEP PepsiCo Inc

• The paper must be submitted in a Microsoft word format.
• You must do the analysis in excel and transfer your work to Microsoft word.
• Your paper must be your original work. If it is not, you will automatically fail the assignment.
• You may not submit work you have presented in other courses (I will use software to test the originality of your paper). If you do, you will automatically fail the assignment.
• The paper must contain between 500-1000 words.
• You must include at least three sources that substantiate your interest in your three ratios (step 1) .
• Paper grades will only be graded after the due date.
• Double space your paper
• Include a graph depicting a ratio-to-ratio comparison of each of your financial ratios. In total, you should have three graphs (see first Excel project Video).