Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Vertical trend analysis income statement

04/12/2021 Client: muhammad11 Deadline: 2 Day

Nova Southeastern University H. Wayne Huizenga School of Business & Entrepreneurship

Assignment for Course:

ACT 5140 – Accounting for Decision Makers

Submitted to:

Dr. Vik Desai

Submitted by:

xxx

xxx

Date of Submission: Sunday, September 27th 2015

Title of Assignment: Financial Analysis Assignment – Wal-Mart

CERTIFICATION OF AUTHORSHIP: I certify that I am the author of this paper and that any assistance I received in its preparation is fully acknowledged and disclosed in the paper. I have also cited any sources from which I used data, ideas or words, either quoted directly or paraphrased. I also certify that this paper was prepared by me specifically for this course.

Student's Signature: _

*****************************************************************

Instructor's Grade on Assignment:

Instructor's Comments:

ACT 5140 – Accounting for Decision Makers

Walmart Analysis Assignment

Directions: Answer all the questions. Please submit your work in Word or PDF formats only. You can submit an Excel file to support calculations, but please “cut and paste” your solutions into the Word or PDF file. Be sure to show how you did your calculations. Also, please be sure to include your name at the top of the first page of your file.

Part 1

Perform a vertical and horizontal analysis of Wal-Mart Stores, Inc.’s income statements and balance sheets as of January 31, 2015. In performing this analysis, consider any notable trends or changes that you observe that may provide useful information concerning its financial condition. Also use as many years’ worth of statements as you feel necessary. You should write up your results in paragraph form.

Part 2

Assess Wal-Mart, Stores Inc. concerning liquidity, solvency, profitability, and stock performance as of January 31, 2015. For each area, you should calculate the ratios we discussed in class and provide an analysis of the ratios calculated. I include historical stock price information and outstanding common share information below.

Fiscal Year Ended

1/31/2015

1/31/2014

1/31/2013

1/31/2012

Adjusted Closing Price

$83.94

$71.97

$65.79

$56.32

Common Shares Outstanding (millions)

3,228

3,233

3,314

3,418

Part 1 – Vertical and Horizontal Analysis

Vertical Analysis

Vertical analysis is a method in which the relationship between items in the same financial statement is identified by converting all amounts into percentages of the total. This method is also known as the common size as it allows to compare companies of different sizes in the same industry.

This type of analysis has two main advantages; the first is that the percentages can be compared over a number of periods allowing to identify unusual changes in the accounts over time. The unusual changes can be further analyzed and action is taken to bring percentages back to normal levels. The second advantage is that financials from companies of different sizes within the same industry can be compared. This type of comparison allows seeing where companies stand versus a particular competitor or the industry. In the case of Wal-Mart the comparison is performed to industry benchmark.

The vertical analysis on the income statement is performed by comparing each expense to the net sales and the balance sheet is performed by comparing each asset to the total assets and the liabilities, long term debt and equities are shown as a percentage of the total liabilities and stockholder equity.

Income Statement

The vertical analysis of Wal-Mart’s income statement was performed by dividing each expense over the net sales. This allows to see how each dollar of sales is distrusted among the various costs, expenses and profits. It also allows to see the trends of successive years for these items. For example, -----------------------------------------------------………. The consolidated net income ------from 2012 to 2013 but then …in 2014 and ….in 2015. So provide the analysis now

Balance Sheet

The vertical analysis of Wal-Mart’s balance sheet is performed by diving assets as a percentage of total assets and current liabilities, long term debt and equities as a percentage of total liabilities and shareholder’s equity. The balance sheet provides internal and external customer and owner’s essential information about the company’s financial position at a specific moment as it reveals the assets the same thing with balance sheet…………..

image1.png

Horizontal Analysis:

Horizontal analysis is a method that shows change in the amounts of financial statement items over a period of time. It is useful to evaluate trends within the company also known as the trend analysis. A base period needs to be establish which is the earliest period being analyzed. The items on the statements after the base period are compared to such. The horizontal analysis main purpose is to see how values change over time and not being utilized or distributed. The base period for the income statement and balance sheet will be 2012 for the purpose of this analysis.

Income Statement

The horizontal analysis for Wal-Mart’s income statement does not show a … trend. SAME THING HERE

Balance Sheet

The horizontal analysis for Wal-Mart’s balance sheet shows a …. trend. SAME THING HERE….

Part 2 – Ratio Analysis

Liquidity Ratios

Calculations:

