Future Projections

Hi if anyone is ever interested in doing future projections you can of course use compound interest uk calculator.

I really wanted to try nail it on a calculator then once I learned finally it took my simple maths brain a while to do it I then moved the calculator version onto my spreadsheet. Now I can project whatever money I put per month, what age I will be when I hit the target etc pretty fun.

Here it is if anyone’s interested:-



3 Likes

I’ve used the same calculator to run figures.

Interesting and motivating.

1 Like

I was in the politics forms where 3 of us kept battling with it as they kept giving me the simple formula of x amount what will it be in 10 years.

We had a teacher I think someone else who was good at maths we all chipped in we did have an accounted but he bailed haha, then a new section called maths got named for topics like I had asked so we could sit and pickle eaxh others brains haha.

I kept saying no but I have started with x amount but want to make contributions monthly to it with monthly interest.

Of course with the stock market is actully hard to to this with because the rates you get change daily etc but it’s just taking a rough guide of what you could get.

I like to set it low like 3% returns per year this way I know I should hit my target even with low returns.

The 0.0041 number is whatever interest you pick 5% divided by 12 then divided by 100 then you can plug in the numbers.

The power to 60 is 5 years. 12 months x 5

I think the rest is standard. It was fun to learn anyways :slight_smile: maybe a pain to type on a calculator but once embedded into a spreadsheet wowieee

1 Like

Its good to run numbers to help set targets and expectations .

1 Like

I have projections for both my SIPP & my girls JISA’s to project out. I’m slightly above my projections on my SIPP but I’m stuck in a “how much is enough” swamp. I’ve read everything but it still always makes me think … but maybe some more would be helpful. Can’t have jam today and jam tomorrow - it’s a tricky balance to strike.

4 Likes