Author Topic: One sheet to rule them all...  (Read 128656 times)

letstalkaboutdune

  • 5 O'Clock Shadow
  • *
  • Posts: 16
  • Location: Tucson, AZ, USA
Re: One sheet to rule them all...
« Reply #200 on: January 19, 2018, 01:28:54 PM »
Thank you for this awesome spreadsheet! Starting in January should keep things nice and clean for me. I did make a couple of edits, like removing the Invest sheet (already tracked through Fidelity and Personal Capital), and automatically pulling the monthly Income and Expenses data into the NW tab. Finally, since my discretionary and excess expenses will change each month, I grouped the non-standard categories into a row called "Other" in the FI tab, and that is calculated with whatever's left after the standard categories.

px4shooter

  • 5 O'Clock Shadow
  • *
  • Posts: 98
Re: One sheet to rule them all...
« Reply #201 on: February 08, 2018, 09:40:52 PM »
Thanks for the sheet!!

Awesome calculations, but I am stuck. I still have 3 properties with mortgages. I cannot see how to calculate the other sheets into the main page. I duplicated the mortgage page and set them up, but just having calculation issues.

Any excel tips on this type of setup?

rosipov

  • 5 O'Clock Shadow
  • *
  • Posts: 2
Re: One sheet to rule them all...
« Reply #202 on: April 01, 2018, 12:09:28 PM »
I'm a few years late to the party, but I started using the sheet a few months ago and I love it! Quick question though, where does tax refund come into the picture? Is there somewhere I can keep track of it?

wienerdog

  • Bristles
  • ***
  • Posts: 453
Re: One sheet to rule them all...
« Reply #203 on: April 07, 2018, 08:49:32 AM »
I just put it in one of the 6 different income entries on the month it comes in.  IE right below you paycheck.  It will get added into income and then calculated into you saving rate as I am sure you are investing it all right????

rosipov

  • 5 O'Clock Shadow
  • *
  • Posts: 2
Re: One sheet to rule them all...
« Reply #204 on: April 07, 2018, 12:44:37 PM »
Oh, I should have probably thought of that - thank you! That makes perfect sense, I just put those as positive State Tax/Federal Tax item in the paystub section. And yes, I invest all of it :)

Now I just can't wait until the end of the year to see what's my real savings rate now that the tax refund is counted!

VanteBoll

  • 5 O'Clock Shadow
  • *
  • Posts: 14
Re: One sheet to rule them all...
« Reply #205 on: April 23, 2018, 05:01:40 PM »
Can anyone tell me why I am getting this error on FI tab (in the attachment)?

I've inserted values for each month and the mortgage tab, but that's it. Any ideas?

Thank you in advance.

PrairieBeardstache

  • 5 O'Clock Shadow
  • *
  • Posts: 44
Re: One sheet to rule them all...
« Reply #206 on: May 01, 2018, 01:20:39 PM »
I apologize if this has already been asked/answered elsewhere but: Has anyone turned this into a Ruby app or similar? And if so, a GitHub repo?

I know there are several software engineers here so I figured I'd ask before I went ahead and made this a side project (also, I'm not a great programmer, but good enough to create a self-hosted version of this).

wienerdog

  • Bristles
  • ***
  • Posts: 453
Re: One sheet to rule them all...
« Reply #207 on: May 06, 2018, 08:36:59 AM »
Can anyone tell me why I am getting this error on FI tab (in the attachment)?

I've inserted values for each month and the mortgage tab, but that's it. Any ideas?

Thank you in advance.

You need to fill out one row on the NW tab.  This is your "snapshot" in time at the end of each month that will stay with the sheet from year to year.  As you get more data in there the numbers will become more accurate.

IndyPendent

  • 5 O'Clock Shadow
  • *
  • Posts: 96
Re: One sheet to rule them all...
« Reply #208 on: May 09, 2018, 06:40:16 PM »
I apologize if this has already been asked/answered elsewhere but: Has anyone turned this into a Ruby app or similar? And if so, a GitHub repo?

I know there are several software engineers here so I figured I'd ask before I went ahead and made this a side project (also, I'm not a great programmer, but good enough to create a self-hosted version of this).

Interesting—whats your vision for the self-hosted version? Meaning, what would others get from it that they wouldn’t get now? Im curious what value you anticipate app-ifying it would create.


Sent from my iPhone using Tapatalk

PrairieBeardstache

  • 5 O'Clock Shadow
  • *
  • Posts: 44
Re: One sheet to rule them all...
« Reply #209 on: May 11, 2018, 10:17:35 AM »
I apologize if this has already been asked/answered elsewhere but: Has anyone turned this into a Ruby app or similar? And if so, a GitHub repo?

I know there are several software engineers here so I figured I'd ask before I went ahead and made this a side project (also, I'm not a great programmer, but good enough to create a self-hosted version of this).

Interesting—whats your vision for the self-hosted version? Meaning, what would others get from it that they wouldn’t get now? Im curious what value you anticipate app-ifying it would create.


Sent from my iPhone using Tapatalk

Connecting to third party APIs used for the basic input functions: Mint, Investment brokers, etc. (I'm unsure if they have public APIs)

In effect, like Mint, but for FIRE.  In short, I'm lazy when it comes to trivial tasks and I like to automate them away.

pseudoyams

  • 5 O'Clock Shadow
  • *
  • Posts: 18
Re: One sheet to rule them all...
« Reply #210 on: July 09, 2018, 10:57:56 AM »
Sorry if this has been asked before, but is it possible to accurately start this in the middle of the year.  Or, does it require all data for Jan-Dec?  I dont think I can get the wife's payroll info prior to last month.

Nm, I figured it out.  RTFM. ;)
« Last Edit: July 09, 2018, 04:15:16 PM by pseudoyams »

