Portfolio

Investable Assets

The table below is an embedded copy of the google sheet I use to track all liquid assets. Much of it is automatically updated, but some cells need to be manually updated.

Scroll to the bottom of the sheet for the color code.

Manual cells last updated: 07/02/17

Account Key

1) Beneficiary IRA – Accessible at any time, but distributions taxed as regular income. Subject to annual “required minimum distribution” (RMD)

2) Regular IRA – Distributions would be subject to penalty except under certain circumstances.

3) Health Savings Account – Distributions would be subject to penalty unless used for qualified medical expenses.

4) 401K (mine) – Distributions would be subject to penalty except under certain circumstances.

5) 401K (my wife’s) – Distributions would be subject to penalty except under certain circumstances.

​6) Taxable Discount Brokerage – Funds accessible at any time.

7) ROTH IRA (mine) – Principal accessible at any time. Earnings subject to penalty except under certain circumstances.

8) ROTH IRA (my wife’s) – Principal accessible at any time. Earnings subject to penalty except under certain circumstances.

9) Lending Club – peer to peer lending account. Projected annual income based on “Weighted Average Rate” * “Total Invested”.

10) War Chest – Savings account; cash ear marked for investment

​11) Envelopes – Savings accounts; cash ear marked for budgeted spend.

12) Business Checking – Rental income and expenses go in and out of here. Also any other Catfishwizard Enterprises money.

2 thoughts on “Portfolio

  1. Well, if I may provide some constructive feedback:

    You have too much going-on in your portfolio, too many accounts and investment vehicles. It may help to show a consolidated or a summary view of your investments rather than a raw portfolio dump across 12 different accounts.

    For example, it may help a reader understand your investment preferences/exposure if you show your holdings as an asset class or by sector. If you are willing to share your investment income, a chart using relative comparison to earlier periods would be a nice way to show growth trends and make it more interesting to your blog reader.

    All the best,
    Mr. ATM

    1. Thanks for the comment, Mr. ATM.

      This google sheet is the one I use to manage the portfolio, which is why it’s broken up by account like that. I can appreciate that it’s a little hard to follow from an outside perspective. I will take your advice and try to come up with more of a summary or dashboard. It’s going to have to be able to link to this file though, because I’m not entering stuff twice.

      I do share my investment income. It’s on the “Income Tracker” page. You might find that spreadsheet a little cumbersome as well, but everything’s there. I’ve been meaning to put it into a graphical form though. That’s a very good suggestion.

      Thanks for visiting.

Leave a Reply