Calculate principal for given period

Calculate principal for given period

Generic formula 

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

Related formulas 

Calculate interest for given period

Calculate compound interest

Calculate interest rate for loan

Calculate original loan amount

Calculate payment for a loan

Calculate payment periods for loan

Explanation

To calculate the principal portion of a loan payment in a given period, you can use the PPMT function. In the example shown, the formula in C10 is:

=PPMT(C6/12,1,C8,-C5)

How this formula works

For this example, we want to calculate the principal portion for payment 1 of a 5-year loan of $5,000 with an interest rate of 4.5%. To do this, we set up PPMT like this:

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

=C6/12

per - the period we want to work with. Supplied as 1 since we are interested in the the principal amount of the first payment.

pv - The present value, or total value of all payments now. In the case of a loan, this is input as a negative value by adding a negative sign in front of C5 to supply -5000.

With these inputs, the PPMT function returns 74.465, which is rounded to $74.47 since the Currency number format is applied.

Calculate principal for given period

Generic formula 

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

Related formulas 

Calculate interest for given period

Calculate compound interest

Calculate interest rate for loan

Calculate original loan amount

Calculate payment for a loan

Calculate payment periods for loan

Explanation

To calculate the principal portion of a loan payment in a given period, you can use the PPMT function. In the example shown, the formula in C10 is:

=PPMT(C6/12,1,C8,-C5)

How this formula works

For this example, we want to calculate the principal portion for payment 1 of a 5-year loan of $5,000 with an interest rate of 4.5%. To do this, we set up PPMT like this:

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

=C6/12

per - the period we want to work with. Supplied as 1 since we are interested in the the principal amount of the first payment.

pv - The present value, or total value of all payments now. In the case of a loan, this is input as a negative value by adding a negative sign in front of C5 to supply -5000.

With these inputs, the PPMT function returns 74.465, which is rounded to $74.47 since the Currency number format is applied.