financial functions Flashcards Preview

Excel 1 > financial functions > Flashcards

Flashcards in financial functions Deck (6)
Loading flashcards...
1

functions needed to find installments given other info

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

how to calculate the principal value

PPMT (principal payment)

3

interest payment due for a given period for a loan or mortgage

IPMT

4

finding the desired interest rate for loan with known terms and constant installments

RATE

5

then theres the known functions....

FV, PV, NPV, IRR

6

return the rank of a number in a list of numbers

RANK.EQ
order---- 0 or omited means largest to smallest
1 means other way around