Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

PPMT

Description: Returns the principal payment for a specific period of an investment based on periodic constant payments and a constant interest rate.

Syntax: PPMT(Rate, Per, Nper, PV, Fv, Type])

Set Type equal to If payments are due
0 or omitted At the end of the period
1 At the beginning of the period

Remarks:

Examples:

PPMT(.10/12, 1, 2*12, 2000,0,0) = -75.62

PPMT(.08, 10, 10, 200000,0,0) = -27,598.05

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.