Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 180
  • Last Modified:

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...
0
diaa
Asked:
diaa
1 Solution
 
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
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.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now