CEM-Capitalized Earnings Model
Copyright 2013 ACBA - All Rights Reserved
BusinessAllstars.com


XL    Name   Date   
Proj 5-yr growth % Next Year's Normalized EPS     $
Proj Real GDP % Proj CPI inflation % Debt Cost r %
EPS / (.01*(g ^ -(5r + .5))) = Stock Value Cap Rate %
g = Long-term Growth rate ( ( Proj growth + (GDP + CPI) ) / 2 ) PE Ratio
/ ( .01 x ( ^ - ( 5 x + .5 ))) = Stock VALUE $

OVER or UNDER - Market Factors
Price Now
Insider Transactions (last 6 mo.) Price Comparison Data $
Purchases 52-week high $
Sales 52-week low $
Over or Under Over or Under O or U
Shrs Short Most Recent 50 day moving average $
Shrs Short Prior Month Analysts (buy, hold, or sell)
Over or Under PEG ratio


Enter Inputs in the YELLOW boxes