Monday, April 3, 2017

Income & Expenses For March 2017

Since 2014, I have been tracking my monthly income and expenses. You can see a breakdown of every penny I earn and spend. For perspective, this budget is for a household of two in a small US city. By documenting my journey, I aim to demonstrate the feasibility of saving a significant portion of your income and provide some ideas and inspirations for your own budget.

Below are my income and expenses for March 2017. You can see all my monthly budgets here.

Mar 2017
Income
Wages$10,296.36
Dividends$2,190.97
Other Income$93.86
Total Income$12,581.19
Expense
Federal Income Tax$735.83
Federal Tax Pmt/(Refund)
FICA-SS$427.02
FICA-Medicare$99.87
Housing$450.00
Student loan repayment$160.47
Food$87.99
Cell phone$12.84
Electric$42.72
Clothing/laundry$8.00
Total Expense$2,024.74
Ex-Tax Total Expense$762.02
Surplus/(Deficit)$10,556.46
Before Tax Saving Rate83.91%
After Tax Saving Rate93.27%

Income
Wages remain my primary source of income by far.  Dividend income reached a new all-time high this month, in reversal to last month's 3-year low.

Here is a chart of my dividend income by month for the past 13 months:

Total dividends for the trailing twelve months: $13,959.85, up 14% from $12,294.59 last year.

Expense
Expenses were all typical recurring expenses this month. Electric was slightly higher than norm at $42.72, not significantly out of the ordinary though.

Total expenses for the trailing twelve months: $10,271.28.
Dividend to expense coverage ratio = 1.36.

Savings
My after tax saving rate was 93.27% for the month of March 2017, back above my 90% saving rate target. I am optimistic that my saving rate will average above 90% for the remainder of the year.

Portfolio Update March 2017

The time has come for my monthly portfolio update. At the end of every month, I will update my portfolio and comment on any changes. I do that for accountability and also so you may glean some ideas on how I allocate my capital. You have the opportunity to learn from what I do well, so you can do the same, as well as what I do poorly, so you will not have to repeat my mistakes.

Follow my real-time portfolio here. Below is a snapshot of my stocks and ETFs portfolio as of 3/31/17:

