StocksAnalysis3

StocksAnalysis3 - [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 Federico, Brian Shares Share Price as of 01/01 as of 01/01 End 1Q End 2Q End 3Q 12/31 est. Ford Motor Company F 362.319 $7.72 $8.05 $6.98 $8.10 $7.73 Four Seasons FS 55.719 $50.20 $50.80 $61.29 $63.95 $69.50 Friendly Ice Cream Coorporation FRN 327.146 $8.55 $7.66 $7.51 $10.69 $10.17 TOTAL INVESTMENT VALUE = $8,391.30 $8,253.14 $8,400.88 $9,995.21 $10,000.00 F $2,797.10 $2,916.67 $2,528.98 $2,934.78 $2,800.72 FS $2,797.10 $2,830.53 $3,415.02 $3,563.24 $3,872.20 FRN $2,797.10 $2,505.94 $2,456.87 $3,497.19 $3,327.08 (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) $6,000.00 $8,000.00 $10,000.00 $12,000.00 Investment Value Analysis...
View Full Document

This note was uploaded on 04/08/2008 for the course CS IT taught by Professor Linderman during the Fall '08 term at Bentley.

Ask a homework question - tutors are online