With increasing prices in food, commodities and inflation, I have decided to distribute the spreadsheets via an alternative method.
The spreadsheets have now been split into a basic and premium version.
The basic spreadsheets are the free versions which now only contain the financial statements and a valuation page. After using it, I hope that users will want to upgrade to the premium version.
The different premium spreadsheets available are:
- 10 year Graham Valuation Spreadsheet
- 10 year Discounted Cash Flow Spreadsheet
- 10 year Graham + DCF spreadsheet
- 5 year Graham Valuation Spreadsheet
- 5 year DCF spreadsheet
- 5 year Graham + DCF spreadsheet
- Full package: 10 year Graham + DCF spreadsheet AND 5 year Graham + DCF spreadsheet
The premium spreadsheets include the following:
- Financial Statements
- Valuation (Either DCF or Graham Formula)
- Historical Stock Price Chart
- Competitor Information (new version integrated)
- Company Stat Charts (new version integrated)
Improvements to Free Version
- Updated user interface
- Easier to read with less inputs
- Formulas revised and edited
- Ranges and cells revised and edited
- All spreadsheets combined
A lot of thought and effort has gone into this spreadsheet over the months in editing and updating and I believe the price is very small compared to that. I also believe it will greatly benefit and help you investigate a company.
For more pricing information, please click here.
———————————————–
Affordable and cheap web hosting package with dedicated hosting services at only 2.75/m. Great offers domain name registration, renew or transfer you existing domain. Register you domain name today and get free web design service.
———————————————–
Think they were referring to you. http://finance.groups.yahoo.com/group/smf_addin/message/4738
Yes maybe, but I’ve received permission to sell a spreadsheet that uses the add in. NOT selling the add in.
Jae,
Great site, I was recently drawn to your site from Seeking Alpha. I was wondering how to you calculate the historical intrinsic value that you charted in the Apple Intrinsic value example. Do you use actual cash flow and growth in the early years and then your estimates for the later years? I appreciate the response.
Hi psp627. Always nice to have a new visitor.
You got it spot on.
e.g. if Im calculating the intrinsic value for 1998, I would use the actual cash flow data from 1998-2007 and then use my projected estimate cash flows from 2008-2017 and then find the NPV.
Same method applies to each year thereafter.
Then you have to get the historical stock price from 1998-2007 and draw the graph.
Hope that helps.
[...] the companies through the intrinsic value spreadsheet with the PE as the growth rate, but capped at 15%. The selected companies shall [...]
[...] the companies through the intrinsic value spreadsheet with the PE as the growth rate, but capped at 15%. The selected companies shall [...]
Where is my post
Sorry but it was moderated for having keywords instead of a name. We would prefer to refer to people by aliases rather than 100 seo tips.