TickerPriceShares HeldCost BasisTotal InvestedMarket ValueG/L ($)G/L (%)Weight
Total$41.3718181.56083$33.29$605,237.21$752,150.33$146,913.1124.27%100.00%
BDX$183.44169.503183$84.36$14,300.00$31,093.66$16,793.66117.44%4.13%
VWO$39.72733.18015$39.40$28,885.07$29,121.92$236.850.82%3.87%
AFL$72.42308.0023$48.05$14,800.00$22,305.53$7,505.5350.71%2.97%
XOM$82.01263.761838$80.70$21,284.51$21,631.11$346.601.63%2.88%
EMR$59.86360.667439$50.83$18,331.98$21,589.55$3,257.5717.77%2.87%
EXC$35.98567.834$30.46$17,296.43$20,430.67$3,134.2418.12%2.72%
BRK.B$166.6891.0092$121.57$11,064.20$15,169.41$4,105.2137.10%2.02%
KO$42.44344.0515$41.55$14,295.00$14,601.55$306.552.14%1.94%
NSC$111.97129.182$76.25$9,850.00$14,464.51$4,614.5146.85%1.92%
WMT$72.08195.2793$66.58$13,001.10$14,075.73$1,074.638.27%1.87%
PG$89.85153.38$69.87$10,715.96$13,781.19$3,065.2328.60%1.83%
BMTC$39.50326.882644$23.56$7,700.00$12,911.86$5,211.8667.69%1.72%
VFC$54.97227.6187$57.55$13,100.00$12,512.20-$587.80-4.49%1.66%
LMT$267.6044.233058$96.91$4,286.67$11,836.77$7,550.10176.13%1.57%
SPGI$130.7489.647935$45.73$4,100.00$11,720.57$7,620.57185.87%1.56%
GILD$67.92166$76.34$12,672.24$11,274.72-$1,397.52-11.03%1.50%
MOCO$21.75517.375$13.82$7,150.00$11,252.91$4,102.9157.38%1.50%
UL$49.34227.5219$41.75$9,500.00$11,225.93$1,725.9318.17%1.49%
NKE$55.73197.4214$51.16$10,100.00$11,002.29$902.298.93%1.46%
AZO$723.0515$759.94$11,399.08$10,845.75-$553.33-4.85%1.44%
AZN$31.14344$22.13$7,613.49$10,712.16$3,098.6740.70%1.42%
MSFT$65.86145.9167$39.93$5,827.06$9,610.07$3,783.0164.92%1.28%
SON$52.92180.275$35.22$6,350.00$9,540.15$3,190.1550.24%1.27%
CVX$107.3788$95.19$8,376.87$9,448.56$1,071.6912.79%1.26%
MCD$129.6170.92$103.64$7,350.00$9,191.94$1,841.9425.06%1.22%
YORW$35.05261.298$21.24$5,550.00$9,158.49$3,608.4965.02%1.22%
INTC$36.07243.1592$27.28$6,632.56$8,770.75$2,138.1932.24%1.17%
VIAB$46.62177.8076$41.06$7,300.00$8,289.39$989.3913.55%1.10%
PEP$111.8672.127668$80.41$5,800.00$8,068.20$2,268.2039.11%1.07%
ESLT$113.6570$36.86$2,580.05$7,955.50$5,375.45208.35%1.06%
MAT$25.61307.5679$29.26$9,000.00$7,876.81-$1,123.19-12.48%1.05%
T$41.55187$33.89$6,336.85$7,769.85$1,433.0022.61%1.03%
HCP$31.28245$35.65$8,734.17$7,663.60-$1,070.57-12.26%1.02%
ED$77.6698$70.40$6,899.44$7,610.68$711.2410.31%1.01%
ABBV$65.16114$61.84$7,050.14$7,428.24$378.105.36%0.99%
DIS$113.3965.4646$95.47$6,250.00$7,423.03$1,173.0318.77%0.99%
BUD$109.7667.6069$108.72$7,350.00$7,420.53$70.530.96%0.99%
KMB$131.6356$115.30$6,456.80$7,371.28$914.4814.16%0.98%
PEG$44.35148.004$30.07$4,450.00$6,563.98$2,113.9847.51%0.87%
VMI$155.5041.408$119.54$4,950.00$6,438.94$1,488.9430.08%0.86%
BEN$42.14150$35.26$5,289.56$6,321.00$1,031.4419.50%0.84%
OGZPY$4.491390.2431$6.09$8,464.47$6,242.19-$2,222.28-26.25%0.83%
RL$81.6276.254$90.81$6,924.41$6,223.85-$700.56-10.12%0.83%
NVS$74.2781.969$75.64$6,200.00$6,087.84-$112.16-1.81%0.81%
SRCL$82.8972$82.12$5,912.79$5,968.08$55.290.94%0.79%
DV$35.45167$22.09$3,688.64$5,920.15$2,231.5160.50%0.79%
UHS$124.4547$122.89$5,776.00$5,849.15$73.151.27%0.78%
FOSL$17.45322$24.72$7,961.06$5,618.90-$2,342.16-29.42%0.75%
SNY$45.25124.17$40.27$5,000.00$5,618.69$618.6912.37%0.75%
SAN$6.07925$6.78$6,273.42$5,614.75-$658.67-10.50%0.75%
NVO$34.28163$38.92$6,344.74$5,587.64-$757.10-11.93%0.74%
VIG$89.9460$59.80$3,587.92$5,396.40$1,808.4850.40%0.72%
HPE$23.70220$9.77$2,150.40$5,214.00$3,063.60142.47%0.69%
BCR$248.5420.651628$96.84$2,000.00$5,132.76$3,132.76156.64%0.68%
CSX$46.55108$21.04$2,272.36$5,027.40$2,755.04121.24%0.67%
VEA$39.30126.78515$31.06$3,938.54$4,982.66$1,044.1226.51%0.66%
GPS$24.29200.5943$20.94$4,200.00$4,872.44$672.4416.01%0.65%
LUKOY$53.0689$49.38$4,395.19$4,722.34$327.157.44%0.63%
FOX$31.78146.5179$25.59$3,750.00$4,656.34$906.3424.17%0.62%
CTSH$59.5275$53.00$3,975.00$4,464.00$489.0012.30%0.59%
CHL$55.2377.42$47.44$3,672.95$4,275.91$602.9616.42%0.57%
RBCAA$34.39118$21.26$2,508.83$4,058.02$1,549.1961.75%0.54%
SBRCY$11.53346$6.18$2,137.25$3,989.38$1,852.1386.66%0.53%
JNJ$124.5532$61.42$1,965.54$3,985.60$2,020.06102.77%0.53%
AAN$29.74133$22.62$3,008.06$3,955.42$947.3631.49%0.53%
HPQ$17.88220$8.89$1,956.29$3,933.60$1,977.31101.07%0.52%
GIS$59.0165.282$38.30$2,500.00$3,852.29$1,352.2954.09%0.51%
JOY$28.25136$12.54$1,705.04$3,842.00$2,136.96125.33%0.51%
K$72.6152.686$50.30$2,650.00$3,825.53$1,175.5344.36%0.51%
CVS$78.5048$88.52$4,248.81$3,768.00-$480.81-11.32%0.50%
DGS$44.8883.77$44.07$3,691.36$3,759.60$68.241.85%0.50%
AN$42.2988$47.50$4,180.00$3,721.52-$458.48-10.97%0.49%
RHHBY$32.02112$30.80$3,449.74$3,586.24$136.503.96%0.48%
FISV$115.3130$100.80$3,024.00$3,459.30$435.3014.39%0.46%
FNDE$26.43129.85$24.59$3,193.03$3,431.94$238.917.48%0.46%
BVN$12.04282$9.23$2,601.60$3,395.28$793.6830.51%0.45%
BBBY$39.4685$41.60$3,536.00$3,354.10-$181.90-5.14%0.45%
HSIC$169.9719$155.68$2,958.00$3,229.43$271.439.18%0.43%
SBS$10.41307$4.92$1,510.38$3,195.87$1,685.49111.59%0.42%
TIF$95.3033$60.25$1,988.40$3,144.90$1,156.5058.16%0.42%
IBM$174.1417$133.64$2,271.92$2,960.38$688.4630.30%0.39%
PII$83.8034$76.53$2,602.00$2,849.20$247.209.50%0.38%
WBA$83.0533$36.78$1,213.89$2,740.65$1,526.76125.77%0.36%
CEO$119.8021.66$144.63$3,132.74$2,594.87-$537.87-17.17%0.34%
PPL$37.3969.357$24.17$1,676.52$2,593.26$916.7454.68%0.34%
DHR$85.5329$79.24$2,298.10$2,480.37$182.277.93%0.33%
PAYX$58.9040.572$33.27$1,350.00$2,389.69$1,039.6977.01%0.32%
LLY$84.1128$35.93$1,006.02$2,355.08$1,349.06134.10%0.31%
DISCA$29.0879.6427$24.99$1,990.00$2,316.01$326.0116.38%0.31%
DE$108.8621$74.65$1,567.56$2,286.06$718.5045.84%0.30%
HCN$70.8231.8857$56.45$1,800.00$2,258.15$458.1525.45%0.30%
TLK$31.1772$16.17$1,164.01$2,244.24$1,080.2392.80%0.30%
OGS$67.6029.562$33.83$1,000.00$1,998.39$998.3999.84%0.27%
DLTR$78.4625$76.92$1,923.08$1,961.50$38.422.00%0.26%
SGTZY$5.11371$6.45$2,392.73$1,895.81-$496.92-20.77%0.25%
WFC$55.6632$45.86$1,467.50$1,781.12$313.6221.37%0.24%
SJI$35.6546.836$24.55$1,150.00$1,669.70$519.7045.19%0.22%
WLK$66.0523$44.00$1,012.00$1,519.15$507.1550.11%0.20%
BP$34.5244$39.34$1,731.17$1,518.88-$212.29-12.26%0.20%
OAOFY$37.4938$28.59$1,086.23$1,424.62$338.3931.15%0.19%
TESS$15.7088.983$8.99$800.00$1,397.03$597.0374.63%0.19%
CHKP$102.6613$74.85$973.05$1,334.58$361.5337.15%0.18%
AXP$79.1116.7283$59.78$1,000.00$1,323.38$323.3832.34%0.18%
POT$17.0877$23.11$1,779.18$1,315.16-$464.02-26.08%0.17%
MPC$50.5426$18.83$489.68$1,314.04$824.36168.35%0.17%
STRA$80.4916$48.00$768.00$1,287.84$519.8467.69%0.17%
TLSYY$17.7472$14.78$1,064.26$1,277.28$213.0220.02%0.17%
RHI$48.8326$36.06$937.56$1,269.58$332.0235.41%0.17%
TGT$55.1922.8818$61.18$1,400.00$1,262.85-$137.15-9.80%0.17%
CERN$58.8521$47.80$1,003.80$1,235.85$232.0523.12%0.16%
GGG$94.1413$73.00$949.00$1,223.82$274.8228.96%0.16%
FSBK$12.13100$4.51$451.00$1,213.00$762.00168.96%0.16%
CICHY$16.1073$13.64$995.73$1,175.30$179.5718.03%0.16%
MDLZ$43.0827$17.63$475.90$1,163.16$687.26144.41%0.15%
KSS$39.8128.7161$43.53$1,250.00$1,143.19-$106.81-8.54%0.15%
MRK$63.5417$34.30$583.18$1,080.18$497.0085.22%0.14%
NNN$43.6224.121$45.60$1,100.00$1,052.16-$47.84-4.35%0.14%
MYTAY$8.30124$13.18$1,633.71$1,029.20-$604.51-37.00%0.14%
VSS$102.6510$87.82$878.20$1,026.50$148.3016.89%0.14%
SCL$78.8113$38.46$499.98$1,024.53$524.55104.91%0.14%
TROW$68.1515$67.00$1,005.00$1,022.25$17.251.72%0.14%
BF.B$46.1822$45.82$1,008.04$1,015.96$7.920.79%0.14%
ESRX$65.9115$68.83$1,032.45$988.65-$43.80-4.24%0.13%
IJR$69.1614$69.25$969.50$968.24-$1.26-0.13%0.13%
BCMXY$18.5252$16.07$835.50$963.04$127.5415.27%0.13%
CMP$67.8514$69.00$966.00$949.90-$16.10-1.67%0.13%
ARLP$21.6541$26.68$1,094.01$887.65-$206.36-18.86%0.12%
BIIB$273.423$221.90$665.71$820.26$154.5523.22%0.11%
TLKGY$22.6236$19.78$711.92$814.32$102.4014.38%0.11%
KHC$90.818.881$28.52$253.28$806.48$553.20218.42%0.11%
PB$69.7111$45.43$499.73$766.81$267.0853.44%0.10%
AEO$14.0354.4158$11.95$650.00$763.45$113.4517.45%0.10%
AAPL$143.665.2832$94.64$500.00$758.98$258.9851.80%0.10%
PNW$83.388.884381$35.01$311.00$740.78$429.78138.19%0.10%
CLD$4.58158$9.44$1,492.23$723.64-$768.59-51.51%0.10%
IMBBY$49.4014$62.93$880.98$691.60-$189.38-21.50%0.09%
NAT$8.1882$19.64$1,610.79$670.76-$940.03-58.36%0.09%
AMGN$164.074$141.00$564.00$656.28$92.2816.36%0.09%
RAVN$29.0522$22.60$497.20$639.10$141.9028.54%0.08%
HSY$109.255.806$90.42$525.00$634.31$109.3120.82%0.08%
EFSI$28.4022$22.85$502.70$624.80$122.1024.29%0.08%
HFC$28.3422$23.50$517.00$623.48$106.4820.60%0.08%
ICE$59.8710$16.67$166.66$598.70$432.04259.23%0.08%
IDCBY$13.1045$12.18$548.10$589.50$41.407.55%0.08%
PDLI$2.27255$6.05$1,542.59$578.85-$963.74-62.48%0.08%
CAH$81.557$74.84$523.88$570.85$46.978.97%0.08%
BACHY$12.3545$11.00$495.00$555.75$60.7512.27%0.07%
CCFN$46.1612$39.50$474.00$553.92$79.9216.86%0.07%
WTR$32.1517.045122$29.33$500.00$548.00$48.009.60%0.07%
RLI$60.029$57.00$513.00$540.18$27.185.30%0.07%
BCS$11.2446$14.02$644.92$517.04-$127.88-19.83%0.07%
SB$2.20233$7.99$1,861.40$512.60-$1,348.80-72.46%0.07%
NTT$42.8411$22.30$245.34$471.24$225.9092.08%0.06%
MPLX$36.0813$8.59$111.66$469.04$357.38320.06%0.06%
MRO$15.8027$29.92$807.79$426.60-$381.19-47.19%0.06%
TRGP$59.907$27.35$191.42$419.30$227.88119.05%0.06%
ATW$9.5333$15.00$495.00$314.49-$180.51-36.47%0.04%
HNNMY$5.0761$6.53$398.52$309.27-$89.25-22.40%0.04%
IEMG$47.796.25$49.67$310.46$298.69-$11.77-3.79%0.04%
RAD$4.2566$8.00$527.84$280.50-$247.34-46.86%0.04%
CPLP$3.5775$8.53$639.48$267.75-$371.73-58.13%0.04%
DYN$7.8624$29.77$714.50$188.64-$525.86-73.60%0.03%
AMC$31.455.5556$18.00$100.00$174.72$74.7274.72%0.02%
LYG$3.4050$3.24$162.00$170.00$8.004.94%0.02%
GSH$30.184.59$20.75$95.24$138.53$43.2945.45%0.02%
MVC$8.9911$8.84$97.28$98.89$1.611.66%0.01%
QCCO$0.82113$3.63$410.25$92.66-$317.59-77.41%0.01%
TSCDY$6.9711$14.33$157.63$76.67-$80.96-51.36%0.01%
PTR$73.250.97$99.24$96.26$71.05-$25.21-26.19%0.01%
LGCY$2.2928$15.62$437.22$64.12-$373.10-85.33%0.01%
VTI$121.320.45382$55.06$55.06#DIV/0!0.01%
BIVV$54.461$37.77$37.77$54.46$16.6944.17%0.01%
EVEP$1.4832$21.84$698.97$47.36-$651.61-93.22%0.01%
BK$47.231$25.01$25.01$47.23$22.2288.84%0.01%
GOOGL$847.800.0459$544.66$25.00$38.91$13.9155.66%0.01%
BPI$10.671$17.85$17.85$10.67-$7.18-40.22%0.00%
BKS$9.251$8.70$8.70$9.25$0.556.32%0.00%
ALN$0.5615$2.11$31.65$8.40-$23.25-73.46%0.00%
LPHIQ$0.03130$6.69$869.72$3.90-$865.82-99.55%0.00%
LQD$117.910.02347$2.77$2.77#DIV/0!0.00%
VGIT$64.320.03855$2.48$2.48#DIV/0!0.00%
TIP$114.650.01731$1.98$1.98#DIV/0!0.00%
SJNK$27.960.04473$1.25$1.25#DIV/0!0.00%
VNQ$82.590.00775$0.64$0.64#DIV/0!0.00%
ZAHLY$0.0123$6.64$152.72$0.23-$152.49-99.85%0.00%
VCSH$79.740.0024$0.19$0.19#DIV/0!0.00%
FAZ$19.35-100$34.42-$3,441.54-$1,935.00$1,506.54-43.78%-0.26%
ERY$11.37-200$13.07-$2,614.59-$2,274.00$340.59-13.03%-0.30%
EDZ$17.35-200$27.57-$5,514.54-$3,470.00$2,044.54-37.08%-0.46%
TZA$18.04-350$21.62-$7,566.14-$6,314.00$1,252.14-16.55%-0.84%

