Calculating interest earned... Excel or otherwise.

  Simsy 12:55 14 Jun 07


though I an good with numbers, I don't usually deal with financial things...

I'm trying to either find a calculator on the internet, or use Excel features to work out how much interest would be earned on regular payment.

I can do it in Excel, "longhanded", making a chart that slowly progresses, but I'm sure there must be a formula to do what I want.

The problem is that all the financial stuff in Excell is either US based, or using terminology that I don't really understand...

Can anyone advise on what formula to use, either build in or created, that will work out the following;

Start amount =£w
Make a monthly payment of £x
Annual Interest Rate of y%

Interest calculated daily, accumulated, and then paid annually.

Number of months = z

This must be doable easier than the method I'm using... I'm having a mental blank!

Thanks in advance.



  Abel 15:46 14 Jun 07

Hi Simsy, I find your post slightly confusing. On the one hand you speak of interest earned, and in the body of your post you mention payments. My assumption is, that you have savings of a certain amount which you add to on a monthly basis and want to monitor the interest earned. If this is the case, I can send you an Excel spreadsheet via the yellow envelope, which I personally use for the same purpose.


  Simsy 16:14 14 Jun 07

I can see the confusion...

When I say "payments" I am refering to payments INTO some form of saving scheme, e.g. Building Society... so these "payments" would be earning interest.

I'd welcome seeing what you've done. I am working on something similar, but I'm sure there's an easier way!

I'll send you a message with my email address.

Many Thanks.



This thread is now locked and can not be replied to.

LG G6 review: Hands-on with LG’s bold, big-screen shot at perfection

1995-2015: How technology has changed the world in 20 years

How the 2017 Oscar-winning VFX of The Jungle Book were created

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…