What is the PMT Function?

The PMT attribute is categorized under financial Excel functionsFunctionsList of the the majority of essential Excel attributes for financial analysts. This cheat sheet covers 100s of functions that are important to understand as an Excel analyst. The function helps calculate the full payment (principal and interest) required to clear up a loan or an investment with a solved interemainder price over a details time duration.

You are watching: The fv function stands for ____.


=PMT(price, nper, pv, , )

The PMT function offers the adhering to arguments:

Rate (required argument) – The interest price of the loan.Nper (required argument) – Total number of payments for the loan taken.Pv (compelled argument) – The present worth or complete amount that a collection of future payments is worth currently. It is likewise termed as the primary of a loan.Fv (optional argument) – This is the future value or a cash balance we want to acquire after the last payment is made. If Fv is omitted, it is assumed to be 0 (zero), that is, the future worth of a loan is 0.Type (optional argument) – The kind of day count basis to usage. The feasible values of the basis are:


How to usage the PMT Function in Excel?

As a worksheet attribute, the PMT attribute have the right to be gotten in as component of a formula in a cell of a worksheet.To understand the offers of PMT, let us take into consideration an example:

Example 1

Let’s assume that we should invest in such a manner that, after two years, we’ll receive $75,000. The rate of interest is 3.5% per year and the payment will be made at the begin of each month. The details are:


The formula provided is:


We acquire the outcomes below:


The above attribute returns PMT as $3,240.20. This is the monthly cash outcirculation forced to realize $75,000 in 2 years. In this example:

The payments into the investment are on a monthly basis. Hence, the annual interemainder rate is converted to a monthly rate. Also, we converted the years right into months: 2*12 = 24.The argument is collection to 1 to show that the payment of the investment will certainly be made at the beginning of each period.As per the basic cash flow convention, outgoing payments are stood for by negative numbers and also incoming payments are stood for by positive numbers.As the worth went back is negative, it indicates an outgoing payment is to be made.The value $3,240.20 includes the principal and also interest but no taxes, reserve payments, or fees.

See more: Why Is The Renaissance Considered A Turning Point In History? ?

A few points to remember around the PMT Function:

#NUM! error – Occurs when:The offered price worth is much less than or equal to -1.The offered nper value is equal to 0.#VALUE! error – Occurs as soon as any type of of the disagreements gave are non-numeric.When calculating monthly or quarterly payments, we should convert annual interemainder prices or the variety of periods to months or quarters.If we wish to find out the total amount that was passist for the duration of the loan, we have to multiply the PMT as calculated by nper.

Click here to downfill the sample Excel file

Further resources

Thanks for reading CFI’s overview to crucial Excel functions! By taking the time to learn and master these attributes, you’ll substantially rate up your financial evaluation. To learn even more, inspect out these additional CFI resources: