Compounding interest of principal P, where a compounding withdrawal amount W get withdrawn from P before each compounding of P.
In accordance with the title I need a single formula that expresses the balance of a principal after "t" amount of time (in years), where
 V(t) is the balance after "t" amount of time,
 P is the balance before any withdrawals (subtractions) or compoundings,
 W is the amount to be withdrawn (subtracted) from P at each compounding,
 r is the decimal percentage the principal growths with (each year),
 i is the decimal percentage the withdrawal amount growths with (each year),
 n is the number of times r or i is used to compound W or P (at each period t).
 If compounding takes place each month n would be = 12. Hence the decimal percentage growth would be r/12 and i/12 for principal and withdrawal amount respectively.
Here is what I can make happen in excel, that I want to be able to do in a single formula as well. The following is an example of two following compoundings (from the beginning of a period):
 W amount is withdrawn from principal P > PW,
 What is left of the principal P is compounded and gives me a new principal value > (PW)*(1+r/n),
 W amount is compounded and thus giving me a new amount to withdraw next month > (PW)*(1+r/n), W*(1+i/n)
 W amount is withdrawn from the latest principal > (PW)*(1+r/n)W*(1+i/n),
 What is left of latest principal P is compounded and gives me a new principal value > ((PW)*(1+r/n)W*(1+i/n))*(1+r/n),
 Newest W amount is compounded and thus giving me a new amount to withdraw next month > ((PW)*(1+r/n)W*(1+i/n))*(1+r/n), W*(1+i/n)*(1+i/n)
Answer
 The questioner was satisfied and accepted the answer, or
 The answer was disputed, but the judge evaluated it as 100% correct.

Thanks you for your answer. I tested it up against an online calculator through desmos.com/calculator with success. Any idea how to use the formula in excel? I currently use the following for the W*SIGMA part. =W*SUMPRODUCT((1+r/n)^(mFACT(1+ROW(INDIRECT(0+1&":"&m1+1)))))*SUMPRODUCT((1+i/n)^(FACT(1+ROW(INDIRECT(0+1&":"&m1+1))))) But results are slightly off.

I am confident about the formula we have derived. Make sure the variables in our formula are the same as the online calculator. In particular in our formula W is the amount to be withdrawn after one month. Some calculators may use W_0 (an initial amount set at the initial time). Then W=(1+i/n)W_0.

For the sigma notation in the formula, you may write all the numbers appearing inside the sigma notation in a column and then add them up. Please watch: https://www.youtube.com/watch?v=eaei7DN6Z9M

The formula fits with the online calculator where I compared results  Well done NicolasP! I am NOT complaining.

As for the YouTube video. That is a good starting point which has inspired the current Excel calculation mentioned in my first comment. My results in Excel are slightly off. It needs tweaking. On desmos.com/calculator I have used our formula and was able to match the result on a few compounding interest calculator sites. Once again. Thank you for your help! :)

Great! I am glad it worked!

Thank you for asking your question at Matchmaticians.com. Please support Matchmaticians community by introducing it to your friends/family who might need mathematical help.
 answered
 169 views
 $4.92
Related Questions
 A generator at a regional Power Station produces an alternating voltage, according to the function, 𝑉 below:
 piceiwise function, graph
 Evaluate $\iint_D (x^2+y^2)^{3/2}dxdy$
 Algebra 2 help Please find attachment
 Recursive Set
 Prove that language L = {a^p ; p is prime} isn't regular using MyhillNerode theorem.
 Functions undergrad
 Use Green’s theorem to compute $\int_C x^2 ydx − xy^2 dy$ where $C$ is the circle $x^2 + y ^2 = 4$ oriented counterclockwise.