Related Topics:

Spreadsheet Math Functions

Formulas Tab and Insert Function

Data Entry Tips for Functions

Function Wizard

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-2016. ReliaSoft Corporation. ALL RIGHTS RESERVED.

E-mail Link