Old School Value blog

Empowering value investors with stock valuation, ideas and tutorials

Bond Rate for Graham Formula

August 10th, 2009

4 Comments

Seems like Yahoo is no longer updating the 20yr bond rate that I use for the Ben Graham Formula spreadsheet.

Whether you use the free or premium version, please change the cell formula to the following

=RCHGetTableCell(“http://finance.yahoo.com/bonds/composite_bond_rates“, 1,”>Corporate Bonds”,”>10yr AAA”, “>10yr AA”)

You may also like:

  1. Benjamin Graham Formula Free Stock Valuation Spreadsheet
  2. Choosing a Growth Rate
  3. How to Value a Stock with Benjamin Graham’s Formula
  4. EPS Affected by Tax Rate Changes
  5. Announcing Two New Ben Graham Screens

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

4 Comments

  1. - rupneu1

    so you are now using 10 year AA bond return then?
    .-= rupneu1´s last blog ..What now? =-.

  2. - Jae Jun

    Yes. It barely changes anything. 10Yr AA rate is just as good.

  3. - Scott

    Which cell is this on the premium version? This is for the Graham Instrinsic Value tab, correct?

  4. - Jae Jun

    In the Graham Intrinsic Value tab, just enter the formula into cell C22 the cell for the Corp Bond Rate

Leave a comment


(Required)


(Required and not published nor shared)