Formula

[NeedForVb]

hello...

i`m doing vb in my college...
my topic is monthly car installment...
can anybody teach me the code for formula...
like when people press the `calculate` button it will display the formula regarding the calculated amount of loan payment (how can get that value)

my project is in the attachment..
e.g
total car price = 1000
downpayment = 100
interest = 3%
duration = 12(monthly)
total = 27.81

*the formula how it counts to get the 27.81

sory for bad english..
thanx for the help...
i really appreciate the help...

[helderjsd]

instead put a frm here, put the entire code...

[stanav]

That total ($27.81) is the total interest paid for the loan at 3% annual interest rate. This is a monthly compound interest. If you just Google for "compound interest formula", you should find the formula right away.
And BTW, that value $27.81 is not correct. It should be $27.37.

[Hack]

Based on the fact that you have attached a form that would only work in VB6 and Earlier I have moved your thread to this section.

[JuggaloBrotha]

instead put a frm here, put the entire code...

That's a vb6 form & code file he posted, I've already notified the admins that the thread is in the wrong subforum here.

Edit: and it's already moved, the price I pay for using tabbed browsing.

[opus]

I'd change the formulas as follows:

'Calculation (Monthly payment is calculted using  CreditAmount*(1-(1 + InterestRatePerYear/PaymentsPerYear) ^(NumberofYears*PaymentsPerYear))


douInterest = douInterest / 100
a = curLoan - curDp
b = 1 + douInterest/intMonth
c = b ^ intMonth
d = 1-c
curInstallment = a*d