Examine publicly traded company-s financial statements

Assignment Help Basic Statistics

Reference no: EM13113214

1) Analyze a publicly traded company's financial statements for the prior five years. Include the following items as supplemental schedules to the analysis, prepared as individual worksheets within an Excel spreadsheet:

a) Horizontal analysis of the prior five years' income statement and balance sheet.
b) Vertical analysis of the prior five years' income statement and balance sheet.
c) Calculation of at least five significant liquidity ratios for each of the five years analyzed.
d) Calculation of at least five significant profitability ratios for each of the five years analyzed.
e) Calculation of at least five significant long-term debt-paying ratios for each of the five years analyzed.
f) Calculation of at least five significant investor ratios for each of the five years analyzed.

2) Prepare a paper (10-15 pages) that analyzes the financial strengths and weaknesses of the company examined.

a) The analysis should reference significant items found in the income statement, balance sheet, statement of cash flows, horizontal analysis, vertical analysis, and ratio analysis of the company examined.
b) A competitor analysis and comparison to industry averages should be presented.
c) A summary identifying whether the company would be attractive to investors and/or creditors must be included.

Reference no: EM13113214

Questions Cloud

What is the molecular formula of the compound : A particular compound contains, by mass, 41.4g carbon, 3.47g hydrogen, and 55.1g oxygen a 0.100 mol sample of this compound weights 11.60 g.

Determine which structure best suits apple needs : Explain how organizational design help to determine which structure best suits Apple's needs. Explain how good of a job does BankBoston do in ensuring a diverse workforce in its efforts to motivate employees?

How long will it take for sulfur to decay : Sulfur-38 has an atomic mass of 38.0 and a half-life of 2.87 hours. How long will it take for 99.99% of a sample of sulfur-38 to decay.

Illustrate what are some of risks associated with each plan : Illustrate what are some of the risks associated with each plan? If the yield curve is steeply inverted, which financing plan should Christensen choose?

Examine publicly traded company-s financial statements : Analyze a publicly traded company's financial statements for the prior five years. Include the following items as supplemental schedules to the analysis, prepared as individual worksheets

What happens when the exchange rate of the domestic economy : The industry pledges to increase its dividend by 6.00 percent per year indefinitely. If you require an 15.00 percent return on your investment, explain how much will you pay for the industry's stock today?

What is best way to connect the workstations to mainframe : Illustrate what is the best way to connect the workstations to the mainframe computer? Explain your reasoning and all the possible solutions you considered.

Explain whether distribution is approximated by normal curve : They plan to set up a radar trap and check the speeds of 80 randomly selected cars. Can this distribution be approximated by a normal curve?

Illustrate what is total production per day if change made : The cost of operating the cutting department two more hours each day is $1,600. The contribution margin of the finished products is $6 each. Inventory carrying costs are $0.40 per unit per day. Illustrate what is the total production per day if th..

User Account

All Pages