Loans & Installments

Financial ★ 30 · ◉ 19 · All versions

=CUMIPMT()

Returns the cumulative interest paid on a loan between start_period and end_period.

=CUMIPMT(rate, nper, pv, start_period, end_period, type)

Financial Calculations Loans & Installments

Examples → Description

Date & Time ★ 45 · ◉ 19 · All versions

=EDATE()

Returns the serial number that represents the date that is the indicated number of months before or after a specified date (the start_date). Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.

=EDATE(start_date, months)

Date & Time Calculations Workdays & Due Dates

Examples → Description

Financial ★ 60 · ◉ 18 · All versions

=PMT()

How to use the PMT function in Excel to calculate monthly loan payments based on constant payments and a constant interest rate.

=PMT(rate, nper, pv, [fv], [type])

Financial Calculations Loans & Installments

Examples → Description

Financial ★ 50 · ◉ 18 · All versions

=RATE()

Returns the interest rate per period of an annuity. RATE is calculated by iteration and can have zero or more solutions. If the successive results of RATE do not converge to within 0.0000001 after 20 iterations, RATE returns the #NUM! error value.

=RATE(nper, pmt, pv, [fv], [type], [guess])

Financial Calculations Loans & Installments

Examples → Description

Financial ★ 45 · ◉ 15 · All versions

=NPER()

Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.

=NPER(rate,pmt,pv,[fv],[type])

Financial Calculations Loans & Installments

Examples → Description

Financial ★ 35 · ◉ 14 · All versions

=EFFECT()

Returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year.

=EFFECT(nominal_rate, npery)

Financial Calculations Loans & Installments

Examples → Description

Financial ★ 30 · ◉ 14 · All versions

=NOMINAL()

Returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year.

=NOMINAL(effect_rate, npery)

Financial Calculations Loans & Installments

Examples → Description

Financial ★ 10 · ◉ 12 · All versions

=ISPMT()

Calculates the interest paid (or received) for the specified period of a loan (or investment) with even principal payments.

=ISPMT(rate, per, nper, pv)

Financial Calculations Loans & Installments

Examples → Description

Financial ★ 45 · ◉ 11 · All versions

=FV()

FV, one of the financial functions, calculates the future value of an investment based on a constant interest rate. You can use FV with either periodic, constant payments, or a single lump sum payment.

=FV(rate,nper,pmt,[pv],[type])

Financial Calculations Loans & Installments

Examples → Description

Financial ★ 45 · ◉ 11 · All versions

=PPMT()

Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.

=PPMT(rate, per, nper, pv, [fv], [type])

Financial Calculations Loans & Installments

Examples → Description

Financial ★ 45 · ◉ 9 · All versions

=PV()

PV, one of the financial functions, calculates the present value of a loan or an investment, based on a constant interest rate. You can use PV with either periodic, constant payments (such as a mortgage or other loan), or a future value that's your investment goal.

=PV(rate, nper, pmt, [fv], [type])

Financial Calculations Loans & Installments

Examples → Description

Financial ★ 45 · ◉ 8 · All versions

=IPMT()

Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.

=IPMT(rate, per, nper, pv, [fv], [type])

Financial Calculations Loans & Installments

Examples → Description

Financial ★ 30 · ◉ 6 · All versions

=CUMPRINC()

Returns the cumulative principal paid on a loan between start_period and end_period.

=CUMPRINC(rate, nper, pv, start_period, end_period, type)

Financial Calculations Loans & Installments

Examples → Description