document.write( "Question 438977: Hello:
\n" ); document.write( "I have a problem I cannot seem to solve. I am hoping you can help me solve it or point me in the right direction. I am trying to solve the compound interest formula for the time variable; however my memory of log is very shady. What I need is:\r
\n" ); document.write( "\n" ); document.write( "given a starting dollar amount
\n" ); document.write( "a fixed monthly deposit
\n" ); document.write( "and a fixed interest rate\r
\n" ); document.write( "\n" ); document.write( "I want to know how long until the balance reaches X amount?\r
\n" ); document.write( "
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "the original formula that solves for final balance is\r
\n" ); document.write( "\n" ); document.write( " B = A(1+i)^N + (P/i)[(1+i)^N − 1]
\n" ); document.write( "
\n" ); document.write( " B = ending balance
\n" ); document.write( " A = starting balance
\n" ); document.write( " i = monthly rate
\n" ); document.write( " P = monthly deposits
\n" ); document.write( " n = how many months\r
\n" ); document.write( "
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "thanks in advance!\r
\n" ); document.write( "\n" ); document.write( "
\n" ); document.write( "

Algebra.Com's Answer #303445 by stanbon(75887)\"\" \"About 
You can put this solution on YOUR website!
B = A(1+i)^N + (P/i)[(1+i)^N − 1]\r
\n" ); document.write( "\n" ); document.write( "Solve for \"N\":
\n" ); document.write( "A(1+i)^N + (P/i)(1+i)^N = B+1
\n" ); document.write( "-----
\n" ); document.write( "[A + (P/i)](1+i)^N = B+1
\n" ); document.write( "---
\n" ); document.write( "(1+i)^N = (B+1)/[A+(P/i)]
\n" ); document.write( "---
\n" ); document.write( "Take the log of both sides:
\n" ); document.write( "N*log(1+i) = log[(B+1)/((Ai+P)/i)]
\n" ); document.write( "----
\n" ); document.write( "N = {log[(B+1)/((Ai+P)/i)]}/log(1+i)
\n" ); document.write( "=========================================
\n" ); document.write( "Cheers,
\n" ); document.write( "Stan H.
\n" ); document.write( "==================
\n" ); document.write( "
\n" ); document.write( "
\n" );