Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to use Excel LOOKUP Function
  • Basic INDEX MATCH approximate in Excel
  • How to get last row in text data in Excel
  • How to get first column number in range in Excel
  • How to get relative column numbers in a range in Excel

Data Analysis Examples

  • Everything about Charts in Excel
  • How To Sort One Column or Multiple Columns in Excel
  • Excel Frequency Function Example
  • How To Perform and Interpret Regression Analysis in Excel
  • Error Bars in Excel

Data Validation Examples

  • Excel Data validation whole percentage only
  • Excel Data validation no punctuation
  • Excel Data validation specific characters only
  • Excel Data validation unique values only
  • Data validation must not exist in list

Calculate cumulative loan principal payments in Excel

by

To calculate the cumulative principal paid between any two loan payments, you can use the CUMPRINC function.

Formula

=CUMPRINC(rate,nper,pv,start,end,type)

Explanation

In the example shown, we calculate the total principal paid over the full term of the loan by using the first and last period. The formula in C10 is:

Worked Example:   CUMPRINC function: Description, Usage, Syntax, Examples and Explanation
=CUMPRINC(C6/12,C8,C5,1,60,0)

How this formula works

For this example, we want to calculate cumulative principal payments over the full term of a 5-year loan of $5,000 with an interest rate of 4.5%. To do this, we set up CUMPRINC like this:

rate – The interest rate per period. We divide the value in C6 by 12 since 4.5% represents annual interest:

=C6/12

nper – the total number of payment periods for the loan, 60, from cell C8.

Worked Example:   CUMPRINC function: Description, Usage, Syntax, Examples and Explanation

pv – The present value, or total value of all payments now, 5000, from cell C5.

start_period – the first period of interest, 1 in this case, since we are calculating principal across the entire loan term.

Worked Example:   CUMPRINC function: Description, Usage, Syntax, Examples and Explanation

end_period – the last period of interest, 60 in this case for the full loan term.

With these inputs, the CUMPRINC function returns 5,000, which matches the original loan value as expected.

Post navigation

Previous Post:

Calculate interest for given period in Excel

Next Post:

Calculate cumulative loan interest 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
  • TEXT function: Description, Usage, Syntax, Examples and Explanation
  • Manipulating text strings using Left, Mid, Right, Len, Substitute in Excel
  • CHAR function: Description, Usage, Syntax, Examples and Explanation
  • Split dimensions into two parts in Excel Worksheet
  • RIGHT, RIGHTB functions: Description, Usage, Syntax, Examples and Explanation
  • Pad week numbers with zeros in Excel
  • Add days exclude certain days of week in Excel
  • NETWORKDAYS function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate most recent day of week in Excel
  • Calculate time difference in hours as decimal value in Excel
  • XNPV function: Description, Usage, Syntax, Examples and Explanation
  • DDB function: Description, Usage, Syntax, Examples and Explanation
  • PRICE function: Description, Usage, Syntax, Examples and Explanation
  • TBILLEQ function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate annuity for interest rate in excel
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles