Old School Value blog

Empowering value investors with stock valuation, ideas and tutorials

Business Valuation: Basic and Premium Spreadsheets

July 15th, 2008

8 Comments

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.

———————————————–
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.
———————————————–

You may also like:

  1. Enter to Win Premium Spreadsheets and Books
  2. iGo Inc (IGOI) Q1 Business Valuation Update
  3. Fundamental Business Valuation Process
  4. Business Valuation of iGo Inc (IGOI): Part 2
  5. K-Tron (KTII) Business Valuation

Are your stocks cheap or overvalued? Check with the stock valuation spreadsheets

Tags: intrinsic value spreadsheet, Stock Analysis, valuation

8 Comments

  1. - dave miller

    Think they were referring to you. http://finance.groups.yahoo.com/group/smf_addin/message/4738

  2. - Jae Jun

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

  3. - psp627

    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

    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.

  5. - 100 seo tips

    Where is my post

  6. - Jae Jun

    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.

Leave a comment


(Required)


(Required and not published nor shared)