Excel spreadsheet

1 Excel spreadsheet + 1 Word document of 600 words

 

 

Select a publicly held company and access the company’s Web page on the Internet to read its most recent annual report. The annual report is typically found in an “Investor Relations” or “Company Information” section within the company’s Web site. Complete the following:

  • Using the company’s financial statements, construct a pro forma income statement and balance sheet for the company using the percentage-of-sales method.
  • Be sure to include the original statements along with a defendable sales forecast.
  • Upon completion of the financials, write a paper detailing the process and what you learned about the company as you work through this activity.1 Excel spreadsheet + 1 Word document of 600 words

     

     

    Select a publicly held company and access the company’s Web page on the Internet to read its most recent annual report. The annual report is typically found in an “Investor Relations” or “Company Information” section within the company’s Web site. Complete the following:

    • Using the company’s financial statements, construct a pro forma income statement and balance sheet for the company using the percentage-of-sales method.
    • Be sure to include the original statements along with a defendable sales forecast.
    • Upon completion of the financials, write a paper detailing the process and what you learned about the company as you work through this activity.