What’s on this page?

Share This Story!
Free Google Sheets template

Free Net Worth Tracker Google Sheets Template

Rebel Finance School Week 2 net worth tracker image asking “Are we going in the right direction?”
Use the tracker to see what you own, what you owe, and whether your money is moving in the right direction.

If you want to take control of your money, start by working out where you are today.

Your net worth is one of the most useful numbers in personal finance. It shows what you own, what you owe, and whether your financial life is moving in the right direction.

We’ve updated the Rebel Finance School net worth tracker for 2026. It now lives in Google Sheets, so you can make your own copy, fill in your numbers, and track your progress over time.

Current version - 2026-06-08

Quick couple of notes: 1. You’ll need a Google account and you’ll need to be signed in. The button should ask you to make your own copy of the sheet, so your numbers stay in your own Google Drive.
2. Keep it in Google Sheets, if you try and download to Excel the formulae won't work

What is a net worth tracker?

A net worth tracker is a simple way to measure your financial starting point.

You add up what you own, subtract what you owe, and track the number over time.

That’s it. No magic. No finance degree. No secret squirrel nonsense.

Your net worth is not your worth as a human being. It is just a number. A useful number. A number that helps you see whether your financial life is moving in the direction you want.

Why track your net worth?

Because what gets measured gets improved.

When you track your net worth, you stop guessing. You can see whether your debts are going down, your savings are growing, your investments are building, and your money is starting to work for you.

Even if the number is not where you want it to be yet, knowing the truth is powerful. The truth gives you a starting point. And once you have a starting point, you can build.

How to use the free Google Sheets net worth tracker

  1. Click the button above to make your own copy of the tracker.
  2. Save it in your Google Drive.
  3. Add your cash, savings, investments, pensions, property, debts, and anything else that matters to your money picture.
  4. Update it each month, or whenever you do your money check-in.
  5. Watch the trend over time.

The month-to-month number will wiggle. That is normal. Investments move. House prices move. Life happens.

The real power is not one perfect number on one perfect day. The real power is seeing the direction of travel.

If the button above does not work

Sometimes Google Sheets has a wobble and the automatic copy link does not behave itself. Spreadsheet gremlins. Very rude.

If that happens, use the backup link below. It opens the original sheet instead.

Open the backup Google Sheet link

Then click: File → Make a copy.

You’ll need to be signed into a Google account before you can make your own copy.

Video guide coming soon

We are planning a new 2026 walkthrough video to show you exactly how to use the updated Google Sheets net worth tracker.

For now, click the button at the top of the page, make your own copy of the tracker, and start filling in your numbers. Do not wait for the perfect moment. Open the sheet. Add what you know. Improve it as you go.

Feedback, Bug Reporting and Feature Requests

No matter how hard the Ninjas and Katie work on the spreadsheets sometimes bugs creep in!  We need your help spotting them. 

If you find something that doesn’t work.  If you think, oh man, I wish there was this feature… If you have feedback on how we can improve it use this form to tell us.  Your feedback helps us to make the course, tools and everything better for all of us!  Thank you. 

Hang on a minute! What’s this net-worth thingymejig?

If you want a full explanation of what net worth is, why it matters, and how to calculate it, read our full guide to net worth here.

Looking for the old 2025 Excel version?

We have kept the old 2025 Excel net worth tracker available for anyone who wants it.

Important: we are no longer updating the Excel version. The newest version of the tracker is now the 2026 Google Sheets version at the top of this page.

We moved to Google Sheets because we want the tracker to work for as many people as possible. Google Sheets works across more devices, browsers, and operating systems, including Chrome, Macs, Apple devices, Windows computers, tablets, and phones.

Excel is brilliant and powerful, but not everyone has the desktop version, and different devices can behave differently. That made it harder for everyone to use the same tracker in the same way.

If you are starting fresh, we recommend using the new Google Sheets version at the top of this page.

If you already use the 2025 Excel version and it works for you, you are very welcome to keep using it. Just know that we are not updating this version going forward.

If you do not have Excel installed on your computer, you may be able to open and edit the spreadsheet using Microsoft 365 for the web. Microsoft says you can use Excel for the web for free in a browser with a Microsoft account, and files are saved in OneDrive.

Download the archived 2025 Excel version below.

