# Loan payments with PMT (Excel lesson 39 of 45)

> What a loan costs per month, and in total.

Source: https://spreadsheetpractice.com/learn/pmt-loan-payments · Updated October 29, 2026

- **Course:** [Excel course](https://spreadsheetpractice.com/learn), track "Finance"
- **Time:** about 9 minutes, 3 graded exercises
- **Functions:** `PMT`
- **Access:** Pro (the lesson text is free; the graded exercises need Pro)
- **Key formula:** `=PMT(B3/12,B4*12,-B2)`: Monthly payment

## How it works

`PMT(rate, nper, pv)` returns the payment per period. Match the units: for monthly payments, divide the annual rate by 12 and multiply the years by 12.

Excel treats money you receive and money you pay as opposite signs, so the payment on a positive loan comes back negative. Put a minus in front of the loan amount to get a positive payment.

## Syntax

| Formula | What it does |
|---|---|
| `=PMT(B3/12,B4*12,-B2)` | Monthly payment |
| `=B6*B4*12-B2` | Total interest paid |

## Watch out for

- Using the annual rate with monthly periods overstates the payment roughly twelvefold.
- A negative result isn't wrong, it's the sign convention. The grader accepts either sign.

## The exercises

Solve them in the live grid at [Loan payments with PMT](https://spreadsheetpractice.com/learn/pmt-loan-payments). Each answer is graded, then re-checked on changed data so typed-in numbers don't pass.

1. **Monthly payment.** In B6, calculate the monthly payment for the loan in B2:B4.
2. **Total interest.** In B7, calculate the total interest paid over the life of the loan.
3. **Rate scenarios.** In B10, calculate the monthly payment at the rate in A10, using the loan amount and years above. Fill down to B13.

Previous: [MAXIFS & MINIFS by group](https://spreadsheetpractice.com/learn/maxifs-minifs-by-group) · Next: [Future & present value](https://spreadsheetpractice.com/learn/future-and-present-value)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
