Formulas Flashcards
Accounting Rate of Return (ARR)
annual % return on the project
ARR = Average annual profit / average (or initial investment)
Average investment = Initial outlay + scrap value / 2
Money rate of interest
(real cost of capital - to get discount factor)
(1 + m) = (1 + r) (1 + i)
m= money rate
r = real rate (assume 10%)
i= general inflation (assume 5%)
Equivalent annual cost (EAC)
represents a constant annual cashflow that has the same PV as the actual under each proposal
EAC = NPV / annuity factor for the project life
Profitability Index
to score single period rationing
Profitability Index = NPV / Initial Investment
Sensitivity - variable impacting on cashflows
the sensitivity to a change in a variables cost/price or volume
Sensitivity = NPV of project / PV of cashflows impacted by variable
Sensitivity - cost of capital
the sensitivity to a change in discount factor
Sensitivity = IRR - Cost of Capital / Cost of Capital
Correlation Coefficient
indicates the strength and direction of a relationship between variables
=CORREL(cell range for array 1, cell range for array 2)
Standard deviation
average amount of variability in a data set, showing how far, on average, each results lies from the mean
=STDEV(cell range)
Expected values
is the probability-weighted average of the possible outcomes
Expected value = probability of the outcome x the outcome
CAPM
ππ = ππ + π·π(ππ β ππ)
rm = market rate
rf = risk free rate
π· = Beta
Theoretical Ex-Rights Price (TERP)
Market capitalisation pre-rights issues + rights proceeds + project NPV / Total number of shares after the rights issue
The dividend valuation model - ke
ke = (Do (1 + g) / Po) + g
Po = Current ex-div share price
Do = Current dividend
g = growth in dividends
ke = cost of equity
Growth - geometric average
= POWER (most recent value/ oldest value, 1/ number of period of growth)
Growth - historical pattern
g = rb
r = PAT / Opening shareholdersβ funds
b = proportion of profits retained
CAPM - ke
ke = ππ + π·π(ππ β ππ)
rm = market rate
rf = risk free rate
π· = Beta