· Current Ratio: total assets / total current liabilities

· Working Capital: Total assets – total current liabilities

· Acid-test ratio: (cash + accounts receivables) / total current liabilities

· Inventory turnover: cost of sales / average inventory

· Days sales in inventory: 365 / inventory turnover

· Accounts receivables turnover: total net sales / average accounts receivables

· Days sales in receivables: 365 / A/R turnover

· Free cash flow: Operating cash flow + capital expenditures

· Average Inventory: (inventory 2015 + inventory 2014)/2

· Average A/R: (accounts receivables 2015 + accounts receivables 2014)/2

Liquidity Ratios

Fiscal Year Ended

2/1/2015

2/2/2014

2/3/2013

1/29/2012

Current ratio

Working capital

Acid-test ratio

Inventory turnover (times)

Days sales in inventory

Accounts receivable turnover (times)

Days sales in receivables

Free cash flow

Average inventory

Average A/R

Analysis:

Liquidity ratios determine the company’s ability to pay off its short-term debt. The ability to turn short-term assets into cash to cover debt is very important for investor’s fundamental analysis. Wal-Mart’s current ratio has been … much l…..than the current ratio as a core part of their business is being eliminated from the calculation.

Overall the liquidity rations have been …………..…

Long-Term Solvency

Calculations:

· Debt to equity: long-term liabilities / total equity

· Interest coverage: operating income / interest expense

· Long-term liabilities: total liabilities - total current liabilities

Solvency Ratios

Fiscal Year Ended

2/1/2015

2/2/2014

2/3/2013

1/29/2012

Debt to equity

Interest coverage

Long term liabilities

Analysis:

The debt to equity ratio has …

Profitability Performance

Calculations:

· Asset turnover: total net revenues / average total assets

· Return on sales: adjusted net income / total net revenues

· Gross margin %: (total revenue – cost of sales) / total revenue

· Return on assets: adjusted net income / average total assets

· Return on equity: net earnings / average equity

· Average interest rate: interest expense / average total liabilities

· Average total assets: (total assets 2015 + total assets 2014)/2

· Income tax rate: Provision for income taxes / earnings before income taxes

· Net of tax interest expense: income tax rate * interest expense

· Adjusted net income: net earning + net of tax interest expense

· Average equity: (total shareholders’ equity 2015 + total shareholders’ equity 2014)/2

· Average total liabilities: (total liabilities 2015 + total liabilities 2014)/2

Profitability Ratios

Fiscal Year Ended

2/1/2015

2/2/2014

2/3/2013

1/29/2012

Asset turnover

Return on sales

Gross margin %

Return on assets

Return on equity

Average interest rate

Average total assets

Income tax rate

Net of tax interest expense

Adjusted net income

Average equity

Average total liabilities

Analysis:

Profitability ratios are important for the analysis of a company as well. They determined the company’s bottom line and its return to its investors.

The asset turnover ratio indicated that Wal-Mart is using its assets …

DuPont Model – Analysis of ROA

Calculations:

· Product: Return on sales * asset turnover

DuPont Analysis of ROA

Fiscal Year Ended

2/1/2015

2/2/2014

2/3/2013

Return on assets (calculated)

Return on sales

Asset turnover

Product

Analysis:

ROA has ….

Stock Performance

Calculations:

· Book value per common share: book value of equity / common shares outstanding

· P/E Ratio: adjusted closing price / earnings per share (diluted)

· Dividend yield: dividend per share / adjusted closing price

· Dividend payout: dividend per share / earnings per share (diluted)

· Adjusted basic EPS: adjusted net income / Weighted average shares outstanding: basic

· Adjusted diluted EPS: adjusted net income / Weighted average shares outstanding: diluted

· Adjusted P/E ratio: adjusted closing price / adjusted diluted EPS

· Adjusted dividend payout: Dividends per share / adjusted diluted EPS

Stock Ratios

Fiscal Year Ended

2/1/2015

2/2/2014

2/3/2013

1/29/2012

Book value per common share

Earnings per share (basic)

Earnings per share (diluted)

P/E Ratio

Dividend yield

Dividend payout

Adjusted Basic EPS

Adjusted Diluted EPS

Adjusted P/E Ratio

Adjusted dividend payout

Book value of equity

Common shares outstanding

Adjusted closing price

Dividends per share

Analysis:

Wal-Mart is a growing company. The book value has ………CONTINUE THE ANALYSIS

APPENDIX A

