I have have what I believe is a pretty simple question relating to investment returns
I have a set of annual return percentages that I need some information out of and I am having a mental blank on how to do it. Basically I need to take the returns from each year and see what my ending value would be if I had invested $100 in year 1 and let the investment sit there over 10 year. I have it set up using FVschedule(B7,B3:K3), where B7 is my starting $100 and B3:K3 is each year of returns. Is this the correct way of doing this?
In addition I need to get the cumulative return for the entire 10 year period, In this case you can find it based on the ending value and starting values, but for future projects I need a way to calculate it based on each years % return. How would I do this?
I have a set of annual return percentages that I need some information out of and I am having a mental blank on how to do it. Basically I need to take the returns from each year and see what my ending value would be if I had invested $100 in year 1 and let the investment sit there over 10 year. I have it set up using FVschedule(B7,B3:K3), where B7 is my starting $100 and B3:K3 is each year of returns. Is this the correct way of doing this?
In addition I need to get the cumulative return for the entire 10 year period, In this case you can find it based on the ending value and starting values, but for future projects I need a way to calculate it based on each years % return. How would I do this?
