What I keep track of and Why

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.

color coded

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.

Date: Income: Net profit Savings Invested (401k)
5/24/16 tax return $74.00 $7,629.20 $900.00 $378.00
5/27/2016 paycheck $660.50 $925.00 $345.00
6/10 paycheck $1,192.00 $548.00 $395.80
Baseball tickets $45.00 $507.00 $42.09
6/24 paycheck $1,234.00 $562.00 $384.72
7/8 paycheck $1,097.00 $106.80 $388.87
7/22 paycheck $1,014.00 $600.00 $339.00
Amazon $80.00 $889.00 $375.00
8/5 paycheck $1,124.00 $551.00 $123.30
bonus $106.80 $295.00 $324.00
8/19 paycheck $1,099.00 ** $550.00 $622.12

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.

networth

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.

Ticker shares cost average value in market value gain/loss gain/loss %
CHK 399 $4.92 $1,963.08 $4.00 -$367.08 -18.70%
ULTA 7 $241.25 $1,688.75 $227.69 -$94.92 -5.62%
O 25 $56.23 $1,405.75 $54.21 -$50.50 -3.59%
F 50 $11.38 $569.00 $11.64 $13.00 2.28%
BPMX 1624 $0.30 $483.46 $0.13 -$272.34 -56.33%
OHI 15 $27.12 $406.80 $27.41 $4.35 1.07%
STAG 15 $26.77 $401.55 $25.69 -$16.20 -4.03%
ATRS 130 $2.42 $314.60 $2.26 -$20.80 -6.61%
ELF 15 $19.87 $298.05 $20.05 $2.70 0.91%
AMBA 10 $52.94 $529.40 $50.25 -$26.90 -5.08%
CEFL 10 $17.72 $177.20 $17.95 $2.30 1.30%
T 5 $33.64 $168.20 $37.82 $20.90 12.43%
IP 1 $57.54 $57.54 $64.75 $7.21 12.53%
TTS 5 $9.48 $47.40 $9.75 $1.35 2.85%
JD 0 $41.82 $0.00 $0.00 $0.00 -100.00%
BAC 0 $23.95 $0.00 $0.00 $0.00 -100.00%
BABA 0 $0.00 $0.00
cash $4.35
updated $8,515.13 profits and dividends -$796.93 Current Value
1/18/18 money in $8,000.00 $515.13 current market ROI
started face value ROI 6.44%
12/2/16 net annual profit $456.37

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.

Dividend tracking 2017 2018
January $0.00 $12.32
February $0.00 $3.10
March $0.00
April $0.00
May $0.00
June $12.54
July $6.39
August $5.55
September $20.68
October $17.86
November $23.12
December $28.13
$114.27 $15.42
Goal: $125 $500

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
month amount
April 2017 $0.00
May 2017 $11.04
June 2017 $29.03
July 2017 $21.33
August 2017 $37.25
September 2017 $38.81
October 2017 $40.66
November 2017 $41.20
December 2017 $35.15
January 2018
February 2018
March 2018
April 2018
1 year gain $254.47

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 deposited account value NAR % return date immediate return monthly payments
active notes $1,500.00 16.50% 6/5/17
70 $1,700.00 $1,720.00 16.74% 6/19/17 1.176%
103 $2,500.00 $2,534.00 14.70% 7/7/17 1.360% ?
107 $2,500.00 $2,546.72 17.58% 7/21/17 1.869% $91.48
128 $3,000.00 $3,063.65 15.72% 8/4/17 2.122% $92.13
129 $3,000.00 $3,066.90 13.95% 8/29/17 2.230% $111.66
128 $2,900.00 $2,963.39 11.41% 9/15/17 2.186% $111.74
127 $2,850.00 $2,931.35 10.05% 10/3 2.854% $110.83
127 $2,800.00 $2,905.65 11.78% 10/17/17 3.773% $110.83
125 $2,650.00 $2,765.00 12.28% 11/1/17 4.340% $109.00
123 $2,600.00 $2,729.38 11.79% 11/15/17 4.976% $107.18
121 $2,500.00 $2,628.97 11.32% 12/1/17 5.159% $105.49
121 $2,450.00 $2,615.00 11.84% 12/16/17 6.735% $105.49
120 $2,400.00 $2,558.22 10.76% 1/1/18 6.593% $103.63
122 $2,400.00 $2,591.66 12.54% 1/15/18 7.986% $105.00

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 sheet blog was created 11/24/2017 Blog stats 2018
Date expense Month: November December January
11/24 $46.98 wordpress 1 year views 3 81
1/5/18 $3.00 IG promotion visitors 2 7
1/12/18 $20.00 IG promotion Revenue $0.00 $0.00
1/15/18 $3.00 IG promotion expense $46.98 $0.00 $29.00
1/17/18 $3.00 IG pormotion NET -$46.98 $0.00 -$29.00

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.

Schedule content
11/30/17 future real estate investment
12/3/17 Stretch investing
12/7/17 side money challenge
12/11/17 lending club review
12/12/17 change of plans
12/17/17 stock portfolio
12/20/17 Aspiration|Summit
12/20/17 stash investing
12/21/17 acorn investing
12/27/17 Discover Credit Card
12/27/17 Dividend update 12/27/17
12/28/17 2018 Goals
1/3/18 stock market book FE
1/5/18 review Robinhood
1/5/18 side money update 1
1/16/18 status update
1/22/18 airsoft entrepreneur

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.

Thanks, B^2

Acorn investing/savings app

Another investing/saving app I use is Acorn. I’ve been using this app since November 2016, and haven’t used it nearly as much as Robinhood or Stash. Acorn is an app that uses your rounded up spare change from purchases on credit/debit cards to fund the investment portfolio ($5.63 is rounded up to $6 and $0.37 is deposited into the account). Due to my very different stretch investing method I’ve been using recently, I stopped using acorn in July 2017. In that short duration of time I was able to make a 4.3% return in about 7 months using the aggressive portfolio shown below. Extrapolating that return into a APY yields approximately 7.4% return. The conservative portfolio is shown below for comparison.

IMG_0126IMG_0127

Between my age, tolerance of risk, and a reliable fall back plan allows me to invest in the aggressive portfolio worry free. The app has you put in your financial information and goals and recommends the proper portfolio you should invest in. Based on the app I was actually supposed  to invest in the moderately aggressive portfolio, but changed to the aggressive portfolio.

Below are my returns and the “Found Money” page.

IMG_0123IMG_0124

The “Found Money” page is essentially the rewards portion. When you make purchases on your linked cards they will redeem the rewards which are paid out in flat rates ($5, $3 etc.) or in a percentage of your total purchase. I currently have a pending “Found Money” reward from the Wall Street Journal for a 2-month trial to their subscription for a $5 amount and the subscription fee cost me $2 for a net $3 gain. Along the lines of free money, when you use the invite code below you will receive $5 in your acorn portfolio.

https://acorns.com/invite/SGQYCZ

Overall, I would say this is a great app to start saving more money daily. The platform of the app is simple and easy to use providing graphs and detailed information where you want it and an overview where you don’t. There is also a “grow” section which is their article and information area. They post monthly articles from Warren Buffet advice, to basic investment information. I would highly recommend this app to beginning investors and savers as well as anyone that could use a little kickstart on saving more money.