Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You will analyze the company's past financial performance to help you forecast their future business, profitability, and cash flow. You will use these results to

You will analyze the company's past financial performance to help you forecast their future business, profitability, and cash flow. You will use these results to forecast the value of the company; what YOU think the company is actually worth today. You will compare your value to the current stock price, explaining any differences.

This is how decisions to buy and sell stock, and to buy and sell companies are made every day all over the world. The nightly business news is full of the "buy, sell, and hold" recommendations derived from analysis like this. I bet those jobs pay very nicely, don't you!

  • Introduction:The company's story- past, present, future. Include who they are (include current events and interesting facts), what they do (products), when they began (how long), and where they do business. Discuss the markets they operate in globally, the current market trends, and their competitors. This should go in debth
  • Financial History:(3-year analysis of the company's performance. Your report will include the ratio results plus an explanation and analysis of each ratio. Include the ratio, its results, and what the results mean for the company. (Liquidity and Debt, Asset Management, Profitability, and Market ratios. See ratio detail below.) Were there changes in the ratios? What could have caused the change? You must include an evaluation section of what each type of (LAPM) ratio means over the three years, then an overall comparison to validate your conclusion. (Show you understand and know the ratios.)
  • Financials Today:Current year with comparison to a competitor. What are they doing? How are they doing now? Add current events and focus on the current financials. Include an evaluation for each type of (LAPM) ratio for the current year, then an overall comparison to validate your conclusion. Include your findings for your competitor.
  • Financial Future:The story behind your analysis of your forecast of the future based on your spreadsheet. Why did you choose the specific growth rates? What impact did they have on the value of Walmart? Use the Walmart Proforma Income Excel spreadsheet located in Course Documents.
  • Conclusion:Your recommendation with justification of how much Walmart is worth. How much do you forecast each share to be worth? Defend your choice.

Required Ratio Analyses

Liquidity and Debt Ratios (L)

  • Current
  • Quick
  • Total Debt to Total Asset

Asset ManagementRatios (Activity A)

  • Inventory Turnover
  • Fixed Asset Turnover
  • Total Asset Turnover

Profitability Ratios (P)

  • Profit Margin on Sales
  • Return on Assets
  • Return on Equity

Market Value Ratios (M)

  • Price Earnings Ratio
  • Market/Book

Start your Walmart research at the website below. Click on everything and explore. This website will be the sole source of financial information for this part of the assessment.

https://www.msn.com/en-us/money/stockdetails/financials/nys-wmt/fi-a25ya2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Financial Management

Authors: Eugene F. Brigham, Joel F. Houston

Concise 6th Edition

324664559, 978-0324664553

More Books

Students also viewed these Finance questions

Question

3. Explain three discount strategies employed by wholesalers

Answered: 1 week ago