J_Fitzgerald_FIN534_A1 Part 2

xlsx

School

Strayer University *

*We aren’t endorsed by this school

Course

534

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

13

Uploaded by jazzyswagg1

Report
Com Your Name: Industry: Retail Company 1 Name: Amazon Company 2 Name: Walmart Company 3 Name: Target Income Statement Information Total Revenue Amazon: $513,983,000.00 Walmart: $572,754,000.00 Target: $106,005,000.00 Gross Profit Amazon: $2,251,520.00 Walmart: $143,754,000.00 Target: $31,042,000.00 Net Income Amazon: -$2,722,000.00 Walmart: $13,673,000.00 Target: $6,946,000.00 EBITDA Amazon: $54,169,000.00 Walmart: $36,600,000.00 Target: $11,588,000.00 Balance Sheet Information Total Assets Amazon: $462,675,000.00 Walmart: $244,860,000.00 Target: $53,811,000.00 Total Liabilities U.S. Stock exchange: Company Name: Determine the free cash flow for the last two most recent years for the two companies. Explain how a company’s free cash flow (cash flow from operating activities minus capital expenditures) impacts its growth potential. Instructions: Find the numbers for these calculations from the income statement or balance sheet for each company from the annual report or 10-K. Make sure the numbers are not from the 10-Q or quarterly report as you want to make apples to apples comparisons.
Amazon: $31,663,200.00 Walmart: $152,969,000.00 Target: $40,984,000.00 Total Stockholders' Equity Amazon: $146,043,000.00 Walmart: $9,189,100.00 Target: $12,827,000.00 Rat Calculate the Following Ratios: Total Debt Amazon: $309.01B Walmart: $167.82B Target: $44.60B Gross Profits Amazon: $225,152,000.00 Walmart: $147,568,000.00 Target: $31,042,000.00 Operating Income Amazon: $12,248,000.00 Walmart: $20,428,000.00 Target: $8,946,000.00 Find the appropriate amounts from the 10K annual report and insert them into the form Formulas Amazon Profitability ratios: Profit margin = Net Income/Sales 2.43% 8.62% Efficiency ratios: 8.395 12.1337 Leverage ratios: 1.83 Debt/Assets = Total Liabilities/Total Assets 0.7 Liquidity ratios: 0.95 Debt to Equity Ratio Formula (Total Debt/Total Equity) Gross Margin Formula (Gross Profits/Sales) Operating Margin Formula (Operating Income/Sales) Return on equity = Net Income/Shareholders' Equity Inventory turnover = Cost of Goods Sold/Average Inventory Accounts receivable turnover = Net Sales/Average Accounts Receivable Debt to equity ratio = Total Liabilities/Shareholders' Equity Current ratio = Current Assets/Current Liabilities
0.7 Discuss three takeaways or an analysis of what you’ve learned about each company b Amazon: Walmart: Target: Quick ratio = (Current Assets - Inventory)/Current Liabilities Amazon's low profit margin at 2.43% sugge turnover of 8.395 and high accounts receiva equity ratio of 1.83 indicates a balanced fina debt-to-equity ratio contribute to its strong f Walmart's profit margin is 2.23%, similar to inventory management. However, its accou equity ratio of 2.09 suggests a higher relian Target's profit margin is 3.12%, indicating b suggesting less efficient inventory managem receivable. Target's debt-to-equity ratio is 4 strategies. These factors may influence Tar
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
mpany Analysis Ebay $866 Positive FCF not only provides the financial means to invest in growth init effective working capital management, all of which contribute to a compan Note: Choose Net Income or EBITDA. Generally accepted acco Income and EBITDA is optional. Foreign companies generally d makes the numbers look better.
tios Calculations Total Equity $168.06B $80.12B $11.02B Sales $0.00 $0.00 $0.00 Sales $0.00 $0.00 $0.00 mula to calculate. Walmart 2.23% 10.45% 7.5914 69.1732 2.09 0.62 0.87
0.23 based on their financial data. Include at least one para Analysis ests a focus on growth and market share over short-te able turnover of 12.1337 demonstrate efficient invento ancing approach and lower financial risk. Overall, Am financial position. Amazon's, indicating cost efficiency. Its high inventor unts receivable turnover is lower than Amazon's, sugg nce on debt financing, potentially increasing financial r better revenue-to-profit conversion. However, its inven ment. Additionally, the accounts receivable turnover is 4.05, indicating higher financial leverage and potential rget's financial performance.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
($1,055) Costco tiatives but also supports financial stability, debt reduction, and ny's ability to grow and thrive in a competitive business environment. ounting principles (GAAP) only requires the use of Net do not follow GAAP and use EBITDA because it normally
Debt to Equity Ratio 1.83 2.09 4.05 Gross Margin $0.00 $0.00 $0.00 Operating Margin $0.00 $0.00 $0.00 Target 3.12% 30.51% 5.3922 0 4.05 0.8 0.86
0.14 agraph for each company. erm profitability. The company's high inventory ory management. Amazon's moderate debt-to- mazon's efficiency, high inventory turnover, and low ry turnover of 7.5914 demonstrates efficient gesting slower collection. Walmart's higher debt-to- risk. ntory turnover is the lowest among the three, s almost zero, suggesting minimal accounts l risk due to financing choices or investment
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Stock Analysis Your Name: Jasmine Fitzgerald Industry: Retail Company Name 1: Amazon Company Name 2: Walmart Company Name 3: Target Stock Ticker Symbol Amazon : AMZN Walmart : WMT Target : TGT Fiscal Year End Date: Amazon: 84.00 Walmart: 140.18 Target: 145.81 Amazon: $1291.47B Walmart: $427.31B Target: $50.24B Amazon: $0.00 Walmart: 43.27 Target: 21.88 Amazon: 5% Walmart: 1% Target: 4% Instructions: Find the numbers for these calculations from the income statement or balance sheet for each company from the annual report or 10-K. Make sure the numbers are not from the 10-Q or quarterly report as you want to make apples to apples comparisons. Stock Price Include the stock price at the balance sheet date . (Stock prices fluctuate daily and are available in the Wall Street Journal) Market Cap Formula (Share Price/Number of Shares) Price to Earnings Ratio Formula (Share Price/EPS) Current Dividend Yield - Year End Formula (DPS/Share Price)
Analysis Amazon: Walmart: Target: Discuss the performance of the stocks, how the company's performance Include at least one paragraph for each company. You can consult the no financial statements to find a detailed explanation or you can use Manag Amazon's stock price was $84.00 at a low P/E ratio. The company's perfo However, its low P/E ratio suggests it expansion into e-commerce, cloud co Walmart's stock price was $140.18, w performance is influenced by factors management. Its investment potentia expand its online presence, while its Target's stock price was $145.81 at t P/E ratio of 21.88. Its resilience in e-c attractive for investors. Target's perfo industry competition. Its investment p expanding its online presence.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
s impacts the stock performance, and their investment potential. otes to the financial statements that appear right after the gement's Discussion and Analysis in the Annual (10K) Report. the balance sheet date, with a market capitalization of $1,291.47 billion and ormance has been remarkable, with significant growth over the years. t may not generate significant earnings due to reinvestment. Amazon's omputing, and entertainment has contributed to its market dominance. with a market capitalization of $427.31 billion and a P/E ratio of 43.27. Its like consumer spending, e-commerce competition, and supply chain al is influenced by its ability to adapt to changing retail landscapes and lower dividend yield may appeal to income-focused investors. the balance sheet date, with a market capitalization of $50.24 billion and a commerce competition and 4% current dividend yield at year-end make it ormance is influenced by consumer trends, seasonal factors, and retail potential is driven by adapting to changing consumer preferences and