{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["TenPoints","DataCollection","WebQuery","BondQuery","BalanceQuery"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"TenPoints","index":0,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Benjamin Graham's 10 Rules for Stock Selection"]
[]
["1. An earnings-to-price yield at least twice the AAA bond rate."]
["2. P/E ratio less than 40% of the highest P/E ratio the stock had over the past 5 years."]
["3. Dividend yield of at least 2/3 the AAA bond yield."]
["4.Stock price below 2/3 of tangible book value per share."]
["5. Stock price below 2/3 of Net Current Asset Value."]
["6. Total debt less than book value."]
["7. Current ratio greater than 2."]
["8. Total debt less than 2 times Net Current Asset Value."]
["9. Earnings growth of prior 10 years at least at a 7% annual compound rate."]
["10. Stability of growth of earnings in that no more than 2 declines of 5% or more in year end earnings in the prior ten years are permissible."]

{"sheet":"DataCollection","index":1,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Stock Ticker Symbol:","MSFT"]
["Stock Price",39.36]
["P/E Ratio",14.95,null,null,null,null,"Hurdle #","Hurdle Description","Pass Hurdle?"]
["Earnings-to-Price",6.6889632107023408E-2,null,null,null,null,1,"Earnings-to-Price >= 2*(AAA Bond Yield)",{"$f":"IF(B4>(2*B5),\"Yes\",\"No\")","v":"No"}]
["AAA Bond Yield",4.26,null,null,null,null,2,"Fallen Angel? (P/E Ratio >= 0.4*(5-Year High P/E))",{"$f":"IF(B7=\"No\",\"Yes\",\"No\")","v":"Yes"}]
["5-Year High P/E",15.33,null,null,null,null,3,"Dividend Yield >= (2/3)*(AAA Bond Yield)",{"$f":"IF(B11=\"--\",\"No\",IF(B11<(2/3)*B5,\"No\",\"Yes\"))","v":"No"}]
["Fallen Angel?","No",null,null,null,null,4,"Stock Price < (2/3)*(Net Tangible Assets)/(Total Shares Held)",{"$f":"IF(B2<(2/3)*(B17/B16),\"Yes\",\"No\")","v":"No"}]
["Total Assets",142431000,null,null,null,null,5,"Stock Price < (2/3)*(Net Current Asset Value)",{"$f":"IF(B2<(2/3)*(B21),\"Yes\",\"No\")","v":"Yes"}]
["Total Liabilities",63487000,null,null,null,null,6,"Total Debt < Book Value",{"$f":"IF(B10<B20,\"Yes\",\"No\")","v":"Yes"}]
["Total Debt",15600000,null,null,null,null,7,"Current Ratio > 2",{"$f":"IF(B13>2,\"Yes\",\"No\")","v":"Yes"}]
["Dividend Yield",2.77,null,null,null,null,8,"Total Debt < 2*(Net Current Asset Value)",{"$f":"IF(B10<(2*B21),\"Yes\",\"No\")","v":"Yes"}]
["Growth Rate",7.62,null,null,null,null,9,"Growth Rate >= 7",{"$f":"IF(B12<7,\"No\",\"Yes\")","v":"Yes"}]
["Current Ratio",3.17,null,null,null,null,10,"Data are unavailable to test.","Unknown"]
["Short-Term Debt",2999000]
["Long-Term Debt",12601000,null,null,null,null,"Hurdle #","Pass Hurdle?"]
["Total Shares Held",5883762412,null,null,null,null,1,"No"]
["Net Tangible Assets",61206000,null,null,null,null,2,"Yes"]
["Current Assets",101466000,null,null,null,null,3,"No"]
["Current Liabilities",37417000,null,null,null,null,4,"No"]
["Book Value",78944000,null,null,null,null,5,"Yes"]
["Net Current Asset Value",85866000,null,null,null,null,6,"Yes"]
["Cash And Cash Equivalents",3804000,null,null,null,null,7,"Yes"]
["Short Term Investments",73218000,null,null,null,null,8,"Yes"]
["Net Receivables",19118000,null,null,null,null,9,"Yes"]
["Inventory",1938000,null,null,null,null,10,"Unknown"]
["Other Current Assets",3388000]
["Accounts Payable",10182000,null,null,null,null,null,"Total Number of Cleared Hurdles",6]
["Short/Current Long Term Debt",2999000,null,null,null,null,null,"Total Number of Failed Hurdles",3," out of "]
["Other Current Liabilities",24236000,null,null,null,null,null,"Total Number of Calculated Hurdles",9]
[]
[]
[null,null,null,null,null,null,null,"Total Number of Cleared Hurdles",{"$f":"COUNTIF(H16:H25,\"Yes\")","v":6}]
[null,null,null,null,null,null,null,"Total Number of Failed Hurdles",{"$f":"COUNTIF(H16:H25,\"No\")","v":3}]
[null,null,null,null,null,null,null,"Total Number of Calculated Hurdles",{"$f":"SUM(I32:I33)","v":9}]

{"sheet":"WebQuery","index":2,"n_rows":407,"n_cols":6,"rows_kept":407,"cut":false,"hidden":false,"merged":[]}
["MSFT"]
[]
[]
[]
[]
[]
["Reuters"]
["Edition:"]
["U.S."]
[]
["Arabic"]
["Argentina"]
["Brazil"]
["Canada"]
["China"]
["France"]
["Germany"]
["India"]
["Italy"]
["Japan"]
["Latin America"]
["Mexico"]
["Russia"]
["Spain"]
["United Kingdom"]
["Home"]
["Business"]
[]
["Business Home"]
["Economy"]
["Legal"]
["Deals"]
["Business Video"]
["Aerospace & Defense"]
["Autos"]
["Reuters Summits"]
["Small Business"]
["Markets"]
[]
["Markets Home"]
["U.S. Markets"]
["European Markets"]
["Asian Markets"]
["Global Market Data"]
["Indices"]
["Stocks"]
["Bonds"]
[]
["Currencies"]
["Commodities"]
["Futures"]
["Funds"]
["peHUB"]
["Earnings"]
["Dividends"]
["World"]
[]
["World Home"]
["U.S."]
["Special Reports"]
["Reuters Investigates"]
["Euro Zone"]
["Middle East"]
["China"]
[]
["Japan"]
["Mexico"]
["Brazil"]
["Africa"]
["Russia"]
["India Insight"]
["World Video"]
["Politics"]
[]
["Politics Home"]
["Supreme Court"]
["Politics Video"]
["Tech"]
[]
["Technology Home"]
["MediaFile"]
["Science"]
["Tech Video"]
["Top 100 Global Innovators"]
["Opinion"]
[]
["Opinion Home"]
["John Lloyd"]
["Felix Salmon"]
["Jack Shafer"]
["David Rohde"]
["Nicholas Wapshott"]
["Bethany McLean"]
["Anatole Kaletsky"]
["Zachary Karabell"]
[]
["Edward Hadas"]
["Hugo Dixon"]
["Ian Bremmer"]
["Lawrence Summers"]
["The Great Debate"]
["Reihan Salam"]
["Mark Leonard"]
["Steven Brill"]
["Alison Frankel"]
["Breakingviews"]
[]
["Equities"]
["Credit"]
["Private Equity"]
["M&A"]
["Macro & Markets"]
["Politics"]
["Breakingviews Video"]
["Money"]
[]
["Money Home"]
["Tax Break"]
["Lipper Awards"]
["Global Investing"]
["MuniLand"]
["Unstructured Finance"]
["Linda Stern"]
["Mark Miller"]
["John Wasik"]
[]
["James Saft"]
["Analyst Research"]
["Alerts"]
["Watchlist"]
["Portfolio"]
["Stock Screener"]
["Fund Screener"]
["Personal Finance Video"]
["Life"]
[]
["Health"]
["Sports"]
["Arts"]
["Entertainment"]
["Oddly Enough"]
["Faithworld"]
["Lifestyle Video"]
["Pictures"]
[]
["Pictures Home"]
["Reuters Photographers"]
["Full Focus"]
["Video"]
[]
["Reuters TV"]
["Reuters News"]
["Financials: Microsoft Corp (MSFT.O)"]
["Related Topics:"]
["Stocks"]
["Stock Screener"]
["Market Data"]
["Technology"]
["Software"]
["Overview"]
["News"]
["Key Developments"]
["People"]
["Charts"]
["Financials"]
["Analysts"]
["Research"]
["Pulse"]
["MSFT.O on Nasdaq"]
[]
["39.36USD"]
["2014-04-10"]
["Price Change (% chg)"]
[]
["$-1.11 (-2.74%)"]
["Prev Close"]
[40.47]
["Open"]
[40.44]
["Day's High"]
[40.69]
["Day's Low"]
[39.090000000000003]
["Volume"]
[45960848]
["Avg. Vol"]
[39374000]
["52-wk High"]
[41.66]
["52-wk Low"]
[28.5]
["Search Stocks"]
["Revenue"]
["Periods",2012,2013,2014]
["September",17372,16008,18529]
["December",20885,21456,24519]
["March",17407,20489]
["June",18059,19896]
[]
["Note: Units in Millions of U.S. Dollars"]
["Earnings Per Share"]
["Periods",2012,2013,2014]
["September",0.67584999999999995,0.52578000000000003,0.62177000000000004]
["December",0.78251999999999999,0.75521000000000005,0.78117999999999999]
["March",0.60107999999999995,0.71835000000000004]
["June",-5.8659999999999997E-2,0.58660000000000001]
[]
["Note: Units in U.S. Dollars"]
["Consensus Estimates Analysis"]
[null,"# of Estimates","Mean","High","Low","1 Year Ago"]
["SALES (in millions)"]
["Quarter Ending Jun-14",23,21027,21769,20459,22209]
["Quarter Ending Sep-14",19,19985.099999999999,20452.7,19130,21208.2]
["Year Ending Jun-14",25,84455.3,85089,83732,85909]
["Year Ending Jun-15",25,90315.5,98640.4,87014,91159.2]
["EARNINGS (per share)"]
["Quarter Ending Jun-14",24,0.67,0.77,0.56000000000000005,0.84]
["Quarter Ending Sep-14",20,0.65,0.72,0.6,0.79]
["Year Ending Jun-14",26,2.7,2.81,2.6,3.13]
["Year Ending Jun-15",25,2.9,3.22,2.69,3.42]
["LT Growth Rate (%)",4,7.62,10,2,9.0299999999999994]
["Sales and Earnings Figures in U.S. Dollars (USD)"]
["Valuation Ratios"]
[null,"Company","Industry","Sector"]
["P/E Ratio (TTM)",14.95,29.16,15.14]
["P/E High - Last 5 Yrs.",15.33,158.76,42.83]
["P/E Low - Last 5 Yrs.",9.65,13.28,10.14]
[]
["Beta",0.9,0.85,1.02]
[]
["Price to Sales (TTM)",4.03,7.29,4]
["Price to Book (MRQ)",3.95,5.31,2.4500000000000002]
["Price to Tangible Book (MRQ)",4.9800000000000004,116.76,5.25]
["Price to Cash Flow (TTM)",12.41,19.93,18.350000000000001]
["Price to Free Cash Flow (TTM)",23.32,24.14,17.920000000000002]
[]
["% Owned Institutions","--","--","--"]
["Dividends"]
[null,"Company","Industry","Sector"]
["Dividend Yield",2.77,1.48,1.21]
["Dividend Yield - 5 Year Avg.",2.4700000000000002,1.44,1.08]
["Dividend 5 Year Growth Rate",15.9,0.31,17.37]
[]
["Payout Ratio(TTM)",37.21,31.27,16.510000000000002]
["Growth Rates"]
[null,"Company","Industry","Sector"]
["Sales (MRQ) vs Qtr. 1 Yr. Ago",14.28,29.37,12.25]
["Sales (TTM) vs TTM 1 Yr. Ago",14.4,9.9700000000000006,21.93]
["Sales - 5 Yr. Growth Rate",5.2,6.65,12.16]
[]
["EPS (MRQ) vs Qtr. 1 Yr. Ago",3.44,49.46,12.19]
["EPS (TTM) vs TTM 1 Yr. Ago",48.51,"--","--"]
["EPS - 5 Yr. Growth Rate",6.69,7.3,27.11]
[]
["Capital Spending - 5 Yr. Growth Rate",5.99,-2.58,7.98]
["Financial Strength"]
[null,"Company","Industry","Sector"]
["Quick Ratio (MRQ)",3.12,1.75,1.75]
["Current Ratio (MRQ)",3.17,3.87,2.39]
["LT Debt to Equity (MRQ)",24.3,6.6,8.01]
["Total Debt to Equity (MRQ)",27,9.31,14.13]
["Interest Coverage (TTM)","--",20.86,15.55]
["Profitability Ratios"]
[null,"Company","Industry","Sector"]
["Gross Margin (TTM)",71.489999999999995,50.22,42.99]
["Gross Margin - 5 Yr. Avg.",77.25,56.69,41.15]
[]
["EBITD Margin (TTM)",38.64,"--","--"]
["EBITD - 5 Yr. Avg",41.15,26.77,21.65]
[]
["Operating Margin (TTM)",33.369999999999997,13.65,16.32]
["Operating Margin - 5 Yr. Avg.",35.28,22.13,14.57]
[]
["Pre-Tax Margin (TTM)",33.6,18.399999999999999,17.32]
["Pre-Tax Margin - 5 Yr. Avg.",35.69,23.94,15.4]
[]
["Net Profit Margin (TTM)",27.35,8.3699999999999992,12.68]
["Net Profit Margin - 5 Yr. Avg.",27.84,16.5,11.49]
[]
["Effective Tax Rate (TTM)",18.59,31.65,24.05]
["Effective Tax Rate - 5 Yr. Avg.",22.01,27.93,23.79]
["Efficiency"]
[null,"Company","Industry","Sector"]
["Revenue/Employee (TTM)",842758,14585074,14435729]
["Net Income/Employee (TTM)",230525,2565045,1041673]
[]
["Receivable Turnover (TTM)",5.51,5.19,8.01]
["Inventory Turnover (TTM)",14.62,216.96,53.52]
["Asset Turnover (TTM)",0.59,0.63,1.06]
["Management Effectiveness"]
[null,"Company","Industry","Sector"]
["Return on Assets (TTM)",16.170000000000002,9.68,14.31]
["Return on Assets - 5 Yr. Avg.",19,10.51,12.48]
[]
["Return on Investment (TTM)",21.08,14.75,14.98]
["Return on Investment - 5 Yr. Avg.",26.98,14.3,17.55]
[]
["Return on Equity (TTM)",28.95,16.05,15.19]
["Return on Equity - 5 Yr. Avg.",35.729999999999997,15.99,17.23]
["Growth for Microsoft Corp"]
[null,"1 Year","3 Years","5 Years"]
["Sales %",5.6,7.6,5.2]
["EPS %",29.32,7.09,6.69]
["Dividend %",15,20.95,15.9]
["Note: Units in Millions of US Dollars"]
["» View Financial Statements"]
["Performance for Microsoft Corp"]
["Period","%","% vs.","Rank In","Industry"]
[null,"Actual","S&P 500","Industry","Rank"]
["4 Week",5.75,5.53,73,36]
["13 Week",13.17,11.07,75,32]
["26 Week",22.38,8.27,62,64]
["52 Week",36.68,14.52,65,98]
["YTD",8.18,6.8,64,36]
["Note:: Rank is a percentile that ranges from 0 to 99, with 99 = best."]
["Microsoft Corp News"]
["Microsoft ends Windows XP support, hackers may be lurking"]
["Untaxed U.S. corporate profits held overseas top $2.1 trln -study"]
["Microsoft ends Windows XP support, hackers may be lurking"]
["Microsoft ends Windows XP support, hackers may be lurking"]
["Nokia wins Chinese approval for Microsoft deal"]
["» More MSFT.O News"]
["Institutional Holders"]
["% Shares Owned:",0.70889999999999997]
["# of Holders:",2567]
["Total Shares Held:",5883762412]
["3 Mo. Net Change: ",11088267]
["# New Positions:",18]
["# Closed Positions:",6]
["# Increased Positions:",101]
["# Reduced Positions:",95]
["# Net Buyers:",6]
["NYSE and AMEX quotes delayed by at least 20 minutes. NASDAQ delayed by at least 15 minutes. For a complete list of exchanges and delays, please click here."]
["Related Topics:"]
["Stocks"]
["Stock Screener"]
["Market Data"]
["Technology"]
["Software"]
["Search Stocks"]
[]
["Edition:"]
["U.S."]
[]
["Arabic"]
["Argentina"]
["Brazil"]
["Canada"]
["China"]
["France"]
["Germany"]
["India"]
["Italy"]
["Japan"]
["Latin America"]
["Mexico"]
["Russia"]
["Spain"]
["United Kingdom"]
["Back to top"]
["Reuters.com"]
["Business"]
["Markets"]
["World"]
["Politics"]
["Technology"]
["Opinion"]
["Money"]
["Pictures"]
["Videos"]
["Site Index"]
["Legal"]
["Bankruptcy Law"]
["California Legal"]
["New York Legal"]
["Securities Law"]
["Support & Contact"]
["Support"]
["Corrections"]
["Connect with Reuters"]
["Twitter  "]
["Facebook  "]
["LinkedIn  "]
["RSS  "]
["Podcast  "]
["Newsletters  "]
["Mobile"]
["About"]
["Privacy Policy"]
["Terms of Use"]
["Advertise With Us"]
["AdChoices"]
["Copyright"]
[]
["Our Flagship financial information platform incorporating Reuters Insider"]
["An ultra-low latency infrastructure for electronic trading and data distribution"]
["A connected approach to governance, risk and compliance"]
["Our next generation legal research platform"]
["Our global tax workstation"]
["Thomsonreuters.com"]
["About Thomson Reuters"]
["Investor Relations"]
["Careers"]
["Contact Us"]
["Thomson Reuters is the world's largest international multimedia news agency, providing investing news, world news, business news, technology news, headline news, small business news, news alerts, personal finance, stock market, and mutual funds information available on Reuters.com, video, mobile, and interactive television platforms. Thomson Reuters journalists are subject to an Editorial Handbook which requires fair presentation and disclosure of relevant interests."]
["NYSE and AMEX quotes delayed by at least 20 minutes. Nasdaq delayed by at least 15 minutes. For a complete list of exchanges and delays, please click here."]
["DCSIMG"]

{"sheet":"BondQuery","index":3,"n_rows":491,"n_cols":2,"rows_kept":491,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["Economic Research, Federal Reserve Bank of St. Louis"]
["My Account"]
["Register"]
["Sign in"]
["My Account"]
["Sign out"]
[]
[]
["Email"]
["Password"]
["Remember me"]
["Forgot your password?"]
["Learn More"]
[]
[]
["FRED® Economic Data"]
["FRED"]
[]
["All Series"]
["Tags"]
["Categories"]
["Releases"]
["Sources"]
["Updates"]
["Release Calendar"]
["FRED Blog NEW"]
["Popular Series"]
["FRED Logo"]
["Consumer Price Index for All Urban Consumers: All Items"]
["Real Gross Domestic Product"]
["Civilian Unemployment Rate"]
["10-Year Treasury Constant Maturity Rate"]
["Gross Domestic Product"]
["Effective Federal Funds Rate"]
["Top 50 Popular Series"]
["Data Tools"]
["Data Tools"]
[]
["FRED logoCreate Your Own Graphs"]
["FRED Graph - Create graphs using FRED data."]
[]
["iPhone logoAccess Data on the Go"]
["FRED Mobile Apps"]
[]
["Excel logoLoad Data from Excel"]
["FRED Add-in - Load FRED data directly into Microsoft® Excel®."]
[]
["GeoFRED logoCreate Your Own Maps"]
["GeoFRED - Map data at state, MSA & county levels."]
[]
["ALFRED logoView Archival Economic Data"]
["ALFRED - View and chart vintage FRED data."]
[]
["FRED logoDeveloper Access to FRED"]
["API - Access FRED data in your own applications."]
[]
["FRED logoEmbedded FRED Data"]
["Show 6 of our most popular data series on your website or blog. Now you can customize your widget!"]
[]
["Publications"]
["Publications"]
[]
["US Financial Data"]
["Review"]
["Economic Synopses"]
["Page One Economics Newsletter"]
["Burgundy Books"]
["The Regional Economist"]
["All Publications"]
["Featured Publication"]
["The Federal Reserve Bank of St. Louis Review"]
["A quarterly research journal intended for an economically informed but broad readership—from the undergraduate student to the PhD."]
["Current Issue | Previous Issues"]
["In this Issue:"]
[]
["The Rise and Fall of Labor Force Participation in the United States"]
["The Great Trade Collapse and Rebound: A State-by-State View"]
["A Guide to Tracking the U.S. Economy"]
["QE: Is There a Portfolio Balance Effect?"]
["more"]
["Review"]
["Working Papers"]
["Categories"]
[]
["Applied Econometrics"]
["Applied Microeconomics"]
["Banking"]
["Finance"]
["International"]
["Mathematical and Quantitative Methods"]
["Monetary Policy"]
["Regional Economics"]
["Recent Working Papers"]
[]
["Mar 27 Credit Markets, Limited Commitment, and Government Debt"]
["Francesca Carapella and Stephen Williamson"]
["Mar 27 Keynesian Inefficiency and Optimal Policy: A New Monetarist Approach"]
["Stephen Williamson"]
["Mar 27 Scarce Collateral, the Term Premium, and Quantitative Easing"]
["Stephen Williamson"]
["Mar 10 Withstanding Great Recession like China"]
["Yi Wen and Jing Wu"]
["Feb 27 Determinants of Trade Margins: Insights Using State Export Data"]
["Cletus C. Coughlin"]
["Economists"]
["Leadership"]
[]
["James Bullard"]
["President & Chief Executive Officer"]
["Christopher J. Waller"]
["Director of Research"]
["Cletus C. Coughlin"]
["Policy Adviser"]
["David C. Wheelock"]
["Deputy Director of Research"]
["Economists"]
[]
["David Andolfatto"]
["Costas Azariadis"]
["Alejandro Badel"]
["Subhayu Bandyopadhyay"]
["Aleksander Berentsen"]
["Michele Boldrin"]
["Maria E. Canon"]
["YiLi Chien"]
["Silvio Contessi"]
[]
["Riccardo DiCecio"]
["William Dupor"]
["Carlos Garriga"]
["William T. Gavin"]
["Rubén Hernández-Murillo"]
["Kevin L. Kliesen"]
["David Levine"]
["Rodolfo Manuelli"]
["Fernando M. Martin"]
[]
["Michael W. McCracken"]
["Alexander Monge-Naranjo"]
["Christopher J. Neely"]
["Christopher Otrok"]
["Michael T. Owyang"]
["B. Ravikumar"]
["Paulina Restrepo-Echavarria"]
["Juan M. Sánchez"]
[]
["Raul Santaeulalia-Llopis"]
["Yongseok Shin"]
["Daniel L. Thornton"]
["Yi Wen"]
["David Wiczer"]
["Stephen Williamson"]
["Christian Zimmermann"]
["More"]
["Tools"]
[]
["FRED®"]
["ALFRED®"]
["GeoFRED®"]
["IDEAS"]
["CASSIDI®"]
["FRASER®"]
["Developers / API"]
["More Services"]
["Events"]
["Information on conferences, seminars, and workshops sponsered by the Research Division."]
["8th District Economy"]
["Find economic data and reports on economic conditions in the Federal Reserve's Eighth District."]
["Careers"]
["Job Opportunities offered by the Research Division"]
["Page One Economics"]
["Includes a newsletter, data \"starter set\", and other economic resources."]
["Education Resources"]
["Classroom resources for elementary, middle-school, and high-school, and college educators."]
["EconWise logoEconWise"]
["The excellent economic analysis you expect, now with the advantages of a free mobile app."]
["Monetary Aggregates"]
["Data and information relating to monetary aggregates."]
["Economic Information Infographic"]
["A guide to understanding the economy using the resources of the Federal Reserve Bank of St. Louis."]
["View All"]
["St. Louis Fed Home"]
["FRED Economic Data | St. Louis Fed"]
[]
["Data"]
["Download Data"]
["View Data"]
["Vintage Series in ALFRED "]
["My FRED"]
["Notify Me of Updates"]
["Add to Data List"]
["Save Graph"]
["View My Graphs"]
["Other Formats"]
["Monthly, Not Seasonally Adjusted"]
["Weekly, Not Seasonally Adjusted"]
["Tags"]
["moody's x 10"]
["aaa x 12"]
["h15 x 164"]
["bonds x 403"]
["yield x 444"]
["daily x 841"]
["interest rate x 1,316"]
["corporate x 1,630"]
["frb x 7,825"]
["nation x 120,238"]
["usa x 123,642"]
["nsa x 152,367"]
["Related Categories"]
["Moody's"]
["Corporate Bonds"]
["Interest Rates"]
["Money, Banking, & Finance"]
["Need Help?"]
["Tutorials"]
["FAQs"]
["Email Us"]
[]
["Home > FRED® Economic Data > Releases > H.15 Selected Interest Rates "]
[]
["Moody's Seasoned Aaa Corporate Bond Yield"]
["2014-04-09: 4.26 Percent (+ see more) "]
["2014-04-09: ",4.26]
["2014-04-08: ",4.25]
["2014-04-07: ",4.25]
["2014-04-04: ",4.28]
["2014-04-03: ",4.32]
["Daily, Not Seasonally Adjusted, DAAA, Updated: 2014-04-10 3:31 PM CDT"]
[]
[]
["Click and drag in the plot area or select dates:   1yr | 5yr | 10yr | Max   to "]
[]
["Notes ©"]
[]
["Graph"]
["Share"]
["Export"]
[]
["Copyright, 2011, Moody's Investor Services. Reprinted with permission. Moody's tries to include bonds with remaining maturities as close as possible to 30 years. Moody's drops bonds if the remaining life falls below 20 years, if the bond is susceptible to redemption, or if the rating changes."]
[]
["Source: Board of Governors of the Federal Reserve System"]
[]
["Release: H.15 Selected Interest Rates"]
[]
["Growth Rate Calculations | US recession dates"]
[]
["Restore defaults | Save settings | Apply saved settings"]
[]
["Graph Settings"]
[]
["Graph type:"]
[]
[]
["Stacking:"]
[]
[]
["Recession bars: On Off"]
[]
["Log scale: Left Right "]
[]
["Font:"]
[]
[]
["Title Font Size: 12"]
[]
[]
["General Font Size: 12"]
[]
["Show: Title/Legend Axis Titles"]
[]
["Graph Size:"]
["    w   h "]
[]
["Graph Background: Plot Background: Text: "]
[]
["Add Data Series"]
[]
["  Browse"]
[]
["Add new series     Modify existing series"]
[]
["Add Series"]
[]
["Edit Data Series 1: Moody's Seasoned Aaa Corporate Bond Yield "]
[]
["Line Style:"]
[]
[]
["Line Width:"]
[]
[]
["Color: "]
[]
["Mark Type:"]
[]
[]
["Mark Width:"]
[]
["Frequency:"]
["   Aggregation Method:"]
[]
["Y-Axis Position: Left Right Bottom Bubble Size"]
[]
["(a) Moody's Seasoned Aaa Corporate Bond Yield, Percent, Not Seasonally Adjusted (DAAA)"]
[]
["Units:"]
[]
["Copyright, 2011, Moody's Investor Services. Reprinted with permission. Moody's tries to include bonds with remaining maturities as close as possible to 30 years. Moody's drops bonds if the remaining life falls below 20 years, if the bond is susceptible to redemption, or if the rating changes."]
[]
["Moody's Seasoned Aaa Corporate Bond Yield"]
[]
["    "]
[]
["U.S. Recession Peak:"]
["   or Trough:"]
[]
["or Observation Date: "]
["Display integer periods instead of dates (e.g. ...,-1,0,1,...) with the value scaled to 100 at period 0."]
[]
["Integer Period Range: to copy to all"]
[]
["Create your own data transformation: [+] "]
[]
["Need help? [+]"]
[]
["Use a formula to modify and combine data series into a single line. For example, invert an exchange rate a by using formula 1/a, or calculate the spread between 2 interest rates a and b by using formula a - b."]
[]
["Use the assigned data series variables above (e.g. a, b, ...) together with operators {+, -, *, /, ^}, braces {(,)}, and constants {e.g. 2, 1.5} to create your own formula {e.g. 1/a, a-b, (a+b)/2, (a/(a+b+c))*100}. The default formula 'a' displays only the first data series added to this line. You may also add data series to this line before entering a formula."]
[]
["Formula: Apply "]
["Transformation:"]
["will be applied to formula result"]
[]
["Create segments for min, max, and average values: [+]"]
["Do not include this series in calculations (default)"]
["Include this series in calculations"]
["Include this series in calculations but do not display"]
[]
["move up move down"]
[]
["Data in this graph is copyrighted. Please review the copyright information in the series notes before sharing."]
[]
["Share"]
["share on twitter share on facebook share on google plus email"]
[]
["Embed in website why embed?"]
[]
["Link"]
[]
["Image"]
[]
["Data in this graph is copyrighted. Please review the copyright information in the series notes before sharing."]
[]
["Graph Data"]
[]
["Download as XLS"]
[]
["Graph Image"]
[]
["Print"]
["Export as PDF"]
["Export as PNG"]
["Export as JPG"]
["Export as SVG"]
[]
[]
[]
[]
[]
[]
["×"]
["Confirm Delete"]
[]
["Are you sure you want to remove this series from the graph? This can not be undone."]
[]
["Cancel Remove"]
["×"]
["Browse Data"]
["Close"]
["×"]
["Save Settings"]
[]
["Success!"]
[]
["The current graph settings have been saved to your account. Click the 'Apply Saved Settings' link to use these settings on future graphs."]
[]
["Oops! There was an error."]
[]
["The current graph settings could not be saved at this time."]
[]
["This will overwrite any settings you may have previously saved. Do you want to continue?"]
[]
["Yes, save current settings"]
[]
["This feature requires signing in to your user account. Would you like to sign in now?"]
[]
["Yes, sign in now"]
["Close"]
["×"]
["Apply Saved Settings"]
[]
["Oops! There was an error."]
[]
["Your saved graph settings could not be retrieved at this time."]
[]
["Are you sure you want to apply your saved settings to the current graph?"]
[]
["Yes, apply current settings"]
[]
["This feature requires signing in to your user account. Would you like to sign in now?"]
[]
["Yes, sign in now"]
["Close"]
["×"]
["Apply Saved Settings"]
[]
["Oops! There was an error."]
[]
["The default graph settings could not be retrieved at this time."]
[]
["Are you sure you want to restore the default settings? This may overwrite any already adjusted settings."]
[]
["Close"]
["Retrieving data.×"]
["Graph updated.×"]
["MY ACCOUNT:"]
["Sign In"]
["Register"]
["ABOUT:"]
["Employment"]
["Contact"]
["Customer Comments"]
["Follow the Fed"]
["RSS"]
["Privacy"]
["Legal"]
["SERVICES:"]
["FRED®"]
["Mobile FRED®"]
["ALFRED®"]
["GeoFRED®"]
["CASSIDI®"]
["FRASER®"]
["Developer/APIs"]
["IDEAS"]
["RESEARCH:"]
["8th District Economy"]
["Page One Economics"]
["Events"]
["Monetary Aggregates"]
["Other Resources"]
["Education Resources"]
["FOMC Speak"]
["HELP:"]
["Data: stlsFRED@stls.frb.org"]
["Questions/Comments: webmaster@research.stlouisfed.org"]
["FRED Help"]
["More Help"]
["TOOLS:"]
["FRED Mobile Apps"]
["FRED Add-In for Microsoft® Excel®"]
["Embeddable FRED Widget"]
["EconWise iPad App"]
["OUR SITES:"]
["St. Louis Fed"]
["Federal Reserve System"]
["Economic Research"]
["Subscribe to our newsletter for updates on published research, data news, and latest econ information."]
["Name:   Email:  "]
["Twitter logoGoogle Plus logoFacebook logoYouTube logoLinkedIn logo"]
["Federal Reserve Bank of St. Louis, One Federal Reserve Bank Plaza, St. Louis, MO 63102"]
[]
["Click to send us feedback"]
["×"]
["Send Us Feedback"]
[]
["How can we improve our FRED graphs?"]
[]
["If reporting a bug, please include the name of your operating system, web browser, and browser version number."]
[]
["Your feedback:"]
[]
["Your email (if you want a reply):"]
[]
["Send feedback"]

{"sheet":"BalanceQuery","index":4,"n_rows":232,"n_cols":6,"rows_kept":232,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["Home"]
["Mail"]
["News"]
["Sports"]
["Finance"]
["Weather"]
["Games"]
["Groups"]
["Answers"]
["Screen"]
["Flickr"]
["Apps"]
["More"]
[]
["Celebrity"]
["Shine"]
["Movies"]
["Music"]
["TV"]
["Health"]
["Shopping"]
["Travel"]
["Autos"]
["Homes"]
[]
["Yahoo Finance "]
[null,"Search Finance"]
[null,"Search Web"]
["Sign In "]
["Mail "]
["Help "]
["Account Info"]
["Help"]
["Suggestions"]
["Yahoo"]
[]
["close button"]
["Mobile App Promotion"]
[]
["Send me a link:"]
[]
["Phone Number"]
["*Only U.S. numbers are accepted. Text messaging rates may apply."]
["Please enter a valid phone number."]
["Please enter your Phone Number."]
["Send"]
[]
["Thanks! A link has been sent."]
[]
["Done"]
[]
["Finance Home"]
["My Portfolio"]
[]
["Sign in to access My Portfolios"]
["Free trial of Real-Time Quotes"]
["Market Data"]
[]
["Stocks"]
["Mutual Funds"]
["Options"]
["ETFs"]
["Bonds"]
["Commodities"]
["Currencies"]
["Business & Finance"]
[]
["Company News"]
["Economic News"]
["Market News"]
["Personal Finance"]
[]
["Career & Education"]
["Real Estate"]
["Retirement"]
["Credit & Debt"]
["Taxes"]
["Health & Lifestyle"]
["Featured Videos"]
["Rates in Your Area"]
["Calculators"]
["Yahoo Originals"]
[]
["Breakout"]
["The Daily Ticker"]
["Unexpected Returns"]
["The Exchange"]
["Hot Stock Minute"]
["Just Explain It"]
["CNBC"]
[]
["Big Data Download"]
["Off the Cuff"]
["Power Pitch"]
["Talking Numbers"]
["Top/Best/Most"]
["Search for share prices"]
["Search for share prices"]
["Finance Search"]
[]
["Thu, Apr 10, 2014, 11:15PM EDT - U.S. Markets closed"]
[]
[" Dow Down1.62% Nasdaq Down3.10%"]
[]
[]
["More On MSFT"]
[]
["Quotes"]
[]
["Summary"]
["Order Book"]
["Options"]
["Historical Prices"]
[]
["Charts"]
[]
["Interactive"]
["Basic Chart"]
["Basic Tech. Analysis"]
[]
["News & Info"]
[]
["Headlines"]
["Press Releases"]
["Company Events"]
["Message Boards"]
["Market Pulse"]
[]
["Company"]
[]
["Profile"]
["Key Statistics"]
["SEC Filings"]
["Competitors"]
["Industry"]
["Components"]
[]
["Analyst Coverage"]
[]
["Analyst Opinion"]
["Analyst Estimates"]
["Research Reports"]
[]
["Ownership"]
[]
["Major Holders"]
["Insider Transactions"]
["Insider Roster"]
[]
["Financials"]
[]
["Income Statement"]
["Balance Sheet"]
["Cash Flow"]
[]
[]
[]
["Microsoft Corporation (MSFT)"]
[]
["-NasdaqGS "]
["39.36 Down1.11(2.74%) 4:00PM EDT"]
["|After Hours : 39.35 Down0.01 (0.03%) 7:35PM EDT"]
["Get the big picture on all your investments."]
["Sync your Yahoo portfolio now"]
["Balance Sheet",null,null,null,null,"Get Balance Sheet for: "]
["View: Annual Data | Quarterly Data",null,null,null,null,"All numbers in thousands"]
["Period Ending",null,41455,41090,40724]
[]
["Assets"]
["Current Assets"]
[null,"Cash And Cash Equivalents",3804000,6938000,9610000]
[null,"Short Term Investments",73218000,56102000,43162000]
[null,"Net Receivables",19118000,17815000,17454000]
[null,"Inventory",1938000,1137000,1372000]
[null,"Other Current Assets",3388000,3092000,3320000]
[]
["Total Current Assets ",null,101466000,85084000,74918000]
["Long Term Investments",null,10844000,9776000,10865000]
["Property Plant and Equipment",null,9991000,8269000,8162000]
["Goodwill",null,14655000,13452000,12581000]
["Intangible Assets",null,3083000,3170000,744000]
["Accumulated Amortization",null,"-  ","-  ","-  "]
["Other Assets",null,2392000,1520000,1434000]
["Deferred Long Term Asset Charges",null,"-  ","-  ","-  "]
[]
["Total Assets ",null,142431000,121271000,108704000]
[]
["Liabilities"]
["Current Liabilities"]
[null,"Accounts Payable",10182000,9653000,9560000]
[null,"Short/Current Long Term Debt",2999000,1231000,"-  "]
[null,"Other Current Liabilities",24236000,21804000,19214000]
[]
["Total Current Liabilities ",null,37417000,32688000,28774000]
["Long Term Debt",null,12601000,10713000,11921000]
["Other Liabilities",null,10000000,8208000,8072000]
["Deferred Long Term Liability Charges",null,3469000,3299000,2854000]
["Minority Interest",null,"-  ","-  ","-  "]
["Negative Goodwill",null,"-  ","-  ","-  "]
[]
["Total Liabilities ",null,63487000,54908000,51621000]
[]
["Stockholders' Equity"]
["Misc Stocks Options Warrants",null,"-  ","-  ","-  "]
["Redeemable Preferred Stock",null,"-  ","-  ","-  "]
["Preferred Stock",null,"-  ","-  ","-  "]
["Common Stock",null,67306000,65797000,63415000]
["Retained Earnings",null,9895000,-856000,-6332000]
["Treasury Stock",null,"-  ","-  ","-  "]
["Capital Surplus",null,"-  ","-  ","-  "]
["Other Stockholder Equity",null,1743000,1422000,"-  "]
[]
["Total Stockholder Equity ",null,78944000,66363000,57083000]
[]
["Net Tangible Assets ",null,61206000,49741000,43758000]
["Sign Up for a Free Trial to EDGAR Online Premium!"]
["Get the critical business and financial information you need for more than 15,000 U.S. public companies."]
["Sign Up Now - Learn More"]
["Currency in USD."]
[]
[]
["Privacy - About Our Ads - Terms - Send Feedback - Yahoo! - ABC News Network"]
["Quotes are real-time for NASDAQ, NYSE, and NYSE MKT. See also delay times for other exchanges. All information provided \"as is\" for informational purposes only, not intended for trading purposes or advice. Neither Yahoo! nor any of independent providers is liable for any informational errors, incompleteness, or delays, or for any actions taken in reliance on information contained herein. By accessing the Yahoo! site, you agree not to redistribute the information found therein. Real-Time continuous streaming quotes are available through our premium service. You may turn streaming quotes on or off."]
[]
["US Financials data provided by Edgar Online and all other Financials provided by Capital IQ."]
[]
[95941443]