100% Free MasterclassFinancialBeginner Level
=PMT() Interactive Masterclass & Practice Simulator
Calculates the payment for a loan based on constant payments and a constant interest rate.
Official Syntax:
=PMT(rate, nper, pv, [fv], [type])Live Interactive Excel Spreadsheet (Full Width)
X
Excel Live Grid: =PMT() Practice Dataset=PMT() Engine • Click Any Cell to Calculate
E2
fx
🎯 Active Cell: Enter any formula or value into cell E2! Try
Sheet: Sheet 1 (Practice Table)=PMT(B2/12, C2*12, A2)Formula Assistant
Cell: E2Excel Calculation Rules:
- Click on any cell across the entire sheet.
- Type
=B2*C2,=PMT(...), or any math! - Click other cells to insert cell addresses automatically.
- Press Enter or click ✓ to evaluate live!
⚡ Pro Keyboard Shortcuts:
Enter CalculateTab Next CellF2 Edit CellEsc Cancel
Ready • Any Cell Formula Engine•Zoom: 100%
Advertisement Google AdSense Verified Slot
Google AdSense Responsive Unit (horizontal)
Compliant responsive placement adhering to Google Publisher Policies. Ads will display here upon adding your Publisher ID in .env.local.
Graded Practice Challenges (1)
1
Exercise 1: Practice =PMT() in Live Simulator
+50 XP
🎯 Target Goal:
Calculate Monthly Mortgage Payment on $300,000 Loan at 6.5% for 30 Years
Syntax Parameters Breakdown
rateRequiredThe interest rate for the loan.
nperRequiredThe total number of payments for the loan.
pvRequiredThe present value, or total amount that a series of future payments is worth now.
[fv]OptionalThe future value or cash balance after last payment.
[type]Optional0 = payment at end of period, 1 = payment at start.
Top Pitfalls to Avoid:
- Forgetting to close the parenthesis ) at the end of the formula.
- Mismatching cell range sizes in lookup vectors or criteria arrays.
Corporate Pro Tips:
- Always divide annual interest rate by 12 to get the monthly period rate.
- Multiply term in years by 12 to get total monthly payments (nper).
- PMT returns a negative value representing outgoing cash flow; use -PMT(...) to display positive.