[Hey guys! If you love numbers and forecasting and poking around new financial calculators, you’re going to enjoy this review of OnTrajectory today :) It comes from Gwen of FieryMillennials.com and should give you something exciting to do over the weekend! Haha… Hope it helps!]
*********
Hi my name is Gwen, and I have a confession.
I love spreadsheets.
Not like, oh yeah occasionally I play around in Excel making spreadsheets. No no.
I LOVE SPREADSHEETS.
Chances are high you feel the same way. Many drawn to the FIRE life want to optimize their lives to the fullest, and one of the best ways to do so is through spreadsheets.
Months of income neatly listed in columns. Years of expenses documented in different tabs. Beautiful graphs made from forecasting the FV formula.
I can’t. Get. Enough.
Eventually, though, if you’re anything like me, you run out of variables to change. The joy starts to fade from putzing around in Excel, and you need something more to keep up the high…
Enter, OnTrajectory.
I’m pretty sure this beautiful piece of software is a love child from Excel having a one-night stand with the cFIREsim calculator.
OnTrajectory (or OT) bills themselves as “A Financial Planner and Analyzer – All in one easy-to-use graphically interactive program.” They’re not wrong. It’s beautiful.
You start off entering in some details about you: age, total savings, annual income, and how much income you save monthly. You can skip these questions and enter them manually if you want a more granular control over where that information goes.
After it processes the information, you’re taken to the main screen where you have a number of options.
Let’s start with income:
The thing I love most about OT is the flexibility to include multiple streams of income that last as long as you want.
- Day job income until you’re 34? Done.
- Great Aunt Ethel passes away when you’re 50? Put that chunk of change in there.
- Lucky enough to get a pension that starts at age 65? You guessed it: that can go in there as well!
Moving on to expenses:
Much the same story as income, except these are all the things you’re spending money on.
- Only paying for college for 2 years for the kiddo? You can include that.
- Finish paying off the house at age 45? You get the picture.
I also like that you can go super granular and include your actual budget for expenses. It’s for those that really want to go deep into their budget and estimate how changing things like not spending money on work clothes and spending more money on vacations and tequila affects their timeline.
(I may or may not be one of those people.)
After expenses comes the really fun part: Accounts and Taxes
(Is that the first time anyone has ever said taxes are fun?)
This is the section where you get to add in all of your existing accounts. If you’re like me, this could take awhile. It’s worth it, I promise.
Notice how in the picture above I have a 401k in there? Well, if you look closer at the numbers that I totally made up out of the blue, you’ll notice how it has two sections. The first section is the years I’m going to contribute money to it while I’m still working. The second part is the growth stage, where I don’t touch my beautiful little nest egg and let it grow untouched for 29 years.
As with all the other sections, you can change the date ranges and amounts contributed to see how it changes your trajectory. One really fun thing to do is to look at what your projected end number is if you stop contributing to you 401(k) this year. I bet the number is higher than you would think it would be! I wouldn’t recommend, however, seeing what your number would be if you worked for 35 years and contributed the max. Let’s just say I’d be worth well over 7 figures if I decided to sacrifice the best part of my life to ‘The Man’.
The next tab is “goals”
I’m going to be completely honest here and let you know I haven’t fiddled with this section too much. Simply because I’m a Type A person and I don’t like setting goals that are so dependent on something as flaky as the US Stock Market.
There are a number of goals you can set, though, like Trajectory reaches $ on this Date _____, Projected Progress reaches $ on this Date ______, and Trajectory reaches $ on _____ at this cumulative RATE _____.
The last and final tab is simply a list of all the progress check-ins you’ve done so far.
Everything combines to make a chart that looks something like this:
As you can see, this very simple example would have me living a life full of comfort and luxury until the end of my days. Yay!
I know this because not only does the graph end on a record high, there is also a handy dandy notification that says so. Not in those exact words though, sadly.
The notification area comes with a variety of different messages, from successful trajectory to early withdrawal penalties to projected shortfall warnings. Here are what some of them look like:
At the risk of babbling on and on about this awesome website (seriously I could talk about it all day. I feel like I’ve barely scratched the surface!) I will end with a quick summary.
Pros of using OnTrajectory
- Gives you robust projection capabilities that Excel can’t provide
- Can get way down into the details
- It’s very well documented
- It looks great!
- Their support responds promptly (now with a dedicated subreddit!)
Cons of using OnTrajectory
- The free version only lets you put in a few accounts (which is fine to poke around, but to truly get a good idea you need to add all your different accounts which requires upgrading to the “PowerPlan” at $5.00/mo)
- Takes a while to set up the first time
TL;DR
OnTrajectory really lets you dig into the nitty gritty details if you’re a numbers person. I’ve been using them for over a year now and I love it. I feel far more confident with my plans now that I can see the definite impact of working a few more years or not fully maxing out my 401(k).
Highly recommend checking them out: OnTrajectory.com
UPDATE: Two more options have since been implemented:
- Full consolidated PDF Reports of one’s overall Trajectory, as well as graphs / output data for all individual Income / Expense / Account items.
- Ability to create and share “Scenarios” with others (for example, if you wanted to demonstrate tax-handling techniques or just various assumptions about growth or contributions, and how it could be comparatively handled to reach a goal)
*****
Gwen is the founder of fierymillennials.com, a blog about achieving financial independence from a millennial’s point of view. She’s on Twitter [@fierymillennial] and also has Instagram and Facebook.
FYI: This post includes affiliate links to OnTrajectory, but of course we only blog about products we love and use here regardless of compensation. If we think it’ll help you we’ll share it!
[Awesome pic up top of the founder of OnTrajectory, Tyson Koska ;)]
Get blog posts automatically emailed to you!
This is awesome. I love playing around with spreadsheets so I will definitely have to sign up and see how i like it. Thanks for sharing!!!!
You’re very welcome! Glad you like it!
Oooohhh… it’s like catnip for clones! (or cocaine for early-retirement spreadsheet wonks?)
Very cool, Gwen. I love my Excel though (the only thing that’s “Microsoft” I can say -that- about.) So much that I even figured out how to run simulations with it. But for folks who are not as comfortable with .xls, I think OnTrajectory might be a good gateway drug. Errr, retirement planner. Yeah, that’s what I meant.
Is that why I keep having to **sniff** all the time?? hahaha
Excel is awesome if you know how to use it, but not everyone loves to dive in deep like us. For everyone else, there’s OnTrajectory. Hmmm that’s catchy. Sounds like a good slogan! ;)
hey gwen..! i love numbers & i love your review, cfiresim calculator its really nice. thanks for sharing !
Thanks Sam, you’re very welcome!
So cool, thank you for sharing your review, Gwen! I’ll have to check this one out (I’m always looking for a fun calculator to play around with…!).
You’re welcome, Mrs. Adventure Rich! Have fun and let me know what you think!
Great title! Excel is such a great tool. It can go from basic calculations to complex formulas that can help simplify our complicated problems.
I’m not in love with Excel per se, but after I started blogging, I’ve been obsessed with Google Analytics. I can just stare at GA without blinking to process all the great data it offers. Why do I love Google even more? Google search and Google Analytics!!
Oh man…. GA and site stats are a whole nother topic I could talk about all day. It’s so addicting!
They are pretty quick to respond to bugs and feature requests. One bug I found was fixed basically over night. And then my suggestion of drawing down from non tax advantaged accounts first was implemented in about a week.
Yeah their support is amazing. Very responsive! Thanks for reading SC!
I have been maintaining my spreadsheet for about ten years now and it’s just rinse and repeat every quarter when I do my net worth calculation.
Yes, the joy of creating new formula and graphs definitely diminished over time. However, the joy of seeing your net worth grow exponentially is still there.
As a parent of two young kids, it’s difficult to spend the same amount of time that I used to when I had no kids. This tool seems interesting and maybe it’d save me some time in the future once I migrate my numbers to OT.
I can’t recommend it enough!
I second the kids situation :)
Gwen – Thanks for the tutorial!
I love cFIRESim and FireCalc and use both all the time.
I have looked at OnTrajectory and it just felt too complicated for me. It may have to do with the fact that I’m already FIREd so I’m really looking for how much we’re under-spending. This is easy to do with cFIRESim and FireCalc because you can configure both of them to tell you how much you can afford to spend and still have a theoretical 100% success rate. Can you do that with OnTrajectory?
Yes, if you “over spend” you can run the “shortfall” warning to figure out how much more on average you need to save.
I’m not entirely sure since I haven’t tried to do that with OT. I can play around in it and let you know though!
Thanks for sharing! Excited to take a look at this and play around with some scenarios!
Let me know what you think, Lance!
You had me until the $5/month…(dang am I really that cheap?!) Sounds like a great tool though, thanks for sharing!
Yeah $5/mo is something to consider, but I’d say it’s worth it!
This seems super cool. I may have to play around with the free version for a bit when I have time (LOL which is never, damn moving…) and see how I like it.
I’ve been slowly building something similar out for my own purposes as well. :)
Ah the ol “when I have time”…. I’ve found myself to be short on that too lately!
I’d be interested to see what you’ve got so far!
Ohhhhhh – I am intrigued. I love me a good spreadsheet las much as the next (nerdy) person but I haven’t found the right FIRE calculator yet. So many variables!! I hope this will be “the one”!! :)
Just as long as you tell everyone I was the one to introduce you! ;)
It does look quite interesting – thanks for sharing!
I don’t think $5 is too much for a powerful, helpful tool. But what are your thoughts on this tool vs. Personal Capital or similar apps / tools?
I definitely enjoy numbers and tracking, but the time to setup and for maintenance looks intensive if you’re to utilize all the various functions.
Personal Capital is good for seeing all of my investments. I like that they tell me what % of the market I’m holding and the fee analyzer is awesome.
OT is strictly for projecting out the FIRE path. I can play around with different hypothetical scenarios and see what makes a difference. I can’t really do that with Mint/PC/YNAB.
Cool, review that opens my mind up to the potential and possibilities of spreadsheets. Unfortunately, I don’t have any natural skills when it comes to spreadsheets. That probably stems from too many years working on a typewriter that was engineered long before interactive spreadsheets even existed. Will have to give them a try and see how they go.
I swear – one of these days I’m totally typewriting up one of my blog posts and scanning it here, haha… Wouldn’t that be so cool/nerdy? :)
As a recovering spreadsheet addict, I’m afraid to dive in here. I know once I get in I might never get out again.
Ahhh screw it! *clicks to site*
Haha.. DO ITTT!!!!!!!!!
It’s awesome that they let you see the impacts of rental income and leaving your 401K alone for years. Neat tool!
This looks awesome! I will definitely check it out. I’m also a spreadsheet addict and am sad that I can’t post all my blog content in spreadsheet form. For some reason, people want words.
okay, now THAT is funny :)
This calculator is completely useless.