Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Example of COUNTIFS with variable table column in Excel
  • Reverse List in Excel
  • How to Create One and Two Variable Data Tables in Excel
  • Data Series in Excel
  • Excel Line Chart

References

  • Create hyperlink with VLOOKUP in Excel
  • Excel Advanced Lookup using Index and Match Functions
  • How to use Excel OFFSET function
  • Two-column Lookup in Excel
  • Count rows that contain specific values in Excel

Data Validations

  • Excel Data validation unique values only
  • Excel Data validation no punctuation
  • Excel Data validation must begin with
  • Excel Data validation whole percentage only
  • Excel Data validation must not contain

PPMT function: Description, Usage, Syntax, Examples and Explanation

by

What is PPMT function in Excel?

PPMT function is one of the Financial functions in Microsoft Excel that returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.

Syntax of PPMT function

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

The PPMT function syntax has the following arguments:

  • Rate: The interest rate per period.
  • Per: Specifies the period and must be in the range 1 to nper.
  • Nper: The total number of payment periods in an annuity.
  • Pv: The present value — the total amount that a series of future payments is worth now.
  • Fv(Optional): The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0.
  • Type(Optional): The number 0 or 1 and indicates when payments are due.
Set type equal to If payments are due
0 or omitted At the end of the period
1 At the beginning of the period

PPMT formula explanation

Make sure that you are consistent about the units you use for specifying rate and nper. If you make monthly payments on a four-year loan at 12 percent annual interest, use 12%/12 for rate and 4*12 for nper. If you make annual payments on the same loan, use 12% for rate and 4 for nper.

Examples of PPMT function

Steps to follow:

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

You can adjust the column widths to see all the data, if need be.

Data Argument description
10% Annual interest rate
2 Number of years for the loan
$2,000.00 Amount of loan
Formula Description Result
=PPMT(A2/12, 1, A3*12, A4) Principal payment for month 1 of the loan ($75.62)
Data Argument description
8% Annual interest rate
10 Number of years for the loan
$200,000.00 Amount of loan
Formula Description (Result) Live Result
=PPMT(A11, A12, 10, A13) Principal payment for year 10 of the loan ($27,598.05)

Post navigation

Previous Post:

How to generate random date between two dates in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • Excel If, Nested If, And/Or Criteria Examples
  • How to use Excel AND Function
  • How to use Excel NOT Function
  • TRUE function: Description, Usage, Syntax, Examples and Explanation
  • Check multiple cells are equal in Excel

Date Time

  • Count dates in current month in Excel
  • MINUTE function: Description, Usage, Syntax, Examples and Explanation
  • NETWORKDAYS.INTL function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate most recent day of week in Excel
  • WEEKNUM function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • Running count group by n size in Excel
  • Group times into unequal buckets in Excel
  • How to randomly assign people to groups in Excel
  • Categorize text with keywords in Excel
  • If cell contains one of many things in Excel

General

  • 3D SUMIF for multiple worksheets in Excel
  • 44 Practical Excel IF function Examples
  • Count cells that do not contain many strings in Excel
  • How to count total columns in range in Excel
  • Customize Ribbon In Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning