'Investment formula

I'm breaking my head on a formula to calculate investment. With the basic parameters of:

Percentage monthly gain
Monthly investment 
Fee (on the entire capital)

I would like a formula that returns the capital.

For example:

Percentage monthly gain = 10%
Monthly investment =1000$
Fee= 0.1%

For first month: capital would be 1000*10% - (1000*10%*0.1%) = 1098.1
For second month: (1098+1100) *10% - ((1098+1100) *10%*0.1%) = 2416.3
And so on..

I want to have the option in excel to just change the number of months and get the capital after the gain and fees.

excel excel-formula

Solution 1:^[1]

The return on investment is usually expressed as a percentage. ... You may calculate the return on investment using the formula: ROI = Net Profit / Cost of the investment * 100 If you are an investor, the ROI shows you the profitability of your investments.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Dilliraj Somasundaram

'Investment formula

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]