Which function is used for regular, equal payments in time-value calculations?

Which function is used for regular, equal payments in time-value calculations?

• A. PV
• B. NPV
• C. FV
• D. PMT

Answer: (A)

Regular, equal payments over time are modeled with the PMT function. PMT calculates the fixed periodic payment required to amortize a loan or fund an annuity, given a periodic interest rate, the number of periods, and the amount financed (present value) or desired future value. It’s specifically designed for scenarios where payments are constant each period. Understanding the others helps see why PMT is the right tool: PV determines how much a future set of cash flows is worth today, FV projects what today’s amount will grow into in the future, and NPV sums the net value of a series of cash flows at a given discount rate. None of these directly solves for the fixed periodic payment—that’s PMT. For example, to find the monthly payment on a loan, you’d use PMT with the monthly rate, total months, and loan amount, noting that payments are typically shown as a negative value to reflect cash outflows.

Regular, equal payments over time are modeled with the PMT function. PMT calculates the fixed periodic payment required to amortize a loan or fund an annuity, given a periodic interest rate, the number of periods, and the amount financed (present value) or desired future value. It’s specifically designed for scenarios where payments are constant each period.

Understanding the others helps see why PMT is the right tool: PV determines how much a future set of cash flows is worth today, FV projects what today’s amount will grow into in the future, and NPV sums the net value of a series of cash flows at a given discount rate. None of these directly solves for the fixed periodic payment—that’s PMT. For example, to find the monthly payment on a loan, you’d use PMT with the monthly rate, total months, and loan amount, noting that payments are typically shown as a negative value to reflect cash outflows.