{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["Instructions","Analysis","Data","AnnBS","Name","Income","Bond rate","10 Yr PE","Price2","CFlow","G-1","G-1a","G-2","G-2a","G-3","G-3a","G-4","G-5","G-5a","G-6","G-6a","G-7","G-7a","G-8","G-9"],"not_rendered":{"charts":37,"images":1,"macros":1,"external_links":2,"defined_names":53,"comments":1,"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":"Instructions","index":0,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,1,30,5],[26,1,26,12],[23,1,23,11],[12,1,12,11],[13,1,13,11],[20,1,20,11],[18,1,18,11],[21,1,21,11],[15,1,15,11],[14,1,14,11],[16,1,16,11],[1,12,1,16],[0,1,0,11],[3,1,3,11],[9,1,9,11],[11,1,11,11],[2,1,2,11],[10,1,10,11],[6,1,6,11],[7,1,7,11],[8,1,8,11],[5,8,5,11],[1,1,1,11]]}
[null,"INSTRUCTIONS:"]
[null,"1.  Type a company ticker symbol in the cell with a blue background and press the Enter key.",null,null,null,null,null,null,null,null,null,null,"Click here to return to the Analysis page"]
[null,"There is a considerable amount of data to be downloaded to complete the analysis."]
[null,"All data will be inserted in the appropriate cells--provided you are logged on to the Internet.  If using a dial-up modem, be patient.  The update may take 15 to 20 seconds. New data will be written over the old data.  There is no need to delete existing data. No password is required to use this tool.  If you are asked for a password you are attempting to enter data into a cell that cannot be changed.  The ticker symbol is the only data entry needed to use the spreadsheet. "]
[]
[null,null,null,null,null,null,null,null,"If data does not update after entering a ticker symbol and pressing the Enter key, look above the top of the spreadsheet for a \"Security Warning\", shown here.   Click the Options box--a drop down menu will appear.  Click the \"Enable this content\" radio button, then OK.  These steps will be required each time the spreadsheet is opened.  It is possible to eliminate this step by authorizing all external data to be accessed but is not recommended as it opens your computer to the possibility of receiving destructive data. "]
[null,"If data are incomplete or you receive an error message of any type when using the form, please check my website for an updated spreadsheet.  This tool relies on websites that are open and offer free data.  They change their site on occasion, causing the automatic download of data feature to stop working.  I normally correct the problem within a few days of becoming aware.  If you notice strange behavior please email me:  bob.at.seattle@gmail.com"]
[]
[null,"HOW TO USE THIS TOOL:  The data presented within this tool is comprehensive and can be overwhelming.  Therefore, I suggest using only portions of the information until you become more experienced with what the various data show.  The most simple approach is to read the \"Bullish Results\" and \"Bearish Results\" in those two boxes.  That verbiage will steer you to additional comments and numerical analysis at the left of the form--when you want to dive in deeper.  To the right of the remarks is a column containing numbers.  The numbers refer to line numbers, found on the extreme left which identify data the remarks are referring to.  Don't feel it's necessary to analyze all the data in this spreadsheet to aid in making decisions about a company.  Use the information that makes sense to you in each learning stage, taking more and more advantage of additional data as your learning experience expands.  The final step in using the data presented on this form are the graphs, accessed by clicking the small purple boxes adjacent to selected information.  (They are also available as tabs at the bottom of the spreadsheet.)  Verbiage explains what to look for on each graph.  Notice there are five year data as well as five quarter graphs--providing a display of long and short term information."]
[null,"The automatic data feature requires being logged on to the Internet when the spreadsheet is opened, and only works with Excel 2000 or newer. If you are using Excel 2007 or newer you must download the file that's to be used with the version of Excel you are using.  Note that there are two versions of the spreadsheet on my site.  As explained on my website Excel 2010 contains a bug which precludes the use of this tool."]
[]
[null,"You can't damage the spreadsheet, so have fun."]
[null,"(The form is protected and does not allow the user to make changes to formulas, etc..  Therefore, as a user, you cannot make changes that will harm the form, or make it inoperative.)   "]
[null,"Note the color legend located on the lower left of the form.  Much of the verbiage and many cells will display these colors, depending upon the results of the analysis.  This form is somewhat the same as using the SSG.  You'll find some items indicating a positive direction, and others not.  Use these results as a help in guiding your decision.  It does not provide absolute answers.  There is no form, or method, that provides \"yes\" or \"no\" answers when dealing with the stock market."]
[null,"SOME SUGGESTIONS IN USING THE TOOL:  (It's a little intiminating at first glance.)"]
[null,"I suggest analyzing the data in layers.  You might start with observing the Bullish and Bearish remarks.  Even a cursory glance tells you a lot.  If there are many more Bullish remarks, that's probably good.  The opposite is probably bad.  Use the \"Numerical Result of this Analysis\" number only when comparing companies in the same industry.  Note: competitors are listed at the bottom of the sheet so a comparison is easily done.  Just type in the ticker symbol.  Another easy to use factor is determining the Intrinsic Value that Warren Buffett uses--he has no interest unless the discount rate is 25% or more.  Click the link, enter the ticker and read the result.  The result can be entered on the form if you wish."]
[null,"Note the yellow \"SEE\"column of numbers to the right of the Bullish and Bearish remarks.  If you'd like to know more about what drives the remark seen, locate the same number in the yellow collumn at the far left.  To the left of the Bullish and Bearish boxes are small purple boxes.  Click on one and see 5 year and 5 quarter charted data associated with the location of the purple box.  Verbiage with each graph explains what to look for.  That should be enough to get you started.  Investigate and enjoy."]
[]
[null,"Use the verbiage and the numerical result only as a guide in analyzing the company and as a comparison to companies in the same intistry."]
[null,"Some Background on this form:"]
[null,"The form was derived after reading what various authors recommended looking at when studying the Annual Report.  The authors I used are Peter Lynch, Warren Buffett, Benjamin Graham, and the NAIC Guide.  Therefore, the items studied in this form represent the same items recommended by these authors as study tools."]
[]
[]
[null,"This form is offered without warranty.  If strange behavior is observed please contact me -- bob.at.seattle@gmail.com"]
[null,"Thanks."]
[]
[null,"NOTE:  This analysis tool is designed for Retail and Manufacturing type industries.  If used with other industries the results will be less helpful."]
[]
[null,"Bob"]
[]
[null,"Click here to return to the Analysis page"]

