Calculate The Maximum Mortgage Possible For A Customer?
Dec 3, 2011
I have to calculate the maximum mortgage possible for a customer. If it is a single application, the customer can borrow up to three times their salary plus any savings and investments they may have.
If it is a joint application, the customer can borrow 3 times larger salary and 2 times the smallest, also borrowing against any savings and investments. In either case, the applicant is not allowed to borrow in excess of 90% of the purchase value of the property (including stamp duty and legal fees).
I have declared everything and done out the code, yet every time I calculate the max amount they can borrow, it comes up as 0. My code is below if anyone can spot problems.Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) _
[Code]...
View 2 Replies
ADVERTISEMENT
Jan 1, 2009
Write the program in VB.Net (not Web based) with a graphical user interface. Allow the user to select which way they want to calculate the mortgage: By input of the amount of the mortgage, the term of the mortgage and the interest rate of the mortgage
[Code]...
View 2 Replies
May 23, 2010
Number of downloads: 81This program is supposed to calculate the ever popular mortgage payment and amortize the loan in a list box. I keep throwing this error "Missing Member Exception" and can not find out how to fix it anywhere. Because of the error I can't even see if I can even get a calculation in the text box, let alone if the amortization will run. The purple text is where the exception is.
Public Class HarlessSmithIA3
Dim LoanAmt, Int, Result, Term As Double
Dim txtIntRate As New Object
Dim txtLoanAmount As New Object
Dim txtLoanTerm As New Object
Dim txtMonthlyPayment As New Object
[CODE]...
View 10 Replies
Mar 15, 2010
Im trying to programme a form to calculate rainfall total,average,maximum, and minimum.how do I create the input box that opens to input the info I cant seem to find it in the tool box. Am i Missing something, and how do I set a array to calculate?
View 2 Replies
Sep 27, 2011
Calculate maximum or minimum of "x" numbers
View 2 Replies
Oct 4, 2011
I have the following problem: I select a customer from a dropdownlist and then the gridview should load all items of all orders of that customer. I have the following query:
Dim allorders = From ord In db.Orders
Where ord.CustomerID = Convert.ToInt32(CustomerDropDownList.SelectedValue)
[CODE]..............
I also tried to modify the query as follows:
Dim orderitems = From oi In db.OrderItems
Where oi.OrderNumber = (From From ord In db.Orders
[CODE]...........
But this does not work. I just started using LINQ.
View 5 Replies
Oct 5, 2011
A registeration sys using a Microsoft acres database I have a table named customer info to store customer details when registering and I need coding that will add the following to my table customer I'd , firstname, lastname , phonenumber and user also has to make selection between radio buttons male or female.
View 2 Replies
Jan 5, 2010
I am trying to autocomplete customer surnames direct from the Customer Datatable, using the code below which I got from another thread, but nothing is happening.
[Code]...
View 6 Replies
Jun 3, 2010
I am here again begging for help with homework. I have to write this program to display three mortgage payments simultaneously using an array for three types of loans, that part of my program does work... Then I must amortize all three loans at once using a loop for comparison so the user can see: [code] I can't get the amortization to show. [code]
View 7 Replies
Oct 9, 2010
I am creating a mortgage calculator using Visual Basic Express version. I am currently using the Console method, or command window view. I have it set up so the user can input the mortgage/loan amount, interest rate, term (in years), and have the formula for calculating the monthly payments.The problem I am having is that I need the program to display "all" the payments for the term of the loan, the loan balance/interest paid, and depreciating after each payment. The program should display a certain amount of payments, hesitate, then continue to display until it shows the end of the term of the loan. Basically, it is now an amortization loop formula I am trying to implement into the program.
View 3 Replies
Jan 26, 2009
I am suppose to be creating a mortgage amortization program that calculates the monthly payment and the amortization table for a mortgage based on user input of the mortgage amount, the interest rate and the length of the loan. I have worked on the program all week and finally got the program to compile; however, the interface does not give me any output. I already posted the assignment yesterday and am getting a C in the class but each week the program builds on the last week? Attached is the complet VB 2005 project file.
Public Class MortgageCalc 'Forms Click Event Handler
Private Sub MortCal_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Click
End Sub
[code]....
View 3 Replies
May 19, 2011
I am having a problem trying to pause/hesitate my loop for a couple of seconds and then iterate through the loop, but pauses every 10th iteration. I have my loan amortization displaying correctly but cannot get it to pause to list only 10 items at a time. 'This section uses the for loop to display the Loan Balance and Interest Paid over the Term of the Loan.
Dim counterStart As Integer
For counterStart = 1 To LoanTerm
'Performs Calculations for Amortization of loan.
InterestPaid = LoanAmount * InterestRate
[code]....
View 5 Replies
Nov 23, 2011
For my enterprise computing course we were asked to re-due a previous project which was a mortgage calculator that calculates your monthly payment except now using function and sub procedures.
[Code]...
View 2 Replies
Nov 8, 2011
I'm taking an introductory programming course, and am completely flummoxed as to what I'm doing wrong with my program. The problem seems to be in my arithmetic, as the program runs fine; it just doesn't produce the correct result when compared to the professor's control model.
I need to create a mortgage calculator, using the following formula: monthly payment = interest rate * loan amount * ( (1+ interest rate) ^ months) / ((1+interest rate)^months)-1) )
We have to use that formula, no other one. If anyone can spot an error in my code, please let me know what I've done wrong!
The code I've written is as follows:
CODE:
View 1 Replies
Dec 4, 2010
I am writing an application for my class, wherein I have a mortgage that will give the customer a discount of 1% on their interest if they pay early in the month, or penalize them by 1% if they are after the due date. Right now, I have it working with a checkbox that the user selects. However, I would like to have VB see the current date on the calendar I placed in the application already, and calculate the appropriate amount of interest based on that information. I am using Microsoft 2008 Visual Basic Express Edition on a PC.
View 8 Replies
Feb 17, 2010
I'm creating an amortization schedule for my mortgage calculator and I'm having a problem with a loop.
[Code]...
View 2 Replies
Feb 7, 2010
I have a multiple form project that is a mortgage calculator and I am having trouble with my Payment Numbers. One of the things I am listing in the amortization table is Payment #. The variable for that is Lyears. It seems like Lyears is set to 0 so it continues and never stops.
Public Class Week3Calc
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CalcBtn.Click
Dim MonthlyRate As Double 'Initiates variable
Dim YearRate As Double 'Initiates variable
[code].....
View 4 Replies
Mar 15, 2009
how to write/program VB programs. However, I'm stuck on the mortgage calculator application. Whenever I run the program, I come up with an error stating "Argument 'NPer' is not a valid value." which refers to the Pmt function in the code.
'Dim monthly As Double ' monthly payment rates
Dim years As Double 'total # of years
Dim rate As Decimal 'annual rate
Dim months As Integer
[code]....
View 2 Replies
Jan 19, 2009
I have already posted this assignment . The assignment is to create a VB.NET program that calculates the monthy mortgage payment for a $200,000 mortgage with an interest rate of 5.75% for 30 yrs. The program compiles and the interface window comes up but when you click the payment button nothing happens. fix this program because my other 4 assignments are based on this progam. The Visual Studio project file is attached.
Public Class Form1
Private Sub Form1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Click
[code]...
View 6 Replies
Mar 30, 2009
I am trying to calculate the number of years for my calculate age event handler, however i am apparently missing a method or whatnot because im trying to calculate the age , can anyone suggest help on this. I need to subtract years to get my age but when i try the birthdate.Subtract (currentDate) method i get an error about not able to convert from LONG?
So below is what I have.
Private Sub btnCalculateAge_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculateAge.Click
Dim currentDate As Date
Dim BirthDate As Date
Dim Age As Long
[CODE]
View 7 Replies
Mar 2, 2009
creating a mortgage calculator that display continuous information depending on the user input such as monthly payments, remaining balances, and interest paid. I am attempting to use a list box and am currently stuck. [code] Please use code tags when posting your code. Code tags are used like so.
View 1 Replies
Jun 2, 2011
[code]A customer can not exceed a debt load of 36% of their gross monthly income including house rent or a mortgage.[code]I basically know how to code this. I get the information from the user (income, rent, and other monthly payments) and then ask if they have good, ok, or bad credit (this will be the percentage part) and I know mostly what to do, but the hardest part is the actuall coding part, basically the calculations part, im always confused on what to do, my example shows basically what to do and I know how to get the users info, but how to program the calculations, is where im also stuck at My example is (the money for the income, rent, and other monthly payments the user entered already)
1. If there monthly Income is:$2,000.00
2. Monthly Home Rent/Mortgage:$500.00
3. Other Monthly Payments (alimony, child support, student loans):$100.00
4. Then there allowable Monthly Car Payment:( 36% of 2,000 (income) = 720)( now I subtract debts 720 - 500 (rent) - 100 (other) = 120) :$120.00
5. Display Maximum Car Value (interest rate based on credit):Present Value Function (16% per year (this is where I check one of the boxes for the credit, which in this case its an ok credit), 6 years (I have to keep it at 6 years), 120 (this is the allowable monthly car payment) per month)So basically PV((0.16 / 12), (6 * 12), 120) : $5532.03.
View 5 Replies
Jun 4, 2011
im using a datagridview, and it is connected to ms access. every time i have an input same in the column where primary key is I already got an error. can you guys how to show a messagebox if the Customer Contact number is already in use? here is my code.
[Code]...
View 1 Replies
Jun 28, 2009
It's a basic Access database driven e-commerce site. I have a home page, a products page, an orders page, an order confirm page, a shopping cart page and a view current orders page. The site uses an Access database with three tables. A Customer table, with all of the customer details, (FirstName, LastName, EmailAdd, CardNo, CardEx, SortCode, DeliveryAdd, Postcode)A Products table, with all the product information, (ProductID, ProductName, Price, ProductType, Images, ProductDescription). And an Orders table which contains CustomerID and ProductID.I've managed to get the orders page to work, this leads to the order confirmation page which displays the details the customer just placed.Here is what I have in the order confirmation page load event so far. Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
[code]...
This returns this error "Syntax error in FROM clause." I'm guessing my SQL code is wrong. I noticed when I placed the order in the order page it added an entry in the Access database where the generated CustomerID was 12 on the customers table and 4 in the orders table. Shouldn't these numbers be the same when they are generated?
View 2 Replies
Apr 14, 2011
So, I want to implement my own binary serialization. I'm looking for some examples to head me in the right direction.
View 2 Replies
May 4, 2012
I have a home page, a products page, an orders page, an order confirm page, a shopping cart page and a view current orders page. The site uses an Access database with three tables. A Customer table, with all of the customer details, (FirstName, LastName, EmailAdd, CardNo, CardEx, SortCode, DeliveryAdd, Postcode)A Products table, with all the product information, (ProductID, ProductName, Price, ProductType, Images, ProductDescription).And an Orders table which contains CustomerID and ProductID.I've managed to get the orders page to work, this leads to the order confirmation page which displays the details the customer just placed.[code]This returns this error "Syntax error in FROM clause." I'm guessing my SQL code is wrong.I noticed when I placed the order in the order page it added an entry in the Access database where the generated CustomerID was 12 on the customers table and 4 in the orders table.
View 2 Replies
Mar 25, 2009
i created a sales form and it is using currency also the project is working greatthe thing is when the form loads everything works great shows the decimal and dollar sign's for the first customer but when i click on the navigator for the next customer there is no decimal and dollar sign's how can i inherit the same controls to the next customer.
View 9 Replies
Jan 20, 2011
I'm currently in the middle of attempting to create a query that will be used so that the application user will be able to search the a customers id number. I'm completely new to adding queries using the query builder so I've become slightly stuck on trying to get this to work corrently.
I have a database which is set up and in this case the table is called 'cid' which defines the customers id column in the database, this is a primary key and the column has a data type 'AutoNumber'. I've become stuck as I'm not sure what I would have to put into the filter to make this query work.
View 2 Replies
Dec 15, 2011
how to view report particular Customer Name. in this code when i m type from date or To date report is showing all customer information but i need single customer info with name or Date this is my code.
[Code]...
View 1 Replies
Nov 15, 2011
[code]... i want to add CUSTOMER NAME in this code how to view each customer datewise
View 2 Replies
