Project Spread Sheet - 939

Request Posted by
ladybugsd70

ladybugsd70

Rating : No Rating
Earned: $0
Request Detail
Price: $15
  • From: Business,
  • Due on: Wed 07 Mar, 2012 (02:04am)
  • Asked on: Wed 07 Mar, 2012
  • Due date has passed, but you can still Post Solution.
Description

Need help with the spread sheet portion of this assignment badly.

Please see the instructions below. I can provide all my research up to current week 10 to help. The reference site I have used is

 http://investing.money.msn.com/investments/stock-income-statement/?symbol=baÂ

Boeing is my company and all research was done on this link. Most questions covered 2008-2009 but some did cover the annual over time. If you wish to help me with the spread sheets please contact me and I can provide all other material I have done to this point for better understanding.

At this time I am looking for help on the spread sheet information as I should be able to take care of the written portion unless otherwise notified.

Â

Your final project is due in Module 11. There will be individual research assignments along the way that will help you in the development of your final project. The module they are due is noted in the time line below.

Time Line

Module

Assignment

01

Select a Company

02

Ratio Analysis of Fixed Assets

03

Ratio Analysis of Current Liabilities

04

Liability Analysis and Debt Ratio

06

Analysis and Return on Equity

08

Analysis, Free Cash Flow, and Cash Conversion Cycle

11

Final Project Due

Requirements

Choose a publicly held company. Collect two consecutive years of financial statements for the company. Visit the company's website and access an annual report under the investor/shareholder tab. Familiarize yourself with the company's history, goals, and objectives.

  1. Create a vertical and horizontal analysis report for the company's income statement and balance sheet. (This will result in four separate spreadsheets)
  2. Prepare a full ratio analysis of the company using your analysis assignments. (This will consist of one spreadsheet)
  3. Prepare a research paper according to the following criteria:
    1. Company overview(1-2 pages)
      1. History
      2. Executive Management team
      3. Projections for the future
      4. Other pertinent information
    2. Industry and competitive analysis (1-2 pages)
      1. Who are the 3 main competitors?
      2. What are the competitors' strengths?
      3. How competitive is the market?
      4. Projections for the future of the industry as a whole
    3. Conclusions (1 page)
      1. Company growth potential
      2. Your fully supported recommendation for investment. This is where you summarize the rest of the paper applying the information you have gained. Why did you decide how you decided?
    4. Attach copies of the financial statements or provide the URL of the website where the financial statements can be found.
  • Your final paper should be 4-6 pages in length.
  • Your spreadsheets should be contained onto five separate tabs of a single Excel file.
Attachments
Financial Accounting Project_all work so far and instructions.docx
Financial Accou...
Please Login or Register to Submit the Solution for the Request