Wal-Mart’s Common Size Income Statement

WAL MART STORES INC

10-K

Income Statement

(Amounts in millions except per share data)

Fiscal Year Ended January 31,

2015

2014

2013

2012

2015

2014

2013

2012

Revenues:

%

%

%

%

Net sales

482,229

473,076

465,604

443,416

100.00%

100.00%

100.00%

100.00%

Membership and other income

Costs and expenses:

Cost of sales

Operating, selling, general and administrative expenses

Gross Margin

Operating income

Interest:

Debt

Capital leases

Interest expense

Interest income

Interest, net

Income from continuing operations before income taxes

Provision for income taxes:

Current

Deferred

Total provision for income taxes

Income from continuing operations

Income (Loss) from discontinued operations, net of tax

Consolidated net income

Consolidated net income attributable to noncontrolling interest

Consolidated net income attributable to Walmart

APPENDIX B

Discount Department Stores Industry Benchmark Common Size Income Statement (Data Period 2013)

Company Size

All

Large

Medium

Small

Size by Revenue

Over $50M

$5M - $50M

Under $5M

Company Count

Net Sales

100%

100%

100%

100%

Gross Margin

Officer Compensation

Advertising & Sales

Other Operating Expenses

Operating Expenses

Operating Income

Net Income

APPENDIX C

Wal-Mart’s Common Size Balance Sheet

WAL MART STORES INC

10-K

Balance Sheet

(Amounts in millions except per share data)

Fiscal Year Ended January 31,

2015

2014

2013

2012

2015

2014

2013

2012

ASSETS

%

%

%

%

Current assets:

Cash and cash equivalents

Receivables

Inventories

Prepaid expenses and other

Current assets of discontinued operations

Total current assets

Property and equipment, at cost

Less accumulated depreciation

Property and equipment, net

Property under capital lease

Less accumulated amortization

Property under capital lease, net

Goodwill

Other assets and deferred charges

Total assets

203,706

204,751

203,105

193,406

100.00%

100.00%

100.00%

100.00%

LIABILITIES AND SHAREHOLDERS EQUITY

Current liabilities:

Short-term borrowings

Accounts payable

Accrued liabilities

Accrued income taxes

Long-term debt due within one year

Obligations under capital leases due within one year

Current liabilities of discontinued operations

Total current liabilities

Long-term debt

Long-term obligations under capital leases

Deferred income taxes and other

Redeemable non-controlling interest

Commitments and contingencies

Total liabilities

Shareholders’ equity:

Common stock

Capital in excess of par value

Retained earnings

Accumulated other comprehensive income (loss)

Total Walmart shareholders' equity

Noncontrolling interest

Total equity

Total liabilities and shareholders’ equity

203,706

204,751

203,105

193,406

100.00%

100.00%

100.00%

100.00%

APPENDIX D

Discount Department Stores Industry Benchmark Common Size Balance Sheet (Data Period 2013)

Company Size

All

Large

Medium

Small

Size by Revenue

Over $50M

$5M - $50M

Under $5M

Balance Sheet

Cash

Accounts Receivable

Inventory

Total Current Assets

Property, Plant & Equipment

Other Non-Current Assets

Total Assets

Accounts Payable

Total Current Liabilities

Total Long Term Liabilities

Net Worth

APPENDIX E

Wal-Mart’s Trend Analysis Income Statement

WAL MART STORES INC

10-K

Income Statement

(Amounts in millions except per share data)

Base Year

Fiscal Year Ended January 31,

2015

%

2014

%

2013

%

2012

Revenues:

Net sales

Membership and other income

Costs and expenses:

Cost of sales

Operating, selling, general and administrative expenses

Operating income

Interest:

Debt

Capital leases

Interest expense

Interest income

Interest, net

Income from continuing operations before income taxes

Provision for income taxes:

Current

Deferred

Total provision for income taxes

Income from continuing operations

Income (Loss) from discontinued operations, net of tax

Consolidated net income

Consolidated net income attributable to noncontrolling interest

Consolidated net income attributable to Walmart

APPENDIX F

Wal-Mart’s Trend Analysis Balance Sheet

WAL MART STORES INC

10-K

Balance Sheet

(Amounts in millions except per share data)

Base Year

Fiscal Year Ended January 31,

2015

2014

2013

2012

ASSETS

Current assets:

Cash and cash equivalents

Receivables

Inventories

Prepaid expenses and other

Current assets of discontinued operations

Total current assets

