EXCEL chapter 7 terms

Calculates the number of periods for an investment or loan given a fixed rate, period payment, and present value.

NPER

Calculates the future value of an investment given a fixed rate, a term, and identical periodic payments.

FV

Calculates the net present value of an investment with a fixed rate and periodic payments that may be identical or different.

NPV

Calculates cumulative principal for a specified payment period.

CUMPRINC

Calculates the present value of an investment with a fixed rate, specified number of periods, and identical periodic payments that will be made in the future.

PV

Calculates cumulative interest for a specified payment period.

CUMIPMT

A schedule showing monthly payments, interest per payment, amount toward paying off the loan, and the remaining balance for each payment.

Loan Amortization Table

Calculates the principal payment for a specified payment period on a loan or an investment given a fixed rate, a specified term, and identical periodic payments.

PPMT

Calculates periodic interest for a specific payment period on a loan or investment with a fixed rate, a specified term, and identical periodic payments.

IPMT

Returns the average of all cells that meet multiple criteria.

AVERAGEIFS

A type of chart that displays a visual representation of geographic regions to illustrate relative values.

Map Chart

Returns a number representing the day of the week where 1 represents Sunday and 7 represents Saturday by default.

WEEKDAY

Calculates the total of a range of values when a specified condition is met.

SUMIF

A logical function that evaluates multiple conditions and returns a result that corresponds with the first true condition.

IFS

Calculates the fraction of a year between two dates based on the number of whole days.

YEARFRAC

Returns the number of cells that meet a condition.

COUNTIF

Extracts the year from a date.

YEAR

Calculates the total of a range of values when multiple conditions are met.

SUMIFS

Returns TRUE if any argument is true and returns FALSE if all arguments are false.

OR

Returns TRUE when all arguments are true and FALSE when at least one argument is false.

AND