Excel Formulas to Calculate the Principal for Given Period ~ Easily!!
Tags: excelformula, excelformulas
Published: 2021-06-29 10:09:59

---
title: Excel Formulas to Calculate the Principal for Given Period ~ Easily!!
published: true
date: 2021-06-22 06:35:42 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-calculate-the-principal-for-given-period/
---

For anyone working in finance or banking, the time value of money is one topic that you should be fluent in. Excel can be an extremely useful tool for these calculations. Here we will show the formulas to **calculate the principal for the given period in Excel**. Let’s jump into this article!! 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)

[![Calculate principal for given period](https://geekexcel.com/wp-content/uploads/2021/06/Calculate-principal-for-given-period.png)](https://geekexcel.com/excel-formulas-to-calculate-the-principal-for-given-period/calculate-principal-for-given-period/#main)<figcaption id="caption-attachment-47809">Calculate principal for a given period</figcaption>

## Generic Formula:

- If you want to find out the principal for the given period in Excel, you can use the below formula.

**=PPMT(rate,period,periods,-loan)**

## Syntax Explanations:

- **PPMT** – The Excel **PV function** is used to calculate the principal portion of a given loan payment.
- **Rate** – It represents the interest rate.
- **Period** – It specifies the loan period.
- **Loan** – It represents the loan amount.
- **Minus Operator (-)** – This symbol will help to subtract any two values.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Let’s consider the below example image.

- Here, we will enter the input values in **Column B** and **Column C**.
- Now we need to find out the principal amount for the given period.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/06/Input-Ranges-59.png)<figcaption id="caption-attachment-47807">Input Ranges</figcaption>

- Select any cell and apply the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/06/Enter-the-formula-73.png)<figcaption id="caption-attachment-47810">Enter the formula</figcaption>

- Finally, press the ** ENTER**  key, you can get the result as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/06/Result-59.png)<figcaption id="caption-attachment-47808">Result</figcaption>

## Closing Words:

So yeah guys this is how you easily **calculate the principal for the given period in Excel**. If you have any **questions** , feel free to **comment**.

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 Ahead:

- **[Excel Formulas to Calculate the Bond Valuation ~ Easy Tutorial!!](https://geekexcel.com/excel-formulas-calculate-the-bond-valuation/)**
- **[Formulas for Finding Largest Value Smaller than a Specified Number!!](https://geekexcel.com/formulas-for-finding-largest-value-smaller-than-a-specified-number/)**
- **[How to find Vlookup and Return the Matching Values from Multiple Worksheets?](https://geekexcel.com/how-to-find-vlookup-and-return-the-matching-values-from-multiple-worksheets/)**
- **[Excel Formulas to Strip HTML from Text or Numbers ~ Quick Tips!!](https://geekexcel.com/excel-formulas-to-strip-html-from-text-or-numbers/)**