I need to find the total of all payments at the end of the loan period.example, Mr. X borrows $100,000 for 15 years at the rate of 10%. The total of all payments is supposed to be $193,428.92.
View 2 Replies
I wrote a Visual Basic program using the PMT function to calculate the monthly payment for a loan. Also calculate the Total of All Payments made over the term of the loan. This is how it should work, The user will input the loan amount in a text box. The user will use horizontal scroll bars to input the term of the loan (years), and the rate of the loan. As the user clicks the scroll arrows for years and rate their values display on the form above each scroll bar. When the user clicks the Calculate button the program will output values for the amount of the monthly payment and the total of all payments for the term of the loan. The two scroll bars are set to their mid-points (15 years and 10%), I am unable to get to show this values in their respective text boxes for some reason. [Code]
View 3 RepliesThe pay rates for the project are:
a. Level 1 - $10.00
b. Level 2 - $12.00
c. Level 3 - $14.00
d. Level 4 - $16.00
e. Benefit Deduction Rate - 0.10
f. Overtime Factor - 1.5
For ease of program maintenance, all of the above rates and factors must be stored in module level constants. All references to pay rates in the program must refer to the module level constants.
When the Calculate button is clicked:
a. The value in the Hours text box must be validated to insure that it is numeric value greater than zero.
1. If the value is not valid, a message box must appear as shown below and the user must be offered the option to continue processing or quit the program.
2. If the user chooses to continue processing, the focus must be set to the Hours text box.
3. If the user chooses to quit, the program must close immediately.
b. If the value is valid, the program must calculate and display the total pay in the Total Pay label.
1. The pay rate is determined by which Job Grade radio button is checked.
2. For hours less than or equal to 40, the total pay is the hours times the pay rate.
3. For hours greater than 40, the total pay is 40 hours times the pay rate plus the hours in excess of 40 hours times the pay rate times the Overtime Factor.
4. If the Full Time radio button is selected, the total pay must be reduced by the Benefit Deduction Rate.
5. The value displayed in the Total Pay label must be formatted with a dollar sign and with two decimal
places.
6. The focus must be set to the Hours text box.
Why i get an error when i try to run this code
Code:
Also the message box, both yes and no close the program.....
o change this template use Tools | Options | Coding | Edit Standard Headers.'
Option Explicit On
Option Strict On
Public Partial Class MainForm
[code].....
What I want to do is to add a new student loan and the program checks the book title if loan exists, does not allow the same loan to be created. There is no limit on the number of loan placed by the student. How do I write the code as above in VB.NET Note: 1 book Per Loan number Add Loan Form
View 1 RepliesHere is the code. The only problem I am having is getting the total miles to display. How do I get my listbox to show my total miles broken down to hour1 xx miles. I can get it to show the total miles per total hours driven.
Option Strict On
Public Class frmDistanceTraveled
Private Sub btnCalculateDistance_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculateDistance.Click
' The btnCalculateDistance event hadler calculates the distance
' traveled
[Code] .....
I have this homework assignment where we have to create a pay calculator where you would enter the total minutes worked and the hourly pay rate. and then i have to create the code to show what the total weekly pay would be. I have to display the Hours Worked: and the Leftover minutes: I also know that the formula to calculate the weekly pay is totalMinutesWorked / 60 = hoursWorked and i have to use the Mod operator. [code]
View 2 RepliesHow do I code the total cost to give me a pound sign with the total cost at the moment when the total comes up for an example it gives me 3.6 when I need it to show £3.60 here is the code I have so far. [code]
View 2 Replieswhat im trying to do is to disply the sum of the payments to a label.i still cant [code]
View 1 RepliesI 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 RepliesI was wondering if I were to start a new project in vb .net would i be able to have say a user log into the application were their creditionals are stored in a access database (containing their username, password and their payment status) or wherever. (I can do this part easily).
Then have a paypal payment option within the application so a button saying Pay Now or Donate Now, were upon paying the users payment status in the database is changed to 'paid'. I'm sure that if i were to do it through paypal it would send you to their website because of privacy and security.
What I don't understand is how would i be able to send the user from my application to the paypal website and upon paying, have the paypal website return to my application saying that they have paid and the money has went into another paypal account?
I given label caption as Trans&Payments..But it's comming as Trans_Payments..I know the problem why it showing like this because '&' is using for ALT + Key combination..But i need to avoid this condition ..i need to show exactly what i typed ..I have one solution.. Trans&&Payments..But my case i don't want give like this ..
View 2 RepliesI am developing a program in which I add the payments for my bills on a monthly basis. I have the design layout and the logic thinking, but having a little difficulty getting the database codes in place. I have 2 comboboxes that act as drop down boxes (1 lists all 12 months and the other lists the years, only 2009 for now for testing).
My access database has 3 columns (name, dates, amount). The names are pre-populated and the only columns displayed in the datagridview are name and amount.
When I choose a month and year, the datagridview should populate with the amounts entered from that month. I am having trouble debugging which lines of code are not working because there are no errors showing, just seems that it stops running at some point.
Dim Connection As OleDb.OleDbConnection = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\My Documents\BillTracker.accdb;Jet OLEDB:Database Password=password")
[CODE]...
I am working with VB 2008. I want to be able to run this program say in N: and it will show me in an excel sheet the following:
Folder Path Size(GB) Count of Files
N:Clients 0.53 308
where clients contains subfolders and files and the size is the total of all those files within each folder and the count is the total within each folder also.
This works fine as it is but i have to select one by one the top level folders and some of them are huge so it takes forever to give me an answer.
1) I would like to see in my spreadsheet the following by only select the network drive n:
Folder Path Size(GB) Count of Files
N:Clients 0.53 308
N:Software 10.7 15430
N:Billing 0.98 105
2) I would also like to know if this is the faster method.
3) I tried adding a progress bar so that the user can have an idea of how much this will take but i had to remove because it was not working.
4) I would like to see the folder name, size of folder and count of files in the listview.
Here is the code:
Imports Microsoft
Imports Microsoft.Win32
Imports Microsoft.Win32.Registry
Imports System.Collections
[code].....
I am using visual basic 2008 amd creatomg a datagrodview format like below [code] Now I wnat to get total balance in total column after less discount in percentage with ENTER EVENT proceedure and get the whole total column balance in a textbox i.e Net BalanceTextBox. Please tell me how to calculate discount in percent % and get total in total column and also tell me how to move cursor in next cell instead of bottom row in datagridview.
View 2 RepliesI have 3 columns in a unbound datagridview, "length" "height" and "Total". Total = length x width and the final total in TextBox outside of the Grid. I found question simalar in this forum and tried the code but i am getting errors.The following is the code i am using
Public
Class Form1
Dim UnboundColumn[code]...
I am trying to program that is based on calculating the loan based on the balance of an item after the deposit. Then I must display certain information in a listbox. I am having a problem
Dim buyername As String
Dim cartype As String
[code]....
I get a credit loan for 2500 with 10 percent interest rate. I pay $150 a month to pay off the loan. How many months does it take to pay off the loan? I also have to show the new balance at every step Well I know it's 19 months in this case. I tried to do it, but I get many arithmetic overflow errors!![code]
View 4 RepliesI have the following problem: I get a credit loan for 2500 with 10 percent interest rate. I pay $150 a month to pay off the loan. How many months does it take to pay off the loan? I also have to show the new balance at every step. Well I know it's 19 months in this case. I tried to do it, but I get many arithmetic overflow errors!!
Here is my code so far:
Dim loan As Integer = 2500
Dim intrate As Double = 0.1
Dim payment As Integer = 150
Dim interest As Double
Dim newbalance As Double
[Code] .....
i'm making a program to calculate loan using dates, the customer borrows an item on a particular day and returns it on a given day else he would have to pay a certain amount of fine per day, which starts from the date of return if the user returns the item 1 day after the Date of Return, he pays a fine of 50pence if the user returns the item 3 days after the Date of Return, he pays a fine of 25pence per day if the user returns the item 10 days after the Date of Return, he pays a fine of 10pence per day and if the user returns the item 30 days after the Date of Return, he pays a fine of 5pence per day i did something like this, but it's not producing the required answer
Dim returned As Date
Dim due As Double
Dim fine As Double
[Code]....
how do i format a datetime in a textbox?
I have an assignment where I have to use financial.pmt to take input of a loan amount, interest rate, and term and display the monthly payment, total interest paid and total payments.
[Code]...
Our book doesn't talk much about the financial.pmt method. Can I use it to find the interest paid and total payments, or do i have to do that part with regular math like I've done?
Here is the problem. I am to write a VB program that will take a Loan of $563 that is to be paid off with 5 monthly payments of $116. The interest Rate is 1% per month. I need to display a table giving the number of months and the balance on the loan after each month.The Table displayed should look like this:
Month Amount Owed
1 $452.63
2 $341.16
3 $228.57
4 $114.86
5 $0.00
Here is my code but I do not understand why it only shows "Month" and "Amount Owed" and nothing else.Maybe someone can point me in the right direction and I can figure it out.
[Code]...
I'm new to forums as well as new to VB 2008. I'm in process of making a order calculator which will total any values you selected in combo boxes/checkboxes and then display it in a selected area. There are 3 things that I want to achieve: 1. Be able to add another total to an existing total (currently I'm able to see only one total when I hit "Calculate" button)2. Display how many orders I have made so far (new total counts as one order)3. Be able to add up checkboxes selected to an overall total. (when I try to add up one checkbox with another it seems to be stuck on 1.5 pounds which I assigned for each "side order")
View 4 RepliesI am coding a loan payment application and when I run the application the loan calculations are incorrect.[code]...
View 1 RepliesMonthly Loan payment calculated perfectly but still I'm stuck with fixed 2 week payment frequency for individual loan for example: if I a customer want to borrow $2000 and he/she want that loan amount to be paid off within 8 month technically by Biweekly payment frequency type!
For period As Integer = 1 To mPayments
iPayment = IPmt(APR, period, mPayments, -PVal, FVal, 1)
pPayment = PPmt(APR, period, mPayments, -PVal, FVal, 1)
lstLoanInterest.Items.Add(FormatCurrency(TotPrincipal).PadRight(25) & FormatCurrency(iPayment).PadRight(25) & FormatCurrency(dblBalance).PadLeft(25))
[Code] .....
I have problems with the formula, it dosent seem to work, and i also have problems, why its not storing in the gridview?
Private Sub btncalculate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btncalculate.Click
Dim LoanAmount As Decimal
Dim LoanRate As Decimal
Dim Interest As Double
[CODE]...
I have to show monthly paymen in label, make sure the user has entered an amount greater than 100, If user changes amount or rate or number of payments have label with answer cleared, When user Click on the text box have ente amount highlighted so user can type right over what was already written
I need to calcuate the button Also I need to be able to concatenate "Your monthly payment is (whatever the principal amount is) loan for(years) years at a rate of (whatever the %) is $ (whatever the monthlyPaymen)
[Code]...
i want to deduct some amount(i.e user input) from main loan taken by employee and remaining amount again come as balance loan amount and on nxt month again the some amount should deduct from balance loan amount.
my database is in ms-access and i use vb.net..
I am writing this program for class its supposed to be able to accept loan amount interest rate amount and the term of the loan (in years) and then output how much interest you owe and how much in total you owe.
Here is my code:
<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _
Partial Class Form1
Inherits System.Windows.Forms.Form
'Declare Variables
Dim loanAmount As Double
Dim interestRate As Double
[Code] .....
I copied the whole code as to I do not know where the rros are. My error keeps saying 'class' statement must end with a matching 'end class' I got a feeling this is something like if/endif but I cannot find it.
create website involving payments plus some data entry eg booking of some facilities with the main data kept at a LAN window system.
View 4 Replies
