Copy of BBBY - Buffet Bond Test by  esskuchenkj  esskuchenkj 
  Log In  |  Create a FREE Account  |  Everyone's Spreadsheets  |  Tags  |  Help  
 Saving... 
  login to save   undo redo  |  bold italic font text underline more font formatting  |  align left align center align right  |  text color background text color  |  sum hide/show tools
  fx
BBBYToday's PriceEPSDPSTOTALLast Updated:9/21/2005
37.42$37.421.71$1.710.00$0.001.71
$1.71
BOND TEST(One "quick and dirty" test Buffet does is compare the total yield of a stock to that of the 10 year bond.)
Earn Yield0.045697487974345266
4.569748797434527%
Div Yield
Total Yield0.045697487974345266
4.569748797434527%
10yr Bond0.041684.168%<-- 10 yr bond yield doesn't beat total yield of stock
Bond Price41.02687140115163
$41.03
<-- Bond more expensive for equivalent cashflow
 
Average Rating:  Not rated (Not yet rated)
 
Name:  Copy of BBBY - Buffet Bond Test by  esskuchenkj esskuchenkj 
Description:  This spreadsheet applies the quick-n-dirty "Buffet bond test" to BBBY.
Tags:  Buffet valuation stocks BBBY  
[ default color ]
 
 recent: