Financial Math Flashcards
What is the basic rule of financial math?
you can only compare/combine cash-flows when they are in the same point in time
What types of cash-flows are there?
Inflows (positive) and outflows (negative)
Why do we use the future-value formula?
To move one cash-flow forward in time (cash-flow needs to be compounded).
Why do we use the present-value formula?
To move one cash-flow back in time (cash-flow needs to be discounted).
What are the conditions for the present-value and future-value formulas?
1) T>t
2) the end of the periods are counted in the same frequency as the discount/compounding rate
What is the formula of a future stream of cash-flows?
T∑i=t CFi/(1 + r)^(i-t)
What is the formula of a present value of a stream of future cash-flows and its condition?
PV=T∑i=t CFt/(1 + r)^t
The 1st element must already be at time 0.
What is the Net Present Value?
The NPV is a tool that allows us to evaluate the quality of a potential investment. It represents the wealth creation associated with the project’s implementation.
NPV0 = PV(Future Benefits) - PV(Future Costs)
What is the Net Present Value’s formula?
NPV = -I0 + T∑t=1 CFt/(1 + r)^t
(I0 initial investment)
What is the Net Present Value’s formula in excel?
NPV(rate, value 1, [ value 2],…) and then subtract the initial investment
rate is the rate of discount, only 1st value is required
When should we use perpetuities and annuities?
We use perpetuities and annuities when cash-flows follow a regular pattern.
What is a perpetuity?
A perpetuity is an infinite sequence of cash-flows with a constant growth rate (positive, negative or zero).
What is the formula for the perpetuity?
Vt-1 = CFt/(r-g)
What are the conditions to use the perpetuity formula?
1) r>g
2) r and g need to be in the same frequency as the sequence of cash-flows
3) r and g need to be constant
4) the only cash-flow to insert is the same
What is the formula to find one cash-flow knowing another one?
CFT = CFt * (1 + g)^(T-t)
if g is constant
What is an annuity?
An annuity is a finite sequence of cash-flows with a constant growth rate (positive, negative or zero).
What is the formula for annuities?
Vt-1 = CFt/(r - g) * [ 1- ((1+ g)/(1 + r))^N]
How do you calculate N?
N = Last - First + 1
What are the conditions to use the annuity’s formula?
1) only cash-flow you insert is the first
2) r and g need to be constant
3) r is different from g
4)r and g need to be in the same frequency as the cash-flows
How can you decompose the annuity’s formula?
V0(Annuity) = V0(Perpetuity) - ((1 + g)/(1 + r))^N * V0(Perpetuity)
What is the annuity’s formula in Excel?
PV(rate, nper, pmt, [ fv])
rate is the interest rate
nper is the number of payments
pmt is the payment each period (g needs to be 0)
fv is optional and it means the cash balance you want to attain after the last payment is made
What is the excel formula to find a cash-flow within an annuity?
PMT(rate, nper, pv, [ fv])
nper is the number of payments
pv is the present value of the annuity
fv is optional and it means the cash balance you want to attain after the last payment is made
What is an effective interest rate?
An interest rate that incorporates compounded interest.
What is an annual percentage rate (APR)?
Interest rates that only incorporate simple interest and not compounded interests.
