Beeing far from a math guy, I've come here to ask the gurus for help :)
I have an index data imported to spreadsheet and I would like to calculate the investment return after n months with fixed periodical deposits starting from principal of 0. The data involves changing interest (or change of the index value) monthly.
Lets say, I would like to deposit 100$ every month for 36 months in total, starting at any moment during the history (lets say 1st of May 1901 in this case). So what will be my final yield after 36 months feeding the interest rates monthly? (1st of May 1904 in this case). Is there any useful formula that can be used in excel?
The data in spreadsheet looks like this: data
Thanks a lot
PS. Sorry, I dont even know what is the proper tag for this question