# help in calculate!!!

hi,
I want to calculate the following
'calc profit for first month'
profit = deposit * .05/12
'accumlate profit
deposit = deposit + profit
I want loop to do what mentioned above
I used for I, and try do while but the result gives me the first month only
DO LOOP
PROFIT = DEPOSIT * .05/12
DEPOSIT = DEPOSIT + PROFIT
LOOP
HOW can I do it with vb plz...
###### Who is Participating?

Web / Application DeveloperCommented:
deposit = 1000
For i = 1 To 102
profit = deposit * 0.05 / 12
deposit = deposit + profit
Next i
0

Web / Application DeveloperCommented:
above one would give you cumulative result value using 0.05 / 12 for monthly interest.

suat
0

Commented:

Here's how to do it in a Do..Loop

Total = 102
Curr = 1
Deposit = 1000
do while Total >= Curr
Deposit = Deposit + (Deposit * .05 / 12)
Curr = Curr + 1
loop

0

Commented:
Why not

Deposit = Deposit *(1+(0.05/12))^102
0

Commented:
Hi diaa,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will suggest to:

Accept smozgur's comment(s) as an answer.

diaa, if you think your question was not answered at all or if you need help, you can simply post a new comment here.  Community Support moderators will follow up.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
0

Commented:
Comment from expert accepted as answer

Computer101
E-E Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.