Discuss the trends revealed in each ratio

Assignment Help Financial Management
Reference no: EM131299785

Using DuPont analysis is a quick and relatively easy way to assess the overall health of a firm. Include information on the DuPont equation.

Go to finance.yahoo.com and choose a company by entering the company name in the box to the left of "Get Quotes." Once you have the company overview page open, to the left you will see a list of links for further information on that firm.

Near the bottom of the link column are financial statements. Open the firm's income statement and balance sheet and use the information there to calculate all parts of the DuPont Ratio for the past three years; do not use Nike. If your firm does not have 3 years of full information, choose a different firm. Report each ratio value as well as the numerator and denominator of each of the 4 ratios for the past 3 years (12 ratios in total). Discuss the trends revealed in each ratio.

Note your firm's name in the title of your post and please do not duplicate firms.
United Airlines

Income Statement
All numbers in thousands

Revenue

?12?/?31?/?15

? 12?/?31?/?14

?12?/?31?/?2013

Total Revenue

37,864,000

38,901,000

38,279,000

Cost of Revenue

12,130,000

16,611,000

17,192,000

Gross Profit

25,734,000

22,290,000

21,087,000

Operating Expenses

Research Development

-

-

-

Selling General and Administrative

18,423,000

17,795,000

17,629,000

Non Recurring

326,000

443,000

520,000

Others

1,819,000

1,679,000

1,689,000

Total Operating Expenses

-

-

-

Operating Income or Loss

5,166,000

2,373,000

1,249,000

Income from Continuing Operations

Total Other Income/Expenses Net

-327,000

-562,000

24,000

Earnings Before Interest and Taxes

4,839,000

1,811,000

1,273,000

Interest Expense

620,000

683,000

734,000

Income Before Tax

4,219,000

1,128,000

539,000

Income Tax Expense

-3,121,000

-4,000

-32,000

Minority Interest

-

-

-

Net Income From Continuing Ops

7,340,000

1,132,000

571,000

Non-recurring Events

Discontinued Operations

-

-

-

Extraordinary Items

-

-

-

Effect Of Accounting Changes

-

-

-

Other Items

-

-

-

Net Income

Net Income

7,340,000

1,132,000

571,000

Preferred Stock And Other Adjustments

-

-

-

Net Income Applicable To Common Shares

7,340,000

1,132,000

571,000

Balance Sheet

All numbers in thousands

Period Ending

?12?/?31?/?15

12?/?31?/14

? 12?/?31?/?13

Current Assets

Cash And Cash Equivalents

3,058,000

3,156,000

3,251,000

Short Term Investments

2,190,000

2,382,000

1,901,000

Net Receivables

1,128,000

1,146,000

2,179,000

Inventory

738,000

666,000

667,000

Other Current Assets

740,000

774,000

704,000

Total Current Assets

7,828,000

7,547,000

8,702,000

Long Term Investments

-

-

-

Property Plant and Equipment

21,580,000

19,467,000

18,047,000

Goodwill

4,523,000

4,523,000

4,523,000

Intangible Assets

4,136,000

4,284,000

4,436,000

Accumulated Amortization

-

-

-

Other Assets

757,000

774,000

1,104,000

Deferred Long Term Asset Charges

2,037,000

2,037,000

2,037,000

Total Assets

40,861,000

36,595,000

36,812,000

Current Liabilities

Accounts Payable

7,972,000

7,401,000

7,188,000

Short/Current Long Term Debt

1,483,000

2,117,000

1,485,000

Other Current Liabilities

2,959,000

2,990,000

3,434,000

Total Current Liabilities

12,414,000

12,508,000

12,107,000

Long Term Debt

10,400,000

10,524,000

10,924,000

Other Liabilities

6,255,000

7,288,000

6,600,000

Deferred Long Term Liability Charges

2,826,000

3,879,000

4,197,000

Minority Interest

-

-

-

Negative Goodwill

-

-

-

Total Liabilities

31,895,000

34,199,000

33,828,000

Stockholders' Equity

Misc. Stocks Options Warrants

-

-

-

Redeemable Preferred Stock

-

-

-

Preferred Stock

-

-

-

Common Stock

4,000

4,000

4,000

Retained Earnings

3,457,000

-3,883,000

-5,015,000

Treasury Stock

-1,610,000

-367,000

-38,000

Capital Surplus

7,946,000

7,721,000

7,425,000

Other Stockholder Equity

-831,000

-1,079,000

608,000

Total Stockholder Equity

8,966,000

2,396,000

2,984,000

Net Tangible Assets

307,000

-6,411,000

-5,975,000

Reference no: EM131299785