Video guide for the 2025 Excel version

The video guide below was created for the older 2025 Excel version of the net worth tracker.

We are keeping it here because it may still be useful if you are using the archived Excel spreadsheet, or if you want to understand the thinking behind the tracker.

Important: the 2026 version of the tracker now lives in Google Sheets, so some tabs, buttons, categories, formulas, or instructions may look different from what you see in this video.

If you are starting fresh, we recommend using the new Google Sheets version at the top of this page. If you are using the old Excel version, this video guide is for you.

What next?!

Download the template above and start adding in your numbers each month! What gets measured gets improved BABY!

We want to you to be able to take control of your financial destiny and create a bright future for yourself and your family.

The first step is to calculate and track your net-worth each month.

Get to work!

Love Alan and Katie​

PS we hope you have as much fun as we do working this stuff out

​This is us at one of our month end finance meetings. We do it every single month with a fabulous breakfast and nice coffee! We have been tracking for ten years now!

The Donegans out for breakfast and their monthly finance meeting

A quick note before you dive in

We built this free net worth tracker to help you get started. It is a teaching tool, not personal financial advice.

You are responsible for checking your own numbers, updating the categories so they fit your life, and making sure the formulas work for your situation.

Use the tracker as a starting point. Make it yours. Improve it over time. The goal is not spreadsheet perfection. The goal is clarity. Read the full disclaimer here

