ACC685-Financial Statement Analysis And Valuation

Task

Select two companies in the same industry that are publicly traded in a US stock market (ex: NYSE). It must be companies that sell inventory. You will need to use their financial statements for the two most recent fiscal years. They must be obtained from their 10-K filing with the SEC (sec.gov). The project is due the last week of class.

Requirements:

1.Using Excel, prepare common size financial statements for both years for each company.

2.Compute the following ratios using Excel for the past two years for each company (you must show all calculations):

Liquidity:

a.Current ratio

b.Acid-Test ratio

c.Collection period

d.Days to sell inventory

Capital Structure and Solvency:

a.Total debt to equity

b.Long-term debt to equity

c.Times interest earned

Return on Investment:

a.Return on assets

b.Return on common equit

Operating Performance:

a.Gross profit margin

b.Operating profit margin (pre-tax)

c.Net profit margin

Asset Utilization:

a.Cash turnover

b.Accounts receivable turnover

c.Inventory turnover

d.Working capital turnover

e.PPE turnover

f.Total asset turnover

Market Measures:

a.Price-to-earnings

b.Earnings yield

c.Dividend yield

d.Dividend yield payout rate

e.Price-to-book

3.Obtain copies of the most recently filed quarterly financial statements (10-Q) from the SEC website.

4.Read all of the notes to the financial statements.

5.Listen to the most recent analyst conference call. There should be a link on the company’s website in the “investor relations” section where you can listen to the recording.

6.Using the information from 1 – 5 above, prepare a 5-6 page pager discussing these various items:

a.Description of the business and main product(s) sold? Who are their major competitors? What countries do they mainly operate in?

b.Liquidity.

c.Capital Structure.

d.Return on Investment, Operating Performance and Asset Utilization.

e.Market Measures.

f.From the Notes, what method of accounting do they use for the following items (if applicable):

1.Leases

2.Inventory

3.Capitalization of Long Term Assets

4.Depreciation

5.Intangibles

6.Investments

g.What disclosure (if any) do they have about:

1.Contingencies

2.Accounting changes

3.Financial Instruments and Derivatives

4.Long-Term Debt

5.Incentive Programs (Stock Options, Stock Appreciation Rights, Etc…)

6.Pension/Retirement Benefits

7.Income Taxes (and Deferred Taxes)

h.Are there any additional disclosures that would be material to analyzing the company?

i.Do your companies have Other Comprehensive Income? If so, what items are they reporting as part of Other Comprehensive Income and how do they impact the ratios?

j.Do they use the equity method for any of their investments? Are there any investments where they have a controlling interest and there is a non-controlling interest?

k.Are they reporting any special items (unusual or infrequent) or any discontinued operations?

l.During the conference call, did management mention any events that impacted the financial statements? If so, how? Did they discuss any forecast and projections? If so, how will they impact any of the ratios?

m.Is management using any accounting policies to improve any of the ratios? For example, do they have operating leases versus capital leases that impact many of the ratios?

n.What is the company’s credit rating?

 

Pressed for time?

 

Hire a skilled expert and get original paper for 3+ hours now

More Similar Essays

White’s The Clash of Economic Ideas

Pick one of the topics to write a 6 page paper on. Please use citations and quotes mentioned in the topic you chose (An Outline of the history of Economic Thought by Screpanti or The Clash of Economic Ideas by White). 1. Screpanti/Zamagni in chapter 12 provide a host...

read more

Philosophy

1. Wright a summary of content and methods used in the chronological development of metaphysics. 2. Choose a philosopher from the ancient, medieval, or modern period then discuss and compare his distinct metaphysical teaching and method with Martin Heidegger (a...

read more

EXAM 4 History

5 short answer questions 2 essay questions. This exam covers Chapters 13-16 in the textbook.George Brown Tindall and David Emory Shi, America: A Narrative History (11th Edition, Volume 1) ISBN # 978-0-393-66893-3Joshua D. Rothman, Reforming America, 1815-1860. ISBN #...

read more