program to help a bank customer figure out certificate deposit

GUnit216

I was wondering if anyone had or knew where to get or could write a program that helps a bank customer figure out certificate deposit.

The formula to calculate the balance with compound interest would be:

Balance=principal * (1 + annual_interest_rate/12) ^number_of_months

Program allows user to enter amount of principal between $1000 and $50,000. Any amount not in that range is not allowed.

So you would include principal, interest rate, interest, # of months, and balance for the data.

Thanks!

BullS1

You can create a form in VB and put 4 text boxes on it, Balance, Princal, annualinterestrate and numberofmonths

Also put a button called calculate. Code would be as follows on the click event.

Dim Value as integer
Dim Prin As integer
Dim annintrate as integer
Dim nomonths as integer



Prin = Principle.text
annintrate = annualinterestrate.text
nomonths = numberofmonths.text

If Prin >=1000 AND Prin <= 50000 Then
Value = prin * ((1 annintrate/12)*nomonths)

balance.text = Value
Else : MsgBox("Please enter a principle value between 1000 and 50000")
End If

: I was wondering if anyone had or knew where to get or could write a program that helps a bank customer figure out certificate deposit.
:
: The formula to calculate the balance with compound interest would be:
:
: Balance=principal * (1 + annual_interest_rate/12) ^number_of_months
:
: Program allows user to enter amount of principal between $1000 and $50,000. Any amount not in that range is not allowed.
:
: So you would include principal, interest rate, interest, # of months, and balance for the data.
:
: Thanks!
: