Ultimate Stock Finder Housekeeping - Important Message:
We are still having a data integrity problem in MutualFundEvaluator.xls. Our Ultimate Stock Finder web query program is not able to retrieve the "52 Week Low" values from our preferred website due to changes in the format at that website. We are working on a solution to this problem, but for now the "52 Week Low" values in MutualFundEvaluator.xls have all been replaced with "1" to prevent the Red cell count from returning an error code. We are NOT seeing this problem in StockEvaluator.xls. Please be sure to let me know if you ever find any bad data in our spreadsheets because we want to fix it.
This Week's Activity:
This week Tesla Motors (TSLA) jumped from $55 to $76 (38%) due to surprising the market by reporting a first ever profit for the most recent quarter. TSLA carries a staggering Debt to Equity of 374%, so I am not willing to buy them. But for anyone who did buy, this was sure a good week.
My former employer ViaSat (VSAT) jumped from $49 to $58 (18%) due to no official news, but the hope by the market that VSAT will report good quarterly numbers next week on May 16. We will keep an eye on that report.
Several of you have asked me about annuities, so I made an "annuity_calculator.xls" spreadsheet that compares a Schwab variable annuity that guarantees 5% payout on $100,000 for your lifetime versus investing this same money yourself in a very safe bond fund like PRGMX in a self directed account.
Download these 2 documents at www.ultimatestockfinder.com "Investment Training" webpage:
schwab_annuity_example.ppt
Schwab shows their annuity where you start taking payouts at age 65, and then the annuity surrender value (also called residual value or death benefit) drops every year until reaching $0 at age 93.
annuity_calculator.xls
This Excel spreadsheet shows a self directed account that you manage where you start taking payments at age 65, and the invested value (same as residual value or death benefit) drops a lot slower because you are not paying the annuity provider. You can change your current age and expected rates of return for your self directed account to match your estimate of what rate of return you expect to earn over the next 30 years.
The bottom line is that by age 85, the annuity residual value (death benefit) has dropped to $46,000 and the self directed invested value (death benefit) is worth $147,000. At that point, you have paid the annuity provider $100,000 for giving you a secure guaranteed income for life.
Next Monthly Meeting 2nd Tuesday of every Month:
Tuesday, May 14, 2013 , 7:30 PM at my house.
Here are my Buys for May 2013:
Buy Company Buy
Date Bought Price Target Sell
----- --------- ------ -------------
none
Here are my Sells for May 2013:
Sell Company Sell Buy Buy
Date Sold Price Price Date
------- ---------- ------- ------- ------------
none
StockEvaluator.xls and Mutual FundEvaluator.xls are available for download atwww.ultimatestockfinder.com
Remember to send me any other stocks or mutual funds that you would like to see added to the Evaluator spreadsheets, and any other investing ideas, information or questions that you want to share.
Thanks,
John D.
____________________________________________________________________
Visit Our Website UltimateStockFinder.com for More Investing Ideas:
All the Yahoo!Finance data is refreshed on Saturday morning into StockEvaluator.xls and contains over 2,100 company stocks. We will add any company you would like to the list. Download "StockEvaluator.xls spreadsheet" at: http://www.ultimatestockfinder.com/
MutualFundEvaluator.xls is also updated weekly and currently contains over 650 mutual funds.
Also, View our YouTube training videos.
Run the various Ctrl-_ sort commands in StockEvaluator.xls and MutualFundEvaluator.xls to bring the best companies to the top based on their key financial values.
At "Web Search Links" you can find our favorite links for good investing information including:
Screener for New 52 week lows
Screener for Good Fundamental Values
Screener for Stocks with High Volatility
CNN links that show current P/E values for the major worldwide indexes.
At "Investment Training" read more information on how we do our investments.
"How We Use PUTs and CALLs to Minimize Risk and Increase Profit on Each Buy & Sell"
"S&P 500 Total Return Comparison" spreadsheet for 25 year comparisons of many funds
"Compare Annuity Returns, Expenses and Death Benefit v.s. Managing it Yourself"
At "Stock Evaluator" download various pre-sorted views this week's StockEvaluator.xls
also, sign in and view the Ultimate Stock Finder watchlist on Yahoo Finance
Visit Our Blog and Facebook pages:
No comments:
Post a Comment