StocksAnalysis - [1/3 of the investment will automatically...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Stock Analysis for Lastname, Firstname Shares Share Price as of 01/01 as of 01/01 End 1Q End 2Q End 3Q 12/31 est. Level Platform Company LEVP 10.000 $100.00 $100.00 $100.00 $100.00 Loozer and Sons, Inc. LOOZ 1.000 $1,000.00 $800.00 $600.00 $400.00 Lucky Investment Corporation LUCK 2.000 $500.00 $500.00 $700.00 $900.00 TOTAL INVESTMENT VALUE = $3,000.00 $2,800.00 $3,000.00 $3,200.00 $0.00 (1) Download a copy of StockAnalysis.xls from the class BlackBoard site and enter your name in cell A2 (2) Choose ANY 3 stocks (your choice) with ticker symbols starting with the same initial as your Lastname (3) For each stock: enter the name (Col A), ticker symbol (Col B), and the 01/01 share price (Col D) (4) DO NOT enter numbers of shares (Col C), but instead enter an investment between $1000 and $9000 in cell D8
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: [1/3 of the investment will automatically be invested in each stock, and the number of shares will be put into Col C] (5) For each stock: enter end-of-quarter share prices (Cols E,F,G) [NOTE the knownDthruG_range is used in step (6)] (6) Use the FORECAST function to estimate 12/31 share prices (Col H) =FORECAST(4,knownDthruG_range,{0,1,2,3}) (7) Use the graph wizard to produce a "Share Price Analysis" graph as shown above (8) Use the Goal Seek tool to determine what investment (cell D8) would be required to achieve a $10000 12/31 value (9) Submit the final version of your StockAnalysis.xls spreadsheet via the BlackBoard Dropbox (by 5pm Monday 10/30)...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online