Hi everyone!

I could really use your help on this, so please bear with my explanation! Thank you so much for your time in advance. This may be a bit of a challenge, but I’m really at a loss as to what formulas are needed, what data is needed to make those formulas work – an ABSOLUTE loss!

I’ve attached a mock-up I’ve done that is similar to the real thing. It is one tab of a multi tab spreadsheet that is focused on finances for 2025 – this is the savings tab. During the course of 2025, there are some things that I need to save for, so I’ve added at the top some examples, with the target date, target to save and then I’ve worked out how many months I will have to save that (I’m paid on the 15th of the month and the entries from A17 help with this). It then gives a split out as to how much I would need to save each month if I wanted to achieve the target amount by the target date. Hope you’re still with me!

I then have an entry for each month, how much disposable income I have to save, how much to pay on each savings goal and then how much disposable income I have left after saving for them.

What I want is that each month it allocates the most money to whatever one I want to save for first (by date), then the next date etc. When one of the savings targets is then met by the date, the following month the extra money then goes into the next target savings goal. For example, if you look at savings goal 3) Car Repair, it wants £65.00 a month to achieve by the target date (15/10/25), but I only have £26.38 available each month. However, that is only until say May or July when the other savings goals are paid off, then I can put the extra money (that I’m not paying towards these) into 3) Car Repair, so it ends up still being paid off by the date, just it won’t end up being £65.00 each month, it’ll be a lower figure in the first number of months and then increase when the others are paid off.

I really hope this is somewhat understandable!! I want to be able to alter the target amounts, target dates, available to save money, and have everything auto adjust to try and work out a savings plan – what I need to put into the savings amount each month for that goal to try and get it paid off by the target date. If suddenly something changes, such as I have more disposable income or the savings goal is reduced, then the spreadsheet will all automatically update to those changes and then the plan (plan being the best word here) changes. If a savings plan cannot be achieved, as in there isn’t enough money available that month to cater for all of the “> Savings”, then it flags up and identifies this and tells me that more money is needed. I can then make some changes elsewhere and make sure there is extra available funds (if I need to!)

I really really hope that this is understandable and any advice anyone is able to give is appreciated so so much.

If you have any questions then please do contact me!

Thank you so much again.

​Hi everyone! I could really use your help on this, so please bear with my explanation! Thank you so much for your time in advance. This may be a bit of a challenge, but I’m really at a loss as to what formulas are needed, what data is needed to make those formulas work – an ABSOLUTE loss! I’ve attached a mock-up I’ve done that is similar to the real thing. It is one tab of a multi tab spreadsheet that is focused on finances for 2025 – this is the savings tab. During the course of 2025, there are some things that I need to save for, so I’ve added at the top some examples, with the target date, target to save and then I’ve worked out how many months I will have to save that (I’m paid on the 15th of the month and the entries from A17 help with this). It then gives a split out as to how much I would need to save each month if I wanted to achieve the target amount by the target date. Hope you’re still with me! I then have an entry for each month, how much disposable income I have to save, how much to pay on each savings goal and then how much disposable income I have left after saving for them. What I want is that each month it allocates the most money to whatever one I want to save for first (by date), then the next date etc. When one of the savings targets is then met by the date, the following month the extra money then goes into the next target savings goal. For example, if you look at savings goal 3) Car Repair, it wants £65.00 a month to achieve by the target date (15/10/25), but I only have £26.38 available each month. However, that is only until say May or July when the other savings goals are paid off, then I can put the extra money (that I’m not paying towards these) into 3) Car Repair, so it ends up still being paid off by the date, just it won’t end up being £65.00 each month, it’ll be a lower figure in the first number of months and then increase when the others are paid off. I really hope this is somewhat understandable!! I want to be able to alter the target amounts, target dates, available to save money, and have everything auto adjust to try and work out a savings plan – what I need to put into the savings amount each month for that goal to try and get it paid off by the target date. If suddenly something changes, such as I have more disposable income or the savings goal is reduced, then the spreadsheet will all automatically update to those changes and then the plan (plan being the best word here) changes. If a savings plan cannot be achieved, as in there isn’t enough money available that month to cater for all of the “> Savings”, then it flags up and identifies this and tells me that more money is needed. I can then make some changes elsewhere and make sure there is extra available funds (if I need to!) I really really hope that this is understandable and any advice anyone is able to give is appreciated so so much. If you have any questions then please do contact me! Thank you so much again.   Read More

​