VR Finance model

Portfolio Value

Stock Shares AVG cost basis Price Adjusted CB Value G/L % XIRR FD yield YoC Avg DGR Min DGR
Total (53): $13,390.90 $15,769.88 17.77% 11.23% 3.56%
AAPL 1.80 $127.25 $179.67 $229.05 $323.41 35.23% 9.83% 0.53% 0.75% 7.15% 5.75%
ABBV 3 $91.60 $178.54 $274.80 $535.62 94.91% 28.29% 3.47% 6.77% 14.24% 9.16%
ADM 2 $55.89 $54.28 $111.78 $108.56 -2.88% -21.17% 3.68% 3.58% 7.45% 4.99%
AMD 2 $84.93 $201.30 $169.86 $402.60 137.02% 73.51% - - - -
AMZN 3 $104.37 $178.52 $313.10 $535.58 71.05% 49.13% - - - -
ASML 0.20 $634.25 $986.84 $126.85 $197.37 55.59% 37.69% 0.65% 1.02% 1.33% -2.40%
BAC 6 $28.58 $34.42 $171.46 $206.52 20.45% 28.83% 2.79% 3.36% 24.98% 19.92%
BAS.DE 2 $60.36 $51.87 $120.72 $103.75 -14.07% -3.18% 7.09% 6.10% - -
BMY 8 $61.73 $51.01 $493.83 $408.08 -17.36% -4.28% 4.72% 3.89% 6.11% 3.45%
BRK-B 0.30 $309 $406.62 $92.70 $121.99 31.59% 26.45% - - - -
BTC-USD 0.01300 $22,772 $61,871.98 $296.04 $804.34 140.56% 48.17% - - - -
BTI 12 $32.69 $29.75 $392.24 $357 -8.98% 8.13% 9.95% 9.09% 3.44% 0.77%
CSCO 6 $39.42 $48.36 $236.52 $290.13 22.68% 9.70% 3.23% 3.96% 5.74% 2.70%
CVS 4 $75.14 $73.95 $300.57 $295.80 -1.59% 1.53% 3.57% 3.54% 9.05% 2.50%
DLR 2 $119.74 $150.11 $239.48 $300.22 25.36% 9.20% 3.25% 4.08% 4.75% 3.98%
ENB 6 $36.28 $34.81 $217.70 $208.88 -4.06% 0.35% 7.70% 7.41% 8.30% 5.27%
EPR 4 $39.41 $41.64 $157.64 $166.56 5.66% 19.52% 8.07% 8.37% 22.69% 11.99%
GOOGL 3.50 $115.87 $137.69 $405.56 $481.91 18.83% 13.02% - - - -
HD 0.30 $296.18 $384.12 $88.85 $115.23 29.70% 33.53% 2.34% 3.04% 17.09% 11.77%
IIPR 1.50 $86.97 $97.52 $130.45 $146.27 12.13% 16.41% 7.47% 8.37% 10.92% 7.19%
INTC 4 $30.60 $43.90 $122.41 $175.60 19.48% 7.94% 1.09% 1.63% 8.20% 4.62%
JNJ 4.50 $151.80 $162.23 $683.09 $730.04 6.87% 8.34% 2.93% 3.14% 6.37% 5.62%
JPM 1 $145.14 $185.45 $145.14 $185.45 27.77% 14.10% 2.27% 2.89% 14.10% 5.57%
KO 2 $42.36 $59.69 $84.72 $119.38 40.91% 13.03% 3.22% 4.58% 11.48% 3.41%
LMT 0.40 $346.10 $426.80 $138.44 $170.72 23.32% 12.52% 2.95% 3.64% 9.60% 7.17%
LOW 0.30 $201.13 $244.17 $60.34 $73.25 21.40% 31.79% 1.80% 2.19% 17.90% 16.89%
META 1.60 $147.34 $502.81 $235.74 $804.50 147.89% 61.46% 0.10% 0.34% - -
MO 4 $41 $40.83 $164.01 $163.32 -0.42% 8.83% 9.60% 9.56% 4.19% 1.74%
MPW 40 $10.51 $4.40 $420.58 $175.80 -58.15% -47.84% 13.65% 5.71% 3.64% 3.57%
MRK 2 $76.78 $127.06 $153.55 $254.12 65.50% 29.55% 2.42% 4.01% 8.61% 5.84%
MSFT 0.50 $232.32 $415.79 $116.16 $207.89 53.03% 22.98% 0.72% 1.29% 9.52% 9.14%
NEE 11 $63.17 $55.43 $694.89 $609.72 -12.26% -4.89% 3.75% 3.26% 9.34% 8.40%
O 11 $53.55 $51.74 $589.07 $569.14 -3.38% 4.45% 6.03% 5.75% 0.80% 0.72%
OHI 6 $31.32 $30.89 $187.94 $185.34 -1.38% 8.51% 8.68% 8.56% 1.85% 0.25%
PEP 0.50 $165.44 $164.68 $82.72 $82.34 -0.46% -56.84% 3.06% 3.06% 7.38% 6.00%
PFE 16 $34.86 $26.59 $557.68 $425.51 -23.71% -9.72% 6.32% 4.82% 6.71% 5.15%
QCOM 0.50 $117 $162.96 $58.50 $81.48 39.28% 52.39% 1.96% 2.74% 9.82% 5.74%
RTX 3 $87.51 $89.73 $262.54 $269.19 2.53% 5.25% 2.63% 2.70% 6.67% 4.87%
SHEL 6 $47.04 $63.64 $282.27 $381.84 35.27% 11.57% 4.34% 5.85% 1.77% -4.11%
SPG 5 $99.75 $150.11 $498.75 $750.55 50.49% 21.54% 5.18% 7.82% 10.87% 9.25%
T 18 $22.73 $17.02 $409.18 $306.36 -25.13% -1.29% 6.58% 4.88% -6.27% -15.06%
TSM 6 $100.09 $134.84 $600.56 $809.04 34.71% 20.22% 1.28% 1.71% -3.05% -11.31%
TSN 3 $65.70 $53.24 $197.10 $159.70 -18.96% -3.24% 3.68% 2.98% 14.04% 5.77%
UL 3 $52.46 $49.10 $157.38 $147.32 -6.40% 1.51% 3.78% 3.49% 2.90% 0.45%
V 0.30 $212.27 $283.33 $63.68 $85 33.48% 14.01% 0.73% 0.98% 13.70% 12.53%
VICI 10 $29.62 $29.44 $296.22 $294.40 -0.61% 4.81% 5.61% 5.60% 8.62% 8.62%
VZ 8 $49.83 $40.20 $398.61 $321.60 -19.32% -3.99% 6.57% 5.34% 2.40% 2.01%
WBD 16 $15 $8.67 $240 $138.72 -42.20% -32.82% - - - -
WFC 8 $39.52 $55.26 $316.16 $442.04 39.83% 11.35% 2.53% 3.54% 5.40% -4.39%
WHR 1 $122.28 $106.67 $122.28 $106.67 -12.77% -13.58% 6.56% 5.72% 7.70% 3.92%
WM 0.50 $154.80 $205.62 $77.40 $102.81 32.83% 31.85% 1.36% 1.81% 7.18% 6.26%
WPC 4 $71.77 $56.32 $287.06 $225.28 -21.52% -7.49% 6.11% 4.79% 0.53% 0.21%
XOM 1 -$20.69 $105.78 -$20.69 $105.78 62.61% 19.71% 3.59% - 3.96% 0.95%
Total: $13,390.90 $15,769.88 17.77% 11.23% 3.56%