QR 2-7 Tech Template

xlsx

School

Grand Canyon University *

*We aren’t endorsed by this school

Course

1440500

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

3

Uploaded by alyssacastillo26

Report
Purchase Date Stock Shares Price per Share Fees Initial Investment 8-Oct TSLA 10 $413.98 $9.95 $4,149.75 8-Oct AAPL 5 $115.08 $9.95 $585.35 8-Oct MSFT 10 $209.83 $9.95 $2,108.25 Total $6,843.35 Date Stock Shares Closing Price per Share Value Gain/Loss 8-Oct TSLA 10 $413.98 $4,139.80 $0.00 9-Oct TSLA 10 $425.30 $4,253.00 $113.20 12-Oct TSLA 10 $425.92 $4,259.20 $119.40 13-Oct TSLA 10 $434.00 $4,340.00 $200.20 14-Oct TSLA 10 $442.30 $4,423.00 $283.20 Enter the information in columns A, B, C and D for each of your three stocks. Enter a formula in cell F2 and use the fill-down feature to complete cells F3 and F4 (don't forget to include the fees in this formula). Then enter a formula in cell F5 to compute the total of your three stock purchases. Note: You may nee depending on how
Date Stock Shares Closing Price per Share Value Gain/Loss Date Stock 8-Oct AAPL 5 $115.08 $575.40 $0.00 8-Oct MSFT 9-Oct AAPL 5 $114.97 $574.85 -$0.55 9-Oct MSFT 12-Oct AAPL 5 $116.97 $584.85 $9.45 12-Oct MSFT 13-Oct AAPL 5 $124.00 $620.00 $44.60 13-Oct MSFT 14-Oct AAPL 5 $121.10 $605.50 $30.10 14-Oct MSFT Enter the date and closing price of each stock for each date you track after the purchase date. The template is se that once you enter the initial price, ticker symbol and number of shares, that information will automatically appe the cells from row 14 down. Enter a formula in cells E14, L14, and S14 to calculate the value of each stock for each date. Use the fill-down fea complete these columns. Enter a formula in cells F14, M14, and T14 to calculate the gain/loss of value for each stock as of each date. Use t down feature to complete these columns. This formula should compare the value as of each date to the initial investment near the top of column F. You will need to use $ to lock the cell where the initial investment for each appears. Enter a formula in cell V14 to calculate the total gain/loss for all three stocks as of each date. This will be done by adding the results in the gain/loss column for each stock. Use the fill-down feature to complete this column. ed to add additional rows after row 18 many dates you are asked to record.
Shares Closing Price per Share Value Gain/Loss Total Gain/Loss 10 $209.83 $2,098.30 $0.00 $0.00 10 $210.58 $2,105.80 $7.50 $120.15 10 $215.81 $2,158.10 $59.80 $188.65 10 $221.40 $2,214.00 $115.70 $360.50 10 $222.86 $2,228.60 $130.30 $443.60 et up so ear in ature to the fill- stock
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help