My transactions in March are listed as follows:

StockActionCostPrice per share% of Portfolio
ERXCover$1,580.26$31.610.17%
FOSLAdd$1,032.24$17.500.11%
TGTAdd$750.00$57.020.08%
RLAdd$500.00$80.240.05%
MATAdd$500.00$25.240.05%
IJRAdd$476.00$68.000.05%
XOMAdd$333.70$82.010.04%
AFLAdd$329.30$72.490.04%
EMRAdd$309.19$59.520.03%
EXCAdd$248.38$35.930.03%
WMTAdd$200.00$70.610.02%
VMIAdd$200.00$153.490.02%
KOAdd$200.00$42.230.02%
BRKBAdd$200.00$175.950.02%
NVSAdd$200.00$75.930.02%
SONAdd$165.55$53.230.02%
VFCAdd$150.00$54.350.02%
NKEAdd$150.00$57.900.02%
MCDAdd$150.00$129.340.02%
DISAdd$150.00$111.400.02%
YORWAdd$100.00$34.350.01%
ULAdd$100.00$47.190.01%
PEPAdd$100.00$110.060.01%
NNNAdd$100.00$42.720.01%
MSFTAdd$100.00$64.950.01%
INTCAdd$100.00$35.760.01%
BUDAdd$100.00$106.360.01%
BDXAdd$100.00$181.710.01%
SNYAdd$100.00$44.620.01%
NSCAdd$76.30$119.410.01%
BMTCAdd$68.30$41.350.01%
PEGAdd$63.03$44.320.01%
SPGIAdd$36.64$131.540.00%
KAdd$24.66$74.730.00%
OGSAdd$12.33$63.890.00%
PNWAdd$5.77$81.660.00%
VTIAdd$4.85$123.070.00%
VEAAdd$3.28$38.380.00%
WTRAdd$3.24$30.280.00%
VWOAdd$0.76$38.540.00%
LQDAdd$0.32$117.650.00%
VGITAdd$0.30$63.560.00%
TIPAdd$0.24$115.380.00%
SJNKAdd$0.14$27.290.00%
VNQAdd$0.07$88.610.00%
VCSHAdd$0.07$82.350.00%
ERYShort-$1,169.80$11.70-0.13%
Bought$9,024.920.97%
Sold-$1,169.80-0.13%
Net$7,855.120.85%


