How to use the CUMPRINC function in Excel Spreadsheet?
Tags: tousethecumprincfunc, excel, excelfunctions
Published: 2021-08-25 09:30:35

---
title: How to use the CUMPRINC function in Excel Spreadsheet?
published: true
date: 2021-08-22 15:04:24 UTC
tags: ToUseTheCUMPRINCFunc,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-cumprinc-function-in-excel-spreadsheet/
---

 **CUMPRINC function** in Excel returns the **cumulative principal**  **paid** between **two given periods**. The function takes the **rate, total period of the loan, and Loan amount** as **arguments**. The **principal amount** is the **amount of money one borrows**. Here I will introduce you to some quick tricks for how to **use the CUMPRINC Function In Excel Office 365**. Let’s get them below!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

## CUMPRINC function Syntax

```
=CUMPRINC (rate, nper, pv, start_period, end_period, type)
```

**Syntax Explanation:**

- **rate** – The **interest rate** per period.
- **nper** – The **total number of payments**.
- **pv** – the **loan amount**.
- **start\_period** – **start month** for the period.
- **end\_period** – **end month** for the period.
- **type** – The **timing of the payment** , either at the beginning or end of the period. **Numbers 0 or 1** represent the **payment date**. The **number 0** represents **payment at the end of the period** , and the **number 1** represents **payment at the beginning of the period**.

## Example

- Firstly, you have to **create the data** with **loan amount, annual interest rate** , and **period**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Sample-data-23.png)<figcaption>Sample data</figcaption>

- Then, you need to **use the formula** to **calculate principal paid** from **1st month to 6th month**.

```
=CUMPRINC(B2/12,B3,B1,D3,E3,0)
```

**Explanation:**

- **D4** : rate/12, annual rate divided by 12 for monthly payments.
- **D5** : total number of payments.
- **D3** : total loan amount.
- **F3** : start period.
- **G3** : end period.
- **0** : payment at the end of period.

![](https://geekexcel.com/wp-content/uploads/2021/08/use-the-formula-2-1024x369.png)<figcaption>Use the formula</figcaption>

- Now, the result amount is with a **negative sign** , and the **loan amount or borrowed amount** is **positive** , so the amount returned comes with a negative sign.
- You need to **change the start period** and **end period argument** in the formula.
- Finally, you have to calculate the **amount** varying with **different intervals of time**.

![](https://geekexcel.com/wp-content/uploads/2021/08/different-interval-time-1024x364.png)<figcaption>different interval time</figcaption>

**Check this too:** [How to use the TBILLYIELD function in Excel office 365?](https://geekexcel.com/how-to-use-the-tbillyield-function-in-excel-office-365/)

**NOTES:**

- You have to type **argument is not default** in this function, throws an error “you’ve entered too few arguments for this function”, If argument is not used.
- The formula only works with **numbers** only, returns **#VALUE! Error** if any **argument is non-numeric**.
- Then, you do not use **negative numbers** in the **argument** , as the formula generate **#NUM! Error**.
- Now,if you make **monthly payments on a four-year loan** at an **annual interest rate of 12 percent** , use  **rate/12 for monthly rate**. Use rate directly 12%, if calculating for annual payments
- If the **start period < 1, end period < 1 or Start period > end period** , the formula returns **#NUM! Error**.
- You need to type **argument other than 0 or 1** , the formula returns **#NUM! error**.

## Verdict

From this chapter, you can get some clarification about **how to use the CUMPRINC Function In Excel Office 365**. Let me know if you have any **doubts** regarding this article or any other Excel/VBA topic.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Also:**

- **[Excel Formulas to Calculate the Interest for Given Period ~ Quickly!!](https://geekexcel.com/excel-formulas-to-calculate-the-interest-for-given-period/)**
- **[Formulas to Calculate the Cumulative Loan Principal Payments!!](https://geekexcel.com/excel-formulas-to-calculate-the-cumulative-loan-principal-payments/)**
- **[Excel Formulas to Calculate Loan Interest in Given Year ~ Simple Tips!!](https://geekexcel.com/excel-formulas-to-calculate-loan-interest-in-given-year/)**
- **[Formulas to Calculate the Interest Rate for Loan ~ Easy Tricks!!](https://geekexcel.com/excel-formulas-to-calculate-the-interest-rate-for-loan/)**
- **[Excel Formulas to Calculate the Principal for Given Period ~ Easily!!](https://geekexcel.com/excel-formulas-to-calculate-the-principal-for-given-period/)**