financial functions Flashcards
1
Q
functions needed to find installments given other info
A
PMT()….. short for payment
note rate is for the payment periods in the function… might have to normalize
type: 0 means pay end of period, 1 pay upfront
2
Q
how to calculate the principal value
A
PPMT (principal payment)
3
Q
interest payment due for a given period for a loan or mortgage
A
IPMT
4
Q
finding the desired interest rate for loan with known terms and constant installments
A
RATE
5
Q
then theres the known functions….
A
FV, PV, NPV, IRR
6
Q
return the rank of a number in a list of numbers
A
RANK.EQ
order—- 0 or omited means largest to smallest
1 means other way around
