Personality Cafe banner

1 - 4 of 4 Posts

·
Registered
Joined
·
5 Posts
Discussion Starter #1
I got a question, what if i started saving with 500 euro each month and set it a way for 2.75%, the rente is paid at the end of the year (of course you save 1/12 each month) and i will do this for 4 years. How much money would i've saved?? I'm pretty bad with excel PLS HELP ME :)
 

·
Registered
Joined
·
2,308 Posts
I assume interest is calculated and paid at the end of each year? If that is the case its easy. Simply create a sheet with four columns, one for each year. Leave the top cell empty for now. In each column first enter 500 euros in twelve cells. Then add up the whole column in cell 14. Then add a new cell number 15 which should read =(cell 13) *0.0275

Finally add up the two bottom cells and then add a reference to this cell in the top of the second column(cell no. 1 which is empty in column one).

From that point on simply copy past the rest of the sheet.

I could refine this a lot using percentages and variables but you asked for something simple.
 
1 - 4 of 4 Posts
Top