PPMT

PPMT(rate, per, nper, pv [,fv] [,type])

Returns the amount of principal paid in a given period in a series of equal cash flows at regular intervals (Double).

 rate The interest rate per period (Double). per The payment period (Double). nper The total number of payments (Double). pv The present value of the future payments (Double). fv (Optional) The future value (Double) type (Optional) The number indicating when the payments are due:0 = the end of the period (default)1 = the start of the period

 REMARKS
 * This function returns the principal payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate.* The "par" is a value between 1 and "nper".* If "type" = True, then 1 is used.* You can use the PMT function to return the amount of principal and interest paid in a given period in a series of equal cash flows at regular intervals.* The equivalent Excel function is Application.WorksheetFunction.PPMT* The equivalent .NET function is Microsoft.VisualBasic.Financial.PPmt* For the Microsoft documentation refer to learn.microsoft.com

`Debug.Print PPmt(0.1 / 12, 1, 2 * 12, 2000)    '-75.62  Debug.Print PPmt(0.1, 1, 2, 2000)              '-952.38  Debug.Print PPmt(0.1 / 12, 1, 5 * 12, -10000)  '129.14  Debug.Print PPmt(0.08, 10, 10, 200000)         '-27,598.05  `

© 2024 Better Solutions Limited