WebMail 
Finance investing project
Finance investing project
This needs to be done in an excel spreadsheet using the first 5 stocks in the example as well as the following 5 stocks:
Corning
Walmart
Bestbuy
Pepsi
Amazon
The starting date of the project was July 12, 2013
So the data in the first column needs to reflect the prices of those stocks on Friday july 12, 2013. Every friday since then, so a total of 7 weeks worth of data needs to be added to the spread sheet and all data needs to be accurate.
July 12, July 19, July 26, Aug 2, Aug 9, Aug 16, Aug 23 all need to be added with the correct stock prices for their specific days.
Please make sure you use the exact example that was given in the attachements below. There are 10 stocks total, 5 were given and the 5 above.
Use the instructions on the first attachement as well
1.21
10000
2283.11
4.38
10000.0218
2283.11
10000
10000
10000
10000
10000
10000
10000
10000
10000
100000
FIN315
Individual Project
Stock
Symbol
Company
Name
Sector
Beta
Starting
Shares
Starting
Price
Week 1
Week 2
– – – – – –
Your Stock 1
Your Stock 2
Your Stock 3
Your Stock 4
Your Stock 5
Total Number of Shares
Total
Closing
Price on
Friday
(Continue each week)
Example
Name
Date
. . .
Initial
Investment
Then compute the total values for each stock and the total for the portfolio for Week 1.
Total as
of Friday
Total as of Friday
In the beginning, select your stocks and compute the starting number of shares.
AVNR
GM
IAU
GE
General Motors
Biotech
General Electric
iShares Gold Trust
Avenir Pharmaceuticals
AAPL
Apple Inc.
(Compute
this value)
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.
Attachments:
Is this the question you were looking for? If so, place your order here to get started!
