This blogpost is focused on mutual funds. Here’s the FSM methodology
- Sound byte: when you buy, WAC may change, but not (never) when you sell. No FIFO rule.
- Sound byte: methodology was presumably designed for buy-once-never-sell, or buy-once-sell-repeatedly.
Before you sell, the WAC [weighted avg cost] was last updated in the previous buy event. From then on, all units are treated as bought at the same cost i.e. the WAC. When you sell 11 units,
- units reduce by 11
- investment amount reduce by … ? { 11 * sales price } I guess the updated value may approach $0
- $ pnL i.e. unrealized PnL is updated to { units * WAC – investment amount }
- % pnl = $ pnl / investment amount
$ profit is unrealized profit. (The realized profit is now show in the blotter.)
For stocks, the $10.30 upfront is part of the displayed cost
==== wife’s account end-to-end PnL before my 50th birthday
- Total Portfolio Valuation 0
- (-) Total Investments SGD299,029.16
- (+) Total Withdrawals SGD306,000.56
- (+) Total Coupon/Dividend Payout SGD864.60
- (=) Profit & Loss SGD7,836
— complete exit plan:
As of Christmas 2023, there is only one unsold fund in the account. Invested 1k (initial valuation) a few years ago….. now valuation dropped to $714. I hope to sell a bit higher, like $720. Sold $735 🙂