Microsoft Excel — Medium
Key points
- The PMT function requires specific loan terms as inputs
- It outputs a single payment amount, not a series of payments
- The function assumes a fixed interest rate over the loan's life
- Present value is a critical input for the PMT function
Ready to go further?
Related questions