Finance investing project

heaven4040
individual_project_-_example_3.xlsx

Sheet1

FIN315 Individual Project Example
Name
Date - - - - - - Week 1 - - - - - - - - - - - - Week 2 - - - - - -
Stock Symbol Company Name Sector Beta Initial Investment Starting Shares Starting Price Total as of Friday Total Number of Shares Closing Price on Friday Total as of Friday . . . (Continue each week)
AVNR Avenir Pharmaceuticals Biotech 1.21 $10,000.00 2,283.11 4.38 $10,000.02 2,283.11
GM General Motors $10,000.00
IAU iShares Gold Trust $10,000.00
GE General Electric $10,000.00
AAPL Apple Inc. $10,000.00
Your Stock 1 $10,000.00
Your Stock 2 $10,000.00
Your Stock 3 $10,000.00
Your Stock 4 $10,000.00
Your Stock 5 $10,000.00
Total $100,000.00 (Compute this value) (Compute this value)
In the beginning, select your stocks and compute the starting number of shares.
Then compute the total values for each stock and the total for the portfolio for Week 1.
You will add columns and values each week.
By the end of the term, you need to add the Sector and Beta values for each stock.

Sheet2

Sheet3

Sheet4