Send a link to your students to track their progress
19 Terms
1
New cards
PMT function
A financial function that calculates the periodic payment for a loan based on constant payments and a constant interest rate.
2
New cards
RATE function
A financial function used to calculate the interest rate per period of an annuity or loan.
3
New cards
NPER function
A financial function that returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
4
New cards
CUMIPMT function
A financial function that calculates the cumulative interest paid on a loan between a starting period and an ending period.
5
New cards
CUMPRINC function
A financial function that calculates the cumulative principal paid on a loan between a starting period and an ending period.
6
New cards
Amortization schedule
A table that calculates the interest and principal payments along with the remaining balance of the loan for each period.
7
New cards
PPMT function
A financial function that calculates how much of a specific periodic payment is going toward the principal amount of a loan.
8
New cards
IPMT function
A financial function that calculates the interest payment for a specific period of an investment based on periodic, constant payments and a constant interest rate.
9
New cards
Principal
The original amount of money borrowed or the amount still owed on a loan, separate from interest.
10
New cards
Interest
The cost of borrowing money, usually expressed as an annual percentage rate (APR).
11
New cards
Periodic rate
The interest rate charged per period, such as monthly or quarterly (calculated as Annual Rate divided by number of periods per year).
12
New cards
Fv
An argument used for the future value or the cash balance you want to attain after the last payment is made (usually 0 for loans).
13
New cards
Pv
The present value, or the total amount that a series of future payments is worth now
14
New cards
for a loan, this is the amount borrowed.
15
New cards
Type
An argument (0 or 1) that indicates when payments are due: 0 at the end of the period, 1 at the beginning.
16
New cards
Loan analysis
The process of evaluating a loan's terms, including the monthly payment, total interest paid, and total cost of the loan.
17
New cards
Cash flow
The movement of cash into and out of a business or personal account, often categorized as positive (inflow) or negative (outflow).
18
New cards
Beginning balance
The amount owed on a loan at the start of a specific period in an amortization schedule.
19
New cards
Ending balance
The remaining principal on a loan after the principal portion of the current payment has been subtracted from the beginning balance