US dollar risk free rate =		3,04%
Mature market ERP =		5,00%			#NAME?		#NUM!
Company Name	Exchange:Ticker	Industry Group	Country	Broad Group	Sub Group	Bottom up Beta for sector	Bottom up levered beta	ERP for Country	Cost of equity in US$	Total Default Spread for cost of debt (Company + Country)	Pre-tax cost of debt in US $	After-tax cost of debt in US $	Cost of capital in US$	ROE - Cost of Equity	ROIC - Cost of Capital	Market Cap (in US $)	PV of lease debt	Total Debt	Total Debt incl leases (in US $)	Firm Value (in US $)	Cash	Enterprise Value (in US $)	Cash/ Firm Value	Liquidity Ratio (Daily trading volume/Shrs outs)	Book Debt to capital ratio	Market Debt to capital ratio	Book Debt to Equity Ratio	Market Debt to Equity ratio	Stock price (Dec 31, 2012)in US$	Beta	Correlation with market	Standard deviation in stock price	HiL0 Risk Measure (Hi- lo)/ (Hi+Lo)	Interest coverage ratio	Current PE	Trailing PE	Forward PE	PEG	PBV	PS	EV/EBIT	EV/EBITDA	EV/Invested Capital	EV/Sales	Payout ratio	Dividend Yield	Historical growth in Net Income - Last 3 years	Historical growth in Net Income - Last 5 years	Historical growth in Revenues - Last 3 years	Historical growth in Revenues - Last 5 years	Expected growth rate in EPS- Next 5 years	Expected growth in revenues - Next 2 years	Return on Equity	Return on Capital (ROC or ROIC)	Net Profit Margin	Pre-tax Operating Margin	Effective Tax Rate	% held by institutions	Net Income	Trailing Net Income	Operating Income	Trailing Operating Income (adj for leases)	Revenues	Trailing Revenues	EBITDA	Trailing EBITDA	EBIT (1-t)	Net Debt issued (Debt issue - repaid)	Change in non-cash Working capital	Net Cap Ex	Reinvestment Rate	FCFF	FCFE	FCFE without debt	Book Value of Equity - 4 qtrs ago	Invested Capital - 4 qtre ago	Current Book Value of Equity	Current Invested Capital	Dividends	Modified 2-year beta	Modified 5-year beta	Beta adjustment factor	Coeff of variation - Op Income	Coeff of variation - Net Income	Average 10-year EBIT	Average 10-yr Net Income	Dividends + Buybacks	CRP	Country Marginal tax rate
Akbank T.A.S. (IBSE:AKBNK)	IBSE:AKBNK	Bank	Turkey	Developed Europe	EU & Environs	0,4029	1,0245	8,30%	11,54%	3,70%	6,74%	5,32%	7,38%	3,63%	-7,17%	$12 484,90	$0,00	$25 313,00	$25 313,00	$37 797,90	$748,40	$37 049,50	1,98%	0,01	70,16%	66,97%	235,13%	202,75%	$3,12	2,20	50,50%	62,38%	0,27	NA	7,41	7,16	8,25	0,73	1,16	3,26	517,45	NA	1,05	9,66	16,19%	2,26%	5,55%	12,30%	10,20%	11,90%	10,20%	12,50%	15,17%	0,21%	43,57%	1,79%	23,91%	26,31%	$1 683,80	$1 744,80	$0,00	$71,60	$3 834,80	$4 004,80	$0,00	$0,00	$54,48	-$1 465,00	$0,00	$1 936,90	3555,26%	-$1 882,42	$1 272,90	-$192,10	$11 505,40	$33 892,50	$10 765,60	$35 330,20	-$282,40	1,26	0,77	0,50	NA	0,03	NA	$1 388,71	-$282,40	3,30%	21%

-> download data from Reuters or Bloomberg for a sector for which you will preprae model (expected approach) -> if don't know how to do it, take the database from this file =>>> (less points) -> estimate model for PB which will have R2 >= 55% F prepare a 10 minute presentation which will explain your approach and economic interpretation of your model -> download data from Reuters or Bloomberg for a sector for which you will preprae model (expected approach) -> if don't know how to do it, take the database from this file =>>> (less points) -> estimate model for PB which will have R2 >= 55% F prepare a 10 minute presentation which will explain your approach and economic interpretation of your model