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 (56): $13,678.28 $15,957.81 16.67% 10.58% 3.63%
AAPL 1.80 $127.25 $172.69 $229.05 $310.84 30.54% 8.45% 0.56% 0.75% 7.15% 5.75%
ABBV 3 $91.60 $161.67 $274.80 $485.01 76.50% 24.09% 3.83% 6.77% 8.50% 7.25%
ADC 2 $57.74 $55.69 $115.48 $111.38 -3.55% -53.59% 5.39% 5.20% 5.53% 2.31%
ADM 2 $55.89 $60.52 $111.78 $121.04 8.28% 53.84% 3.30% 3.58% 7.45% 4.99%
AMD 2 $84.93 $160.32 $169.86 $320.64 88.77% 46.18% - - - -
AMZN 3 $104.37 $183.62 $313.10 $550.86 75.94% 47.10% - - - -
ASML 0.20 $634.25 $954.82 $126.85 $190.96 50.54% 31.81% 0.67% 1.02% 1.33% -2.40%
BAC 6 $28.58 $35.95 $171.46 $215.70 25.80% 30.55% 2.67% 3.36% 24.98% 19.92%
BAS.DE 2 $60.36 $54.50 $120.71 $108.99 -9.71% -0.32% 6.57% 6.04% - -
BMY 8 $61.73 $48.51 $493.83 $388.08 -21.41% -5.50% 4.95% 3.89% 6.09% 3.52%
BRK-B 0.30 $309 $400.26 $92.70 $120.08 29.53% 22.21% - - - -
BTC-USD 0.01200 $18,881.50 $63,463.04 $226.58 $761.56 147.92% 47.46% - - - -
BTI 12 $32.69 $28.51 $392.24 $342.12 -12.78% 6.23% 10.38% 9.09% 3.44% 0.77%
CSCO 6 $39.42 $48.24 $236.52 $289.44 22.37% 9.54% 3.32% 4.06% 4.57% 2.63%
CVS 4 $75.14 $68.96 $300.57 $275.84 -8.23% -4.63% 3.83% 3.54% 9.20% 3.00%
DLR 2 $119.74 $138.56 $239.48 $277.12 15.72% 7.27% 3.52% 4.08% 4.69% 3.83%
ENB 6 $36.28 $33.75 $217.70 $202.50 -6.98% -4.05% 7.94% 7.42% 8.30% 5.27%
EPR 4 $39.41 $40.41 $157.64 $161.64 2.54% 12.38% 8.31% 8.68% 29.24% 26.97%
GOOGL 3.50 $115.87 $154.86 $405.56 $542.01 33.64% 20.71% - - - -
HD 0.30 $296.18 $337.93 $88.85 $101.38 14.10% 15.81% 2.66% 3.04% 17.09% 11.77%
IIPR 1.50 $86.97 $96.72 $130.45 $145.08 11.22% 15.85% 7.53% 8.37% 9.77% 6.12%
INTC 4 $30.60 $36.31 $122.41 $145.24 8.36% 4.79% 1.32% 1.63% 8.20% 4.62%
JNJ 4.50 $151.80 $147.59 $683.09 $664.16 -2.77% 1.22% 3.23% 3.14% 6.37% 5.62%
JPM 1 $145.14 $182.89 $145.14 $182.89 26.01% 13.02% 2.52% 3.17% 11.79% 4.58%
KO 2 $42.36 $58.14 $84.72 $116.28 37.25% 11.97% 3.30% 4.58% 11.48% 3.41%
LMT 0.40 $346.10 $453.08 $138.44 $181.23 30.91% 14.47% 2.78% 3.64% 9.60% 7.17%
LOW 0.30 $201.13 $230.01 $60.34 $69 14.36% 19.25% 1.91% 2.19% 17.94% 16.89%
META 1.50 $124.56 $500.23 $186.84 $750.35 146.52% 57.35% 0.10% 0.40% - -
MO 6 $41.88 $40.95 $251.25 $245.70 -2.21% 8.15% 9.57% 9.36% 5.78% 3.68%
MPW 40 $10.51 $4.74 $420.58 $189.60 -54.92% -39.42% 12.66% 5.71% 3.72% 3.65%
MRK 2 $76.78 $126.19 $153.55 $252.38 64.36% 27.52% 2.44% 4.01% 8.61% 5.84%
MSFT 0.50 $232.32 $413.64 $116.16 $206.82 52.41% 21.81% 0.73% 1.29% 9.52% 9.14%
NEE 11 $63.17 $62.75 $694.89 $690.25 -0.67% 2.37% 3.31% 3.26% 9.34% 8.40%
O 11 $53.55 $51.65 $589.07 $568.15 -3.55% 4.53% 6.04% 5.76% 0.80% 0.72%
OHI 6 $31.32 $30.33 $187.94 $181.98 -3.17% 7.37% 8.84% 8.56% 1.85% 0.25%
PEP 0.50 $165.44 $166.95 $82.72 $83.48 0.91% 7.48% 3.02% 3.06% 7.38% 6.00%
PFE 16 $34.86 $25.91 $557.68 $414.56 -25.66% -10.42% 6.48% 4.82% 6.71% 5.15%
QCOM 0.50 $117 $169.84 $58.50 $84.92 45.16% 50.92% 1.88% 2.74% 9.82% 5.74%
RIO 2 $64.30 $66.77 $128.60 $133.54 3.84% 150.23% 7.73% 8.02% - -
RTX 3 $87.51 $100.02 $262.54 $300.06 14.29% 13.88% 2.36% 2.70% 6.67% 4.87%
SHEL 6 $47.04 $71.94 $282.27 $431.64 52.92% 14.32% 3.84% 5.85% 1.77% -4.11%
SOFI 10 $7.45 $7.12 $74.50 $71.20 -4.43% -66.79% - - - -
SPG 5 $99.75 $142.39 $498.75 $711.95 42.75% 18.91% 5.48% 7.82% 10.87% 9.25%
T 18 $22.73 $16.24 $409.18 $292.32 -28.56% -2.12% 6.90% 4.88% -7.24% -16.76%
TSM 6 $100.09 $140.14 $600.56 $840.84 40.01% 21.25% 1.23% 1.71% -3.05% -11.31%
TSN 3 $65.70 $58.12 $197.10 $174.36 -11.54% -0.72% 3.37% 2.98% 14.04% 5.77%
UL 3 $52.46 $46.71 $157.38 $140.13 -10.96% -0.06% 3.94% 3.49% 3.99% -0.40%
V 0.30 $212.27 $271.28 $63.68 $81.38 27.80% 11.31% 0.77% 0.98% 13.70% 12.53%
VICI 10 $29.62 $27.58 $296.22 $275.80 -6.89% 1.88% 6.09% 5.60% 7.97% 7.31%
VZ 8 $49.83 $40.11 $398.61 $320.88 -19.50% -3.24% 6.58% 5.34% 2.40% 2.00%
WBD 16 $15 $8.36 $240 $133.76 -44.27% -32.28% - - - -
WFC 8 $39.52 $56.97 $316.16 $455.76 44.15% 11.81% 2.46% 3.54% 5.40% -4.39%
WHR 1 $122.28 $106.53 $122.28 $106.53 -12.88% -11.69% 6.57% 5.72% 7.70% 3.92%
WM 0.50 $154.80 $205.36 $77.40 $102.68 32.66% 28.54% 1.46% 1.94% 7.18% 6.26%
WPC 4 $71.77 $54.01 $287.06 $216.04 -24.74% -8.39% 6.37% 4.82% 0.41% 0.21%
XOM 1 -$20.69 $119.68 -$20.69 $119.68 69.49% 20.62% 3.18% - 3.96% 0.95%
Total: $13,678.28 $15,957.81 16.67% 10.58% 3.63%