Visual Basic for Applications and Function Essay
PPMT Excel functions MS Excel – PMT Function(WS,
VBA)
• In Excel, the PMT function returns the payment amount for a loan based on an interest rate and a constant payment schedule. • The syntax for the PMT function is:
• PMT( interest_rate, number_payments, PV, [FV], [Type] )
•
•
•
•
interest_rate is the interest rate for the loan. number_payments is the number of payments for the loan.
PV is the present value or principal of the loan.
FV is optional. It is the future value or the loan amount outstanding after all payments have been made. If this parameter is omitted, the PMT function assumes a FV value of
0.
• Type is optional. It indicates when the payments are
due. …show more content…
• =IPMT(6%/52, 30, 4*52, 8000, 0 ,1)
• This next example returns the interest payment for a $6,500 investment that earns 5.25% annually for 10 years. The interest payment is calculated for the 4th year and payments are due at the end of each year.
• =IPMT(5.25%/1, 4, 10*1, 6500)
VBA Function Example
• The IPMT function can also be used in VBA code. For example:
• Dim LNumber As Currency
• LNumber = IPmt(0.0525/1, 4, 10*1, 6500)
MS Excel: PPMT Function (WS,
VBA)
• In Excel, the PPMT function returns the payment on the principal for a particular payment based on an interest rate and a constant payment schedule.
• The syntax for the PPMT function is:
• PPMT( interest_rate, period, number_payments, PV, [FV],
[Type] )
• interest_rate is the interest rate for the loan.
• period is the period used to determine how much principal has been repaid. Period must be a value between 1 and number_payments.
• number_payments is the number of payments for the loan.
• PV is the present value or principal of the loan.
• FV is optional. It is the future value or the loan amount outstanding after all payments have been made. If this parameter is omitted, the PPMT function assumes a FV value of 0.
• Type is optional. It indicates when the payments are due. Type can be one of the

All About Visual Basic
1713 Words  7 PagesMicrosoft Visual Basic is new evolution in current era, whenever we need to develop any windowbased application then we use VB. There have a lot of versions in VB like VB.6, VB.7, VB.NET etc & we use VB.6 version to make this project. The basic idea of introducing visual Basic to the world was to provide a rapid Application Development Environment to the developer. Visual basic provides the first example of successful component object modeling programming in which third Party available components…

Three Basic Trig Functions Of Trigonometry
2263 Words  10 PagesSIX BASIC TRIG FUNCTIONS Trigonometry, stemming from the greek words trigonon and metron , is the branch of mathematics in which sides and angles within in a triangle are examined in relation to one another. A right triangle has six total functions used in correlation to its angles, represented by the greek letter theta (θ). The primary operations are sine (sin), cosine (cos) and tangent (tan) which serve also as the reciprocal of cosecant (csc), secant (sec), and cotangent (cot) in that order.…

Calculator Codes in Visual Basic
2753 Words  12 PagesCalculator In this tutoral, Basic Calculator in VB.Net, we will look at creating a basic calculator. The calculator will have the following functionality: * Addition * Subtraction * Division * Multiplication * Square Root * Exponents (Power Of) * Clear Entry * Clear All There will be a 2nd tutorial that will cover some more advanced features such as * Adding a number to memory * Removing a number from memory * Calculating with a number in memory * Entering numbers…

The Basic Functions Of Management
1537 Words  7 PagesManagement Management is defined as the process of coordinating people, and other resources to achieve the goals of an organization. Management consists of a variety of things and very active job and duty. Management includes knowing basic management function, what types of managers there are, skillsets required to be a manager, leadership quality, and decision making. Altogether these different sections are taken in a much broader perspective diving into the four main resources of management…

Basic Computer Application Exam Paper
2474 Words  10 Pages(PARTTIME) MODULE NAME DATE May 2011 TIME Hours NO. OF QUESTIONS SET 4 BASIC COMPUTER APPLICATION MODULE CODE CSE 1021 DURATION NO. OF QUESTIONS TO BE ATTEMPTED 2 Hours 4 INSTRUCTIONS TO CANDIDATES This question paper has 4 questions. Answer ALL questions. This paper has an attached answer sheet to answer multiple choice questions. Detach the answer sheet and tie it with your answer booklet. BASIC COMPUTER APPLICATION – CSE 1021 MULTIPLE CHOICE QUESTIONS [30 marks] Question 1 Answer the MCQs…

Visual Basic  Available Credit Essay
626 Words  3 Pagesused by the customer from the customer’s maximum amount of credit. As you did in programming challenge 1, perform steps 1 through 6 of the programming process to design an application that determines a customer’s available credit. Steps 16 1. Clearly define what the application is to do. 2. Visualize the application running on the computer and design its user interface. 3. Make a list of the controls needed. 4. Define the values of each control’s properties. 5. Make a list of…

Visual Basic Practical File
3294 Words  14 PagesPractical 1 Aim:  WAP to perform arithmetic operation using command buttons. (Declare variables globally). Design: Source code : Path : F:\Program Files\Microsoft Visual Studio\COMMON\IDE\IDE ‘Initialize variable global Dim a, b, c As Integer ‘event for clear content Private Sub Command1_Click() ‘clear text box Text1.Text = "" Text2.Text = "" Text3.Text = "" End Sub ‘option for addition Private Sub Option1_Click() a = Val(Text1.Text) b = Val(Text2.Text) ‘Perform operation c = a + b Text3…

The Basic Three Functions Of Communication
1566 Words  7 PagesOB Final Exam 1. Communications fulfils three main functions within an organization, name them and explain their impact from an effective and ineffective perspective. The basic three functions of communication in organization are to inform, persuade, and motivate. Inform The idea of informing within an organization is to provide data and information so that employees can effectively complete their job. There are three ways through which information can travel: Downward moving information: In…

The Basic Function Of The Hydraulic System
1558 Words  7 Pagesthem on different parking level, which will cost more and will not be for generations. Another solution was using Hydraulics, motors and electric system to take the cars to different level and it will last much longer. Why to Use Hydraulics? The basic function of the hydraulic system is the ability to force or torque multiplication to apply in a simple manner, regardless of the distance between the input and the output, without the need for mechanical transmission or lever, either by varying the effective…

Basic Functions of Law: Australia
2224 Words  9 Pages(Australian Law System) The Functions of law, Social Cohesion,Social,Progress,Sources of law,Parliament made law,Judgemade law Which type of law is sovereign?,Classification of Law,Regulation of human behaviour,Criminal law,Classifications of Crime,Objectives of sanctions,Civil Law,Types of civil wrongs,Civil remedies,Types of civil remedies,Crimes The Functions of law The two functions are: 1 Social Cohesion 2 Social Progress Laws are needed to achieve these dual functions simultaneously. Social…
More about Visual Basic for Applications and Function Essay

All About Visual Basic
1713 Words  7 Pages 
Three Basic Trig Functions Of Trigonometry
2263 Words  10 Pages 
Calculator Codes in Visual Basic
2753 Words  12 Pages 
The Basic Functions Of Management
1537 Words  7 Pages 
Basic Computer Application Exam Paper
2474 Words  10 Pages 
Visual Basic  Available Credit Essay
626 Words  3 Pages 
Visual Basic Practical File
3294 Words  14 Pages 
The Basic Three Functions Of Communication
1566 Words  7 Pages 
The Basic Function Of The Hydraulic System
1558 Words  7 Pages 
Basic Functions of Law: Australia
2224 Words  9 Pages