Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
9 Cards in this Set
- Front
- Back
=effect() |
Calculates the annual percentage rate for an interest rate, given the number of times per year that interest is charged |
|
=nper() |
Calculates the number of payments that will be made to pay off a loan given the interest rate, payment amount, and original loan amount. |
|
=pmt() |
Calculates the payment amount for a loan given the interest rate, number of payments to be made to pay off the loan, and the original loan amount. |
|
=pv() |
Calculates the given CURRENT VALUE (accounting for compounding interest) of an investment given the interest rate, number of payments to be made, and the amount of the payment. |
|
=fv() |
Calculates the FUTURE VALUE of an investment given the interest rate, number of payments to be made, and the amount of the payment. |
|
=rate() |
Calculates the interest rate earned for an investment given the number of payments, made as part of the investment, the payment amount, and the current value of the investment. |
|
=counta() |
Counts the number of cells in a range of cells that are not blank. |
|
=count() |
Counts the number of cells in a range of cells that contains numbers. |
|
=correl() |
Calculates the correlation coefficient between two sets of values. |