Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You will be consolidating all of the information you have gathered so far on your company and presenting it in a powerpoint presentation. If you

You will be consolidating all of the information you have gathered so far on your company and presenting it in a powerpoint presentation. If you are not familiar with powerpoint, you may consolidate it into a Word document. As with any PowerPoint presentation, it will not be able to include all information gathered over the semester, but should provide an adequate summary so that you have portrayed an accurate financial position for WalMart and explain any changes that have occurred.

Requirements of your presentation:

Introduction and brief history of WalMart (bullet points work best here)

Horizontal and vertical analysis. You wont be able to include the entire horizontal and vertical analysis on the slides due to size constraints, but you can include the highlights along with a discussion of significant items. An explanation of what you are presenting is required. Do not assume that your audience has a financial background. Explanations of what you found in the MD&A would also be very useful.

Discussion of ratio analysis and the evaluation of Walmarts performance.

Discussion of the companys stock history, including dividends, and comparison to other competitors.(**see below**)

Conclusion based on MD&A located in the annual report and other external sources, what future projections are being made about your company? Also, make a recommendation on whether you would recommend investing in this stock and why.

Stock Analysis:

What is the current stock price of WalMart? What about one year ago? 5 years ago? (you may use finance.google.com to view historical stock prices)

Include a stock price graph chart over the past year for WalMart. Can you explain any wild fluctuations?

What is WalMarts dividend policy? Do they pay dividends? If so, what have they historically paid out to the stockholders?

You will be consolidating all of the information you have gathered so far on your company and presenting it in a powerpoint presentation. If you are not familiar with powerpoint, you may consolidate it into a Word document. As with any powerpoint presentation, it will not be able to include all information gathered over the semester, but should provide an adequate summary so that you have portrayed an accurate financial position for WalMart and explain any changes that have occurred. image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Walmart Inc. Consolidated Balance Sheets Walmart Inc. n... Instructions: 1. You will copy or move this sheet into your encel file with your financial statements. 2. Insert the name of your company (heading) and the reported years of the financial data (column headings). 3. Column A tells you the name of the item you are calculating. Column B tells you the formula to perform the calculation. Columns C-E will be the calculations for the various years. 4. Columns C-E require cell references to the financial statements for calculations- do not type values! Format 3 decimal places. 5. Column E requires the calculation of the percentage of change of the results for columns Cix . Format 3 decimal places. 6. Column F will be where you perform your analysis of your results (interpretation of trend) from columns C \& D. Use your ebook Chapter 12 to help you understand the ratio or use google. old being the prior year, for enample ([2022-2021]/2) can not calculate it. Leverage positive or negative to stockholder? Consolidated Statements of Income Walmart Inr Consolidated Balance Sheets (Amounts in millions) 2022 2021 ASSETS Current assets: LIABILITIES AND EQUITY Current liabilities: Commitments and contingencies Equity: CommonstockCapitalinexcessofparvalueRetainedearningsAccumulatedothercomprehensivelossTotalWalmartshareholdersequityNoncontrollinginterestTotalequityTotalliabilitiesandequity2764,83986,904(8,766)83,2538,63891,891$244,8600.11%1.98%35.49%3.58%34.00%3.53%37.53%100.00%2823,64688,763(11,766)80,9256,60687,531$52,4960.11%1.44%35.15%4.66%32.05%2.62%34.67%100.00% Walmart Inc. Consolidated Balance Sheets Walmart Inc. n... Instructions: 1. You will copy or move this sheet into your encel file with your financial statements. 2. Insert the name of your company (heading) and the reported years of the financial data (column headings). 3. Column A tells you the name of the item you are calculating. Column B tells you the formula to perform the calculation. Columns C-E will be the calculations for the various years. 4. Columns C-E require cell references to the financial statements for calculations- do not type values! Format 3 decimal places. 5. Column E requires the calculation of the percentage of change of the results for columns Cix . Format 3 decimal places. 6. Column F will be where you perform your analysis of your results (interpretation of trend) from columns C \& D. Use your ebook Chapter 12 to help you understand the ratio or use google. old being the prior year, for enample ([2022-2021]/2) can not calculate it. Leverage positive or negative to stockholder? Consolidated Statements of Income Walmart Inr Consolidated Balance Sheets (Amounts in millions) 2022 2021 ASSETS Current assets: LIABILITIES AND EQUITY Current liabilities: Commitments and contingencies Equity: CommonstockCapitalinexcessofparvalueRetainedearningsAccumulatedothercomprehensivelossTotalWalmartshareholdersequityNoncontrollinginterestTotalequityTotalliabilitiesandequity2764,83986,904(8,766)83,2538,63891,891$244,8600.11%1.98%35.49%3.58%34.00%3.53%37.53%100.00%2823,64688,763(11,766)80,9256,60687,531$52,4960.11%1.44%35.15%4.66%32.05%2.62%34.67%100.00%

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

Accounting For Beginners

Authors: Warren Piper Ruell

1st Edition

1713479397, 978-1713479390

More Books

Students also viewed these Accounting questions