86 Comments

  1. Stef February 6, 2025 at 2:14 pm - Reply

    Hi Alan & Katie,
    I’m not sure how to fill the section State Pension.
    I logged into my Personal tax account from the UK gov. My forecast is £x a week, £x a month, £x a year, assuming that I’ll contribute another 26 years. What number shall I put in my net-worth tracker? What if I stop contributing because I stop working or moving abroad, does that number still count? How do we best estimate?
    Also, it tells me I need to contribute for at least 10 years to be eligible for a state pension. Do you recommend making voluntary contributions until I reach 10 years (currently on 9 years NI contributions). Any insight on this?

    Another question is about my NHS pension. I’m currently on a 12-months career break. I keep contributing as my NHS employer is overmatching my contributions, but only up to 6 months since my career break started. Can I get your opinion on whether I should continue contributing after the first 6 months even after my employer stops? Or shall I rather invest in a global all-cap index fund?

    Thanks for all your great work!!!

    • Lisa May 28, 2025 at 5:45 pm - Reply

      I’d like to know the answer to the state pension part too.

    • Dominic (ninja) June 10, 2025 at 2:25 pm - Reply

      Hi Stef, and Lisa – for the state pension, you can take the annual amount and multiply it by 25 to give its approximate value as an asset.

  2. Paola March 23, 2025 at 2:02 pm - Reply

    Hi Donegans, thank you so much for your course, it is helping me a lot!!! I was wondering if Crypto currencies can be considered Assets. Can you please advise? Thanks!

    • Alan Donegan March 26, 2025 at 2:02 pm - Reply

      Hey Paola, We know they have gone up a huge amount recently. For us we don’t consider them an asset as they don’t produce an income, people buying them are hoping for a gain in the future in price so they can sell them to someone else for more. We think this is super risky.

      Many people own a bit in their portfolio but we don’t own any and actively avoid it for many reasons. Do you have a large % of your money in Crypto?

      Alan

  3. Lynn March 30, 2025 at 11:53 am - Reply

    You guys are awesome :) Thanks x

  4. louise forbes April 3, 2025 at 4:26 pm - Reply

    Thanks Donegans from a grateful Lou F

    • Alan Donegan April 15, 2025 at 4:39 pm - Reply

      Lou! it is our pleasure. Thank you so much for commenting. We had fun pulling this together and will be updating for this year!

  5. Abi P May 27, 2025 at 5:28 pm - Reply

    This is great! You are great!! Thank you Both!!!

  6. Becky June 9, 2025 at 10:22 pm - Reply

    I currently have premium bonds and a fixed rate savings account. These provide me with some monthly income in addition to my employed salary. If I were to move the premium bonds and savings to investments/freedom fund (whilst retaining an emergency savings fund), can I get any income from them immediately?

    • Alan Donegan June 10, 2025 at 3:17 pm - Reply

      hey Becky, Couple of thoughts:

      1. the income you get from the two accounts you mentioned is VERY low. You can put your money to better use elsewhere
      2. if you put it in an index fund and invested in a tax efficient way then you could live off 4% of those investments straight away and they would probably grow as well. Index funds produce 10-12% a year return on average over the long term
      3. If you don’t take the income then it will compound and grow for you. Are you in retirement? do you need the income?

      Does that help?

      Alan

  7. Ama June 9, 2025 at 11:15 pm - Reply

    Thanks so much for the course; am really loving it, starting from zero clue about finances, moving forwards to transform my life step by step : – ) Sorry for the likely stupid question, I am not sure what to put in the pension box in the tracker. I am in the NHS pension scheme, am 49, been contributing since my early 20s . I would also be eligible for a UK state pension. What is the figure that I enter in the pension box and how do I find it out please? Thanks so much : – )

    • Alan Donegan June 10, 2025 at 2:56 pm - Reply

      Ama, Dom got it spot on. 25 X the yearly amount you get in retirement. YAY. For the state e pension we will come onto that in later weeks and how to account for that. it is income in retirement rather than a value! Does that help? So glad you asked! Alan

  8. Nadia June 10, 2025 at 6:26 am - Reply

    Morning! Thanks for the Wk 2 lesson last night. We have an investment property. We pay the interest only so it currently does give us extra cash from the rental. We save half of these for future / unexpected costs for the house and half we invest. Does this still count as an asset since we aren’t paying down the mortgage? The plan is to sell it in the future when it hopefully will have gone up in value. It hasn’t cost us anything as we kept our inheritance in it and bought out my brother / sister’s share.

    • Alan Donegan June 10, 2025 at 2:55 pm - Reply

      Nadia, you are awesome.

      You have inspired us and the ninjas and I are writing an article entitles “Is your investment property an asset?”

      The type of debt on an investment property doesn’t really affect whether it is an asset or not. The key question is what is the Return On Equity. Have you found the return on equity calculator. You can download it from here: https://rebeldonegans.com/finance/investing/property-calc/

      The cost for you is the opportunity cost. if you put it in an index fund you could get a 10-12% a year return. The critical piece is the opportunity cost as your money should be working as hard as it can for you!

      Does this help? Alan

      • Liz June 11, 2025 at 7:56 am - Reply

        I hope it has helped Nadia too…it has definitely helped me! Lightbulb moment: 💡
        I am selling my big house (family home) in favour of a small house (adult kids will have to sleep on sofa beds when they visit 😜) and I have been considering renting out the big house if I can’t sell it but this makes it super clear: if I can’t get 10-12% pa net in rent from it, it is better to sell it and invest the money. Even if I don’t get the best price I thought I could from it. Still better to sell.

        As always, Thank you to both you fabulous Donegans, for the clarity !

        (I love the bullet point notes in the Week 2 email btw…brilliant 🤩)

        • Alan Donegan June 11, 2025 at 1:15 pm - Reply

          So glad you enjoyed the notes. We worked so hard on creating that this week and developing the resources to go with the course! YAY. And you might just get to buy a whole lot of freedom with that house move. Excited to hear how it goes! Keep us up to date!

      • Ailsa McKnight June 16, 2025 at 11:36 pm - Reply

        Thanks for this. I am currently deciding whether to re-mortgage one of my rental properties or to sell and place the equity that’s released into another investment vehicle (eg index fund) so your property calculator will help with the process of deciding what to do.

        • Alan Donegan June 17, 2025 at 4:40 pm - Reply

          Love it. Download the spreadsheet and see what you return on equity is. This is the key number that will help you make the decision. We will be looking at this in week 6 of the course specifically! ALan

  9. Rachel June 10, 2025 at 4:13 pm - Reply

    Hi – loving the course- thanks. We live in Hong Kong and we own two investment properties in the UK, mortgage paid off several years ago on both. Do we write the income from these properties in the Freedom fund section of the Net Worth Calculator?

    • Alan Donegan June 10, 2025 at 4:52 pm - Reply

      hey Rachel, great question. On the net-worth tracker we would put the equity which as you have paid off the mortgages is the total value of the property. The key number for you to work out in addition to this is the Return on Equity which you can download a spreadsheet here to do that. Work out the ROE on each property individually in readiness for the investing weeks! Nice work! https://rebeldonegans.com/finance/investing/property-calc/ Thanks for commenting! let us know how you get on! Alan and Katie

  10. Pete June 10, 2025 at 8:34 pm - Reply

    Hi Katie & Alan, I’m just a bit confused. I don’t understand why I enter the annual value of my defined benefits pension (before tax) and then multiply it by 25 (yet) If you could explain this that would be great. Many thanks :-)

    • Alan Donegan June 10, 2025 at 9:55 pm - Reply

      of course Pete. This is a simple little formula that gives you and idea of what you would have to have invested to get the same annual income as your DB pension. If your DB pension gives you £10k a year then you would need an equivalent pot of £250,000 to get the same income as that. It is based on the 4% rule that we will cover in the later weeks of the course. Does this give you enough to get going? Alan

      • Zoe June 11, 2025 at 7:32 pm - Reply

        This is helpful! Thank you. Part of my teachers pension includes an annual amount, but also a lump sum. Would I add the lump sum to the (annual amount x 25). And also, I have based the annual amount on the amount it will be if I retire early… as that is what I hope to do. Is that the right approach? Thanks so much!

        • Alan Donegan June 13, 2025 at 3:26 pm - Reply

          Zoe, love the question.

          Lump Sum amount is just that. No multiplying for that one as that is what you will get!
          And for the Annual amount yes use the number for early retirement if that is what you are planning to do other wise you will have inflated figures and might not have enough in retirement! Alan

      • Ailsa McKnight June 16, 2025 at 11:20 pm - Reply

        Thank you – I was wondering why we use x25 too.

  11. Craig Jones June 12, 2025 at 3:56 pm - Reply

    Hi Katie & Alan, really enjoying the course! a couple of questions regarding the tracker.

    1) Do you factor in state pension as part of your ‘freedom fund’ (if you’ve already paid the required NI contributions)
    2) Unsure why S&S savings are classed as freedom fund but houses (owned outright) are not? I believe typically house prices rise by around 6-8% over any 10 year period, so would appear to be not far behind the S&S expectations.

    Thanks!

    • Alan Donegan June 13, 2025 at 2:45 pm - Reply

      Hey Craig, Thanks for the lovely question. So glad you are enjoying the course. YAY

      1. great thought on state pension. We haven’t included it in ours as net-worth but think of it as future cashflow. We didn’t want people to have huge freedom funds and not save outside this. So we don’t add it to our tracker but it is in our future cashlow template that we will share later in the course.
      2. Is this a home you live in or a rental property?

      On the growth when you look at real growth over that period based on the longest study we have the Nationwide study this is what you are looking at: The real compound annual growth rate (CAGR) of UK house prices from 1952 to 2024, after adjusting for inflation, is approximately 1.91% per year.

      If you have a rental property it is bringing you money (unless negatively geared) and there for an asset and goes in the freedom fund.
      if it is the home you live int then it is taking money away from you and not growing significantly (despite the back of the envelope maths everyone likes to do) and it doesn’t provide for you in retirement. It will not bring money in for you in retirement so goes under valuable liabilities.

      Does that make any kind of sense. I am so glad you comments Craig. Alan

  12. Craig Jones June 12, 2025 at 3:57 pm - Reply

    Sorry, should have said 6-8% PER YEAR over a 10 year period… !

  13. Paul June 13, 2025 at 12:28 pm - Reply

    Fabulous work you guys! I’m already retired but still finding the course super useful (and I did it last year too). I have an annuity that I bought when I retired and last year you suggested I put that annual figure x 25 into my Freedom Fund assets. I also draw the state pension and a small work pension. It seems to me that I should handle these in the same way as the annuity so x 25. Is that right? If I do it makes my number look much more healthy!
    Thanks again for all your work :-)

    • Alan Donegan June 13, 2025 at 2:18 pm - Reply

      Hey Paul, if you are in retirement then we would look at those as cash flow but you are right the idea of the value is the same. Is the small pension a DB pension (defined Benefit)? So glad you are enjoying the course. We have had so much fun improving it and making better this year! You rock! Alan

      • Paul June 13, 2025 at 3:36 pm - Reply

        Thanks for the quick response Alan. The small co pension is effectively a DB pension now in that it will stay the same for life, but it wasn’t when I was paying in. I’ve had some trouble getting my head around this in the Freedom Fund because while the state pension is (hopefully) index linked the annuity and other pension aren’t. That means some of my pot will have growth but other parts won’t so presumably that screws up the 4% calc because of the inflation part of the equation. That said, at my age I believe I can draw down >4% anyway. Looking forward to your draw down module later in the course! Best, Paul

  14. Michelle June 13, 2025 at 3:07 pm - Reply

    hello rebels, i have a 2015 NHS pension. I can take in full from 67 but reduced from 60. If I want to retire at 60 should I put the reduced figures in? I get the annual amount I should x 25 but what should I do with the lump sum figure? Just put it in as is? Thank you :)

    • Alan Donegan June 16, 2025 at 12:39 am - Reply

      Hey Michelle, yes use the reduced figure as that is what you will actually take at that point. So the annual amount is 25x and then you can just put the lump sum in as it is as that is exactly what you will get! Does that help? Alan

      • Michelle June 22, 2025 at 8:59 am - Reply

        Thank you! :)

  15. Gemma June 15, 2025 at 9:32 pm - Reply

    Hi Katie and Allen,
    Loving the course-its really opening my eyes properly to our finances.
    Just catching up ready for tomorrow night and filling in the networth calculator.
    My husband and I are paying into our NHS pensions -do we just put the current value in the spread sheet rather than doing the x25 thing.
    Thank you

    • Alan Donegan June 15, 2025 at 11:42 pm - Reply

      Hey Gemma, YAY, So glad you are enjoying the course. We have had so much fun writing it. On the pension thing I assume as it is NHS it is a defined benefit DB pension? If so then do the 25x thing! Alan

  16. Jen June 15, 2025 at 9:43 pm - Reply

    Hi, a little confused on how to log my pensions. I’m in receipt of 3 pensions now which total £26k pa.
    Do I just put the 26k gross in the June column
    or 26k – 20% tax (£20,800)
    or do I divide by 12 to put the monthly gross figure in (26k/12 £2,166) or the monthly net figure (26k/12+20% £1,732)
    or do I use one of the figures above and x by 25 (£520,000 or £54,150 or £43,300)?

    Next pension question –
    I have another DB pension which ive chosen not to receive yet (Im 60 and hit NRD for this pension).
    My last benefit statement gives me a lump sum of £91,117 and an annual pension of £20,378.
    How do I show this on the tracker?
    Do I put the lump sum in the ‘cash and planned spending’ pot?
    The £20,378 is as the 1st pension question.

    Thankyou!
    Jen

    • Alan Donegan June 16, 2025 at 12:35 am - Reply

      Hey Jenn,

      The pensions you are currently in receipt of in the Net-worth tracker go in as 25x their value if they are DB Defined Benefit pensions. Is this what they are?

      For the pension you haven’t taken yet then as it is a DB pension you would put the lump sum as it is (£91,117) and then 25x the annual benefit for the rest.

      Does that help? Alan

  17. Karyn June 24, 2025 at 9:17 am - Reply

    First, thank you SO much for all your work on this course – we need it, and it is really well done; totally enjoying learning with you guys! Second, I love your t-shirts and your obvious love for Star Wars, Marvel, and Disney. Third, I downloaded this tracker and am using it with Google Sheets (I assume this is where the problem stems), but I get a blank sheet when I look at the Networth split tab. Do you have any ideas?

  18. Vicki June 26, 2025 at 9:29 am - Reply

    Hi both, thanks so much for this course, finding it super useful as someone who has money anxiety. I have two DB pensions and an AVC pot. The DB from my previous employer is straightforward, 25x the annual amount at the age I plan to take it. For the one I am still paying into do I just assume I stay in this scheme until my chosen retirement age and multiply the DB for that by 25 even though I might not stay in this job? And for the AVC pot does this just go in as its current value?

  19. Craig July 10, 2025 at 12:01 am - Reply

    Hi Guys, I’ve just transferred all my figures from Jan 2025 from the old Net worth Tracker to the new one, and at first it looked ok, then I realised that I have “#NAME?” in all the boxes for the “Total of things you own”, “Total Net Worth”, and “Change from last year” columns? What’s went wrong? I watched the video and followed Katie’s instructions, but obviously I have done something not quite right! Any Ideas???

  20. Paolo July 27, 2025 at 10:58 am - Reply

    Hi Donegans (and Ninja’s), I’ve been doing this years course and loving it. You’ve mentioned near the bottom of the article that:

    “We have a Numbers version and a Google sheets version coming soon!”

    I don’t suppose that “coming soon” date is coming anytime soon? I’ve got most of our budgetting numbers on Google Sheets and would love to include the new and improved Net Work Tracker too?

  21. Caz September 7, 2025 at 10:24 pm - Reply

    Just wanted to say a big thank you for pulling these resources together. I am currently working my way through the You Tube video’s – on week 2 and have learnt so much useful information already. I have a DB pension and you have totally helped to “clear the fog” about how to calculate this for net worth. Absolutely LOVED the clarity about the different categories and what is classed as an asset. Never felt this excited about getting to grips with my finances and am very much looking forward to working my way through the rest of the course.

    • Alan Donegan September 11, 2025 at 11:26 pm - Reply

      Caz, that is AMAZING> I love it. And the classification of assets, future spending and valuable liabilities took us so long to realise and figure out for our own lives. I am so glad you commented! THANK YOU. And let us know how you get on with the rest of the course! Stay in touch. Alan

  22. Aleks September 24, 2025 at 7:42 pm - Reply

    Hi Both, thank you very much for this course. I’m making very slow progress, but finding it so helpful!
    But to the question – I’m in a Local Government Pension Scheme and really not sure what my pension value actually is, I just don’t understand the statement. For some reason, my brain just can’t process it. So, I have things like:
    Summary of total benefits at 31 March 2025 – Annual pension – is that what I use? And if so, do I x25?
    And then there’s Career Average Revalued Earnings (CARE) pension benefits as at 31 March 2025 (payable from 10/07/2051) with subheading of: CARE pensionable pay for year ending 31 March 2025 in Main Section. I don’t really know how that relates to anything and whether I’m supposed to put that number in the tracker as well?
    I also have a deferred pension where there is CARE section and Lump Sum. I read one of your previous answers and now know that lump sum is just that, but do I do CARE section x 25?
    Sorry for the lengthy message. I am really determined, regardless of my ignorant brain!
    Thank you again!!

  23. Aleks September 24, 2025 at 7:44 pm - Reply

    Hi Both, thank you very much for this course. I’m making very slow progress, but finding it so helpful!
    But to the question – I’m in a Local Government Pension Scheme and really not sure what my pension value actually is, I just don’t understand the statement. For some reason, my brain just can’t process it. So, I have things like:
    Summary of total benefits at 31 March 2025 – Annual pension – is that what I use? And if so, do I x25?
    And then there’s Career Average Revalued Earnings (CARE) pension benefits as at 31 March 2025 (payable from 10/07/2051) with subheading of: CARE pensionable pay for year ending 31 March 2025 in Main Section. I don’t really know how that relates to anything and whether I’m supposed to put that number in the tracker as well?
    I also have a deferred pension where there is CARE section and Lump Sum. I read one of your previous answers and now know that lump sum is just that, but do I do CARE section x 25?
    Sorry for the lengthy message. I am really determined, regardless of my ignorant brain!
    Thank you again!!

  24. Louise Harris October 10, 2025 at 8:00 am - Reply

    Hi Katie & Alan, I have just started your fantastic course. Please can you advise me when I can access the weekly course notes. Thank you for educating everyone – you are doing brilliant work.
    Many thanks

  25. Sandra October 27, 2025 at 3:14 pm - Reply

    Hi Katie and Alan

    I have also just started the course but having trouble with the spreadsheet for Net Worth. It seems to come up with loads of cells with #NAME? in. I am using open office and have tried copying it to Excel online, but with no luck. HELP! TIA Sandra

  26. Jo December 27, 2025 at 6:44 pm - Reply

    Hi, really enjoying getting stuck into the course. QQ On the Net Worth Calculator -Mortgage on home you own and live in – that would be how much I have left to pay on it I assume? and Equity in investment property (IF it’s a valuable liability) – would that be the amount of equity on my mortage? Reason, I ask is my net worth seems quite high so wanted to check the above. Thanks so much and hope youd had a great xmas :)

    • Alan Donegan December 30, 2025 at 4:50 pm - Reply

      hey Jo, so glad you are enjoying the course.

      1. Yes the mortgage is the amount left to pay. Just have a look on your latest statement to see how much is left
      2. Equity equals value of the home minus what is left to pay on the mortgage. if your home is worth £300,000 and you have £100,000 left on the mortgage then you have equity of £200,000 which is the valuable liability you own….

      Does that make sense?

      Sending happiness Alan

  27. Cathryn December 29, 2025 at 4:04 pm - Reply

    My Nhs pension is now frozen and I can’t access it until Im 60 ( 3yrs time). Am I correct in that the annual pension gets multiplied by 25 and entered into the freedom fund and the lump sum component is also entered into the freedom fund under a separate row or just added on to the other figure? Or does it matter? One I will get once at 60 years old and the other I will receive monthly and will go up annually by CPI.

    • Alan Donegan December 30, 2025 at 4:52 pm - Reply

      Hey Cathryn, If it was me I would add 25x the annual amount I am going to get with the pension on one line and then second line for the lump sum which is a one of payment. Does that help? Do you have a plan for the lump sum? will you invest some of it? Live off it? Sending happiness. Alan

  28. Kristy January 7, 2026 at 6:44 pm - Reply

    Hello Alan and Katie, quick question on whether my home is an asset or a valuable liability. If i have a lodger should the income i get from that be put somewhere on the Freedom Fund spreadsheet as my home is making me money; or does this just go into the income tracking spreadsheet?

    • Alan Donegan January 8, 2026 at 7:07 pm - Reply

      Hey Kristy, love this question. in a way you have turned it into less of a liability as it is bringing you cash! probably not covering the total cost of the house? Although I have made that up you can tell me. If it was me I would still keep it in the VL column on the net worth spreadsheet and then track the income from the lodger as part of my gap. It basically gives you a bigger gap to be able to invest! this is awesome. Alan

  29. Sofie January 21, 2026 at 3:46 pm - Reply

    Hello, loving the course so far! How does it work with a LGPS pension and what to put under the assets? The current transfer value? Thank you!

    • Alan Donegan February 2, 2026 at 2:54 am - Reply

      Local Gov pensions normally are defined benefit? Do they give you a figure for your annual income you will receive in retirement in your portal? if so we would add 25x the figure you will get if you retire now at pensionable age. Does that make sense? Alan

  30. Jackie January 22, 2026 at 3:27 pm - Reply

    Hi Alan and Katie… have just watched week 2 of the course and am filling out the net worth calculator. If a credit card is paid off in full each month, does that still count as debt?

    • Alan Donegan February 1, 2026 at 8:58 pm - Reply

      hey Jackie, we don’t add ours in as they are paid of in full on direct debit. We just leave them to be paid off! Alan

  31. Hannh January 25, 2026 at 11:14 am - Reply

    Thank you so much for all this helpful advice, really appreciated. I note in the ‘cash and planned spending’ section you have separate sections for different funds (e.g. car fund, holiday fund etc). Would you suggest having these as separate accounts which you budget for and transfer into a certain amount each month? i.e. We have a £3k holiday budget this year so we are going to put £250 into the holiday bank account each month? Hopefully not covered before (and hopefully not too basic!). Cheers! Hannah

    • Alan Donegan February 1, 2026 at 8:56 pm - Reply

      Hannah, that is a FABULOUS way to do it and 100% it is a great way to budget. You know you want to buy a car on x years, save for it so much a month into a separate account with intertest and be ready for the purchase. Exactly. Thanks for writing. Alan

  32. Stacey February 23, 2026 at 6:27 pm - Reply

    Wow! We loved the course, just wish I had come across it sooner.
    I’m wanting to use the spread sheet off-line on an iPad which the MS 365 free account does not cover.
    Is the Apple Numbers or Google Sheets version available yet?

    • Alan Donegan February 24, 2026 at 8:16 pm - Reply

      Stacey, we haven’t got those versions sorted yet. Sorry. Options are download the office version and export as google sheets version or apple numbers version (the formulas might go a bit weird but you can probably fix them easily with AI!) Or if you are good with spreadsheet? Just whip up your own version. How are your spreadsheet skills? Alan

      • Stacey March 13, 2026 at 10:20 am - Reply

        Thanks Alan. I didn’t want to start spending time creating a Numbers or Google version if one was already nearly completed as my Spread sheet skills are a little rusty; but that is something I am considering. That and I was on a small iPad screen and find I have to scroll an awful lot, and some buttons seem to not always work. For the time being I’ve gotten myself a discounted MS 365 plan and using excel.
        I’m new to using AI, tis awesome.

        • Alan Donegan March 14, 2026 at 12:21 pm - Reply

          Hey Stacey, yes Ai is amazing what it can teach you to do and how it builds things and developed and codes for you. We have been so impressed. Cool you got a discounted version. Love that. Let us know how you get on. Alan

  33. Laura April 14, 2026 at 5:27 pm - Reply

    Hi all,
    I have just started the course and am a little stuck on the valuable liabilities in the gap calculator spreadsheet. The tracker only has a section for the first part of calculating net value, ie pensions, SSISA and so on, but nowhere where to add information for valuable liabilities, for example property value etc. Is it in a different spreadsheet or has it been updated and included anymore?

    • Alan Donegan April 14, 2026 at 9:43 pm - Reply

      Hey Laura, I just downloaded the file to make sure I wasn’t going crazy and I can see it just below freedom fund. You should be able to scroll down and see a section called Valuable Liabilities in Orange with a section for property in there. For your main home. Can you see if you can scroll down and see it? Let me know if not and we can email you a versoin or work out how to do it together. it is there when I checked just now though…. Alan

  34. Vic June 9, 2026 at 2:32 pm - Reply

    Hello, I have a DB pension which I dont know a lot about but it is apparently is an average salary scheme.
    Do I add this into the calculator and if so how does this work please?

    • Alan Donegan June 15, 2026 at 11:21 pm - Reply

      Hey Vic, We would take the amount you will get if you retired now (annual figure) and multiply by 25x. This gives you a rough estimate of its value right now… Alan

  35. Justin Ryan June 12, 2026 at 7:40 am - Reply

    Hi
    Great course and learning a lot and already plugging gaps and changing attitude to spending – and we are already retired! (DB pensions!).
    I have saved the google spreadsheet and entered the figures on the appropriate tab but it isn’t calculating anything- do I need to do something to make it do that or have I just done something wrong?

    • Alan Donegan June 13, 2026 at 4:21 pm - Reply

      Hey Justin, did you put a date in at the top. sometimes that stops it working… Alan

  36. Wasima June 14, 2026 at 10:25 pm - Reply

    Hi
    With regards to an NHS pension – I have money in the 1995 section and the 2015 section. How do I put this into the google sheet?

    • Alan Donegan June 15, 2026 at 10:11 pm - Reply

      Hey Wasima, as a rough estimate you take the amount you would get yearly from each section and multiply by 25 to give you a rough value for the tracker. Sending happiness.. Alan

  37. Sara June 16, 2026 at 7:36 pm - Reply

    So amazing, thank you!

  38. Kelly NZ July 23, 2026 at 10:56 am - Reply

    I love this tool, and am loving your videos so far. It is as though the clouds of financially haze are lifting. Thank you!

    • Alan Donegan July 28, 2026 at 12:36 am - Reply

      YES KELLY! love it. Where in NZ are you? We will be in Auckland for a party and the last few weeks of the course soon and then south island november! ALan

  39. Gill August 25, 2026 at 9:05 pm - Reply

    Hi both, really enjoying the course. I am confused about what to put in the pension part fo the tracker. I currently work at a university and am in the local government pension and I can see my latest valuation per year but I wouldn’t be able to access this until the current retirement age. Is this still the current value per year x25 because I wouln’t actually be able to access it until 67 (and lets face it, probably later as it will increase).

    • Alan Donegan August 26, 2026 at 2:39 am - Reply

      hey Gill, the 25x just gives you a rough value for that part of your pension. later in the course we treat it as income for the Freedom Calculator but at the beginning we add it into the net-worth tracker to show you have built something up here and have value. Otherwise for people who have heavy DB pensions it looks as though their freedom fund is empty when it is not… Does that make sense to you? Alan

Leave A Comment

Join the Donegan mailing list