Complete a horizontal analysis of the income statement

Assignment Help Financial Accounting
Reference no: EM131082992

Walgreens Income Statement

 

 

Period Ending

Aug 31, 2013

Aug 31, 2012

Total Revenue

72,217,000

71,633,000

Cost of Revenue

51,098,000

51,291,000

Gross Profit

21,119,000

20,342,000

Operating Expenses

 

 

Research Development

-

-

Selling General and Administrative

17,543,000

16,878,000

Operating Income or Loss

3,940,000

3,464,000

Income from Continuing Operations

 

 

Total Other Income/Expenses Net

140,000

-

Earnings Before Interest And Taxes

4,060,000

3,464,000

Interest Expense

165,000

88,000

Income Before Tax

3,895,000

3,376,000

Income Tax Expense

1,445,000

1,249,000

Net Income From Continuing Ops

2,794,000

2,127,000

Net Income

2,450,000

2,127,000

 

WALGREENS BALANCE SHEET FOR 2012 AND 2013
Period Ending

Aug 31, 2013

Aug 31, 2012

Assets

 

 

Current Assets

 

 

Cash And Cash Equivalents

2,106,000

1,297,000

Short Term Investments

-

-

Net Receivables

2,632,000

2,167,000

Inventory

6,852,000

7,036,000

Other Current Assets

284,000

260,000

Total Current Assets

11,874,000

10,760,000

Long Term Investments

7,100,000

7,006,000

Property Plant and Equipment

12,138,000

12,038,000

Goodwill

2,410,000

2,161,000

Intangible Assets

-

-

Accumulated Amortization

-

-

Other Assets

1,959,000

1,497,000

Deferred Long Term Asset Charges

-

-

Total Assets

35,481,000

33,462,000

Liabilities

 

 

Current Liabilities

 

 

Accounts Payable

8,313,000

7,403,000

Short/Current Long Term Debt

570,000

1,319,000

Total Current Liabilities

8,883,000

8,722,000

Long Term Debt

4,477,000

4,073,000

Other Liabilities

2,067,000

1,886,000

Deferred Long Term Liability Charges

600,000

545,000

Total Liabilities

16,027,000

15,226,000

Stockholders' Equity

 

 

Common Stock

80,000

80,000

Retained Earnings

21,523,000

20,156,000

Treasury Stock

(3,114,000)

(2,985,000)

Capital Surplus

1,074,000

936,000

Other Stockholder Equity

(109,000)

49,000

Total Stockholder Equity

19,454,000

18,236,000

INSTRUCTIONS:

Using the Income Statement and Balance Sheet, please perform the following instructions.

1. Complete a Horizontal Analysis of the 2013 Income Statement

2. Complete a Vertical Analysis of the 2013 and 2012 Income Statement using Total Revenue as the base amount.

3. Indicate any unusual trends identified using Horizontal or Vertical Analysis.

4. Using the Balance Sheet of 2012 and 2013, compute the following ratios FOR 2012 AND 2013:

i. Current Ratio
ii. Inventory Turnover. Only Compute for 2013
iii. Gross Profit Percentage.
iv. AR Turnover. Only Compute for 2013. Please assume all revenue was sold on credit.
v. Debit-to-Equity Ratio
vi. Earnings Per Share (EPS). Please note Weighted Average Number of Shares Outstanding for 2013 was: 946,595,578 and for 2012 was 944,055,334

5. Identify any ratio changes from 2012 to 2013.

Reference no: EM131082992

Questions Cloud

Explain to the director how a firm can be profitable : A member of the board of directors is puzzled by the fact that the firm has had a very profitable year but does not have enough cash to pay its bills on time.
Diligence and risk management : Question One: What is the ISO31000 definition of risk and what is the utility of this definition? Question Two: In what way is pure risk different from a threat? Question Three: What is the difference between due diligence and risk management? Illust..
What is its inductance : What is its inductance?
Find and discuss all legal issues. : On January 3, 2016, Newman, a dedicated, long term postal work, delivered 30 letters in and 8 hour period. Todd Gak, Newman's supervisor, was so impressed that on January 4, 2016, he made the following statement:  It is now April 18, 2016, and New ma..
Complete a horizontal analysis of the income statement : Complete a Horizontal Analysis of the 2013 Income Statement. Complete a Vertical Analysis of the 2013 and 2012 Income Statement using Total Revenue as the base amount.
Calculate the maximum height to whichm1rises after collision : Calculate the maximum height to whichm1rises after the collision
Question regarding the effective organizational culture : What is organizational culture? What must strategic leaders do to develop and sustain an effective organizational culture?
Which of them is not considered an elementary particle : Which of the following is not considered an elementary particle?
Define the first order differential equations : Define the first order differential equations using the state variables - Define a state variable model for the system in a matrix notation.

Reviews

Write a Review

Financial Accounting Questions & Answers

  What price should matt charge per rental for the business

Matt is happy with the steady rental average of 6,400 per year. For this number of rentals, what price should Matt charge per rental for the business to make a 20 percent life-cycle return on investment?

  What are the total equivalent units for conversion costs

The Filling Department of Savannah Lotion Company had 3,000 ounces in beginning work in process inventory (60% complete). During the period, 40,400 ounces were completed. The ending work in process inventory was 600 ounces (25% complete). What are th..

  Decision on lease or buying the home

Determine whether it is financially more attractive for the Bergholts to rent or to purchase the home over a five-year holding period.

  Scenarios result in recognized gain or loss

Does each of the following scenarios result in a recognized gain or loss, and how much is the gain or loss? Adam sells his personal residence (adjusted basis of $150,000) for $100,000. There is a realized Select loss gain Correct 1 of Item 2 of $ tha..

  Identify each given transaction as an operating activity

Identify each transaction as (a) an operating activity, (b) an investing activity, (c) a financing activity, (d) a noncash transaction, or (e) not on the statement of cash flows.

  Uses a periodic inventory system-particular transaction

James Company began the month of October with inventory of $34,000. The following inventory transactions occurred during the month: Assuming that the James Company uses a periodic inventory system, prepare journal entries for the above transactions i..

  Compatibility-relative advantage and observability

Describe some products whose adoption rates have been affected by complexity, compatibility, relative advantage, observability, and/or trial ability.

  Actual manufacturing overhead

The following information was taken from the cost records of the Solom Corporation: Estimated manufacturing overhead $89.000 Actual manufacturing overhead $84,000 estimated direct labor hours 12,000 Actual direct labor hours 12,500 Solom applies manu..

  Contributions to the managerial decision-making process

Incremental analysis is the process of identifying the financial data that do not change under alternative courses of action.change under alternative courses of action.are mixed under alternative courses of action.no correct answer is given.

  Partners who share profits

Bob and Kathy are partners who share profits 60% and 40%. Their capital balances were both $60,000 before Donna was admitted to the partnership. Donna contributed $100,000 in cash to the partnership for a 30% interest. After Donna is admitted to the ..

  Which statement is true concerning a static budget report

How much sales are required to earn a target income of $80,000, if total fixed costs are $100,000 and the contribution margin ratio is 40%.

  What is percy''s cost of common equity

What is percy's cost of common equity - Percy Motors has a target capital structure of 40% debt and 60% common equity, with no preferred stock

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd