Basic Investment calculator

Options

Nick9967 Posts: 192 Forumite

23 October 2020 at 1:41PM in Pensions, annuities & retirement planning

Does anyone have a basic Excel investment calculator with variable return rates, charges & inflation they could share with me please.
I'd like to be able to calculate my own without using the one on Which , as that's not variable.
I have one that's a basic value now, interest rate, term, compound periods, withdrawals, etc as below but that's not what I'm after.
I realise my description is less than professional but would be grateful if anyone could help, thanks

Present Value	£ 100,000
Interest Rate	6.0%
Term (Years)	6
Compounding periods per year	12	£ 100	pm
		£ 1,200	pa
Future Value	£ 134,564

★ ★ ★ Meet your Ambassadors

MSE News

Barclaycard's cutting minimum repayments – you could be in debt YEARS longer paying DOUBLE the interest
If you've got debt on a Barclaycard, it's likely the minimum you have to repay each month will be cut from July. If you're unaware, and don't act, you could stay in debt for many years longer and pay possibly £1,000s more in interest.
NatWest, RBS and Ulster Bank to close at least 100 branches in 2024/25 – here's the full list, plus alternatives
NatWest, Royal Bank of Scotland (RBS) and Ulster Bank, which are all part of the NatWest Group, will shut at least 100 of their bank branches in 2024/25, after RBS announced a further 18 closures.
Co-op Bank customer? You could be moved to Coventry Building Society in future – here's what's happening
The building society has today agreed to a potential takeover of the high street bank – though it's still very early days and the deal needs regulatory approval.
Got a text, email or letter from the Met Police? Don't ignore it – you may need to act to protect yourself from scams
If you got a text message or email from the Metropolitan Police between 4pm and 6pm on Wednesday 17 April – or you get a letter in the next few days – don't ignore it.
Save up to £1 on your takeaway coffee – while saving the planet
Many of us regularly reach for a cup of coffee or tea to give us a caffeine boost, but if you’re out and about and can't bring a thermos from home, the cost of this can quickly mount up.
Chase customer? Check if you can get its boosted 5.1% easy-access saver
If you have a Chase current account, you may be able to get a table-topping 5.1% easy-access savings rate to go with it, as the bank has launched a new, temporary bonus offer for some existing customers.
New online state pension boosting tool promised to Martin Lewis hit by delays – here's what you need to know
The tool was first promised to MoneySavingExpert.com founder Martin Lewis on ITV's The Martin Lewis Money Show Live last summer and was expected to launch before the end of the 2023/24 financial year.
Spotify to hike prices by up to £24 a year – here's what's happening
If you've got a Spotify Individual, Duo or Family account you'll see prices rise by up to £2 a month (equivalent to £24 a year) in a month's time, the music streaming service has announced.
Subway customer? You've got until 14 May to use your loyalty scheme points before shake-up – here's what's happening
If you're a Subway Rewards member, you have until the end of Tuesday 14 May to spend any points you've built up – or lose them entirely.

View All

Basic Investment calculator

Categories

Get our FREE Weekly email full of deals & guides - and it’s spam-free