{"sheet":"Analysis","index":1,"n_rows":102,"n_cols":25,"rows_kept":102,"cut":false,"hidden":false,"merged":[[33,10,33,14],[52,10,52,14],[28,10,28,14],[43,10,43,14],[44,10,44,14],[45,10,45,14],[46,10,46,14],[47,10,47,14],[48,10,48,14],[49,10,49,14],[50,10,50,14],[51,10,51,14],[34,10,34,14],[35,10,35,14],[36,10,36,14],[37,10,37,14],[38,10,38,14],[39,10,39,14],[40,10,40,14],[41,10,41,14],[42,10,42,14],[24,10,24,14],[25,10,25,14],[26,10,26,14],[29,10,29,14],[30,10,30,14],[31,10,31,14],[32,10,32,14],[13,10,13,14],[14,10,14,14],[15,10,15,14],[16,10,16,14],[17,10,17,14],[18,10,18,14],[19,10,19,14],[20,10,20,14],[21,10,21,14],[22,10,22,14],[0,11,0,12],[7,10,7,14],[8,10,8,14],[9,10,9,14],[10,10,10,14],[11,10,11,14],[12,10,12,14],[5,10,5,14],[23,10,23,14],[2,10,2,21],[94,3,94,7],[55,2,55,5],[89,2,89,3],[93,3,93,7],[91,3,91,7],[89,4,89,7],[81,8,81,9],[70,5,70,8],[62,5,62,8],[56,4,56,6],[78,4,78,7],[79,4,79,6],[80,2,80,7],[81,2,81,4],[81,5,81,6],[90,2,90,7],[85,2,85,7],[88,2,88,7],[68,5,68,8],[58,7,58,8],[83,2,83,7],[90,8,90,11],[88,8,88,11],[76,2,76,11],[36,23,36,24],[38,23,38,24],[39,3,39,4],[95,2,95,5],[65,5,65,8],[85,8,85,9],[61,2,61,8],[60,6,60,7],[57,7,57,8],[57,3,57,6],[49,6,49,8],[87,2,87,7],[55,6,55,8],[59,1,59,4],[58,2,58,6],[52,6,52,8],[56,1,56,2],[56,7,56,8],[45,6,45,8],[47,1,47,4],[86,2,86,7],[51,6,51,8],[87,8,87,9],[48,6,48,8],[77,2,77,5],[29,7,29,8],[49,1,49,4],[30,3,30,4],[36,1,36,4],[36,6,36,8],[37,6,37,8],[33,1,33,2],[40,6,40,8],[47,6,47,8],[39,6,39,8],[40,1,40,4],[42,1,42,4],[32,5,32,8],[38,6,38,8],[34,5,34,8],[33,6,33,8],[38,1,38,2],[34,1,34,4],[54,1,54,3],[54,6,54,8],[51,1,51,4],[11,1,11,2],[23,6,23,8],[18,5,18,8],[20,6,20,8],[19,5,19,8],[20,1,20,2],[21,6,21,8],[46,2,46,6],[31,1,31,2],[31,6,31,8],[29,1,29,2],[30,6,30,8],[17,6,17,8],[14,1,14,2],[17,1,17,2],[23,1,23,2],[22,6,22,9],[105,3,105,6],[96,4,96,7],[98,2,98,7],[97,4,97,6],[99,2,99,4],[8,1,8,3],[9,4,9,8],[15,5,15,8],[14,5,14,8],[13,4,13,8],[12,4,12,8],[8,6,8,8],[10,4,10,8],[99,5,99,6],[100,2,100,11],[28,6,28,8],[26,1,26,2],[26,3,26,4],[26,6,26,8],[24,3,24,5],[27,10,27,11],[27,5,27,8],[11,6,11,8],[50,6,50,8],[1,9,3,9],[5,4,5,8],[6,4,6,8],[1,1,1,3],[0,4,0,10],[2,5,2,6],[2,7,2,8],[4,6,4,8],[3,3,3,4],[0,1,0,3],[3,5,3,7],[1,5,1,8]]}
[null,"ANALYZING THE ANNUAL REPORT ",null,null,"This page shows year over year comparisons--see the graphs for 5 quarter and 5 year comparisons",null,null,null,null,null,null,"version 9.34",null,{"$f":"IF(COUNT(rngEarningsStatement)=8,\"         It appears no Refresh is required\",\"Earnings Data are missing--click the \"\"Refresh Data\"\" icon\")","v":"         It appears no Refresh is required"}]
[null,"Type a Ticker Symbol in blue colored cell & press Enter",null,null,"aapl",{"$f":"Data!D73","v":"Apple Inc"},null,null,null,"Graphs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(RevenuesThisYear=RevenuesLastYear,\"Caution: some data are not being reported correctly\",\"\")","v":""}]
[null,null,"The cheaper the paper, the more valuable the information -- Peter Lynch",null,null,null,null,"(Company)",null,null,{"$f":"IF(Data!G15=\"data missing\", \"It appears the most recent annual data are missing\", \"Financial Data from Zacks\")","v":"Financial Data from Zacks"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(RevenuesThisYear=RevenuesLastYear,\"It appears last year data and this year data are the same\",\"\")","v":""}]
[null,null,{"$f":"IF(D4=\"capitalization: SmallCap\",\"(Less than 1 Billion in sales)\",IF(D4=\"capitalization: MidCap\",\"(5 Billion to 10 Billion in sales)\",IF(D4=\"capitalization: largeCap\",\"(Over 10 Billion in sales)\")))","v":"(Over 10 Billion in sales)"},{"$f":"IF(Data!G40<=1000,\"Capitalization: SmallCap\",IF(Data!G40>=10000,\"Capitalization: LargeCap\",IF(Data!G40<500000,\"Capitalization: MidCap\",\"\")))","v":"Capitalization: LargeCap"},null,"Fiscal Year End date:",null,null,{"$f":"Data!C17","v":"2017-09-30"},null,{"$f":"IF(ISERROR(S75),\"\",S75)","v":52},"out of ",{"$f":"U75","v":100},{"$f":"IF(T75>693,\"CAUTION: DATA ARE MISSING. Close the spreadsheet and open it again.\",IF(T75=1,\"Caution: One data item is missing\",IF(ISERROR(K4),\"< #DIV/0 Indicates data are missing\",\"Total Points for this analysis\")))","v":"Total Points for this analysis"}]
[1,"Accounts Receivable",null,null,"Change:",{"$f":"IF(OR(X9<=0,COUNT(X8,X9)<2),0,(X8/X9)-1)","v":0.21755008703368706},{"$f":"IF(F5=0,\"No Accounts receivable data are reported for this company\",IF(F5>0.001,\"Oops - Wrong direction (Increasing)\",IF(F12<F5,\"Right direction, but Sales is declining faster\",IF(F5<0,\"OK!, Right direction (Decreasing)\",\"\"))))","v":"Oops - Wrong direction (Increasing)"},null,null,null,"Bullish Results",null,null,null,null,null,null,null,null,null,null,"SEE",null,"Millions","of dollars - except today's price"]
[null,null,"Days waiting for payment this year=",{"$f":"IF(ISNA(ARThisYear),\"N/A\",IF(OR(X22<=0,COUNT(X8,X22)<2),NA(),X8/(X22/365)))","v":56.800670930141251},{"$f":"IF(COUNT(F5)<1,\"\",IF(AND(F12>0,F5>0),\"Sales and Accounts Receivable are both increasing - If about equal, that's probably ok\",IF(F5>0,\"Rising Accts. Rec. means customers aren't paying their bills\",\"\")))","v":"Sales and Accounts Receivable are both increasing - If about equal, that's probably ok"},null,null,null,null,1,{"$f":"IF(F12>F5,\"Sales is increasing faster than Accts Receivable\",IF(F$5<0,\"Accounts Receivable is decreasing\",\"\"))","v":""},null,null,null,null,{"$f":"IF(K6=\"Sales is increasing faster than Accts Receivable\",Q6,0)","v":0},4,{"$f":"IF(ISNA(D6),\"N/A\",IF(D6<45,1,IF(D6<60,1,0)))","v":1},{"$f":"IF(T6=99,\"\",IF(R6>0,R6*3,0))","v":3},{"$f":"IF(ISERROR(R6),99,\"\")","v":""},4,{"$f":"IF(OR(K6=\"Sales is increasing faster than Accts Receivable\",K6=\"Accounts Receivable is decreasing\"),\"Line 1\",\"\")","v":""},null,null,"(from Balance Sheet)"]
[null,null,"Days waiting for payment prior year=",{"$f":"IF(OR(X23<=0,COUNT(X9,X23)<2),NA(),X9/(X23/365))","v":49.59276846952546},{"$f":"IF(ISNA(F5),\"N/A\",IF(AND(F5<0,F9>0),\"Accounts Receivable are decreasing but Inventories are increasing - why?\",IF(AND(F5>0,F9>0),\"Inventories are also increasing - are the increases substantial?\",IF(AND(F5<0,F9<0),\"Good - Both Accounts Receivable and Inventories are decreasing\",\"If Sales are increasing at a similar rate, good\"))))","v":"Inventories are also increasing - are the increases substantial?"},null,null,null,null,null,{"$f":"IF(ISERROR(F9),\"\",IF(F12>F9,\"Sales are growing faster than Inventories\",IF(F$9<0,\"Inventories are decreasing\",\"\")))","v":""},null,null,null,null,{"$f":"IF(K7=\"Sales are growing faster than Inventories\",Q7,0)","v":0},4,{"$f":"IF(E6=\"Sales and Accounts Receivable are both increasing - If about equal, that's probably ok\",1,0)","v":1},3,{"$f":"IF(ISERROR(R7),99,\"\")","v":""},4,{"$f":"IF(OR(K7=\"Sales are growing faster than inventories\",K7=\"Inventories are decreasing\"),\"Line 2\",\"\")","v":""},null,{"$f":"Data!C19","v":74181},"Cash & Cash Equivalents  "]
[null,null,null,"Below 60 is good - below 45 is superb)",null,null,null,null,null,"1a",{"$f":"IF(F$12>0,\"Sales are increasing\",\"\")","v":"Sales are increasing"},null,null,null,null,{"$f":"IF(K8=\"Sales are increasing\",Q8,0)","v":4},4,{"$f":"IF(G9=\"whoa, wrong direction (increasing)\",0,IF(G9=\"yes! - Right direction (Decreasing)\",1))","v":0},0,{"$f":"IF(ISERROR(R8),99,\"\")","v":""},4,{"$f":"IF(K8=\"Sales are increasing\",\"Line 3\",\"\")","v":"Line 3"},null,{"$f":"Data!M9","v":35673},"Accounts Receivable this year"]
[2,"Inventories",null,null,"Change:",{"$f":"IF(InventoriesThisYear=0,0,IF(OR(X11<=0,COUNT(X10,X11)<2),NA(),(X10/X11)-1))","v":1.2772045028142589},{"$f":"IF(F9=0,\"No Inventory data are reported for this company\",IF(COUNT(F9)<1,\"\",IF(F9>0.001,\"Whoa, wrong direction (Increasing)\",IF(F9<0,\"YES! - Right direction (Decreasing)\",\"\"))))","v":"Whoa, wrong direction (Increasing)"},null,null,null,{"$f":"IF(ISERROR(E15),\"\",IF(F$12>E$15,\"Sales are increasing faster than Cost of Sales\",\"\"))","v":"Sales are increasing faster than Cost of Sales"},null,null,null,null,{"$f":"IF(K9=\"Sales are increasing faster than Cost of Sales\",Q9,0)","v":4},4,{"$f":"IF(E10=\"CAUTION -- Both Accts. Receivable & Inventories are increasing\",0,IF(E10=\"Both Accts Rec. & Inventories are decreasing, that's positive.\",1,0))","v":0},0,"",4,{"$f":"IF(K9=\"Sales are increasing faster than Cost of Sales\",\"Line 4\",\"\")","v":"Line 4"},null,{"$f":"Data!L9","v":29299},"Accounts Receivable prior year"]
[null,null," Inventory Turnover Days this year =",{"$f":"Data!M27","v":9.4432131822863035},{"$f":"IF(COUNT(F9,F5)<2,\"\",IF(AND(F9>0,F5>0),\"CAUTION -- Both Accts. Receivable & Inventories are increasing\",IF(AND(F9<0,F5<0),\"Both Accts Rec. & Inventories are decreasing, that's positive.\",IF(F9>0,\"If Sales are flat or decreasing, Caution\",\"\"))))","v":"CAUTION -- Both Accts. Receivable & Inventories are increasing"},null,null,null,null,null,{"$f":"IF(ISERROR(F$21),\"This company has no long term debt\",IF(F$21<0,\"Debt is decreasing\",\"\"))","v":""},null,null,null,null,{"$f":"IF(K10=\"Debt is decreasing\",Q10,0)","v":0},4,{"$f":"IF(E11=\"CAUTION -- Both Accts. Receivable & Inventories are increasing\",0,IF(E11=\"Both Accts Rec. & Inventories are decreasing, that's positive.\",1,0))","v":0},{"$f":"IF(T10=99,\"\",IF(R10>0,R10*3,0))","v":0},"",3,{"$f":"IF(K10=\"Debt is decreasing\",\"Line 6\",\"\")","v":""},null,{"$f":"Data!M11","v":4855},"Inventories current year"]
[null,null,"Compare with other companies in the industry",null,{"$f":"IF(COUNT(F9)<1,\"\",IF(F9>0,\"If Inventories are rising faster than sales, competition or pricing are likely the problem\",\"\"))","v":"If Inventories are rising faster than sales, competition or pricing are likely the problem"},null,null,null,null,2,{"$f":"IF(ISERROR(F$27),\"\",IF(F$27>5,\"Interest Coverage is reasonable\",\"\"))","v":"Interest Coverage is reasonable"},null,null,null,null,{"$f":"IF(K11=\"Interest Coverage is reasonable\",Q11,0)","v":4},4,{"$f":"IF(G12=\"Way to GO! (Increasing)\",1,IF(G12=\"Oh-Oh - Wrong way\",0))","v":1},{"$f":"IF(T11=99,\"\",IF(R11>0,R11*3,0))","v":3},"",3,{"$f":"IF(K11=\"Interest Coverage is reasonable\",\"Line 8\",\"\")","v":"Line 8"},null,{"$f":"Data!L11","v":2132},"Inventories prior year"]
[3,"Sales or Revenues",null,null,"Change:",{"$f":"IF(OR(X23<=0,COUNT(X22,X23)<2),NA(),(X22/X23)-1)","v":6.304518199398057E-2},{"$f":"IF(COUNT(F12)<1,\"\",IF(F12>0,\"Way to GO! (Increasing)\",\"Oh-Oh - Wrong way\"))","v":"Way to GO! (Increasing)"},null,null,null,{"$f":"IF(ISERROR(E30),\"\",IF(E$30>G$30,\"Gross Profit Margin is growing\",\"\"))","v":"Gross Profit Margin is growing"},null,null,null,null,{"$f":"IF(K12=\"Gross Profit Margin is growing\",Q12,0)","v":4},4,{"$f":"IF(E13=\"Caution - Accts Receivables growing faster than sales\",0,IF(E13=\"OK (Sales growing faster than Accts Receivable)\",1,0))","v":0},0,"",3,{"$f":"IF(K12=\"Gross Profit Margin is growing\",\"Line 9\",\"\")","v":"Line 9"},null,{"$f":"Data!M13","v":128645},"Total Current Assets"]
[null,null,"Sales to Accts Receivable Ratio. . . . . . . . . . . . . .",null,{"$f":"IF(COUNT(F5,F12)<2,\"\",IF(F5>F12,\"Caution - Accts Receivables growing faster than sales\",\"OK (Sales growing faster than Accts Receivable)\"))","v":"Caution - Accts Receivables growing faster than sales"},null,null,null,null,"2a",{"$f":"IF(F32<0,\"Shares outstanding are decreasing\",\"\")","v":""},null,null,null,null,{"$f":"IF(K13=\"Shares outstanding are decreasing\",Q13,0)","v":0},4,{"$f":"IF(E14=\"Caution: Inventories growing faster than sales\",0,IF(E14=\"Sales to Inventories ratio is OK (Sales growing faster than Inventories)\",1,0))","v":0},0,"",3,{"$f":"IF(K13=\"Shares outstanding are decreasing\",\"Line 10\",\"\")","v":""},null,{"$f":"Data!G22","v":16597},"This Yr. Total Property Plant & Equip."]
[null,null,"Sales to Inventories Ratio. . . . . . . . . . . . . . . . . . . ",null,{"$f":"IF(F9>F12,\"Caution: Inventories growing faster than sales\",\"Sales to Inventories ratio is OK (Sales growing faster than Inventories)\")","v":"Caution: Inventories growing faster than sales"},null,null,null,null,null,{"$f":"IF(F$34>=F$12,\"Cash flow is growing faster than Sales\",\"\")","v":""},null,null,null,null,{"$f":"IF(K14=\"Cash flow is growing faster than Sales\",Q14,0)","v":0},4,{"$f":"IF(F15=\"Caution - Why is it increasing?\",-1,IF(F15=\"Cost of Sales is increasing but so is Sales\",1,0))","v":0},0,"",4,{"$f":"IF(K14=\"Cash flow is growing faster than Sales\",\"Line 11\",\"\")","v":""},null,{"$f":"Data!L22","v":27010},"Prior Yr. Total Property Plant & Equip."]
[4,"Cost of Sales",null,{"$f":"IF(COUNT(E15)<1,\"\",IF(E15<0.01,\"Down\",IF(E15>0.01,\"Up\",\"Even\")))","v":"Down"},{"$f":"IF(COUNT(X24,X25)<2,NA(),(X24/X25)-1)","v":-5.0348304797876331E-2},{"$f":"IF(COUNT(E15)<1,\"\",IF(E15<0.03,\"A small change isn't considered too serious\",IF(F12>E15,\"Cost of Sales is increasing but so is Sales\",IF(E15>0.03,\"Caution - Why is it increasing?\",\"\"))))","v":"A small change isn't considered too serious"},null,null,null,null,{"$f":"IF(F$39>0.1,\"Free cash flow growth is excellent\",\"\")","v":"Free cash flow growth is excellent"},null,null,null,null,{"$f":"IF(K15=\"Free cash flow growth is excellent\",Q15,0)","v":4},4,{"$f":"IF(F16=\"CAUTION - Cost of Sales increasing faster than Sales\",-1,IF(F16=\"Good - Sales increasing faster than Cost of Sales\",1,0))","v":1},3,"",4,{"$f":"IF(K15=\"Free cash flow growth is excellent\",\"Line13\",\"\")","v":"Line13"},null,{"$f":"Data!M25","v":100814},"Total Current Liabilities"]
[null,"[Cost of sales this year/Cost of sales prior year as a % change]",null,null,null,{"$f":"IF(ISERROR(E15),\"Data is missing or not available\",IF((X24/X25)>(X22/X23),\"CAUTION - Cost of Sales increasing faster than Sales\",\"Good - Sales increasing faster than Cost of Sales\"))","v":"Good - Sales increasing faster than Cost of Sales"},null,null,null,null,{"$f":"IF(F$41*100>X$35,\"Return on Free Cash flow is good\",\"\")","v":"Return on Free Cash flow is good"},null,null,null,null,{"$f":"IF(K16=\"Return on Free Cash flow is good\",Q16,0)","v":4},4,{"$f":"IF(F17=\"CAUTION - Cost of Sales increasing faster than Sales\",-1,IF(F17=\"Good - Sales increasing faster than Cost of Sales\",1,0))","v":-1},0,{"$f":"IF(ISERROR(R16),99,\"\")","v":""},4,{"$f":"IF(K16=\"Return on Free Cash flow is good\",\"Line 14\",\"\")","v":"Line 14"},null,{"$f":"IF(ISERROR(Data!G29),0,Data!G29)","v":0},"Long-term Debt this year"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F$48>0.1,\"Return on Assets is adequate\",\"\")","v":"Return on Assets is adequate"},null,null,null,null,{"$f":"IF(K17=\"Return on Assets is adequate\",Q17,0)","v":4},4,{"$f":"IF(G18=\"Caution - The investment in PP&E is flat or decreasing\",-1,IF(G18=\"OK - (Sales should grow as fast)\",1,0))","v":-1},0,"",3,{"$f":"IF(K17=\"Return on Assets is adequate\",\"Line 17\",\"\")","v":"Line 17"},null,{"$f":"IF(ISERROR(Data!F29),0,Data!F29)","v":0},"Long-term Debt prior year"]
[5,"Plant & Equipment",null,null,"Change:",{"$f":"IF(COUNT(X13,X14)<2,NA(),X13/X14-1)","v":-0.38552388004442795},{"$f":"IF(COUNT(F18)<1,\"\",IF(F18>0,\"OK - (Sales should grow as fast)\",\"Caution - The investment in PP&E is flat or decreasing\"))","v":"Caution - The investment in PP&E is flat or decreasing"},null,null,null,{"$f":"IF(F$50>0.15,\"Return on Equity is adequate\",\"\")","v":"Return on Equity is adequate"},null,null,null,null,{"$f":"IF(K18=\"Return on Equity is adequate\",Q18,0)","v":4},4,{"$f":"IF(F19=\"Oops - Sales aren't growing as fast\",-1,IF(F19=\"Way to GO! Sales are growing faster\",1,0))","v":1},3,"",3,{"$f":"IF(K18=\"Return on Equity is adequate\",\"Line 18\",\"\")","v":"Line 18"},null,{"$f":"Data!G32","v":6359.4},"Common Shares Outstanding this Yr."]
[null,null,"(Sales should be increasing as fast or faster).",null,null,{"$f":"IF(COUNT(F12,F18)<2,\"\",IF(F12>F18,\"Way to GO! Sales are growing faster\",\"Oops - Sales aren't growing as fast\"))","v":"Way to GO! Sales are growing faster"},null,null,null,3,{"$f":"IF(ISERROR(Net_Income),\"\",IF(E$55<F$55,\"Net Cash is growing faster than Net Income\",\"\"))","v":""},null,null,null,null,{"$f":"IF(K19=\"Net Cash is growing faster than Net Income\",Q19,0)","v":0},4,null,null,"",null,{"$f":"IF(K19=\"Net Cash is growing faster than Net Income\",\"Line 20\",\"\")","v":""},null,{"$f":"Data!F32","v":5864.8},"Common Shares Outstanding prior Yr."]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E$57>(CurrentPrice*0.1),\"Cash Position per Share is worth noting\",\"\")","v":""},null,null,null,null,{"$f":"IF(K20=\"Cash Position per Share is worth noting\",Q20,0)","v":0},4,{"$f":"IF(ISERROR(F21),\"\",IF(LTDebtThisYEar=0,1,IF(G21=\"Wrong direction (Increasing)\",-1,IF(G21=\"Right direction (Decreasing)\",1,0))))","v":1},{"$f":"IF(T20=99,\"\",IF(R20>0,R20*3,0))","v":3},"",2,{"$f":"IF(K20=\"Cash Position per Share is worth noting\",\"Line 21\",\"\")","v":""},null,{"$f":"Data!G28","v":41547},"Total Stockholders Equity"]
[6,"Long-term Debt",null,null,"Change:",{"$f":"IF(AND(LTDebtThisYEar>0,LTDebtLastYear=0),1,IF(LTDebtThisYEar+LTDebtLastYear>0,X16/X17-1,0))","v":0},{"$f":"IF(ISERROR(LTDebtThisYEar),\"Company has no debt or it has not been reported\",IF(AND(F21>\"0\",LTDebtLastYear=\"0\"),\"Company has taken on new debt this year\",IF(LTDebtThisYEar=0,\"No long term debt can be very positive\",IF(F21>0.02,\"Wrong direction (Increasing)\",IF(F21<0,\"Right direction (Decreasing)\",\"No substantial change\")))))","v":"No long term debt can be very positive"},null,null,null,{"$f":"IF(CurrentPrice*0.1*2<D$57,\"Cash Position per Share is greater than 20% of the current price\",\"\")","v":""},null,null,null,null,{"$f":"IF(K21=\"Cash Position per Share is greater than 20% of the current price\",Q21,0)","v":0},4,{"$f":"IF(ISERROR(F22),\"\",IF(LTDebtThisYEar=0,1,IF(G22=\"Wrong direction (Increasing)\",-1,IF(G22=\"Right direction (Decreasing)\",1,0))))","v":1},{"$f":"IF(T21=99,\"\",IF(R21>0,R21*3,0))","v":3},{"$f":"IF(ISERROR(R21),99,\"\")","v":""},2,{"$f":"IF(K21=\"Cash Position per Share is greater than 20% of the current price\",\"Line 21\",\"\")","v":""},null,null,"(from Statement of Earnings)"]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(LTDebtThisYEar),\"\",IF(F21=\"up\",\"\",IF(LTDebtThisYEar<0.001,\"\",IF(F24>0.25,\"Debt to Equity Ratio is High\",\"Debt to Equity Ratio is OK\"))))","v":""},null,null,"3a",{"$f":"IF(ISERROR(LTDebtThisYEar),\"\",IF(F$24=0,\"No debt can be very positive--particularly in a down economy\",IF(F$24<0.26,\"Debt to Equity ratio is reasonable\",\"\")))","v":"No debt can be very positive--particularly in a down economy"},null,null,null,null,{"$f":"IF(OR(K22)=\"Debt to Equity ratio is reasonable\",K22=\"No debt can be very positive--particularly in a down economy\",Q22)","v":true},4,{"$f":"IF(G22=\"Debt to Equity Ratio is High\",-1,IF(G22=\"Debt to Equity Ratio is OK\",1,1))","v":1},{"$f":"IF(T22=99,\"\",IF(R22>0,R22*3,0))","v":3},"",3,{"$f":"IF(OR(K22=\"No debt can be very positive--particularly in a down economy\",K22=\"Debt to Equity ratio is reasonable\"),\"Line 7\",\"\")","v":"Line 7"},null,{"$f":"Data!M39","v":229234},"Total Sales or Revenues this Year"]
[null,null,null,null,null,null,{"$f":"IF(COUNT(F21)<1,\"\",IF(F21=0,\"\",IF(F21>0.02,\"Why are they taking on more debt?  What is the debt to equity ratio?\",\"A small change isn't considered a serious negative.\")))","v":""},null,null,null,{"$f":"IF(F37>2,\"The dividend payout ratio appears to be sustainable\",\"\")","v":"The dividend payout ratio appears to be sustainable"},null,null,null,null,{"$f":"IF(K23=\"The dividend payout ratio appears to be sustainable\",Q23,0)","v":4},4,{"$f":"IF(ISERROR(F27),1,IF(G22=\"Debt to Equity Ratio is OK\",1,IF(G27=\"Caution, company may be weak financially.\",0)))","v":false},{"$f":"IF(T23=99,\"\",IF(R23>0,R23*3,0))","v":0},"",3,{"$f":"IF(K23=\"The dividend payout ratio appears to be sustainable\",\"Line 12\",\"\")","v":"Line 12"},null,{"$f":"Data!L39","v":215639},"Total Sales or Revenues prior Year"]
[7,"LT Debt to Equity Ratio:",null,null,"debt to equity.",{"$f":"IF(LTDebtThisYEar=\"--\",0,X16/X20)","v":0},{"$f":"IF(ISERROR(LTDebtThisYEar),\"Company has no debt or it has not been reported\",IF(COUNT(F24)<1,\"\",IF(F24>0.26,\"Long-term debt may be excessive\",IF(F24=0,\"The company has no Long-term Debt\",\"Long-term Debt is in normal range\"))))","v":"The company has no Long-term Debt"},null,null,null,{"$f":"IF(ISERROR(D81),\"\",IF(D81>H81,\"Gross Profit Margin is greater than the industry average\",\"\"))","v":""},null,null,null,null,{"$f":"IF(K24=\"Gross Profit Margin is greater than the industry average\",Q24,0)","v":0},4,{"$f":"IF(G24=\"Long-term Debt is in normal range\",1,0)","v":0},{"$f":"IF(T24=99,\"\",IF(R24>0,R24*3,0))","v":0},{"$f":"IF(ISERROR(R24),99,\"\")","v":""},3,{"$f":"IF(K24=\"Gross Profit Margin is greater than the industry average\",\"Line 30\",\"\")","v":""},null,{"$f":"Data!G60","v":106606},"Cost of Sales this Year"]
[null,null,"[Long-term Debt / Total Equity]","  Normal Long-term Debt -- Less than 25%.",null,null,{"$f":"IF(COUNT(F24)<1,\"\",IF(F24>0.26,\"Is the ROE greater than interest rates?  Also see Free Cash Flow Ratio\",\"\"))","v":""},null,null,null,{"$f":"IF(F$46>E$46,\"The growth in Sales is greater than the growth in Assets\",\"\")","v":""},null,null,null,null,{"$f":"IF(K25=\"The growth in Sales is greater than the growth in Assets\",Q25,0)","v":0},4,null,null,"",null,{"$f":"IF(K25=\"The growth in Sales is greater than the growth in Assets\",\"Line 16\",\"\")","v":""},null,{"$f":"Data!F60","v":112258},"Cost of Sales prior Year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,{"$f":"Data!G48","v":50155},"Income before Taxes"]
[8,"Total Interest Coverage",null,"Pretax exceeds interest X times ",null,{"$f":"IF(OR(X29<=0,COUNT(X26,X29)<2),\"N/A\",(X26+X29)/X29)","v":20.357390968737938},{"$f":"IF(ISERROR(LTDebtThisYEar),\"Company has no debt or it has not been reported\",IF(F27=\"n/a\",\"The data source reports no interest was paid on debt this year\",IF(TotalInterestPaidonDebt=0,\"With no LT debt, this item is Not Applicable\",IF(F27>4.99,\"Large numbers aren't as useful as small.\",\"\"))))","v":"Large numbers aren't as useful as small."},null,null,null,null,null,null,null,null,{"$f":"IF(K27=\"Short interest is fairly low and decreasing\",Q27,0)","v":4},4,{"$f":"IF(F28=\"Caution, Interest Coverage is VERY worrysome\",-3,IF(F28=\"Caution, Interest Coverage is worrysome\",-2,IF(F28=\"This company appears to be in good shape financially.\",1,0)))","v":1},{"$f":"IF(T27=99,\"\",IF(R27>0,R27*3,0))","v":3},"",3,null,null,{"$f":"Data!G49","v":37037},"This Yr. Net Income"]
[null,null,"[Pretax Profit + Total Interest Paid / Total Interest Paid]",null,null,{"$f":"IF(COUNT(F27)<1,\"\",IF(F27>4.99,\"This company appears to be in good shape financially.\",IF(F27>2.9999,\"Caution, Interest Coverage is worrysome\",\"CAUTION, Interest Coverage is VERY worrysome\")))","v":"This company appears to be in good shape financially."},null,null,null,null,null,null,null,null,null,{"$f":"COUNT(P6:P27)","v":20},{"$f":"SUM(Q6:Q27)","v":88},null,null,"",null,null,null,{"$f":"Data!F49","v":39510},"Prior Yr. Net Income"]
[null,null,null,null,null,null,"Any number below 5 is worrisome.  A number below 3 is very worrisome",null,null,null,"Bearish Results",null,null,null,null,null,null,{"$f":"IF(H30=\"Caution the Gross Margin is decreasing\",0,IF(H30=\"Good, Gross Profit is increasing\",1,0))","v":1},{"$f":"IF(T29=99,\"\",IF(R29>0,R29*2,0))","v":2},"",2,"SEE",null,{"$f":"IF(ISERROR(Data!G56),0,Data!G56)","v":2591},"Total Interest Paid on Debt "]
[9,"Gross Profit Margin",null,"This year=",{"$f":"ROUND((RevenuesThisYear-CostsThisYear)/RevenuesThisYear,3)","v":0.53500000000000003},"Prior Year=",{"$f":"ROUND((RevenuesLastYear-CostsLastYear)/RevenuesLastYear,3)","v":0.47899999999999998},{"$f":"IF(G30>E30,\"Caution the Gross Margin is decreasing\",IF(G30<E30,\"Good, Gross Profit is increasing\",\"\"))","v":"Good, Gross Profit is increasing"},null,4,{"$f":"IF(F$5>0,\"Accounts Receivable is increasing\",\"\")","v":"Accounts Receivable is increasing"},null,null,null,null,{"$f":"IF(K30=\"Accounts Receivable is increasing\",Q30,0)","v":-4},-4,null,null,"",null,{"$f":"IF(K30=\"Accounts Receivable is increasing\",\"Line 1\",\"\")","v":"Line 1"},null,null,"(from Statement of Cash Flows)"]
[null,null,"[Sales - Cost of Sales / Sales]",null,null,null,null,null,null,null,{"$f":"IF(ISERROR(F9),\"\",IF(F$9>0,\"Inventories are increasing\",\"\"))","v":"Inventories are increasing"},null,null,null,null,{"$f":"IF(K31=\"Inventories are increasing\",Q31,0)","v":-4},-4,{"$f":"IF(G32=\"Wrong direction (Increasing)--Dilution is occuring\",-1,IF(G32=\"Right Direction (Decreasing)\",1,0))","v":-1},{"$f":"IF(T31=99,\"\",IF(R31>0,R31*3,0))","v":0},"",3,{"$f":"IF(K31=\"Inventories are increasing\",\"Line 2\",\"\")","v":"Line 2"},null,{"$f":"Data!M64","v":63598},"This Yr.-Net Cash provided by Operations"]
[10,"Number of shares outstanding trend:",null,null,{"$f":"IF(F32<1.02,\"Down\",IF(F32>1.02,\"Up\",\"Even\"))","v":"Down"},{"$f":"IF(OR(X19<=0,COUNT(X18,X19)<2),\"UP\",(X18/X19)-1)","v":8.4333651616423255E-2},{"$f":"IF(F32=\"UP\",\"Company has not reported common shares last year\",IF(F32>0.02,\"Wrong direction (Increasing)--Dilution is occuring\",IF(F32=0,\"No significant change\",IF(F32<0,\"Right Direction (Decreasing)\",IF(F32<=0.02,\"A small change is not important\")))))","v":"Wrong direction (Increasing)--Dilution is occuring"},null,null,null,{"$f":"IF(F$12<0,\"Sales are decreasing\",\"\")","v":""},null,null,null,null,{"$f":"IF(K32=\"Sales are decreasing\",Q32,0)","v":0},-4,null,null,"",null,{"$f":"IF(K32=\"Sales are decreasing\",\"Line 3\",\"\")","v":""},null,{"$f":"Data!L64","v":65824},"Prior Yr. -Net Cash provided by Operations"]
[null,null,"[Curr. Yr. Shares/Prior Yr. Shares]",null,null,{"$f":"IF(COUNT(F32)<1,\"\",IF(F32<0.02,\"A small change of up to about 2% isn't considered too consequencial\",\"\"))","v":""},null,null,null,null,{"$f":"IF(F9>F12,\"Inventories are growing faster than sales\",\"\")","v":"Inventories are growing faster than sales"},null,null,null,null,{"$f":"IF(K33=\"Inventories are growing faster than sales\",Q33,0)","v":-4},-4,null,null,"",null,{"$f":"IF(K33=\"Inventories are growing faster than sales\",\"Line 3\",\"\")","v":"Line 3"},null,{"$f":"Data!M54","v":12770},"Dividends"]
[11,"Operating Cash flow Change",null,null,null,{"$f":"Data!M52","v":-7.1244794567783321E-2},"Cash flow should increase at the same rate as Sales - or greater",null,null,null,{"$f":"IF(ISERROR(E15),\"\",IF(F$12<E$15,\"Cost of Sales is growing faster than Sales\",\"\"))","v":""},null,null,null,null,{"$f":"IF(K34=\"Cost of Sales is growing faster than Sales\",Q34,0)","v":0},-4,{"$f":"IF(F35=\"Caution - Cashflow is not increasing at or better than the Sales rate\",0,IF(G35=\"Cashflow is growing faster than Sales\",1,0))","v":0},{"$f":"IF(T34=99,\"\",IF(R34>0,R34*3,0))","v":0},"",3,{"$f":"IF(K34=\"Cost of Sales is growing faster than Sales\",\"Line 4\",\"\")","v":""},null,{"$f":"Data!E75","v":190.29},"Price"]
[null,"(Curr. Yr. PreTax + Depreciation - Taxes / Prior Yr. PreTax + Depreciation - Taxes]",null,null,null,{"$f":"IF(COUNT(NetCashOperationsThisYear,NetCashOperationsLastYear,RevenuesThisYear,RevenuesLastYear)<4,\"\",IF(F34>F12,\"Cashflow is growing faster than Sales\",IF(F34=\"NMF\",\"This ratio is not meaningful -- Caution is advised\",\"Caution - Cashflow is not increasing at or better than the Sales rate\")))","v":"Caution - Cashflow is not increasing at or better than the Sales rate"},null,null,null,null,{"$f":"IF(ISERROR(F$21),\"\",IF(F$21>0.25,\"Long Term Debt is increasing\",\"\"))","v":""},null,null,null,null,{"$f":"IF(K35=\"Long Term Debt is increasing\",Q35,0)","v":0},-4,null,null,"",null,{"$f":"IF(K35=\"Long Term Debt is increasing\",\"Line 6\",\"\")","v":""},null,{"$f":"Data!C118/100","v":2.9500000000000002E-2},"10 Year Note rate"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(F$27),\"\",IF(F$27<5,\"Caution--Interest Coverage is low or data are missing\",\"\"))","v":""},null,null,null,null,{"$f":"IF(K36=\"Caution--Interest Coverage is low or data are missing\",Q36,0)","v":0},-4,{"$f":"IF(G37=\"\",0,IF(G37=\"ratio is probably sufficient--the dividend is not likely to be cut\",1,0))","v":1},{"$f":"IF(T36=99,\"\",IF(R36>0,R36*3,0))","v":3},"",3,{"$f":"IF(K36=\"Caution--Interest Coverage is low or data are missing\",\"Line 8\",\"\")","v":""}]
[12,"Dividend to Cash from Operations ratio ",null,null,null,{"$f":"Data!N57","v":4.9802662490211436},{"$f":"IF(AND(Data!M54=0,SUM(Data!I54:M54)>0),\"Company paid a dividend in the past but data for most recent quarter is missing--why?\",IF(Data!M54=0,\"The company pays no dividend\",IF(F37>=2,\"Ratio is probably sufficient--the dividend is not likely to be cut\",IF(AND(F37>=1,F37<2),\"The ratio is low--can the current dividend be continued?\",IF(F37<1,\"The dividend is in danger of being cut or eliminated\",\"\")))))","v":"Ratio is probably sufficient--the dividend is not likely to be cut"},null,null,null,{"$f":"IF(ISERROR(E30),\"\",IF(E$30<G$30,\"Gross Profit Margin is not growing\",\"\"))","v":""},null,null,null,null,{"$f":"IF(K37=\"Gross Profit Margin is not growing\",Q37,0)","v":0},-4,null,null,"",null,{"$f":"IF(K37=\"Gross Profit Margin is not growing\",\"Line 9\",\"\")","v":""}]
[null,null,"Indicates if there is enough cash flow to cover the dividend",null,null,null,null,null,null,null,{"$f":"IF(F39<0.1,\"Free cash flow margin should be higher\",\"\")","v":""},null,null,null,null,{"$f":"IF(K38=\"Free cash flow margin should be higher\",Q38,0)","v":0},-4,{"$f":"IF(G39=\"OOPS, anything less than 10 is bad news\",0,IF(G39=\"Anything over 10 is Great - Substantially over 10 is EXCELLENT\",1,0))","v":1},{"$f":"IF(T38=99,\"\",IF(R38>0,R38*3,0))","v":3},"",3,{"$f":"IF(K38=\"Free cash flow margin should be higher\",\"Line 13\",\"\")","v":""}]
[13,"Free Cash Flow Margin",null,null,null,{"$f":"Data!N60","v":0.27743702941099485},{"$f":"IF(COUNT(F39)<1,\"\",IF(F39<0.098,\"OOPS, anything less than 10 is bad news\",\"Anything over 10 is Great - Substantially over 10 is EXCELLENT\"))","v":"Anything over 10 is Great - Substantially over 10 is EXCELLENT"},null,null,null,{"$f":"IF(F32>=0.02,\"Shares outstanding are increasing\",\"\")","v":"Shares outstanding are increasing"},null,null,null,null,{"$f":"IF(K39=\"Shares outstanding are increasing\",Q39,0)","v":-4},-4,null,null,"",null,{"$f":"IF(K39=\"Shares outstanding are increasing\",\"Line 10\",\"\")","v":"Line 10"},null,"See www.Investopedia.com for item definitions"]
[null,null,"[Free Cash Flow / Sales]",null,null,null,null,null,null,null,{"$f":"IF(F$34<F$12,\"Sales is growing slower than Cash flow\",\"\")","v":"Sales is growing slower than Cash flow"},null,null,null,null,{"$f":"IF(K40=\"Sales is growing slower than Cash flow\",Q40,0)","v":-4},-4,null,null,{"$f":"IF(ISERROR(R40),99,\"\")","v":""},null,{"$f":"IF(K40=\"Sales is growing slower than Cash flow\",\"Line 11\",\"\")","v":"Line 11"}]
[14,"Return on free cash flow - compare to yield on 10 year Note",null,null,null,{"$f":"IF(Dividends=0,\"Caution\",(NetCashOperationsThisYear-PPEThisYear-Dividends)/CommonSharesThisYear)/CurrentPrice","v":2.828703825798002E-2},{"$f":"IF(F41<X35/100,\"The return is less than the 10 year note.  Is company spending cash wisely?\",IF(F41>X35/100,\"Good - Free Cashflow return is greater than the 10 year note rate\",\"\"))","v":"Good - Free Cashflow return is greater than the 10 year note rate"},null,null,null,{"$f":"IF(ISERROR(LTDebtThisYEar),\"\",IF(F$24=0,\"\",IF(F$24>0.26,\"Debt to Equity is high\",\"\")))","v":""},null,null,null,null,{"$f":"IF(K41=\"Debt to Equity is high\",Q41,0)","v":0},-4,null,null,{"$f":"IF(ISERROR(R41),99,\"\")","v":""},null,{"$f":"IF(K41=\"Debt to Equity is high\",\"Line 7\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F$46<E$46,\"The growth in Sales is less than the growth in Assets\",\"\")","v":""},null,null,null,null,{"$f":"IF(K42=\"The growth in Sales is less than the growth in Assets\",Q42,0)","v":0},-4,null,null,null,null,{"$f":"IF(K42=\"The growth in Sales is less than the growth in Assets\",\"Line 16\",\"\")","v":""},null,{"$f":"IF(COUNT(rngBalanceSheet)=14,\"...\",333)","v":"..."}]
[15,"Earnings Yield - compare to yield on 10 year Note",null,null,null,{"$f":"CurrentPrice/Data!G58/100","v":0.33501760563380278},{"$f":"IF(F43-0.02>X35,\"Earnings Yield is significantly greater than the 10 year note rate\",\"Earnings Yield is not significantly higher than the 10 year note rate.\")","v":"Earnings Yield is significantly greater than the 10 year note rate"},null,null,null,{"$f":"IF(F$41*100<X$35,\"Return on Free Cash flow is less than the 10 year bond rate\",\"\")","v":""},null,null,null,null,{"$f":"IF(K43=\"Return on Free Cash flow is less than the 10 year bond rate\",Q43,0)","v":0},-4,{"$f":"IF(F43-(F44+2)<1,1)","v":1},{"$f":"IF(T43=99,\"\",IF(R43>0,R43*1,0))","v":1},null,1,{"$f":"IF(K43=\"Return on Free Cash flow is less than the 10 year bond rate\",\"Line 14\",\"\")","v":""}]
[null,null,"[Inverse of the P/E ---  Price / Earnings]",null,"10 Year Note Yield =",{"$f":"X35","v":2.9500000000000002E-2},"Earnings Yield should exceed 10 year Note yield by at least 2%",null,null,null,{"$f":"IF(F$48<0.1,\"Return on Assets should be higher\",\"\")","v":""},null,null,null,null,{"$f":"IF(K44=\"Return on Assets should be higher\",Q44,0)","v":0},-4,null,null,"",null,{"$f":"IF(K44=\"Return on Assets should be higher\",\"Line 17\",\"\")","v":""}]
[null,null,null,null,"Asset growth","Sales growth",null,null,null,null,{"$f":"IF(F$50<0.15,\"Return on Equity is inadequate\",\"\")","v":""},null,null,null,null,{"$f":"IF(K45=\"Return on Equity is inadequate\",Q45,0)","v":0},-4,null,null,"",null,{"$f":"IF(K45=\"Return on Equity is inadequate\",\"Line 18\",\"\")","v":""}]
[16,"Asset Utilization ",null,null,{"$f":"ROUND(Data!M41,3)","v":6.3E-2},{"$f":"ROUND(F12,3)","v":6.3E-2},{"$f":"IF(E46>F46,\"Good, Sales is growing faster than Assets\",IF(F46>E46,\"Caution-Assets are growing faster than Sales\",\"\"))","v":""},null,null,"5a",{"$f":"IF(E$55>F$55,\"Net Cash is not growing as fast or faster than Net Income\",\"\")","v":"Net Cash is not growing as fast or faster than Net Income"},null,null,null,null,{"$f":"IF(K46=\"Net Cash is not growing as fast or faster than Net Income\",Q46,0)","v":-4},-4,{"$f":"IF(F46>E46,1,0)","v":0},{"$f":"IF(T46=99,\"\",IF(R46>0,R46*3,0))","v":0},"",1,{"$f":"IF(K46=\"Net Cash is not growing as fast or faster than Net Income\",\"Line 20\",\"\")","v":"Line 20"}]
[null,null,"How well is management utilizing the assets of the company--turning them into Revenues/Sales?",null,null,null,null,null,null,null,{"$f":"IF(CurrentPrice*0.1*2>D$57,\"Cash Position per Share is less than 20% of the current price\",\"\")","v":"Cash Position per Share is less than 20% of the current price"},null,null,null,null,{"$f":"IF(K47=\"Cash Position per Share is less than 20% of the current price\",Q47,0)","v":-4},-4,{"$f":"IF(F43>0.05,1,0)","v":1},{"$f":"IF(T47=99,\"\",IF(R47>0,R47*3,0))","v":3},"",3,{"$f":"IF(K47=\"Cash Position per Share is less than 20% of the current price\",\"Line 21\",\"\")","v":"Line 21"}]
[17,"Return on Assets (ROA)",null,null,null,{"$f":"NetProfitThisYear/Data!G14","v":0.17892270531400967},"This measurement of profitability includes debt--an important factor",null,null,null,{"$f":"IF(F37=\"none\",\"\",IF(F37<=2,\"The dividend may be in danger of being cut\",\"\"))","v":""},null,null,null,null,{"$f":"IF(K48=\"The dividend may be in danger of being cut\",Q48,0)","v":0},-4,null,null,null,null,{"$f":"IF(K48=\"The dividend may be in danger of being cut\",\"Line 12\",\"\")","v":""}]
[null,null,"[Net Income / Total Assets]",null,null,null,"See Graph 6 for the reasons why",null,null,6]
[18,"Return on Equity (ROE)",null,null,null,{"$f":"NetProfitThisYear/TotalStockholdersEquity","v":0.89144823934339423},"This measurement of profitability does not include debt--an important factor",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"[Net Income / Total Equity]",null,null,null,"See graph 6 for the reasons why",null,null,null,null,null,null,null,null,null,null,null,null,""]
[19,"Earnings Confidence Rating -- Measures quality of Earnings",null,null,null,{"$f":"IF(OR(X31<=0,COUNT(X27,X31)<2),NA(),X31/X27)","v":1.7171477171477172},"The higher the number the higher the quality of Earnings. ",null,null,"7a",null,null,null,null,null,{"$f":"IF(K52=\"Short Interest is becoming a concern--Is it also increasing?\",Q52,0)","v":-4},-4]
[null,null,"[Net Cash from Operations / Net Income]",null,null,null,"One or less than one is very serious.  Earnings quality is very low.",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(F52),0,IF(F52>3,3,IF(F52>1.5,2,IF(F52<1,0))))","v":2},{"$f":"IF(T53=99,\"\",IF(R53>0,R53*3,0))","v":6},{"$f":"IF(ISERROR(R53),99,\"\")","v":""},1]
[null,null,null,null,"Net Income","Net Cash",null,null,null,8,null,null,null,null,null,{"$f":"COUNT(P30:P53)","v":20},{"$f":"SUM(Q30:Q52)","v":-80}]
[20,"Compare - Net Income with Net Cash",null,null,{"$f":"X28/X27-1","v":6.6771066771066812E-2},{"$f":"IF(OR(X32<=0,COUNT(X31,X32)<2),\"NA\",ROUND((X31/X32-1),2))","v":-0.03},{"$f":"IF(NetCashOperationsThisYear=\"--\",\"Data not reported\",IF(E55>F55,\"Oops - Net Cash is growing at a slower rate than Net Income\",IF(F55>E55,\"Net Cash is growing faster than Net Income.  That normally is positive\",\"\")))","v":"Oops - Net Cash is growing at a slower rate than Net Income"},null,null,null,{"$f":"Data!I76","v":""},null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"IF(COUNT(E55)<1,\"\",IF(E55<0.01,\"Caution - Net Income is declining\",\"Net Income is growing\"))","v":"Net Income is growing"},null,null,null,{"$f":"IF(COUNT(F55)<1,\"\",IF(F55<0.01,\"    Caution - Net Cash is declining\",\"    Net Cash is growing\"))","v":"    Caution - Net Cash is declining"},null,null,"6a",null,null,null,null,null,{"$f":"IF(G55=\"Oops - Net Cash is growing at a slower rate than Net Income\",-1,IF(G55=\"Net Cash is growing faster than Net Income.  That normally is positive\",1,0))","v":-1},{"$f":"IF(R56=99,\"\",IF(P56>0,P56*3,0))","v":0},{"$f":"IF(G55=\"Oops - Net Cash is growing at a slower rate than Net Income\",-1,IF(G55=\"Net Cash is growing faster than Net Income.  That normally is positive\",1,0))","v":-1},{"$f":"IF(T56=99,\"\",IF(R56>0,R56*3,0))","v":0},"",3]
[21,"Cash Position per Share:",null,{"$f":"IF(COUNT(X18)<1,NA(),(X7)/X18)","v":11.664779696197755}," per share in cash beyond debt.",null,null,{"$f":"IF(COUNT(D57)<1,\"\",IF(D57>0.00001,\"This represents actual cash included in the\",\"A small or negative amount isn't considered too \"))","v":"This represents actual cash included in the"},null,null,null,null,null,null,null,{"$f":"IF(G56=\"    Caution - Net Cash is declining\",0,IF(G56=\"    Net Cash is growing\",1,0))","v":0},{"$f":"IF(R57=99,\"\",IF(P57>0,P57*3,0))","v":0},{"$f":"IF(G56=\"    Caution - Net Cash is declining\",0,IF(G56=\"    Net Cash is growing\",1,0))","v":0},{"$f":"IF(T57=99,\"\",IF(R57>0,R57*3,0))","v":0},"",3]
[null,null,"[Net Cash / Shrs outstanding]","  Offers price support in falling market if positive.",null,null,null,{"$f":"IF(COUNT(D57)<1,\"\",IF(D57>0.00001,\"price of each share of stock. If significant, (perhaps\",\"serious.  But if cash is shrinking and debt is growing,\"))","v":"price of each share of stock. If significant, (perhaps"},null,null,"Danger",null,null,null,null,{"$f":"IF(C56=\"Caution - Net Income is declining\",0,IF(C56=\"Net Income is growing\",1,0))","v":1},{"$f":"IF(R58=99,\"\",IF(P58>0,P58*3,0))","v":3},{"$f":"IF(C56=\"Caution - Net Income is declining\",0,IF(C56=\"Net Income is growing\",1,0))","v":1},{"$f":"IF(T58=99,\"\",IF(R58>0,R58*3,0))","v":3},"",3]
[null,null,{"$f":"IF(D57/CurrentPrice>0.2,\"Good, Cash Position is meaningful - greater than 20% of current price\",\"Oops, Cash Position is not meaningful - less than 20% of current price\")","v":"Oops, Cash Position is not meaningful - less than 20% of current price"},null,null,null,null,{"$f":"IF(COUNT(D57)<1,\"\",IF(D57>0.00001,\"20% of the share price) it's very positive.\",\"the company may be in weak financial shape.\"))","v":"20% of the share price) it's very positive."},null,null,"Caution",null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(F60>0.15,\"At greater than 15%, cash per share may become a factor at\",IF(D57>0.2,\"Cash position per share is:\"))","v":"Cash position per share is:"},null,null,null,{"$f":"D57/X34","v":6.1300014168888306E-2},null,null,null,null,"Good",null,null,null,null,{"$f":"IF(C59=\"Oops, Cash Position is not meaningful - less than 20% of current price\",-1,IF(C59=\"Good, Cash Position is meaningful - greater than 20% of current price\",1,0))","v":-1},{"$f":"IF(P60>0,P60*3,0)","v":0},{"$f":"IF(C59=\"Oops, Cash Position is not meaningful - less than 20% of current price\",-1,IF(C59=\"Good, Cash Position is meaningful - greater than 20% of current price\",1,0))","v":-1},{"$f":"IF(R60>0,R60*3,0)","v":0},"",3]
[24,null,null,null,null,null,null,null,null,null,"Very Good",null,null,null,null,{"$f":"IF(G24=\"Caution, Long-term debt may be excessive -- Check Section 2B of the SSG -- ROE\",-1,IF(G24=\"Long-term Debt is in normal range\",1,IF(E24=\"No long-term debt\",1,0)))","v":0},{"$f":"IF(R61=99,\"\",IF(P61>0,P61*3,0))","v":0},{"$f":"IF(G24=\"Caution, Long-term debt may be excessive -- Check Section 2B of the SSG -- ROE\",-1,IF(G24=\"Long-term Debt is in normal range\",1,IF(G24=\"No long-term debt\",1,0)))","v":0},{"$f":"IF(T61=99,\"\",IF(R61>0,R61*3,0))","v":0},"",2]
[null,null,"NOTE:  Ratios are more meaningful if compared to other companies in the same industry.  See below for competitors."]
[25,null,"Quick Ratio:",{"$f":"(TotalCurrentAssets-InventoriesThisYear)/X15","v":1.2279048544844962},"to 1","About 1:1 is normal.  The higher the better.",null,null,null,null,null,null,null,null,null,{"$f":"IF(D63>0.9999,1)","v":1},{"$f":"P63*1","v":1},{"$f":"IF(D63>0.9999,1)","v":1},{"$f":"R63*1","v":1},"",1]
[null,null,"[Total Assets - Inventories  / Total Liabilities]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,""]
[26,null,"Current Ratio ",{"$f":"IF(OR(X15<=0,COUNT(X12,X15)<2),NA(),X12/X15)","v":1.2760628484139107},"to 1","About 2:1 is normal for manufacturer.  1:1 normal for Utilities.",null,null,null,null,null,null,null,null,null,{"$f":"IF(D66>1.999,1)","v":false},{"$f":"P66*1","v":0},{"$f":"IF(D66>1.999,1)","v":false},{"$f":"R66*1","v":0},"",1]
[null,null,"(also called Working Capital Ratio)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"[Total Current Assets / Total Current Liabilities]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[27,null,"Inventory Turnover Ratio:",{"$f":"IF(X10=0,\"No\",X24/X10)","v":21.957981462409887},{"$f":"IF(D69=\"no\",\"inventory\",\"to 1\")","v":"to 1"},"The higher the ratio the better. Indicates quality merchandise & proper pricing.",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"[Cost of Sales / Inventory]",null,null,"Also note the number of days Inventories are held before they become a product and sold (See \"Inventories\" above).",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IF(D69>25,\"Why is this ratio so high? Check it out. Has Cost of Sales or Inventories changed greatly?\",\"Inventory Ratio appears to be in a normal range\")","v":"Inventory Ratio appears to be in a normal range"},null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[28,null,"Plant Turnover Ratio:",{"$f":"IF(COUNT(X22,X13)<2,NA(),X22/X13)","v":13.811773212026269},"to 1","The higher the ratio the better.  If plant or equipment are added, sales should increase.",null,null,null,null,null,null,null,null,null,{"$f":"IF(F71=\"Why is this ratio so high? Check it out. Has Cost of Sales or Inventories changed greatly?\",0,IF(F71=\"Inventory Ratio appears to be in a normal range\",1))","v":1},{"$f":"IF(R72=99,\"\",IF(P72>0,P72*3,0))","v":3},{"$f":"IF(F71=\"Why is this ratio so high? Check it out. Has Cost of Sales or Inventories changed greatly?\",0,IF(F71=\"Inventory Ratio appears to be in a normal range\",1))","v":1},{"$f":"IF(T72=99,\"\",IF(R72>0,R72*3,0))","v":3},"",2]
[null,null,"(Sales / Prop. Plant & Equip.)",null,"Be aware it takes time for a new plant to come on line and benefit sales.  Check to see what the funds for PP&E were spent for.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[29,null,"Price to Sales Ratio:",{"$f":"IF(OR(X22<=0,COUNT(X34,X22,X18)<3),NA(),X34/(X22/X18))","v":5.2790171876772201},null,"The lower the amount the better.  This is the amount invested for each dollar of sales. This ratio is Industry sensitive.",null,null,null,null,null,null,null,null,null,{"$f":"SUM(P3:P72)","v":50},{"$f":"SUM(Q6:Q72)","v":23},{"$f":"SUM(R6:R72)","v":14},52,0,100]
[null,null,"[Today's Price / Revenues per Share]",null,null,"This ratio will be higher for companies with high profit margins and growth.  Compare to same industry companies.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(R76),99,\"\")","v":""}]
[null,null,"NOTE:  If there are large changes in year to year results, check to see if acquisitions have skewed the results of the analysis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"IF(H$100-F$100<10,\"\",\"Fair Value may be out of date.  Please update the value.\")","v":""},null,null,null,null,null,null,null,null,"Copyright Bob Adams 2017  All Rights Reserved",null,null,null,null,null,null,null,""]
[null,null,"Closing Price",{"$f":"Data!D75","v":190.29},"CLICK HERE FOR INTRINSIC VALUE"]
[null,null,"Enter Discounted CF here >>>",29,{"$f":"IF(H80>0,\"Company is selling at a discount of:\",\"Company is over valued\")","v":"Company is over valued"},null,null,{"$f":"((D79/D80)-1)/-1","v":-5.5617241379310345}]
[null,null,"Discounted Cash Flow is not an automatic feature.  Click the link above. When on the site type in the ticker symbol."]
[null,null,{"$f":"IF(H82-F82>20,\"Enter the date IV the was updated (Todays date) >>\",\"Intrinsic Value is up to date\")","v":"Enter the date IV the was updated (Todays date) >>"},null,null,"2017-09-12",null,{"$f":"TODAY()","v":"2018-07-31"}]
[]
[null,null,"An attempt to provide accurate information on this spreadsheet has been made but is not guaranteed.  It uses data available from free data sites which change their formatting at times, which causes the tool to fail.  If a problem is noticed please email me.  bobatseattle@gmail.com"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(S99),99,\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Data","index":2,"n_rows":167,"n_cols":15,"rows_kept":167,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Analysis!E2","v":"aapl"}]
[]
[null,"Annual Balance Sheet Data"]
[{"$f":"MATCH(B4,AnnBS!A$200:A$500,0)","v":189},"All items in Millions except Per Share data.",{"$f":"OFFSET(INDEX(AnnBS!$A$200:$M$500,$A4,COLUMN()-COLUMN($A4)),1,0)","v":"2017-09-30"},{"$f":"OFFSET(INDEX(AnnBS!$A$200:$M$500,$A4,COLUMN()-COLUMN($A4)),1,0)","v":"2016-09-30"},{"$f":"OFFSET(INDEX(AnnBS!$A$200:$M$500,$A4,COLUMN()-COLUMN($A4)),1,0)","v":"2015-09-30"},{"$f":"OFFSET(INDEX(AnnBS!$A$200:$M$500,$A4,COLUMN()-COLUMN($A4)),1,0)","v":"2014-09-30"},{"$f":"OFFSET(INDEX(AnnBS!$A$200:$M$500,$A4,COLUMN()-COLUMN($A4)),1,0)","v":"2013-09-30"},null,{"$f":"G4","v":"2013-09-30"},{"$f":"F4","v":"2014-09-30"},{"$f":"E4","v":"2015-09-30"},{"$f":"D4","v":"2016-09-30"},{"$f":"C4","v":"2017-09-30"}]
[{"$f":"MATCH(B5,AnnBS!A$200:A$500,0)","v":189},"All items in Millions except Per Share data.",{"$f":"OFFSET(INDEX(AnnBS!$A$200:$M$500,$A5,COLUMN()-COLUMN($A5)),1,0)","v":"2017-09-30"},{"$f":"OFFSET(INDEX(AnnBS!$A$200:$M$500,$A5,COLUMN()-COLUMN($A5)),1,0)","v":"2016-09-30"},{"$f":"OFFSET(INDEX(AnnBS!$A$200:$M$500,$A5,COLUMN()-COLUMN($A5)),1,0)","v":"2015-09-30"},{"$f":"OFFSET(INDEX(AnnBS!$A$200:$M$500,$A5,COLUMN()-COLUMN($A5)),1,0)","v":"2014-09-30"},{"$f":"OFFSET(INDEX(AnnBS!$A$200:$M$500,$A5,COLUMN()-COLUMN($A5)),1,0)","v":"2013-09-30"}]
[]
[{"$f":"MATCH(B7,AnnBS!A$200:A$500,0)","v":192},"Cash & Equivalents",{"$f":"INDEX(AnnBS!$A$200:$M$500,$A7,COLUMN()-COLUMN($A7))","v":74181},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A7,COLUMN()-COLUMN($A7))","v":67155},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A7,COLUMN()-COLUMN($A7))","v":41601},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A7,COLUMN()-COLUMN($A7))","v":25077},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A7,COLUMN()-COLUMN($A7))","v":40546},null,{"$f":"G7","v":40546},{"$f":"F7","v":25077},{"$f":"E7","v":41601},{"$f":"D7","v":67155},{"$f":"C7","v":74181},"Annual data"]
[{"$f":"MATCH(B8,AnnBS!A$200:A$500,0)","v":{"$error":"#N/A"}},"  Marketable Securities",{"$f":"INDEX(AnnBS!$A$200:$M$500,$A8,COLUMN()-COLUMN($A8))","v":{"$error":"#N/A"}},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A8,COLUMN()-COLUMN($A8))","v":{"$error":"#N/A"}},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A8,COLUMN()-COLUMN($A8))","v":{"$error":"#N/A"}},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A8,COLUMN()-COLUMN($A8))","v":{"$error":"#N/A"}},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A8,COLUMN()-COLUMN($A8))","v":{"$error":"#N/A"}},null,{"$f":"IF(C8=\"--\",0,C8)","v":{"$error":"#N/A"}},{"$f":"IF(D8=\"--\",0,D8)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"Annual data"]
[{"$f":"MATCH(B9,AnnBS!A$200:A$500,0)","v":193},"Receivables",{"$f":"INDEX(AnnBS!$A$200:$M$500,$A9,COLUMN()-COLUMN($A9))","v":35673},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A9,COLUMN()-COLUMN($A9))","v":29299},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A9,COLUMN()-COLUMN($A9))","v":30343},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A9,COLUMN()-COLUMN($A9))","v":27219},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A9,COLUMN()-COLUMN($A9))","v":20641},null,{"$f":"G9","v":20641},{"$f":"F9","v":27219},{"$f":"E9","v":30343},{"$f":"D9","v":29299},{"$f":"C9","v":35673},"Annual data"]
[{"$f":"MATCH(B10,AnnBS!A$200:A$500,0)","v":195},"Inventories",{"$f":"INDEX(AnnBS!$A$200:$M$500,$A10,COLUMN()-COLUMN($A10))","v":4855},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A10,COLUMN()-COLUMN($A10))","v":2132},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A10,COLUMN()-COLUMN($A10))","v":2349},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A10,COLUMN()-COLUMN($A10))","v":2111},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A10,COLUMN()-COLUMN($A10))","v":1764},null,{"$f":"G10","v":1764},{"$f":"F10","v":2111},{"$f":"E10","v":2349},{"$f":"D10","v":2132},{"$f":"C10","v":4855},"Annual data"]
[null,null,null,null,null,null,null,null,{"$f":"IF(I10<0,-I10,I10)","v":1764},{"$f":"IF(J10<0,-J10,J10)","v":2111},2349,2132,4855,"Convert Inventories"]
[]
[{"$f":"MATCH(B13,AnnBS!A$200:A$500,0)","v":197},"Total Current Assets",{"$f":"INDEX(AnnBS!$A$200:$M$500,$A13,COLUMN()-COLUMN($A13))","v":128645},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A13,COLUMN()-COLUMN($A13))","v":106869},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A13,COLUMN()-COLUMN($A13))","v":89378},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A13,COLUMN()-COLUMN($A13))","v":68531},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A13,COLUMN()-COLUMN($A13))","v":73286},null,{"$f":"G13","v":73286},{"$f":"F13","v":68531},{"$f":"E13","v":89378},{"$f":"D13","v":106869},{"$f":"C13","v":128645},"Annual data"]
[{"$f":"MATCH(B14,AnnBS!A$200:A$500,0)","v":204},"Total Assets",{"$f":"INDEX(AnnBS!$A$200:$M$500,$A14,COLUMN()-COLUMN($A14))","v":375319},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A14,COLUMN()-COLUMN($A14))","v":321686},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A14,COLUMN()-COLUMN($A14))","v":290479},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A14,COLUMN()-COLUMN($A14))","v":231839},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A14,COLUMN()-COLUMN($A14))","v":207000},null,{"$f":"G14","v":207000},{"$f":"F14","v":231839},{"$f":"E14","v":290479},{"$f":"D14","v":321686},{"$f":"C14","v":375319}]
[null,null,null,null,null,null,{"$f":"IF(SUM(G9:G14)=0,\"Data missing\",\"\")","v":""},null,{"$f":"IF(ISERROR(I13),I14,I13)","v":73286},{"$f":"IF(ISERROR(J13),J14,J13)","v":68531},{"$f":"IF(ISERROR(K13),K14,K13)","v":89378},{"$f":"IF(ISERROR(L13),L14,L13)","v":106869},{"$f":"IF(ISERROR(M13),M14,M13)","v":128645},"if error(line 7, use line 8"]
[null,null,null,null,null,null,null,null,{"$f":"I9*365/G40","v":44.081475630448772},{"$f":"J9*365/F40","v":54.350146338794822},{"$f":"K9*365/E40","v":47.387608839826285},{"$f":"L9*365/D40","v":49.59276846952546},{"$f":"M9*365/C40","v":56.800670930141251},"Days waiting for payment--Receivables"]
[null,"Period Ending:",{"$f":"C4","v":"2017-09-30"}]
[null,{"$f":"IF(C19=0,\"Caution--Some data for this company are not available.\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"J14/I14-1","v":0.11999516908212571},{"$f":"K14/J14-1","v":0.25293414826668514},{"$f":"L14/K14-1","v":0.1074328953211765},{"$f":"M14/L14-1","v":0.16672469426708036},"Total Assets % change"]
[null,{"$f":"IF(C19=\"na\",\"Last year Balance Sheet data has not yet reported.\",\"\")","v":""},{"$f":"M7","v":74181},"(Warning if some data missing)",null,null,null,null,{"$f":"I49/I14","v":0.17892270531400967},{"$f":"J49/J14","v":0.17041998973425523},{"$f":"K49/K14","v":0.18381363196651049},{"$f":"L49/L14","v":0.14202358821956815},{"$f":"M49/M14","v":0.12882641166580963},"ROA"]
[null,"Do not remove lines 11 & 12 above --they contain verbiage ",null,null,null,null,null,null,null,null,null,null,null,"Net Income/Total Assets"]
[null,null,null,null,null,null,null,null,{"$f":"I49/I35","v":0.29977579745687943},{"$f":"J49/J35","v":0.35420047155010892},{"$f":"K49/K35","v":0.44735453060198566},{"$f":"L49/L35","v":0.35623669580269629},{"$f":"M49/M35","v":0.36070184338329092},"Return on Equity ROE"]
[{"$f":"MATCH(B22,AnnBS!A$200:A$500,0)","v":198},"Net Property & Equipment",{"$f":"INDEX(AnnBS!$A$200:$M$500,$A22,COLUMN()-COLUMN($A22))","v":33783},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A22,COLUMN()-COLUMN($A22))","v":27010},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A22,COLUMN()-COLUMN($A22))","v":22471},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A22,COLUMN()-COLUMN($A22))","v":20624},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A22,COLUMN()-COLUMN($A22))","v":16597},null,{"$f":"G22","v":16597},{"$f":"F22","v":20624},{"$f":"E22","v":22471},{"$f":"D22","v":27010},{"$f":"C22","v":33783}]
[{"$f":"MATCH(B23,AnnBS!A$200:A$500,0)","v":204},"Total Assets",{"$f":"INDEX(AnnBS!$A$200:$M$500,$A23,COLUMN()-COLUMN($A23))","v":375319},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A23,COLUMN()-COLUMN($A23))","v":321686},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A23,COLUMN()-COLUMN($A23))","v":290479},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A23,COLUMN()-COLUMN($A23))","v":231839},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A23,COLUMN()-COLUMN($A23))","v":207000},null,{"$f":"G23","v":207000},{"$f":"F23","v":231839},{"$f":"E23","v":290479},{"$f":"D23","v":321686},{"$f":"C23","v":375319}]
[{"$f":"MATCH(B24,AnnBS!A$200:A$500,0)","v":207},"Accounts Payable",{"$f":"INDEX(AnnBS!$A$200:$M$500,$A24,COLUMN()-COLUMN($A24))","v":49049},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A24,COLUMN()-COLUMN($A24))","v":37294},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A24,COLUMN()-COLUMN($A24))","v":35490},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A24,COLUMN()-COLUMN($A24))","v":30196},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A24,COLUMN()-COLUMN($A24))","v":22367},null,{"$f":"G24","v":22367},{"$f":"F24","v":30196},{"$f":"E24","v":35490},{"$f":"D24","v":37294},{"$f":"C24","v":49049}]
[{"$f":"MATCH(B25,AnnBS!A$200:A$500,0)","v":213},"Total Current Liabilities",{"$f":"INDEX(AnnBS!$A$200:$M$500,$A25,COLUMN()-COLUMN($A25))","v":100814},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A25,COLUMN()-COLUMN($A25))","v":79006},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A25,COLUMN()-COLUMN($A25))","v":80610},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A25,COLUMN()-COLUMN($A25))","v":63448},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A25,COLUMN()-COLUMN($A25))","v":43658},null,{"$f":"G25","v":43658},{"$f":"F25","v":63448},{"$f":"E25","v":80610},{"$f":"D25","v":79006},{"$f":"C25","v":100814}]
[{"$f":"MATCH(B26,AnnBS!A$200:A$500,0)","v":221},"Total Liabilities",{"$f":"INDEX(AnnBS!$A$200:$M$500,$A26,COLUMN()-COLUMN($A26))","v":241272},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A26,COLUMN()-COLUMN($A26))","v":193437},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A26,COLUMN()-COLUMN($A26))","v":171124},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A26,COLUMN()-COLUMN($A26))","v":120292},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A26,COLUMN()-COLUMN($A26))","v":83451},null,{"$f":"G26","v":83451},{"$f":"F26","v":120292},{"$f":"E26","v":171124},{"$f":"D26","v":193437},{"$f":"C26","v":241272},"Total Liabilities"]
[{"$f":"MATCH(B27,AnnBS!A$200:A$500,0)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,{"$f":"I40/I10","v":19.377551020408163},{"$f":"J40/J10","v":17.318332543818094},{"$f":"K40/K10","v":19.89910600255428},{"$f":"L40/L10","v":20.228799249530958},{"$f":"M40/M10","v":9.4432131822863035},"Inventory turnover Ratio"]
[{"$f":"MATCH(B28,AnnBS!A$200:A$500,0)","v":222},"Shareholders Equity",{"$f":"INDEX(AnnBS!$A$200:$M$500,$A28,COLUMN()-COLUMN($A28))","v":43008},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A28,COLUMN()-COLUMN($A28))","v":42643},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A28,COLUMN()-COLUMN($A28))","v":42277},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A28,COLUMN()-COLUMN($A28))","v":41912},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A28,COLUMN()-COLUMN($A28))","v":41547},null,null,null,null,null,null,"Total Revenue/Total Inventory"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M30/M35","v":0.72517102210418738},"Debt to Equity"]
[{"$f":"MATCH(B30,AnnBS!A$200:A$500,0)","v":217},"Long-Term Debt",{"$f":"INDEX(AnnBS!$A$200:$M$500,$A30,COLUMN()-COLUMN($A30))","v":97207},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A30,COLUMN()-COLUMN($A30))","v":75427},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A30,COLUMN()-COLUMN($A30))","v":53463},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A30,COLUMN()-COLUMN($A30))","v":28987},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A30,COLUMN()-COLUMN($A30))","v":16960},null,{"$f":"G30","v":16960},{"$f":"F30","v":28987},{"$f":"E30","v":53463},{"$f":"D30","v":75427},{"$f":"C30","v":97207},"LT Debt"]
[null,null,null,null,null,null,null,null,{"$f":"I68/I39","v":-4.7773682054882687E-2},{"$f":"J68/J39","v":-5.235920019694193E-2},{"$f":"K68/K39","v":-4.812271356138887E-2},{"$f":"L68/L39","v":-5.9052397757362998E-2},{"$f":"M68/M39","v":-5.4315677430049641E-2},"Cap expenditures as % of Sales"]
[{"$f":"MATCH(B32,AnnBS!A$200:A$500,0)","v":232},"Shares Outstanding",{"$f":"INDEX(AnnBS!$A$200:$M$500,$A32,COLUMN()-COLUMN($A32))","v":5165.2},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A32,COLUMN()-COLUMN($A32))","v":5388.4},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A32,COLUMN()-COLUMN($A32))","v":5702.7},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A32,COLUMN()-COLUMN($A32))","v":5864.8},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A32,COLUMN()-COLUMN($A32))","v":6359.4},null,{"$f":"G32","v":6359.4},{"$f":"F32","v":5864.8},{"$f":"E32","v":5702.7},{"$f":"D32","v":5388.4},{"$f":"C32","v":5165.2},"Shares"]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I13),I14/I35,I13/I25)","v":1.6786385084062485},{"$f":"IF(ISERROR(J13),J14/J35,J13/J25)","v":1.0801128483167317},{"$f":"IF(ISERROR(K13),K14/K35,K13/K25)","v":1.1087706239920605},{"$f":"IF(ISERROR(L13),L14/L35,L13/L25)","v":1.352669417512594},{"$f":"IF(ISERROR(M13),M14/M35,M13/M25)","v":1.2760628484139107},"Current Ratio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(Total Curr Ass-Inv)/Curr Liab"]
[{"$f":"MATCH(B35,AnnBS!A$200:A$500,0)","v":229},"Total Shareholder's Equity",{"$f":"INDEX(AnnBS!$A$200:$M$500,$A35,COLUMN()-COLUMN($A35))","v":134047},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A35,COLUMN()-COLUMN($A35))","v":128249},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A35,COLUMN()-COLUMN($A35))","v":119355},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A35,COLUMN()-COLUMN($A35))","v":111547},{"$f":"INDEX(AnnBS!$A$200:$M$500,$A35,COLUMN()-COLUMN($A35))","v":123549},null,{"$f":"G35","v":123549},{"$f":"F35","v":111547},{"$f":"E35","v":119355},{"$f":"D35","v":128249},{"$f":"C35","v":134047}]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I13),(I15-I10)/I35,(I13-I10)/I25)","v":1.6382335425351597},{"$f":"IF(ISERROR(J13),(J15-J10)/J35,(J13-J10)/J25)","v":1.0468415080065565},{"$f":"IF(ISERROR(K13),(K15-K10)/K35,(K13-K10)/K25)","v":1.0796303188190051},{"$f":"IF(ISERROR(L13),(L15-L10)/L35,(L13-L10)/L25)","v":1.3256841252563096},{"$f":"IF(ISERROR(M13),(M15-M10)/M35,(M13-M10)/M25)","v":1.2279048544844962},"Quick Ratio "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Curr Assets/Total Curr Liabilities"]
[null,null,{"$f":"Analysis!C4","v":"(Over 10 Billion in sales)"},null,null,null,null,null,{"$f":"I49/(I35+I29)","v":0.29977579745687943},{"$f":"J49/(J35+J29)","v":0.35420047155010892},{"$f":"K49/(K35+K29)","v":0.44735453060198566},{"$f":"L49/(L35+L29)","v":0.35623669580269629},{"$f":"M49/(M35+M29)","v":0.36070184338329092},"ROC = Net Profit/(LT Debt+Equity)"]
[null,"Annual Income Statement",null,null,null,null,null,null,{"$f":"G40","v":170910},{"$f":"F40","v":182795},{"$f":"E40","v":233715},{"$f":"D40","v":215639},{"$f":"C40","v":229234},"Revenues"]
[{"$f":"MATCH(B40,Income!A$200:A$524,0)","v":191},"Sales",{"$f":"INDEX(Income!$A$200:$Z$500,$A40,COLUMN()-COLUMN($A40))","v":229234},{"$f":"INDEX(Income!$A$200:$Z$500,$A40,COLUMN()-COLUMN($A40))","v":215639},{"$f":"INDEX(Income!$A$200:$Z$500,$A40,COLUMN()-COLUMN($A40))","v":233715},{"$f":"INDEX(Income!$A$200:$Z$500,$A40,COLUMN()-COLUMN($A40))","v":182795},{"$f":"INDEX(Income!$A$200:$Z$500,$A40,COLUMN()-COLUMN($A40))","v":170910},null,{"$f":"I39/5","v":34182},{"$f":"J39/5","v":36559},46743,43127.8,45846.8,"divided by 5"]
[null,null,null,null,null,null,null,null,null,{"$f":"J40/I40-1","v":6.9539523725937524E-2},{"$f":"K40/J40-1","v":0.27856341803659834},{"$f":"L40/K40-1","v":-7.7342061913013627E-2},{"$f":"M40/L40-1","v":6.304518199398057E-2},"Revenue % change"]
[{"$f":"MATCH(B42,Income!A$200:A$524,0)","v":192},"Cost Of Goods",{"$f":"INDEX(Income!$A$200:$Z$500,$A42,COLUMN()-COLUMN($A42))","v":141048},{"$f":"INDEX(Income!$A$200:$Z$500,$A42,COLUMN()-COLUMN($A42))","v":131376},{"$f":"INDEX(Income!$A$200:$Z$500,$A42,COLUMN()-COLUMN($A42))","v":140089},{"$f":"INDEX(Income!$A$200:$Z$500,$A42,COLUMN()-COLUMN($A42))","v":112258},{"$f":"INDEX(Income!$A$200:$Z$500,$A42,COLUMN()-COLUMN($A42))","v":106606},null,{"$f":"G42","v":106606},{"$f":"F42","v":112258},{"$f":"E42","v":140089},{"$f":"D42","v":131376},{"$f":"C42","v":141048}]
[]
[]
[{"$f":"MATCH(B45,Income!A$200:A$524,0)","v":208},"Depreciation & Amortization (Cash Flow)",{"$f":"INDEX(Income!$A$200:$Z$500,$A45,COLUMN()-COLUMN($A45))","v":10157},{"$f":"INDEX(Income!$A$200:$Z$500,$A45,COLUMN()-COLUMN($A45))","v":10505},{"$f":"INDEX(Income!$A$200:$Z$500,$A45,COLUMN()-COLUMN($A45))","v":11257},{"$f":"INDEX(Income!$A$200:$Z$500,$A45,COLUMN()-COLUMN($A45))","v":7946},{"$f":"INDEX(Income!$A$200:$Z$500,$A45,COLUMN()-COLUMN($A45))","v":6757}]
[null,null,null,null,null,null,null,null,{"$f":"(I39-I42)/I39","v":0.37624480720847231},{"$f":"(J39-J42)/J39","v":0.38588035777783858},{"$f":"(K39-K42)/K39","v":0.40059902017414373},{"$f":"(L39-L42)/L39","v":0.39075955648097049},{"$f":"(M39-M42)/M39","v":0.38469860491899105},"Gross Margin--Annual"]
[{"$f":"MATCH(B47,Income!A$200:A$524,0)","v":195},"Income After Depreciation & Amortization",{"$f":"INDEX(Income!$A$200:$Z$500,$A47,COLUMN()-COLUMN($A47))","v":61344},{"$f":"INDEX(Income!$A$200:$Z$500,$A47,COLUMN()-COLUMN($A47))","v":60024},{"$f":"INDEX(Income!$A$200:$Z$500,$A47,COLUMN()-COLUMN($A47))","v":71230},{"$f":"INDEX(Income!$A$200:$Z$500,$A47,COLUMN()-COLUMN($A47))","v":52503},{"$f":"INDEX(Income!$A$200:$Z$500,$A47,COLUMN()-COLUMN($A47))","v":48999},null,{"$f":"G47","v":48999},{"$f":"F47","v":52503},{"$f":"E47","v":71230},{"$f":"D47","v":60024},{"$f":"C47","v":61344},"(Revenue-COGS)/Revenue "]
[{"$f":"MATCH(B48,Income!A$200:A$524,0)","v":198},"Pretax Income",{"$f":"INDEX(Income!$A$200:$Z$500,$A48,COLUMN()-COLUMN($A48))","v":64089},{"$f":"INDEX(Income!$A$200:$Z$500,$A48,COLUMN()-COLUMN($A48))","v":61372},{"$f":"INDEX(Income!$A$200:$Z$500,$A48,COLUMN()-COLUMN($A48))","v":72515},{"$f":"INDEX(Income!$A$200:$Z$500,$A48,COLUMN()-COLUMN($A48))","v":53483},{"$f":"INDEX(Income!$A$200:$Z$500,$A48,COLUMN()-COLUMN($A48))","v":50155},null,{"$f":"I47/I39","v":0.28669475162366159},{"$f":"J47/J39","v":0.28722339232473537},{"$f":"K47/K39","v":0.30477290717326661},{"$f":"L47/L39","v":0.27835410106706115},{"$f":"M47/M39","v":0.26760428208729942},"Operating Margin"]
[{"$f":"MATCH(B49,Income!A$200:A$524,0)","v":205},"Net Income",{"$f":"INDEX(Income!$A$200:$Z$500,$A49,COLUMN()-COLUMN($A49))","v":48351},{"$f":"INDEX(Income!$A$200:$Z$500,$A49,COLUMN()-COLUMN($A49))","v":45687},{"$f":"INDEX(Income!$A$200:$Z$500,$A49,COLUMN()-COLUMN($A49))","v":53394},{"$f":"INDEX(Income!$A$200:$Z$500,$A49,COLUMN()-COLUMN($A49))","v":39510},{"$f":"INDEX(Income!$A$200:$Z$500,$A49,COLUMN()-COLUMN($A49))","v":37037},null,{"$f":"G49","v":37037},{"$f":"F49","v":39510},{"$f":"E49","v":53394},{"$f":"D49","v":45687},{"$f":"C49","v":48351},"(Operating Income/Revenue"]
[null,null,null,null,null,null,null,null,{"$f":"I49/I39","v":0.21670469837926393},{"$f":"J49/J39","v":0.21614376760852322},{"$f":"K49/K39","v":0.22845773698735639},{"$f":"L49/L39","v":0.211867983064288},{"$f":"M49/M39","v":0.21092420845075338},"Net Profit Margin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(Net Income/Revenue"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(G48+G67+G59)/(F48+F67+F59)-1","v":-7.1244794567783321E-2},"Operating Cash Flow annual change"]
[null,null,null,null,null,null,null,null,{"$f":"I54/I32","v":1.6613202503380824},{"$f":"J54/J32","v":1.8972513981721457},2.0274606765216476,2.2550293222477915,2.4723147215983894,"Dividend per share"]
[null,null,null,null,null,null,null,null,{"$f":"1-G68","v":10565},{"$f":"1-F68","v":11127},{"$f":"1-E68","v":11562},{"$f":"1-D68","v":12151},{"$f":"1-C68","v":12770},"Total Dividend"]
[{"$f":"MATCH(B55,Income!A$200:A$524,0)","v":197},"Interest Expense",{"$f":"INDEX(Income!$A$200:$Z$500,$A55,COLUMN()-COLUMN($A55))","v":0},{"$f":"INDEX(Income!$A$228:$Z$528,$A55,COLUMN()-COLUMN($A55))","v":2346},{"$f":"INDEX(Income!$A$228:$Z$528,$A55,COLUMN()-COLUMN($A55))","v":6965},{"$f":"INDEX(Income!$A$228:$Z$528,$A55,COLUMN()-COLUMN($A55))","v":3203},{"$f":"INDEX(Income!$A$228:$Z$528,$A55,COLUMN()-COLUMN($A55))","v":2591}]
[null,"Convert from negative number",{"$f":"IF(C55<0,-C55,C55)","v":0},{"$f":"IF(D55<0,-D55,D55)","v":2346},6965,3203,2591,null,{"$f":"IF(I53=\"--\",\"\",I53+I69)","v":0.37739409378243249},{"$f":"IF(J53=\"--\",\"\",J53+J69)","v":0.26531169008320843},{"$f":"IF(K53=\"--\",\"\",K53+K69)","v":5.5236993003314083E-2},{"$f":"IF(L53=\"--\",\"\",L53+L69)","v":-0.10819538267389239},{"$f":"IF(M53=\"--\",\"\",M53+M69)","v":6.1759467203593488E-2},"Div.+ Cap Expense/share"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C53=\"--\",0,IF(C54=\"--\",\"None\",M64/M54))","v":4.9802662490211436},"Div to Cash from Operations"]
[{"$f":"MATCH(B58,Income!A$200:A$524,0)","v":213},"Diluted Net EPS",{"$f":"INDEX(Income!$A$200:$Z$500,$A58,COLUMN()-COLUMN($A58))","v":9.2100000000000009},{"$f":"INDEX(Income!$A$200:$Z$500,$A58,COLUMN()-COLUMN($A58))","v":8.31},{"$f":"INDEX(Income!$A$200:$Z$500,$A58,COLUMN()-COLUMN($A58))","v":9.2200000000000006},{"$f":"INDEX(Income!$A$200:$Z$500,$A58,COLUMN()-COLUMN($A58))","v":6.45},{"$f":"INDEX(Income!$A$200:$Z$500,$A58,COLUMN()-COLUMN($A58))","v":5.68},null,{"$f":"(C58/D58)-1","v":0.10830324909747291},{"$f":"(D58/E58)-1","v":-9.8698481561822149E-2},{"$f":"(E58/F58)-1","v":0.42945736434108528},{"$f":"(F58/G58)-1","v":0.13556338028169024},null,{"$f":"AVERAGE(I58:L58)","v":0.14365637803960657},"Avg. EPS growth"]
[{"$f":"MATCH(B59,Income!A$200:A$524,0)","v":199},"Income Taxes",{"$f":"INDEX(Income!$A$200:$Z$500,$A59,COLUMN()-COLUMN($A59))","v":15738},{"$f":"INDEX(Income!$A$200:$Z$500,$A59,COLUMN()-COLUMN($A59))","v":15685},{"$f":"INDEX(Income!$A$200:$Z$500,$A59,COLUMN()-COLUMN($A59))","v":19121},{"$f":"INDEX(Income!$A$200:$Z$500,$A59,COLUMN()-COLUMN($A59))","v":13973},{"$f":"INDEX(Income!$A$200:$Z$500,$A59,COLUMN()-COLUMN($A59))","v":13118}]
[{"$f":"MATCH(B60,Income!A$200:A$524,0)","v":192},"Cost of Goods",{"$f":"INDEX(Income!$A$200:$Z$500,$A60,COLUMN()-COLUMN($A60))","v":141048},{"$f":"INDEX(Income!$A$200:$Z$500,$A60,COLUMN()-COLUMN($A60))","v":131376},{"$f":"INDEX(Income!$A$200:$Z$500,$A60,COLUMN()-COLUMN($A60))","v":140089},{"$f":"INDEX(Income!$A$200:$Z$500,$A60,COLUMN()-COLUMN($A60))","v":112258},{"$f":"INDEX(Income!$A$200:$Z$500,$A60,COLUMN()-COLUMN($A60))","v":106606},null,null,null,null,null,null,{"$f":"C71*C32/C40","v":0.27743702941099485},"Free Cahflow Margin"]
[null,null,null,null,null,null,null,null,{"$f":"I64/I49","v":1.448983448983449},{"$f":"J64/J49","v":1.5113389015439129},{"$f":"K64/K49","v":1.5220062179271079},{"$f":"IF(L64=\"--\",\"N/A\",L64/L49)","v":1.4407599535973035},{"$f":"IF(M64=\"--\",\"N/A\",M64/M49)","v":1.3153399102397054},"Earnings Confidence Rating"]
[null,"Cashflow",null,null,null,null,null,null,null,null,null,null,{"$f":"(M49-M70)/AVERAGE(L14:M14)","v":-4.2834699894548821E-2},"Quality of Earnings Ratio"]
[{"$f":"MATCH(B63,CFlow!A$200:A$524,0)","v":192},"Net Income (Loss)",{"$f":"INDEX(CFlow!$A$200:$M$500,$A63,COLUMN()-COLUMN($A63))","v":48351},{"$f":"INDEX(CFlow!$A$200:$M$500,$A63,COLUMN()-COLUMN($A63))","v":45687},{"$f":"INDEX(CFlow!$A$200:$M$500,$A63,COLUMN()-COLUMN($A63))","v":53394},{"$f":"INDEX(CFlow!$A$200:$M$500,$A63,COLUMN()-COLUMN($A63))","v":39510},{"$f":"INDEX(CFlow!$A$200:$M$500,$A63,COLUMN()-COLUMN($A63))","v":37037},null,{"$f":"G63","v":37037},{"$f":"F63","v":39510},{"$f":"E63","v":53394},{"$f":"D63","v":45687},{"$f":"C63","v":48351}]
[{"$f":"MATCH(B64,CFlow!A$200:A$524,0)","v":197},"Net Cash From Operating Activities",{"$f":"INDEX(CFlow!$A$200:$M$500,$A64,COLUMN()-COLUMN($A64))","v":63598},{"$f":"INDEX(CFlow!$A$200:$M$500,$A64,COLUMN()-COLUMN($A64))","v":65824},{"$f":"INDEX(CFlow!$A$200:$M$500,$A64,COLUMN()-COLUMN($A64))","v":81266},{"$f":"INDEX(CFlow!$A$200:$M$500,$A64,COLUMN()-COLUMN($A64))","v":59713},{"$f":"INDEX(CFlow!$A$200:$M$500,$A64,COLUMN()-COLUMN($A64))","v":53666},null,{"$f":"G64","v":53666},{"$f":"F64","v":59713},{"$f":"E64","v":81266},{"$f":"D64","v":65824},{"$f":"C64","v":63598},"Cash from Operations"]
[null,null,null,null,null,null,null,null,{"$f":"C64/C32","v":12.312785564934563},{"$f":"D64/D32","v":12.215871130576796},14.250442772721694,10.181591870140499,8.4388464320533387,"Annual Free Cash Flow/share"]
[{"$f":"MATCH(B66,CFlow!A$200:A$524,0)","v":198},"Property & Equipment",{"$f":"INDEX(CFlow!$A$200:$M$500,$A66,COLUMN()-COLUMN($A66))","v":-12451},{"$f":"INDEX(CFlow!$A$200:$M$500,$A66,COLUMN()-COLUMN($A66))","v":-12734},{"$f":"INDEX(CFlow!$A$200:$M$500,$A66,COLUMN()-COLUMN($A66))","v":-11247},{"$f":"INDEX(CFlow!$A$200:$M$500,$A66,COLUMN()-COLUMN($A66))","v":-9571},{"$f":"INDEX(CFlow!$A$200:$M$500,$A66,COLUMN()-COLUMN($A66))","v":-8165},null,{"$f":"1-G66","v":8166},{"$f":"1-F66","v":9572},{"$f":"1-E66","v":11248},{"$f":"1-D66","v":12735},{"$f":"1-C66","v":12452},"Property & Equipment"]
[{"$f":"MATCH(B67,CFlow!A$200:A$524,0)","v":193},"Depreciation/Amortization & Depletion",{"$f":"INDEX(CFlow!$A$200:$M$500,$A67,COLUMN()-COLUMN($A67))","v":10157},{"$f":"INDEX(CFlow!$A$200:$M$500,$A67,COLUMN()-COLUMN($A67))","v":10505},{"$f":"INDEX(CFlow!$A$200:$M$500,$A67,COLUMN()-COLUMN($A67))","v":11257},{"$f":"INDEX(CFlow!$A$200:$M$500,$A67,COLUMN()-COLUMN($A67))","v":7946},{"$f":"INDEX(CFlow!$A$200:$M$500,$A67,COLUMN()-COLUMN($A67))","v":6757},null,{"$f":"I65/$G$32","v":1.9361552292566223E-3},{"$f":"J65/$G$32","v":1.9209156729529196E-3},{"$f":"K65/$G$32","v":2.2408470567540483E-3},{"$f":"L65/$G$32","v":1.6010302654559392E-3},{"$f":"M65/$G$32","v":1.3269878340807842E-3},"Per share Free Cash Flow"]
[{"$f":"MATCH(B68,CFlow!A$200:A$524,0)","v":208},"Payment of Dividends & Other Distributions",{"$f":"INDEX(CFlow!$A$200:$M$500,$A68,COLUMN()-COLUMN($A68))","v":-12769},{"$f":"INDEX(CFlow!$A$200:$M$500,$A68,COLUMN()-COLUMN($A68))","v":-12150},{"$f":"INDEX(CFlow!$A$200:$M$500,$A68,COLUMN()-COLUMN($A68))","v":-11561},{"$f":"INDEX(CFlow!$A$200:$M$500,$A68,COLUMN()-COLUMN($A68))","v":-11126},{"$f":"INDEX(CFlow!$A$200:$M$500,$A68,COLUMN()-COLUMN($A68))","v":-10564},null,{"$f":"G66","v":-8165},{"$f":"F66","v":-9571},{"$f":"E66","v":-11247},{"$f":"D66","v":-12734},{"$f":"C66","v":-12451},"Capital Expenditures"]
[null,"(convert to positive number)",{"$f":"1-C68","v":12770},{"$f":"1-D68","v":12151},11562,11127,10565,null,{"$f":"I68/I32","v":-1.2839261565556499},{"$f":"J68/J32","v":-1.6319397080889373},{"$f":"K68/K32","v":-1.9722236835183335},{"$f":"L68/L32","v":-2.3632247049216839},{"$f":"M68/M32","v":-2.4105552543947959},"Cap Exp per share"]
[{"$f":"MATCH(B70,CFlow!A$200:A$524,0)","v":197},"Net Cash From Operating Activities",{"$f":"INDEX(CFlow!$A$200:$M$500,$A70,COLUMN()-COLUMN($A70))","v":63598},{"$f":"INDEX(CFlow!$A$200:$M$500,$A70,COLUMN()-COLUMN($A70))","v":65824},{"$f":"INDEX(CFlow!$A$200:$M$500,$A70,COLUMN()-COLUMN($A70))","v":81266},{"$f":"INDEX(CFlow!$A$200:$M$500,$A70,COLUMN()-COLUMN($A70))","v":59713},{"$f":"INDEX(CFlow!$A$200:$M$500,$A70,COLUMN()-COLUMN($A70))","v":53666},null,{"$f":"I64-I54-I68","v":51266},{"$f":"J64-J54-J68","v":58157},80951,66407,63279,"Free Cash Flow","(Cash from Oper-PP&E-Dividends)"]
[null,"Free Cashflow per Share",{"$f":"C64/C32","v":12.312785564934563},{"$f":"D64/D32","v":12.215871130576796},14.250442772721694,10.181591870140499,8.4388464320533387,null,null,null,null,null,null,null,"formula from Investopedia"]
[null,null,null,null,null,null,null,null,{"$f":"G71","v":8.4388464320533387},{"$f":"F71","v":10.181591870140499},{"$f":"E71","v":14.250442772721694},{"$f":"D71","v":12.215871130576796},{"$f":"C71","v":12.312785564934563},{"$f":"IF(M72=\"--\",\"No data\",(M72/L72))","v":1.0079334853259205},"Change from prior year"]
[null,"NAME OF COMPANY",{"$f":"OFFSET(Name!A119,-60,0,1)","v":"end header wrap"},{"$f":"Name!A60","v":"Apple Inc"}]
[null,null," Price"," Price",null,"Price adjustment if price",null,null,{"$f":"C63/I9-1","v":1.3424737173586552},{"$f":"D63/J9-1","v":0.67849663837760388},{"$f":"E63/K9-1","v":0.75968098078634272},{"$f":"F63/L9-1","v":0.34851018806102596},{"$f":"G63/M9-1","v":3.8236201048411855E-2},"% difference-Net Earnings/Receivables"]
[null,null,{"$f":"Price2!A25","v":"$190.29 USD "},{"$f":"LEFT(C75,7)*1","v":190.29},{"$f":"IF(ISERROR(D75),LEFT(C75,5)*1,D75)","v":190.29},"is less than $10",null,null,null,null,null,null,{"$f":"IF(G69=\"--\",0,G69)","v":10565}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(C63:C64)=0,\"CAUTION The most recent fiscal year data are incomplete or not yet reported\",\"\")","v":""},"Yellow cell contains data"]
[]
[]
[null,"QUARTERLY INCOME DATA"]
[{"$f":"MATCH(B80,AnnBS!A$400:A$500,0)","v":35},"All items in Millions except Per Share data.",{"$f":"OFFSET(INDEX(AnnBS!$A$400:$M$500,$A80,COLUMN()-COLUMN($A80)),1,0)","v":"2018-06-30"},{"$f":"OFFSET(INDEX(AnnBS!$A$400:$M$500,$A80,COLUMN()-COLUMN($A80)),1,0)","v":"2018-03-31"},{"$f":"OFFSET(INDEX(AnnBS!$A$400:$M$500,$A80,COLUMN()-COLUMN($A80)),1,0)","v":"2017-12-31"},{"$f":"OFFSET(INDEX(AnnBS!$A$400:$M$500,$A80,COLUMN()-COLUMN($A80)),1,0)","v":"2017-09-30"},{"$f":"OFFSET(INDEX(AnnBS!$A$400:$M$500,$A80,COLUMN()-COLUMN($A80)),1,0)","v":"2017-06-30"},null,{"$f":"G80","v":"2017-06-30"},{"$f":"F80","v":"2017-09-30"},{"$f":"E80","v":"2017-12-31"},{"$f":"D80","v":"2018-03-31"},{"$f":"C80","v":"2018-06-30"}]
[]
[]
[]
[]
[null,"Free Cash Flow per Share",{"$f":"INDEX(#REF!,$A85,COLUMN()-COLUMN($A85))","v":{"$error":"#REF!"}},{"$f":"INDEX(#REF!,$A85,COLUMN()-COLUMN($A85))","v":{"$error":"#REF!"}},{"$f":"INDEX(#REF!,$A85,COLUMN()-COLUMN($A85))","v":{"$error":"#REF!"}},{"$f":"INDEX(#REF!,$A85,COLUMN()-COLUMN($A85))","v":{"$error":"#REF!"}},{"$f":"INDEX(#REF!,$A85,COLUMN()-COLUMN($A85))","v":{"$error":"#REF!"}},null,{"$f":"C85","v":{"$error":"#REF!"}},{"$f":"D85","v":{"$error":"#REF!"}},{"$f":"E85","v":{"$error":"#REF!"}},{"$f":"F85","v":{"$error":"#REF!"}},{"$f":"G85","v":{"$error":"#REF!"}},"Cash from Operating Activities per share"]
[null,null,null,null,null,null,null,null,{"$f":"IF(I90=0,\"No Div.\",I85/I90)","v":{"$error":"#REF!"}},{"$f":"IF(J90=0,\"No Div.\",J85/J90)","v":{"$error":"#REF!"}},{"$f":"IF(K90=0,\"No Div.\",K85/K90)","v":{"$error":"#REF!"}},{"$f":"IF(L90=0,\"No Div.\",L85/L90)","v":{"$error":"#REF!"}},{"$f":"IF(M90=0,\"No Div.\",M85/M90)","v":{"$error":"#REF!"}},"ratio: Dividends to Cash from Operations"]
[]
[null,null,null,null,null,null,null,null,{"$f":"C81/C92","v":0},{"$f":"D81/D92","v":0},{"$f":"E81/E92","v":0},{"$f":"F81/F92","v":0},{"$f":"G81/G92","v":0},"Ernings confidence rating"]
[{"$f":"MATCH(B89,Income!$A$350:$A$524,0)","v":{"$error":"#N/A"}},"Dividends Per Share",{"$f":"INDEX(Income!$A$350:V$500,$A89,COLUMN()-COLUMN($A89))","v":{"$error":"#N/A"}},{"$f":"INDEX(Income!$A$350:W$500,$A89,COLUMN()-COLUMN($A89))","v":{"$error":"#N/A"}},{"$f":"INDEX(Income!$A$350:X$500,$A89,COLUMN()-COLUMN($A89))","v":{"$error":"#N/A"}},{"$f":"INDEX(Income!$A$350:Y$500,$A89,COLUMN()-COLUMN($A89))","v":{"$error":"#N/A"}},{"$f":"INDEX(Income!$A$350:Z$500,$A89,COLUMN()-COLUMN($A89))","v":{"$error":"#N/A"}}]
[{"$f":"MATCH(B90,Income!$A$395:$A$524,0)","v":22},"Sales",{"$f":"INDEX(Income!$A$395:V$500,$A90,COLUMN()-COLUMN($A90))","v":"NA"},{"$f":"INDEX(Income!$A$395:W$500,$A90,COLUMN()-COLUMN($A90))","v":61137},{"$f":"INDEX(Income!$A$395:X$500,$A90,COLUMN()-COLUMN($A90))","v":88293},{"$f":"INDEX(Income!$A$395:Y$500,$A90,COLUMN()-COLUMN($A90))","v":52579},{"$f":"INDEX(Income!$A$395:Z$500,$A90,COLUMN()-COLUMN($A90))","v":45408},null,{"$f":"G90","v":45408},{"$f":"F90","v":52579},{"$f":"E90","v":88293},{"$f":"D90","v":61137},{"$f":"C90","v":"NA"},"Q Sales"]
[{"$f":"MATCH(B91,Income!$A$395:$A$524,0)","v":3},"Pretax Income",{"$f":"INDEX(Income!$A$395:V$500,$A91,COLUMN()-COLUMN($A91))","v":64089},{"$f":"INDEX(Income!$A$395:W$500,$A91,COLUMN()-COLUMN($A91))","v":61372},{"$f":"INDEX(Income!$A$395:X$500,$A91,COLUMN()-COLUMN($A91))","v":72515},{"$f":"INDEX(Income!$A$395:Y$500,$A91,COLUMN()-COLUMN($A91))","v":53483},{"$f":"INDEX(Income!$A$395:Z$500,$A91,COLUMN()-COLUMN($A91))","v":50155},null,{"$f":"G92","v":37037},{"$f":"F92","v":39510},{"$f":"E92","v":53394},{"$f":"D92","v":45687},{"$f":"C92","v":48351},"Net Income"]
[{"$f":"MATCH(B92,Income!$A$395:$A$524,0)","v":10},"Net Income",{"$f":"INDEX(Income!$A$395:V$500,$A92,COLUMN()-COLUMN($A92))","v":48351},{"$f":"INDEX(Income!$A$395:W$500,$A92,COLUMN()-COLUMN($A92))","v":45687},{"$f":"INDEX(Income!$A$395:X$500,$A92,COLUMN()-COLUMN($A92))","v":53394},{"$f":"INDEX(Income!$A$395:Y$500,$A92,COLUMN()-COLUMN($A92))","v":39510},{"$f":"INDEX(Income!$A$395:Z$500,$A92,COLUMN()-COLUMN($A92))","v":37037},null,{"$f":"C92*C32","v":249742585.19999999},{"$f":"D92*D32","v":246179830.79999998},{"$f":"E92*E32","v":304489963.80000001},{"$f":"F92*F32","v":231718248},{"$f":"G92*G32","v":235533097.79999998},"Q TotalNet Income"]
[{"$f":"MATCH(B93,Income!$A$395:$A$524,0)","v":23},"Cost Of Goods",{"$f":"INDEX(Income!$A$395:V$500,$A93,COLUMN()-COLUMN($A93))","v":"NA"},{"$f":"INDEX(Income!$A$395:W$500,$A93,COLUMN()-COLUMN($A93))","v":37715},{"$f":"INDEX(Income!$A$395:X$500,$A93,COLUMN()-COLUMN($A93))","v":54381},{"$f":"INDEX(Income!$A$395:Y$500,$A93,COLUMN()-COLUMN($A93))","v":32648},{"$f":"INDEX(Income!$A$395:Z$500,$A93,COLUMN()-COLUMN($A93))","v":27920},null,null,{"$f":"(D90/C90)-1","v":{"$error":"#VALUE!"}},{"$f":"(E90/D90)-1","v":0.44418273713136069},{"$f":"(F90/E90)-1","v":-0.40449412750727687},{"$f":"(G90/F90)-1","v":-0.13638524886361481},"Sales growth"]
[{"$f":"MATCH(B94,Income!$A$395:$A$524,0)","v":10},"Net Income",{"$f":"INDEX(Income!$A$395:V$500,$A94,COLUMN()-COLUMN($A94))","v":48351},{"$f":"INDEX(Income!$A$395:W$500,$A94,COLUMN()-COLUMN($A94))","v":45687},{"$f":"INDEX(Income!$A$395:X$500,$A94,COLUMN()-COLUMN($A94))","v":53394},{"$f":"INDEX(Income!$A$395:Y$500,$A94,COLUMN()-COLUMN($A94))","v":39510},{"$f":"INDEX(Income!$A$395:Z$500,$A94,COLUMN()-COLUMN($A94))","v":37037},null,{"$f":"G93","v":27920},{"$f":"F93","v":32648},{"$f":"E93","v":54381},{"$f":"D93","v":37715},{"$f":"C93","v":"NA"},"Q Cost of good sold"]
[{"$f":"MATCH(B95,Income!$A$395:$A$524,0)","v":{"$error":"#N/A"}},"Free Cash Flow",{"$f":"INDEX(Income!$A$395:V$505,$A95,COLUMN()-COLUMN($A95))","v":{"$error":"#N/A"}},{"$f":"INDEX(Income!$A$395:W$505,$A95,COLUMN()-COLUMN($A95))","v":{"$error":"#N/A"}},{"$f":"INDEX(Income!$A$395:X$505,$A95,COLUMN()-COLUMN($A95))","v":{"$error":"#N/A"}},{"$f":"INDEX(Income!$A$395:Y$505,$A95,COLUMN()-COLUMN($A95))","v":{"$error":"#N/A"}},{"$f":"INDEX(Income!$A$395:Z$505,$A95,COLUMN()-COLUMN($A95))","v":{"$error":"#N/A"}},null,{"$f":"I91/C90","v":{"$error":"#VALUE!"}},{"$f":"J91/D90","v":0.64625349624613571},{"$f":"K91/E90","v":0.60473650232747778},{"$f":"L91/F90","v":0.86892105213107895},{"$f":"M91/G90","v":1.0648123678646935},"Profitability on Revenues"]
[{"$f":"MATCH(B96,Income!A$392:A$524,0)","v":11},"Income From Cont. Operations",{"$f":"INDEX(Income!$A$395:P$500,$A96,COLUMN()-COLUMN($A96))","v":43008},{"$f":"INDEX(Income!$A$395:Q$500,$A96,COLUMN()-COLUMN($A96))","v":42643},{"$f":"INDEX(Income!$A$395:R$500,$A96,COLUMN()-COLUMN($A96))","v":42277},{"$f":"INDEX(Income!$A$395:S$500,$A96,COLUMN()-COLUMN($A96))","v":41912},{"$f":"INDEX(Income!$A$395:T$500,$A96,COLUMN()-COLUMN($A96))","v":41547},null,{"$f":"C95","v":{"$error":"#N/A"}},{"$f":"D95","v":{"$error":"#N/A"}},{"$f":"E95","v":{"$error":"#N/A"}},{"$f":"F95","v":{"$error":"#N/A"}},{"$f":"G95","v":{"$error":"#N/A"}},"Free Cash Flow"]
[null,null,null,null,null,null,null,null,{"$f":"C92/C90","v":{"$error":"#VALUE!"}},{"$f":"D92/D90","v":0.74728887580352321},{"$f":"E92/E90","v":0.60473650232747778},{"$f":"F92/F90","v":0.75144068924855933},{"$f":"G92/G90","v":0.8156492248062015},"Net Profit Margin"]
[null,"Qtr Balance Sheet data",null,null,null,null,null,null,{"$f":"(C90-C93)/C90","v":{"$error":"#VALUE!"}},{"$f":"(D90-D93)/D90","v":0.38310679294044525},{"$f":"(E90-E93)/E90","v":0.38408480853521798},{"$f":"(F90-F93)/F90","v":0.37906768862093232},{"$f":"(G90-G93)/G90","v":0.38513037350246654},"Quarterly Gross Margin"]
[{"$f":"MATCH(B99,AnnBS!A$415:A$500,0)","v":29},"Net Property & Equipment",{"$f":"INDEX(AnnBS!$A$415:L$500,$A99,COLUMN()-COLUMN($A99))","v":"NA"},{"$f":"INDEX(AnnBS!$A$415:M$500,$A99,COLUMN()-COLUMN($A99))","v":35077},{"$f":"INDEX(AnnBS!$A$415:N$500,$A99,COLUMN()-COLUMN($A99))","v":33679},{"$f":"INDEX(AnnBS!$A$415:O$500,$A99,COLUMN()-COLUMN($A99))","v":33783},{"$f":"INDEX(AnnBS!$A$415:P$500,$A99,COLUMN()-COLUMN($A99))","v":29286},null,{"$f":"C94/C90","v":{"$error":"#VALUE!"}},{"$f":"D94/D90","v":0.74728887580352321},{"$f":"E94/E90","v":0.60473650232747778},{"$f":"F94/F90","v":0.75144068924855933},{"$f":"G94/G90","v":0.8156492248062015},"Operating Margin"]
[null,null,null,null,null,null,null,null,{"$f":"1-C99","v":{"$error":"#VALUE!"}},{"$f":"1-D99","v":-35076},{"$f":"1-E99","v":-33678},{"$f":"1-F99","v":-33782},{"$f":"1-G99","v":-29285},"Property Plant & Equipment"]
[{"$f":"MATCH(B101,AnnBS!A$415:A$500,0)","v":24},"Receivables",{"$f":"INDEX(AnnBS!$A$415:L$500,$A101,COLUMN()-COLUMN($A101))","v":"NA"},{"$f":"INDEX(AnnBS!$A$415:M$500,$A101,COLUMN()-COLUMN($A101))","v":22408},{"$f":"INDEX(AnnBS!$A$415:N$500,$A101,COLUMN()-COLUMN($A101))","v":50899},{"$f":"INDEX(AnnBS!$A$415:O$500,$A101,COLUMN()-COLUMN($A101))","v":35673},{"$f":"INDEX(AnnBS!$A$415:P$500,$A101,COLUMN()-COLUMN($A101))","v":22632},null,{"$f":"IF(C101=\"--\",\"No data\",C101/$C$108)","v":{"$error":"#VALUE!"}},{"$f":"IF(D101=\"--\",\"No data\",D101/$C$108)","v":4.3382637651978628},{"$f":"IF(E101=\"--\",\"No data\",E101/$C$108)","v":9.854216680864246},{"$f":"IF(F101=\"--\",\"No data\",F101/$C$108)","v":6.9064121428018277},{"$f":"IF(G101=\"--\",\"No data\",G101/$C$108)","v":4.3816309145822041},"Accts Receivable per share"]
[{"$f":"MATCH(B102,AnnBS!A$415:A$500,0)","v":26},"Inventories",{"$f":"INDEX(AnnBS!$A$415:L$500,$A102,COLUMN()-COLUMN($A102))","v":"NA"},{"$f":"INDEX(AnnBS!$A$415:M$500,$A102,COLUMN()-COLUMN($A102))","v":7662},{"$f":"INDEX(AnnBS!$A$415:N$500,$A102,COLUMN()-COLUMN($A102))","v":4421},{"$f":"INDEX(AnnBS!$A$415:O$500,$A102,COLUMN()-COLUMN($A102))","v":4855},{"$f":"INDEX(AnnBS!$A$415:P$500,$A102,COLUMN()-COLUMN($A102))","v":3146},null,{"$f":"G102","v":3146},{"$f":"F102","v":4855},{"$f":"E102","v":4421},{"$f":"D102","v":7662},{"$f":"C102","v":"NA"},"Q Inventories"]
[null,null,null,null,null,null,null,null,{"$f":"C99/C90","v":{"$error":"#VALUE!"}},{"$f":"D99/D90","v":0.57374421381487484},{"$f":"E99/E90","v":0.38144586773583411},{"$f":"F99/F90","v":0.64251887635748117},{"$f":"G99/G90","v":0.64495243128964064},"Qtr Cap Expenditures/Sales"]
[null,null,null,null,null,null,null,null,{"$f":"G99","v":29286},{"$f":"F99","v":33783},{"$f":"E99","v":33679},{"$f":"D99","v":35077},{"$f":"C99","v":"NA"},"PP&E per share"]
[{"$f":"MATCH(B105,AnnBS!A$415:A$500,0)","v":35},"Total assets",{"$f":"INDEX(AnnBS!$A$415:L$500,$A105,COLUMN()-COLUMN($A105))","v":"NA"},{"$f":"INDEX(AnnBS!$A$415:M$500,$A105,COLUMN()-COLUMN($A105))","v":367502},{"$f":"INDEX(AnnBS!$A$415:N$500,$A105,COLUMN()-COLUMN($A105))","v":406794},{"$f":"INDEX(AnnBS!$A$415:O$500,$A105,COLUMN()-COLUMN($A105))","v":375319},{"$f":"INDEX(AnnBS!$A$415:P$500,$A105,COLUMN()-COLUMN($A105))","v":345173},null,{"$f":"C105","v":"NA"},367502,406794,375319,345173]
[{"$f":"MATCH(B106,AnnBS!A$415:A$500,0)","v":39},"Current Portion Long-Term Debt",{"$f":"INDEX(AnnBS!$A$415:L$500,$A106,COLUMN()-COLUMN($A106))","v":"NA"},{"$f":"INDEX(AnnBS!$A$415:M$500,$A106,COLUMN()-COLUMN($A106))","v":20478},{"$f":"INDEX(AnnBS!$A$415:N$500,$A106,COLUMN()-COLUMN($A106))","v":18478},{"$f":"INDEX(AnnBS!$A$415:O$500,$A106,COLUMN()-COLUMN($A106))","v":18473},{"$f":"INDEX(AnnBS!$A$415:P$500,$A106,COLUMN()-COLUMN($A106))","v":18475},null,"NA",20478,18478,18473,18475,"Q Debt"]
[{"$f":"MATCH(B107,AnnBS!A$415:A$500,0)","v":7},"Shareholders Equity",{"$f":"INDEX(AnnBS!$A$415:L$500,$A107,COLUMN()-COLUMN($A107))","v":43008},{"$f":"INDEX(AnnBS!$A$415:M$500,$A107,COLUMN()-COLUMN($A107))","v":42643},{"$f":"INDEX(AnnBS!$A$415:N$500,$A107,COLUMN()-COLUMN($A107))","v":42277},{"$f":"INDEX(AnnBS!$A$415:O$500,$A107,COLUMN()-COLUMN($A107))","v":41912},{"$f":"INDEX(AnnBS!$A$415:P$500,$A107,COLUMN()-COLUMN($A107))","v":41547}]
[{"$f":"MATCH(B108,AnnBS!A$415:A$500,0)","v":17},"Shares Outstanding",{"$f":"INDEX(AnnBS!$A$415:H$500,$A108,COLUMN()-COLUMN($A108))","v":5165.2},{"$f":"INDEX(AnnBS!$A$415:I$500,$A108,COLUMN()-COLUMN($A108))","v":5388.4},{"$f":"INDEX(AnnBS!$A$415:J$500,$A108,COLUMN()-COLUMN($A108))","v":5702.7},{"$f":"INDEX(AnnBS!$A$415:K$500,$A108,COLUMN()-COLUMN($A108))","v":5864.8},{"$f":"INDEX(AnnBS!$A$415:L$500,$A108,COLUMN()-COLUMN($A108))","v":6359.4},null,{"$f":"IF(I101=\"no data\",\"N/A\",(I101*91.5)/C90)","v":{"$error":"#VALUE!"}},{"$f":"IF(J101=\"no data\",\"N/A\",(J101*91.5)/D90)","v":6.4928134274760694E-3},{"$f":"IF(K101=\"no data\",\"N/A\",(K101*91.5)/E90)","v":1.0212143955909058E-2},{"$f":"IF(L101=\"no data\",\"N/A\",(L101*91.5)/F90)","v":1.2018804295752434E-2},{"$f":"IF(M101=\"no data\",\"N/A\",(M101*91.5)/G90)","v":8.8292641975923122E-3},"Days waiting for payment"]
[null,null,null,null,null,null,null,null,{"$f":"IF(I102=0,\"0\",C90/C102)","v":{"$error":"#VALUE!"}},{"$f":"IF(J102=0,\"0\",D90/D102)","v":7.9792482380579486},{"$f":"IF(K102=0,\"0\",E90/E102)","v":19.97127346754128},{"$f":"IF(L102=0,\"0\",F90/F102)","v":10.829866117404737},{"$f":"IF(M102=0,\"0\",G90/G102)","v":14.433566433566433},"Inventory Turover"]
[]
[{"$f":"MATCH(B111,AnnBS!A$415:A$500,0)","v":28},"Total Current Assets",{"$f":"INDEX(AnnBS!$A$415:L$500,$A111,COLUMN()-COLUMN($A111))","v":"NA"},{"$f":"INDEX(AnnBS!$A$415:M$500,$A111,COLUMN()-COLUMN($A111))","v":130053},{"$f":"INDEX(AnnBS!$A$415:N$500,$A111,COLUMN()-COLUMN($A111))","v":143810},{"$f":"INDEX(AnnBS!$A$415:O$500,$A111,COLUMN()-COLUMN($A111))","v":128645},{"$f":"INDEX(AnnBS!$A$415:P$500,$A111,COLUMN()-COLUMN($A111))","v":112875},null,null,{"$f":"(D111/C111)-1","v":{"$error":"#VALUE!"}},{"$f":"(E111/D111)-1","v":0.10577995125064388},{"$f":"(F111/E111)-1","v":-0.10545163757735898},{"$f":"(G111/F111)-1","v":-0.12258540946014229},"Change in Assets growth"]
[{"$f":"MATCH(B112,AnnBS!A$415:A$500,0)","v":44},"Total Current Liabilities",{"$f":"INDEX(AnnBS!$A$415:L$500,$A112,COLUMN()-COLUMN($A112))","v":"NA"},{"$f":"INDEX(AnnBS!$A$415:M$500,$A112,COLUMN()-COLUMN($A112))","v":89320},{"$f":"INDEX(AnnBS!$A$415:N$500,$A112,COLUMN()-COLUMN($A112))","v":115788},{"$f":"INDEX(AnnBS!$A$415:O$500,$A112,COLUMN()-COLUMN($A112))","v":100814},{"$f":"INDEX(AnnBS!$A$415:P$500,$A112,COLUMN()-COLUMN($A112))","v":81302}]
[{"$f":"MATCH(B113,AnnBS!A$415:A$500,0)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,{"$f":"G115","v":16960},{"$f":"F115","v":28987},{"$f":"E115","v":53463},{"$f":"D115","v":75427},{"$f":"C115","v":97207},"Long-Term Debt"]
[{"$f":"MATCH(B114,AnnBS!A$415:A$500,0)","v":17},"Shares Outstanding",{"$f":"INDEX(AnnBS!$A$415:L$500,$A114,COLUMN()-COLUMN($A114))","v":5165.2},{"$f":"INDEX(AnnBS!$A$415:M$500,$A114,COLUMN()-COLUMN($A114))","v":5388.4},{"$f":"INDEX(AnnBS!$A$415:N$500,$A114,COLUMN()-COLUMN($A114))","v":5702.7},{"$f":"INDEX(AnnBS!$A$415:O$500,$A114,COLUMN()-COLUMN($A114))","v":5864.8},{"$f":"INDEX(AnnBS!$A$415:P$500,$A114,COLUMN()-COLUMN($A114))","v":6359.4},null,{"$f":"C114","v":5165.2},{"$f":"D114","v":5388.4},{"$f":"E114","v":5702.7},{"$f":"F114","v":5864.8},{"$f":"G114","v":6359.4},"Qtr Shares Outstanding"]
[{"$f":"MATCH(B115,AnnBS!A$415:A$500,0)","v":2},"Long-Term Debt",{"$f":"INDEX(AnnBS!$A$415:L$500,$A115,COLUMN()-COLUMN($A115))","v":97207},{"$f":"INDEX(AnnBS!$A$415:M$500,$A115,COLUMN()-COLUMN($A115))","v":75427},{"$f":"INDEX(AnnBS!$A$415:N$500,$A115,COLUMN()-COLUMN($A115))","v":53463},{"$f":"INDEX(AnnBS!$A$415:O$500,$A115,COLUMN()-COLUMN($A115))","v":28987},{"$f":"INDEX(AnnBS!$A$415:P$500,$A115,COLUMN()-COLUMN($A115))","v":16960},null,{"$f":"(C111-C102)/C112","v":{"$error":"#VALUE!"}},{"$f":"(D111-D102)/D112","v":1.3702530228392298},{"$f":"(E111-E102)/E112","v":1.2038294123743394},{"$f":"(F111-F102)/F112","v":1.2279048544844962},{"$f":"(G111-G102)/G112","v":1.3496469951538708},"Quick Ratio 1:1"]
[null,null,null,null,null,null,null,null,{"$f":"C111/C112","v":{"$error":"#VALUE!"}},{"$f":"D111/D112","v":1.4560344827586207},{"$f":"E111/E112","v":1.2420112619615158},{"$f":"F111/F112","v":1.2760628484139107},{"$f":"G111/G112","v":1.3883422302034389},"Current Ratio 2:1"]
[null,null,null,null,null,null,null,null,{"$f":"C92/C111","v":{"$error":"#VALUE!"}},{"$f":"D92/D111","v":0.35129524117090727},{"$f":"E92/E111","v":0.37128155204784091},{"$f":"F92/F111","v":0.30712425667534687},{"$f":"G92/G111","v":0.32812403100775195},"ROA"]
[{"$f":"MATCH(B118,'Bond rate'!A$1:A$291,0)","v":213},"Ten-Year Treasury Constant Maturity",{"$f":"INDEX('Bond rate'!$A$1:$C$291,$A118,COLUMN()-COLUMN($A118))","v":2.95},null,null,null,null,null,{"$f":"I92/C107","v":5806.8867466517859},{"$f":"J92/D107","v":5773.0420186197025},{"$f":"K92/E107","v":7202.2604205596426},{"$f":"L92/F107","v":5528.6850543996943},{"$f":"M92/G107","v":5669.0759332803809},"ROE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ROC"]
[]
[]
[]
[]
[null,null,"Instructions to convert cell with number and text to number or text only"]
[null,null,"http://www.excelforum.com/excel-general/683911-need-to-copy-only-select-text-from-one-cell-to-another.html"]
[]
[null,null,"Do you mean take it out and show just the Numbers in an adjacent cell, leaving the original data intact? If A1 has the value, put this formula in an adjacent cell, then copy the cell down the entire data set."]
[null,"OFFSET(INDEX(AnnBS!$A$200:$I$500,$A4,COLUMN()-COLUMN($A4)),1,0)"]
[null,null,"Cppy this formula into adjacent cell (add = equal sign to make it a formuls)"]
[null,null,"LOOKUP(99^99,--(\"0\"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&\"0123456789\")),ROW($1:$10000))))"]
[]
[null,null,"Now you have the numbers. If you want the numbers back in the original column REPLACING the original data:"]
[]
[null,null,"1) highlight this whole new row of numbers"]
[null,null,"2) click CTRL-C to copy"]
[null,null,"3) click on the first cell in the original column"]
[null,null,"4) select EDIT > PASTE SPECIAL > Values"]
[]
[null,null,"TO JUST SEPARATE THE TWO PARTS into cells of their own:  Requires a space between number and text"]
[]
[null,null,"1) Highlight the original column of mixed data"]
[null,null,"2) Click on DATA > TEXT TO COLUMNS > DELIMITED > next"]
[null,null,"3) Click on [ ] Space"]
[null,null,"4) Finish"]
[]
[null,"In Excel, you can use VLOOKUP or INDEX/MATCH functions to reference the data in the web query. For example use a formula like =INDEX(D:D,MATCH(\"MSFT\",B:B,0)) to get the Price for MSFT."]
[null,null,"LOOKUP(99^99,--(\"0\"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&\"0123456789\")),ROW($1:$10000))))"]
[]
[null,null,"1) Highlight the original column of mixed data"]
[null,null,"2) Click on DATA > TEXT TO COLUMNS > DELIMITED > next"]
[null,null,"3) Click on [ ] Space"]
[null,null,"4) Finish"]
[]
[]
[]
[]
[]
[]
[null,null,"INDEX('Bal sheet'!$A$3:$M$61,MATCH(\"\",'Bal sheet'!$A$3:$A$65,0),2)"]
[null,null,"INDEX($A$2:$f$65,MATCH(\"\",$A$2:$A$65,0),2)"]
[]
[null,null,"OFFSET(Price!A44,1,0)"]
[]
[null,null,"With the data now in Excel, you can use VLOOKUP or INDEX/MATCH functions to reference the data in the web query. For example use a formula like =INDEX(D:D,MATCH(\"MSFT\",B:B,0)) to get the Price for MSFT."]
[]
[]
[null,null,"INDEX('Bal sheet'!$A$3:$M$61,MATCH(\"\",'Bal sheet'!$A$3:$A$65,0),2)"]

{"sheet":"AnnBS","index":3,"n_rows":540,"n_cols":16,"rows_kept":540,"cut":false,"hidden":true,"merged":[]}
[{"$f":"Analysis!E2","v":"aapl"}]
["Zacks Investment Research"]
[]
["Join"]
["Sign In"]
["Member Sign In"]
["Keep Me Signed In What does \"Remember Me\" do?"]
["Forgot Password"]
["Create a New Account"]
[]
["Home"]
["Stocks Stocks +"]
[]
["Stocks"]
["Zacks #1 Rank"]
["Zacks Rank"]
["Zacks Industry Rank"]
["Zacks Sector Rank"]
["Equity Research"]
["Markets"]
[]
["Funds Funds +"]
[]
["Funds"]
["Mutual Funds"]
["ETFs"]
["Mutual Fund Screener"]
["ETF Screener"]
["Top ETFs"]
[]
["Earnings Earnings +"]
[]
["Earnings"]
["Earnings Calendar"]
["Earnings Releases"]
["Earnings ESP"]
["Earnings ESP Filter"]
[]
["Screening Screening +"]
[]
["Screening"]
["Stock Screener"]
["Mutual Fund Screener"]
["ETF Screener"]
["Premium Screens"]
["Quant Monitor"]
["Research Wizard"]
[]
["Finance Finance +"]
[]
["Personal Finance"]
["Insurance"]
["Investing"]
["Money Managing"]
["Real Estate"]
["Retirement Planning"]
["Tax Information"]
[]
["Portfolio Portfolio +"]
[]
["My Portfolio"]
["Create Portfolio"]
[]
["Education Education +"]
[]
["Education"]
["Stocks"]
["Style Scores"]
["Funds"]
["Earnings ESP"]
["Screening"]
["Video"]
["Testimonial"]
[]
["Services Services +"]
[]
[]
["Services Overview"]
["Zacks Ultimate"]
["Zacks Investor Collection"]
["Zacks Premium"]
[]
[]
[]
[]
["Investor Services"]
["ETF Investor"]
["Home Run Investor"]
["Income Investor"]
["Stocks Under $10"]
["Value Investor"]
["Top 10 Stocks"]
[]
[]
[]
["Other Services"]
["Method for Trading"]
["Research Wizard"]
["Zacks Confidential"]
[]
[]
[]
[]
[]
["Trading Services"]
["Black Box Trader"]
["Counterstrike"]
["Insider Trader"]
["Large-Cap Trader"]
["Momentum Trader"]
["Options Trader"]
["Short List"]
["Surprise Trader"]
["TAZR"]
[]
[]
[]
["Innovators"]
["Blockchain"]
["Healthcare"]
["Technology"]
[]
["Menu"]
[]
["Home"]
["Stocks Stocks +"]
[]
["Stocks"]
["Zacks #1 Rank"]
["Zacks Rank"]
["Zacks Industry Rank"]
["Zacks Sector Rank"]
["Equity Research"]
["Markets"]
[]
["Funds Funds +"]
[]
["Funds"]
["Mutual Funds"]
["ETFs"]
["Mutual Fund Screener"]
["ETF Screener"]
["Top ETFs"]
[]
["Earnings Earnings +"]
[]
["Earnings"]
["Earnings Calendar"]
["Earnings Releases"]
["Earnings ESP"]
["Earnings ESP Filter"]
[]
["Screening Screening +"]
[]
["Screening"]
["Stock Screener"]
["Mutual Fund Screener"]
["ETF Screener"]
["Premium Screens"]
["Quant Monitor"]
["Research Wizard"]
[]
["Finance Finance +"]
[]
["Personal Finance"]
["Insurance"]
["Investing"]
["Money Managing"]
["Real Estate"]
["Retirement Planning"]
["Tax Information"]
[]
["Portfolio Portfolio +"]
[]
["My Portfolio"]
["Create Portfolio"]
[]
["Education Education +"]
[]
["Education"]
["Stocks"]
["Style Scores"]
["Funds"]
["Earnings ESP"]
["Screening"]
["Video"]
["Testimonial"]
[]
["Services Services +"]
[]
[]
["Services Overview"]
["Zacks Ultimate"]
["Zacks Investor Collection"]
["Zacks Premium"]
[]
[]
[]
[]
["Investor Services"]
["ETF Investor"]
["Home Run Investor"]
["Income Investor"]
["Stocks Under $10"]
["Value Investor"]
["Top 10 Stocks"]
[]
[]
[]
["Other Services"]
["Method for Trading"]
["Research Wizard"]
["Zacks Confidential"]
[]
[]
[]
[]
[]
["Trading Services"]
["Black Box Trader"]
["Counterstrike"]
["Insider Trader"]
["Large-Cap Trader"]
["Momentum Trader"]
["Options Trader"]
["Short List"]
["Surprise Trader"]
["TAZR"]
[]
[]
[]
["Innovators"]
["Blockchain"]
["Healthcare"]
["Technology"]
[]
["Join"]
[]
["Sign In"]
[]
["Member Sign In"]
["Keep Me Signed In What does \"Remember Me\" do?"]
["Forgot Password"]
["Create a New Account"]
["Close this window",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MATCH(N245,A200:A300,)","v":{"$error":"#N/A"}},"All items in Millions except Per Share data."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX([1]AnnBS!$A$200:$O$300,$A242,COLUMN()-COLUMN($A242))","v":{"$error":"#VALUE!"}}]
["Help"]
[]
["Zacks Investment Research"]
["You are being directed to ZacksTrade, a division of LBMZ Securities and licensed broker-dealer. ZacksTrade and Zacks.com are separate companies. The web link between the two companies is not a solicitation or offer to invest in a particular security or type of security. ZacksTrade does not endorse or adopt any particular investment strategy, any analyst opinion/rating/report or any approach to evaluating indiv idual securities."]
["If you wish to go to ZacksTrade, click OK. If you do not, click Cancel."]
["OK Cancel"]
["Back to top"]
["more "]
["Financials"]
["Balance Sheet"]
["close"]
[]
["Quotes & News "]
[]
[]
["Quote Overview"]
["Zacks News "]
["Partner News "]
[]
["Zacks Research "]
[]
[]
["*Snapshot"]
["*Analyst Report"]
["*Style Scores"]
["*Detailed Estimates"]
["Comparison to Industry"]
["Zacks Experts View"]
[]
["More Research "]
[]
[]
["*Broker Recommendations "]
["Full Company Report"]
["Earnings Announcements"]
["Key Company Metrics"]
["Broker Reports "]
["Insiders "]
["Earnings Transcripts"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C287","v":"00:00:00"},{"$f":"G287","v":"00:00:00"},{"$f":"H287","v":"00:00:00"},{"$f":"K287","v":"00:00:00"}]
["Charts "]
[]
[]
["*Price, Consensus and EPS Surprise"]
["*Fundamental Charts"]
["Comparative"]
["Interactive Charts"]
["Price and Consensus"]
["Price & EPS Surprise"]
["12 Month EPS"]
["Broker Recommendations"]
[]
["Financials "]
[]
[]
["Financial Overview "]
["Income Statements "]
["Balance Sheet "]
["Cash flow Statements"]
[]
["Options "]
[]
[]
["Option Chain"]
["Options Greek Montage"]
[]
["Access Zacks"]
["Data Feed"]
[]
["Apple Inc. (AAPL)"]
["(Real Time Quote from BATS)"]
["$190.29 USD"]
[190.29]
[31320430]
["+0.81 (0.43%)"]
["Updated Jul 31, 2018 03:58 PM ET"]
["After-Market: $195.72 +5.43 (2.85%) 5:00 PM ET"]
["Add to portfolio"]
["Zacks Rank: "]
["2-Buy   2      "]
["Style Scores: "]
["B Value | C Growth | D Momentum | B VGM"]
["The Style Scores are a complementary set of indicators to use alongside the Zacks Rank. It allows the user to better focus on the stocks that are the best fit for his or her personal trading style."]
["The scores are based on the trading styles of Value, Growth, and Momentum. There's also a VGM Score ('V' for Value, 'G' for Growth and 'M' for Momentum), which combines the weighted average of the individual style scores into one score."]
["Value Score","A"]
["Growth Score","A"]
["Momentum Score","A"]
["VGM Score","A"]
["Within each Score, stocks are graded into five groups: A, B, C, D and F. As you might remember from your school days, an A, is better than a B; a B is better than a C; a C is better than a D; and a D is better than an F."]
["As an investor, you want to buy stocks with the highest probability of success. That means you want to buy stocks with a Zacks Rank #1 or #2, Strong Buy or Buy, which also has a Score of an A or a B in your personal trading style."]
["Zacks Style Scores Education - Learn more about the Zacks Style Scores"]
["Industry Rank: "]
["Top 20%(51 out of 255)"]
["Industry: Computer - Mini computers"]
["View All Zacks #1 Ranked Stocks"]
["Trades from $3 "]
["This is our short term rating system that serves as a timeliness indicator for stocks over the next 1 to 3 months. How good is it? See rankings and related performance below."]
["Zacks Rank","Definition","Annualized Return"]
[1,"Strong Buy",0.2571]
[2,"Buy",0.1812]
[3,"Hold",9.9099999999999994E-2]
[4,"Sell",5.4899999999999997E-2]
[5,"Strong Sell",2.29E-2]
["S&P",500,9.7900000000000001E-2]
["Zacks Rank Education - Learn about the Zacks Rank"]
["Zacks Rank Home - Zacks Rank resources in one place"]
["Zacks Premium - The only way to fully access the Zacks Rank"]
["The Zacks Equity Research reports, or ZER for short, are our in-house, independently produced research reports."]
["The ever popular one-page Snapshot reports are generated for virtually every single Zacks Ranked stock. It's packed with all of the company's key stats and salient decision making information. Including the Zacks Rank, Zacks Industry Rank, Style Scores, the Price, Consensus & Surprise chart, graphical estimate analysis and how a stocks stacks up to its peers."]
["The detailed multi-page Analyst report does an even deeper dive on the company's vital statistics. In addition to all of the proprietary analysis in the Snapshot, the report also visually displays the four components of the Zacks Rank (Agreement, Magnitude, Upside and Surprise); provides a comprehensive overview of the company business drivers, complete with earnings and sales charts; a recap of their last earnings report; and a bulleted list of reasons to buy or sell the stock. It also includes an industry comparison table to see how your stock compares to its expanded industry, and the S&P 500."]
["Researching stocks has never been so easy or insightful as with the ZER Analyst and Snapshot reports."]
["Learn more about Zacks Equity Research reports"]
["See more Zacks Equity Research reports"]
["The Zacks Industry Rank assigns a rating to each of the 265 X (Expanded) Industries based on their average Zacks Rank."]
["An industry with a larger percentage of Zacks Rank #1&apos;s and #2&apos;s will have a better average Zacks Rank than one with a larger percentage of Zacks Rank #4&apos;s and #5&apos;s."]
["The industry with the best average Zacks Rank would be considered the top industry (1 out of 265), which would place it in the top 1% of Zacks Ranked Industries. The industry with the worst average Zacks Rank (265 out of 265) would place in the bottom 1%."]
["Zacks Rank Education -- Learn more about the Zacks Rank"]
["Zacks Industry Rank Education -- Learn more about the Zacks Industry Rank"]
["Apple Inc. (AAPL) Quote Overview » Financials » Apple Inc. (AAPL) Balance Sheet "]
["Balance Sheet"]
["The Style Scores are a complementary set of indicators to use alongside the Zacks Rank. It allows the user to better focus on the stocks that are the best fit for his or her personal trading style."]
["The scores are based on the trading styles of Value, Growth, and Momentum. There's also a VGM Score ('V' for Value, 'G' for Growth and 'M' for Momentum), which combines the weighted average of the individual style scores into one score."]
["Value Score","A"]
["Growth Score","A"]
["Momentum Score","A"]
["VGM Score","A"]
["Within each Score, stocks are graded into five groups: A, B, C, D and F. As you might remember from your school days, an A, is better than a B; a B is better than a C; a C is better than a D; and a D is better than an F.",null,null,null,null,null,null,null,null,null,null,null,10029,"ba"]
["As an investor, you want to buy stocks with the highest probability of success. That means you want to buy stocks with a Zacks Rank #1 or #2, Strong Buy or Buy, which also has a Score of an A or a B in your personal trading style.",null,null,null,null,null,null,null,null,null,null,null,9260]
["Zacks Style Scores Education - Learn more about the Zacks Style Scores"]
["Research for AAPL "]
["   "]
["The Zacks Equity Research reports, or ZER for short, are our in-house, independently produced research reports."]
["The ever popular one-page Snapshot reports are generated for virtually every single Zacks Ranked stock. It's packed with all of the company's key stats and salient decision making information. Including the Zacks Rank, Zacks Industry Rank, Style Scores, the Price, Consensus & Surprise chart, graphical estimate analysis and how a stocks stacks up to its peers."]
["The detailed multi-page Analyst report does an even deeper dive on the company's vital statistics. In addition to all of the proprietary analysis in the Snapshot, the report also visually displays the four components of the Zacks Rank (Agreement, Magnitude, Upside and Surprise); provides a comprehensive overview of the company business drivers, complete with earnings and sales charts; a recap of their last earnings report; and a bulleted list of reasons to buy or sell the stock. It also includes an industry comparison table to see how your stock compares to its expanded industry, and the S&P 500."]
["Researching stocks has never been so easy or insightful as with the ZER Analyst and Snapshot reports."]
["Learn more about Zacks Equity Research reports"]
["See more Zacks Equity Research reports"]
[]
["Annual Balance Sheet"]
["Quarterly Balance Sheet"]
["Fiscal Year End for Apple Inc. falls in the month of September."]
["All items in Millions except Per Share data."]
[null,43008,42643,42277,41912,41547]
["Assets"]
["Cash & Equivalents",74181,67155,41601,25077,40546]
["Receivables",35673,29299,30343,27219,20641]
["Notes Receivable",0,0,0,0,0]
["Inventories",4855,2132,2349,2111,1764]
["Other Current Assets",13936,8283,15085,14124,10335]
["Total Current Assets",128645,106869,89378,68531,73286]
["Net Property & Equipment",33783,27010,22471,20624,16597]
["Investments & Advances",194714,170430,164065,130162,106215]
["Other Non-Current Assets",0,0,0,0,0]
["Deferred Charges",0,0,0,0,0]
["Intangibles",8015,8620,9009,8758,5756]
["Deposits & Other Assets",10162,8757,5556,3764,5146]
["Total Assets",375319,321686,290479,231839,207000]
["Liabilities & Shareholders Equity",43008,42643,42277,41912,41547]
["Notes Payable",0,0,0,0,0]
["Accounts Payable",49049,37294,35490,30196,22367]
["Current Portion Long-Term Debt",18473,11605,10999,6308,0]
["Current Portion Capital Leases",0,0,0,0,0]
["Accrued Expenses",25744,22027,25181,18453,13856]
["Income Taxes Payable",0,0,0,0,0]
["Other Current Liabilities",7548,8080,8940,8491,7435]
["Total Current Liabilities",100814,79006,80610,63448,43658]
["Mortgages",0,0,0,0,0]
["Deferred Taxes/Income",2836,2930,3624,3031,2625]
["Convertible Debt",0,0,0,0,0]
["Long-Term Debt",97207,75427,53463,28987,16960]
["Non-Current Capital Leases","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
["Other Non-Current Liabilities",40415,36074,33427,24826,20208]
["Minority Interest (Liabilities)",0,0,0,0,0,null,null,null,null,null,null,10326,"ba"]
["Total Liabilities",241272,193437,171124,120292,83451,null,null,null,null,null,null,10052]
["Shareholders Equity",43008,42643,42277,41912,41547]
["Preferred Stock",0,0,0,0,0]
["Common Stock (Par)",35867,31251,27416,23313,19764]
["Capital Surplus",0,0,0,0,0]
["Retained Earnings",98330,96364,92284,87152,104256]
["Other Equity",-150,634,-345,1082,-471]
["Treasury Stock",0,0,0,0,0]
["Total Shareholder's Equity",134047,128249,119355,111547,123549]
["Total Liabilities & Shareholder's Equity",375319,321686,290479,231839,207000]
["Total Common Equity",134047,128249,119355,111547,123549]
["Shares Outstanding",5165.2,5388.4,5702.7,5864.8,6359.4]
["Book Value Per Share",25.95,23.8,20.93,19.02,19.43]
["Fiscal Year End for Apple Inc. falls in the month of September."]
["All items in Millions except Per Share data."]
[null,43281,43190,43100,43008,42916]
["Assets"]
["Cash & Equivalents","NA",87940,77153,74181,76759]
["Receivables","NA",22408,50899,35673,22632]
["Notes Receivable","NA",0,0,0,0]
["Inventories","NA",7662,4421,4855,3146]
["Other Current Assets","NA",12043,11337,13936,10338]
["Total Current Assets","NA",130053,143810,128645,112875]
["Net Property & Equipment","NA",35077,33679,33783,29286]
["Investments & Advances","NA",179286,207944,194714,184757]
["Other Non-Current Assets","NA",0,0,0,0]
["Deferred Charges","NA",0,0,0,0]
["Intangibles","NA",0,8038,8015,8105]
["Deposits & Other Assets","NA",23086,13323,10162,10150]
["Total Assets","NA",367502,406794,375319,345173]
["Liabilities & Shareholders Equity",43281,43190,43100,43008,42916]
["Notes Payable","NA",0,0,0,0]
["Accounts Payable","NA",34311,62985,49049,31915]
["Current Portion Long-Term Debt","NA",20478,18478,18473,18475]
["Current Portion Capital Leases","NA",0,0,0,0]
["Accrued Expenses","NA",26756,26281,25744,23304]
["Income Taxes Payable","NA",0,0,0,0]
["Other Current Liabilities","NA",7775,8044,7548,7608]
["Total Current Liabilities","NA",89320,115788,100814,81302]
["Mortgages","NA",0,0,0,0]
["Deferred Taxes/Income","NA",3087,3131,2836,2984]
["Convertible Debt","NA",0,0,0,0]
["Long-Term Debt","NA",101362,103922,97207,89864]
["Non-Current Capital Leases","NA",0,0,0,0]
["Other Non-Current Liabilities","NA",null,43754,40415,38598]
["Minority Interest (Liabilities)","NA",0,0,0,0]
["Total Liabilities","NA",240624,266595,241272,212748]
["Shareholders Equity",43281,43190,43100,43008,42916]
["Preferred Stock","NA",0,0,0,0]
["Common Stock (Par)","NA",38044,36447,35867,34445]
["Capital Surplus","NA",0,0,0,0]
["Retained Earnings","NA",91898,104593,98330,98525]
["Other Equity","NA",-3064,-841,-150,-545]
["Treasury Stock","NA",0,0,0,0]
["Total Shareholder's Equity","NA",126878,140199,134047,132425]
["Total Liabilities & Shareholder's Equity","NA",367502,406794,375319,345173]
["Total Common Equity",0,126878,140199,134047,132425]
["Shares Outstanding",5074,5074,5087,5165.2,5213.8]
["Book Value Per Share",0,25.01,27.56,25.95,25.4]
["Quick Links"]
["     "]
["Services"]
["Account Types"]
["Premium Services"]
["Zacks Rank"]
["Research"]
["Personal Finance"]
["Commentary"]
["Education"]
["Zacks Advisor Tools"]
["My Account"]
["Manage Account"]
["Update Profile"]
["Subscriptions"]
["Preferences"]
["Login/Password Help"]
["Upgrade to Premium"]
["Resources"]
["Help"]
["About Zacks"]
["Disclosure"]
["Privacy Policy"]
["Terms of Service"]
["Performance"]
["Site Map"]
["Podcasts"]
["Earnings Calendar"]
["Client Support"]
["Contact Us"]
["Share Feedback"]
["Media"]
["Careers"]
["Advertise"]
["Follow Us"]
["Facebook"]
["Twitter"]
["Linkedin"]
["RSS"]
["You Tube"]
["Zacks Moblie App"]
["Apple play store"]
["Get it on Google Play"]
["Zacks Research is Reported On:"]
[]
["Yahoo"]
["MSN"]
["Marketwatch"]
["Nasdaq"]
["Forbes"]
["Investors.com"]
["Morningstar"]
[]
["Zacks Investment Research is an A+ Rated BBB Accredited Business"]
["Copyright 2018 Zacks Investment Research"]
["At the center of everything we do is a strong commitment to independent research and sharing its profitable discoveries with investors. This dedication to giving investors a trading advantage led to the creation of our proven Zacks Rank stock-rating system. Since 1988 it has more than doubled the S&P 500 with an average gain of +25% per year. These returns cover a period from 1988-2017. Zacks Rank stock-rating system returns are computed monthly based on the beginning of the month and end of the month Zacks Rank stock prices plus any dividends received during that particular month. A simple, equally-weighted average return of all Zacks Rank stocks is calculated to determine the monthly return. The monthly returns are then compounded to arrive at the annual return. Only Zacks Rank stocks included in Zacks hypothetical portfolios at the beginning of each month are included in the return calculations. Zack Ranks stocks can, and often do, change throughout the month. Certain Zacks Rank stocks for which no month-end price was available, pricing information was not collected, or for certain other reasons have been excluded from these return calculations."]
["Visit performance for information about the performance numbers displayed above."]
["Visit www.zacksdata.com to get our data and content for your mobile app or website."]
["Real time prices by BATS. Delayed quotes by Sungard."]
["NYSE and AMEX data is at least 20 minutes delayed. NASDAQ data is at least 15 minutes delayed."]
["We use cookies to understand how you use our site and to improve your experience. This includes personalizing content and advertising. To learn more, click here. By continuing to use our site, you accept our use of cookies, revised Privacy Policy and Terms and Conditions of Service."]
["I accept X"]

{"sheet":"Name","index":4,"n_rows":110,"n_cols":2,"rows_kept":110,"cut":false,"hidden":true,"merged":[]}
[{"$f":"Analysis!E2","v":"aapl"},"http://financials.morningstar.com/company-profile/c.action?t=CCL&region=USA&culture=en_US"]
[]
["start logo"]
["Welcome!"]
["Company News Company Site Premium Log In"]
["end logo start leaderboard ads"]
["end leaderboard ads start main navigation"]
["Membership Home Portfolio Stocks Bonds Funds ETFs CEF Markets Tools Real Life Finance Discuss"]
["start sub navigation"]
["Investing Ideas"]
["Fund Analyst Picks"]
["Picks by Category"]
["Fund Pick Performance"]
["Picks & Pans E-Newsletter"]
["Fund Spy Column"]
["Fund Spy Book"]
["Bond Squad"]
["Fund Video Reports"]
["FundInvestor Newsletter"]
["ETF Investing"]
["Fund Family Experts"]
["Fund Reports"]
["All Fund Analyst Reports"]
["Fund Stewardship Reports"]
["Fund Ratings"]
["Highest-Rated Value"]
["Highest-Rated Growth"]
["Highest-Rated Large-Cap"]
["Highest-Rated Mid-Cap"]
["Highest-Rated Small-Cap"]
["Foreign Fund Standouts"]
["Star Rating Performance"]
["Rating Methodology"]
["Fund Performance"]
["Top 1-Month Performers"]
["Top YTD Performers"]
["Top 1-Year Performers"]
["Top 3-Year Performers"]
["Top 5-Year Performers"]
["Fund Category Returns"]
["Biggest Daily NAV Changes"]
["Closed-End Funds"]
["Exchange-Traded Funds"]
["Quarterly Market Outlook"]
["Fund Screeners"]
["Basic Screeners"]
["Fund Screener"]
["Long-Term Winners"]
["Solid Small-Growth Funds"]
["Conservative Bond Funds"]
["Premium Screeners"]
["Premium Fund Screener"]
["Index Funds"]
["Hidden Gems"]
["Lower-Risk Foreign Funds"]
["Video Center"]
["end sub navigation"]
["end main navigation"]
["end header wrap"]
["Apple Inc"]
[" AAPL Morningstar Rating "]
["Add to Portfolio"]
["Get E-mail Alerts"]
["Print This Page"]
["PDF Report"]
["Data Question"]
["Quote"]
["Chart"]
["Stock Analysis"]
["Performance"]
["Key Ratios"]
["Financials"]
["Valuation"]
["Insiders"]
["Ownership"]
["Filings"]
["Bonds"]
["Overview"]
["Company Profile"]
["Industry Peers"]
[]
["start leaderboard ads"]
["end leaderboard ads"]
["Site Directory Site Map Our Products"]
["start site directory"]
["end site directory start site smap"]
["end smapwrap"]
["end site map start products"]
["end prodwrap"]
["end products"]
["end directory start links"]
["Corrections Help Advertising Opportunities Licensing Opportunities Glossary RSS Mobile Portfolio Affiliate Careers"]
["end links start international sites"]
["International Sites: Australia Canada China France Germany Hong Kong Italy The Netherlands Norway Spain U.K. Switzerland"]
["end international sites start copyright, seo"]
["Stocks by: Name | Ticker | Star Rating | Market Cap | Stock Type | Sector | Industry"]
["Mutual Funds by: Star Rating | Investment Style | Total Assets | Category | Top Holdings | Top Sectors | Symbol / Ticker | Name"]
["ETFs by: Star Rating | Category | Total Assets | Symbol / Ticker | Name"]
["Articles by: Title | Date | Author | Collection | Interest | Popularity"]
["Investment Categories by: Topic | Sector | Key Indicators | User Interest | Market Cap | Industry"]
["Premium Stocks by: Name | Ticker | Star Rating | Market Cap | Stock Type | Sector | Industry"]
["Premium Mutual Funds by: Star Rating | Investment Style | Total Assets | Category | Top Holdings | Top Sectors | Symbol / Ticker | Name"]
["Premium ETFs by: Star Rating | Category | Total Assets | Symbol / Ticker | Name"]
["Popular Articles by: Title | Date | Author | Collection | Interest | Popularity"]
["Popular Investment Categories by: Topic | Sector | Key Indicators | User Interest | Market Cap | Industry"]
["Independent. Insightful. Trusted. Morningstar provides stock market analysis; equity, mutual fund, and ETF research, ratings, and picks; portfolio tools; and option, hedge fund, IRA, 401k, and 529 plan research. Our reliable data and analysis can help both experienced enthusiasts and newcomers."]
[]
["© Copyright Morningstar, Inc. All rights reserved. Please read our Terms of Useand Privacy Policy.Dow Jones Industrial Average, S&P 500, Nasdaq, and Morningstar Index (Market Barometer) quotes are real-time. Russell 2000 quote is 10 minutes delayed."]
["end copyright, seo"]
["end footerwrap"]

{"sheet":"Income","index":5,"n_rows":496,"n_cols":10,"rows_kept":496,"cut":false,"hidden":true,"merged":[]}
[{"$f":"Analysis!E2","v":"aapl"}]
["Zacks Investment Research"]
[]
["Join"]
["Sign In"]
["Member Sign In"]
["Keep Me Signed In What does \"Remember Me\" do?"]
["Forgot Password"]
["Create a New Account"]
[]
["Home"]
["Stocks Stocks +"]
[]
["Stocks"]
["Zacks #1 Rank"]
["Zacks Rank"]
["Zacks Industry Rank"]
["Zacks Sector Rank"]
["Equity Research"]
["Markets"]
[]
["Funds Funds +"]
[]
["Funds"]
["Mutual Funds"]
["ETFs"]
["Mutual Fund Screener"]
["ETF Screener"]
["Top ETFs"]
[]
["Earnings Earnings +"]
[]
["Earnings"]
["Earnings Calendar"]
["Earnings Releases"]
["Earnings ESP"]
["Earnings ESP Filter"]
[]
["Screening Screening +"]
[]
["Screening"]
["Stock Screener"]
["Mutual Fund Screener"]
["ETF Screener"]
["Premium Screens"]
["Quant Monitor"]
["Research Wizard"]
[]
["Finance Finance +"]
[]
["Personal Finance"]
["Insurance"]
["Investing"]
["Money Managing"]
["Real Estate"]
["Retirement Planning"]
["Tax Information"]
[]
["Portfolio Portfolio +"]
[]
["My Portfolio"]
["Create Portfolio"]
[]
["Education Education +"]
[]
["Education"]
["Stocks"]
["Style Scores"]
["Funds"]
["Earnings ESP"]
["Screening"]
["Video"]
["Testimonial"]
[]
["Services Services +"]
[]
[]
["Services Overview"]
["Zacks Ultimate"]
["Zacks Investor Collection"]
["Zacks Premium"]
[]
[]
[]
[]
["Investor Services"]
["ETF Investor"]
["Home Run Investor"]
["Income Investor"]
["Stocks Under $10"]
["Value Investor"]
["Top 10 Stocks"]
[]
[]
[]
["Other Services"]
["Method for Trading"]
["Research Wizard"]
["Zacks Confidential"]
[]
[]
[]
[]
[]
["Trading Services"]
["Black Box Trader"]
["Counterstrike"]
["Insider Trader"]
["Large-Cap Trader"]
["Momentum Trader"]
["Options Trader"]
["Short List"]
["Surprise Trader"]
["TAZR"]
[]
[]
[]
["Innovators"]
["Blockchain"]
["Healthcare"]
["Technology"]
[]
["Menu"]
[]
["Home"]
["Stocks Stocks +"]
[]
["Stocks"]
["Zacks #1 Rank"]
["Zacks Rank"]
["Zacks Industry Rank"]
["Zacks Sector Rank"]
["Equity Research"]
["Markets"]
[]
["Funds Funds +"]
[]
["Funds"]
["Mutual Funds"]
["ETFs"]
["Mutual Fund Screener"]
["ETF Screener"]
["Top ETFs"]
[]
["Earnings Earnings +"]
[]
["Earnings"]
["Earnings Calendar"]
["Earnings Releases"]
["Earnings ESP"]
["Earnings ESP Filter"]
[]
["Screening Screening +"]
[]
["Screening"]
["Stock Screener"]
["Mutual Fund Screener"]
["ETF Screener"]
["Premium Screens"]
["Quant Monitor"]
["Research Wizard"]
[]
["Finance Finance +"]
[]
["Personal Finance"]
["Insurance"]
["Investing"]
["Money Managing"]
["Real Estate"]
["Retirement Planning"]
["Tax Information"]
[]
["Portfolio Portfolio +"]
[]
["My Portfolio"]
["Create Portfolio"]
[]
["Education Education +"]
[]
["Education"]
["Stocks"]
["Style Scores"]
["Funds"]
["Earnings ESP"]
["Screening"]
["Video"]
["Testimonial"]
[]
["Services Services +"]
[]
[]
["Services Overview"]
["Zacks Ultimate"]
["Zacks Investor Collection"]
["Zacks Premium"]
[]
[]
[]
[]
["Investor Services"]
["ETF Investor"]
["Home Run Investor"]
["Income Investor"]
["Stocks Under $10"]
["Value Investor"]
["Top 10 Stocks"]
[]
[]
[]
["Other Services"]
["Method for Trading"]
["Research Wizard"]
["Zacks Confidential"]
[]
[]
[]
[]
[]
["Trading Services"]
["Black Box Trader"]
["Counterstrike"]
["Insider Trader"]
["Large-Cap Trader"]
["Momentum Trader"]
["Options Trader"]
["Short List"]
["Surprise Trader"]
["TAZR"]
[]
[]
[]
["Innovators"]
["Blockchain"]
["Healthcare"]
["Technology"]
[]
["Join"]
[]
["Sign In"]
[]
["Member Sign In"]
["Keep Me Signed In What does \"Remember Me\" do?"]
["Forgot Password"]
["Create a New Account"]
["Close this window"]
[]
["Help"]
[]
["Zacks Investment Research"]
["You are being directed to ZacksTrade, a division of LBMZ Securities and licensed broker-dealer. ZacksTrade and Zacks.com are separate companies. The web link between the two companies is not a solicitation or offer to invest in a particular security or type of security. ZacksTrade does not endorse or adopt any particular investment strategy, any analyst opinion/rating/report or any approach to evaluating indiv idual securities."]
["If you wish to go to ZacksTrade, click OK. If you do not, click Cancel."]
["OK Cancel"]
["Back to top"]
["more "]
["Financials"]
["Income Statements"]
["close"]
[]
["Quotes & News "]
[]
[]
["Quote Overview"]
["Zacks News "]
["Partner News "]
[]
["Zacks Research "]
[]
[]
["*Snapshot"]
["*Analyst Report"]
["*Style Scores"]
["*Detailed Estimates"]
["Comparison to Industry"]
["Zacks Experts View"]
[]
["More Research "]
[]
[]
["*Broker Recommendations "]
["Full Company Report"]
["Earnings Announcements"]
["Key Company Metrics"]
["Broker Reports "]
["Insiders "]
["Earnings Transcripts"]
[]
["Charts "]
[]
[]
["*Price, Consensus and EPS Surprise"]
["*Fundamental Charts"]
["Comparative"]
["Interactive Charts"]
["Price and Consensus"]
["Price & EPS Surprise"]
["12 Month EPS"]
["Broker Recommendations"]
[]
["Financials "]
[]
[]
["Financial Overview "]
["Income Statements "]
["Balance Sheet "]
["Cash flow Statements"]
[]
["Options "]
[]
[]
["Option Chain"]
["Options Greek Montage"]
[]
["Access Zacks"]
["Data Feed"]
[]
["Apple Inc. (AAPL)"]
["(Real Time Quote from BATS)"]
["$190.29 USD"]
[190.29]
[31320430]
["+0.81 (0.43%)"]
["Updated Jul 31, 2018 03:58 PM ET"]
["After-Market: $195.72 +5.43 (2.85%) 5:00 PM ET"]
["Add to portfolio"]
["Zacks Rank: "]
["2-Buy   2      "]
["Style Scores: "]
["B Value | C Growth | D Momentum | B VGM"]
["The Style Scores are a complementary set of indicators to use alongside the Zacks Rank. It allows the user to better focus on the stocks that are the best fit for his or her personal trading style."]
["The scores are based on the trading styles of Value, Growth, and Momentum. There's also a VGM Score ('V' for Value, 'G' for Growth and 'M' for Momentum), which combines the weighted average of the individual style scores into one score."]
["Value Score","A"]
["Growth Score","A"]
["Momentum Score","A"]
["VGM Score","A"]
["Within each Score, stocks are graded into five groups: A, B, C, D and F. As you might remember from your school days, an A, is better than a B; a B is better than a C; a C is better than a D; and a D is better than an F."]
["As an investor, you want to buy stocks with the highest probability of success. That means you want to buy stocks with a Zacks Rank #1 or #2, Strong Buy or Buy, which also has a Score of an A or a B in your personal trading style."]
["Zacks Style Scores Education - Learn more about the Zacks Style Scores"]
["Industry Rank: "]
["Top 20%(51 out of 255)"]
["Industry: Computer - Mini computers"]
["View All Zacks #1 Ranked Stocks"]
["Trades from $3 "]
["This is our short term rating system that serves as a timeliness indicator for stocks over the next 1 to 3 months. How good is it? See rankings and related performance below."]
["Zacks Rank","Definition","Annualized Return"]
[1,"Strong Buy",0.2571]
[2,"Buy",0.1812]
[3,"Hold",9.9099999999999994E-2]
[4,"Sell",5.4899999999999997E-2]
[5,"Strong Sell",2.29E-2]
["S&P",500,9.7900000000000001E-2]
["Zacks Rank Education - Learn about the Zacks Rank"]
["Zacks Rank Home - Zacks Rank resources in one place"]
["Zacks Premium - The only way to fully access the Zacks Rank"]
["The Zacks Equity Research reports, or ZER for short, are our in-house, independently produced research reports."]
["The ever popular one-page Snapshot reports are generated for virtually every single Zacks Ranked stock. It's packed with all of the company's key stats and salient decision making information. Including the Zacks Rank, Zacks Industry Rank, Style Scores, the Price, Consensus & Surprise chart, graphical estimate analysis and how a stocks stacks up to its peers."]
["The detailed multi-page Analyst report does an even deeper dive on the company's vital statistics. In addition to all of the proprietary analysis in the Snapshot, the report also visually displays the four components of the Zacks Rank (Agreement, Magnitude, Upside and Surprise); provides a comprehensive overview of the company business drivers, complete with earnings and sales charts; a recap of their last earnings report; and a bulleted list of reasons to buy or sell the stock. It also includes an industry comparison table to see how your stock compares to its expanded industry, and the S&P 500."]
["Researching stocks has never been so easy or insightful as with the ZER Analyst and Snapshot reports."]
["Learn more about Zacks Equity Research reports"]
["See more Zacks Equity Research reports"]
["The Zacks Industry Rank assigns a rating to each of the 265 X (Expanded) Industries based on their average Zacks Rank."]
["An industry with a larger percentage of Zacks Rank #1&apos;s and #2&apos;s will have a better average Zacks Rank than one with a larger percentage of Zacks Rank #4&apos;s and #5&apos;s."]
["The industry with the best average Zacks Rank would be considered the top industry (1 out of 265), which would place it in the top 1% of Zacks Ranked Industries. The industry with the worst average Zacks Rank (265 out of 265) would place in the bottom 1%."]
["Zacks Rank Education -- Learn more about the Zacks Rank"]
["Zacks Industry Rank Education -- Learn more about the Zacks Industry Rank"]
["Apple Inc. (AAPL) Quote Overview » Financials » Apple Inc. (AAPL) Income Statements "]
["Income Statements"]
["The Style Scores are a complementary set of indicators to use alongside the Zacks Rank. It allows the user to better focus on the stocks that are the best fit for his or her personal trading style."]
["The scores are based on the trading styles of Value, Growth, and Momentum. There's also a VGM Score ('V' for Value, 'G' for Growth and 'M' for Momentum), which combines the weighted average of the individual style scores into one score."]
["Value Score","A"]
["Growth Score","A"]
["Momentum Score","A",null,null,null,null,null,"intc","ccl","msft"]
["VGM Score","A",null,null,null,null,null,59387,16389,89950]
["Within each Score, stocks are graded into five groups: A, B, C, D and F. As you might remember from your school days, an A, is better than a B; a B is better than a C; a C is better than a D; and a D is better than an F.",null,null,null,null,null,null,23196,9383,34261]
["As an investor, you want to buy stocks with the highest probability of success. That means you want to buy stocks with a Zacks Rank #1 or #2, Strong Buy or Buy, which also has a Score of an A or a B in your personal trading style."]
["Zacks Style Scores Education - Learn more about the Zacks Style Scores"]
["Research for AAPL "]
["   "]
["The Zacks Equity Research reports, or ZER for short, are our in-house, independently produced research reports."]
["The ever popular one-page Snapshot reports are generated for virtually every single Zacks Ranked stock. It's packed with all of the company's key stats and salient decision making information. Including the Zacks Rank, Zacks Industry Rank, Style Scores, the Price, Consensus & Surprise chart, graphical estimate analysis and how a stocks stacks up to its peers."]
["The detailed multi-page Analyst report does an even deeper dive on the company's vital statistics. In addition to all of the proprietary analysis in the Snapshot, the report also visually displays the four components of the Zacks Rank (Agreement, Magnitude, Upside and Surprise); provides a comprehensive overview of the company business drivers, complete with earnings and sales charts; a recap of their last earnings report; and a bulleted list of reasons to buy or sell the stock. It also includes an industry comparison table to see how your stock compares to its expanded industry, and the S&P 500."]
["Researching stocks has never been so easy or insightful as with the ZER Analyst and Snapshot reports."]
["Learn more about Zacks Equity Research reports"]
["See more Zacks Equity Research reports"]
[]
["Annual Income Statement"]
["Quarterly Income Statement"]
["Fiscal Year end for Apple Inc. falls in the month of September."]
["All items in Millions except EPS data."]
[null,43008,42643,42277,41912,41547]
["Sales",229234,215639,233715,182795,170910]
["Cost Of Goods","2286-03-04","2259-09-10","2283-07-19","2207-05-08","2191-11-15"]
["Gross Profit",88186,84263,93626,70537,64304]
["Selling & Adminstrative & Depr. & Amort Expenses",26842,24239,22396,18034,15305]
["Income After Depreciation & Amortization",61344,60024,71230,52503,48999]
["Non-Operating Income",2745,1348,1285,980,1156]
["Interest Expense",0,0,0,0,0]
["Pretax Income","2075-06-19","2068-01-10","2098-07-14","2046-06-05","2037-04-25"]
["Income Taxes",15738,15685,19121,13973,13118]
["Minority Interest",0,0,0,0,0]
["Investment Gains/Losses",0,0,0,0,0]
["Other Income/Charges",0,0,0,0,0]
["Income From Cont. Operations",48351,45687,53394,39510,37037]
["Extras & Discontinued Operations",0,0,0,0,0]
["Net Income",48351,45687,53394,39510,37037]
["Depreciation Footnote",43008,42643,42277,41912,41547]
["Income Before Depreciation & Amortization",71501,70529,82487,60449,55756]
["Depreciation & Amortization (Cash Flow)",10157,10505,11257,7946,6757]
["Income After Depreciation & Amortization",61344,60024,71230,52503,48999]
["Earnings Per Share Data","2017-09-30","2016-09-30","2015-09-30","2014-09-30","2013-09-30"]
["Average Shares",5251.69,5500.28,5793.07,6122.66,6521.63]
["Diluted EPS Before Non-Recurring Items","1900-01-09T05:02:24","1900-01-08T07:26:24","1900-01-09T05:16:48","1900-01-06T10:48:00","1900-01-05T16:19:12"]
["Diluted Net EPS",9.2100000000000009,8.31,9.2200000000000006,6.45,5.68]
["Fiscal Year end for Apple Inc. falls in the month of September."]
["All items in Millions except EPS data."]
[null,"2018-06-30",43190,43100,43008,42916]
["Sales","NA",61137,88293,52579,45408]
["Cost Of Goods","NA",37715,54381,32648,27920]
["Gross Profit","NA",23422,33912,19931,17488]
["SG&A, R&D, and Dept/Amort Expenses",0,7528,7638,6811,6720]
["Income After SG&A, R&D, and Dept/Amort Expenses",0,15894,26274,13120,10768]
["Non-Operating Income","NA",274,756,797,540]
["Interest Expense","NA",0,0,0,0]
["Pretax Income","NA",16168,27030,13917,11308]
["Income Taxes","NA",2346,6965,3203,2591]
["Minority Interest","NA",0,0,0,0]
["Investment Gains/Losses","NA",0,0,0,0]
["Other Income/Charges","NA","00:00:00","00:00:00","00:00:00","00:00:00"]
["Income From Cont. Operations","NA",13822,20065,10714,8717]
["Extras & Discontinued Operations","NA",0,0,0,0]
["Net Income","NA",13822,20065,10714,8717]
["Earnings Per Share Data","2018-06-30","2018-03-31","2017-12-31","2017-09-30","2017-06-30"]
["Average Shares","NA",5068.49,5157.79,5183.59,5233.5]
["Diluted EPS Before Non-Recurring Items","NA",2.73,3.89,2.0699999999999998,1.67]
["Diluted Net EPS","NA",2.73,3.89,2.08,1.67]
["Quick Links"]
["     "]
["Services"]
["Account Types"]
["Premium Services"]
["Zacks Rank"]
["Research"]
["Personal Finance"]
["Commentary"]
["Education"]
["Zacks Advisor Tools"]
["My Account"]
["Manage Account"]
["Update Profile"]
["Subscriptions"]
["Preferences"]
["Login/Password Help"]
["Upgrade to Premium"]
["Resources"]
["Help"]
["About Zacks"]
["Disclosure"]
["Privacy Policy"]
["Terms of Service"]
["Performance"]
["Site Map"]
["Podcasts"]
["Earnings Calendar"]
["Client Support"]
["Contact Us"]
["Share Feedback"]
["Media"]
["Careers"]
["Advertise"]
["Follow Us"]
["Facebook"]
["Twitter"]
["Linkedin"]
["RSS"]
["You Tube"]
["Zacks Moblie App"]
["Apple play store"]
["Get it on Google Play"]
["Zacks Research is Reported On:"]
[]
["Yahoo"]
["MSN"]
["Marketwatch"]
["Nasdaq"]
["Forbes"]
["Investors.com"]
["Morningstar"]
[]
["Zacks Investment Research is an A+ Rated BBB Accredited Business"]
["Copyright 2018 Zacks Investment Research"]
["At the center of everything we do is a strong commitment to independent research and sharing its profitable discoveries with investors. This dedication to giving investors a trading advantage led to the creation of our proven Zacks Rank stock-rating system. Since 1988 it has more than doubled the S&P 500 with an average gain of +25% per year. These returns cover a period from 1988-2017. Zacks Rank stock-rating system returns are computed monthly based on the beginning of the month and end of the month Zacks Rank stock prices plus any dividends received during that particular month. A simple, equally-weighted average return of all Zacks Rank stocks is calculated to determine the monthly return. The monthly returns are then compounded to arrive at the annual return. Only Zacks Rank stocks included in Zacks hypothetical portfolios at the beginning of each month are included in the return calculations. Zack Ranks stocks can, and often do, change throughout the month. Certain Zacks Rank stocks for which no month-end price was available, pricing information was not collected, or for certain other reasons have been excluded from these return calculations."]
["Visit performance for information about the performance numbers displayed above."]
["Visit www.zacksdata.com to get our data and content for your mobile app or website."]
["Real time prices by BATS. Delayed quotes by Sungard."]
["NYSE and AMEX data is at least 20 minutes delayed. NASDAQ data is at least 15 minutes delayed."]
["We use cookies to understand how you use our site and to improve your experience. This includes personalizing content and advertising. To learn more, click here. By continuing to use our site, you accept our use of cookies, revised Privacy Policy and Terms and Conditions of Service."]
["I accept X"]

{"sheet":"Bond rate","index":6,"n_rows":291,"n_cols":4,"rows_kept":291,"cut":false,"hidden":true,"merged":[]}
[null,"http://www.bankrate.com/rates/interest-rates/treasury.aspx?ec_id=m1108343&s_kwcid=AL!1325!10!755415317!7018561280&ef_id=VEqRkgAAAagJjRd7:20141024175838:s"]
["Mortgages"]
[]
["Compare Lenders"]
[]
[]
["Mortgage rates"]
["Refinance rates"]
["Home equity loan rates"]
["Mortgage lender reviews"]
[]
["Use Calculators"]
[]
[]
["Mortgage calculator"]
["How much house can you afford?"]
["Mortgage refinance calculator"]
["Mortgage payment calculator"]
["Amortization calculator"]
["All home equity calculators"]
["All mortgage calculators"]
[]
["Get Advice"]
[]
[]
["Reverse mortgages"]
["What is a home equity loan?"]
["Home buying guide"]
["Refinance your mortgage"]
["First-time homebuyer tips"]
["FHA loans"]
["Banking"]
[]
["Compare Accounts"]
[]
[]
["CD rates"]
["Savings accounts"]
["Money market accounts"]
["Checking accounts"]
["Bank ratings"]
[]
["Use Calculators"]
[]
[]
["Savings calculator"]
["CD calculator"]
["Compound savings calculator"]
["All banking calculators"]
[]
["Get Advice"]
[]
[]
["Money market account vs. savings account"]
["Prime rate"]
["Credit union basics"]
["Credit Cards"]
[]
["Compare Cards"]
[]
[]
["0 interest credit cards"]
["Airline credit cards"]
["Balance transfer credit cards"]
["Business credit cards"]
["Cash-back credit cards"]
["Rewards credit cards"]
["Credit card reviews"]
[]
["Use Calculators"]
[]
[]
["Credit card payoff calculator"]
["Balance transfer calculator"]
["Credit card consolidation calculator"]
["All credit card calculators"]
[]
["Get Advice"]
[]
[]
["Getting a secured credit card"]
["Balance transfer pros and cons"]
["Credit card fraud protection"]
["Manage your credit"]
[]
["Best Offers"]
[]
[]
["Best credit cards of 2018"]
["Best reward cards"]
["Best travel credit cards"]
["Best balance transfer credit cards"]
["Best cash-back credit cards"]
["Best student credit cards"]
["Best business credit cards"]
["Loans"]
[]
["Compare Lenders"]
[]
[]
["Personal loan rates"]
["Auto loan rates"]
[]
["Loan Types"]
[]
[]
["Personal loans"]
["Auto loans"]
["Debt consolidation loans"]
["Home improvement loans"]
["Student loans"]
["Medical loans"]
["Bad credit loans"]
[]
["Use Calculators"]
[]
[]
["Loan calculator"]
["Auto loan calculator"]
["Personal loan calculator"]
["Auto refinance calculator"]
["Loan payment calculator"]
["Student loan calculator"]
["All calculators"]
[]
["Get Advice"]
[]
[]
["Personal loans guide"]
["Student loans guide"]
["Refinancing student loans"]
["Refinancing personal loans"]
["Refinancing auto loans"]
["How to get a personal loan"]
["Personal loan origination fees"]
["Investing"]
[]
["Compare"]
[]
[]
["IRA CD rates"]
["Brokerage accounts"]
["Brokerage reviews"]
[]
["Use Calculators"]
[]
[]
["Investment calculator"]
["Annuity calculator"]
["401(K) calculator"]
["Roth IRA calculator"]
["All retirement calculators"]
["All investing calculators"]
[]
["Get Advice"]
[]
[]
["Creating passive income"]
["Mutual fund vs. ETF"]
["Roth IRA vs. traditional IRA"]
["What type of CD is best?"]
["IRA basics"]
["Personal Finance"]
[]
["Compare"]
[]
[]
["Current interest rates"]
["Compare rates"]
[]
["Use Calculators"]
[]
[]
["Debt consolidation calculator"]
["Net worth calculator"]
["Personal finance calculators"]
["Cost of living calculator"]
["All calculators"]
[]
["Get Advice"]
[]
[]
["Retirement advice"]
["Debt management"]
["Improve your credit score"]
["Career resources"]
["Tax advice"]
["Insurance basics"]
["Real estate tips"]
["Personal finance glossary"]
[]
["Free credit report"]
["myBankrate"]
[]
["open"]
[]
["1. Rate watch"]
["2. Treasury securities"]
[]
["Treasury securities"]
[]
["Investors and those following the movement of interest rates look at the movement of Treasury yields as an indicator of things to come. Their rates are considered an important benchmark: Because Treasury securities are backed by the full faith and credit of the U.S. Treasury, they represent the rate at which investment is considered risk-free."]
[]
["Click on the links below to find a fuller explanation of the term."]
[]
["Treasury securities Updated: 07/30/2018"]
[null,"This week","Month ago","Year ago"]
["One-Year Treasury Constant Maturity",2.4300000000000002,2.34,1.22]
["91-day T-bill auction avg disc rate",2,1.94,1.07]
["182-day T-bill auction avg disc rate",2.16,2.09,1.1299999999999999]
["Two-Year Treasury Constant Maturity",2.63,2.57,1.34]
["Five-Year Treasury Constant Maturity",2.83,2.75,1.8]
["Ten-Year Treasury Constant Maturity",2.95,2.87,2.2599999999999998]
["One-Year CMT (Monthly)",2.33,2.33,1.2]
["One-Year MTA",1.75,1.75,0.83]
[]
["Ratings methodology"]
[]
["Since investors in riskier investments command a higher return as compensation, the yields on many bonds and money market instruments are priced at a spread over the corresponding risk-free Treasury rate. Yields on money markets and certificates of deposit are often priced relative to yields on Treasuries of a similar length. Adjustable rate mortgages can be indexed to the one-year Treasury. Fixed mortgage rates are closely linked to movements in long-term Treasury yields, as mortgages are often packaged together and sold as mortgage-backed bonds. Yields on short-term Treasuries can behave differently from yields on longer-term Treasuries."]
[]
["Compare mortgage rates"]
[]
["Fixed Rates"]
[]
["10 year fixed"]
["10 year fixed refi"]
["15 year fixed"]
["15 year fixed refi"]
["20 year fixed"]
["20 year fixed refi"]
["30 year fixed"]
["30 year fixed refi"]
["30 year FHA"]
["30 year FHA refi"]
[]
["Adjustable Rates"]
[]
["1 year ARM"]
["1 year ARM refi"]
["3/1 ARM"]
["3/1 ARM refi"]
["5/1 ARM"]
["5/1 ARM refi"]
["7/1 ARM"]
["7/1 ARM refi"]
["10/1 ARM"]
["10/1 ARM refi"]
[]
["Interest Only Rates"]
[]
["3/1 ARM (IO)"]
["5/1 ARM (IO) refi"]
["5/1 ARM (IO)"]
["7/1 ARM (IO) refi"]
["7/1 ARM (IO)"]
["30 year (IO) refi"]
["30 year fixed (IO)"]
["3/1 ARM (IO) refi"]
[]
["About Us"]
["Press Room"]
["Affiliate Center"]
["Contact Us"]
["Careers"]
[]
["Advertise With Us"]
["Latest News"]
["Popular Topics"]
["Glossary"]
["Compare Rates"]
[]
["Understand Bankrate's Averages"]
["Privacy Policy / Your California Privacy Rights"]
["Terms of Use"]
["Licenses"]
["Sitemap"]
[]
["How we make money"]
[]
["Bankrate.com is an independent, advertising-supported publisher and comparison service. Bankrate is compensated in exchange for featured placement of sponsored products and services, or your clicking on links posted on this website. This compensation may impact how, where and in what order products appear. Bankrate.com does not include all companies or all available products."]
[]
["Maximize Your Money. Get Expert Advice & Tools. Master Life's Financial Journey."]
[]
["You have money questions. Bankrate has answers. Our experts have been helping you master your money for four decades."]
[]
["Our tools, rates and advice help no matter where you are on lifeâ€™s financial journey."]
[]
["Follow Us"]
[]
["© 2018 Bankrate, LLC All Rights Reserved."]
["United States United Kingdom "]

{"sheet":"10 Yr PE","index":7,"n_rows":194,"n_cols":2,"rows_kept":194,"cut":false,"hidden":true,"merged":[]}
[]
["S&P 500 PE Ratio"]
["Shiller PE Ratio"]
["10 Year Treasury Rate"]
["S&P 500 Dividend Yield"]
["S&P 500 Earnings"]
["S&P 500 Historical Prices"]
["more"]
["multpl"]
[]
["multpl"]
["menu"]
["S&P 500 PE Ratio by Year"]
["For the Shiller PE10 Ratio, see Shiller PE."]
[]
["Chart"]
["Table"]
["Share"]
[]
["Show:"]
["By Year"]
["By Month"]
[]
["Date","Value Value"]
["2017-09-22","24.92 estimate"]
["2017-01-01",23.59]
["2016-01-01",22.18]
["2015-01-01",20.02]
["2014-01-01",18.149999999999999]
["2013-01-01",17.03]
["2012-01-01",14.87]
["2011-01-01",16.3]
["2010-01-01",20.7]
["2009-01-01",70.91]
["2008-01-01",21.46]
["2007-01-01",17.36]
["2006-01-01",18.07]
["2005-01-01",19.989999999999998]
["2004-01-01",22.73]
["2003-01-01",31.43]
["2002-01-01",46.17]
["2001-01-01",27.55]
["2000-01-01",29.04]
["1999-01-01",32.92]
["1998-01-01",24.29]
["1997-01-01",19.53]
["1996-01-01",18.079999999999998]
["1995-01-01",14.89]
["1994-01-01",21.34]
["1993-01-01",22.5]
["1992-01-01",25.93]
["1991-01-01",15.35]
["1990-01-01",15.13]
["1989-01-01",11.82]
["1988-01-01",14.03]
["1987-01-01",18.010000000000002]
["1986-01-01",14.28]
["1985-01-01",10.36]
["1984-01-01",11.52]
["1983-01-01",11.48]
["1982-01-01",7.73]
["1981-01-01",9.02]
["1980-01-01",7.39]
["1979-01-01",7.88]
["1978-01-01",8.2799999999999994]
["1977-01-01",10.41]
["1976-01-01",11.83]
["1975-01-01",8.3000000000000007]
["1974-01-01",11.68]
["1973-01-01",18.079999999999998]
["1972-01-01",18]
["1971-01-01",18.12]
["1970-01-01",15.76]
["1969-01-01",17.649999999999999]
["1968-01-01",17.7]
["1967-01-01",15.3]
["1966-01-01",17.809999999999999]
["1965-01-01",18.760000000000002]
["1964-01-01",18.78]
["1963-01-01",17.68]
["1962-01-01",21.25]
["1961-01-01",18.600000000000001]
["1960-01-01",17.12]
["1959-01-01",18.79]
["1958-01-01",12.5]
["1957-01-01",13.32]
["1956-01-01",12.13]
["1955-01-01",12.58]
["1954-01-01",10.1]
["1953-01-01",10.86]
["1952-01-01",9.9499999999999993]
["1951-01-01",7.47]
["1950-01-01",7.21]
["1949-01-01",6.62]
["1948-01-01",9.0399999999999991]
["1947-01-01",13.46]
["1946-01-01",19.170000000000002]
["1945-01-01",14.35]
["1944-01-01",12.61]
["1943-01-01",9.6999999999999993]
["1942-01-01",7.97]
["1941-01-01",10.050000000000001]
["1940-01-01",13.23]
["1939-01-01",18.940000000000001]
["1938-01-01",10.47]
["1937-01-01",16.75]
["1936-01-01",17.87]
["1935-01-01",16.25]
["1934-01-01",23.95]
["1933-01-01",17.29]
["1932-01-01",14.07]
["1931-01-01",17]
["1930-01-01",13.92]
["1929-01-01",17.760000000000002]
["1928-01-01",15.51]
["1927-01-01",10.89]
["1926-01-01",10.119999999999999]
["1925-01-01",11.02]
["1924-01-01",9.01]
["1923-01-01",12.54]
["1922-01-01",22.81]
["1921-01-01",9.36]
["1920-01-01",9.6]
["1919-01-01",7.93]
["1918-01-01",5.72]
["1917-01-01",6.34]
["1916-01-01",10.029999999999999]
["1915-01-01",13.6]
["1914-01-01",13.5]
["1913-01-01",13.48]
["1912-01-01",15.2]
["1911-01-01",12.88]
["1910-01-01",13.26]
["1909-01-01",15.1]
["1908-01-01",10.54]
["1907-01-01",12.75]
["1906-01-01",14.51]
["1905-01-01",16.53]
["1904-01-01",12.6]
["1903-01-01",13.65]
["1902-01-01",15.92]
["1901-01-01",14.73]
["1900-01-01",12.71]
["Jan 1, 1899",16.89]
["Jan 1, 1898",15.74]
["Jan 1, 1897",19.18]
["Jan 1, 1896",17.079999999999998]
["Jan 1, 1895",25]
["Jan 1, 1894",17.28]
["Jan 1, 1893",15.58]
["Jan 1, 1892",16.21]
["Jan 1, 1891",16.690000000000001]
["Jan 1, 1890",17.93]
["Jan 1, 1889",20.149999999999999]
["Jan 1, 1888",15.17]
["Jan 1, 1887",16.91]
["Jan 1, 1886",18.57]
["Jan 1, 1885",13.68]
["Jan 1, 1884",13.28]
["Jan 1, 1883",13.51]
["Jan 1, 1882",13.45]
["Jan 1, 1881",12.63]
["Jan 1, 1880",13.1]
["Jan 1, 1879",11.19]
["Jan 1, 1878",10.83]
["Jan 1, 1877",12.68]
["Jan 1, 1876",12.74]
["Jan 1, 1875",10.09]
["Jan 1, 1874",10.130000000000001]
["Jan 1, 1873",11.88]
["Jan 1, 1872",12.15]
["Jan 1, 1871",11.1]
[]
["Price to earnings ratio, based on trailing twelve month “as reported” earnings."]
[]
["Current PE is estimated from latest reported earnings and current market price."]
[]
["Source: Robert Shiller and his book Irrational Exuberance for historic S&P 500 PE Ratio."]
[]
["See also"]
[]
["Shiller PE Ratio"]
["S&P 500 Price to Sales Ratio"]
["S&P 500 Price to Book Value"]
["S&P 500 Earnings Yield"]
["Inflation Adjusted S&P 500"]
["S&P 500 Earnings"]
[]
["Information is provided ‘as is’ and solely for informational purposes, not for trading purposes or advice, and may be delayed."]
[]
["You should sign up for our mailing list here."]
[]
["Copyright © 2017"]
["contact@multpl.com"]

{"sheet":"Price2","index":8,"n_rows":561,"n_cols":16,"rows_kept":561,"cut":false,"hidden":true,"merged":[]}
[{"$f":"Analysis!E2","v":"aapl"}]
["Subscribe Now Sign In"]
["The Wall Street Journal"]
["2018-07-31"]
["Todays Paper"]
[]
["Home "]
["World "]
["U.S. "]
["Politics "]
["Economy "]
["Business "]
["Tech "]
["Markets "]
["Opinion "]
["Life & Arts "]
["Real Estate "]
["WSJ. Magazine "]
[]
["Apple Inc. AAPL (U.S.: Nasdaq)"]
["search",null,null,null,null,null,null,"Search"]
["View All companies",null,null,null,null,null,null,"view all companies"]
[]
["AT CLOSE 4:00 PM EDT 07/31/18"]
["$190.29 USD "]
["0.38 0.20% "]
["Volume 30,960,675"]
["AFTER HOURS 5:02 PM EDT 07/31/18"]
["$196.02 5.73 3.01% "]
["AFTER HOURS Vol 4,327,961"]
[]
["Volume 30,960,675"]
["65 Day Avg Vol 24,325,457"]
["1 Day Range 189.34 - 192.14"]
["52 Week Range 149.16 - 195.96 (09/25/17 - 07/26/18)"]
[]
["1 D"]
["5 D"]
["1 M"]
["3 M"]
["YTD"]
["1 Y"]
["3 Y"]
[]
["$"]
["%"]
[]
["Advanced Charting Compare"]
[]
["Compare to Benchmark:"]
["DJIA"]
["S&P 500"]
["GLOBAL DOW"]
["NASDAQ"]
["Technology"]
[]
["Compare to"]
["Add"]
["Open 190.30"]
["Prior Close 189.91 (07/30/18)"]
[]
["1 Day"]
["AAPL 0.20% "]
["DJIA 0.43% "]
["S&P 500 0.49% "]
["Technology -1.49% "]
[]
["Overview"]
[]
["News Apple Inc.AAPL"]
["Significant News Only"]
[]
[]
["5 min ago"]
["WSJ Blogs"]
["Apple Drives Stock Market’s Buyback Spree "]
["WSJ Blogs"]
[]
["21 min ago"]
["Press Release"]
["Apple Reports Third Quarter Results "]
["Press Release"]
[]
["22 min ago"]
["The Wall Street Journal"]
["Apple’s Revenue, Earnings Top Estimates "]
["The Wall Street Journal"]
[]
["26 min ago"]
["MarketWatch.com"]
["Apple earnings: Watch these 4 numbers "]
["MarketWatch.com"]
[]
["3 hours ago"]
["MarketWatch.com"]
["After a decade of wins, the end may be near for one of Wall Street’s best stock trades "]
["MarketWatch.com"]
[]
["7 hours ago"]
["The Wall Street Journal"]
["A FANG Index Slides Into Correction Territory "]
["The Wall Street Journal"]
[]
["7 hours ago"]
["The Wall Street Journal"]
["Apple Comes Under Media Fire in China "]
["The Wall Street Journal"]
[]
["8 hours ago"]
["MarketWatch.com"]
["Apple’s shaping up for a massive earnings beat, strategist predicts "]
["MarketWatch.com"]
[]
["9 hours ago"]
["MarketWatch.com"]
["Apple earnings: Brace for hints about the next iPhone "]
["MarketWatch.com"]
[]
["10 hours ago"]
["The Wall Street Journal"]
["Apple Could’ve Been a Trillionaire Long Ago "]
["The Wall Street Journal"]
[]
["11 hours ago"]
["The Wall Street Journal"]
["Apple Expected to Report Modest iPhone Growth "]
["The Wall Street Journal"]
[]
["2018-07-30"]
["MarketWatch.com"]
["Fear the FAANG stocks? Here’s a better S&P 500 index fund for you "]
["MarketWatch.com"]
[]
["2018-07-30"]
["MarketWatch.com"]
["Earnings Watch: Even Apple takes a back seat to Elon Musk right now "]
["MarketWatch.com"]
[]
["2018-07-28"]
["MarketWatch.com"]
["Weekend roundup: Facebook’s flogging | Amazon’s better news | FAANG stock exposure "]
["MarketWatch.com"]
[]
["2018-07-28"]
["Barron's"]
["Amazon Leads Tech Rivals in an Era of Shifts "]
["Barron's"]
[]
["2018-07-28"]
["Barron's"]
["How to Get a Share in a Vintage Car "]
["Barron's"]
[]
["2018-07-27"]
["Barron's"]
["Look Beyond the FANGs "]
["Barron's"]
[]
["2018-07-27"]
["MarketWatch.com"]
["These four fund managers and 30 analysts figured out how to consistently beat the S&P 500 "]
["MarketWatch.com"]
[]
["2018-07-27"]
["MarketWatch.com"]
["Here’s a hedge for investors against inflated FAANG stocks "]
["MarketWatch.com"]
[]
["2018-07-26"]
["The Wall Street Journal"]
["Facebook Leads Tech-Share Decline "]
["The Wall Street Journal"]
[]
["2018-07-26"]
["MarketWatch.com"]
["Wall Street veteran who flagged Apple at $1.14 a share says these 5 overlooked stocks are buys "]
["MarketWatch.com"]
[]
["2018-07-25"]
["Press Release"]
["Thinking about buying stock in Apple, Advanced Micro Devices, Fitbit, GoPro or Netflix? "]
["Press Release"]
[]
["2018-07-25"]
["Press Release"]
["Self-Driving and Electric Vehicles are Combining to Make the Cars of the Future "]
["Press Release"]
[]
["2018-07-24"]
["Press Release"]
["Apple Piazza Liberty Opens Thursday in Milan "]
["Press Release"]
[]
["2018-07-23"]
["Press Release"]
["Thinking about buying stock in Apple, General Electric, Hasbro, ReWalk Robotics, or Tesla? "]
["Press Release"]
[]
["2018-07-13"]
["Press Release"]
["Apple Supports Malala Fund Expansion in Latin America "]
["Press Release"]
[]
["2018-07-12"]
["Press Release"]
["Apple Launches New Clean Energy Fund in China "]
["Press Release"]
[]
["2018-07-12"]
["Press Release"]
["Apple Updates MacBook Pro with Faster Performance and New Features for Pros "]
["Press Release"]
[]
["2018-07-11"]
["Press Release"]
["Should you buy stock in Apple, Salesforce, Facebook, Netflix or NVIDIA? "]
["Press Release"]
[]
["2018-07-09"]
["Press Release"]
["Thinking about buying stock in Apple, Black Box Corporation, Helen of Troy Limited, Neovasc Inc. or Twitter? "]
["Press Release"]
[]
["2018-07-05"]
["Press Release"]
["Should you buy stock in Apple, Barnes & Noble, Facebook, Fiat Chrysler Auto or Netflix? "]
["Press Release"]
[]
["2018-06-28"]
["Press Release"]
["Should you buy stock in Apple, Advanced Micro Devices, Netflix, Neovasc Inc. or Energous? "]
["Press Release"]
[]
["2018-06-28"]
["Press Release"]
["The Fastest Growing Smartphone Market in the World "]
["Press Release"]
[]
["2018-06-25"]
["Press Release"]
["Apple News Launches 2018 Midterm Elections Section "]
["Press Release"]
[]
["2018-06-19"]
["Press Release"]
["Increasing Global Purchasing Power is Leading to Electronics-market Boom "]
["Press Release"]
[]
["2018-06-18"]
["Press Release"]
["Should you buy stock in Apple, Facebook, Helios and Matheson Analytics Inc, Microsoft or AT&T? "]
["Press Release"]
[]
["2018-06-18"]
["Press Release"]
["Apple's iOS 12 Securely and Automatically Shares Emergency Location with 911 "]
["Press Release"]
[]
["2018-06-13"]
["Press Release"]
["Growing Global Payments Industry Encourages Bold New Approaches to Transactions "]
["Press Release"]
[]
["2018-06-11"]
["Press Release"]
["Thinking about buying or selling stock in Apple, Amazon.com, Micron, NVIDIA or Tesla Motors? "]
["Press Release"]
[]
["2018-06-05"]
["Press Release"]
["Should you buy or sell stock in Apple, Chesapeake Energy, Chipotle Mexican Grill, Snap Inc. and Twitter? "]
["Press Release"]
[]
["load more"]
["Key Stock Data"]
["?"]
[]
["P/E Ratio (TTM)"]
["The Price to Earnings (P/E) ratio, a key valuation measure, is calculated by dividing the stock's most recent closing price by the sum of the diluted earnings per share from continuing operations for the trailing 12 month period."]
["Earnings Per Share (TTM)"]
["A company's net income for the trailing twelve month period expressed as a dollar amount per fully diluted shares outstanding."]
["Market Capitalization"]
["Reflects the total market value of a company. Market Cap is calculated by multiplying the number of shares outstanding by the stock's price. For companies with multiple common share classes, market capitalization includes both classes."]
["Shares Outstanding"]
["Number of shares that are currently held by investors, including restricted shares owned by the company's officers and insiders as well as those held by the public."]
["Public Float"]
["The number of shares in the hands of public investors and available to trade. To calculate, start with total shares outstanding and subtract the number of restricted shares. Restricted stock typically is that issued to company insiders with limits on when it may be traded."]
["Dividend Yield"]
["A company's dividend expressed as a percentage of its current stock price."]
[]
["Key Stock Data"]
[]
["P/E Ratio (TTM)"]
["18.37 (07/31/18) "]
["EPS (TTM)"]
[10.36]
["Market Cap"]
["$933.43 B"]
["Shares Outstanding"]
["4.92 B"]
["Public Float"]
["4.91 B"]
["Yield"]
["1.53% (07/31/18) "]
["Latest Dividend"]
["$0.73 (05/17/18) "]
["Ex-Dividend Date"]
["2018-05-11"]
[]
["?"]
[]
["Shares Sold Short"]
["The total number of shares of a security that have been sold short and not yet repurchased."]
["Change from Last"]
["Percentage change in short interest from the previous report to the most recent report. Exchanges report short interest twice a month."]
["Percent of Float"]
["Total short positions relative to the number of shares available to trade."]
[]
["Short Interest (07/13/18)"]
[]
["Shares Sold Short"]
["42.85 M"]
["Change from Last"]
[0.12520000000000001]
["Percent of Float"]
[8.6999999999999994E-3]
[]
["?"]
[]
["Money Flow Uptick/Downtick Ratio"]
["Money flow measures the relative buying and selling pressure on a stock, based on the value of trades made on an \"uptick\" in price and the value of trades made on a \"downtick\" in price. The up/down ratio is calculated by dividing the value of uptick trades by the value of downtick trades. Net money flow is the value of uptick trades minus the value of downtick trades. Our calculations are based on comprehensive, delayed quotes."]
[]
["Stock Money Flow"]
[]
["Uptick/Downtick Trade Ratio"]
["0 2 "]
[0.67]
["Net Money Flow ($)"]
["-552.25 M "]
[]
["Money flow gives a snapshot of relative buying and selling pressure in a stock. A ratio above one suggests greater buying pressure, below one suggests greater selling."]
[]
["Advertisement"]
["Competitors AAPL"]
["Company","Change","P/E (TTM)"]
["MSFT",{"$f":"0.67% +0.71","v":0.7167},50.27]
["Microsoft Corp."]
["NOK",{"$f":"-1.82% -0.1","v":-0.1182},"-"]
["Nokia Corp. ADR"]
["IBM",{"$f":"-0.38% -0.56","v":-0.56380000000000008},23.38]
["International Business Machines Corp."]
["HPQ",{"$f":"-0.09% -0.02","v":-2.0900000000000002E-2},8.8800000000000008]
["HP Inc."]
["GOOGL",{"$f":"-0.23% -2.82","v":-2.8222999999999998},53.15]
["Alphabet Inc. Cl A"]
["BB",{"$f":"1.13% +0.11","v":0.12130000000000001},"-"]
["BlackBerry Ltd."]
["More information on AAPL"]
["Competitor Data Provided By: capital cube"]
["Profile AAPL"]
["Apple, Inc. engages in the design, manufacture, and marketing of mobile communication, media devices, personal computers, and portable digital music players. It operates through the following geographical segments: Americas, Europe, Greater China, Japan, and Rest of..."]
[]
["One Apple Park Way"]
["Cupertino California 95014"]
["United States"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2000000000000002,0.63]
["Email"]
["Website",null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3","Q4"]
["Map"]
[]
["Employees 123,000 "]
["Sector Computers/Consumer Electronics "]
["Sales or Revenue 228.57 B "]
["Industry Technology "]
["1Y Sales Change 6.70% "]
["Fiscal Year Ends September 30 Download Reports"]
[]
["Timothy Donald Cook Chief Executive Officer & Director"]
[]
["Jeffrey E. Williams Chief Operating Officer"]
[]
["Luca Maestri Chief Financial Officer, SVP & VP-Human Resources"]
[]
["Kevin M. Lynch Vice President-Technology"]
[]
["More"]
[]
["Research & Ratings Apple Inc.AAPL"]
["Per-Share Earnings, Actuals and Estimates"]
[]
["Quarterly"]
["Annual"]
["AAPL will report FY 2018 earnings on 10/31/2018 AAPL will report Q3 earnings on 07/31/2018 "]
["Actual Analyst Range Consensus"]
["5.00 4.00 3.00 2.00"]
["Actual 1.67","Actual 2.07","Actual 3.89","Actual 2.73",null,2.16,2.65]
[1.57,1.87,3.86,2.68]
["Q32017","Q4","Q12018","Q2",null,"Q3","Q4"]
["20 15 10 5 0"]
["Actual 9.21",11.46,13.16,14.7]
[8.99]
["FY 2017","FY 2018","FY 2019","FY 2020"]
["Q3 2018 Estimate Trends"]
["Current:",2.16]
["1 month ago:",2.16]
["3 months ago:",1.99]
["Q4 2018 Estimate Trends"]
["Current:",2.65]
["1 month ago:",2.65]
["3 months ago:",2.56]
["FY 2018 Estimate Trends"]
["Current:",11.46]
["1 month ago:",11.47]
["3 months ago:",11.16]
["FY 2019 Estimate Trends"]
["Current:",13.16]
["1 month ago:",13.13]
["3 months ago:",12.8]
[]
["More"]
[]
["Financials Apple Inc.AAPL"]
[]
["Quarterly"]
["Annual"]
["Net Income"]
["0 6B 12B 18B 24B"]
[]
["Mar 2017 Jun 2017 Sep 2017 Dec 2017 Mar 2018 "]
["0 20B 40B 60B"]
[]
["'13 '14 '15 '16 '17"]
[null,"2018-03-01","5-quarter trend"]
["Net Income Growth",0.25319999999999998]
[]
["Sales or Revenue","61.22 B"]
["Sales or Revenue Growth",0.16639999999999999]
[]
["EBITDA","+18.74 B"]
[null,"2017","5-year trend"]
["Net Income Growth",5.8299999999999998E-2]
[]
["Sales or Revenue","228.57 B"]
["Sales or Revenue Growth",6.7000000000000004E-2]
[]
["EBITDA","+70.19 B"]
[]
["More"]
[]
["Overview"]
[]
["Notes & Data Providers"]
[]
["Real-time U.S. stock quotes reflect trades reported through Nasdaq only."]
[]
["International stock quotes are delayed as per exchange requirements. Indexes may be real-time or delayed; refer to time stamps on index quote pages for information on delay times."]
[]
["Quote data, except U.S. stocks, provided by SIX Financial Information."]
[]
["Data is provided \"as is\" for informational purposes only and is not intended for trading purposes. SIX Financial Information (a) does not make any express or implied warranties of any kind regarding the data, including, without limitation, any warranty of merchantability or fitness for a particular purpose or use; and (b) shall not be liable for any errors, incompleteness, interruption or delay, action taken in reliance on any data, or for any damages resulting therefrom. Data may be intentionally delayed pursuant to supplier requirements."]
[]
["All of the mutual fund and ETF information contained in this display was supplied by Lipper, A Thomson Reuters Company, subject to the following: Copyright © Thomson Reuters. All rights reserved. Any copying, republication or redistribution of Lipper content, including by caching, framing or similar means, is expressly prohibited without the prior written consent of Lipper. Lipper shall not be liable for any errors or delays in the content, or for any actions taken in reliance thereon."]
[]
["Bond quotes are updated in real-time. Source: Tullett Prebon."]
[]
["Currency quotes are updated in real-time. Source: Tullet Prebon."]
[]
["Fundamental company data and analyst estimates provided by FactSet. Copyright FactSet Research Systems Inc. All rights reserved."]
["Advertisement"]
[]
["Wall Street Journal"]
[]
["Subscribe"]
["Sign In"]
["TOP«"]
[]
["WSJ Membership"]
[]
[]
["WSJ+ Membership Benefits"]
["Digital Subscription"]
["Print Subscription"]
["Print and Digital Subscription"]
["Why Subscribe?"]
["Download WSJ Apps for iOS and Android"]
["Corporate Subscriptions"]
["Professor Journal"]
["Student Journal"]
[]
["Customer Service"]
[]
[]
["Customer Center"]
["Contact Us"]
["Live Help"]
["Redesign Guided Tour"]
["Notice to Subscribers"]
[]
["Tools & Features"]
[]
[]
["Emails & Alerts"]
["Guides"]
["My News"]
["RSS Feeds"]
["Video Center"]
["Watchlist"]
[]
["Ads"]
[]
[]
["Advertise"]
["Advertise Locally"]
["Commercial Real Estate Ads"]
["Place a Classified Ad"]
["Sell Your Business"]
["Sell Your Home"]
["Recruitment & Career Ads"]
[]
["More"]
[]
[]
["Content Partnerships"]
["Corrections"]
["Jobs at WSJ"]
["News Archive"]
["Register for Free"]
["Reprints"]
["Facebook"]
["Twitter"]
["Google+"]
["YouTube"]
["Podcasts"]
["GooglePlay"]
["AppStore"]
["Windows10"]
[]
["Dow Jones Products"]
["Barron's"]
["BigCharts"]
["DJX"]
["Dow Jones Newswires"]
["Factiva"]
["Financial News"]
["Mansion Global"]
["MarketWatch"]
["Private Markets"]
["realtor.com"]
["Risk & Compliance"]
["WSJ Classifieds"]
["WSJ Conference"]
["WSJ Video"]
["WSJ Wine"]
[]
["Privacy Policy"]
["Cookie Policy"]
["Copyright Policy"]
["Data Policy"]
["Subscriber Agreement & Terms of Use"]
["Your Ad Choices"]
["Copyright ©2018 Dow Jones & Company, Inc. All Rights Reserved."]

{"sheet":"CFlow","index":9,"n_rows":476,"n_cols":6,"rows_kept":476,"cut":false,"hidden":true,"merged":[]}
[{"$f":"Analysis!E2","v":"aapl"}]
["Zacks Investment Research"]
[]
["Join"]
["Sign In"]
["Member Sign In"]
["Keep Me Signed In What does \"Remember Me\" do?"]
["Forgot Password"]
["Create a New Account"]
[]
["Home"]
["Stocks Stocks +"]
[]
["Stocks"]
["Zacks #1 Rank"]
["Zacks Rank"]
["Zacks Industry Rank"]
["Zacks Sector Rank"]
["Equity Research"]
["Markets"]
[]
["Funds Funds +"]
[]
["Funds"]
["Mutual Funds"]
["ETFs"]
["Mutual Fund Screener"]
["ETF Screener"]
["Top ETFs"]
[]
["Earnings Earnings +"]
[]
["Earnings"]
["Earnings Calendar"]
["Earnings Releases"]
["Earnings ESP"]
["Earnings ESP Filter"]
[]
["Screening Screening +"]
[]
["Screening"]
["Stock Screener"]
["Mutual Fund Screener"]
["ETF Screener"]
["Premium Screens"]
["Quant Monitor"]
["Research Wizard"]
[]
["Finance Finance +"]
[]
["Personal Finance"]
["Insurance"]
["Investing"]
["Money Managing"]
["Real Estate"]
["Retirement Planning"]
["Tax Information"]
[]
["Portfolio Portfolio +"]
[]
["My Portfolio"]
["Create Portfolio"]
[]
["Education Education +"]
[]
["Education"]
["Stocks"]
["Style Scores"]
["Funds"]
["Earnings ESP"]
["Screening"]
["Video"]
["Testimonial"]
[]
["Services Services +"]
[]
[]
["Services Overview"]
["Zacks Ultimate"]
["Zacks Investor Collection"]
["Zacks Premium"]
[]
[]
[]
[]
["Investor Services"]
["ETF Investor"]
["Home Run Investor"]
["Income Investor"]
["Stocks Under $10"]
["Value Investor"]
["Top 10 Stocks"]
[]
[]
[]
["Other Services"]
["Method for Trading"]
["Research Wizard"]
["Zacks Confidential"]
[]
[]
[]
[]
[]
["Trading Services"]
["Black Box Trader"]
["Counterstrike"]
["Insider Trader"]
["Large-Cap Trader"]
["Momentum Trader"]
["Options Trader"]
["Short List"]
["Surprise Trader"]
["TAZR"]
[]
[]
[]
["Innovators"]
["Blockchain"]
["Healthcare"]
["Technology"]
[]
["Menu"]
[]
["Home"]
["Stocks Stocks +"]
[]
["Stocks"]
["Zacks #1 Rank"]
["Zacks Rank"]
["Zacks Industry Rank"]
["Zacks Sector Rank"]
["Equity Research"]
["Markets"]
[]
["Funds Funds +"]
[]
["Funds"]
["Mutual Funds"]
["ETFs"]
["Mutual Fund Screener"]
["ETF Screener"]
["Top ETFs"]
[]
["Earnings Earnings +"]
[]
["Earnings"]
["Earnings Calendar"]
["Earnings Releases"]
["Earnings ESP"]
["Earnings ESP Filter"]
[]
["Screening Screening +"]
[]
["Screening"]
["Stock Screener"]
["Mutual Fund Screener"]
["ETF Screener"]
["Premium Screens"]
["Quant Monitor"]
["Research Wizard"]
[]
["Finance Finance +"]
[]
["Personal Finance"]
["Insurance"]
["Investing"]
["Money Managing"]
["Real Estate"]
["Retirement Planning"]
["Tax Information"]
[]
["Portfolio Portfolio +"]
[]
["My Portfolio"]
["Create Portfolio"]
[]
["Education Education +"]
[]
["Education"]
["Stocks"]
["Style Scores"]
["Funds"]
["Earnings ESP"]
["Screening"]
["Video"]
["Testimonial"]
[]
["Services Services +"]
[]
[]
["Services Overview"]
["Zacks Ultimate"]
["Zacks Investor Collection"]
["Zacks Premium"]
[]
[]
[]
[]
["Investor Services"]
["ETF Investor"]
["Home Run Investor"]
["Income Investor"]
["Stocks Under $10"]
["Value Investor"]
["Top 10 Stocks"]
[]
[]
[]
["Other Services"]
["Method for Trading"]
["Research Wizard"]
["Zacks Confidential"]
[]
[]
[]
[]
[]
["Trading Services"]
["Black Box Trader"]
["Counterstrike"]
["Insider Trader"]
["Large-Cap Trader"]
["Momentum Trader"]
["Options Trader"]
["Short List"]
["Surprise Trader"]
["TAZR"]
[]
[]
[]
["Innovators"]
["Blockchain"]
["Healthcare"]
["Technology"]
[]
["Join"]
[]
["Sign In"]
[]
["Member Sign In"]
["Keep Me Signed In What does \"Remember Me\" do?"]
["Forgot Password"]
["Create a New Account"]
["Close this window"]
[]
["Help"]
[]
["Zacks Investment Research"]
["You are being directed to ZacksTrade, a division of LBMZ Securities and licensed broker-dealer. ZacksTrade and Zacks.com are separate companies. The web link between the two companies is not a solicitation or offer to invest in a particular security or type of security. ZacksTrade does not endorse or adopt any particular investment strategy, any analyst opinion/rating/report or any approach to evaluating indiv idual securities."]
["If you wish to go to ZacksTrade, click OK. If you do not, click Cancel."]
["OK Cancel"]
["Back to top"]
["more "]
["Financials"]
["Cash flow Statements"]
["close"]
[]
["Quotes & News "]
[]
[]
["Quote Overview"]
["Zacks News "]
["Partner News "]
[]
["Zacks Research "]
[]
[]
["*Snapshot"]
["*Analyst Report"]
["*Style Scores"]
["*Detailed Estimates"]
["Comparison to Industry"]
["Zacks Experts View"]
[]
["More Research "]
[]
[]
["*Broker Recommendations "]
["Full Company Report"]
["Earnings Announcements"]
["Key Company Metrics"]
["Broker Reports "]
["Insiders "]
["Earnings Transcripts"]
[]
["Charts "]
[]
[]
["*Price, Consensus and EPS Surprise"]
["*Fundamental Charts"]
["Comparative"]
["Interactive Charts"]
["Price and Consensus"]
["Price & EPS Surprise"]
["12 Month EPS"]
["Broker Recommendations"]
[]
["Financials "]
[]
[]
["Financial Overview "]
["Income Statements "]
["Balance Sheet "]
["Cash flow Statements"]
[]
["Options "]
[]
[]
["Option Chain"]
["Options Greek Montage"]
[]
["Access Zacks"]
["Data Feed"]
[]
["Apple Inc. (AAPL)"]
["(Real Time Quote from BATS)"]
["$190.29 USD"]
[190.29]
[31320430]
["+0.81 (0.43%)"]
["Updated Jul 31, 2018 03:58 PM ET"]
["After-Market: $195.72 +5.43 (2.85%) 5:00 PM ET"]
["Add to portfolio"]
["Zacks Rank: "]
["2-Buy   2      "]
["Style Scores: "]
["B Value | C Growth | D Momentum | B VGM"]
["The Style Scores are a complementary set of indicators to use alongside the Zacks Rank. It allows the user to better focus on the stocks that are the best fit for his or her personal trading style."]
["The scores are based on the trading styles of Value, Growth, and Momentum. There's also a VGM Score ('V' for Value, 'G' for Growth and 'M' for Momentum), which combines the weighted average of the individual style scores into one score."]
["Value Score","A"]
["Growth Score","A"]
["Momentum Score","A"]
["VGM Score","A"]
["Within each Score, stocks are graded into five groups: A, B, C, D and F. As you might remember from your school days, an A, is better than a B; a B is better than a C; a C is better than a D; and a D is better than an F."]
["As an investor, you want to buy stocks with the highest probability of success. That means you want to buy stocks with a Zacks Rank #1 or #2, Strong Buy or Buy, which also has a Score of an A or a B in your personal trading style."]
["Zacks Style Scores Education - Learn more about the Zacks Style Scores"]
["Industry Rank: "]
["Top 20%(51 out of 255)"]
["Industry: Computer - Mini computers"]
["View All Zacks #1 Ranked Stocks"]
["Trades from $3 "]
["This is our short term rating system that serves as a timeliness indicator for stocks over the next 1 to 3 months. How good is it? See rankings and related performance below."]
["Zacks Rank","Definition","Annualized Return"]
[1,"Strong Buy",0.2571]
[2,"Buy",0.1812]
[3,"Hold",9.9099999999999994E-2]
[4,"Sell",5.4899999999999997E-2]
[5,"Strong Sell",2.29E-2]
["S&P",500,9.7900000000000001E-2]
["Zacks Rank Education - Learn about the Zacks Rank"]
["Zacks Rank Home - Zacks Rank resources in one place"]
["Zacks Premium - The only way to fully access the Zacks Rank"]
["The Zacks Equity Research reports, or ZER for short, are our in-house, independently produced research reports."]
["The ever popular one-page Snapshot reports are generated for virtually every single Zacks Ranked stock. It's packed with all of the company's key stats and salient decision making information. Including the Zacks Rank, Zacks Industry Rank, Style Scores, the Price, Consensus & Surprise chart, graphical estimate analysis and how a stocks stacks up to its peers."]
["The detailed multi-page Analyst report does an even deeper dive on the company's vital statistics. In addition to all of the proprietary analysis in the Snapshot, the report also visually displays the four components of the Zacks Rank (Agreement, Magnitude, Upside and Surprise); provides a comprehensive overview of the company business drivers, complete with earnings and sales charts; a recap of their last earnings report; and a bulleted list of reasons to buy or sell the stock. It also includes an industry comparison table to see how your stock compares to its expanded industry, and the S&P 500."]
["Researching stocks has never been so easy or insightful as with the ZER Analyst and Snapshot reports."]
["Learn more about Zacks Equity Research reports"]
["See more Zacks Equity Research reports"]
["The Zacks Industry Rank assigns a rating to each of the 265 X (Expanded) Industries based on their average Zacks Rank."]
["An industry with a larger percentage of Zacks Rank #1&apos;s and #2&apos;s will have a better average Zacks Rank than one with a larger percentage of Zacks Rank #4&apos;s and #5&apos;s."]
["The industry with the best average Zacks Rank would be considered the top industry (1 out of 265), which would place it in the top 1% of Zacks Ranked Industries. The industry with the worst average Zacks Rank (265 out of 265) would place in the bottom 1%."]
["Zacks Rank Education -- Learn more about the Zacks Rank"]
["Zacks Industry Rank Education -- Learn more about the Zacks Industry Rank"]
["Apple Inc. (AAPL) Quote Overview » Financials » Apple Inc. (AAPL) Cash flow Statements "]
["Cash flow Statements"]
["The Style Scores are a complementary set of indicators to use alongside the Zacks Rank. It allows the user to better focus on the stocks that are the best fit for his or her personal trading style."]
["The scores are based on the trading styles of Value, Growth, and Momentum. There's also a VGM Score ('V' for Value, 'G' for Growth and 'M' for Momentum), which combines the weighted average of the individual style scores into one score."]
["Value Score","A"]
["Growth Score","A"]
["Momentum Score","A"]
["VGM Score","A"]
["Within each Score, stocks are graded into five groups: A, B, C, D and F. As you might remember from your school days, an A, is better than a B; a B is better than a C; a C is better than a D; and a D is better than an F."]
["As an investor, you want to buy stocks with the highest probability of success. That means you want to buy stocks with a Zacks Rank #1 or #2, Strong Buy or Buy, which also has a Score of an A or a B in your personal trading style."]
["Zacks Style Scores Education - Learn more about the Zacks Style Scores"]
["Research for AAPL "]
["   "]
["The Zacks Equity Research reports, or ZER for short, are our in-house, independently produced research reports."]
["The ever popular one-page Snapshot reports are generated for virtually every single Zacks Ranked stock. It's packed with all of the company's key stats and salient decision making information. Including the Zacks Rank, Zacks Industry Rank, Style Scores, the Price, Consensus & Surprise chart, graphical estimate analysis and how a stocks stacks up to its peers."]
["The detailed multi-page Analyst report does an even deeper dive on the company's vital statistics. In addition to all of the proprietary analysis in the Snapshot, the report also visually displays the four components of the Zacks Rank (Agreement, Magnitude, Upside and Surprise); provides a comprehensive overview of the company business drivers, complete with earnings and sales charts; a recap of their last earnings report; and a bulleted list of reasons to buy or sell the stock. It also includes an industry comparison table to see how your stock compares to its expanded industry, and the S&P 500."]
["Researching stocks has never been so easy or insightful as with the ZER Analyst and Snapshot reports."]
["Learn more about Zacks Equity Research reports"]
["See more Zacks Equity Research reports"]
["Annual Cash Flow Statement"]
["Fiscal Year End for Apple Inc. falls in the month of September."]
["All data in Millions except Per Share data."]
["Cash Flow From Operations, Investments & Financial Activities"]
[null,43008,42643,42277,41912,41547]
["Cash Flow From Operations, Investments & Financial"]
["Activities"]
["Net Income (Loss)",48351,45687,53394,39510,37037]
["Depreciation/Amortization & Depletion",10157,10505,11257,7946,6757]
["Net Change from Assets/Liabilities",-5550,484,11647,7047,6478]
["Net Cash from Discontinued Operations",0,0,0,0,0]
["Other Operating Activities",10640,9148,4968,5210,3394]
["Net Cash From Operating Activities",63598,65824,81266,59713,53666]
["Property & Equipment",-12451,-12734,-11247,-9571,-8165]
["Acquisition/ Disposition of Subsidiaries",-329,-297,-343,-3765,-496]
["Investments",-33542,-32022,-44417,-9017,-24042]
["Other Investing Activities",-124,-924,-267,-226,-1071]
["Net Cash from Investing Activities",-46446,-45977,-56274,-22579,-33774]
["Uses of Funds"]
[null,43008,42643,42277,41912,41547]
["Issuance (Repurchase) of Capital Stock",-32345,-29227,-34710,-44270,-22330]
["Issuance (Repayment) of Debt",25162,22454,27114,11960,16896]
["Increase (Decrease) Short-Term Debt",3852,-397,2191,6306,0]
["Payment of Dividends & Other Distributions",-12769,-12150,-11561,-11126,-10564]
["Other Financing Activities",-1247,-1163,-750,-419,-381]
["Net Cash from Financing Activities",-17347,-20483,-17716,-37549,-16379]
["Effect of Exchange Rate Changes",0,0,0,0,0]
["Net Change In Cash & Equivalents",-195,-636,7276,-415,3513]
["Cash at Beginning of Period",20484,21120,13844,14259,10746]
["Cash at End of Period",20289,20484,21120,13844,14259]
["Diluted Net EPS",9.2100000000000009,8.31,9.2200000000000006,6.45,5.68]
["Quick Links"]
["     "]
["Services"]
["Account Types"]
["Premium Services"]
["Zacks Rank"]
["Research"]
["Personal Finance"]
["Commentary"]
["Education"]
["Zacks Advisor Tools"]
["My Account"]
["Manage Account"]
["Update Profile"]
["Subscriptions"]
["Preferences"]
["Login/Password Help"]
["Upgrade to Premium"]
["Resources"]
["Help"]
["About Zacks"]
["Disclosure"]
["Privacy Policy"]
["Terms of Service"]
["Performance"]
["Site Map"]
["Podcasts"]
["Earnings Calendar"]
["Client Support"]
["Contact Us"]
["Share Feedback"]
["Media"]
["Careers"]
["Advertise"]
["Follow Us"]
["Facebook"]
["Twitter"]
["Linkedin"]
["RSS"]
["You Tube"]
["Zacks Moblie App"]
["Apple play store"]
["Get it on Google Play"]
["Zacks Research is Reported On:"]
[]
["Yahoo"]
["MSN"]
["Marketwatch"]
["Nasdaq"]
["Forbes"]
["Investors.com"]
["Morningstar"]
[]
["Zacks Investment Research is an A+ Rated BBB Accredited Business"]
["Copyright 2018 Zacks Investment Research"]
["At the center of everything we do is a strong commitment to independent research and sharing its profitable discoveries with investors. This dedication to giving investors a trading advantage led to the creation of our proven Zacks Rank stock-rating system. Since 1988 it has more than doubled the S&P 500 with an average gain of +25% per year. These returns cover a period from 1988-2017. Zacks Rank stock-rating system returns are computed monthly based on the beginning of the month and end of the month Zacks Rank stock prices plus any dividends received during that particular month. A simple, equally-weighted average return of all Zacks Rank stocks is calculated to determine the monthly return. The monthly returns are then compounded to arrive at the annual return. Only Zacks Rank stocks included in Zacks hypothetical portfolios at the beginning of each month are included in the return calculations. Zack Ranks stocks can, and often do, change throughout the month. Certain Zacks Rank stocks for which no month-end price was available, pricing information was not collected, or for certain other reasons have been excluded from these return calculations."]
["Visit performance for information about the performance numbers displayed above."]
["Visit www.zacksdata.com to get our data and content for your mobile app or website."]
["Real time prices by BATS. Delayed quotes by Sungard."]
["NYSE and AMEX data is at least 20 minutes delayed. NASDAQ data is at least 15 minutes delayed."]
["We use cookies to understand how you use our site and to improve your experience. This includes personalizing content and advertising. To learn more, click here. By continuing to use our site, you accept our use of cookies, revised Privacy Policy and Terms and Conditions of Service."]
["I accept X"]

{"sheet":"G-1","index":10,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[37,0,37,14],[15,6,15,8],[17,0,17,14],[33,6,33,8],[35,0,35,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Return to Analysis Summary "]
[]
["If Receivables is going up, customers aren't paying their bills.  But if Revenue is also going up Receivables will likely go up also--and Inventories as well.  If either goes up faster than Revenues however, that's a danger signal. All three are expected to more or less act in concert.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Expect Sales to increase at or above the growth in Cost of Sales.    Also, if Property, Plant & Equipment (PP&E) is increasing Revenues should also increase.  PP&E might trail Revenues a year or two if the money is being spent on new buildings, etc.--large projects.  Allow for completion time.  "]

{"sheet":"G-1a","index":11,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[15,6,15,8],[34,6,34,8],[17,0,17,13],[18,0,18,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Return to Analysis Summary "]
[]
["Days waiting for payment is an indication of how loose the company is allowing credit terms to customers to become when paying for product purchases.  An upward slope is not desired--unless Sales are also increasing at approximately the same rate. Compare the graphs below, both annual and quarterly, to discern those trends.  The number of days waiting is industry sensitive.  It's wise to compare companies with their competitors to determine how well your company is doing.  "]
["The annual data is a long-term look, which isn't as important as the quarterly data.  On the quarterly graph, compare the number of days waiting in the most recent quarter to the year ago quarter--i.e. compare the right side to the left side of the plotted data.  An increase of 3 or more days is considered a warning sign the company is loosening credit standards and allowing customers to take longer to pay for product.  However, if Sales are increasing at about the same rate (slope on the Sales graph below), a slight upward trend is not considered too serious.  Also, an acquision can cause the days waiting to increase."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Return to Analysis Summary "]

{"sheet":"G-2","index":12,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[17,5,17,8],[14,0,14,6],[15,0,15,14],[19,0,19,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(InventoriesThisYear=0,\"This company has not reported any Inventories\",\"\")","v":""}]
["A ratio showing how many times a company's inventory is sold and replaced each period.  The higher the ratio the better. It indicates quality merchandise & proper pricing."]
[]
[null,null,null,null,null,"Return to Analysis Summary"]
[]
["The graph to the right indicates the number of days waiting for customers to pay for sold merchandise, and how long inventory is sitting on the shelf unsold.  Less than 60 days is good and less than 45 days is suburb.  Look for any change in the upward direction of either or both data, indicating a problem with the product or pricing.   "]

{"sheet":"G-2a","index":13,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,5,16,7],[14,0,14,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Comparing Revenues with Total Assets indicates how well management is utilizing the assets of the company to turn them into sales.  Watch the relationship between the two values.  If Total Assets is growing faster than Revenues it may signal that management is taking on more debt.  Check the debt--see Graph 3a."]
[]
[null,null,null,null,null,"Return to Analysis Summary "]

{"sheet":"G-3","index":14,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[34,8,34,14],[34,2,34,4],[15,0,15,14],[16,0,16,14],[18,5,18,8],[21,8,21,14],[32,0,32,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["If PP&E is increasing markedly it may cause Free Cash Flow to decrease--even to the point of causing it to become negative.  The question to ask is:  What is the company spending it's cash on and will that expenditure likely result in increasing market share and sales?"]
["Also compare PP&E with Capital Expenditures as a Percentage of Sales--see the graphic below."]
[]
[null,null,null,null,null,"Return to Analysis Summary "]
[]
[]
[null,null,null,null,null,null,null,null,"Capital expenditures are generally not meaningful on a quarterly basis as it takes time for those types of expenditures to result in increased sales and profitablility.  Therefore no graphing of quarterly data is shown here."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Cash flow per share should be greater than Capital Expenditures plus Dividends per share.  If Cash Flow is less than capital spending it's a RED FLAG."]

{"sheet":"G-3a","index":15,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,5,19,8],[15,0,15,13],[14,4,14,6],[14,8,14,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Total Interest Coverage is:",null,null,{"$f":"Analysis!F27","v":20.357390968737938},{"$f":"IF(LTDebtThisYEar=0,\"This company has no Long-term Debt\",\"\")","v":"This company has no Long-term Debt"}]
["If Long Term Debt is increasing, what is management doing with the money to increase the growth of the company?  Can the company borrow at a rate less than the Return on Equity?  If not, it's a double whammy to borrow.  If the Total Interest Coverage is less than 5, worry.  If less than 3, consider a sell.  Large Total Interest Coverage numbers don't mean too much.  It's the small number you want to pay attention to.  "]
[]
[]
[]
[null,null,null,null,null,"Return to Analysis Summary "]

{"sheet":"G-4","index":16,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,0,25,6],[21,0,21,6],[22,0,22,6],[23,0,23,6],[24,0,24,6],[15,6,15,8],[17,0,17,6],[20,0,20,6],[18,0,18,6],[17,8,17,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Return to Analysis Summary "]
[]
["Gross Margin is a company's total revenue, minus cost of goods sold divided by the total sales revenue, expressed as a percentage. The gross margin represents the percent of total sales revenue that the company retains after incurring the direct costs associated with producing the goods and services sold by a company. The higher the percentage, the more the company retains on each dollar of sales to service its other costs and obligations.",null,null,null,null,null,null,null,"Quarterly data provides a more timely look at the same data.  Declining Margins are particularly troubling and can be an indicator of future problems.  Compare the Margins of this company with its peers and the market in general.  "]
["It's the relationship between Revenues and the Cost of Revenues.  Stability and an increasing value is an indication of good management--an indication of efficient use of facilities and labor."]
[]
["The operating profit margin shows how successful a company’s management has been in generating income from the operation of its core business.  Net income is the money that's left over after all other expenses have been paid.  It indicates how effectively management runs the company. "]
["     Operating Income / Sales"]
[]
["Net Profit Margin indicates how much profit a company makes on each dollar it generates in Revenues; again, a measurement of management..  "]
[]
["What to look for:  To get a better picture when looking at margins, always compare a company to its peers and industry average.  (The Analysis section of this form shows year over year short term comparisons in the \"Competitors\" area as well as competing companies.)"]

{"sheet":"G-5","index":17,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":true,"merged":[[14,0,14,6],[14,8,14,14],[17,5,17,8],[16,0,16,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Is there sufficient Cash Flow to pay the Dividend if one is paid?  If Cash Flow from Operations drops to a value close to or below the Dividends paid, the Dividend is in danger of being cut. The chart is showing Annual data, which is a broad look at the data.  Quarterly data is not available for comparison.",null,null,null,null,null,null,null,"The Quarterly Gross Margin reveals the profitability of a company.  The numerical value is important if used to compare companies in the same industry only.  The trend, however, is comparable regardless of the industry. A decreasing trend can be a warning of profitability problems at the present, as well as in the future.  Why is it decreasing?  "]
[]
[{"$f":"IF(Data!M55=0,\"No Dividend is currently paid by this company, therefore no comparison can be made.\",\"\")","v":"No Dividend is currently paid by this company, therefore no comparison can be made."}]
[null,null,null,null,null,"Return to Analysis Summary "]

{"sheet":"G-5a","index":18,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[14,0,14,14],[17,6,17,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["How well is management utilizing the assets--turning the assets into sales?  Is there consistency?  Compare the results with other companies to determine if any problem is with the company, industry, or market."]
[]
[]
[null,null,null,null,null,null,"Return to Analysis Summary "]

{"sheet":"G-6","index":19,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,4,37,7],[38,4,38,6],[15,0,15,12],[16,0,16,12],[17,0,17,12],[19,0,19,5],[18,6,18,7],[19,9,19,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Return on Assets (ROA) and Return on Capital (ROC) are arguably better indicators of the profitability of a company, compared to Return on Equity (ROE).  Both ROA and ROC include long term debt in the equation and ROE does not.  Thus, ROA and ROC provide a more true picture.  Debt increases ROE.  How? -- The use of debt lowers equity, and if equity is lowered more than net income, ROE will increase.  On the other hand, ROA and ROC are lowered by debt--the interest expense lowers net income, which lowers ROA and ROC.  "]
["ROE indicates how well the management is doing with the money it has now.  ROA and ROC indicate how well management is likely to do in the future with capital.  "]
["Both ROA and ROC can be used an the Implied Growth Rate--a realistic growth rate expected in the next few years. Normally ROA is a little more conservative as a projected growth rate."]
[]
["Watch the relationship between ROE, ROA and ROC, and debt.",null,null,null,null,null,null,null,null,"Return to Analysis Summary "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Return to Analysis Summary "]

{"sheet":"G-6a","index":20,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,5,18,7],[14,0,14,14],[15,0,15,14],[16,0,16,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The comparison of these two data are very important and revealing."]
["If Cash from Operations is declining or falls faster than Net Cashflow Income, it's a very serious situation.  The company will need to raise capital to stay in business--through borrowing or issuing new shares.  If Net Cash from Operations becomes negative, it means the company is spending it's cash to stay in business. "]
["Look at the Cashflow statement under Operating Activities to see what the company is using it's money for.  Look at Inventories and Receivables; if rising, products may not be properly priced or being returned by customers.  See Graph-1 "]
[]
[null,null,null,null,null,"Return to Analysis Summary "]

{"sheet":"G-7","index":21,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":true,"merged":[[16,5,16,7],[14,0,14,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The higher the number the better, but watch the trend also.  This rating is most useful when compared to other companies, particularly those in the same industry."]
[]
[null,null,null,null,null,"Return to Analysis Summary "]

{"sheet":"G-7a","index":22,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[14,0,14,14],[16,5,16,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The higher the number the better, but watch the trend also.  This rating is most useful when compared to other companies, particularly those in the same industry."]
[]
[null,null,null,null,null,"Return to Analysis Summary "]

{"sheet":"G-8","index":23,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,5,17,7],[15,0,15,6],[15,8,15,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Use extreme caution when Net Income exceeds Operating Cash Flow."]
[]
[null,null,null,null,null,"Return to Analysis Summary "]

{"sheet":"G-9","index":24,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[14,3,14,12],[21,5,21,7],[15,0,15,14],[16,0,16,14],[17,0,17,14],[18,0,19,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"IF(InventoriesThisYear=0,\"This company has no Inventories, therefore Quick Ratio and Current Ratio values are the same\",\"\")","v":""}]
["Current Ratio is also known as the \"Liquidity Ratio\".  \nThe ratio is mainly used to give an idea of the company's ability to pay back its short-term liabilities (debt and payables) with its short-term assets (cash, inventory, receivables). The higher the current ratio, the more capable the company is of paying its obligations. A ratio under 1 suggests that the company would be unable to pay off its obligations if they came due at that point.  If decreasing, the companie's financial position is weakening.\n"]
["Quick Ratio is also known as the \"acid-test ratio\". It is an indicator of a company's short-term liquidity. The quick ratio measures a company's ability to meet its short-term obligations with its most liquid assets. The higher the quick ratio, the better the position of the company."]
["  The quick ratio is more conservative than the current ratio because it excludes inventory from current assets. Inventory is excluded because some companies have difficulty turning their inventory into cash. In the event that short-term obligations need to be paid off immediately, there are situations in which the current ratio would overestimate a company's short-term financial strength.  If decreasing, the companie's financial position is weakening."]
["NOTE:  Ratios are more meaningful if compared to other companies in the same industry."]
[]
[]
[null,null,null,null,null,"Return to Analysis Summary "]