Www.lcps.org



-317647398700lefttop00 There are two ways to make money… work for it or let it work for you! To make your money work for you, you must invest wisely. Investing in stocks has historically proven to be financially rewarding. For this challenge, you will be given $100,000 to purchase FIVE different stocks. You must purchase these stocks in “round lots” (amounts divisible by 100). We will be tracking the prices of these stocks over five school days. You will use a spreadsheet template that lists the name of each stock and their high, low, and closing prices for five consecutive business days. This will also create a graph that shows the “high-low-close” for each stock. Be sure to label and give each graph a title. Your spreadsheet will help you to calculate how much money you have spent. For example, if you select the following stocks at the following prices, this is how you would calculate your profit / loss:This assignment is intended to teach you about the stock market, how to use the Internet to create a personal portfolio, and how to use spreadsheets to track your investments. This assignment does not reflect an intelligent way in which to invest in the stock market. Investing is most successful, and least risky, when it is done over the long-term (one year or more).5109048-17399000-36033-1524000Getting StartedDo some research to decide in which stocks you will invest your money (use only stocks traded on an American exchange like NYSE or Nasdaq – do not use foreign stocks). You will need to choose five different companies in which to invest. In Microsoft Word, compose a one-page document to summarize your choices. Write a paragraph for each stock (five paragraphs total) that includes: company name, industry, products or services offered, ticker symbol, on which market the stock trades, why you think it is a good investment, current buy price, number of shares to purchase, and your total cost. On the Global drive download the BullsAndBears.xlsx template. Then in Microsoft Excel find the appropriate worksheet tab and fill in the information for the companies you chose and their current stock prices. Review the separate worksheet tabs in the spreadsheet for tracking prices of your stocks over the next five days. Notice that you will need to include the date, company, symbol, high, low, and closing price. Checking Your Stock Prices Daily (1) Go to (2) In the search box labeled “Enter Symbol” at the top-left corner of your screen, start typing the name or the ticker symbol of the company you want to search. (3) From the links toolbar on the left, click on “Historical Prices.” This will automatically pull up the prices for the last week. Note: the current buy price is the “open” price from Today’s date _______________ … you are responsible for documenting the high, low, and close for each business day from _______________ thru _______________ … the sell price will be the “close” price on _______________.Finishing Your Excel Workbook After recording your last day of high, low, and close prices and filling in your sell price, do the following: Subtract a total of 3% of your ROI from your final profit (or add it to your loss). This money represents the fee paid to your stockbroker. Complete the “Historical” worksheet of your Excel workbook. You will need to find the close price of your stock on the first day of each month listed in the Closing Prices table. The graphs will update automatically as you enter the price information. (Note: some months may start on the 2nd or 3rd day because stocks are not traded over the weekend) PRINT your project. You will need your Word document summary of the five stocks you chose, the Stocks worksheet showing your purchase cost and profit or loss, the Daily sheet showing your price tracking, and the Historical Chart sheet showing your research. Staple all four sheets together in this order. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download