FIRE Calculator

[ky_gal]

Hey guys!

The increase in posts and comments about Financial Independence/Retire Early (FIRE) has been a delightful surprise.

I was recently asked to share my FIRE calculator, so here it is:

https://docs.google.com/spreadsheets/d/17hwQ5MND2xtyW3PSbYdLkX1Lc9XqMV1yAY7qNzfb3cY/edit?usp=sharing

Play around with the yellow cells (age, salary, investment allocation, monthly expenses, big expenses like wedding and cars, etc), and you'll get projections like this and this.

For more info on FIRE, you may refer to this post and this one.

There's also some FIRE discussion on the phinvest Discord chat. https://discord.gg/AxFw5Pb

Ciao!

Edit: In case you guys want the excel file, here it is.

Edit 2: Here's the Google Drive link.

Warning: Your data will be visible to others. If you don't want that, pls make a copy or download to your local hard drive.

 

[tutorman]

@ky_gal Wow! good to know that there are other people also pursuing FIRE in the PH. Keep it up!

 

[flowerinthesky]

@ky_gal Wow! Thanks for this, will tinker with it, and see if my goals is reachable by the time frame I'm gunning for.

 

[taostish]

@ky_gal Good on ya, Spread the FIRE!

 

[mylordyeshuathemessiah]

@ky_gal Just dropping by to say thank you for this post.

This is an excellent material that will be helpful to a bunch of us here (non-excel savvy). I like how the file was structured specially adding the non-recurring expense part. It gives one an idea how massively a home renovation or a car purchase will affect the total net worth and portfolio growth if the timing is awful (early accumulation phase).

 

[jesuslovesyou69]

@ky_gal How do I estimate my net worth?

 

[ky_gal]

@jesuslovesyou69 Assets minus liabilities. Here's a guide.

 

[jesuslovesyou69]

@ky_gal Thanks!

 

[resjudicata]

@ky_gal Huh, so I can retire in 10 years with a 40-30-30 stocks-bonds-cash portfolio, and 5 years with a 60-20-20 allocation. Not too shabby, but I do want to keep on working for at least 15 years more for that sweet, sweet retirement package.

 

[ragamullin]

@ky_gal Thank you so much!!!

 

[gregorystellar]

@ky_gal Hello po... Paano mag save ng spreadsheet? Cannot access my discord (forgot pw) so cannot access the excel file.
Thank you po in advance.

 

[ky_gal]

@gregorystellar Hi @gregorystellar! Here's the Google Drive link.

 

[gregorystellar]

@ky_gal Thanks a lot OP... More power to you!

 

[resjudicata]

@ky_gal Thank you so much for this!

 

[a_soft_voice]

@ky_gal Thanks for this. Im on mobile now but I will try it on my browser tomorrow.

 

[humansmeagol]

@ky_gal Sir,

Why is it that at age 46, my net worth starts to decline and completely becomes negative at age 55?

 

[ky_gal]

@humansmeagol That's because your expenses are probably increasing at a faster rate than your income and investment growth. Come join us in the phinvest discord chat as well --- we have a channel dedicated to FIRE. Here's the invite: https://discord.gg/AxFw5Pb

 

[resjudicata]

@ky_gal Thank you. very helpful spreadsheet!

 

[megahunky]

@ky_gal Dude lock the document and require everybody to "Make a Copy"

 

[ky_gal]

@megahunky Yeah, I locked the sheets except for the yellow cells. People are free to make a copy or even download the excel file. Gonna have a blast looking at your numbers