Compounding Yield Spreadsheets

Ever wondered how the effect of compounding will affect your investment over a number of years?

With these spreadsheets that I have created, you can see how your money will be working over a set number of years!

The best way you can utilise these spreadsheets, is by first calculating the overall yield of all of your investments. Once you have done this, you can select the spreadsheet that directly applies to you and work out how much money you will earn in years to come.

The layout is designed to be simple, hence the price, all you need to do is change the figure of the initial investment, to what it is that you have invested initially, and then how much you are, or plan to invest every single month.

Once you have done this, the spreadsheet will do all of the maths for you, and it will tell you how much you will earn each month for the next 50 years, and how much you will earn each year for the next 50 years too! It will also tell you how much you are investing on an annual basis and it will also tell you how much you have invested through the course of your time investing!

I have created spreadsheets that vary from 1-20%, so you can see the effect that compounding would have at all ends of the spectrum.

You'll be able to see how much you will earn if you keep your money in savings (1% - if you're lucky).

You will also be able to how much you will yield if you were to invest in stocks and ETFs, (typically around 8%, either through dividends or capital gain).

The super high yielding dividend stocks can sometimes be upwards of 10-12%, if you are brave and ambitious to invest in some of those, hence why I have included spreadsheets all the way up to 20%. That way, you can see that too!

If there is anything else you would like me to add to these spreadsheets, please do let me know!