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
 
 
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
AAPL78%Apple169.95764.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-111%Microsoft82.5439.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-41%Cisco36.4925.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-71%Altria Group65.8338.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-318%Activision Blizzard63.9315.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-202%Lear Corp176.4758.39-2.00%5.00%4.00%3.50%12.00%30%10451163920%1,8781,386-4925354434774965166,14912-31-12
10
GME39%GameStop Inc.16.4327.11-5.00%-5.00%-5.00%0.00%12.00%30%13842365135%627171-4564734494264053852,72901-28-12
11
APOL100%Apollo Group0.0046.88-6.00%-6.00%5.00%2.00%10.00%100%12646071836%782332-4504604324064264485,75802-29-12
12
CMI-11%Cummins159.63143.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-49%Molson Coors79.1853.053.50%3.50%3.50%2.00%10.00%30%18272490520%3,8463,546-30066568871273776310,03212-31-11
14
HRL6%Hormel Foods33.3535.581.00%8.50%9.00%3.50%8.50%25%27045770335%1,045807-23844334436639843411,15401-29-12
15
DV98%DeVry0.6542.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-70%Booz Allen Hamilton37.1721.898.00%6.00%5.00%3.50%10.00%30%14226937428%1721,2671,0952192502722863004,85012-31-11
18
NDAQ-149%NASDAQ OMX76.9330.908.00%8.00%8.00%3.50%12.00%80%18047773435%1,2292,4601,2314685055455896367,88612-31-11
19
ABC-60%AmeriSourceBergen77.4348.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-26%McKesson138.30109.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-163%Delphi Auto PLC102.2938.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-102%Amgen168.6583.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-104%Best Buy56.3227.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
BAX12%Baxter International63.9272.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-53%Unilever48.2831.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
TEVA77%Teva Pharmaceutical Industries Ltd13.0855.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
T7%AT&T34.6637.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