week 3: using Apple, amazon and visa as the chosen companiesfor week 3 excel using those three companies apple amazon and visa, i should under column A (enter the 3 companies i chose which are apple amazon and visa), column B (enter the amount out of the 25000 $ you would like to invest in each company, column C ( enter the share price for each of your chosen companies), 4. the # of shares will automatically populate in column D.this is the scenario for week 3: Scenario Capital markets and the ability to raise funds for corporate uses are essential to the U.S. economic system. For this assignment, imagine you have $25,000 to invest in U.S. companies. You are buying used stock. You are investing, or buying, the stock because you believe the three companies you choose will make money and pay you a dividend in cash. Each share of stock you buy entitles you to any dividend declared and a vote at the annual stockholders' meeting. The stocks you choose also give you the ability to earn your money back by selling the stock. Of course, investing in stocks is risky, and there is the possibility that the stock you buy will be worth less when you want your money back. The company is not obligated to give you any of your money back. You will only get your money back if another investor wants to buy your stock.
week 3: Using the above scenario and the resources listed below, complete the following directions for your Week 3 Stock Journal entry: Use your knowledge and experience to select three publicly traded U.S. companies. Make sure you are practicing good diversification. Diversification means you are not selecting three companies from the same industry. For example, you would not want to choose Target, Walmart, and Sam’s Club because they sell the same types of products. A better choice would be Amazon, Uber, and Kroger, because they sell different products and services. You may wish to visit Statistics, Surveys and Government Resources to find such companies. For stock price information, you may use the New York Stock Exchange, NASDAQ, Yahoo! Finance, or The Wall Street Journal. Determine how you will divide $25,000 across the three companies (for example, $10,000 in Company 1, $10,000 in Company 2, and $5,000 in Company 3). Decide the amount you are investing in each company. You need not provide any analysis to justify your decisions. Provide a reason for picking each company. For example, you might invest in Ford because that company gets a lot of your money, and you hear that Ford is doing well and will continue to do well. Identify the number of shares you are buying and the price of the shares you are buying for each company. Once you decide the companies and the amount you will invest in each company, determine how many shares you can buy. For example, if Company 1 is selling for $42.16, then you may buy $10,000/$42.16, or 237.19 shares. But you cannot buy a part of a share, so you decide to buy either 237 or 238. In this example, you buy 237 shares at $42.16 per share, investing $9,991.92. You will not be able to buy exactly $10,000, or $5,000, or $25,000, but it will be relatively close.
WEEK 8:for week 8 word document instructions: Evaluate the results of your current investment. Are you happy with the result and the trend? Are you upset because you’re investment is worth less than $25,000. Feel free to speculate / guess at why you believe the stock increased, decreased, or remained static. Insert your update here. One paragraph is more than adequate to provide and update concerning the 3 companies you have chosen.
WEEK 8 EXCEL:(still using apple, amazon and visa and continuing the work from week 3)for week 8 excel: 1. enter the updated share price in column E 2. the change in the dollar value of your investment will populate in column H.
WEEK 8 scenario:week 8: This is the second of three stock journal assignments that you will complete during this course. For this assignment, add your work for Week 8 to your previous work from Week 3, following the instructions and using the provided templates below. In the Weeks 3, 8, and 10 Stock Journal Project Excel Template 1 [XLSX] template you began in Week 3, 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. In the Weeks 3, 8, and 10 Stock Journal Writing Assignment Template [DOC] template you began in Week 3, write your rationale/summary. Instructions For this week's portion of the assignment, 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 3 and Week 8 stock prices side-by-side, to show your comparison. Determine the current value of your total investment. Do not make any changes to your investment at this time. Calculate your new total (earnings or losses) based on the number of shares and the new price per share, for each company. Provide your assessment of your investments after evaluating the results of your current investments. This is the information you will include in your word document template. Consider the following as you provide your assessment: How would you evaluate the results of your current investment? Why do you believe the stock increased, decreased, or remained static? Are you upset because your investment is worth less than $25,000? Are you happy with the result and the trend? Go to Strayer library's search page to locate and incorporate at least two quality sources into this assignmentdon't forget the sources on week 8 word document assignmenton the excel week 8 do week 3 and 8on the word document only do week 8