Question

Stock Portfolio Value

Stock
Symbol
Previous Stock
Price
NEW
Stock
Price
Number of
Shares Owned
Previous Stock Value
New Stock
Value
Percent Increase or Decrease in Value






(same as shares purchased in
Understanding Stocks)
(Previous Stock Price multiplied by Number of Shares Owned)
(NEW Stock
Price multiplied by Number of Shares Owned)
(New Stock Value − Previous Stock Value) / New Stock Value × 100%)
Sample
ABC
$35.17
$29.29
200
$7034.00
$5858.00
($5858 − $7034) /
$5858 × 100% =
− 20.08%
Sample
XYZ
$22.50
$32.11
100
$2250.00
$3211.00
($3211 − $2250) /
$3211 × 100% =
+ 29.93%
GHA
$23.00
$27.70
100 shares
$2,300.00
$2,770.00
($2770 − $2300) / $2770 × 100% = +16.97%
TTO
$12.40
$10.30
200 shares
$2,480.00
$2,060.00
($2060 − $2480) / $2060 × 100% = −20.39%
FRB
$14.50
$14.70
100 shares
$1,450.00
$1,470.00
($1470 − $1450) / $1470 × 100% = +1.36%
BBP
$6.70
$3.00
100 shares
$670.00
$300.00
($300 − $670) / $300 × 100% = −123.33%
ISL
$34.90
$47.40
0 shares
$0.00
$0.00
0
RAG
$29.40
$30.10
100 shares
$2,940.00
$3,010.00
($3010 − $2940) / $3010 × 100% = +2.33%
Subtotal of New Stock Value
(total all the amounts from the “New Stock Value” column)
$9,610.00
Cash on Hand
(same amount left from Understanding Stocks)
$160.00
Total Assets
(“Subtotal of New Stock Value” plus “Cash on Hand”)
$9,770.00


Consider the following questions:
1. Have you made or lost money? What is the percentage increase or decrease ?
I have lost money. My portfolio went from $10,000 to $9,770, a loss of $230, which is −2.30% overall.

2. Is it time to sell existing stock or buy a new stock? Why? Don’t make a snap decision to buy or sell.



Buy, Sell, or Hold?
You can now make changes to your investment portfolio. Be strategic. You can take a loss and get rid of stock you do not think will recover, or take advantage of price drops that you think are temporary and buy stock cheaply!
◻ Decide which stocks (if any) you would like to sell. You can only sell what you already own! Selling stocks will increase your cash on hand amount.
◻ Decide which stocks (if any) you would like to buy. You must have enough cash on hand.
◻ Make adjustments, do the math, and record your new portfolio in the chart.

Updated Stock Portfolio

Current Cash on Hand: $160.00





A
B
C
D
E
F
G
H




Value of
Shares
Owned
Number of Shares to
Buy or Sell
Updated
Number
of Shares
Owned
Amount
Spent or
Received
Updated Cash (start with current cash on hand)
Updated
Value of
Shares
Owned








(Column A multiplied
by Column B)
(+ for
buying, −
for selling)
(Column B
+/− Column D)
(Column A multiplied
by Column D)
(current cash on
hand +/− amount in Column F (+ if shares sold, − if shares
bought))
(Column A
multiplied by Column E)
ABC
$35.17
$29.29
200
$5858.00
+50
250
$1464.50
Beginning cash: $4200
$4200 − $1464.50 = $2735.50
$7322.50
XYZ
$22.50
$32.11
100
$3211.00
-50
50
$1605.50
$2735.50 + $1605.50 = $4341.00
$1605.50
GHA
$23.00
$27.70














TTO
$12.40
$10.30














FRB
$14.50
$14.70














BBP
$6.70
$3.00














ISL
$34.90
$47.40














RAG
$29.40
$30.10














Total Value of Stocks Owned
(add ALL “Updated Value of Shares Owned” from column H)


Cash on Hand
(ending total from “Updated Cash” from column G)


Total Assets
(“Total Value of Stocks Owned” plus “Cash on Hand”)





Reflect
How would you rate your current understanding of how stocks are traded? Why?

26 Student Workbook

Answer 1

Thanks — a few quick clarifying points before I fill in the updated portfolio:

