MAT 144 Calculate the Value of Each Stock Exercise
Order ID: 89JHGSJE83839 Style: APA/MLA/Harvard/Chicago Pages: 5-10 Instructions:
MAT 144 Calculate the Value of Each Stock Exercise
The video Tech Hints QR 2-7 in the media resources section of the eBook covers the calculations youll be doing for this DQ. (Our template does look a little different, but it is essentially the same.)
Here is a video I made to help with the Excel: https://youtu.be/iSMKu1B1fVc
Here are specific instructions for completing the DQ:
1. In the initial investment section (A1:F4), select three different stocks to track. Select your stocks from the New York Stock Exchange listings directory at https://www.nyse.com/listings_directory/stock. Use the Filter text box to search for specific stocks; click on the stock Symbol in the list at the right to go to the stock quote page for the stock to see more details, including historical prices. Towards the bottom, you can find a chart that will let you input date ranges. You can input the same date for start and end to look up your specific day.
2. Use a purchase date of 1 year ago, for each stock. So if it is Feb 18, 2020, then you look at the price Feb 18, 2019. Find each stocks price on that date and enter it into the Price per Share field. The table does not contain data points for weekends. If your date is on a non-business day choose a date close to your date listed. Assume that the number of shares purchased is 100 for your first stock, 200 for your second stock, and 300 for your third stock and that the fees are $5, $10, and $15 (total fee) for your first, second, and third stocks. Enter an appropriate formula in the Initial Investment field, and calculate an initial investment total in cell F5.
3. In cells A14:F16, continue your analysis for your first stock. Use the closing price 9 months ago, 6 months ago, 3 months ago, and the latest for the second through fifth date sections. Just get close to these dates, basically, we are looking at quarterly fluctuations. Look up the closing price per share on each of these dates and enter those in column D. Calculate a current value on each date in column E. Calculate the gain or loss to date (starting from the initial purchase date) in column F.
4. Repeat the analysis from step 3 for your second and third stocks, using cells H14:M16 for the second stock and O14:T16 for your third stock.
5. In column V, calculate (in cells V14:V16) the total gain or loss for all three stocks on each of the three dates.
Hint: To get the stock value on a particular date from the stock quote page, scroll down to the stock chart or stock table below it.
RUBRIC
Excellent Quality
95-100%
Introduction 45-41 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Literature Support
91-84 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Methodology
58-53 points
Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score
50-85%
40-38 points
More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.
83-76 points
Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.
52-49 points
Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality
0-45%
37-1 points
The background and/or significance are missing. No search history information is provided.
75-1 points
Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.
48-1 points
There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow MAT 144 Calculate the Value of Each Stock Exercise
MAT 144 Calculate the Value of Each Stock Exercise