Friday, August 5, 2016

Stock Project

NOTE: I found an old school project- spend $1000 on stocks and track them for the school year and see who makes the most money. I did this project back in December 2008, almost 8 years ago now -- and I did not win. Here's the project in it's entirety-


Activision Blizzard (ATVI) is the first stock I chose to invest in. On Aug 28, 2008 one stock was trading for $16.77, and I purchased 9 shares for a total of $150.93. I purchased this stock because it is my favorite video game company, and a recent merger made it the largest video game company in the world. It has a few high-profile releases coming up in the near future, including Guitar Hero: World Tour and World of Warcraft: Wraith of the Lich King.

The second stock I chose to invest in is Electronic Arts, which trades at ERTS. On Aug 28, 2008 the closing cost was $46.82. At that price, I purchased 4 shares for a total of $187.28. ERTS is a major competitor to ATVI, and the entire video game industry is booming currently. ERTS, after acquiring multiple game studios, was the largest company until a recent merger between Activision and Blizzard, which put ATVI slightly ahead.

Diamond Offshore Drilling is the third company that I invested in. They trade as just DO. The closing price for this stock on Aug 28, 2008 was $108.42, and I only bought one stock—making the total spent on DO just $108.42. Diamond Offshore Drilling is a world leader in offshore drilling, with roots in companies founded as early as 1953. The eventual merger of ODECO, Zapata, and Diamond M lead to the creation of this oil giant. I opted to invest in this company because the price of oil has skyrocketed in recent months.

The next company is known as NOV, or National Oilwell Varco. On the 28th of Aug. 2008, one share cost $74.90 and I was only able to purchase one. The total amount I spent on this company was $74.90. I opted to invest in this company because Oil seems like a very solid investment, especially with gas being over $4/gallon. NOV leads the world in the design, manufacture and sale of all the things used to get fuel out of the ground. From Oilfield tubular inspection to internal tubular coatings, National Oilwell Varco is a prevalent company on the oil front.

The last company that I invested in is Exxon Mobile Corporation, traded as XOM. On Aug 28, 2008 one share in the company cost $78.71 and at that cost I purchased 6 shares. The total I spent on this stock was $472.26. XOM is my safest investment, being the most profitable company in the world; it won’t be going anywhere anytime soon. This years outrages fuel prices are sure to make the profits be even higher this year.

In conclusion, I spent a total of $993.79 on all of my stocks.

A line graph is an excellent tool to show changes in data, especially changes in data over a timeframe. In this project, the line graph is used to show the values of stocks from Aug 28 through Dec 1, and then a line of regression is used to predict the cost of said stock on Jan 1.  
Activision Blizzard (ATVI) is the first stock I chose to invest in. On Aug 28, 2008 one stock was trading for $16.77, and I purchased 9 shares for a total of $150.93. On Dec 1, the closing cost fell to $10.53. I lost a total of $56.16.

The second stock I chose to invest in is Electronic Arts, which trades at ERTS. On Aug 28, 2008 the closing cost was $46.82. At that price, I purchased 4 shares for a total of $187.28. By Dec 1, the closing cost for this stock fell to $17.77. I lost a total of $116.20.

Diamond Offshore Drilling is the third company that I invested in. They trade as just DO. The closing price for this stock on Aug 28, 2008 was $108.42, and I only bought one stock—making the total spent on DO just $108.42. The closing cost on Dec 1 was $65.91, losing me $42.51.

The next company is known as NOV, or National Oilwell Varco. On the 28th of Aug. 2008, one share cost $74.90 and I was only able to purchase one. The total amount I spent on this company was $74.90. The closing cost by Dec 1, fell to a dismal $23.15. This lost me a total of $51.75.

The last company that I invested in is Exxon Mobile Corporation, traded as XOM. On Aug 28, 2008 one share in the company cost $78.71 and at that cost I purchased 6 shares. The total I spent on this stock was $472.26. XOM on Dec 1 was worth 74.31, and I lost a total of $26.40

In conclusion, I spent a total of $993.79 on all of my stocks, and lost a total of $293.02. Most importantly, I learned a lot about excel through trial and error. Excel is a powerful program, the inner-workings of which I can navigate through much better now than in the past. These are skills that will certainly come in handy in the future, be it for another class or for a job. I also learned not to invest in oil at the peak of it’s cost, from there is only has one place to go: down.
Name of Stock
Symbol
8-25 Closing
12-1 Closing
Number Purchased
Total Spend on Stock
Earn or (Loss)
Predicion Closing Jan 30, 2008
Activision Blizzard
ACTI
$     16.77
$    10.53
9
$  150.93
$    (56.16)
######
Electronic Arts
ERTS
$     46.82
$    17.77
4
$  187.28
$  (116.20)
######
Diamond Offshore Drilling
DO
$  108.42
$    65.91
1
$  108.42
$    (42.51)
######
National Oilwell Varco
NOV
$     74.90
$    23.15
1
$    74.90
$    (51.75)
######
Exxon Mobil Corporation
XOM
$     78.71
$    74.31
6
$  472.26
$    (26.40)
#######
Total Earned or (Lost)




$  993.79
$  (293.02)


STOCK MARKET PROJECT

This ends the old project. Now let's update the results!

Name of StockSymbol8-25-08 Closing8-4-16 ClosingCountTotal SpentCurrent ValueEarn or -Loss
Activision BlizzardACTI$16.77$40.789$150.93$367.02$216.09
Electronic ArtsERTS$46.82$78.234$187.28$312.92$125.64
Diamond Offshore DrillingDO$108.42$21.361$108.42$21.36-$87.06
National Oilwell VarcoNOV$74.90$32.561$74.90$32.56-$42.34
Exxon Mobil CorporationXOM$78.71$87.486$472.26$524.88$52.62
Totals$993.79$1,258.74$264.95
Freakin' BOOM! My $300 deficit has replaced itself with with a $250 profit!

Which sadly, still wouldn't have been enough to win.

No comments:

Post a Comment