We'd like to remind Forumites to please avoid political debate on the Forum... Read More » This is to keep it a safe and useful space for MoneySaving discussions. Threads that are - or become - political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Excel calc for working our interest on a regular saver account.

smiffy · 2009-10-04 11:43:06

Hi, Can someone help me create a spread sheet that will work out the interest on my kids savings accounts. The rate for the 1st year is 5% AER. Each month we invest £300. At the end of the year we can then remove the £3600 +plus the interest. I'm trying to work out the interest each month. thanks

Options

Comments

oldwiring Posts: 2,452 Forumite

6 October 2009 at 9:03PM

rb10 wrote: »

No. All the interest is paid at the end of the year. This is why the calculation of [monthly payment]*[interest rate]*6.5 works, where the monthly payment is the same each month.

Average balance :(2n+1)/2, where n= no of instalments, eh?:D

0

This discussion has been closed.

★ ★ ★ Meet your Ambassadors

Confirm your email address to Create Threads and Reply

MSE News

British Airways passenger? Book and travel using your old Covid vouchers NOW – or lose them
If you had a British Airways (BA) flight or holiday disrupted by the Covid-19 pandemic, check if you've got an old voucher as millions of pounds' worth are still unclaimed. You'll need to use it to travel before the end of September 2025 – or risk losing it. Below we explain how to search for unused vouchers and how to use them.

View All

Excel calc for working our interest on a regular saver account.

Comments

Confirm your email address to Create Threads and Reply

🚀 Getting Started

Categories

Is this how you want to be seen?

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