Jump to content
House Price Crash Forum

Premium Bonds Calculations

Recommended Posts

I want to create an excel spreadsheet that will calculate the interest earned in a year through investment of premium bonds. Its not quite as simple as it seems as I have made monthly payments and have not had the full total for the full 12 months. See below:

Year 1





May deposited 1500


Jul deposited 2500 and won 50

Aug won 50

Sep deposited 6000 and won 50

Oct deposited 2000



TOTAL investment 12000

Total winnings 150

So as you can see I have invested 12000 but over the course of a full year I need to calculate the interest based on the number of months I've held each deposit for.

Any Excel guru's among us??

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Recently Browsing   0 members

    No registered users viewing this page.

  • 301 Brexit, House prices and Summer 2020

    1. 1. Including the effects Brexit, where do you think average UK house prices will be relative to now in June 2020?

      • down 5% +
      • down 2.5%
      • Even
      • up 2.5%
      • up 5%

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.