Vikrant Choudhary

Thursday, August 16, 2007

Equity per market value and debt calculation

1. price/ share : $12.40
2. share/issue : 1084

=> market capitalization = price/share * share/issue
= $13,499

DebtCalculation :

cash = $5024
Marektable secutities = $1713

Total cash equivalent = cash + marketable securities = 6737

Long term debt = 26,073
short term debt = 13,884
total debt = long+short = 39,957
Net debt = cash equivalent + total debt =

market value of debt

market price of debt(%) = 95%
market value of debt = Netdebt * market price =

enterprice value = market capitalization + market value of debt

Tuesday, August 14, 2007

Beta calculation

Beta :
Beta measure the volatility of the firm/stock w.r.t market.
if ( Beta > 0) => more volatile .... else less volatile.

NetBeta value of stock x = abs(Long cash Beta) - abs(short cash beta)

Beta of x for market m= Covariance(stock x, Maket m) / variance(m)

eg :

X X% diff from mean
M M% Diff with mean return










100000

100000




100055 0.00055 -0.003147525 100360 0.0036 -0.00282108 8.87942E-06

101706 0.016500924 0.0128034 102765 0.023963731 0.017542651 0.000224606

101100 -0.005958351 -0.009655875 101912 -0.008300491 -0.014721571 0.00014215
Average
0.003697525

0.00642108
0.000125212 Cov(x,m)
Variance
8.90233E-05

0.000177476











Beta
0.705512902