Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 2 You are required to carry out an income statement analysis for Walmart. Using Walmart's latest financials (AR-2018), create a spreadsheet for the income
Question 2 You are required to carry out an income statement analysis for Walmart. Using Walmart's latest financials (AR-2018), create a spreadsheet for the income statement which captures 3 years of historical information and 5 years of projections. The following expectations are to be met in completing this analysis. (25 points) To formulate your projections, utilize Thomson One, Factiva and/or Bloomberg. You are expected to create an Appendix with page printouts of your sources and reference them accordingly. If your numbers come from a certain page, reference the page. You may utilize the Print Screen function to do so. You also want to create a table as follows: Report Description Source Appendix Page Number Short description of Information being utilized SEC 10-K Supplemental Earnings Call Analyst Estimates Factiva Thomson One Averaging x, y You are expected to have an Assumptions Section that outlines key assumptions that govern your projections for Revenue Growth, COGS, SG&A, Taxes and Distributions. You are expected to reference your sources of information if you are plugging in analyst recommendations. Question 2 You are required to carry out an income statement analysis for Walmart. Using Walmart's latest financials (AR-2018), create a spreadsheet for the income statement which captures 3 years of historical information and 5 years of projections. The following expectations are to be met in completing this analysis. (25 points) To formulate your projections, utilize Thomson One, Factiva and/or Bloomberg. You are expected to create an Appendix with page printouts of your sources and reference them accordingly. If your numbers come from a certain page, reference the page. You may utilize the Print Screen function to do so. You also want to create a table as follows: Report Description Source Appendix Page Number Short description of Information being utilized SEC 10-K Supplemental Earnings Call Analyst Estimates Factiva Thomson One Averaging x, y You are expected to have an Assumptions Section that outlines key assumptions that govern your projections for Revenue Growth, COGS, SG&A, Taxes and Distributions. You are expected to reference your sources of information if you are plugging in analyst recommendations
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started