I came to you guys almost 3 months ago with an overview of my dividend income and situation. Back then I was bringing in approximately $150 a year in dividends from Robinhood and with all dividends and interest included I was bring in a little over $20 a month. Today this is what we are looking at.
The above table tracks my dividends from multiple platforms (Robinhood, acorns, and stash) as well as interest I receive from Robinhood. As you can see there is a general trend upward and although there were some bad months (January) I receive upwards of $20 a month in dividends. Here is the table in graph form, the blue represents 2017 and the red represents 2018. As you can see March 2018 has been my best month to date with $31.68, or about a $1 a day.
Below is another table tracking my dividend stocks in Robinhood. As you can see I am now making approximately $200 a year in dividends not including stash dividends or Robinhood interest. This equates to approximately 2.5% return on my portfolio in dividends. I also have small positions in some very high yield dividend stock such as CEFL, CBL, and OHI. I am looking into increasing those positions moving forward and cost averaging down when I can, to increase actual percent yield which is calculated in the table below.
Overall, I am impressed with these results as I have been taking my foot off the gas in terms of investing in dividend stocks. I have been looking more into higher potential returns than higher dividend income recently and we will see how that pays off in the future. Currently my largest position is down big right now (~$750) as that comes up as I expect it too in 2018/2019 and I can funnel more money into my investing accounts I will keep you all updated on my stock portfolio and my dividends.
So naturally as an engineer I am very numbers and data driven. Fluff is not my game, numbers, charts, graphs, hard tangible data is where I thrive. I started tracking my spending while on co-op and internship, I figured it would be good practice for when I got out in the real world on my own and needed to be financially responsible. So, at that point I created what is now my most useful tool that I use to track my finances and goals, the co-op money breakdown google sheet. Doesn’t sound exciting but contained in these 8 pages excel spreadsheet is a lot of cool stuff. We’ll start with what started it all, the daily tracking of my finances.
I color coded my categories of expenses, from left to right they are Food, gas, fun money, fitness, Significant other, and other costs. I would track every cost that came in with running totals at the bottom, weekly amount spent on each category as well as the percentage of my costs it represents. This helped figure out where I was over spending and what needed to be adjusted. Next, on the same page of the excel sheet right next to the color-coded spending category is my income category. Here I would track my income (mainly paychecks) as well as how much of that income I saved. I also tracked my 401k contributions on every paycheck and kept a running total of that as well. Yes, I had a 401k through my co-op company at 20 years old, it was pretty frickin cool. Moving on, I would run totals on all of that, run percentages for amount of money I was saving compared to making and how much I was investing compared to how much I made in total etc.
5/24/16 tax return
After that I believe I started tracking my net worth in specific categories. As you can see below I would track it every month and I have a nice little graph and everything, but I would track cash, emergency fund, P2P lending, Robinhood stock account, Stash and acorn, and finally my 401k. Add all that up in a couple different columns and there’s my net worth tracking.
Another critical tool that I use on this spreadsheet is my Robinhood portfolio spreadsheet. Shown below it contains all the information on my stocks, shares, cost average, value into the position, market value and then the gain/loss with percentages. Also, the conditional formatting is a nice touch to quickly assess the portfolio. I usually update this sheet twice a week or more if I make big moves in the portfolio which I have recently.
profits and dividends
current market ROI
face value ROI
net annual profit
Following the stock portfolio, I have two tables for dividend tracking however I’m only going to show the monthly counting dividend table. Below is a table showing how much I’ve received in dividends by each month and then sum it all together for the yearly total. As you can see I was relatively close to my goal this past year, a lot of my money was tied up in bad positions that didn’t pay dividends which ultimately hurt my portfolio as well. The other table features all the stocks I own that pay dividends, their payout on a yearly basis, how many shares I own, total yearly dividend income from those stocks, etc. I believe I am right at the $200 a year in dividends mark as we are speaking, that is not including interest payments I receive from Robinhood or the dividends I receive in stash.
I also use 2 tables for my Lending Club portfolio, the one below just tracks the interest I receive each month as it says on the account statement I get. Very simple and easy to fill out, nice little tool to figure out how the portfolio is doing overall at a quick glance.
Lending club interest collected
1 year gain
This next one is a bit more intimidating. This is a detailed depiction of the Lending Club portfolio, I fill this one out biweekly and the immediate return column is the only one that is self-calculated, everything else is straight from the Lending Club dashboard/summary screen. I use the immediate return to gauge my APY % as it comes in rather than the speculative NAR % return.
Lending Club info
NAR % return
Finally, I track my blog statistics and posting schedule on my spreadsheet. As you can see I have tracked my advertising costs as well as the WordPress cost of the blog. I also track my views, visitors each month. Now if you are familiar with blogging or have one already you know that jetpack tracks this all for you currently. I just like the convenience of pulling up this spreadsheet and having all the numbers and data I’d ever care to know about right at the tip of my fingertips and easily analyzed. I think It is worth the extra time to fill out the spreadsheet.
blog was created
wordpress 1 year
Like I said, just a schedule of what I’ve posted and when, I also anticipate a posting schedule but that is never correct, I always have too much on my plate or other things that need my attention before this. The yellow highlighted posts are blog posts that have the potential to profit through affiliate sales, referral codes, etc. I have a column next to it with the amount they’ve made so far. Unfortunately that’s a big fat goose egg right now.
future real estate investment
side money challenge
lending club review
change of plans
Discover Credit Card
Dividend update 12/27/17
stock market book FE
side money update 1
As always let me know that you think!Hope you got some useful information from this post, and may apply some of the ideas and concepts to help organize your finances or something else important to you.
Hey sorry everyone, I was out of town on a ski trip this last week and didn’t have a chance to post anything. I’m back at school now and while its been hectic getting back I should be able to post more frequently, my goal being every other day or thereabouts. I have a friend that will write an article on Lyft or drop shipping here shortly and he’s had incredible success with both so keep your eyes open for that.
Other than that things have been relatively uneventful. My stash portfolio has been doing incredible its up about $100 in the last 2 weeks (portfolio value of ~$2150 so ~5% increase) and I started an Instagram account for the blog you can follow it @bsquared.website. I’ve been experimenting with Instagram advertising and trying to promote my articles and posts through that. Look for a review of that in the future as I learn more about the subject and experiment with different methods to drive traffic and revenue.
I’ve started reading Grant Cardone’s The 10X Rule: The Only Difference Between Success and Failure, and I would highly recommend that book so far. Look for a review of that here shortly as well as well as some drastic action that I will take as a result. I would also recommend checking him out on YouTube, he offers lots of advice and motivation and is a great source for information regarding Real Estate if you choose to go that route which I intend to do when I get some more capital.
Also I have several posts that have the opportunity to make me revenue through the blog, including the book review for stock market investing, Discover It credit card, stash app review, acorns app review, Robinhood app review etc. Unfortunately I haven’t made any revenue from these opportunities yet but I think we are getting closer and I expect to make my first dollar from this blog by the end of January. I will of course keep you all updated on that as well.
In summary, buckle up ladies and gentleman, 2018 is going to be a phenomenal year filled with handwork, hardship and opportunities and we should all try to make the most of it.
So as December ends and 2018 is fast approaching I’ve been thinking what I want to accomplish this upcoming year. I’m not talking about New Years resolutions or anything, I’m looking at this year as a incredibly critical moment in my life. The actions I take in 2018 could have a significant impact on my life, and could either push me to the next level however you would like to define it, or I could come up short. As I mentioned before in my “Change of Plans” post, I did not get offered the co-op or internship that I thought I had a very good shot at. The co-op would’ve gave me another huge influx of capital and could’ve been a critical asset in my financial life. The missed internship opportunity would have most likely secured a career path once I graduated. So, without either of those I am approaching 2018 in no man’s land. This would be the first time in 2 years that I am going into the new year without a summer job prospect or offer. I did end the Fall 2017 semester very strong, so I have that going for me as well as some good stock positions and prospects going into 2018, but back to the goals. I recently started reading Grant Cardone’s The 10x Rule which has driven me to set more ambitious goals and to put in more time and effort to achieve those results.
$2500 in my aspiration emergency fund (this would give me the 1.00% APY interest rate)
$20,000 In my Robinhood portfolio (originally shooting for $10,000, hoping some options trading will give me the edge I need to achieve this goal)
$10,000 in stash app (originally $5,000)
$10,000 in Lending club (originally $5,000, would be incredibly useful in the stretch investing method)
Collect over $1,000 in dividends and stock interest (this years projected amount was ~$250, original goal was $500)
Have 5, $1,000+/year income streams by the end of 2018 (Anticipate being Dividends/interest, Lending Club interest, Internship, Drop Shipping, Blog)
150 blog posts by the end of 2018
All these goals are related to the blog and my financial life, I also have goals, relating to my academic life, extracurricular involvement, and fitness. I won’t get into details on these to keep this post short.
So tell me some of your goals and ambitions this year, I look forward to reading your comments.
I have been using Stash since November 2016 and I am a huge fan. Stash is an app based platform to invest in ETF’s (exchange traded funds) and offers over 40 of them. ETF’s are a grade investment to help diversify your portfolio and mitigate risk, as well as a sound investment for beginners. When you follow the link https://get.stashinvest.com/brandoni35n0 you will receive one year of free investing (normal fee is $1 a month for accounts under $5,000, and 0.25% APY for accounts over $5,000). Below are some pictures of my own stash portfolio and what all I own.
The first screen shot is the portfolio screen, here you can see Total Portfolio Value and Total Return. As you can see in 13 months I’ve managed an impressive 25% return, with minimal risk. The screen shot on the right shows my account balance over time, if you have seen my stretch investing article you may recognize the steady ramp up over the summer months and the slow decrease in the fall months as I start to pull out money for large expenses that come up. I would normally sell off portions of my highest return ETF’s and any funds I would receive from dividends or bank transfers would go toward the worse preforming ETF, thus following the sell high, buy low mantra.
As of 12/20/2017 here are my best and worse performing investments over the duration I’ve used the app.
Unfortunately, the app organizes based on total return in dollars which accounts for the size of the position and not just the % return. Essential Europe is my worse preforming ETF; however, I’ve only owned it since July so a 4.4% return in 6 months would ideally equate to a 8.8% return for the year, being inline with the overall market average historically speaking.
I would highly recommend this app for anyone looking to easily diversify their portfolios, or a beginner looking to get their toes wet. The app also features an IRA retirement account, and articles to help beginners learn about ETF investing and the stock market.
*Received the summary for the year from stash take a look and let me know what you think.
Hi my name is Brandon and this is my financial and investing blog!
A little bit about myself, I am a 22 year old college student, studying in the engineering field. I currently invest in ETF’s, stocks, 401k, and peer-to-peer lending. I am looking into real estate investing, options trading, and drop shipping in the future.