- The worksheet you pasted has inconsistent totals. The row-by-row “New Stock Value” numbers sum to $18,679 (not $9,610). With Cash on Hand $160 the correct Total Assets would be $18,839.
- You also wrote an answer earlier that your portfolio went from $10,000 → $9,770 (−$230, −2.30%). That is a separate scenario (probably from a different example). Which set should I use going forward: the $10,000 starting-account example or the per-stock numbers listed above (which add to $18,679 in stock value + $160 cash)? I’ll proceed using the per-stock numbers you supplied and Cash = $160 unless you tell me otherwise.

Suggested, conservative strategy (no snap decisions)
- Sell BBP entirely (big loss, low conviction). Pro: frees cash to reallocate; Con: realizes a loss.
- Trim TTO (sell 50 of 200 shares) to raise more cash and reduce exposure to a falling holding.
- Use proceeds to buy ISL (has strong price move up; you may want some exposure if you expect continued strength). This keeps the portfolio diversified while closing out the weakest holding.

Trades I’ll apply and the math
Starting (from your figures)
- Stock values (new prices): ABC $5,858; XYZ $3,211; GHA $2,770; TTO $2,060; FRB $1,470; BBP $300; ISL $0; RAG $3,010. Stock subtotal = $18,679. Cash = $160. Total assets = $18,839.

Planned trades
- Sell BBP: 100 shares × $3.00 = +$300
- Sell 50 shares of TTO: 50 × $10.30 = +$515
- Buy 20 shares of ISL: 20 × $47.40 = −$948

Cash flow
- Starting cash: $160
- + BBP sale: +$300 → $460
- + TTO sale: +$515 → $975
- − ISL purchase: −$948 → $27 ending cash

Updated share counts and values
- ABC: 200 shares, value = 200 × $29.29 = $5,858 (unchanged)
- XYZ: 100 shares, value = $3,211 (unchanged)
- GHA: 100 shares, value = $2,770 (unchanged)
- TTO: 150 shares (200 − 50), value = 150 × $10.30 = $1,545
- FRB: 100 shares, value = $1,470 (unchanged)
- BBP: 0 shares (sold 100), value = $0
- ISL: 20 shares (bought 20), value = 20 × $47.40 = $948
- RAG: 100 shares, value = $3,010 (unchanged)

Totals after trades
- Updated total value of stocks = $18,812
- Updated cash on hand = $27
- Updated total assets = $18,812 + $27 = $18,839

Note: total assets are the same as before the trades ($18,839) because we traded at current prices (selling and buying at the same market prices simply reallocates value).

Answering your worksheet questions
1) Have you made or lost money? What is the percentage increase or decrease?
- If you’re using the per-stock numbers above, the asset total didn’t change as a result of the trades (we just reallocated). Compared to whatever prior baseline you have (for example, if you really started with $10,000 and now have $9,770), use that baseline to compute percent change. For the $10,000 → $9,770 example: loss = $230 = −2.30%.
- If you want me to compute the portfolio change vs. an earlier date or the “previous stock values,” tell me the baseline total and I’ll compute the percent precisely.

2) Is it time to sell existing stock or buy new stock? Why?
- Don’t make snap decisions. Sell when you no longer believe a company’s fundamentals or prospects will recover, or to rebalance risk. Consider selling BBP because it’s down heavily and occupies capital that can be redeployed. Trimming TTO reduces exposure to a falling holding. Buying ISL is a reallocation into a better-performing company — but do this only if you’ve checked ISL’s fundamentals and you’re comfortable with the risk.
- If your goal is long-term growth and you believe the weak names will recover, holding can be better than locking in losses. If you need cash or want to rebalance, realize losses strategically.

Short reflection (sample you can adapt)
- I would rate my understanding of how stocks are traded as “developing.” I understand that trades change cash and holdings and that selling locks in a gain or loss, but I need to practice making decisions using company fundamentals, diversification, and risk tolerance.

If you want, I can:
- Fill the exact worksheet table format with the numbers above,
- Try a different buy/sell plan (more aggressive or fully conservative — e.g., hold everything),
- Recompute using the $10,000 starting example you wrote about earlier.

Which would you like next?