FinPPmt

Syntax

FinPPmt(Rate,Per,NPer,Pv,Fv,Due)

Description

Calculates the principal payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate.

An annuity is a series of fixed payments made to an insurance company or other investment company over a period of time. Examples of annuities are mortgages and monthly savings plans.

Rate and NPer must be in the same units to calculate correctly. If Rate is expressed in months, then NPer must also be expressed in months.

Negative values represent payments paid out, whereas positive values represent payments received.

Parameter	Description
Rate	Double representing the interest rate per period.
Per	Double representing the number of payment periods. Per can be no less than 1 and no greater than NPer.
NPer	Double representing the total number of payments in your annuity.
Pv	Double representing the present value of your annuity. In the case of a loan, the present value would be the amount of the loan.
Fv	Double representing the future value of your annuity. In the case of a loan, the future value would be 0.
Due	Integer indicating when payments are due. If this parameter is 0, then payments are due at the end of each period; if it is 1, then payments are due at the start of each period.

See Also

FinIPmt, FinNPer, FinPmt, FinRate.

Example

Sub Main
'This example calculates the principal paid during 
'each year on a loan of $1,000.00 with an annual 
'rate of 10% for a period of 10 years. The result
'is displayed as a table containing the following 
'information: payment,principal payment, principal 
'balance.
 
    pay = Pmt(.1,10,1000.00,0,1)
    msg = "Amortization table for 1,000" & vbCrLf _
			 & "at 10% annually for"
    msg = msg & " 10 years: " & vbCrLf
    bal = 1000.00
    For per = 1 to 10
        prn = PPmt(.1,per,10,1000,0,0)
        bal = bal + prn
        msg = msg & Format(pay,"###,###,##0.00") & " " _
			& Format$(Prn,"###,###,##0.00") & _
		 "  " & Format(bal,"###,###,##0.00") & vbCrLf
    Next per
    MsgBox msg
End Sub