Stock Journal.10

profileCmod
cf_weeks_3_8_10_stock_journal_project_excel_template.week10.xlsx
Home>Business & Finance homework help>Marketing homework help>Stock Journal.10

Sheet1

Student Name:
Week 3 Week 8 Week 10
Column A: (3) U.S. Companies Column B: Investment ($25K) Column C: Share Price (Week 3) # of Shares (Column D) Column E: Share Price (Week 8) # of Shares Week 3 and 8 Change Column H: Dollar Value Change Column I: Share Price (Week 10) # of Shares Week 3 and 10 Change Column L: Dollar Value Change
1) Amazon ERROR:#DIV/0! ERROR:#DIV/0! $0 ERROR:#DIV/0! ERROR:#DIV/0! $0 ERROR:#DIV/0!
2) Mickey D's ERROR:#DIV/0! ERROR:#DIV/0! $0 ERROR:#DIV/0! ERROR:#DIV/0! $0 ERROR:#DIV/0!
3) Target ERROR:#DIV/0! ERROR:#DIV/0! $0 ERROR:#DIV/0! ERROR:#DIV/0! $0 ERROR:#DIV/0!
Total Investment ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Instructions:
Week 3
1. Under Column (A), enter the 3 U.S. Companies you chose.
2. Under Column (B), enter the amount out of the $25,000 you would like to invest in each company.
3. Under Column (C), enter the share price for each of your chosen companies.
4. The # of shares will automatically populate in Column (D).
5. Using the Word document template provided, please discuss why you chose the 3 companies you chose.
Week 8
1. Enter the updated share price in Column (E).
2. The number of new shares that can be purchased will populate in Column (F).
3. The difference in the new number of shares you can purchase for your initial investment will populate in Column (G).
2. The change in the dollar value of your investment will populate in Column (H).
3. Using the Word document template provided, please discuss any gains or losses experienced. Did you make or lose money? Which stocks changed in value?
Week 10
1. Enter the updated share price in Column (I).
2. The number of new shares that can be purchased will populate in Column (J).
3. The difference in the new number of shares you can purchase for your initial investment will populate in Column (K).
2. The change in the dollar value will populate in Column (L).
3. Using the Word document template provided, please discuss any gains or losses experienced. Did you make or lose money? Which stocks changed in value?

Week 3

Student Name:
Week 3 Week 8 Week 10
Column A: (3) U.S. Companies Column B: Investment ($25K) Column C: Share Price (Week 3) # of Shares (Column D) Column E: Share Price (Week 8) # of Shares Week 3 and 8 Change Column H: Dollar Value Change Column I: Share Price (Week 10) # of Shares Week 3 and 10 Change Column L: Dollar Value Change
1) Amazon $15,000.00 $3,259 5 5 -$3,259 -$15,000 5 -$3,259 -15,000.00
2) Mickey D's $5,000.00 $223 22 22 -$223 -$5,000 22 -$223 -5,000.00
3) Target $5,000.00 $157 32 32 -$157 -$5,000 32 -$157 -5,000.00
Total Investment $25,000 $0 $0 -$25,000
Instructions:
Week 3
1. Under Column (A), enter the 3 U.S. Companies you chose.
2. Under Column (B), enter the amount out of the $25,000 you would like to invest in each company.
3. Under Column (C), enter the share price for each of your chosen companies.
4. The # of shares will automatically populate in Column (D).
5. Using the Word document template provided, please discuss why you chose the 3 companies you chose.
Week 8
1. Enter the updated share price in Column (E).
2. The number of new shares that can be purchased will populate in Column (F).
3. The difference in the new number of shares you can purchase for your initial investment will populate in Column (G).
2. The change in the dollar value of your investment will populate in Column (H).
3. Using the Word document template provided, please discuss any gains or losses experienced. Did you make or lose money? Which stocks changed in value?
Week 10
1. Enter the updated share price in Column (I).
2. The number of new shares that can be purchased will populate in Column (J).
3. The difference in the new number of shares you can purchase for your initial investment will populate in Column (K).
2. The change in the dollar value will populate in Column (L).
3. Using the Word document template provided, please discuss any gains or losses experienced. Did you make or lose money? Which stocks changed in value?

Week 8

Student Name:
Week 3 Week 8 Week 10
Column A: (3) U.S. Companies Column B: Investment ($25K) Column C: Share Price (Week 3) # of Shares (Column D) Column E: Share Price (Week 8) # of Shares Week 3 and 8 Change Column H: Dollar Value Change Column I: Share Price (Week 10) # of Shares Week 3 and 10 Change Column L: Dollar Value Change
1) Amazon $15,000.00 $3,259 5 $3,099 5 -$160 -$736 5 -$3,259 -15,000.00
2) Mickey D's $5,000.00 $223 22 $214 22 -$9 -$198 22 -$223 -5,000.00
3) Target $5,000.00 $157 32 $172 32 $15 $472 32 -$157 -5,000.00
Total Investment $25,000 $24,539 $0 -$25,000
Instructions:
Week 3
1. Under Column (A), enter the 3 U.S. Companies you chose.
2. Under Column (B), enter the amount out of the $25,000 you would like to invest in each company.
3. Under Column (C), enter the share price for each of your chosen companies.
4. The # of shares will automatically populate in Column (D).
5. Using the Word document template provided, please discuss why you chose the 3 companies you chose.
Week 8
1. Enter the updated share price in Column (E).
2. The number of new shares that can be purchased will populate in Column (F).
3. The difference in the new number of shares you can purchase for your initial investment will populate in Column (G).
2. The change in the dollar value of your investment will populate in Column (H).
3. Using the Word document template provided, please discuss any gains or losses experienced. Did you make or lose money? Which stocks changed in value?
Week 10
1. Enter the updated share price in Column (I).
2. The number of new shares that can be purchased will populate in Column (J).
3. The difference in the new number of shares you can purchase for your initial investment will populate in Column (K).
2. The change in the dollar value will populate in Column (L).
3. Using the Word document template provided, please discuss any gains or losses experienced. Did you make or lose money? Which stocks changed in value?

Week 10