# How to Use the PPMT Function in Google Sheets

The `PPMT` function in Google Sheets is used to calculate the payment on the principal investment based on constant-amount periodic payments and a constant interest rate.

When we calculate for the `PMT` function and find the correct payment periodic payment amount, this amount can be broken down to the principal repayment and the interest payment.

The `PPMT` function is useful because it helps you understand which part of a certain payment goes towards the principal. Having this information can help you plan around your investments and reach your investment goals in the proper manner. It is an easy, simplified method to help in your financial analysis problems.

Let’s look at an example.

You want to choose what investment to pursue, and you are planning your liquidity during certain periods. You have one upcoming month in mind. You have the information about the cost of the investment, the number of periods that the payment will take, and the fixed interest rates.

The `PPMT` function needs all the parameters mentioned above to help calculate the right principal payment for the investment in a certain period.

## The Anatomy of the PPMT Function in Google Sheets

The syntax of the `PPMT` function is as follows::

`=PPMT(rate, period, number_of_periods, present_value, [future_value,end_or_beginning]))`

Let’s have a look at each part of the function to understand what is going on here:

• `=` is the equals sign that starts off any function in Google Sheets.
• `PPMT` is the name of our function.
• `rate` is the interest rate.
• `period` is the amortization period, in terms of the number of periods.
• `number_of_periods` is the number of payments to be made.
• `present_value` is the current value of the annuity.
• `future_value` is an optional attribute that is the future value remaining after the final payment has been made.
• `end_or_beginning` is an optional attribute that sets whether the payments are due at the end (0) or the beginning (1) of each period. If left blank, it will be 0 by default.

You should also make sure that consistent units are used for the `rate` and `number_of_periods`. For example, if you have a loan, paid monthly, that goes on for longer than 12 months, and you have the annual percentage rate on hand, you need to divide this rate by 12. In the same vein, a loan paid quarterly requires you to divide the provided annual percentage rate by 4.

## A Real Example of Using the PPMT Function

Let’s look at the example below to see how to use `PPMT` function in Google Sheets.

#### Calculating the Monthly Principal Payments in Google Sheets

This is a simple problem. We want to find the monthly principal payment for a car loan on month 12.

The function takes three arguments. So in the equation, it will look like:

`=PPMT(C2/12,C7,C4,C5,0,0)`

Like mentioned above, because we are given an annual percentage rate, we need to keep our payment periods and rates consistent. That is why you can see in the example, it is divided by 12.

As a result, we get -\$498.70. It’s negative because it is a payment.

This number is the amount of your 12th month payment that goes towards the principal. The rest of the payment that month, will be the interest payment.

This simple problem can be practiced to perfection. Use the link below to get a copy of this problem set:

## How to Use the PPMT Function in Google Sheets

In this section, we will show you a step-by-step process on how to use the `PPMT` function in Google Sheets.

In this problem, we will be calculating the payments to two different loans

Calculating PPMT in Google Sheets

1. To begin, click on a cell to make active, which you would like to display the PPMT. For the guide. The PPMT will be in Cell C8.

2. Next, type the equal sign ‘=’ to start writing the function. Follow this with “PPMT” or “ppmt” – Google Sheets functions are not case sensitive so either is fine.
3. The auto-suggest box will create a drop-down menu. Select the PPMT function by clicking it. It is the first to pop up on the list, but take care to choose the correct function.

4. After the opening bracket ‘(‘, you will add the rate attribute. Note that since we are given monthly payments and an annual percentage rate, we need to divide the rate by 12, as seen in the formula below.
5. Next, we enter the period, according to the number of periods. We are interested in the 12th month, which is the 12th payment.
6. Next, we enter the number of periods or payments.
7. Next, we enter the present value of the investment.
8. There is an optional attribute of future value. We can keep this blank, or choose zero.
9. There is an optional attribute of payment end or beginning. Since we will be paying the loans at the end of each month, pick 0. Leaving it blank will leave to 0 as the default. You should even see a preview for the end result.
10. Click enter and you will find the 12th month’s principal payment.
11. Do this for the next case, remembering that since the payments are quarter, you should divide the annual percentage rate by 4 to keep consistent.
12. You are done!

Given a practical problem where you should completely solve for the correct monthly principal payment of a certain period, use the `PPMT`to find and study the monthly payment for your important financial decision-making.

And there you have it – you can now use the `PPMT` function in Google Sheets together with the other numerous Google Sheets formulas to create even more effective formulas.

Get emails from us about Google Sheets.

Our goal this year is to create lots of rich, bite-sized tutorials for Google Sheets users like you. If you liked this one, you'll love what we are working on! Readers receive ✨ early access ✨ to new content. There will be no spam and you can unsubscribe at any time.

## How to Share Specific Tabs in Google Sheets

Learning to share specific tabs in Google Sheets may come in useful when you want to share a…

## How to Get LSE Real-Time Prices in Google Sheets

Learning how to obtain prices from the LSE market in Google Sheets is useful for when you need…

## How to Calculate Reverse Percentages in Google Sheets

This guide will show you how you can compute reverse percentages in Google Sheets using basic arithmetic operations.…

## How to Extract Date From Timestamp in Google Sheets

To extract date from timestamp in Google Sheets is useful if you have DateTime values in your sheet,…