Purdue Global University Comprehensive Financial Analysis Paper


Your paper should approach 20-pages and should be viewed as a term paper. Ask your instructor any questions in the Virtual Office.
Refer to the following documents found in Course Documents to help you with this assignment:

Format for the Walmart Research Paper
Walmart Proforma Income Excel Spreadsheet
Walmart Ratio Solutions 2017 LAPM (Use this as a guide.)

In this assignment, you will be assessed based on the following Outcomes:
MT482-6: Determine the value of a company through conducting effective earnings forecasts and analysis.
GEL-1.02: Demonstrate college-level communication through the composition of original materials in Standard English.
This is a challenging activity. You should prepare to spend substantial time working on your response.
In this research paper, you will dig deep into the financial statements of Walmart. 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!
Your paper must include the following criteria in addition to a title and references page:

Executive Summary: This is a 1-page summary of the entire paper that highlights the key results of your analysis and the resulting conclusions, and a summary of their defense.
Table of Contents: List of the sections in your paper.
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 be at least 2-pages, likely more.)
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)

Total Debt to Total Asset

Asset Management Ratios (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

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 assignment.
Walmart, Inc. (n.d.). https://www.msn.com/en-us/money/stockdetails/finan…

3 attachmentsSlide 1 of 3attachment_1attachment_1attachment_2attachment_2attachment_3attachment_3

Unformatted Attachment Preview

Terminal Value
Year 5
Walmart — Pro Forma Income Statements ($ in millions) M&A – Current Value Estimate – 2019 Actual
Fiscal Year
$567.945 Growth Rate
Gross Profit
Fixed Costs – SG&A
Variable Costs
Other Income
Net Income
EPS – Before Interest Exp.
Cash Flows
Operating Cash Flow
Residual Value
Capital Spending
Cash Flow
Discount Rate (WACC)
11,00% assumed
Net Present Value
$322.757,14 Our current estimate of WalMart’s total value in Millions
Shares Outstanding
Value Per Share
$364.783,27 PE Mulitple
Based on your growth, PE, WACC, and Outstanding Shares Assumptions
this is your valuation of Walmart’s shares
Students, you change the numbers above in RED to reflect your analysis of the company … the value of the
company will update based on you assumptions …
Assumptions of growth, cost structure, taxes, PE Ratio, WACC, and Shares Outstanding.
20 assumed
Walmart 2019 Ratios
Liquidity & Debt
Total Debt to Total Asset
Current Assests/Current Liabilites
(CA – Inventories)/Current Liabilites
Total Debt/Total Assests
Asset Management
Inventory Turnover
Fixed Asset Turnover
Total Asset Turnover
CGS/ Inventories
Sales/ Net Fixed Assests
Sales/Total Assets
Profit Margin on Sales
Return on Assests
Return on Equity
Net Income/Sales
Net Income/Total Assets
Net Income/Common Equity
Market Value
Price Earnings Ratio
Price of Shares/Earning Per Share
Market Price/Book Value (Per Share)
per year

Purchase answer to see full

Explanation & Answer:
20 Pages

User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.

Reviews, comments, and love from our customers and community:

This page is having a slideshow that uses Javascript. Your browser either doesn't support Javascript or you have it turned off. To see this page as it is meant to appear please use a Javascript enabled browser.

Peter M.
Peter M.
So far so good! It's safe and legit. My paper was finished on time...very excited!
Sean O.N.
Sean O.N.
Experience was easy, prompt and timely. Awesome first experience with a site like this. Worked out well.Thank you.
Angela M.J.
Angela M.J.
Good easy. I like the bidding because you can choose the writer and read reviews from other students
Lee Y.
Lee Y.
My writer had to change some ideas that she misunderstood. She was really nice and kind.
Kelvin J.
Kelvin J.
I have used other writing websites and this by far as been way better thus far! =)
Antony B.
Antony B.
I received an, "A". Definitely will reach out to her again and I highly recommend her. Thank you very much.
Khadija P.
Khadija P.
I have been searching for a custom book report help services for a while, and finally, I found the best of the best.
Regina Smith
Regina Smith
So amazed at how quickly they did my work!! very happy♥.