Financial Modelling Formulas -

=ACCRINT(•)

=ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])

=PRICE(•)

=PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis])

=YIELD(•)

=YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])

=DURATION(•)

=DURATION(settlement, maturity, coupon, yld, frequency, [basis])

=MDURATION(•)

=MDURATION(settlement, maturity, coupon, yld, frequency, [basis])

=FV(•)

=FV(rate, nper, pmt, [pv], [type])

=IRR(•)

=IRR(values, [guess])

=NPV(•)

=NPV(rate, value1, [value2], ...) - Initial Investment

=PV(•)

=PV(rate, nper, pmt, [fv], [type])

=AVERAGE(•)

=AVERAGE(number1, [number2], ...)

=CHISQ.DIST(•)

=CHISQ.DIST(x, deg_freedom, cumulative)

=CHISQ.INV(•)

=CHISQ.INV(probability, deg_freedom)

=CHISQ.DIST.RT(•)

=CHISQ.DIST.RT(x, deg_freedom)

=CHISQ.INV.RT(•)

=CHISQ.INV.RT(probability, deg_freedom)

=CORREL(•)

=CORREL(array1, array2)

=COVAR(•)

=COVAR(array1, array2)

=KURT(•)

=KURT + 3, <3 means Platykurtic, >3 means leptokurtic

=LINEST(•)

=LINEST(known_y's, [known_x's], [const], [stats])

=INTERCEPT(•)

=INTERCEPT(known_y's, known_x's)

=SLOPE(•)

=SLOPE(known_y's, known_x's)

=RSQ(•)

=RSQ(known_y's, known_x's)

=FORECAST(•)

=FORECAST(x, known_y's, known_x's)

=MEDIAN(•)

=MEDIAN(number1, [number2], ...)

=NORM.DIST(•)

=NORM.DIST(x, mean, standard_dev, cumulative)

=NORM.INV(•)

=NORM.INV(probability, mean, standard_dev)

=NORM.S.DIST(•)

=NORM.S.DIST(z, cumulative)

=NORM.S.INV(•)

=NORM.S.INV(probability)

=PERCENTILE(•)

=PERCENTILE(array, k)

=SKEW(•)

=SKEW(number1, [number2], ...)

=STDEV(•)

=STDEV(number1, [number2], ...)

=STDEVP(•)

=STDEVP(number1, [number2], ...)

=T.DIST(•)

=T.DIST(x, deg_freedom, cumulative)

=T.INV(•)

=T.INV(probability, deg_freedom)

=VAR(•)

=VAR(number1, [number2], ...)

=VARP(•)

=VARP(number1, [number2], ...)

=ABS(•)

=ABS(number)

=COMBIN(•)

=COMBIN(number, number_chosen)

=EXP(•)

=EXP(number)

=LN(•)

=LN(number)

=MAX(•)

=MAX(number1, [number2], ...)

=MIN(•)

=MIN(number1, [number2], ...)

=RAND(•)

=RAND()

=SQRT(•)

=SQRT(number)

=SUM(•)

=SUM(number1, [number2], ...)

=SUMPRODUCT(•)

=SUMPRODUCT(array1, [array2], ...)

=FREQUENCY(•)

=FREQUENCY(data_array, bins_array)

=MINVERSE(•)

=MINVERSE(array)

=MMULT(•)

=MMULT(array1, array2)

=TRANSPOSE(•)

=TRANSPOSE(array)

=DATE(•)

=DATE(year, month, day)

=INDEX(•)

=INDEX(array, row_num, [column_num])

=AND(•)

=AND(logical1, [logical2], ...)

=IF(•)

=IF(logical_test, value_if_true, value_if_false)

RSS

=INDEX(LINEST(,y's, x's, TRUE, TRUE), 5, 2)

standard error

=SQRT(RSS/df)

or =INDEX(LINEST(,y's, x's, TRUE, TRUE), 3, 2)

Risk Neutral probability pi (probability of going up)

(r-d) / (u-d)

Bond Price change (as result of YTM change)

change P = -(duration / 1 + og YTM) change ytm Price

if possible, it is more accurate if you add + 1/2Convexityprice *(change ytm)^2

t statistic

= abnormal return / SE

Portfolio Variance:

if Var-cov matrix = I3:M7, and portfolio weights = I8:M8

=MMULT(I8:M8, MMULT(I3:M7, TRANSPOSE(I8:M8)))

Portfolio Standard Deviation

=SQRT(Portfolio Variance)