Pmt - Calculate Total Interest Paid?

Apr 13, 2009

I have successfully written this interest calculation, although it is based on the ppmt function and adding up the interest from each payment. This is quite a long looping process.. And it is not accurate because of the rounding of each payment. I was wondering if someone knows if there is a formula I can use, or if the pmt function is capable of this? (e.g. Mortgage payment - total interest payable over 30 years at 5% ( principle and interest repayments))?

ADVERTISEMENT

Two-dimensional Arrays - Display The Total Bonus Paid To All Salespeople?

Apr 24, 2010

I am doing in my Visual Basic Reloaded:second edition school book. Ok here is all the information the case problem gives me and what it wants me to do.JM Sales employs 10 salespeople. The sales made by the salespeople during the months of January,February, and March are shown in Figure 8.52. The sales manager wants an application that allows him to enter the current bonus rate. The application should display each salesperson's number (1 through 10), total sales ammount, and total bonus ammount. It also should display the total bonus paid to all salespeople. Be sure to use one or more array in the application.Then it gives you a table with the salespersons 1-10 sales amount january February and March.(this is the figure 8.52)Here is a duplicate table of it below.

Salesperson January February March
----------- ------- -------- -------
1 2400 3500 2000
2 1500 7000 1000
3 600 450 21

View 2 Replies View Related

Payroll Calculator - Program Must Calculate And Display The Total Pay In The Total Pay Label

Oct 6, 2010

The 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.....

View 10 Replies View Related

How To Calculate Discount In Percent % And Get Total In Total Column

Jun 8, 2011

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 Replies View Related

Calculate Total Time?

Jan 6, 2012

I have many time result in my hand... like

10.10.23 (hours,minute,seconds)
01.14.15

How can i calculate total time?

View 8 Replies View Related

How To Calculate Total Of A Column In SQL

Nov 30, 2010

I have a sql SELECT statement in vb.net. I have this line of code to calculate a specific percentage of the Net Total:ROUND(Invoices.NetT*'" + txtOnGoing.Text + "'/100,2) As Commission 'txtOnGoing is a text box which pre populates a certain number e.g '10'... this means 10% of the NetT column..The above code works fine, now I want to add the "Commission" Column and display the Total in a text box. Does anyone know how to do this? I know I can use the SUM operator but because the Commission column isnt a column that actually exists in the table I dont know how I could do this.

View 3 Replies View Related

Calculate The Total Of A Column From A Database?

Apr 19, 2012

I'm having some trouble firstly trying to calculate the total of a column in the database connected to my vb.net project. Then I want to divide that total by the number of items in a listbox. This is my code so far:

Private Sub btnavresult_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnavresult.Click
Dim sqlx As OleDbCommand = New OleDbCommand

[Code]......

I get an error saying "No value given for one or more required parameters." when I try to run my program on this line "Dim rdr As OleDbDataReader = sqlx.ExecuteReader()"

View 6 Replies View Related

Calculate Total Of Decimal Textboxs

Jun 10, 2009

I have two textboxs are formated to decimal type. i want create thirth textbox and get total of above two textboxs. how can i do that.

[Code]...

View 13 Replies View Related

DB/Reporting :: Calculate The Total Sum Of Data In CR?

Dec 6, 2008

How to get the total sum of my fields that are not duplicated? The highlighted are examples of my duplicated fields (both lec and lab) but they don't have the same time.

View 1 Replies View Related

Eliminating (Calculate Total Due) Button?

Apr 6, 2010

This is the code that I have so far, the program works, etc.. How to delete the "Calculate Total Due" button and write the code so that the total due changes when any of the three options is changed/selected.

Option Explicit On
Option Strict On
Option Infer Off
Public Class MainForm
Private Function CalcResidentialTotalDue(ByVal premiumChannels As Integer) As Decimal
[Code] .....

View 3 Replies View Related

How To Calculate And Display Total Due Amount

Oct 6, 2009

This should calculate and display the total amount due. There are 3 radio buttons, A, B, C. Nonprofit should get a 20% discount from final charges.

Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
End Sub
Private Sub RadioButton1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles radA.CheckedChanged
[Code] .....

View 5 Replies View Related

How To Calculate Total Price Of Fruit

Jan 8, 2010

The program is for calculating an amount of fruit. I have a label saying the name of the fruit, a textbox to enter a value of 0-99 and another textbox with ReadOnly which will show the price.

