|PERL - Plan For Early Retirement and Life Tools|
1. A Major performance and functionality upgrade to the spreadsheet financial independence planning tool - CERP - Contender Early Retirement Planner.
2. Introducing a NEW Stock Screening Tool CISS (Contender Investment Stock Screener) to identify good companies that are potentially undervalued. This is done by automatically down loading and analysing the information of up to 3,000 stocks
The crazy thing about all of this is that all of this is being offered TOTALLY FREE!
Get yours today :)
CERP - Contender Early Retirement Planner
- Plan your monthly budget
- Calculate early retirement goals
- Dividend, growth and protect portfolio management which automatically retrieve stock data from Yahoo Finance
- Stock analysis tools and progress tracking
- Strategy sheets to plan for success
- It is FREE as is Open office and Java *See end of post for setup instructions. THE.CONTENDER wants this to be available to everyone hence the choice of open office. There is a slightly less detailed version in excel available on the tools download page.
The open office financial analysis tool has been enhanced to remove the slow GetQuote add-in. A magic macro :) downloads the data from Yahoo instead.
This has made the whole spreadsheet about 10x faster and has provided access to lots of new financial data. Here is a screenshot of the stock analysis spreadsheet:
|Stock Analysis - Click for a larger image|
- Is the debt compared to the equity in the company too high?
- Is the dividend payout ratio (dividend rate / earnings per share) sustainable
- What has been the year on year increase in the dividends?
- Dividend discount model to ESTIMATE the intrinsic worth of the company
|Portfolio view - Click for larger image|
- An automatic Yahoo hyperlink has been added for each stock
- Company names are now automatically added
- Dividend discount model is available (a way to value dividend stocks - are they overpriced?)
- Useful links have been added below the tables to the financial checks and some useful financial resources
- Cells have conditional formatting to highlight opportunities or concerns such as where dividend payouts are greater than earnings.
CLICK HERE FOR YOUR FREE DOWNLOAD (Open Office)Please read on for CISS the NEW stock screen tool that can download and analyse 3000 stocks at a time.
CISS - Contender Investment Stock Screen
How do you screen for value \ growth stocks to add to the GROW portfolio? THE.CONTENDER has used paid investment letters down the years to do this for him such as:
The Complete Investor - several balanced portfolios in lots of different areas (good for HYP and GROWTH portfolio)
Outstanding Investments - more focused on material scarcity (good for ALL portfolio's)
The Morgan Report - silver focused investment letter (GROWTH portfolio)
This was a wise move in some respects as professional advice versus just guessing what stocks to buy turned out to be a good decision. The newsletters are informative and you find out about companies that you would never have heard of as well as in depth analysis of their performance and future prospects.
THE.CONTENDER does believe a financial newsletter is very useful, as a starting point, to learn about how professionals research stocks. Check out the books below and some background reading on Wikipedia to learn more about investing.
THE.CONTENDER now likes to research stocks himself. This has been done through recommendations from sites such as seeking alpha, dividend monk, and top yields as well as some of the investment themes all for income investing.
For growth we have typically relied on tracker funds but what about individual stocks? To look for some growth stocks the principles of the two books below have been used to devise a stock screen tool:
- Choose up to 3000 stocks and down load the data by clicking the magic button into an excel spreadsheet (currently no open office version sorry)
- Data converted and cleaned up
- Data analyzed and sorted to provide value stock recommendations based on a well known investing approach.
|Yahoo download - click for larger picture|
- Using an excel spreadsheet provided by gummy-stuff.org with a few modifications to the code it is possible to download up to 3000 stocks into the spreadsheet:
- The data is then cleaned up and converted into usable data and an analysis based on the following 2 books:The Intelligent Investor (2003)
The little book that beats the market (2010)
Data cleanup and analysis - click for larger picture
- All of the stocks are ranked based on profitability and return on capital to give the final table.
|The results - click for a larger image|
Get On With It
We are still early days on these tools and feedback would be greatly appreciated. THE.CONTENDER will then Get on With It - tweak how the tools work, add user improvements or just plain simplify them as much as possible.
Please have a play. Go onto Yahoo Finance, The Financial Times, MSN money and have a look at the companies you find in more detail.
What do you think of them? What can you compare them to? Ultimately would you invest in them? Will they grow fast and will their returns be strong enough to propel you to financial independence / early retirement?*
Peace and ultimate prosperity
* Open Office Setup
- Install Open office
- Install Java (it is important there is only the latest version of java installed - uninstall any old versions)
- Open Open office Calc
- Go to Tools > options >
- Choose Java > select the latest version of Java
- Select Security and set macro security to medium - you will be asked each time you would like to use macros
|Click for Large Image|
|Click for Large Image|
Please read the disclaimer in the right hand side of the page. All tools are for education and information purposes only. They are free and have no warranty and are as accurate as possible to the best of the authors knowledge. Investing has risk this blog does not contain professional advice only the inquisitiveness of a private investor. Any feedback on the tools would be greatly appreciated so they can be improved as we go along.
Welcome New Contender Readers! Take a look around. Find out who THE.CONTENDER is or Start at the first article, browse the all posts or just go for a Random Post. Please feel free to play with the FREE planning tools and checklists.
Keep in Touch: RSS Feed, follow our tribe on Twitter or subscribe to posts by email: