Value Investing Based on Ben Graham, Phil Fisher, Warren Buffett, Joe Ponzio
Random header image... Refresh for more!

Blog > Investment Tools > Blog article: Basic and Premium Spreadsheets


Basic and Premium Spreadsheets

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:

  1. 10 year Graham Valuation Spreadsheet
  2. 10 year Discounted Cash Flow Spreadsheet
  3. 10 year Graham + DCF spreadsheet
  4. 5 year Graham Valuation Spreadsheet
  5. 5 year DCF spreadsheet
  6. 5 year Graham + DCF spreadsheet
  7. 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.

Outrageous? Too expensive? Let me know?

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • E-mail this story to a friend!
  • Google
  • Live
  • YahooMyWeb
  • Technorati
  • bodytext
  • StumbleUpon
  • TwitThis
  • del.icio.us
  • Facebook
You may also like:

4 comments

1 dave miller { 07.21.08 at 12:45 pm }
2 Jae Jun { 07.22.08 at 9:22 am }

Yes maybe, but I’ve received permission to sell a spreadsheet that uses the add in. NOT selling the add in.

3 psp627 { 07.22.08 at 6:14 pm }

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.

4 Jae Jun { 07.23.08 at 12:40 am }

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.

Leave a Comment