FI414 Valuation Model 2012
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
TickerDeviationStock NameCurrent PriceTarget Pricegrowth (y1)growth (y2)growth (y3-5)growth (y>=6)Discount RateROICshares outstandingNOPATEBITATax RateExcess CashGross DebtNet DebtFCF1FCF2FCF3FCF4FCF5Terminal ValueData Vintage
2
AAPL82%Apple140.75764.7733.00%14.00%10.00%3.50%12.00%150%94232,04443,30326%95,4904,295-91,19535,56944,60850,20555,22560,748743,03912-31-11
3
MSFT-66%Microsoft64.8839.156.00%9.00%8.50%3.50%12.00%120%8,46520,30827,07725%57,60221,667-35,93520,51121,84923,79625,81928,013342,30212-31-11
4
CSCO-32%Cisco34.0625.8313.50%8.50%8.50%3.50%12.00%50%5,4017,8869,85720%48,20123,001-25,2006,8218,1898,8859,64110,460135,71101-28-12
5
MO-91%Altria Group73.4238.415.00%5.00%4.00%3.00%9.00%80%2,0424,2056,27633%21,93718,677-3,2604,1524,3604,5904,7734,96483,65412-31-11
6
ATVI-220%Activision Blizzard48.9615.285.00%4.00%3.50%3.50%11.00%40%1,1471,0931,36620%3,315174-3,1411,0111,0791,1311,1701,21116,09712-31-11
7
SNDK-31%SanDisk Corporation76.1858.11-5.00%5.00%5.00%3.50%12.00%25%2471,0711,53030%5,0102,017-2,9931,2328659089531,00112,51301-01-12
8
CFN-81%CareFusion59.9433.178.00%5.00%4.00%3.50%9.00%25%22739160235%2,6161,898-7182973593904064227,80512-31-11
9
LEA-136%Lear Corp137.6358.39-2.00%5.00%4.00%3.50%12.00%30%10451163920%1,8781,386-4925354434774965166,14912-31-12
10
GME23%GameStop Inc.20.9127.11-5.00%-5.00%-5.00%0.00%12.00%30%13842365135%627171-4564734494264053852,72901-28-12
11
APOL79%Apollo Group9.9946.88-6.00%-6.00%5.00%2.00%10.00%100%12646071836%782332-4504604324064264485,75802-29-12
12
CMI-5%Cummins150.82143.3214.00%12.00%12.00%3.50%12.00%35%1921,7922,56030%2,9432,547-3961,3261,5881,7781,9912,23034,03612-31-11
13
TAP-83%Molson Coors97.1153.053.50%3.50%3.50%2.00%10.00%30%18272490520%3,8463,546-30066568871273776310,03212-31-11
14
HRL3%Hormel Foods34.5235.581.00%8.50%9.00%3.50%8.50%25%27045770335%1,045807-23844334436639843411,15401-29-12
15
DV22%DeVry33.2842.64-5.00%-5.00%3.00%2.00%10.00%100%6823334332%26679-1872332222102172232,81812-31-11
16
FDO1%Family Dollar79.4279.8914.00%14.00%14.00%3.50%9.00%25%11843067236%15279664424928432437042112,94802-25-12
17
BAH-66%Booz Allen Hamilton36.3721.898.00%6.00%5.00%3.50%10.00%30%14226937428%1721,2671,0952192502722863004,85012-31-11
18
NDAQ-127%NASDAQ OMX70.0230.908.00%8.00%8.00%3.50%12.00%80%18047773435%1,2292,4601,2314685055455896367,88612-31-11
19
ABC-79%AmeriSourceBergen86.4748.346.00%6.00%5.00%3.50%9.50%25%2638721,24530%8822,2191,33771575883287491816,24812-31-11
20
LO55%Lorillard71.40160.406.50%6.50%6.50%3.00%9.00%80%1341,1731,89238%1,6873,0361,3491,1541,2291,3091,3941,48525,78212-31-11
21
MCK-33%McKesson145.94109.6110.00%10.00%10.00%3.50%9.50%25%2511,5692,24230%3,5285,3951,8671,0991,2081,3291,4621,60836,22812-31-11
22
DLPH-103%Delphi Auto PLC78.8738.861.50%5.00%4.00%3.50%12.00%30%3281,3401,67520%1,5983,8352,2371,2931,2011,2951,3471,40016,69412-31-12
23
AMGN-98%Amgen165.6683.524.50%4.50%4.50%3.50%9.00%30%8614,2625,32720%21,38624,1722,7863,8143,9864,1654,3534,54885,29412-31-11
24
BBY-62%Best Buy44.8627.62-4.00%-3.00%-2.00%2.00%12.00%20%3481,5282,35035%2213,9733,7521,7721,6421,5361,5051,47512,04912-31-11
25
BAX28%Baxter International52.1072.837.00%7.00%6.50%3.50%9.00%25%5662,4703,08820%3,9658,0774,1121,9522,0882,2772,4252,58253,42212-31-11
26
UNA-48%Unilever46.6031.477.50%7.50%7.50%3.50%9.00%40%2,9105,1766,90125%6,54220,00513,4634,5934,9385,3085,7066,134123,27812-31-11
27
TEVA41%Teva Pharmaceutical Industries Ltd32.6755.7114.00%5.50%5.00%3.50%9.00%20%8863,6234,02510%1,31315,77014,4571,5943,2213,4853,6603,84375,65312-31-11
28
T-12%AT&T41.6537.237.50%5.50%4.50%3.00%8.00%15%593318,07122,58920%9,428111,721102,29310,39113,37215,26915,95616,674374,21112-31-11
29
Loading...
 
 
 
DCF