SOLUTION: Hello: 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

Question 438977: Hello:
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:
given a starting dollar amount
a fixed monthly deposit
and a fixed interest rate
I want to know how long until the balance reaches X amount?

the original formula that solves for final balance is
B = A(1+i)^N + (P/i)[(1+i)^N − 1]

B = ending balance
A = starting balance
i = monthly rate
P = monthly deposits
n = how many months

thanks in advance!

Answer by stanbon(75887) (Show Source): You can put this solution on YOUR website!
B = A(1+i)^N + (P/i)[(1+i)^N − 1]
Solve for "N":
A(1+i)^N + (P/i)(1+i)^N = B+1
-----
[A + (P/i)](1+i)^N = B+1
---
(1+i)^N = (B+1)/[A+(P/i)]
---
Take the log of both sides:
N*log(1+i) = log[(B+1)/((Ai+P)/i)]
----
N = {log[(B+1)/((Ai+P)/i)]}/log(1+i)
=========================================
Cheers,
Stan H.
==================

RELATED QUESTIONS
Hello, I am completely stumped on the following 2 questions. Any help would be... (answered by nabla)

Hello, I am in need of help. I have this problem on an optional assignment, and I cannot... (answered by macston)

Tutor, I was hoping you could help me with this problem. I can not seem to get it to (answered by rapaljer,bucky)

Hello, I need some help with factoring. I have a problem and I am not sure that I am... (answered by stanbon)

Hello friends. I have a problem here that I am hoping someone can help me with . A right... (answered by hkwu)

Hello, I am struggling with this homework problem. I need to solve for "x" of course, but (answered by bucky)

Hello, I was hoping you'd please help me out with a math problem. I have to find an... (answered by mananth)

I am hoping I can get some help with this problem be cause it just doesn't seem right to... (answered by Alan3354)

I have been trying to solve this problem but I cannot seem to get it. Could somone help... (answered by Fombitz)