I need assistance with preparing the Historical Average and Standard Deviation, for Coca-Cola, and Apple, Inc., using 2014 financial statements.The returns need to be represented in percentages, at least for 20 years. how do I set up the excel spreadsheet with this information?

Once I have the above data, I need to find the Beta for Coca-Cola and Apple, the current and the historical beta.

Once I have the above Beta information, I need to address the following: what would be the impact if the stock market went up 10% today on the Coca-Cola and Apple stocks?