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?