Create A Kickass Financial Spreadsheet: A Candid Review Of Actuary On Fire’s Course

crispydoc Uncategorized 8 Comments

I recently got a hot tip from a friend I trust and respect. Gasem mentioned that he'd enrolled in an online video course on creating a Financial Independence spreadsheet taught by blogger and math whiz Actuary on Fire (henceforth "AoF," which I imagine to be the sound of a sucker punch to your cerebral cortex). He'd found it to be outstanding.

Explanatory Digression Break

I'm a math guy, but not a spreadsheet guy. I was a former mathlete in high school. You'll be relieved to learn, dear reader, that dating with a stethoscope in later life more than made up for the challenges of dating with a calculator watch in early life.

Some on my math team were recognized as innately gifted. I was the "hard worker" of the group, which is what the faculty advisor calls the kid who isn't a native speaker of equations but demonstrates an admirable work ethic. If you believe in growth mindset, however, work ethic and practice are ultimately the qualities that matter most.

Spreadsheets Intimidate Me

The last time I'd used a spreadsheet, the dominant software was Lotus 1-2-3. Consequently, Excel and its free google equivalent left me exclaiming "Holy Sheets!," and seemed far too sophisticated for my cave-man level skills. Which is why I jumped at the opportunity to learn something designed for students who need their hands held.

AoF joined the Rockstar Finance Forum shortly after I did, and I recalled his jovial and generous personality from a few discussion threads we both partook of. So I thought nothing of reaching out to my old compadre, who was kind enough to let me test drive his video course on Udemy for free.

The course consists of bite-sized videos ranging from 1 to 14 minutes in length, each with a discrete spreadsheet skill set or concept that is covered.

Let's Look Under The Hood

AoF starts gently, introducing you to the concept of cashflow modeling as a secret actuarial tool of the trade. His spreadsheet allows for multiple sources of income (and expenses) that may vary over time. Some remain predictable over years, like a salary or social security. Others reflect one-time windfalls or expenses like property sales, a child's college education or major home repairs.

Since many docs on the road to FI have side hustles and additional streams of income, this is a great way of accounting for a multi-income household.

Accounts are grouped into pre-tax and post-tax, with the ability to use different predictions for their respective returns. One can also designate different withdrawal rates for pre-tax and post-tax accounts. The effect is a very customizable prediction tool with an extremely granular level of detail.

This naturally lends itself to bouts of prolonged experimentation - you can now see what happens if you work a couple of additional years, if your spouse retires earlier, or how finances might be affected if you opt to have that third kid.

I spent two hours in the blink of an eye playing with the customized spreadsheet I created, but it left me reconsidering the best strategy for our glide path toward retirement.

Highlights

I love having the video lectures to refer back to if I forget a particular command or lose track of how to perform a function.

I also enjoyed having the spreadsheet ready to download in the identical format used in the lecture series, so that I could take a functional version and simply change the numbers to reflect my situation.

The ability to change individual variables and immediately see the impact this has on predicted retirement income makes abstract concepts far easier to grasp.

AoF is an outstanding lecturer, and he used simple language that steered clear of jargon. I never felt condescended to or less than for my ignorance of the subject matter. The icing on the cake was AoF's charming British accent (it reminded me of Mike Myers' old SNL skits as Simon, the British child who likes to make "drawrings").

I found little to dislike about the course.

While the spreadsheet does not account for the effects of taxation, this is announced at the outset as being beyond the scope of the course. There is intimation that an advanced course will follow. I  look forward to enrolling, and hope that taxation will be included in the next version.

There was liberal use of anthropomorphic animals, perhaps intended to add levity and make a challenging topic seem approachable. While this felt distracting during a couple of lectures, it fortunately never reached the fiasco of 1997's release of Microsoft Word with Clippy, the animated paperclip.

Target Audience

I'd recommend this course for anyone who seeks to factor in complexity when they model their financial future, for example:

  • Dual-income households where one partner may have variable income over time as they ramp down work to care for children, then ramp up as kids grow independent.
  • Persons who plan for a "mushy" retirement; instead of going from salary to no salary, these folks plan to continue earning fluctuating income in some capacity.
  • Persons with multiple income streams such as rental real estate investments.
  • Dual-income households where retirement dates and post-retirement income is likely to vary.
  • Partners of different ages and different career stages who would like to model how staggered retirements will affect household cashflow.
  • Control freaks (you know who you are) who enjoy futzing with variables to model their effects on cashflow in retirement.

AoF reminds me of that buddy in college who allowed you to knock on his door whenever you had trouble with a problem set, and was never too busy to answer a question.

His passion is obviously in teaching others, as reflected in the course's modest pricing ($49 at time of this post). At one and half hours total, it's a small time investment for a high-impact educational supplement.

I make no commission if you buy the course - but if you are seeking to reach Financial Independence and want to add a powerful tool to your tool belt, I was extremely impressed and would recommend this course without reservation.

Click here to purchase Actuary on Fire's online course, Create A Kickass Financial Independence Spreadsheet.

Comments 8

  1. Great review and pretty much spot on with my experience of the course. If you’re not a spreadsheet jock there is no time like the present to pick up some chops. When it comes to spreadsheets GIGO (garbage in = garbage out) so it’s nice to work a cash flow sheet that’s reliable from the start, open to modification, and the ability to quickly return to square 1 if you get the logic wrong. It’s a quantum better than the typical bogglead 4th grade math (4 x 25) approach to cash flow. Knowledge is power, this thing makes you powerful regarding your particular financial situation.

    1. Post
      Author

      I think I just felt a chest hair sprout while using the spreadsheet.
      It’s a wonderful tool, but more importantly, it’s a very easy to follow teacher. Without that the utility would be far less.

  2. Thanks for the review – I thought that was very fair. I’m glad you found it useful and not intimidating.

    To Gasem’s point I wanted to make it easily tailored to your own situation. So the cashflow approach was the most transparent.

    1. Post
      Author

      I truly enjoyed it, and had to reach to find something that was not to my liking.

      It’s wonderful to have a tool like this and understand how to use it without having needed to create it myself, which would have required more remedial education.

      Thanks for the gift AoF!

  3. Appreciate the review CD. Having recommendations from Gasem and you already speaks volumes about the course. I have enjoyed AOF’s posts on POF as well.

    1. Post
      Author
  4. Like you I have a lot of facility with reading spreadsheets and zero with creating them. I had been trying to get something together to use for months when this AOF course came out and it’s exactly what I needed. Fun too. Highly recommend!

    1. Post
      Author

      Happy to hear from another satisfied student! I’ve had loads of fun tweaking the numbers and watching the immediate effect on the spreadsheet (but I’m weird like that).

      Thanks for piping in, NAFW!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.