Financial Functions
Advanced
PMT Function
Calculate the payment for a loan based on constant payments and a constant interest rate using the PMT function.
Task:
You are taking out a loan and want to know the monthly payment. Calculate the monthly payment in cell B7 using the PMT function, given the rate, number of periods, and present value.
Learning Objectives:
- Learn the PMT function
- Understand loan payment calculations
- Practice financial planning
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | |
|---|---|---|
| 1 | Parameter | Value |
| 2 | Rate | 0.004166666666666667 |
| 3 | Nper | 360 |
| 4 | Pv | 200000 |
| 5 | Fv | 0 |
| 6 | Type | 0 |
| 7 | PMT |
What this exercise teaches (contains the answer)
The PMT function is essential for loan calculations, allowing you to determine the monthly payment, which is crucial for budgeting and financial planning.