FIN 100 Stock Journal Assignment
Stock Journal Assignment
This week, you will find out if you have made money on your original (pretend) investments or if you will need to find a side job to recoup your losses.
This is the last of the three stock journal assignments you will complete during this course. For this assignment, you will add your work for Week 10 to your previous work from Weeks 3 and 8, following the instructions below. Two templates have been provided for your use.
The Weeks 3, 8, and 10 Stock Journal Project Excel Template 1 [XLSX] you began in Week 3 is where you will enter your chosen companies, the share prices, and the number of shares you will be purchasing given your budget of $25K.
Note: The above Excel template has been provided for your use for the stock journal assignment. You will notice that there are directions for your work in Weeks 3, 8, and 10. When submitting your assignment for each week, you may use the provided Excel template above, your own Excel template that you create or a Word document that you create as long as it communicates the requested information.
Note: There are locked cells in the Excel template. The cells have been locked to prevent the formulas from being disturbed. The cells that you will need to use to complete this assignment are not locked. You may create your own templates, however it is recommended that you use the templates provided.
Download both templates. Then, complete, save, and upload both templates at the same time to Blackboard when submitting your work.
Note: Watch the Excel tutorial videos to learn how to use Excel before attempting the assignment. You can use the template provided or you may create your own template based on the one provided.
Instructions
For Week 10, review your investment for the last time and complete the following:
- Record the current price of the stock for each company you selected in Week 3’s Stock Journal.
You may use any price during this week (for example, day one price, the opening, the low, the high, the close, or any price you find when you check it during the day). Use the MS Excel spreadsheet or MS Word document to put your Week 10 stock prices side by side, so that you can compare them with Weeks 3 and 8.
- Determine the total value of your investment.
- Provide your final opinion or assessment of your investments and type your opinion or assessment into your Word document template.
Consider the following questions as you provide your assessment:
Did you make money or lose money?
What were your results?
Based on hindsight, what you would do differently? - Discuss what you learned from this assignment and how this assignment could help you in the future. Include this information in your Word document template as well.
- Go to the Strayer library search page to locate and incorporate at least two quality sources into this assignment.
For stock price information, you may use the New York Stock Exchange, NASDAQ, Yahoo! finance, or The Wall Street Journal Online.
- Submit two documents for your journal assignment submission by uploading both documents at the same time to the assignment submission area. Note that you will update your template in Weeks 3, 8, and 10. Save the template after you have entered your figures so that your selected stocks growth or decline can be tracked.
Completed Excel template with Week 3, 8, and 10 complete.
Completed Word document template with your rationale with Week 3, 8, and 10 complete.
Note: This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions.
The course outcome associated with this assignment is:
- Analyze the performance of an investment portfolio over time.
Multimedia
- View How the Stock Market Works [Video]
- View How the Stock Exchange Works (For Dummies) [Video]
For help with this homework assignment, please view the video and images below:
Investing in My Future
By Type Your Name Here
FIN100: Principles of Finance
Enter the Name of Your Instructor Here
Type the Date Here (ex. February 10,
2
020)
Summary
Insert your summary here
*This summary will help you develop your paper. Begin writing your summary by responding to the questions and prompts below.
1. Develop a one-paragraph summary using the Week 10 Assignment template. A section for your summary has been provided within the template.
2. Think about what you learned in this course. What are your new financial goals?
3. Would you like to become more liquid, to save for your retirement, or to start a new business?
*Whatever your goals, finance is right at the core. Think about what you wrote in your summary as you complete this assignment. The paper template begins on the next page. Please delete these instructions and make sure your font is black.
Investing in My Future: (2 – pages)
Insert your Introduction here
Three (3) Ways I will Invest in My Future
Insert your response here
Describe (3) ways you will invest in your future based on the principles of finance discussed in this course. Include terminology from the course and use citations as necessary to support your explanation of the terminology.
My Confidence Concerning Investing in My Future
Insert your response here
Discuss one of the (3) ways you feel most confident as a way to invest in your future. Explain your level of confidence.
Challenges With Investing in My Future
Insert your response here
Of the (3) ways you will invest in your future, discuss the one you perceive might be the most challenging. Then, discuss how you might overcome some of those challenges.
Conclusion
Insert your conclusion here
*Use black, size 12, Times New Roman, Arial, Courier, or Calibri fonts. Double-space your paragraph. Use paragraph headers as necessary to express your results. See the formatting instructions and samples under the Strayer Writing Standards link in the Course Shell.
Sources (3 sources)
Please provide your source list below:
1. Website 1
2. Website 2
3. Website 3
PAGE
2
Investing in My Future
By Type Your Name Here
FIN100: Principles of Finance
Enter the Name of Your Instructor Here
Type the Date Here (ex. February 10,
2
020)
Summary
Insert your summary here
*This summary will help you develop your paper. Begin writing your summary by responding to the questions and prompts below.
1. Develop a one-paragraph summary using the Week 10 Assignment template. A section for your summary has been provided within the template.
2. Think about what you learned in this course. What are your new financial goals?
3. Would you like to become more liquid, to save for your retirement, or to start a new business?
*Whatever your goals, finance is right at the core. Think about what you wrote in your summary as you complete this assignment. The paper template begins on the next page. Please delete these instructions and make sure your font is black.
Investing in My Future: (2 – pages)
Insert your Introduction here
Three (3) Ways I will Invest in My Future
Insert your response here
Describe (3) ways you will invest in your future based on the principles of finance discussed in this course. Include terminology from the course and use citations as necessary to support your explanation of the terminology.
My Confidence Concerning Investing in My Future
Insert your response here
Discuss one of the (3) ways you feel most confident as a way to invest in your future. Explain your level of confidence.
Challenges With Investing in My Future
Insert your response here
Of the (3) ways you will invest in your future, discuss the one you perceive might be the most challenging. Then, discuss how you might overcome some of those challenges.
Conclusion
Insert your conclusion here
*Use black, size 12, Times New Roman, Arial, Courier, or Calibri fonts. Double-space your paragraph. Use paragraph headers as necessary to express your results. See the formatting instructions and samples under the Strayer Writing Standards link in the Course Shell.
Sources (3 sources)
Please provide your source list below:
1. Website 1
2. Website 2
3. Website 3
PAGE
2
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 E: Share Price (Week 8) | Week 3 and 8 Change | Column H: Dollar Value Change | Column I: Share Price (Week 10) | Week 3 and 10 Change | Column L: Dollar Value Change | ||||||||||||||||
| 1) Amazon | ERROR:#DIV/0! | $0 | |||||||||||||||||||||||
| 2) Mickey D’s | |||||||||||||||||||||||||
| 3) Target | |||||||||||||||||||||||||
| Total Investment | |||||||||||||||||||||||||
| Instructions: | |||||||||||||||||||||||||
| 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. | |||||||||||||||||||||||||
| 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? | |||||||||||||||||||||||||
| 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? |