A little picture here:[URL]

As you can see, the Fruit1 Etc... Is only the fruit name.
The Text box wich indicate 1-99 means the number of fruit.
The Textbox with Cash on it, means the total price.
The Calculate button, when I will push it, all the total price from all the fruit will be added together to form a total price which will be indicated in the total price textbox under the Calculate button.

When I will enter the number of fruit, if I enter 99, it give me a price.
When I will enter 60, I want that the 60 are multiplied by (let say) 0,10$
I just like to know how I can do this... Its really bothering e and I don't want to calculate all the things and make 99 line for 1 fruit cause it will be long.

The code I was using was:
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
If TextBox1.Text = "99" Then
TextBox2.text = "10.00$"
Elseif TextBox1.Text = "98" Then
TextBox2.Text = "9,90$"
EndIf
End Sub

Until the the number of the fruit in the code reach 0. So its very long.

View 14 Replies View Related

Calculate - Display A Total Gross Earnings

Jun 15, 2009

In my form I have Gross Earnings Calculated. Then that goes to a label. I then click a button to Clear Current Employee. Then I can input another employees info to get that employees Gross Earnings. Well when I click View Summary I want to display a Total Gross Earnings. The Total Gross Earnings should be a Total of all Employees Gross Earnings.

View 4 Replies View Related

Calculate The Total Cost Of A Parking Garage ?

Jun 21, 2010

I have a class assignment where i have to calculate the total cost of a parking garage from hours but i have to do it with a method function. So this might be a stupid question but can you read the user input values from a textbox in the function itself or do they have to be read in and recalled from the Private Sub Button1_Click section?

View 8 Replies View Related

Calculate The Total Fare Of Taxi Journeys?

Apr 4, 2010

tell me what is wrong with this calculation. I am fairly new to vb.net so i'm not particularly clued up! I am using it to calculate the total fare of taxi journeys.

[Code]...

View 6 Replies View Related

Calculate The Total For Bill Amounts In An Arraylist?

Oct 13, 2011

I want to calculate the total for bill amounts in an arraylist. I have already used this code:

[Code]...

View 1 Replies View Related

Calculate The Total Spend Of The Project And Display It On Either The First Tab?

Jun 23, 2011

my question is regarding a calculation and control display that I am doing.

The application is a project tracker, and I am trying to calculate the total spend of the project and display it on either the first tab if it is an open project or the second tab if it is a completed project. For some reason, it is showing 0 for all but one of the projects. If anyones eyes can see the problem I would be really greatful. The code is below

[code]...

View 1 Replies View Related

Calculate Total Salary According To Attending Days?

Aug 15, 2011

i want to calculate total salary according to attending days.

View 5 Replies View Related

Calculate Total Time In Crystal Report?

Mar 14, 2010

I am creating a report in vb.net using crystal reports and need help on finding sum of dailyworkhrs in my crystal reprot. I have a feld which calculates dailyworkhrs and now i would like to find the total of it. For example:

07:30:12
08:30:10
OUTPUT Should be
16:00:22

View 6 Replies View Related

Cannot Calculate The Total When Quantity Variable Inserted?

Nov 8, 2011

When I enter the quantity variable the script will not calculate. What am I missing ?

