Build an Investment Calculator in Tableau

Calculator on Tableau Public Dashboard

I love compound interest calculators and use them all the time. If you are looking for the best place to park your nest egg, it can get a little rough tracking the results of these calculations against one another. There are some comparative calculators out there, but they make odd choices on parameters. For instance, you can show compounding monthly (an option few need that does not change the numbers much) but you cannot show the investments at different start dates. I thought there must be a way to make this happen in Tableau.

I tried this a few ways. The hard part was realizing I needed to hard code the dates while filling a revenue column with 1's. (I tried date calcs a few different ways to make it dynamic but no luck.) From there, it was just interest formulas, several parameters and lots of formatting. (Educational purposes. Not investment advice.)

The top line of each investment shows total revenue. Bottom line is interest only. This is useful if you are calculating things like real estate (where you need to drop the mortgage from the principal return) or Roth IRA (where interest is not taxed) against a standard investment (where interest is taxed.) * You'll need to calculate T&I on your own, but this gets you most of the way there. You can use the embedded widget below or the link above to try it out. Let me know what you think!

No Comments Yet