473,322 Members | 1,699 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

PMT Function

Having problems getting the PMT function working. I'm new to programming, and I read the tech notes On how to set up. But it still doesn't work. Can somebody just give me an example the proper way to set up. I'm woking on a LOAN program
TIA

Rudy
Nov 20 '05 #1
6 7997


----- Herfried K. Wagner [MVP] wrote: -----

* "=?Utf-8?B?UnVkeQ==?=" <an*******@discussions.microsoft.com> scripsit:
Having problems getting the PMT function working. I'm new to
programming, and I read the tech notes On how to set up. But it still
doesn't work. Can somebody just give me an example the proper way to set
up. I'm woking on a LOAN program.


What's the problem?!

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

Sorry, didn't mean to be vauge. Here is my PMT function that I set up.

Function Pmt(ByVal interestRate As Single, ByVal Months As Single, ByVal LoanAmount As Single)
End Function

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim LoanAmount As Single
Dim LoanPayment As Single
Dim InterestRate As Single
Dim Months As Single

LoanAmount = LoanAmounttxt.Text
InterestRate = interestratetxt.Text
Months = monthstxt.Text

LoanPayment = Pmt(InterestRate / 12, Months * 12, LoanAmount)

MonthPaymentstxt.Text = LoanPayment

Everytime I run my program, I just get a 0. I have no syntax errors and it builds OK. I have been reading conflicting articles. Some say Dim as Single, other say Dim as Double. And I have been trying to find an example of this type of program that I can see what I'm doing wrong. Compare notes. I'm not even sure if I'm doing the PMT function right. I did import SYSTEM.MATH. Again, I'm new at this, and making this program on my own, and not doing a lab like I have been or the past year. This is the first time at writing my own program without copying it from a book. I though it would be good expierence.

Thanks for your interest.

Rudy
Nov 20 '05 #2
"Rudy" <an*******@discussions.microsoft.com> schrieb

Sorry, didn't mean to be vauge. Here is my PMT function that I
set up.

Function Pmt(ByVal interestRate As Single, ByVal Months As Single,
ByVal LoanAmount As Single)
End Function

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click

Dim LoanAmount As Single
Dim LoanPayment As Single
Dim InterestRate As Single
Dim Months As Single

LoanAmount = LoanAmounttxt.Text
InterestRate = interestratetxt.Text
Months = monthstxt.Text

LoanPayment = Pmt(InterestRate / 12, Months * 12, LoanAmount)

MonthPaymentstxt.Text = LoanPayment

Everytime I run my program, I just get a 0. I have no syntax errors
and it builds OK. I have been reading conflicting articles. Some
say Dim as Single, other say Dim as Double. And I have been trying
to find an example of this type of program that I can see what I'm
doing wrong. Compare notes. I'm not even sure if I'm doing the PMT
function right. I did import SYSTEM.MATH. Again, I'm new at this,
and making this program on my own, and not doing a lab like I have
been or the past year. This is the first time at writing my own
program without copying it from a book. I though it would be good
expierence.


What do you expect? Your PMT function is empty. Consequently it returns zero
(or Nothing).

You should also enable Option Strict in the project properties to be
notified about possible bugs at compile time.
--
Armin

Nov 20 '05 #3


----- Armin Zingler wrote: -----

"Rudy" <an*******@discussions.microsoft.com> schrieb
Sorry, didn't mean to be vauge. Here is my PMT function that I

set up.
Function Pmt(ByVal interestRate As Single, ByVal Months As Single,

ByVal LoanAmount As Single)
End Function

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As

System.EventArgs) Handles Button1.Click
Dim LoanAmount As Single

Dim LoanPayment As Single
Dim InterestRate As Single
Dim Months As Single
LoanAmount = LoanAmounttxt.Text

InterestRate = interestratetxt.Text
Months = monthstxt.Text
LoanPayment = Pmt(InterestRate / 12, Months * 12, LoanAmount)
MonthPaymentstxt.Text = LoanPayment
Everytime I run my program, I just get a 0. I have no syntax errors

and it builds OK. I have been reading conflicting articles. Some
say Dim as Single, other say Dim as Double. And I have been trying
to find an example of this type of program that I can see what I'm
doing wrong. Compare notes. I'm not even sure if I'm doing the PMT
function right. I did import SYSTEM.MATH. Again, I'm new at this,
and making this program on my own, and not doing a lab like I have
been or the past year. This is the first time at writing my own
program without copying it from a book. I though it would be good
expierence.