Public Class frmMovie
Private Property intQuantity As Integer
Private Sub txtName_TextChanged(ByVal sender As System.Object, ByVal e As [codee]....

View 1 Replies View Related

DB/Reporting :: Calculate The Total Sum Of Each Datarow In DataRepeater II

Jul 25, 2009

Now my programm is finish and have full function, but.... it is sooo slowly with dataset/datatable/query-creater. Before I used DataContext like:

PUBLIC CLASS Main
Private db As New KontoauszugSQLDataContext
.
.
.
Privat Sub LaufendeSumme ()

[Code].....

This works much faster. May be something wrong with System or is this normal? I think it must be quicker to get a queryresult with dataset/datatable/query-creater then with the DataContext version and its update.

View 3 Replies View Related

DB/Reporting :: Calculate Total Sum Of Each Datarow In DataRepeater

Jul 22, 2009

i want to calculate the total sum of each datarow in a DataRepeater.[code]

View 4 Replies View Related

How To Calculate A Running Total From Items In A Listbox

Oct 25, 2008

I am having an issue with trying to calculate a running total from items in a listbox. I am getting an InvalidCastException with the btnCalc_Click event. I think I understand why I am getting this exception, just not sure exactly how I fix it.

I need to have the lblTotalCost display the Grand Total of all the workshop totals. Ca anyone point me in the right direction here, I have been struggling with this part for about 2 weeks.[code...]

View 10 Replies View Related

Program To Calculate The Total And Average Rainfall?

Feb 14, 2010

For my programm I was told to do a programm to calculate the total and average rainfall. I have done so, but now I am supposed to use two function procedures to calculate the total and average rainfall. I can not seem to figure it out and it is very frustrating.

[Code]...

View 5 Replies View Related

Calculate The Total Cost For Gas For A Chevy And A Buick On A Form?

Feb 19, 2012

I'm trying to calculate the total cost for gas for a Chevy and a Buick on a form. The total miles is 21 for city and 33 for freeway. I'm also putting in the mpg for each, for city and freeway. How would I set up the labels to display the right amount? Do I use If Then statements?

View 9 Replies View Related

Calculate The Total Time A User Spending On An Application?

Jun 24, 2011

I want to create an application that able to calculate the total time the user (i.e. myself) spent on a particular application, for example Firefox. And this application should display warning message if the user spent a lot of time on Firefox (for example 1 hour or more)Reason: I'm a VB.NET developer. During my working hours, my main tool is Visual Studio and I suppose to do coding. But I need Firefox occasionally to access internet (particularly SO and other sites) to find solutions for my programming problems. The problem is I addicted to SO and SO sucks my time for hours until I have forgotten that I suppose to continue coding and not browsing the SO site.

View 6 Replies View Related

Calculate Running Total In Listview Group Extract From Database?

Dec 30, 2011

I'm developing Asset Management System, it will compute for straight line depreciation, my problem is how to calculate running total on each group that I've extracted from my database.Here's a snippet for my extraction of data

Private Sub cboAType_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboAType.SelectedIndexChanged
ListView1.Items.Clear()
If Not cboAType.Text = "-" Then

[code]....

View 4 Replies View Related

Get The First Store To Calculate The Total 5 Payroll Inputs But It Is Only Calculating The First Entry?

Apr 15, 2012

I am trying to get the first store to calculate the total 5 payroll inputs but it is only calculating the first entry I am not sure what I am doing wrong. Also if I click on the cancel button in my inputbox it bombs.

Private Sub calcButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles calcButton.Click
' Dim storeTotal As Integer
' Dim store As Integer

[code]....

View 8 Replies View Related

Program A Form To Calculate Rainfall Total,average,maximum, And Minimum?

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 View Related

Sub Procedures - Pizza Vendor - Display An Itemized Bill - Calculate The Total Cost

Oct 27, 2009

This is my project for class and this is what i have so far but my teacher gave me no credit. What am i doing wrong? i tried rearranging it but no success.

A fast-food vendor sells pizza slices at $1.25 each, fries at $1.00, and soft drinks at $0.75. Write a program to computer a customers bill. The program should use 4 subprocedures that do the following:

1. read in the amount of each item ordered

2. calculate the total cost

3. display an itemized bill

4. read in the users full name from a textbox, and display a sentence, addressing the user by first name only and in upper case characters, informing the user of their bill

Here is an example itemized bill:
Item Quantity Price
Pizza slices 3 $1.25
Fries 4 $1
Soft drinks 5 $0.75
Total $11.50

Example sentence for point 4: if the user name was entered as John Smith, you would display the sentence JOHN, your bill is $11.50.

MY

Public Class Form1

Sub pizza(ByVal pizzap As Double, ByVal pizzanum As Double)
lstoutput.Items.Add("Pizza Slices" & pizzap & "and" & pizzanum & "is" & (pizzap * pizzanum) & ".")

[CODE]....

View 6 Replies View Related

VS2010 To Monitor Net Usage And Calculate The Current/total Download And Upload While My Application Is Running?

Dec 22, 2011

Is there a way in VS2010 to monitor net usage, and calculate the current/total download and upload while my application is running?

View 9 Replies View Related

Date Checker Every 15 Days Paid?

Mar 15, 2012

I just wanna know what is the way of tracking the record of employee when i save theyre info in payroll. Like if the employee got paid in these date lets just say he will get paid every 15 days of his work not including sat and sunday. If i save the info the error will say."You have been paid on this day / week" .All i got is save the info but when it comes to checking i cant do it

View 5 Replies View Related

When The User Enters The Name "eugene" The Program Is Suppose To Calculate And Output The Total Monthly Sales?

Mar 27, 2011

My code works correctly if I do not have the DO WHILE statement, however we are suppose to have it loop. Which it will continue to ask for the salesman's name, code, etc. but when the user enters the name "eugene" the program is suppose to calculate and output the total monthly sales and the total commission dollars. What is happening is that when a user enters "eugene" the program is not recognizing it to do what it is suppose to do(calculate and output the total monthly sales and the total commission dollars) I am stuck and need assistance on how to make it recognize eugene. I am also having trouble with trying to figure out how once eugene is entered to tell the program to add the salespersoncommission and monthly sales of each case to get the totals to output to the user. Can you add the cases?

Option Explicit On
Option Strict On
Module Lab14

[code].....

View 8 Replies View Related

VB + Adding Word "all" To Calculate Total?

Nov 23, 2011

This program supposed to calculate total from an array based on each month. I was able to do that, but assignment aslo says that user can also put word "ALL" the it should calculate all the totals. I am struggling with the concept of this.

Option Explicit On
Option Strict On
Option Infer Off

[code].....

View 14 Replies View Related

Code Total Cost To Give Pound Sign With Total Cost At Moment When Total Comes Up

Jun 7, 2010

How 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 Replies View Related

Loop Through Top Level Folder In Mapped Drive And Give Total Count Of Files And Total?

Oct 28, 2008

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].....