Property and equipment, at cost

Less accumulated depreciation

Property and equipment, net

Property under capital lease

Less accumulated amortization

Property under capital lease, net

Goodwill

Other assets and deferred charges

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Academic Guru
Academic Mentor
Essay Writing Help
Engineering Help
Top Quality Assignments
Engineering Exam Guru
Writer Writer Name Offer Chat
Top Academic Guru

ONLINE

Top Academic Guru

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$21 Chat With Writer
Academic Mentor

ONLINE

Academic Mentor

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$31 Chat With Writer
Essay Writing Help

ONLINE

Essay Writing Help

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$50 Chat With Writer
Engineering Help

ONLINE

Engineering Help

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$30 Chat With Writer
Top Quality Assignments

ONLINE

Top Quality Assignments

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$36 Chat With Writer
Engineering Exam Guru

ONLINE

Engineering Exam Guru

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$25 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Rough Draft Qualitative Research Critique and Ethical Considerations - Homework - Each of the following items is accurately defined under fica as taxable wages except: - Earthen brother of boreas - 2 responses - Please choose a company from this list: Yahoo, LinkedIn, Dubsmash, Equifax, eBay, Adobe. Based upon the information you can find on the company and any past issues/breaches the company has gone through, create Crisis Management Plan. - Tijuana bronze machining case - Ancient grudge romeo and juliet meaning - Individual Article Presentation Business ethics. - Bus 308 week 3 assignment - How to win the glo bus simulation game - Acls patient cases robert mccrae answers - Camhs barking and dagenham - Need expert in economics to answer and help me understand economics graphs - Convert watts to amperage - Principles of incident response and disaster recovery 2nd edition - All about me math poster - Which of the following generates demand for foreign currencies? - Where to buy fresh epazote - Social realism in advertising - Reaserch on KONSTANTIN MELNIKOV - How are historians like detectives - Ibm short term disability - Cover page of a portfolio - How to calculate annualized rate of occurrence - Native american history ppt - Anu late submission penalty - Revenue Cycle Management and Reimbursement Models - Climate change and pizzly bears worksheet answer key - Carol chen miss san francisco - Discussion 8 - What is the compensation philosophy of maersk - Flexible combined honours degree - A beautiful mind movie questions answers - The wish roald dahl - April business simulation - As 2601 the demolition of structures - Three sources of artifacts in eeg recordings - Four Case Studies on Corporate Social Responsibility - Equations of motion worksheet with answers - How to hack a firewall - Gcse maths trigonometry revision - 8 vicars lane adelaide - Why did gonzo walk around carrying - Half round concrete culvert pipe - Business law and ethics 2nd edition - Minimum wage interest groups - Brisbane city council mowing nature strip - Theory practice gap in nursing example - Lasswade high school blazers - Cosi louis nowra quotes - How are forward rates quoted - What are the three types of family resources - Order 2315655: Target Corp. (Accounting) - Accounting: Week Eleven Discussion For the week eleven discussion board I would like you to take a look at a company website of your choice. - What does allusion mean - Is sodium nitrate a strong electrolyte - Ol 211 final project milestone two - Equilibrium constant in electrochemistry - Walden university positive social change - Market offerings are limited to physical products - Paper due tomorrow - Rewrite 10 1 3 as an improper fraction - Inputing data in spss - Cat hydraulic hose fittings - Internal conflict in the story of an hour - Effect of salt on boiling point of water experiment - HOMEWORK - Ipr curve excel - Cats country club thirsk - Brand equity management system - Grid organizational development ppt - Mean green mildew destroyer lowes - Curriculum guides for academic interventions - Precis writing exercises with answers - Anz capital notes offer - St francis school goosnargh - Australian fast foods pty limited - Scholar practitioner's guide to research design - B and e marketplace - Data Mining - Gap food safety plan template - South delaware coors case study solution - Cutting speed formula for turning - 19 halyard crescent seaford - Separation costs capsim - Current facility assignment p2 parole denver west metro region - Need in 8 hours - Bank engzenon com - Www timelessmyths com classical olympians html - The odyssey robert fagles summary - Secret life of bees chapter 3 questions and answers - Pci compliance policy and procedures template - Concept map pulmonary and systemic circulations - What are supply chain drivers - CASE 2 AND 3 - I need 400 words to edit and proofread my 4 medical cases - During the 700s spain was under the rule of _______ - Explain how dna sequences are used in classification - Mary help of christians prayer