Payment Function:Pmt (interest, term, principal, future value, type) : Excel Buildin Function « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Excel Buildin Function

Payment Function:Pmt (interest, term, principal, future value, type)

 
Sub loanPayment()
   Dim dblRate As Double
   Dim intTerm As Integer
   Dim dblPrincipal As Double
   Dim dblPayment As Double

   dblRate = 0.075
   intTerm = 5
   dblPrincipal = 7000

   dblPayment = Pmt(dblRate / 12, intTerm * 12, -dblPrincipal)

   msgBox "The monthly payment is: " & dblPayment

End Sub








Related examples in the same category

1.Use function from Excel
2.Using Excel Application Functions in VBA
3.Cleans up every selected cell: with Proper function
4.Calculate a moving average
5.Sum a Range
6.Call worksheet function directly