budgetryan

  • 5 O'Clock Shadow
  • *
  • Posts: 1
Re: One sheet to rule them all...
« Reply #211 on: December 01, 2018, 10:17:21 AM »
First - this sheet looks fantastic. In the process of molding it to my preferences now!

These may be two dumb questions but..

1) Where does the investment tab tie back in to the rest of the spreadsheet (i.e., income, net worth, etc.)?
2) On the investment tab, how / where would I input "normal" stocks that I invest in (i.e., GM, Tesla, etc.)? I do this through Robinhood with money that is not tied to an IRA or 401K retirement account.

Thanks so much for your help!! Very much appreciated.

wienerdog

  • Bristles
  • ***
  • Posts: 453
Re: One sheet to rule them all...
« Reply #212 on: December 14, 2018, 03:32:58 PM »
First - this sheet looks fantastic. In the process of molding it to my preferences now!

These may be two dumb questions but..

1) Where does the investment tab tie back in to the rest of the spreadsheet (i.e., income, net worth, etc.)?

The investment tab doesn't really tie back into anything.  It is just a way for you track your investments at different accounts if you have that.  IE you might have a 401k at work, IRA from previous jobs and HSA.  You need to manually copy the value at the end of each month and enter it into you NW sheet.  You should have a column for each account there.  The NW sheet stays with you from year to year so you can see how your accounts grow.  Some people don't use the investment sheet and just go look at your account balance and enter that on the NW sheet at the end of the month.  Just think of of the investment sheet as a tracker and then the NW sheet is a snapshot of that investment sheet at the end of the month.  I find it convenient to use the investment sheet then once every several months log into Vanguard as your dividends and things like that will slightly change your holding amount of any particular stock / bond.


2) On the investment tab, how / where would I input "normal" stocks that I invest in (i.e., GM, Tesla, etc.)? I do this through Robinhood with money that is not tied to an IRA or 401K retirement account.

Just take one of the accounts on the investment sheet and make it Robinhood.  Rename the taxable one if you like.  You can then insert rows in between the middle of that account to how many rows you need for each stock.  Then you will have to cut and paste the formula's down from the first row to get everything to update right.  Then up top make sure the formula is correct for that account.  It needs to sum from the top row of that account to the bottom.  I believe if you insert a row in the middle it will adjust the formula up top for you.

I hope that helps.  Sorry it took a while to answer been really busy with work.


Thanks so much for your help!! Very much appreciated.

olorenshaw.s

  • 5 O'Clock Shadow
  • *
  • Posts: 1
Re: One sheet to rule them all...
« Reply #213 on: February 18, 2019, 12:51:28 AM »
Hi everyone! A little late to the party here but it's fantastic to see such a wonderful tool for FI upon my return to the MMM world from a slight hiatus.. first time posting on the forum, however!

I'm having a couple of problems in setting up the spreadsheet and hoping I can get some help:

1. My 'budgeted' costs don't seem to be flowing through to the monthly tabs (it is using 'Costs' in FI column B) - I have selected 'TRUE' against 'Use Budget?' in the FI tab
2. My adjusted income doesn't seem to be correct - as if it is adding my monthly taxes, rather than subtracting. I'm nervous to play with the formula, so there might be a trick here?

Obviously it's pretty key to get these two things correct, rather than having erroneous or incorrect figures... I can live with a few $ here or there, but adding taxes and having the default expenses  seems less than useful!

wienerdog

  • Bristles
  • ***
  • Posts: 453
Re: One sheet to rule them all...
« Reply #214 on: March 03, 2019, 02:11:24 PM »
The budget doesn't pull from the monthly tabs (I think it is left over from the original Sheet).  If you want to look at what budget would do compared to your real spending just set use budget to TRUE on the FI page and set your monthly budget there in column C.  You can switch back and forth by setting it to TRUE or FALSE to compare the two.

Did you enter you Federal, Social Security, Medicare etc. as as a negative?  It should end up looking like the accounting nomenclature.  If you enter -250 for Federal it will show it as ($250).

Retireatee1

  • 5 O'Clock Shadow
  • *
  • Posts: 33
  • Location: Fort Mill, SC
    • Retireator.org
Re: One sheet to rule them all...
« Reply #215 on: March 22, 2019, 10:06:49 AM »
Nice work.  I recently posted yet another "One Spreadsheet to Rule Them All" style thread here:

https://forum.mrmoneymustache.com/share-your-badassity/launch-of-the-2019-retireator!/

Your expense tab has more granularity, but the Retireator expense tab provides for a transition from the accumulation phase to the distribution phase.  I don't support HELOC's and student loans yet, but those can be roughly approximated.

My net worth calculation takes into account the tax obligation on before-tax savings based on the average tax rate, it doesn't appear you are doing that.

You have a lot of granularity on the investments which can be desirable, I went with basic investment type modeling including target date fund support.

Those month tabs are a bit brutal.

Your dashboard tab is very nice, I like it better than my simple graph interface.

The killer app on my tool is that it can run a binary search algorithm to forecast the exact FIRE date based on the simulation parameters.  You could plug your data into mine and have a go at that (Microsoft Excel for Windows required).