Mathematics Homework Help
Grand Canyon University Finance with Taxes and Stock Market Question
- The plan is for you to pick three stocks to buy with a hypothetical investment of $5,000. Use https://finance.yahoo.com/ to find three stocks you’re interested in, and calculate how many shares you can buy with your $5,000. Keep in mind that you have to buy three different stocks, and assume a fixed commission of $9.95 for each purchase. For this DQ your purchase date is Monday of week 6. Use the close price on Monday of week 6 as your price per share in cells D12, D13, and D14. Input the closing price into a spreadsheet for each day of week 6(M – F) and Monday of week 7. Finally use formulas to calculate the amount of gain or loss on your investment.
To find the closing prices follow these steps
- Go to https://finance.yahoo.com/
- Search for a stock you are interested in.
- Once on the summary page for your stock, use the historical data tab
- Use the 6 close prices for each day in week 6(M-F) and Monday of week 7.