Value Determinator
Powered by Excel®
Instructions

Value a Stock in 4 Steps          
1. Decide on the company you would like to evaluate.  This should be a company that you understand enough to be 
able to come to a general conclusion on its future earnings prospects.        
             
2.  Enter the stock symbol, date, and current stock price in the green spaces provided.    
             
3.  Go to MSN® Annual Balance Sheet Data Click here to go to MSN® Annual Balance Sheet Data  
Enter the stock symbol and click "Go"          
Enter the latest Common Shares Outstanding, Total Equity, and Intangible Assets in the green spaces provided.  
Note: The Common Shares Outstanding must be entered in the same value as the balance sheet data such as in thousands, 
millions, or billions.            
             
4. Switch from the MSN® Annual Balance Sheet Data to the Annual Income Statement Data  
Examine the Historical Normalized Income and project the future earnings in the green spaces provided.  
Remember to not blindly extrapolate from current trends and base the earnings on changes in the level of differentiation from 
competitors and the level of demand.          
Note: For advanced users, update the 10-Year US Treasury Note Yield in the green space provided.