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 was start with constant 1000 for period of 102 month
I used for I, and try do while but the result gives me the first month only
please urgent help...
DO LOOP
PROFIT = DEPOSIT * .05/12
DEPOSIT = DEPOSIT + PROFIT
LOOP
HOW can I do it with vb plz...
diaaAsked:
Who is Participating?
 
Suat OzgurWeb / Application DeveloperCommented:
deposit = 1000
For i = 1 To 102
    profit = deposit * 0.05 / 12
    deposit = deposit + profit
Next i
0
 
Suat OzgurWeb / Application DeveloperCommented:
above one would give you cumulative result value using 0.05 / 12 for monthly interest.

suat
0
 
Hornet241Commented:

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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
VKCommented:
Why not

Deposit = Deposit *(1+(0.05/12))^102
0
 
DanRollinsCommented:
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
 
Computer101Commented:
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.

All Courses

From novice to tech pro — start learning today.