Intrinsic Value Calculation

Inputs Default Input Values (used for calculations)
Your Investment Horizon in Years (Max of 10): 5 5
Most Recent Reported EPS (Earnings Per Share): #N/A 0.1151
Projected EPS Growth Rate: #N/A 15.00%
Projected Average Annual PE Ratio: NA 10
Average Dividend Payout Ratio: #VALUE! 35%
Desired Minimum Annual Return: NA 10%
Current Stock Price NA $1.40


Calculations
Estimated Earnings Per Share after year 5: $0.23
Forecasted Stock Price after 5 Years: $2.32
Total Estimated Dividends for the next 5 Years: $0.08
Total Estimated Stock Value after 5 Years: $2.40
Current Share Price: $1.40
Estimated Intrinsic Value: $1.49
Estimated Margin of Safety: -6.27%


-----------------



Inputs Default Input Values (used for calculations)
Your Investment Horizon in Years (Max of 10): 5 5
Most Recent Reported EPS (Earnings Per Share): #N/A 0.1151
Projected EPS Growth Rate: #N/A 10.00%
Projected Average Annual PE Ratio: NA 10
Average Dividend Payout Ratio: #VALUE! 35%
Desired Minimum Annual Return: NA 15%
Current Stock Price NA $1.40

Calculations
Estimated Earnings Per Share after year 5: $0.19
Forecasted Stock Price after 5 Years: $1.85
Total Estimated Dividends for the next 5 Years: $0.06
Total Estimated Stock Value after 5 Years: $1.92
Current Share Price: $1.40
Estimated Intrinsic Value: $0.95
Estimated Margin of Safety: 31.87%
---------------

http://smartstockresearch.com/InvestingBasics/Articles/Stock-Analysis-Spreadsheet.html

More Topics 
How To Research A Stock 
How To Generate Investing Ideas 
What To Know Before You Begin Investing 
Why Invest Now? 
What Type of Investor are You? 
Is Investing in Stocks Like Gambling? 
What Does a Stock's Price Tell You? 
How To Read a Balance Sheet 
How To Read an Income Statement 
How To Read a Cash Flow Statement 
Why Read the Annual Report? 
Should You Be An Investor or Trader?

Online Investing Guide 
Where to Learn How To Invest 
Online Brokers 
Where to Get Stock Ideas 
Where to Get Basic Company Information 
Where to Get News, Opinions, and Advice 
Where to Get Analyst Research 
Where to Get Economic Information