What do you expect? Your PMT function is empty. Consequently it returns zero
(or Nothing).

You should also enable Option Strict in the project properties to be
notified about possible bugs at compile time.
--
Armin

Thanks for the tip about Option Strict, I forgot about that. It sure helps alot and shows how wrong my code is.

I didn't think it was empty, I thought by putting the "name" in, it was the same as putting the number in that the user would put in the textbox. I guess I still don't understand what I need to put in the PMT function.
Thanks for all your help!

Rudy

Nov 20 '05 #4
"rudy" <an*******@discussions.microsoft.com> schrieb
>> Function Pmt(ByVal interestRate As Single, ByVal Months As
>> Single,

> ByVal LoanAmount As Single)
>>> End Function


What do you expect? Your PMT function is empty. Consequently it
returns zero (or Nothing).

You should also enable Option Strict in the project properties
to be notified about possible bugs at compile time.

Thanks for the tip about Option Strict, I forgot about that. It
sure helps alot and shows how wrong my code is.

I didn't think it was empty, I thought by putting the "name" in, it
was the same as putting the number in that the user would put in the
textbox. I guess I still don't understand what I need to put in the
PMT function. Thanks for all your help!


Sorry, I don't know what you need to put in it because I don't know what you
expect the function to do. You need to write the code that does what you
need.
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

Nov 20 '05 #5
"Armin Zingler" <az*******@freenet.de> schrieb

Sorry, I don't know what you need to put in it because I don't know
what you expect the function to do. You need to write the code that
does what you need.


Now I see what you want. The Pmt function is part of the Microsoft Visual
Basic library, so you don't need to write it at all on your own. Delete your
empty function and the code should work.

The function is part of the Module 'Microsoft.VisualBasic.Financial' in the
MSVB library. All members (incl. functions) in a Module can be accessed
without using a qualified name. Means: you can simply write

variable = pmt(...)

You don't have to write

variable = Microsoft.VisualBasic.Financial.Pmt(...)

but it would work also.

--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

Nov 20 '05 #6
I will try that Armin. Thanks for all your help on this. I really appreciate it. Like I said, I'm still learning, but I wanted to start doing stuff on my own, experience always seems to be the best teacher. It's nice to see there are people who are willing to share the knowledge. I'm going to work on this tonite, I'll keep you updated

Rudy
Nov 20 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: domeceo | last post by:
can anyone tell me why I cannot pass values in a setTimeout function whenever I use this function it says "menu is undefined" after th alert. function imgOff(menu, num) { if (document.images) {...
5
by: phil_gg04 | last post by:
Dear Javascript Experts, Opera seems to have different ideas about the visibility of Javascript functions than other browsers. For example, if I have this code: if (1==2) { function...
2
by: laredotornado | last post by:
Hello, I am looking for a cross-browser way (Firefox 1+, IE 5.5+) to have my Javascript function execute from the BODY's "onload" method, but if there is already an onload method defined, I would...
2
by: sushil | last post by:
+1 #include<stdio.h> +2 #include <stdlib.h> +3 typedef struct +4 { +5 unsigned int PID; +6 unsigned int CID; +7 } T_ID; +8 +9 typedef unsigned int (*T_HANDLER)(void); +10
8
by: Olov Johansson | last post by:
I just found out that JavaScript 1.5 (I tested this with Firefox 1.0.7 and Konqueror 3.5) has support not only for standard function definitions, function expressions (lambdas) and Function...
3
by: Beta What | last post by:
Hello, I have a question about casting a function pointer. Say I want to make a generic module (say some ADT implementation) that requires a function pointer from the 'actual/other modules'...
2
by: f rom | last post by:
----- Forwarded Message ---- From: Josiah Carlson <jcarlson@uci.edu> To: f rom <etaoinbe@yahoo.com>; wxpython-users@lists.wxwidgets.org Sent: Monday, December 4, 2006 10:03:28 PM Subject: Re: ...
28
by: Larax | last post by:
Best explanation of my question will be an example, look below at this simple function: function SetEventHandler(element) { // some operations on element element.onclick = function(event) {
4
by: alex | last post by:
I am so confused with these three concept,who can explained it?thanks so much? e.g. var f= new Function("x", "y", "return x * y"); function f(x,y){ return x*y } var f=function(x,y){
7
by: VK | last post by:
I was getting this effect N times but each time I was in rush to just make it work, and later I coudn't recall anymore what was the original state I was working around. This time I nailed the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.