Copy of T7 DQ1 - Jailene Espinoza

.xlsx

School

Grand Canyon University *

*We aren’t endorsed by this school

Course

144

Subject

Finance

Date

Feb 20, 2024

Type

xlsx

Pages

4

Uploaded by MasterComputerQuetzal22

Report
Purchase Date Stock Shares Price per Share Fees 1 year ago 6-Jun ACOR 100 $6.19 $5.00 1 year ago 6-Jun AAPL 200 $148.71 $10.00 1 year ago 6-Jun DKNG 300 $12.95 $15.00 Total 600 Date Stock Shares Closing Price per Share Value 1 year ago 6-Jun ACOR 100 $6.19 $619.00 9 months ago 6-Sep ACOR 100 $7.45 $745.00 6 months ago 6-Dec ACOR 100 $11.76 $1,175.80 3 months ago 6-Mar ACOR 100 $17.80 $1,780.00 today 6-Jun ACOR 100 $10.67 $1,067.00 Enter the information in columns B, C, D and E for each of your three stocks. E G2 and use the fill-down feature to complete cells G3 and G4 (don't forget to in formula). Then enter a formula in cell G5 to compute the total of your three st
Initial Investment $624.00 $29,752.00 $3,900.00 $34,276.00 Gain/Loss Date Stock Shares Closing Price per Share Value $5.00 6-Jun AAPL 200 $148.71 $29,742.00 ($121.00) 6-Sep AAPL 200 $154.53 $30,906.00 ($551.80) 6-Dec AAPL 200 $142.91 $28,582.00 ($1,156.00) 6-Mar AAPL 200 $153.83 $30,766.00 ($443.00) 6-Jun AAPL 200 $179.58 $35,916.00 - Enter the date and closing price of each stock for each date you track afte enter the initial price, ticker symbol and number of shares, that informatio - Enter a formula in cells F14, M14, and T14 to calculate the value of each s these columns. - Enter a formula in cells G14, N14, and U14 to calculate the gain/loss of va to complete these columns. This formula should compare the value as of e You will need to use $ to lock the cell where the initial investment for each Enter a formula in cell nclude the fees in this tock purchases. Enter a formula in cell W14 to calculate the total gain/loss for all three stoc date. This will be done by adding the results in the gain/loss column for ea the fill-down feature to complete this column.
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