Category: Spreadsheets

How I track my finances using spreadsheets Part 6: Historical Income and Expenses, and Time to Broke

Hi RIP readers,

we have another lightweight “on the beach” post today.

I know, my public spreadsheet is getting way too big (and a bit slow), and I should probably pull something out.

Not today though.

I’ve been playing a bit too much with my Net Worth Spreadsheet lately, and ended up adding a few extra sheets that I’d like to show you today. I’ve added sheets to monitor income and expenses across multiple years (I’m tracking them in detail since beginning of 2016), and a mini retirement calculator.

Let’s look at them one by one

(read more)

Read more

How I track my finances using spreadsheets Part 5: FIRE Metrics

Hi dear RIP readers,

This is Part 5 of my Spreadsheets series. I recommend you to take a look at the previous episodes before reading this one. So far we’ve seen:
– Why I think tracking your finances is important, what to track, my tracking history, and why you don’t need any app but spreadsheets for that (Part 1)
– How I structure my spreadsheets for tracking (Part 2)
– How I track my Net Worth (Part 3)
– How I track my Cash Flow / income Statement (Part 4)

Today we’re going to deep dive into how I track my FIRE Metrics.

Well, today I don’t care much about those metrics, my perception of FIRE has changed a lot. I now see Financial Independence and Early Retirement as a continuous, a Spectrum.

I do think that if you’re at the beginning, or even midway along the way, that modeling your financial “end goal” as a finish line has a lot of motivational value. Keep going!

Enjoy!

Read more

How I track my finances using spreadsheets Part 4: Cash Flow

Hi dear RIP readers,

This is Part 4 of my Spreadsheets series.
Today we’re going to deep dive into my “Cash Flow” tracking, i.e. how I track income and overall expenses. Which is not the definition of “Cash Flow”, I know, I’m an amateur accountant 🙂
It will be a short one, promised. We won’t see expense tracking in full detail today.
I recommend you to take a look at the previous episodes before reading this one.

Enjoy!

Read more

How I track my finances using spreadsheets Part 3: Net Worth

Hi dear RIP readers,

this is Part 3 of my Spreadsheets series, and by far the longest so far. In this post I’ll deep dive into how I track my Net Worth. I hope you like it 😉

Some of the terms used here have been defined in the previous episodes. Please, read all of them before this one.

Read more

How I track my finances using spreadsheets Part 2: Structure

Hi dear RIP readers,

this is Part 2 of my series on my spreadsheets. In this post I’ll explain the structure of my spreadsheets, with a peak preview of the main 2020 Net Worth (NW) Sheet.

Next episode will be the longest, all devoted to how I track our NW.

Stay tuned 🙂

Enjoy!

Read more

How I track my finances using spreadsheets Part 1: Why and What

Hi dear RIP readers,

Today’s post has been sitting in my “Blog Post Ideas” list for a year now. I wanted to deep dive into my 2020 Net Worth Spreadsheet (and more) to help you following me in my journey, and (more importantly) to give you some hints in how to track your own financials.

Ideally, I wanted to write that post in a timely manner at the end of 2019, or in early January 2020.

Well, I didn’t. I procrastinated for months and months, giving precedence to other posts. Do not worry, the list of ideas is never ending. I don’t risk draining my creativity. I’ve ideas ‘stashed for the next 10 years at least.

Read more

My Net Worth

Today I’m going to take another small break before the “season finale” of my financial and professional story and I’ll introduce my Net Worth spreadsheet. […]

Read more