Purchases
This month, I added to my positions in FOSL, TGT, RL, MAT near 52-week low. Most of these stocks belong to the retail sector which has been on sale in the market recently.
I also covered the last leveraged bull ETF (ERX) and shorted more of its counterpart leveraged bear ETF (ERY). 

The rest of my purchases are part of my monthly investment plans and DRIP. 

Sales
To cover the ERX position, I shorted more ERX, 3x energy bear. I am now exclusively on the long side of the market. 

Here is how my assets, liabilities, and net worth have changed over the past month:
Beginning balance
on 3/1/2017
+ Cash inflow
/(outflow)
+ $ P/L= Ending Balance
on 3/31/2017
% P/L% Equity
ASSETS
Current assets
Cash9,885.372,383.320.0012,268.690.00%1.30%
Bonds14,706.48(2,274.34)116.1512,548.290.79%1.33%
Stocks668,163.416,539.474,560.60679,263.480.68%72.00%
Total current assets692,755.266,648.454,676.75704,080.460.68%74.64%
Tax-deferred retirement account150,213.251,515.234,258.49155,986.972.83%16.54%
Roth IRA73,612.45(103.01)73,509.44-0.14%7.79%
Gold13,331.97118.9013,450.870.89%1.43%
Other non-current assets4,000.00(500.00)0.003,500.000.00%0.37%
Total assets933,912.937,663.688,951.13950,527.740.96%100.76%
LIABILITIES & EQUITY
Liabilities
Current liabilities633.71(25.00)0.00608.710.06%
Long-term debt
Student loan6,701.47(147.01)0.006,554.460.69%
Other loans0.000.000.000.000.00%
Total liabilities7,335.18(172.01)0.007,163.170.76%
Equity (net worth)926,577.757,835.698,951.13943,364.570.97%100.00%

During March, my net worth increased 1.81% to $943,264.57, due to investment gains (0.84%) and net cash inflows (0.97%).

Below is a chart of my net worth since I started tracking on a monthly basis:


My monthly performance against the S & P 500 is shown below:
2017My Portfolio ReturnS & P 500 TR
Jan2.39%1.90%Good
Feb2.08%3.97%Bad
Mar0.97%0.12%Good
YTD5.53%6.07%Bad

March was a good month for me relative to the market, but not enough to overcome the shortfall from February. YTD I am trailing the market by just about half a percentage point, a pretty tight race for the first quarter.