financial functions Flashcards Preview

Excel 1 > financial functions > Flashcards

Flashcards in financial functions Deck (6)
Loading 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