FIN 100 assignment week 8

week8exltemplete.xlsx

Home >Business & Finance homework help >Operations Management homework help >FIN 100 assignment week 8

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?