What’s on this page?
Free Net Worth Tracker Google Sheets Template
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
- Click the button above to make your own copy of the tracker.
- Save it in your Google Drive.
- Add your cash, savings, investments, pensions, property, debts, and anything else that matters to your money picture.
- Update it each month, or whenever you do your money check-in.
- 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.
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!

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


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!!!
I’d like to know the answer to the state pension part too.
Hey Stef, what is the question? Alan
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.
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!
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
You guys are awesome :) Thanks x
Thanks Lynn! love you too! Sending happiness.
Thanks Donegans from a grateful Lou F
Lou! it is our pleasure. Thank you so much for commenting. We had fun pulling this together and will be updating for this year!
This is great! You are great!! Thank you Both!!!
Thanks Abi, it makes life easier! Alan
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?
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
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 : – )
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
Thanks so much – super helpful!
YAY
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.
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
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 🤩)
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!
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.
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
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?
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
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 :-)
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
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!
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
Thank you – I was wondering why we use x25 too.
it comes from something called the 4% rule which I wrote about here and we will cover later on in the course this year: https://rebeldonegans.com/finance/fire/how-much-does-it-take-to-retire/ It is a simple and quick way to value a DB pension to get an estimate of its size. Alan
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!
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
Sorry, should have said 6-8% PER YEAR over a 10 year period… !
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 :-)
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
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
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 :)
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
Thank you! :)
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
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
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
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
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?
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?
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???
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?
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.
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
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!!
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!!
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
Louise, of course: https://rebeldonegans.com/finance/rfs/course-notes/ Nice work starting the course and please let us know how you are getting on! Alan
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
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 :)
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
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.
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
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?
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
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!
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
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?
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
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
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
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?
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
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.
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
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?
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
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?
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
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?
Hey Justin, did you put a date in at the top. sometimes that stops it working… Alan
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?
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
So amazing, thank you!
YAY! our pleasure Sara! Alan
I love this tool, and am loving your videos so far. It is as though the clouds of financially haze are lifting. Thank you!
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
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).
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