Stock Portfolio

To find the Initial Cost of a stock, you have to take the initial price per share and multiply it by the amount of shares.

F4=E4*D4

To find the Current Value of a stock, you have to take Current Price per share and subtract the Initial Price per share from it.

H4=G4-E4

To find the Gain/Loss of a stock, you have to take the Current Value and subtract the Initial Cost from it.

I4=H4-F4

To find the Percentage of Gain/Loss of a stock, you have to take the Gain/Loss and subtract the Initial Cost from it.

J4=I4-F4