Questions Cloud

How much will you contribute to your retirement : What are the present-day tax savings from your retirement planning?
Create a list of the top five reasons : Create a list of the top five reasons you believe organizations needs teams.- From this list generate an outline that gives your personal insight into each reason and why you believe it is important.
How important is it for the industry practice advancement : What is your research area, the motivation of research, and how important is it for the industry practice/knowledge advancement?
What do you think is the main point of this video clip : Go to one of the Web sites that contain video clips (such as www.youtube.com) and view some video clips about estate planning. You can use search phrases such as "tips on estate planning." Select one video clip on this topic that you would recomme..
Discuss the trends revealed in each ratio : Report each ratio value as well as the numerator and denominator of each of the 4 ratios for the past 3 years (12 ratios in total). Discuss the trends revealed in each ratio.
University campus with one main campus : Answer the following questions if you were creating a network infrastructure for: 1. A university campus with one main campus 2. A large metropolitan area network 3. A corporate campus with multiple sites across the globe
What is your view on estate planning : Read one practical article about how psychology affects estate planning decisions. You can easily retrieve possible articles by doing an online search using the terms "psychology" and "estate planning." Summarize the main points of the article.
Calculate the premium and multiply the value of the object : Calculate the premium and multiply the value of the object being insured by the corresponding RATE. Note: See the RATE tables above. Get a quote and add all the premiums for all the objects being insured.
How much are dave’s cash flows reduced over the coming year : Assuming that Dave's marginal tax bracket is 25%, by how much should his federal taxes decline this year if he contributes $7,000 to his retirement account?

Reviews

Write a Review

Financial Management Questions & Answers

  What limitations prevent the forecasts from being foolproof

Give examples of how ratios gleaned from the financial statements can be used as a tool in helping a firm plan for the future. What do these ratios tell an individual analyzing them? What limitations prevent the forecasts from being foolproof?

  Markets required yield to maturity on comparable-risk bond

A bond that matures in 17 years has a $1,000 par value. The annual coupon interest rate is 9 percent and the market's required yield to maturity on a comparable-risk bond is 12 percent. What would be the value of this bond if it paid interest annuall..

  When evaluating the effect of a merger

When evaluating the effect of a merger, the European Union seeks to determine: the impact of the merger by a. totaling the total number of competitors left. b. amount of capital invested in the combined companies in relation to the remaining competit..

  Compute the monthly mortgage payment-future value

Compute the future value of a $240,000 home purchased today which increases in value by 3.5% annually for 10 years. Compute the monthly mortgage payment for a $200,000 mortgage loan for 30 years with a contract rate of 3.75%.

  Propose a range of cost of capital estimates to consider

The beta for GM is 1.185, the beta for the automobile industry is 0.97, the equity premium on the world market is assumed to be 6%, and the risk-free rate is 3%. Propose a range of cost-of-capital estimates to consider in the analysis.

  How many years do these bonds have left until they mature

Shinoda Corp. has 8 percent coupon bonds making annual payments with a YTM of 7.4 percent. The current yield on these bonds is 7.75 percent. How many years do these bonds have left until they mature?

  Opportunity or freedom to make mistakes crucial to learning

Why is the opportunity or freedom to make mistakes crucial to learning? 2. How can the opportunity or freedom to make mistakes contribute to performance improvement? 3. What advice do you think James Dyson would give to a recent college graduate who ..

  Lender charges interest at an annual effective interest rate

A 30-year loan of $1000 is repaid with payments at the end of each year. Each of the first ten payments is $80. Each of the next ten payments equals 80% of the amount of interest due. Each of the last ten payments equals the amount of interest due pl..

  What is the net gain or loss for each country

In comparison with free international lending, what happens if each country imposes a 2 percent tax on the international lending? What is the net gain, or loss, for each country?

  Calculate the WACC for Parrothead Enterprises

You are given the following information concerning Parrothead Enterprises: Debt: 10,900 7.4 percent coupon bonds outstanding, with 21 years to maturity and a quoted price of 108.75. These bonds pay interest semiannually. Common stock: 320,000 shares ..

  What is implied value of the warrants attached to each bond

Neubert Enterprises recently issued $1,000 par value 15-year bonds with a 5% coupon paid annually and warrants attached. These bonds are currently trading for $1,000. Neubert also has outstanding $1,000 par value 15-year straight debt with a 9% coupo..

  What is the value of the new firm debt

Sunburn Sunscreen has a zero coupon bond issue outstanding with a $20,000 face value that matures in one year. The current market value of the firm’s assets is $23,200. The standard deviation of the return on the firm’s assets is 27 percent per year,..

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