Submit the Case Study Part 3: Trend Analysis for review here for T_{^{ossie Roll Inc.}}

One should use the most recent 5 years of data. The stock and index prices should correspond most closely to the date of the company's fiscal year-end.

Your numbers and calculations should follow this outline;

PART 3, TREND ANALYSIS: Use the most recent 5 years

Part a) Sales and Income Record:

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

20xx 20xx 20xx 20xx 20xx-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 -------------

20xx 20xx 20xx 20xx 20xx-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 -------------

20xx 20xx 20xx 20xx 20xx-last

---Chosen Co. 10,000 ____ ____ ____ ____

---Dow Jones 10,000 ____ ____ ____ ____

---S & P 500 10,000 ____ ____ ____ ____

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

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

This should be submitted as an Excel file all on one worksheet. Please be aware of formatting issues, as you will be copying this into your final report in Word.