Excel Chapter 4
Predefined formulas that perform common business calculations, and which typically involve a period of time such as months or years.
The amount charged for the use of borrowed money.
In the Excel PMT function, the term used to indicate the interest rate for a loan.
Present Value (PV)
The total amount that a series of future payments is worth now.
Another term for present value
The abbreviation for number of time periods in various Excel functions.
Future Value (FV)
The value at the end of the time periods in an Excel functions; the cash balance you want to attain after the last payment is made-usually zero for loans.
The values that an Excel function uses to perform calculations or operations.
An Excel function that calculates the payment for a loan based on constant payments and at a constant interest rate.
An optional argument in the PMT function that assumes that the payment will be made at the end of each period.