16 Replies  17625 Views  Last Post: 01 October 2008  02:01 PM
#1
mortgage calculator
Posted 26 September 2008  09:13 AM
there are 6 input text boxes :::: home value, loan amount, term(years), home insurance, property tax, and interest rate
and one read only text box that is monthly payment....
# P = principal, the initial amount of the loan
# I = the annual interest rate (from 1 to 100 percent)
# L = length, the length (in years) of the loan, or at least the length over which the loan is amortized.
The following assumes a typical conventional loan where the interest is compounded monthly. First I will define two more variables to make the calculations easier:
# J = monthly interest in decimal form = I / (12 x 100)
# N = number of months over which loan is amortized = L x 12
Okay now for the big monthly payment (M) formula, it is:
M = P x ( J/(1(1J)^N)))
i can not get these numbers to come out correctly.....i am not very good at math.....
can someone please send me code for just the calculations on how to do this....
Replies To: mortgage calculator
#2
Re: mortgage calculator
Posted 26 September 2008  10:57 AM
Sorry, we're not just going to send you the code. We will help as soon as you show us what you've done to solve this, but we're not going to do this for you
#3
Re: mortgage calculator
Posted 26 September 2008  11:08 AM
#4
Re: mortgage calculator
Posted 26 September 2008  07:59 PM
Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim p As Double Dim i As Double Dim l As Double Dim m As Double Dim j As Double Dim n As Double i = txtinterest.Text p = txtloan.Text l = txtterm.Text j = i / (1200) n = l * 12 m = (p * (j / (1  (1 + j) ^ n))) txtpayment.Text = CDbl(m) End Sub End Class
This post has been edited by milton7888: 26 September 2008  08:01 PM
#5
Re: mortgage calculator
Posted 27 September 2008  12:37 PM
#6
Re: mortgage calculator
Posted 27 September 2008  02:12 PM
You said there is 6 inputboxes, from this code i cannot see how that would be necessary.
From what you have posted, i can only see the need for four.
txtLoan, txtInterest, txtTerm and txtPayment
If by input boxes you mean your variables (i am not calling you an idiot, im simply assuming a mistake could possibly be made and there are 6 variables) well if you read the code, its clear to see they are all being used.
n = l * 12
Term should be inputted as yearly. I mention this as it could possibly cause problems, maybe this is the error?
I have also built your application, but instead of making every input box i simply change the values.
debug your code, for the values, have txtinterest at 10, txtloan at 4000 and txtterm at 2. This would be a £4000 loan over a period of 2 years at 10%. Your txtpayment should say: 184.579705350067
Maybe this is your problem? then simply change:
m = (p * (j / (1  (1 + j) ^ n))) txtpayment.Text = CDbl(m)
To:
m = Math.Round((p * (j / (1  (1 + j) ^ n))), 2) payment.Text = CStr(m)
Hope it helps
Oops forgot to say why,
The Math.Round (Number, Dec Points) expression, well it rounds 'number' to however many decimal points you state with 'dec point'.
Anyway, i hope i've solved your problem in their somewhere
#7
Re: mortgage calculator
Posted 27 September 2008  04:31 PM
Quote
but if your only using 3 of the inputs why do you need the other three?
Although i have no idea how to work out the mortgage value, do you need to take into account those other factors? Maybe your not getting the right output is because your not including the tax and insurance and initial home value. But from just having a look at an example i'd say the formula is right. What sample data are you using? have a look here
http://www.sorted.or...ments/page2.php
and try use your data and see how it matches up against the output you get from you app
but my two cents is : try using more descriptive variable names when coding. It can save you a lot of headache and it makes it a lot easier for other people to read and help. Labeling things p and j etc is just painful
This post has been edited by Damage: 27 September 2008  04:46 PM
#8
Re: mortgage calculator
Posted 27 September 2008  05:07 PM
Quote
The following formula is used to calculate the fixed monthly payment (P) required to fully amortize a loan of L dollars over a term of n months at a monthly interest rate of c. [If the quoted rate is 6%, for example, c is .06/12 or .005].
P = L[c(1 + c)n]/[(1 + c)n  1]
The next formula is used to calculate the remaining loan balance ( B ) of a fixed payment loan after p months.
B = L[(1 + c)n  (1 + c)p]/[(1 + c)n  1]
try this
This post has been edited by Damage: 27 September 2008  05:14 PM
#9
Re: mortgage calculator
Posted 28 September 2008  05:59 AM
i must be missing some formulas or something.....
i sent a few of u a message with some example numbers, let me know if ne of u can help an ill send you some example numbers.....thanks
math blows
#10
Re: mortgage calculator
Posted 28 September 2008  08:44 AM
I'll take a look at the examples you sent me. I'm a bit busy at the moment, so i'll get to it in about an hour or two.
#11
Re: mortgage calculator
Posted 28 September 2008  06:11 PM
#12
Re: mortgage calculator
Posted 28 September 2008  08:35 PM
#13
Re: mortgage calculator
Posted 28 September 2008  09:15 PM
jacobjordan, on 28 Sep, 2008  08:35 PM, said:
hahah, yeah dont worry, about it, im lost, im slowly, giving up.....ill figure something out,
if ne one else wants to help or has input let me know....
#14
Re: mortgage calculator
Posted 29 September 2008  06:31 AM
EXACTLY what information where you given ?
#15
Re: mortgage calculator
Posted 01 October 2008  12:41 PM
Private Sub loan() Dim L As Double = 125000D 'loan amount Dim rate As Double = 6.375D 'interest rate Dim c As Double = (rate / 100D) / 12 'monthly interest rate Dim Nyear As Double = 30 'length of loan in years Dim n As Double = Nyear * 12 'length of loan in months Dim P As Double 'the payment P = Microsoft.VisualBasic.Financial.Pmt(c, n, L) End Sub
