Switch To Product Links Languages Themes Feedback Sign Up Now
Loading...
Updating...
Please wait to edit...
Ready for editing X
Stock Analysis Calculater by jkt626  435 views
Embed in Website/Blog
$ Macros
 
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
Stock Analysis Worksheet : Put Your Money to Work - What you Need to Know to Invest in Stocks
Sources for Data:finance.yahoo.com
finance.google.com
Company Name:Shares Outstanding:
Stock Symbol:
Share Price:
Estimated Earnings/Share:Market Cap:$0.00
PEG Ratio:#DIV/0!
Earnings Growth Rate:0.00%Forward P/E:#DIV/0!
Book Value/Share:Price/Book Value:#DIV/0!
Dividend:Dividend Yield:#DIV/0!
Payout Ratio of Div:#DIV/0!
What is a 5-Year AAA Corp. Bond Yielding?
If you had enough money to buy the entire company, but instead bought a AAA 5 year Corp. Bond , how much would you earn?How much is the company expected to earn over the next 5 years based on the forecasted earnings growth or your own estimates?
5 YEAR AAA BondCompany Earnings Estimate
Year 1$0Year 1$0
Year 2$0Year 2$0
Year 3$0Year 3$0
Year 4$0Year 4$0
Year 5$0Year 5$0
Total:$0Total:$0
0will earn$0more than what the CD will earn
or#DIV/0!more than what the CD will earn
Note:If the CD earns more than the company will earn over the next 5 years, it's highly likely that the stock is overvalued
Determine a Future Value of what you believe the business could be worth in 5 years at either liquidation or assign an approximate P/E based on earnings in 5 years and enter a future value.
Future Value in 5 Years:$0(Defaults to Liquidation Value)
Determining the Present Value we must decide on what rate of return we will demand. That rate of return can be lower if we feel confident about our estimates being right and all others risks at hand too. If we are uncertain and there are other risk factors, we should then demand a higher rate of return. Choose from the range of "discount rates" below to determine a fair present value.
Present ValuePresent Value/ShareDiscount/Premium to Present Value
Am very confidentBond + 3%$0------------------#DIV/0!#DIV/0!
Am confidentBond + 4%$0------------------#DIV/0!#DIV/0!
Somewhat confidentBond + 5%$0------------------#DIV/0!#DIV/0!
Not so confidentBond + 6%$0------------------#DIV/0!#DIV/0!
Am uncertainBond + 7%$0------------------#DIV/0!#DIV/0!
Haven't a clueSHOULD NOT INVEST
100% = Fair Value
Estimated P/E in 5 years?12(Make close to what the earnings growth rate will be)
Future Value with Estimated P/E in 5 years:$0.00
Present ValuePresent Value/SharePremium or Discount of Present Value
Am very confidentBond + 3%$0------------------#DIV/0!#DIV/0!
Am confidentBond + 4%$0------------------#DIV/0!#DIV/0!
Somewhat confidentBond + 5%$0------------------#DIV/0!#DIV/0!
Not so confidentBond + 6%$0------------------#DIV/0!#DIV/0!
Am uncertainBond + 7%$0------------------#DIV/0!#DIV/0!
Haven't a clueSHOULD NOT INVEST
* Use this calculator solely as a guide to help you determine whether from a quantitative viewpoint the stock is undervalued, fairly valued or overvalued. Use of this form shall not hold Jason Tillberg responsible from loss of capital invested in the stock markets. Investing in the stock markets bares risk of capital loss. Consult with a financial professional to determine your current financial position and goals makes it prudent to invest in stocks.
Sheet1
Sheet2
Sheet3
 
     
Processing...
Assign Macro Edit Label More