Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Premium Bonds spreadsheet
I'm quite handy with spreadsheets but this one's got me stumped! I want to create an spreadsheet that will calculate the interest earned in a year through investment of UK 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 Jan Feb Mar Apr May deposited 1500 Jun Jul deposited 2500 and won 50 Aug won 50 Sep deposited 6000 and won 50 Oct deposited 2000 Nov Dec TOTAL investment 12000 Total winnings 150 So as you can see I have invested 12000 but over the course of a full year and have received back 150 but what is the interest rate? I need to calculate the interest based on the number of months I've held each deposit for. Can anyone crack this? -- sparker3000 ------------------------------------------------------------------------ sparker3000's Profile: http://www.excelforum.com/member.php...o&userid=27572 View this thread: http://www.excelforum.com/showthread...hreadid=470916 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel 2K3: Opening spreadsheet, also opens book1.xls? | Setting up and Configuration of Excel | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) |