Trend Analysis for review here.Refer to thecase study frameworkon theCase Study Outline and Resourcespage as aguidefor your submission., although you will be entering this into an Excel spreadsheet.

One should use the most recent 5 years of data.The stockand indexprices should correspond most closely to the date of the company's fiscal year-end.You may use the Adjusted closing price.

Your numbers and calculations should follow this outline;

PART 3, TREND ANALYSIS:Use the most recent 5 years for general electric company

Part a) Sales and Income Record:

------------- Fiscal Years -------------

20xx20xx20xx20xx20xx-last

Sales____________________

Percent change in

sales each year________________

--Mean change over 4 years_____

Net Income____________________

Percent change in

net income each year________________

--Mean change over 4 years _____

Graph the percent changes in sales and net income.

COMMENTS: Comment on the trends you see in your numbers.

Part b) Stock Price Record:

------------- Fiscal Years -------------

20xx20xx20xx20xx20xx-last

---Stock price at FYE____________________

---Dividends paid during year____________________

---Total Return to Holders________________

--Mean change over 4 years _____

---Dow Jones Index at FYE____________________

--Total Return on Index________________

--Mean change over 4 years _____

---S & P 500 Index at FYE____________________

---Total Return on Index________________

--Mean change over 4 years _____

COMMENTS: Comment on the trends you see in your numbers.

If a person invested $10,000 in each of the 3 items, how much would the investment grow to over the same periods of 4 years?

------------- Fiscal Years -------------

20xx20xx20xx20xx20xx-last

---Chosen Co.10,000________________

---Dow Jones10,000________________

---S & P 50010,000________________

Graphthe change in value over the 4 years for the 3 different investments.

COMMENTS: Comment on the trends you see in your numbers and graph.