View 5 Replies View Related

Add 1% Interest To The New And Used Rates When DP Is Less Than 20%?

Mar 26, 2012

I need to modify this code to add 1% interest rate to the new and used rates when less than a 20% down payment is made.

Public Class Form1
' Class-level constants
Const dblMONTHS_YEAR As Double = 12 ' Months per year

[code]......

View 1 Replies View Related

Calculating Interest In .net?

Jul 27, 2009

I,ve completed a program for a debt solution agency that calculates the amount a client can afford to repay after all his deductions and general life costs, my proplam however is at the end when i have to display all the creditors on a proposal data grid that shows the amount and total months to repay all creditors and calculates the amounts as one of the creditors debt is paid up and that monthly installment is devided between the remaining creditors.

View 1 Replies View Related

IDE :: Sum Up Total In An Unbound Datagridview Column With Total To Textbox?

Apr 22, 2011

I 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]...

View 5 Replies View Related

Add 1% To Interest Of New And Used Rates When Less Than 20% DP Is Made

Mar 26, 2012

I need to modify this code to add 1% interest rate to the new and used rates when less than a 20% down payment is made.

I've already added in the constants for the increased interest rate, but hit a wall there.

Public Class Form1
' Class-level constants
Const dblMONTHS_YEAR As Double = 12 ' Months per year

[Code].....

View 4 Replies View Related

Calcuating The Interest On A Loan?

Feb 19, 2010

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]....

View 4 Replies View Related

Componding Interest Over 10 Years?

Mar 22, 2009

I am stuck, I am doing a Case Statment and this loop to calculate pay per hour and thexpected raise percentage on 40 hr week @ 52 wks per yr. THe raise increase each amount after the first year.The display for next 10 years is the head bump. Any suggesions will be tried. In this loop trying to get the 1 year values to add the intrest rate to the following 10 years is something I can not seePrivate Sub btnCalculatePay_Click(ByVal sender As System.Object, ByVal e As ystem.EventArgs) Handles btnCalculatePay.Click

View 4 Replies View Related

Compound Interest Calculation?

Feb 6, 2011

Im a little stuck with the Compound Interest Formula.

My code returns
0.00 :L
Dim amount, interest, monthly As Double

[code].....

View 5 Replies View Related

Interest Rate Calculator With Validation?

Mar 11, 2011

Im creating an interest rate calculator that will make sure the principal is a positive amount, retrieve the interest rate from the interest rate:numericupDown function and will leave a message in the resulttextbox.This is what i have so far:

Public Class InterestCalculatorForm
' handles Calculate Button's Click event
Private Sub calculateButton_Click(ByVal sender As System.Object, _

[code].....

View 3 Replies View Related

Make Compound Interest Loop?

Dec 5, 2011

I have to create a Compound Interest Loop where I input a Mortgage amount and Mortgage Term (ie how many years the mortgage will span into another.) into two textboxes.

View 14 Replies View Related

ADVERTISEMENT