Finance investing project
heaven4040
instructions_for_individual_project_3.docxFIN 315: INSTRUCTIONS FOR INDIVIDUAL PROJECT
For your individual project, you will create your own portfolio consisting of 10 stocks. Five of them have been selected for you. You will find them in the spreadsheet. You need to select five stocks of your own. Choose any stocks that interest you.
You have a total of $100,000 to invest. You are to spend $10,000 on each of your 10 stocks. The first thing you need to do is look up the prices. While you may use any web site you wish, I recommend using Yahoo Finance. The web address is: www.finance.yahoo.com Please note the wealth of information available to you as an investor.
When you have found the price of your stock, you will need to compute how many shares you can buy for $10,000. For example, suppose the stock you wish to buy has a price of $10. That means that you can purchase 1,000 shares to start. (For this exercise, we will assume that there is no charge for trades. In real life, you will be charged for every transaction, whether you buy or sell. Trading costs will be added to your cost basis, in order to compute your net gain or loss.) The first stock in your spreadsheet has been filled in for you.
You will use Friday’s closing costs each week for the price of your stocks. For this Friday, you should have your stocks selected. Then, use the closing price to enter into the spreadsheet as your starting price. You will then compute the number of shares that you purchase at that price. Once again, the first line of the spreadsheet is an example. For this exercise, please use fractional shares, although in reality, you would be purchasing whole shares.
For week one, you should invest a total of $100,000. Be sure to total the column that indicates your total portfolio value. After that, each week you will extend the spreadsheet. You will keep your shares and add Friday’s closing cost to compute the value of your portfolio. You will do this every week until the end of the term.
Later in the term, we will add the sector and the beta for each stock. The first stock has been done for you as an example. For the first week you need only choose your stocks, find the prices as of this Friday, and extended each line. Your first deliverable will be to a copy of the spreadsheet for week one. Each succeeding week, you need to submit your spreadsheet again, showing the additional week’s data.
The last part of this project will include an analysis of your portfolio, utilizing the concepts you have learned. By the end of the term, you will have a better understanding of stock selection, portfolio balancing, and how to purchase shares of stock. If you have questions at any time, please use the Ask the Professor forum in the Discussion Board.
FIN 31
5:
INSTRUCTIONS FOR INDIVIDUAL PROJECT
For your individual project, you will create your own portfolio consisting of 10 stocks.
Five of them have been selected for you
. Y
ou will find them in the spreadsheet.
You
need to
select five stocks of your own.
Choose any
stocks that interest you.
Y
ou have a total of $100,000 to invest
. Y
ou
are
to spend $10,000 on each of your 10
stocks. The first thing you need to do is look up the price
s.
While you may use any web site you
wish, I recommend us
ing
Yahoo
F
inance.
The web
address
is
:
www.finance.yahoo
.com
Please
note the wealth of information available to you as an investor.
When you have found the price of your stock, you will need to compute how many shares
you can bu
y for $10,000.
For example
,
suppose
t
he
stock you wish to buy has a
p
rice of $10
.
T
hat means that you can purchase 1
,
000 shares
to start
.
(
For this exercise
,
we will assume that
there is no charge for trades.
In real life, you will be charged for every trans
action, whether you
buy or sell.
Trading costs will
be
added to your cost basis
, in order to compute your net gain or
loss.
)
The first stock in your spreadsheet has been filled in for you.
You will use
Friday
’
s closing costs
each week for the
price
of your stocks.
For this
Friday
,
you should have your stocks selec
ted. Then, use the closing price
to
ent
er
into the
spreadsheet as your starting price.
You will then compute the number of shares that you
purchase
at
that price. Once again, the first line of the spreadsheet is an example.
For this exercise,
please
us
e
fractional shares
, although
i
n reality, you would be purchasing whole shares.
For week one, you should
invest a total of
$100,000
.
Be sure to total the column that
indicates your
total
portfolio value.
After that, e
ach week yo
u will extend the spreadsheet
.
You
will keep your shares and
add
Friday
’
s closing cost
to
comput
e
the value of your portfolio. You
will do this every week until the end of the term.
FIN 315: INSTRUCTIONS FOR INDIVIDUAL PROJECT
For your individual project, you will create your own portfolio consisting of 10 stocks.
Five of them have been selected for you. You will find them in the spreadsheet. You need to
select five stocks of your own. Choose any stocks that interest you.
You have a total of $100,000 to invest. You are to spend $10,000 on each of your 10
stocks. The first thing you need to do is look up the prices. While you may use any web site you
wish, I recommend using Yahoo Finance. The web address is: www.finance.yahoo.com Please
note the wealth of information available to you as an investor.
When you have found the price of your stock, you will need to compute how many shares
you can buy for $10,000. For example, suppose the stock you wish to buy has a price of $10.
That means that you can purchase 1,000 shares to start. (For this exercise, we will assume that
there is no charge for trades. In real life, you will be charged for every transaction, whether you
buy or sell. Trading costs will be added to your cost basis, in order to compute your net gain or
loss.) The first stock in your spreadsheet has been filled in for you.
You will use Friday’s closing costs each week for the price of your stocks. For this
Friday, you should have your stocks selected. Then, use the closing price to enter into the
spreadsheet as your starting price. You will then compute the number of shares that you purchase
at that price. Once again, the first line of the spreadsheet is an example. For this exercise, please
use fractional shares, although in reality, you would be purchasing whole shares.
For week one, you should invest a total of $100,000. Be sure to total the column that
indicates your total portfolio value. After that, each week you will extend the spreadsheet. You
will keep your shares and add Friday’s closing cost to compute the value of your portfolio. You
will do this every week until the end of the term.
