{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Instructions","Analysis","Data","AnnBS","Income","Bond rate","CFlow","G-1","G-1a","G-2","G-2a","G-3","G-3a","G-4","G-5","G-5a","G-6","G-6a","G-7a","G-8","G-9"],"not_rendered":{"charts":34,"images":2,"macros":1,"external_links":0,"defined_names":48,"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],[24,1,24,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],[27,1,27,11],[22,1,22,14],[23,1,23,4],[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.  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.  "]
[]
[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,"How to get Intrinsic Value:    Click on the yellow cell to be taken to the website.  Enter the ticker symbol for your company in the symbol box.  Click on the \"DCF\" icon--both are highlited in green on the example  >>>>"]
[null,"Scroll down to find the \"Fair Value\".  Enter the value on the Analysis spreadsheet."]
[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":93,"n_cols":25,"rows_kept":93,"cut":false,"hidden":false,"merged":[[78,4,78,7],[79,4,79,6],[81,2,81,4],[81,5,81,6],[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],[85,3,85,7],[55,2,55,5],[70,5,70,8],[62,5,62,8],[56,4,56,6],[80,2,80,7],[68,5,68,8],[58,7,58,8],[84,2,84,7],[82,8,82,11],[80,8,80,11],[76,2,76,11],[36,23,36,24],[40,23,40,24],[39,3,39,4],[86,2,86,5],[65,5,65,8],[61,2,61,8],[60,6,60,7],[57,7,57,8],[57,3,57,6],[49,6,49,8],[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],[51,6,51,8],[79,8,79,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],[96,3,96,6],[87,4,87,7],[89,2,89,7],[88,4,88,6],[90,2,90,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],[90,5,90,6],[91,2,91,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,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.51",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,"fb",{"$f":"Data!C74","v":"Facebook, Inc. (FB)"},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":"2020-12-31"},null,{"$f":"IF(ISERROR(S75),\"\",S75)","v":56},"out of ",{"$f":"U75","v":96},{"$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.19090144988442947},{"$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":48.127435584249397},{"$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":"Sales is increasing faster than Accts Receivable"},null,null,null,null,{"$f":"IF(K6=\"Sales is increasing faster than Accts Receivable\",Q6,0)","v":4},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":"Line 1"},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.140274693409907},{"$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":"If Sales are increasing at a similar rate, good"},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":"Sales are growing faster than Inventories"},null,null,null,null,{"$f":"IF(K7=\"Sales are growing faster than Inventories\",Q7,0)","v":4},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":"Line 2"},null,{"$f":"Data!C19","v":61954},"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":false},0,{"$f":"IF(ISERROR(R8),99,\"\")","v":""},4,{"$f":"IF(K8=\"Sales are increasing\",\"Line 3\",\"\")","v":"Line 3"},null,{"$f":"Data!M9","v":11335},"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":0},{"$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":"No Inventory data are reported for this company"},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":9518},"Accounts Receivable prior year"]
[null,null," Inventory Turnover Days this year =",{"$f":"Data!M27","v":{"$error":"#DIV/0!"}},{"$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":""},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":0},"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":""},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":0},"Inventories prior year"]
[3,"Sales or Revenues",null,null,"Change:",{"$f":"IF(OR(X23<=0,COUNT(X22,X23)<2),NA(),(X22/X23)-1)","v":0.21596390228722573},{"$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":1},3,"",3,{"$f":"IF(K12=\"Gross Profit Margin is growing\",\"Line 9\",\"\")","v":"Line 9"},null,{"$f":"Data!M13","v":75670},"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":"OK (Sales growing faster than Accts Receivable)"},null,null,null,null,"2a",{"$f":"IF(F32<0,\"Shares outstanding are decreasing\",\"\")","v":"Shares outstanding are decreasing"},null,null,null,null,{"$f":"IF(K13=\"Shares outstanding are decreasing\",Q13,0)","v":4},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":1},3,"",3,{"$f":"IF(K13=\"Shares outstanding are decreasing\",\"Line 10\",\"\")","v":"Line 10"},null,{"$f":"Data!G22","v":8591},"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":"Sales to Inventories ratio is OK (Sales growing faster than Inventories)"},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":35323},"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":-0.30528052805280526},{"$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":14981},"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!G30),0,Data!G30)","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!F30),0,Data!F30)","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.75678736234181698},{"$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":2886},"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":2906},"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":42735},"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":85965},"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":70697},"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(#REF!),\"\",IF(#REF!>#REF!,\"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":3789},"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":5454},"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":12518},"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":14.13536201469045},{"$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,"Total Bulish factors: ",null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(V6:V24,\"*L*\")","v":13},null,{"$f":"Data!G49","v":10217},"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":19},{"$f":"SUM(Q6:Q27)","v":84},null,null,"",null,null,null,{"$f":"Data!F49","v":15934},"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":953},"Total Interest Paid on Debt "]
[9,"Gross Profit Margin",null,"This year=",{"$f":"ROUND((RevenuesThisYear-CostsThisYear)/RevenuesThisYear,3)","v":0.95599999999999996},"Prior Year=",{"$f":"ROUND((RevenuesLastYear-CostsLastYear)/RevenuesLastYear,3)","v":0.92300000000000004},{"$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":""},null,null,null,null,{"$f":"IF(K31=\"Inventories are increasing\",Q31,0)","v":0},-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":3},"",3,{"$f":"IF(K31=\"Inventories are increasing\",\"Line 2\",\"\")","v":""},null,{"$f":"Data!M64","v":38747},"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":-6.882312456985562E-3},{"$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":"Right Direction (Decreasing)"},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":36314},"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":"A small change of up to about 2% isn't considered too consequencial"},null,null,null,null,{"$f":"IF(F9>F12,\"Inventories are growing faster than sales\",\"\")","v":""},null,null,null,null,{"$f":"IF(K33=\"Inventories are growing faster than sales\",Q33,0)","v":0},-4,null,null,"",null,{"$f":"IF(K33=\"Inventories are growing faster than sales\",\"Line 3\",\"\")","v":""},null,{"$f":"Data!M54","v":1},"Dividends"]
[11,"Operating Cash flow Change",null,null,null,{"$f":"Data!M52","v":-0.39315393047844693},"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!B81","v":373.06},"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!C123/100","v":1.46E-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":""},null,{"$f":"IF(ISERROR(CurrentPrice),\"PRICE IS MISSING.CLICK LINK BELOW TO GET PRICE \",\"\")","v":""}]
[12,"Dividend to Cash from Operations ratio ",null,null,null,{"$f":"Data!N57","v":38747},{"$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,{"$f":"IF(ISERROR(CurrentPrice),\"TYPE PRICE INTO 'THE Price' CELL ABOVE\",\"\")","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.45072994823474671},{"$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":""},null,null,null,null,{"$f":"IF(K39=\"Shares outstanding are increasing\",Q39,0)","v":0},-4,null,null,"",null,{"$f":"IF(K39=\"Shares outstanding are increasing\",\"Line 10\",\"\")","v":""}]
[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.8008143324714387E-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,"See www.Investopedia.com for item definitions"]
[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":1.0689398280802291},{"$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":1.46E-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":0.216},{"$f":"ROUND(F12,3)","v":0.216},{"$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.15727898277427996},"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.23907803907803907},"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":3.7924048155035726},"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,"Total Bearish factors: ",null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(V30:V50,\"*L*\")","v":4}]
[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":0.55955760007830091},{"$f":"IF(OR(X32<=0,COUNT(X31,X32)<2),\"NA\",ROUND((X31/X32-1),2))","v":7.0000000000000007E-2},{"$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":"    Net Cash is growing"},null,null,null,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":21.467082467082466}," 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":1},{"$f":"IF(R57=99,\"\",IF(P57>0,P57*3,0))","v":3},{"$f":"IF(G56=\"    Caution - Net Cash is declining\",0,IF(G56=\"    Net Cash is growing\",1,0))","v":1},{"$f":"IF(T57=99,\"\",IF(R57>0,R57*3,0))","v":3},"",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":5.7543243625911289E-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]
[null,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."]
[null,null,"Quick Ratio:",{"$f":"(TotalCurrentAssets-InventoriesThisYear)/X15","v":5.0510646819304457},"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,""]
[null,null,"Current Ratio ",{"$f":"IF(OR(X15<=0,COUNT(X12,X15)<2),NA(),X12/X15)","v":5.0510646819304457},"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":1},{"$f":"P66*1","v":1},{"$f":"IF(D66>1.999,1)","v":1},{"$f":"R66*1","v":1},"",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,""]
[null,null,"Inventory Turnover Ratio:",{"$f":"IF(X10=0,\"No\",X24/X10)","v":"No"},{"$f":"IF(D69=\"no\",\"inventory\",\"to 1\")","v":"inventory"},"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,""]
[null,null,"Plant Turnover Ratio:",{"$f":"IF(COUNT(X22,X13)<2,NA(),X22/X13)","v":10.00640204865557},"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,""]
[]
[null,null,"Price to Sales Ratio:",{"$f":"IF(OR(X22<=0,COUNT(X34,X22,X18)<3),NA(),X34/(X22/X18))","v":12.524296632350376},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":71},{"$f":"SUM(Q6:Q72)","v":19},{"$f":"SUM(R6:R72)","v":17},56,0,96]
[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$91-F$91<10,\"\",\"Fair Value may be out of date.  Please update the value.\")","v":""},null,null,null,null,null,null,null,null,"Copyright Bob Adams 2021 All Rights Reserved",null,null,null,null,null,null,null,""]
[null,null,"Closing Price",{"$f":"CurrentPrice","v":373.06},"CLICK HERE FOR INTRINSIC VALUE"]
[null,null,"Enter Discounted CF here >>>",590,{"$f":"IF(H80>0,\"Company is selling at a discount of:\",\"Company is over valued\")","v":"Company is selling at a discount of:"},null,null,{"$f":"((D79/D80)-1)/-1","v":0.36769491525423725}]
[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":"Intrinsic Value is up to date"},null,null,"2021-11-13",null,{"$f":"TODAY()","v":"2021-11-13"},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,"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,{"$f":"IF(ISERROR(S90),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":172,"n_cols":15,"rows_kept":172,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"Analysis!E2","v":"fb"}]
[]
[null,"Annual Balance Sheet Data"]
[{"$f":"MATCH(B4,AnnBS!A$200:A$405,0)","v":72},"All items in Millions except Per Share data.",{"$f":"OFFSET(INDEX(AnnBS!$A$200:$O$500,$A4,COLUMN()-COLUMN($A4)),1,0)","v":"2020-12-31"},{"$f":"OFFSET(INDEX(AnnBS!$A$200:$O$500,$A4,COLUMN()-COLUMN($A4)),1,0)","v":"2019-12-31"},{"$f":"OFFSET(INDEX(AnnBS!$A$200:$O$500,$A4,COLUMN()-COLUMN($A4)),1,0)","v":"2018-12-31"},{"$f":"OFFSET(INDEX(AnnBS!$A$200:$O$500,$A4,COLUMN()-COLUMN($A4)),1,0)","v":"2017-12-31"},{"$f":"OFFSET(INDEX(AnnBS!$A$200:$O$500,$A4,COLUMN()-COLUMN($A4)),1,0)","v":"2016-12-31"},null,{"$f":"G4","v":"2016-12-31"},{"$f":"F4","v":"2017-12-31"},{"$f":"E4","v":"2018-12-31"},{"$f":"D4","v":"2019-12-31"},{"$f":"C4","v":"2020-12-31"}]
[{"$f":"MATCH(B5,AnnBS!A$200:A$405,0)","v":72},"All items in Millions except Per Share data.",{"$f":"OFFSET(INDEX(AnnBS!$A$200:$O$500,$A5,COLUMN()-COLUMN($A5)),1,0)","v":"2020-12-31"},{"$f":"OFFSET(INDEX(AnnBS!$A$200:$O$500,$A5,COLUMN()-COLUMN($A5)),1,0)","v":"2019-12-31"},{"$f":"OFFSET(INDEX(AnnBS!$A$200:$O$500,$A5,COLUMN()-COLUMN($A5)),1,0)","v":"2018-12-31"},{"$f":"OFFSET(INDEX(AnnBS!$A$200:$O$500,$A5,COLUMN()-COLUMN($A5)),1,0)","v":"2017-12-31"},{"$f":"OFFSET(INDEX(AnnBS!$A$200:$O$500,$A5,COLUMN()-COLUMN($A5)),1,0)","v":"2016-12-31"}]
[]
[{"$f":"MATCH(B7,AnnBS!A$200:A$405,0)","v":75},"Cash & Equivalents",{"$f":"INDEX(AnnBS!$A$200:$O$500,$A7,COLUMN()-COLUMN($A7))","v":61954},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A7,COLUMN()-COLUMN($A7))","v":54855},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A7,COLUMN()-COLUMN($A7))","v":41114},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A7,COLUMN()-COLUMN($A7))","v":41711},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A7,COLUMN()-COLUMN($A7))","v":29449},null,{"$f":"G7","v":29449},{"$f":"F7","v":41711},{"$f":"E7","v":41114},{"$f":"D7","v":54855},{"$f":"C7","v":61954},"Annual data"]
[{"$f":"MATCH(B8,AnnBS!A$200:A$415,0)","v":{"$error":"#N/A"}},"  Marketable Securities",{"$f":"INDEX(AnnBS!$A$200:$O$500,$A8,COLUMN()-COLUMN($A8))","v":{"$error":"#N/A"}},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A8,COLUMN()-COLUMN($A8))","v":{"$error":"#N/A"}},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A8,COLUMN()-COLUMN($A8))","v":{"$error":"#N/A"}},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A8,COLUMN()-COLUMN($A8))","v":{"$error":"#N/A"}},{"$f":"INDEX(AnnBS!$A$200:$O$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$405,0)","v":76},"Receivables",{"$f":"INDEX(AnnBS!$A$200:$O$500,$A9,COLUMN()-COLUMN($A9))","v":11335},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A9,COLUMN()-COLUMN($A9))","v":9518},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A9,COLUMN()-COLUMN($A9))","v":7587},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A9,COLUMN()-COLUMN($A9))","v":5832},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A9,COLUMN()-COLUMN($A9))","v":3993},null,{"$f":"G9","v":3993},{"$f":"F9","v":5832},{"$f":"E9","v":7587},{"$f":"D9","v":9518},{"$f":"C9","v":11335},"Annual data"]
[{"$f":"MATCH(B10,AnnBS!A$200:A$405,0)","v":78},"Inventories",{"$f":"INDEX(AnnBS!$A$200:$O$500,$A10,COLUMN()-COLUMN($A10))","v":0},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A10,COLUMN()-COLUMN($A10))","v":0},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A10,COLUMN()-COLUMN($A10))","v":0},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A10,COLUMN()-COLUMN($A10))","v":0},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A10,COLUMN()-COLUMN($A10))","v":0},null,{"$f":"G10","v":0},{"$f":"F10","v":0},{"$f":"E10","v":0},{"$f":"D10","v":0},{"$f":"C10","v":0},"Annual data"]
[null,null,null,null,null,null,null,null,{"$f":"IF(I10<0,-I10,I10)","v":0},{"$f":"IF(J10<0,-J10,J10)","v":0},0,0,0,"Convert Inventories"]
[]
[{"$f":"MATCH(B13,AnnBS!A$200:A$415,0)","v":80},"Total Current Assets",{"$f":"INDEX(AnnBS!$A$200:$O$500,$A13,COLUMN()-COLUMN($A13))","v":75670},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A13,COLUMN()-COLUMN($A13))","v":66225},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A13,COLUMN()-COLUMN($A13))","v":50480},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A13,COLUMN()-COLUMN($A13))","v":48563},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A13,COLUMN()-COLUMN($A13))","v":34401},null,{"$f":"G13","v":34401},{"$f":"F13","v":48563},{"$f":"E13","v":50480},{"$f":"D13","v":66225},{"$f":"C13","v":75670},"Annual data"]
[{"$f":"MATCH(B14,AnnBS!A$200:A$415,0)","v":87},"Total Assets",{"$f":"INDEX(AnnBS!$A$200:$O$500,$A14,COLUMN()-COLUMN($A14))","v":159316},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A14,COLUMN()-COLUMN($A14))","v":133376},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A14,COLUMN()-COLUMN($A14))","v":97334},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A14,COLUMN()-COLUMN($A14))","v":84524},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A14,COLUMN()-COLUMN($A14))","v":64961},null,{"$f":"G14","v":64961},{"$f":"F14","v":84524},{"$f":"E14","v":97334},{"$f":"D14","v":133376},{"$f":"C14","v":159316}]
[null,"Company Name from Zacks Ann Balance Sheet",{"$f":"AnnBS!J325","v":"Cash & Equivalents"},null,null,null,{"$f":"IF(SUM(G9:G14)=0,\"Data missing\",\"\")","v":""},null,{"$f":"IF(ISERROR(I13),I14,I13)","v":34401},{"$f":"IF(ISERROR(J13),J14,J13)","v":48563},{"$f":"IF(ISERROR(K13),K14,K13)","v":50480},{"$f":"IF(ISERROR(L13),L14,L13)","v":66225},{"$f":"IF(ISERROR(M13),M14,M13)","v":75670},"if error(line 7, use line 8"]
[null,null,null,null,null,null,null,null,{"$f":"I9*365/G40","v":52.733374339677255},{"$f":"J9*365/F40","v":52.362187292450741},{"$f":"K9*365/E40","v":49.594451807013144},{"$f":"L9*365/D40","v":49.140274693409907},{"$f":"M9*365/C40","v":48.127435584249405},"Days waiting for payment--Receivables"]
[null,"Period Ending:",{"$f":"C4","v":"2020-12-31"}]
[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.30114992072166369},{"$f":"K14/J14-1","v":0.15155458804599875},{"$f":"L14/K14-1","v":0.37029198430147736},{"$f":"M14/L14-1","v":0.19448776391554712},"Total Assets % change"]
[null,{"$f":"IF(C19=\"na\",\"Last year Balance Sheet data has not yet reported.\",\"\")","v":""},{"$f":"M7","v":61954},"(Warning if some data missing)",null,null,null,null,{"$f":"I49/I14","v":0.15727898277427996},{"$f":"J49/J14","v":0.18851450475604561},{"$f":"K49/K14","v":0.2271765261881768},{"$f":"L49/L14","v":0.13859315019193857},{"$f":"M49/M14","v":0.18294458811418815},"ROA"]
[null,"Do not remove lines 18 & 19 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.17260195290063182},{"$f":"J49/J35","v":0.21431934039033182},{"$f":"K49/K35","v":0.26284070512439528},{"$f":"L49/L35","v":0.18292200209788825},{"$f":"M49/M35","v":0.22718840127835374},"Return on Equity ROE"]
[{"$f":"MATCH(B22,AnnBS!A$200:A$415,0)","v":81},"Net Property & Equipment",{"$f":"INDEX(AnnBS!$A$200:$O$500,$A22,COLUMN()-COLUMN($A22))","v":45633},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A22,COLUMN()-COLUMN($A22))","v":35323},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A22,COLUMN()-COLUMN($A22))","v":24683},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A22,COLUMN()-COLUMN($A22))","v":13721},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A22,COLUMN()-COLUMN($A22))","v":8591},null,{"$f":"G22","v":8591},{"$f":"F22","v":13721},{"$f":"E22","v":24683},{"$f":"D22","v":35323},{"$f":"C22","v":45633}]
[{"$f":"MATCH(B23,AnnBS!A$200:A$415,0)","v":87},"Total Assets",{"$f":"INDEX(AnnBS!$A$200:$O$500,$A23,COLUMN()-COLUMN($A23))","v":159316},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A23,COLUMN()-COLUMN($A23))","v":133376},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A23,COLUMN()-COLUMN($A23))","v":97334},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A23,COLUMN()-COLUMN($A23))","v":84524},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A23,COLUMN()-COLUMN($A23))","v":64961},null,{"$f":"G23","v":64961},{"$f":"F23","v":84524},{"$f":"E23","v":97334},{"$f":"D23","v":133376},{"$f":"C23","v":159316}]
[{"$f":"MATCH(B24,AnnBS!A$200:A$415,0)","v":90},"Accounts Payable",{"$f":"INDEX(AnnBS!$A$200:$O$500,$A24,COLUMN()-COLUMN($A24))","v":1331},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A24,COLUMN()-COLUMN($A24))","v":1363},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A24,COLUMN()-COLUMN($A24))","v":820},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A24,COLUMN()-COLUMN($A24))","v":380},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A24,COLUMN()-COLUMN($A24))","v":302},null,{"$f":"G24","v":302},{"$f":"F24","v":380},{"$f":"E24","v":820},{"$f":"D24","v":1363},{"$f":"C24","v":1331}]
[{"$f":"MATCH(B25,AnnBS!A$200:A$415,0)","v":96},"Total Current Liabilities",{"$f":"INDEX(AnnBS!$A$200:$O$500,$A25,COLUMN()-COLUMN($A25))","v":14981},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A25,COLUMN()-COLUMN($A25))","v":15053},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A25,COLUMN()-COLUMN($A25))","v":7017},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A25,COLUMN()-COLUMN($A25))","v":3760},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A25,COLUMN()-COLUMN($A25))","v":2875},null,{"$f":"G25","v":2875},{"$f":"F25","v":3760},{"$f":"E25","v":7017},{"$f":"D25","v":15053},{"$f":"C25","v":14981}]
[{"$f":"MATCH(B26,AnnBS!A$200:A$415,0)","v":104},"Total Liabilities",{"$f":"INDEX(AnnBS!$A$200:$O$500,$A26,COLUMN()-COLUMN($A26))","v":31026},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A26,COLUMN()-COLUMN($A26))","v":32322},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A26,COLUMN()-COLUMN($A26))","v":13207},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A26,COLUMN()-COLUMN($A26))","v":10177},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A26,COLUMN()-COLUMN($A26))","v":5767},null,{"$f":"G26","v":5767},{"$f":"F26","v":10177},{"$f":"E26","v":13207},{"$f":"D26","v":32322},{"$f":"C26","v":31026},"Total Liabilities"]
[null,null,null,null,null,null,null,null,{"$f":"I40/I10","v":{"$error":"#DIV/0!"}},{"$f":"J40/J10","v":{"$error":"#DIV/0!"}},{"$f":"K40/K10","v":{"$error":"#DIV/0!"}},{"$f":"L40/L10","v":{"$error":"#DIV/0!"}},{"$f":"M40/M10","v":{"$error":"#DIV/0!"}},"Inventory turnover Ratio"]
[{"$f":"MATCH(B28,AnnBS!A$200:A$415,0)","v":105},"Shareholders Equity",{"$f":"INDEX(AnnBS!$A$200:$O$500,$A28,COLUMN()-COLUMN($A28))","v":44196},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A28,COLUMN()-COLUMN($A28))","v":43830},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A28,COLUMN()-COLUMN($A28))","v":43465},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A28,COLUMN()-COLUMN($A28))","v":43100},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A28,COLUMN()-COLUMN($A28))","v":42735},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},"Debt to Equity"]
[{"$f":"MATCH(B30,AnnBS!A$200:A$415,0)","v":100},"Long-Term Debt",{"$f":"INDEX(AnnBS!$A$200:$O$500,$A30,COLUMN()-COLUMN($A30))","v":0},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A30,COLUMN()-COLUMN($A30))","v":0},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A30,COLUMN()-COLUMN($A30))","v":0},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A30,COLUMN()-COLUMN($A30))","v":0},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A30,COLUMN()-COLUMN($A30))","v":0},null,{"$f":"G30","v":0},{"$f":"F30","v":0},{"$f":"E30","v":0},{"$f":"D30","v":0},{"$f":"C30","v":0},"LT Debt"]
[null,null,null,null,null,null,null,null,{"$f":"I68/I39","v":-0.16249366813807078},{"$f":"J68/J39","v":-0.16562123336531129},{"$f":"K68/K39","v":-0.24920305168523227},{"$f":"L68/L39","v":-0.21361585357228738},{"$f":"M68/M39","v":-0.17582737160472287},"Cap expenditures as % of Sales"]
[{"$f":"MATCH(B32,AnnBS!A$200:A$415,0)","v":115},"Shares Outstanding",{"$f":"INDEX(AnnBS!$A$200:$O$500,$A32,COLUMN()-COLUMN($A32))","v":2847.6},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A32,COLUMN()-COLUMN($A32))","v":2852},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A32,COLUMN()-COLUMN($A32))","v":2854},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A32,COLUMN()-COLUMN($A32))","v":2906},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A32,COLUMN()-COLUMN($A32))","v":2886},null,{"$f":"G32","v":2886},{"$f":"F32","v":2906},{"$f":"E32","v":2854},{"$f":"D32","v":2852},{"$f":"C32","v":2847.6},"Shares"]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I13),I14/I35,I13/I25)","v":11.965565217391305},{"$f":"IF(ISERROR(J13),J14/J35,J13/J25)","v":12.915691489361702},{"$f":"IF(ISERROR(K13),K14/K35,K13/K25)","v":7.1939575317087074},{"$f":"IF(ISERROR(L13),L14/L35,L13/L25)","v":4.3994552580880883},{"$f":"IF(ISERROR(M13),M14/M35,M13/M25)","v":5.0510646819304457},"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$415,0)","v":112},"Total Shareholder's Equity",{"$f":"INDEX(AnnBS!$A$200:$O$500,$A35,COLUMN()-COLUMN($A35))","v":128290},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A35,COLUMN()-COLUMN($A35))","v":101054},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A35,COLUMN()-COLUMN($A35))","v":84127},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A35,COLUMN()-COLUMN($A35))","v":74347},{"$f":"INDEX(AnnBS!$A$200:$O$500,$A35,COLUMN()-COLUMN($A35))","v":59194},null,{"$f":"G35","v":59194},{"$f":"F35","v":74347},{"$f":"E35","v":84127},{"$f":"D35","v":101054},{"$f":"C35","v":128290}]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I13),(I15-I10)/I35,(I13-I10)/I25)","v":11.965565217391305},{"$f":"IF(ISERROR(J13),(J15-J10)/J35,(J13-J10)/J25)","v":12.915691489361702},{"$f":"IF(ISERROR(K13),(K15-K10)/K35,(K13-K10)/K25)","v":7.1939575317087074},{"$f":"IF(ISERROR(L13),(L15-L10)/L35,(L13-L10)/L25)","v":4.3994552580880883},{"$f":"IF(ISERROR(M13),(M15-M10)/M35,(M13-M10)/M25)","v":5.0510646819304457},"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.17260195290063182},{"$f":"J49/(J35+J29)","v":0.21431934039033182},{"$f":"K49/(K35+K29)","v":0.26284070512439528},{"$f":"L49/(L35+L29)","v":0.18292200209788825},{"$f":"M49/(M35+M29)","v":0.22718840127835374},"ROC = Net Profit/(LT Debt+Equity)"]
[null,"Annual Income Statement",null,null,null,null,null,null,{"$f":"G40","v":27638},{"$f":"F40","v":40653},{"$f":"E40","v":55838},{"$f":"D40","v":70697},{"$f":"C40","v":85965},"Revenues"]
[{"$f":"MATCH(B40,Income!A$200:A$411,0)","v":74},"Sales",{"$f":"INDEX(Income!$A$200:$AA$500,$A40,COLUMN()-COLUMN($A40))","v":85965},{"$f":"INDEX(Income!$A$200:$AA$500,$A40,COLUMN()-COLUMN($A40))","v":70697},{"$f":"INDEX(Income!$A$200:$AA$500,$A40,COLUMN()-COLUMN($A40))","v":55838},{"$f":"INDEX(Income!$A$200:$AA$500,$A40,COLUMN()-COLUMN($A40))","v":40653},{"$f":"INDEX(Income!$A$200:$AA$500,$A40,COLUMN()-COLUMN($A40))","v":27638},null,{"$f":"I39/5","v":5527.6},{"$f":"J39/5","v":8130.6},11167.6,14139.4,17193,"divided by 5"]
[null,null,null,null,null,null,null,null,null,{"$f":"J40/I40-1","v":0.47090961719371882},{"$f":"K40/J40-1","v":0.37352716896661997},{"$f":"L40/K40-1","v":0.26610910132884413},{"$f":"M40/L40-1","v":0.21596390228722573},"Revenue % change"]
[{"$f":"MATCH(B42,Income!A$200:A$411,0)","v":75},"Cost Of Goods",{"$f":"INDEX(Income!$A$200:$AA$500,$A42,COLUMN()-COLUMN($A42))","v":16692},{"$f":"INDEX(Income!$A$200:$AA$500,$A42,COLUMN()-COLUMN($A42))","v":12770},{"$f":"INDEX(Income!$A$200:$AA$500,$A42,COLUMN()-COLUMN($A42))","v":9355},{"$f":"INDEX(Income!$A$200:$AA$500,$A42,COLUMN()-COLUMN($A42))","v":5454},{"$f":"INDEX(Income!$A$200:$AA$500,$A42,COLUMN()-COLUMN($A42))","v":3789},null,{"$f":"G42","v":3789},{"$f":"F42","v":5454},{"$f":"E42","v":9355},{"$f":"D42","v":12770},{"$f":"C42","v":16692}]
[]
[]
[{"$f":"MATCH(B45,Income!A$200:A$411,0)","v":91},"Depreciation & Amortization (Cash Flow)",{"$f":"INDEX(Income!$A$200:$AA$500,$A45,COLUMN()-COLUMN($A45))","v":6862},{"$f":"INDEX(Income!$A$200:$AA$500,$A45,COLUMN()-COLUMN($A45))","v":5741},{"$f":"INDEX(Income!$A$200:$AA$500,$A45,COLUMN()-COLUMN($A45))","v":4315},{"$f":"INDEX(Income!$A$200:$AA$500,$A45,COLUMN()-COLUMN($A45))","v":3025},{"$f":"INDEX(Income!$A$200:$AA$500,$A45,COLUMN()-COLUMN($A45))","v":2342}]
[null,null,null,null,null,null,null,null,{"$f":"(I39-I42)/I39","v":0.86290614371517471},{"$f":"(J39-J42)/J39","v":0.86584015939783043},{"$f":"(K39-K42)/K39","v":0.8324617643898421},{"$f":"(L39-L42)/L39","v":0.81936998741106415},{"$f":"(M39-M42)/M39","v":0.80582795323678236},"Gross Margin--Annual"]
[{"$f":"MATCH(B47,Income!A$200:A$411,0)","v":78},"Income After Depreciation & Amortization",{"$f":"INDEX(Income!$A$200:$AA$500,$A47,COLUMN()-COLUMN($A47))","v":32671},{"$f":"INDEX(Income!$A$200:$AA$500,$A47,COLUMN()-COLUMN($A47))","v":23986},{"$f":"INDEX(Income!$A$200:$AA$500,$A47,COLUMN()-COLUMN($A47))","v":24913},{"$f":"INDEX(Income!$A$200:$AA$500,$A47,COLUMN()-COLUMN($A47))","v":20203},{"$f":"INDEX(Income!$A$200:$AA$500,$A47,COLUMN()-COLUMN($A47))","v":12427},null,{"$f":"G47","v":12427},{"$f":"F47","v":20203},{"$f":"E47","v":24913},{"$f":"D47","v":23986},{"$f":"C47","v":32671},"(Revenue-COGS)/Revenue "]
[{"$f":"MATCH(B48,Income!A$200:A$411,0)","v":81},"Pretax Income",{"$f":"INDEX(Income!$A$200:$AA$500,$A48,COLUMN()-COLUMN($A48))","v":33180},{"$f":"INDEX(Income!$A$200:$AA$500,$A48,COLUMN()-COLUMN($A48))","v":24812},{"$f":"INDEX(Income!$A$200:$AA$500,$A48,COLUMN()-COLUMN($A48))","v":25361},{"$f":"INDEX(Income!$A$200:$AA$500,$A48,COLUMN()-COLUMN($A48))","v":20594},{"$f":"INDEX(Income!$A$200:$AA$500,$A48,COLUMN()-COLUMN($A48))","v":12518},null,{"$f":"I47/I39","v":0.44963456111151312},{"$f":"J47/J39","v":0.49696209381841439},{"$f":"K47/K39","v":0.44616569361366809},{"$f":"L47/L39","v":0.33927889443682191},{"$f":"M47/M39","v":0.3800500203571221},"Operating Margin"]
[{"$f":"MATCH(B49,Income!A$200:A$411,0)","v":88},"Net Income",{"$f":"INDEX(Income!$A$200:$AA$500,$A49,COLUMN()-COLUMN($A49))","v":29146},{"$f":"INDEX(Income!$A$200:$AA$500,$A49,COLUMN()-COLUMN($A49))","v":18485},{"$f":"INDEX(Income!$A$200:$AA$500,$A49,COLUMN()-COLUMN($A49))","v":22112},{"$f":"INDEX(Income!$A$200:$AA$500,$A49,COLUMN()-COLUMN($A49))","v":15934},{"$f":"INDEX(Income!$A$200:$AA$500,$A49,COLUMN()-COLUMN($A49))","v":10217},null,{"$f":"G49","v":10217},{"$f":"F49","v":15934},{"$f":"E49","v":22112},{"$f":"D49","v":18485},{"$f":"C49","v":29146},"(Operating Income/Revenue"]
[null,null,null,null,null,null,null,null,{"$f":"I49/I39","v":0.36967219046240685},{"$f":"J49/J39","v":0.39195139350109465},{"$f":"K49/K39","v":0.39600272216053584},{"$f":"L49/L39","v":0.26146795479298979},{"$f":"M49/M39","v":0.3390449601582039},"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":-0.39315393047844693},"Operating Cash Flow annual change"]
[null,null,null,null,null,null,null,null,{"$f":"I54/I32","v":3.465003465003465E-4},{"$f":"J54/J32","v":3.4411562284927734E-4},3.5038542396636298E-4,3.5063113604488078E-4,3.5117291754459897E-4,"Dividend per share"]
[null,null,null,null,null,null,null,null,{"$f":"1-G68","v":1},{"$f":"1-F68","v":1},{"$f":"1-E68","v":1},{"$f":"1-D68","v":1},{"$f":"1-C68","v":1},"Total Dividend"]
[{"$f":"MATCH(B55,Income!A$200:A$411,0)","v":80},"Interest Expense",{"$f":"INDEX(Income!$A$200:$AA$500,$A55,COLUMN()-COLUMN($A55))","v":0},{"$f":"INDEX(Income!$A$228:$AA$528,$A55,COLUMN()-COLUMN($A55))","v":2006},{"$f":"INDEX(Income!$A$228:$AA$528,$A55,COLUMN()-COLUMN($A55))","v":1835},{"$f":"INDEX(Income!$A$228:$AA$528,$A55,COLUMN()-COLUMN($A55))","v":287},{"$f":"INDEX(Income!$A$228:$AA$528,$A55,COLUMN()-COLUMN($A55))","v":953}]
[null,"Convert from negative number",{"$f":"IF(C55<0,-C55,C55)","v":0},{"$f":"IF(D55<0,-D55,D55)","v":2006},1835,287,953,null,{"$f":"IF(I53=\"--\",\"\",I53+I69)","v":-1.5557865557865558},{"$f":"IF(J53=\"--\",\"\",J53+J69)","v":-2.3165863730213352},{"$f":"IF(K53=\"--\",\"\",K53+K69)","v":-4.8752627890679747},{"$f":"IF(L53=\"--\",\"\",L53+L69)","v":-5.2948807854137447},{"$f":"IF(M53=\"--\",\"\",M53+M69)","v":-5.3076274757690687},"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":38747},"Div to Cash from Operations"]
[{"$f":"MATCH(B58,Income!A$200:A$411,0)","v":96},"Diluted Net EPS",{"$f":"INDEX(Income!$A$200:$AA$500,$A58,COLUMN()-COLUMN($A58))","v":10.09},{"$f":"INDEX(Income!$A$200:$AA$500,$A58,COLUMN()-COLUMN($A58))","v":6.43},{"$f":"INDEX(Income!$A$200:$AA$500,$A58,COLUMN()-COLUMN($A58))","v":7.57},{"$f":"INDEX(Income!$A$200:$AA$500,$A58,COLUMN()-COLUMN($A58))","v":5.39},{"$f":"INDEX(Income!$A$200:$AA$500,$A58,COLUMN()-COLUMN($A58))","v":3.49},null,{"$f":"(C58/D58)-1","v":0.56920684292379486},{"$f":"(D58/E58)-1","v":-0.1505944517833554},{"$f":"(E58/F58)-1","v":0.40445269016697605},{"$f":"(F58/G58)-1","v":0.54441260744985653},null,{"$f":"AVERAGE(I58:L58)","v":0.34186942218931804},"Avg. EPS growth"]
[{"$f":"MATCH(B59,Income!A$200:A$411,0)","v":82},"Income Taxes",{"$f":"INDEX(Income!$A$200:$AA$500,$A59,COLUMN()-COLUMN($A59))","v":4034},{"$f":"INDEX(Income!$A$200:$AA$500,$A59,COLUMN()-COLUMN($A59))","v":6327},{"$f":"INDEX(Income!$A$200:$AA$500,$A59,COLUMN()-COLUMN($A59))","v":3249},{"$f":"INDEX(Income!$A$200:$AA$500,$A59,COLUMN()-COLUMN($A59))","v":4660},{"$f":"INDEX(Income!$A$200:$AA$500,$A59,COLUMN()-COLUMN($A59))","v":2301}]
[{"$f":"MATCH(B60,Income!A$200:A$411,0)","v":75},"Cost of Goods",{"$f":"INDEX(Income!$A$200:$AA$500,$A60,COLUMN()-COLUMN($A60))","v":16692},{"$f":"INDEX(Income!$A$200:$AA$500,$A60,COLUMN()-COLUMN($A60))","v":12770},{"$f":"INDEX(Income!$A$200:$AA$500,$A60,COLUMN()-COLUMN($A60))","v":9355},{"$f":"INDEX(Income!$A$200:$AA$500,$A60,COLUMN()-COLUMN($A60))","v":5454},{"$f":"INDEX(Income!$A$200:$AA$500,$A60,COLUMN()-COLUMN($A60))","v":3789},null,null,null,null,null,null,{"$f":"C71*C32/C40","v":0.45072994823474671},"Free Cahflow Margin"]
[null,null,null,null,null,null,null,null,{"$f":"I64/I49","v":1.5765880395419398},{"$f":"J64/J49","v":1.5197690473201959},{"$f":"K64/K49","v":1.3238965267727931},{"$f":"IF(L64=\"--\",\"N/A\",L64/L49)","v":1.9645117662969975},{"$f":"IF(M64=\"--\",\"N/A\",M64/M49)","v":1.3294105537638097},"Earnings Confidence Rating"]
[null,"Cashflow",null,null,null,null,null,null,null,null,null,null,{"$f":"(M49-M70)/AVERAGE(L14:M14)","v":-0.16888059803479424},"Quality of Earnings Ratio"]
[{"$f":"MATCH(B63,CFlow!A$200:A$350,0)","v":73},"Net Income (Loss)",{"$f":"INDEX(CFlow!$A$200:$M$500,$A63,COLUMN()-COLUMN($A63))","v":29146},{"$f":"INDEX(CFlow!$A$200:$M$500,$A63,COLUMN()-COLUMN($A63))","v":18485},{"$f":"INDEX(CFlow!$A$200:$M$500,$A63,COLUMN()-COLUMN($A63))","v":22112},{"$f":"INDEX(CFlow!$A$200:$M$500,$A63,COLUMN()-COLUMN($A63))","v":15934},{"$f":"INDEX(CFlow!$A$200:$M$500,$A63,COLUMN()-COLUMN($A63))","v":10217},null,{"$f":"G63","v":10217},{"$f":"F63","v":15934},{"$f":"E63","v":22112},{"$f":"D63","v":18485},{"$f":"C63","v":29146}]
[{"$f":"MATCH(B64,CFlow!A$200:A$350,0)","v":78},"Net Cash From Operating Activities",{"$f":"INDEX(CFlow!$A$200:$M$500,$A64,COLUMN()-COLUMN($A64))","v":38747},{"$f":"INDEX(CFlow!$A$200:$M$500,$A64,COLUMN()-COLUMN($A64))","v":36314},{"$f":"INDEX(CFlow!$A$200:$M$500,$A64,COLUMN()-COLUMN($A64))","v":29274},{"$f":"INDEX(CFlow!$A$200:$M$500,$A64,COLUMN()-COLUMN($A64))","v":24216},{"$f":"INDEX(CFlow!$A$200:$M$500,$A64,COLUMN()-COLUMN($A64))","v":16108},null,{"$f":"G64","v":16108},{"$f":"F64","v":24216},{"$f":"E64","v":29274},{"$f":"D64","v":36314},{"$f":"C64","v":38747},"Cash from Operations"]
[null,null,null,null,null,null,null,null,{"$f":"C64/C32","v":13.606897036100577},{"$f":"D64/D32","v":12.732819074333801},10.25718290119131,8.3331039229181005,5.5814275814275813,"Annual Free Cash Flow/share"]
[{"$f":"MATCH(B66,CFlow!A$200:A$350,0)","v":79},"Property & Equipment",{"$f":"INDEX(CFlow!$A$200:$M$500,$A66,COLUMN()-COLUMN($A66))","v":-15115},{"$f":"INDEX(CFlow!$A$200:$M$500,$A66,COLUMN()-COLUMN($A66))","v":-15102},{"$f":"INDEX(CFlow!$A$200:$M$500,$A66,COLUMN()-COLUMN($A66))","v":-13915},{"$f":"INDEX(CFlow!$A$200:$M$500,$A66,COLUMN()-COLUMN($A66))","v":-6733},{"$f":"INDEX(CFlow!$A$200:$M$500,$A66,COLUMN()-COLUMN($A66))","v":-4491},null,{"$f":"1-G66","v":4492},{"$f":"1-F66","v":6734},{"$f":"1-E66","v":13916},{"$f":"1-D66","v":15103},{"$f":"1-C66","v":15116},"Property & Equipment"]
[{"$f":"MATCH(B67,CFlow!A$200:A$350,0)","v":74},"Depreciation/Amortization & Depletion",{"$f":"INDEX(CFlow!$A$200:$M$500,$A67,COLUMN()-COLUMN($A67))","v":6862},{"$f":"INDEX(CFlow!$A$200:$M$500,$A67,COLUMN()-COLUMN($A67))","v":5741},{"$f":"INDEX(CFlow!$A$200:$M$500,$A67,COLUMN()-COLUMN($A67))","v":4315},{"$f":"INDEX(CFlow!$A$200:$M$500,$A67,COLUMN()-COLUMN($A67))","v":3025},{"$f":"INDEX(CFlow!$A$200:$M$500,$A67,COLUMN()-COLUMN($A67))","v":2342},null,{"$f":"I65/$G$32","v":4.7147945378033873E-3},{"$f":"J65/$G$32","v":4.4119262211828828E-3},{"$f":"K65/$G$32","v":3.5541174293802183E-3},{"$f":"L65/$G$32","v":2.8874233967145185E-3},{"$f":"M65/$G$32","v":1.9339665909312478E-3},"Per share Free Cash Flow"]
[{"$f":"MATCH(B68,CFlow!A$200:A$350,0)","v":89},"Payment of Dividends & Other Distributions",{"$f":"INDEX(CFlow!$A$200:$M$500,$A68,COLUMN()-COLUMN($A68))","v":0},{"$f":"INDEX(CFlow!$A$200:$M$500,$A68,COLUMN()-COLUMN($A68))","v":0},{"$f":"INDEX(CFlow!$A$200:$M$500,$A68,COLUMN()-COLUMN($A68))","v":0},{"$f":"INDEX(CFlow!$A$200:$M$500,$A68,COLUMN()-COLUMN($A68))","v":0},{"$f":"INDEX(CFlow!$A$200:$M$500,$A68,COLUMN()-COLUMN($A68))","v":0},null,{"$f":"G66","v":-4491},{"$f":"F66","v":-6733},{"$f":"E66","v":-13915},{"$f":"D66","v":-15102},{"$f":"C66","v":-15115},"Capital Expenditures"]
[null,"(convert to positive number)",{"$f":"1-C68","v":1},{"$f":"1-D68","v":1},1,1,1,null,{"$f":"I68/I32","v":-1.5561330561330562},{"$f":"J68/J32","v":-2.3169304886441844},{"$f":"K68/K32","v":-4.8756131744919413},{"$f":"L68/L32","v":-5.2952314165497896},{"$f":"M68/M32","v":-5.3079786486866132},"Cap Exp per share"]
[{"$f":"MATCH(B70,CFlow!A$200:A$350,0)","v":78},"Net Cash From Operating Activities",{"$f":"INDEX(CFlow!$A$200:$M$500,$A70,COLUMN()-COLUMN($A70))","v":38747},{"$f":"INDEX(CFlow!$A$200:$M$500,$A70,COLUMN()-COLUMN($A70))","v":36314},{"$f":"INDEX(CFlow!$A$200:$M$500,$A70,COLUMN()-COLUMN($A70))","v":29274},{"$f":"INDEX(CFlow!$A$200:$M$500,$A70,COLUMN()-COLUMN($A70))","v":24216},{"$f":"INDEX(CFlow!$A$200:$M$500,$A70,COLUMN()-COLUMN($A70))","v":16108},null,{"$f":"I64-I54-I68","v":20598},{"$f":"J64-J54-J68","v":30948},43188,51415,53861,"Free Cash Flow","(Cash from Oper-PP&E-Dividends)"]
[null,"Free Cashflow per Share",{"$f":"C64/C32","v":13.606897036100577},{"$f":"D64/D32","v":12.732819074333801},10.25718290119131,8.3331039229181005,5.5814275814275813,null,null,null,null,null,null,null,"formula from Investopedia"]
[null,"Latest Annual Free Cashflow",null,null,null,null,{"$f":"G71*G32","v":16108},null,{"$f":"G71","v":5.5814275814275813},{"$f":"F71","v":8.3331039229181005},{"$f":"E71","v":10.25718290119131},{"$f":"D71","v":12.732819074333801},{"$f":"C71","v":13.606897036100577},{"$f":"IF(M72=\"--\",\"No data\",(M72/L72))","v":1.0686476385680137},"Change from prior year"]
[null,"NAME OF COMPANY",{"$f":"OFFSET(AnnBS!A119,-60,0,1)","v":"Insurance"},{"$f":"AnnBS!A60","v":"Investing"}]
[null,"Company Name from Zacks Ann Balance Sheet",{"$f":"AnnBS!J203","v":"Facebook, Inc. (FB)"},null,null,null,null,null,{"$f":"C63/I9-1","v":6.2992737290257947},{"$f":"D63/J9-1","v":2.1695816186556929},{"$f":"E63/K9-1","v":1.914458942928694},{"$f":"F63/L9-1","v":0.67409119562933384},{"$f":"G63/M9-1","v":-9.8632554036171105E-2},"% difference-Net Earnings/Receivables"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G69=\"--\",0,G69)","v":1}]
[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"]
[]
[{"$f":"MATCH(B78,AnnBS!A$100:A$400,0)","v":{"$error":"#N/A"}},"(Real Time Quote from BATS)",null,{"$f":"AnnBS!J210","v":"(Delayed Data from NSDQ)"},{"$f":"AnnBS!J320","v":"Notes Receivable"},"Vlookup price AnnBS"]
[{"$f":"MATCH(B79,AnnBS!A$100:A$400,0)","v":{"$error":"#N/A"}},"(Delayed Data from NSDQ) --old location",{"$f":"OFFSET(INDEX(AnnBS!$A$100:$I$500,$A78,COLUMN()-COLUMN($A78)),1,0)","v":{"$error":"#N/A"}},null,{"$f":"AnnBS!A313","v":"Total Common Equity"},"1st price location"]
[null,null,{"$f":"IF(E79=\"Data feed\",C79,E79)","v":"Total Common Equity"},{"$f":"MID(E78,2,3)","v":"ote"},{"$f":"AnnBS!A317","v":"All items in Millions except Per Share data."},"2nd price location"]
[null,{"$f":"AnnBS!J204","v":373.06},"Text to value >>>",{"$f":"VALUE(E81)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNUMBER(E79),E79,D80)","v":"ote"}]
[null,"Price to use above^^^^"]
[]
[null,"QUARTERLY BALANCE SHEET DATA"]
[{"$f":"MATCH(B85,AnnBS!A$200:A$415,0)","v":72},"All items in Millions except Per Share data.",{"$f":"OFFSET(INDEX(AnnBS!$A$400:$O$500,$A85,COLUMN()-COLUMN($A85)),1,0)","v":0},{"$f":"OFFSET(INDEX(AnnBS!$A$400:$O$500,$A85,COLUMN()-COLUMN($A85)),1,0)","v":0},{"$f":"OFFSET(INDEX(AnnBS!$A$400:$O$500,$A85,COLUMN()-COLUMN($A85)),1,0)","v":0},{"$f":"OFFSET(INDEX(AnnBS!$A$400:$O$500,$A85,COLUMN()-COLUMN($A85)),1,0)","v":0},{"$f":"OFFSET(INDEX(AnnBS!$A$400:$O$500,$A85,COLUMN()-COLUMN($A85)),1,0)","v":0},null,{"$f":"G85","v":0},{"$f":"F85","v":0},{"$f":"E85","v":0},{"$f":"D85","v":0},{"$f":"C85","v":0}]
[]
[]
[]
[]
[null,"Free Cash Flow per Share",{"$f":"INDEX(#REF!,$A90,COLUMN()-COLUMN($A90))","v":{"$error":"#REF!"}},{"$f":"INDEX(#REF!,$A90,COLUMN()-COLUMN($A90))","v":{"$error":"#REF!"}},{"$f":"INDEX(#REF!,$A90,COLUMN()-COLUMN($A90))","v":{"$error":"#REF!"}},{"$f":"INDEX(#REF!,$A90,COLUMN()-COLUMN($A90))","v":{"$error":"#REF!"}},{"$f":"INDEX(#REF!,$A90,COLUMN()-COLUMN($A90))","v":{"$error":"#REF!"}},null,{"$f":"C90","v":{"$error":"#REF!"}},{"$f":"D90","v":{"$error":"#REF!"}},{"$f":"E90","v":{"$error":"#REF!"}},{"$f":"F90","v":{"$error":"#REF!"}},{"$f":"G90","v":{"$error":"#REF!"}},"Cash from Operating Activities per share"]
[null,null,null,null,null,null,null,null,{"$f":"IF(I95=0,\"No Div.\",I90/I95)","v":{"$error":"#REF!"}},{"$f":"IF(J95=0,\"No Div.\",J90/J95)","v":{"$error":"#REF!"}},{"$f":"IF(K95=0,\"No Div.\",K90/K95)","v":{"$error":"#REF!"}},{"$f":"IF(L95=0,\"No Div.\",L90/L95)","v":{"$error":"#REF!"}},{"$f":"IF(M95=0,\"No Div.\",M90/M95)","v":{"$error":"#REF!"}},"ratio: Dividends to Cash from Operations"]
[]
[null,null,null,null,null,null,null,null,{"$f":"C86/C97","v":0},{"$f":"D86/D97","v":0},{"$f":"E86/E97","v":0},{"$f":"F86/F97","v":0},{"$f":"G86/G97","v":0},"Ernings confidence rating"]
[{"$f":"MATCH(B94,AnnBS!A$400:A$415,0)","v":{"$error":"#N/A"}},"Dividends Per Share",{"$f":"INDEX(Income!$A$350:W$500,$A94,COLUMN()-COLUMN($A94))","v":{"$error":"#N/A"}},{"$f":"INDEX(Income!$A$350:X$500,$A94,COLUMN()-COLUMN($A94))","v":{"$error":"#N/A"}},{"$f":"INDEX(Income!$A$350:Y$500,$A94,COLUMN()-COLUMN($A94))","v":{"$error":"#N/A"}},{"$f":"INDEX(Income!$A$350:Z$500,$A94,COLUMN()-COLUMN($A94))","v":{"$error":"#N/A"}},{"$f":"INDEX(Income!$A$350:AA$500,$A94,COLUMN()-COLUMN($A94))","v":{"$error":"#N/A"}}]
[{"$f":"MATCH(B95,Income!$A$200:$A$411,0)","v":74},"Sales",{"$f":"INDEX(Income!$A$200:W$500,$A95,COLUMN()-COLUMN($A95))","v":85965},{"$f":"INDEX(Income!$A$200:X$500,$A95,COLUMN()-COLUMN($A95))","v":70697},{"$f":"INDEX(Income!$A$200:Y$500,$A95,COLUMN()-COLUMN($A95))","v":55838},{"$f":"INDEX(Income!$A$200:Z$500,$A95,COLUMN()-COLUMN($A95))","v":40653},{"$f":"INDEX(Income!$A$200:AA$500,$A95,COLUMN()-COLUMN($A95))","v":27638},null,{"$f":"G95","v":27638},{"$f":"F95","v":40653},{"$f":"E95","v":55838},{"$f":"D95","v":70697},{"$f":"C95","v":85965},"Q Sales"]
[{"$f":"MATCH(B96,Income!$A$200:$A$411,0)","v":81},"Pretax Income",{"$f":"INDEX(Income!$A$200:W$500,$A96,COLUMN()-COLUMN($A96))","v":33180},{"$f":"INDEX(Income!$A$200:X$500,$A96,COLUMN()-COLUMN($A96))","v":24812},{"$f":"INDEX(Income!$A$200:Y$500,$A96,COLUMN()-COLUMN($A96))","v":25361},{"$f":"INDEX(Income!$A$200:Z$500,$A96,COLUMN()-COLUMN($A96))","v":20594},{"$f":"INDEX(Income!$A$200:AA$500,$A96,COLUMN()-COLUMN($A96))","v":12518},null,{"$f":"G97","v":10217},{"$f":"F97","v":15934},{"$f":"E97","v":22112},{"$f":"D97","v":18485},{"$f":"C97","v":29146},"Net Income"]
[{"$f":"MATCH(B97,Income!$A$200:$A$411,0)","v":88},"Net Income",{"$f":"INDEX(Income!$A$200:W$500,$A97,COLUMN()-COLUMN($A97))","v":29146},{"$f":"INDEX(Income!$A$200:X$500,$A97,COLUMN()-COLUMN($A97))","v":18485},{"$f":"INDEX(Income!$A$200:Y$500,$A97,COLUMN()-COLUMN($A97))","v":22112},{"$f":"INDEX(Income!$A$200:Z$500,$A97,COLUMN()-COLUMN($A97))","v":15934},{"$f":"INDEX(Income!$A$200:AA$500,$A97,COLUMN()-COLUMN($A97))","v":10217},null,{"$f":"C97*C32","v":82996149.599999994},{"$f":"D97*D32","v":52719220},{"$f":"E97*E32","v":63107648},{"$f":"F97*F32","v":46304204},{"$f":"G97*G32","v":29486262},"Q TotalNet Income"]
[{"$f":"MATCH(B98,Income!$A$200:$A$411,0)","v":75},"Cost Of Goods",{"$f":"INDEX(Income!$A$200:W$500,$A98,COLUMN()-COLUMN($A98))","v":16692},{"$f":"INDEX(Income!$A$200:X$500,$A98,COLUMN()-COLUMN($A98))","v":12770},{"$f":"INDEX(Income!$A$200:Y$500,$A98,COLUMN()-COLUMN($A98))","v":9355},{"$f":"INDEX(Income!$A$200:Z$500,$A98,COLUMN()-COLUMN($A98))","v":5454},{"$f":"INDEX(Income!$A$200:AA$500,$A98,COLUMN()-COLUMN($A98))","v":3789},null,null,{"$f":"(D95/C95)-1","v":-0.17760716570697377},{"$f":"(E95/D95)-1","v":-0.21017864973054023},{"$f":"(F95/E95)-1","v":-0.27194741932017619},{"$f":"(G95/F95)-1","v":-0.32014857452094558},"Sales growth"]
[{"$f":"MATCH(B99,Income!$A$200:$A$411,0)","v":88},"Net Income",{"$f":"INDEX(Income!$A$200:W$500,$A99,COLUMN()-COLUMN($A99))","v":29146},{"$f":"INDEX(Income!$A$200:X$500,$A99,COLUMN()-COLUMN($A99))","v":18485},{"$f":"INDEX(Income!$A$200:Y$500,$A99,COLUMN()-COLUMN($A99))","v":22112},{"$f":"INDEX(Income!$A$200:Z$500,$A99,COLUMN()-COLUMN($A99))","v":15934},{"$f":"INDEX(Income!$A$200:AA$500,$A99,COLUMN()-COLUMN($A99))","v":10217},null,{"$f":"G98","v":3789},{"$f":"F98","v":5454},{"$f":"E98","v":9355},{"$f":"D98","v":12770},{"$f":"C98","v":16692},"Q Cost of good sold"]
[{"$f":"MATCH(B100,Income!$A$200:$A$411,0)","v":{"$error":"#N/A"}},"Free Cash Flow",{"$f":"INDEX(Income!$A$200:W$500,$A100,COLUMN()-COLUMN($A100))","v":{"$error":"#N/A"}},{"$f":"INDEX(Income!$A$200:X$500,$A100,COLUMN()-COLUMN($A100))","v":{"$error":"#N/A"}},{"$f":"INDEX(Income!$A$200:Y$500,$A100,COLUMN()-COLUMN($A100))","v":{"$error":"#N/A"}},{"$f":"INDEX(Income!$A$200:Z$500,$A100,COLUMN()-COLUMN($A100))","v":{"$error":"#N/A"}},{"$f":"INDEX(Income!$A$200:AA$500,$A100,COLUMN()-COLUMN($A100))","v":{"$error":"#N/A"}},null,{"$f":"I96/C95","v":0.11885069505031118},{"$f":"J96/D95","v":0.22538438689053283},{"$f":"K96/E95","v":0.39600272216053584},{"$f":"L96/F95","v":0.45470199001303718},{"$f":"M96/G95","v":1.0545625587958607},"Profitability on Revenues"]
[{"$f":"MATCH(B101,Income!$A$200:$A$411,0)","v":86},"Income From Cont. Operations",{"$f":"INDEX(Income!$A$200:W$500,$A101,COLUMN()-COLUMN($A101))","v":29146},{"$f":"INDEX(Income!$A$200:X$500,$A101,COLUMN()-COLUMN($A101))","v":18485},{"$f":"INDEX(Income!$A$200:Y$500,$A101,COLUMN()-COLUMN($A101))","v":22112},{"$f":"INDEX(Income!$A$200:Z$500,$A101,COLUMN()-COLUMN($A101))","v":15934},{"$f":"INDEX(Income!$A$200:AA$500,$A101,COLUMN()-COLUMN($A101))","v":10217},null,{"$f":"C100","v":{"$error":"#N/A"}},{"$f":"D100","v":{"$error":"#N/A"}},{"$f":"E100","v":{"$error":"#N/A"}},{"$f":"F100","v":{"$error":"#N/A"}},{"$f":"G100","v":{"$error":"#N/A"}},"Free Cash Flow"]
[null,null,null,null,null,null,null,null,{"$f":"C97/C95","v":0.3390449601582039},{"$f":"D97/D95","v":0.26146795479298979},{"$f":"E97/E95","v":0.39600272216053584},{"$f":"F97/F95","v":0.39195139350109465},{"$f":"G97/G95","v":0.36967219046240685},"Net Profit Margin"]
[null,"Qtr Income data",null,null,null,null,null,null,{"$f":"(C95-C98)/C95","v":0.80582795323678236},{"$f":"(D95-D98)/D95","v":0.81936998741106415},{"$f":"(E95-E98)/E95","v":0.8324617643898421},{"$f":"(F95-F98)/F95","v":0.86584015939783043},{"$f":"(G95-G98)/G95","v":0.86290614371517471},"Quarterly Gross Margin"]
[{"$f":"MATCH(B104,AnnBS!$A$200:$A$401,0)","v":81},"Net Property & Equipment",{"$f":"INDEX(AnnBS!$A$200:N$500,$A104,COLUMN()-COLUMN($A104))","v":45633},{"$f":"INDEX(AnnBS!$A$200:O$500,$A104,COLUMN()-COLUMN($A104))","v":35323},{"$f":"INDEX(AnnBS!$A$200:P$500,$A104,COLUMN()-COLUMN($A104))","v":24683},{"$f":"INDEX(AnnBS!$A$200:Q$500,$A104,COLUMN()-COLUMN($A104))","v":13721},{"$f":"INDEX(AnnBS!$A$200:R$500,$A104,COLUMN()-COLUMN($A104))","v":8591},null,{"$f":"C99/C95","v":0.3390449601582039},{"$f":"D99/D95","v":0.26146795479298979},{"$f":"E99/E95","v":0.39600272216053584},{"$f":"F99/F95","v":0.39195139350109465},{"$f":"G99/G95","v":0.36967219046240685},"Operating Margin"]
[null,null,null,null,null,null,null,null,{"$f":"1-C104","v":-45632},{"$f":"1-D104","v":-35322},{"$f":"1-E104","v":-24682},{"$f":"1-F104","v":-13720},{"$f":"1-G104","v":-8590},"Property Plant & Equipment"]
[{"$f":"MATCH(B106,AnnBS!$A$200:$A$401,0)","v":76},"Receivables",{"$f":"INDEX(AnnBS!$A$200:N$500,$A106,COLUMN()-COLUMN($A106))","v":11335},{"$f":"INDEX(AnnBS!$A$200:O$500,$A106,COLUMN()-COLUMN($A106))","v":9518},{"$f":"INDEX(AnnBS!$A$200:P$500,$A106,COLUMN()-COLUMN($A106))","v":7587},{"$f":"INDEX(AnnBS!$A$200:Q$500,$A106,COLUMN()-COLUMN($A106))","v":5832},{"$f":"INDEX(AnnBS!$A$200:R$500,$A106,COLUMN()-COLUMN($A106))","v":3993},null,{"$f":"IF(C106=\"--\",\"No data\",C106/$C$113)","v":3.9805450203680293},{"$f":"IF(D106=\"--\",\"No data\",D106/$C$113)","v":3.342463829189493},{"$f":"IF(E106=\"--\",\"No data\",E106/$C$113)","v":2.6643489254108723},{"$f":"IF(F106=\"--\",\"No data\",F106/$C$113)","v":2.048040455120101},{"$f":"IF(G106=\"--\",\"No data\",G106/$C$113)","v":1.4022334597555837},"Accts Receivable per share"]
[{"$f":"MATCH(B107,AnnBS!$A$200:$A$401,0)","v":78},"Inventories",{"$f":"INDEX(AnnBS!$A$200:N$500,$A107,COLUMN()-COLUMN($A107))","v":0},{"$f":"INDEX(AnnBS!$A$200:O$500,$A107,COLUMN()-COLUMN($A107))","v":0},{"$f":"INDEX(AnnBS!$A$200:P$500,$A107,COLUMN()-COLUMN($A107))","v":0},{"$f":"INDEX(AnnBS!$A$200:Q$500,$A107,COLUMN()-COLUMN($A107))","v":0},{"$f":"INDEX(AnnBS!$A$200:R$500,$A107,COLUMN()-COLUMN($A107))","v":0},null,{"$f":"G107","v":0},{"$f":"F107","v":0},{"$f":"E107","v":0},{"$f":"D107","v":0},{"$f":"C107","v":0},"Q Inventories"]
[null,null,null,null,null,null,null,null,{"$f":"C104/C95","v":0.53083231547722909},{"$f":"D104/D95","v":0.49963930576969318},{"$f":"E104/E95","v":0.44204663490812707},{"$f":"F104/F95","v":0.33751506653875485},{"$f":"G104/G95","v":0.31084014762283813},"Qtr Cap Expenditures/Sales"]
[null,null,null,null,null,null,null,null,{"$f":"G104","v":8591},{"$f":"F104","v":13721},{"$f":"E104","v":24683},{"$f":"D104","v":35323},{"$f":"C104","v":45633},"PP&E per share"]
[{"$f":"MATCH(B110,AnnBS!$A$200:$A$401,0)","v":87},"Total assets",{"$f":"INDEX(AnnBS!$A$200:N$500,$A110,COLUMN()-COLUMN($A110))","v":159316},{"$f":"INDEX(AnnBS!$A$200:O$500,$A110,COLUMN()-COLUMN($A110))","v":133376},{"$f":"INDEX(AnnBS!$A$200:P$500,$A110,COLUMN()-COLUMN($A110))","v":97334},{"$f":"INDEX(AnnBS!$A$200:Q$500,$A110,COLUMN()-COLUMN($A110))","v":84524},{"$f":"INDEX(AnnBS!$A$200:R$500,$A110,COLUMN()-COLUMN($A110))","v":64961},null,{"$f":"C110","v":159316},133376,97334,84524,64961]
[{"$f":"MATCH(B111,AnnBS!$A$200:$A$401,0)","v":91},"Current Portion Long-Term Debt",{"$f":"INDEX(AnnBS!$A$200:N$500,$A111,COLUMN()-COLUMN($A111))","v":0},{"$f":"INDEX(AnnBS!$A$200:O$500,$A111,COLUMN()-COLUMN($A111))","v":0},{"$f":"INDEX(AnnBS!$A$200:P$500,$A111,COLUMN()-COLUMN($A111))","v":0},{"$f":"INDEX(AnnBS!$A$200:Q$500,$A111,COLUMN()-COLUMN($A111))","v":0},{"$f":"INDEX(AnnBS!$A$200:R$500,$A111,COLUMN()-COLUMN($A111))","v":0},null,0,0,0,0,0,"Q Debt"]
[{"$f":"MATCH(B112,AnnBS!$A$200:$A$401,0)","v":105},"Shareholders Equity",{"$f":"INDEX(AnnBS!$A$200:N$500,$A112,COLUMN()-COLUMN($A112))","v":44196},{"$f":"INDEX(AnnBS!$A$200:O$500,$A112,COLUMN()-COLUMN($A112))","v":43830},{"$f":"INDEX(AnnBS!$A$200:P$500,$A112,COLUMN()-COLUMN($A112))","v":43465},{"$f":"INDEX(AnnBS!$A$200:Q$500,$A112,COLUMN()-COLUMN($A112))","v":43100},{"$f":"INDEX(AnnBS!$A$200:R$500,$A112,COLUMN()-COLUMN($A112))","v":42735}]
[{"$f":"MATCH(B113,AnnBS!$A$200:$A$401,0)","v":115},"Shares Outstanding",{"$f":"INDEX(AnnBS!$A$200:N$500,$A113,COLUMN()-COLUMN($A113))","v":2847.6},{"$f":"INDEX(AnnBS!$A$200:O$500,$A113,COLUMN()-COLUMN($A113))","v":2852},{"$f":"INDEX(AnnBS!$A$200:P$500,$A113,COLUMN()-COLUMN($A113))","v":2854},{"$f":"INDEX(AnnBS!$A$200:Q$500,$A113,COLUMN()-COLUMN($A113))","v":2906},{"$f":"INDEX(AnnBS!$A$200:R$500,$A113,COLUMN()-COLUMN($A113))","v":2886},null,{"$f":"IF(I106=\"no data\",\"N/A\",(I106*91.5)/C95)","v":4.2368390550069756E-3},{"$f":"IF(J106=\"no data\",\"N/A\",(J106*91.5)/D95)","v":4.3260030888275123E-3},{"$f":"IF(K106=\"no data\",\"N/A\",(K106*91.5)/E95)","v":4.3659860072906408E-3},{"$f":"IF(L106=\"no data\",\"N/A\",(L106*91.5)/F95)","v":4.6096401653872836E-3},{"$f":"IF(M106=\"no data\",\"N/A\",(M106*91.5)/G95)","v":4.642317156365725E-3},"Days waiting for payment"]
[{"$f":"MATCH(B114,Income!$A$200:$A$411,0)","v":93},"Earnings Per Share Data",{"$f":"INDEX(AnnBS!$A$200:N$500,$A114,COLUMN()-COLUMN($A114))","v":11152},{"$f":"INDEX(AnnBS!$A$200:O$500,$A114,COLUMN()-COLUMN($A114))","v":11735},{"$f":"INDEX(AnnBS!$A$200:P$500,$A114,COLUMN()-COLUMN($A114))","v":5509},{"$f":"INDEX(AnnBS!$A$200:Q$500,$A114,COLUMN()-COLUMN($A114))","v":2892},{"$f":"INDEX(AnnBS!$A$200:R$500,$A114,COLUMN()-COLUMN($A114))","v":2203},null,{"$f":"IF(I107=0,\"0\",C95/C107)","v":"0"},{"$f":"IF(J107=0,\"0\",D95/D107)","v":"0"},{"$f":"IF(K107=0,\"0\",E95/E107)","v":"0"},{"$f":"IF(L107=0,\"0\",F95/F107)","v":"0"},{"$f":"IF(M107=0,\"0\",G95/G107)","v":"0"},"Inventory Turover"]
[]
[{"$f":"MATCH(B116,AnnBS!$A$200:$A$401,0)","v":80},"Total Current Assets",{"$f":"INDEX(AnnBS!$A$200:N$500,$A116,COLUMN()-COLUMN($A116))","v":75670},{"$f":"INDEX(AnnBS!$A$200:O$500,$A116,COLUMN()-COLUMN($A116))","v":66225},{"$f":"INDEX(AnnBS!$A$200:P$500,$A116,COLUMN()-COLUMN($A116))","v":50480},{"$f":"INDEX(AnnBS!$A$200:Q$500,$A116,COLUMN()-COLUMN($A116))","v":48563},{"$f":"INDEX(AnnBS!$A$200:R$500,$A116,COLUMN()-COLUMN($A116))","v":34401},null,null,{"$f":"(D116/C116)-1","v":-0.12481828994317434},{"$f":"(E116/D116)-1","v":-0.23775009437523598},{"$f":"(F116/E116)-1","v":-3.7975435816164804E-2},{"$f":"(G116/F116)-1","v":-0.29162119308938905},"Change in Assets growth"]
[{"$f":"MATCH(B117,AnnBS!$A$200:$A$401,0)","v":96},"Total Current Liabilities",{"$f":"INDEX(AnnBS!$A$200:N$500,$A117,COLUMN()-COLUMN($A117))","v":14981},{"$f":"INDEX(AnnBS!$A$200:O$500,$A117,COLUMN()-COLUMN($A117))","v":15053},{"$f":"INDEX(AnnBS!$A$200:P$500,$A117,COLUMN()-COLUMN($A117))","v":7017},{"$f":"INDEX(AnnBS!$A$200:Q$500,$A117,COLUMN()-COLUMN($A117))","v":3760},{"$f":"INDEX(AnnBS!$A$200:R$500,$A117,COLUMN()-COLUMN($A117))","v":2875}]
[null,null,{"$f":"INDEX(AnnBS!$A$200:N$500,$A118,COLUMN()-COLUMN($A118))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(AnnBS!$A$200:O$500,$A118,COLUMN()-COLUMN($A118))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(AnnBS!$A$200:P$500,$A118,COLUMN()-COLUMN($A118))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(AnnBS!$A$200:Q$500,$A118,COLUMN()-COLUMN($A118))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(AnnBS!$A$200:R$500,$A118,COLUMN()-COLUMN($A118))","v":{"$error":"#VALUE!"}},null,{"$f":"G120","v":0},{"$f":"F120","v":0},{"$f":"E120","v":0},{"$f":"D120","v":0},{"$f":"C120","v":0},"Long-Term Debt"]
[{"$f":"MATCH(B119,AnnBS!$A$200:$A$401,0)","v":115},"Shares Outstanding",{"$f":"INDEX(AnnBS!$A$200:N$500,$A119,COLUMN()-COLUMN($A119))","v":2847.6},{"$f":"INDEX(AnnBS!$A$200:O$500,$A119,COLUMN()-COLUMN($A119))","v":2852},{"$f":"INDEX(AnnBS!$A$200:P$500,$A119,COLUMN()-COLUMN($A119))","v":2854},{"$f":"INDEX(AnnBS!$A$200:Q$500,$A119,COLUMN()-COLUMN($A119))","v":2906},{"$f":"INDEX(AnnBS!$A$200:R$500,$A119,COLUMN()-COLUMN($A119))","v":2886},null,{"$f":"C119","v":2847.6},{"$f":"D119","v":2852},{"$f":"E119","v":2854},{"$f":"F119","v":2906},{"$f":"G119","v":2886},"Qtr Shares Outstanding"]
[{"$f":"MATCH(B120,AnnBS!$A$200:$A$401,0)","v":100},"Long-Term Debt",{"$f":"INDEX(AnnBS!$A$200:N$500,$A120,COLUMN()-COLUMN($A120))","v":0},{"$f":"INDEX(AnnBS!$A$200:O$500,$A120,COLUMN()-COLUMN($A120))","v":0},{"$f":"INDEX(AnnBS!$A$200:P$500,$A120,COLUMN()-COLUMN($A120))","v":0},{"$f":"INDEX(AnnBS!$A$200:Q$500,$A120,COLUMN()-COLUMN($A120))","v":0},{"$f":"INDEX(AnnBS!$A$200:R$500,$A120,COLUMN()-COLUMN($A120))","v":0},null,{"$f":"(C116-C107)/C117","v":5.0510646819304457},{"$f":"(D116-D107)/D117","v":4.3994552580880883},{"$f":"(E116-E107)/E117","v":7.1939575317087074},{"$f":"(F116-F107)/F117","v":12.915691489361702},{"$f":"(G116-G107)/G117","v":11.965565217391305},"Quick Ratio 1:1"]
[null,null,null,null,null,null,null,null,{"$f":"C116/C117","v":5.0510646819304457},{"$f":"D116/D117","v":4.3994552580880883},{"$f":"E116/E117","v":7.1939575317087074},{"$f":"F116/F117","v":12.915691489361702},{"$f":"G116/G117","v":11.965565217391305},"Current Ratio 2:1"]
[null,null,null,null,null,null,null,null,{"$f":"C97/C116","v":0.38517245936302363},{"$f":"D97/D116","v":0.27912419781049452},{"$f":"E97/E116","v":0.43803486529318542},{"$f":"F97/F116","v":0.32810987789057511},{"$f":"G97/G116","v":0.29699718031452577},"ROA"]
[{"$f":"MATCH(B123,'Bond rate'!A$1:A$435,0)","v":352},"Ten-Year Treasury Constant Maturity",{"$f":"INDEX('Bond rate'!$A$1:$C$435,$A123,COLUMN()-COLUMN($A123))","v":1.46},null,null,null,null,null,{"$f":"I97/C112","v":1877.9108878631548},{"$f":"J97/D112","v":1202.8113164499202},{"$f":"K97/E112","v":1451.9187392154606},{"$f":"L97/F112","v":1074.3434802784222},{"$f":"M97/G112","v":689.97922077922078},"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,"OFFSET(INDEX('[AnnReport-ZACKS 936a.xlsm]AnnBS'!$A$300:$A400,$A76,COLUMN()-COLUMN($C76)),2,0)",null,null,null,null,null,null,"<<<","find the price"]
[null,null,"With the data now in Excel, you can use VLOOKUP or INDEX/MATCH functions to reference the data in the web query. "]
[null,null,"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":427,"n_cols":18,"rows_kept":427,"cut":false,"hidden":true,"merged":[]}
[{"$f":"Analysis!E2","v":"fb"}]
["Skip to main content"]
["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 of Service."]
["I accept X"]
["Zacks Invesment Research Home"]
[]
["Join"]
["Sign In"]
["Member Sign In"]
["Username or Email Address"]
["Password"]
["Keep Me Signed In What does \"Remember Me\" do?"]
["Don't Know Your Password?"]
["Close this window"]
[]
["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"]
[]
["Crypto"]
["Earnings Earnings"]
[]
["Earnings"]
["Earnings Calendar"]
["Earnings Releases"]
["Earnings ESP"]
["Earnings ESP Filter"]
[]
["Screening Screening"]
[]
["Screening"]
["Stock Screener"]
["Mutual Fund Screener"]
["ETF Screener"]
["Premium Screens"]
["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"]
["Testimonials"]
["Zacks.com Tutorial"]
[]
["Video"]
["Podcasts"]
["Services Services"]
["Close Services menu"]
["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"]
["Headline Trader"]
["Insider Trader"]
["Large-Cap Trader"]
["Options Trader"]
["Short Sell List"]
["Surprise Trader"]
["TAZR"]
[]
["Innovators"]
[]
[]
["Blockchain"]
["Commodity"]
["Healthcare"]
["Marijuana"]
["Technology"]
[]
["Quote or Search Search"]
[]
["Join"]
[]
["Sign In"]
[]
["Member Sign In"]
["Username or Email Address"]
["Password"]
["Keep Me Signed In What does \"Remember Me\" do?"]
["Don't Know Your Password?"]
["Close this window"]
[]
["Help"]
[]
["Zacks Invesment Research Home"]
["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 "]
["* indicates the important links in the menu"]
[]
["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 Dates and Announcements"]
["Key Company Metrics"]
["Broker Reports "]
["Insiders "]
["Earnings Transcripts"]
["Dividend History"]
[]
["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"]
[null,null,null,null,null,null,"Alternate method using \"Data Feed\""]
["Options ",null,null,null,null,null,"Using Vlookup and Offset",null,null,{"$f":"VLOOKUP(\"Data Feed\",A106:A406,1,0)","v":"Data Feed"}]
[null,null,null,null,null,null,"to find Company name",null,null,{"$f":"OFFSET(J200,6,-9)","v":"Data Feed"}]
["Option Chain",null,null,null,null,null,null,null,"Price",{"$f":"OFFSET(J200,9,-9)","v":"(Delayed Data from NSDQ)"}]
["Options Greek Montage",null,null,null,null,null,null,null,"This name used",{"$f":"IF(J201=\"data feed\",L209,J201)","v":"Facebook, Inc. (FB)"}]
[null,null,null,null,null,null,null,null,"This price used",{"$f":"IF(ISNUMBER(J202),J202,J218)","v":373.06}]
["Access Zacks"]
["Data Feed",null,null,null,null,null,null,null,null,"NSDQ",null,"NYSE"]
[null,null,null,null,null,null,"Using Vlookup and Offset",null,null,{"$f":"VLOOKUP(\"(Real Time Quote from BATS)\",A100:A300,1,0)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(\"(Delayed Data from NYSE)\",A100:A300,1,0)","v":{"$error":"#N/A"}}]
["Facebook, Inc. (FB)",null,null,null,null,null,"to find Price",null,null,"data Feed",null,{"$f":"OFFSET(L207,2,-11)","v":"(Delayed Data from NSDQ)"}]
["(Delayed Data from NSDQ)",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Data Feed\",A100:A300,1,0)","v":"Data Feed"},null,{"$f":"OFFSET(L208,0,-11)","v":"Facebook, Inc. (FB)"}]
["$373.06 USD",null,null,null,null,null,null,null,null,{"$f":"OFFSET(J209,0,-9)","v":"(Delayed Data from NSDQ)"}]
[373.06,null,null,null,null,null,null,null,null,{"$f":"OFFSET(J210,3,-9)","v":"-0.86 (-0.23%)"}]
[11486171]
["-0.86 (-0.23%)",null,null,null,null,null,null,null,null,{"$f":"OFFSET(J209,0,-9)","v":"(Delayed Data from NSDQ)"}]
["Updated Sep 16, 2021 04:00 PM ET"]
["After-Market: $372.82 -0.24 (-0.06%) 5:04 PM ET",null,null,null,null,null,"Alternate method using \"Data Feed\""]
["Add to portfolio",null,null,null,null,null,"Using Vlookup and Offset",null,null,{"$f":"VLOOKUP(\"Data Feed\",A122:A422,1,0)","v":"Data Feed"}]
["Zacks Rank:",null,null,null,null,null,"to find Company name",null,null,{"$f":"OFFSET(J216,-8,-9)","v":"Facebook, Inc. (FB)"}]
["More Info",null,null,null,null,null,null,null,"Price",{"$f":"OFFSET(J216,-5,-9)","v":373.06}]
["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.25600000000000001]
[2,"Buy",0.19209999999999999]
[3,"Hold",0.1085]
[4,"Sell",6.6199999999999995E-2]
[5,"Strong Sell",3.32E-2]
["S&P",500,0.1133]
["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"]
["3-Hold of 5     3    "]
["Style Scores:"]
["More Info"]
["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"]
["C Value | B Growth | C Momentum | B VGM"]
["Industry Rank:"]
["More Info"]
["The Zacks Industry Rank assigns a rating to each of the 265 X (Expanded) Industries based on their average Zacks Rank.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MATCH(P245,A200:A300,)","v":72},"All items in Millions except Per Share data."]
["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.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
["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"]
["Bottom 37% (160 out of 252)"]
["Industry: Internet - Services"]
["Zacks Premium FeatureView All Zacks #1 Ranked Stocks"]
["Trades from $1 "]
["Facebook, Inc. (FB) Quote Overview » Financials » Facebook, Inc. (FB) Balance Sheet "]
["Balance Sheet"]
["Enter Symbol"]
["Research for FB"]
["More Info"]
["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 Facebook, Inc. falls in the month of December."]
["All items in Millions except Per Share data."]
[null,44196,43830,43465,43100,42735]
["Assets"]
["Cash & Equivalents","2069-08-14","2050-03-08","2012-07-24","2014-03-13","1980-08-16"]
["Receivables",11335,9518,7587,5832,3993]
["Notes Receivable",0,0,0,0,0]
["Inventories",0,0,0,0,0]
["Other Current Assets",2381,1852,1779,1020,959]
["Total Current Assets",75670,66225,50480,48563,34401]
["Net Property & Equipment",45633,35323,24683,13721,8591]
["Investments & Advances",6234,0,0,0,0]
["Other Non-Current Assets",0,0,0,0,0]
["Deferred Charges",0,0,0,0,0]
["Intangibles","1953-11-10","1953-09-07","1953-08-24","1955-01-16","1956-07-21"]
["Deposits & Other Assets",2758,2759,2576,2135,1312]
["Total Assets",159316,133376,97334,84524,64961,null,null,null,null,null,null,null,null,{"$f":"C287","v":"2019-12-31"},{"$f":"H291","v":"00:00:00"},{"$f":"I291","v":"00:00:00"},{"$f":"M287","v":"00:00:00"}]
["Liabilities & Shareholders Equity","2020-12-31","2019-12-31","2018-12-31","2017-12-31","2016-12-31"]
["Notes Payable","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
["Accounts Payable",1331,1363,820,380,302]
["Current Portion Long-Term Debt",0,0,0,0,0]
["Current Portion Capital Leases",0,0,0,0,0]
["Accrued Expenses",11152,11735,5509,2892,2203]
["Income Taxes Payable",0,0,0,0,0]
["Other Current Liabilities",1475,1155,688,488,370]
["Total Current Liabilities",14981,15053,7017,3760,2875]
["Mortgages",0,0,0,0,0]
["Deferred Taxes/Income",0,0,0,0,0]
["Convertible Debt",0,0,0,0,0]
["Long-Term Debt",0,0,0,0,0]
["Non-Current Capital Leases",0,0,0,0,0]
["Other Non-Current Liabilities",6414,7745,6190,6417,2892]
["Minority Interest (Liabilities)",0,0,0,0,0]
["Total Liabilities","1984-12-10","1988-06-28","1936-02-27","1927-11-11","1915-10-15"]
["Shareholders Equity",44196,43830,43465,43100,42735]
["Preferred Stock",0,0,0,0,0]
["Common Stock (Par)",0,0,0,0,0]
["Capital Surplus","2036-12-09","2025-07-13","2017-06-20","2011-02-10","2004-08-28"]
["Retained Earnings","2111-10-05","2052-06-22","2014-12-08","1993-01-21","1959-04-30"]
["Other Equity",927,-489,-760,-227,-703]
["Treasury Stock",0,0,0,0,0]
["Total Shareholder's Equity",128290,101054,84127,74347,59194]
["Total Liabilities & Shareholder's Equity",159316,133376,97334,84524,64961]
["Total Common Equity",128290,101054,84127,74347,59194]
["Shares Outstanding",2847.6,2852,2854,2906,2886]
["Book Value Per Share",45.05,35.43,29.48,25.58,20.51]
["Fiscal Year End for Facebook, Inc. falls in the month of December."]
["All items in Millions except Per Share data."]
[null,44377,44286,44196,44104,44012,null,null,null,"OLD DATA SEARCH--DATA MOVED TO A203"]
["Assets",null,null,null,null,null,"Using Vlookup and Offset",null,null,{"$f":"VLOOKUP(\"(Delayed Data from nsdq)\",A100:A330,1,0)","v":"(Delayed Data from NSDQ)"}]
["Cash & Equivalents","2075-06-10","2075-10-27",61954,"2052-04-11","2059-06-14",null,null,null,{"$f":"OFFSET(J319,3,-9)","v":"Notes Receivable"}]
["Receivables",11698,10276,11335,8024,7483,null,null,null,{"$f":"VLOOKUP(\"(Real Time Quote from BATS)\",A102:A332,1,0)","v":{"$error":"#N/A"}}]
["Notes Receivable",0,0,0,0,0,null,null,null,{"$f":"OFFSET(J321,1,-9)","v":"Notes Receivable"}]
["Inventories",0,0,0,0,0,null,null,null,{"$f":"OFFSET(J322,1,-9)","v":"Inventories"}]
["Other Current Assets",4919,2827,2381,2155,2407]
["Total Current Assets",80697,77322,75670,65799,68130,null,null,null,{"$f":"OFFSET(J321,-1,-9)","v":"Cash & Equivalents"}]
["Net Property & Equipment",50909,47720,45633,42291,39006]
["Investments & Advances",6393,6342,6234,6164,0]
["Other Non-Current Assets",0,0,0,0,0]
["Deferred Charges",0,0,0,0,0]
["Intangibles",19733,19561,19673,19775,19888]
["Deposits & Other Assets",2352,"1906-07-03","1907-07-20","1908-02-16","1908-11-11"]
["Total Assets",170609,"2347-09-16","2336-03-10","2300-12-05","2282-06-16"]
["Liabilities & Shareholders Equity",44377,"2021-03-31","2020-12-31","2020-09-30","2020-06-30"]
["Notes Payable",0,0,0,0,0]
["Accounts Payable",973,878,1331,1106,920]
["Current Portion Long-Term Debt",0,0,0,0,0]
["Current Portion Capital Leases",0,0,0,0,0]
["Accrued Expenses",11510,9411,11152,8684,8496]
["Income Taxes Payable","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
["Other Current Liabilities","1903-09-01","1903-10-19","1904-01-14","1903-03-24","1902-09-19"]
["Total Current Liabilities",14874,12717,14981,11944,11308]
["Mortgages",0,0,0,0,0]
["Deferred Taxes/Income",0,"00:00:00",0,0,0]
["Convertible Debt",0,0,0,0,0]
["Long-Term Debt",0,0,0,0,0]
["Non-Current Capital Leases",0,0,0,0,0]
["Other Non-Current Liabilities",6552,null,6414,7121,8303]
["Minority Interest (Liabilities)",0,"00:00:00",0,0,0]
["Total Liabilities",32382,"1981-10-07",31026,28706,29244]
["Shareholders Equity",44377,"2021-03-31",44196,44104,44012]
["Preferred Stock",0,0,0,0,0]
["Common Stock (Par)",0,0,0,0,0]
["Capital Surplus",52845,51160,50018,48910,47805]
["Retained Earnings",85097,82343,77345,68513,62784]
["Other Equity",285,154,927,308,-142]
["Treasury Stock",0,0,0,0,0]
["Total Shareholder's Equity",138227,133657,128290,117731,110447]
["Total Liabilities & Shareholder's Equity",170609,163523,159316,146437,139691]
["Total Common Equity",138227,133657,128290,117731,110447]
["Shares Outstanding",2819.4,2835.4,2847.6,2848.2,2848.8]
["Book Value Per Share",49.03,47.14,45.05,41.34,38.770000000000003]
["Quick Links"]
["     "]
["Services"]
["Account Types"]
["Premium Services"]
["Zacks Rank"]
["Research"]
["Personal Finance"]
["Commentary"]
["Education"]
["Zacks Advisor Tools"]
["My Account",null,null,null,null,null,null,null,null,null,null,null,null,null,10029,"ba"]
["Manage Account",null,null,null,null,null,null,null,null,null,null,null,null,null,9260]
["Update Profile"]
["Subscriptions"]
["Preferences"]
["Login/Password Help"]
["Upgrade to Premium"]
["Resources"]
["Help"]
["About Zacks"]
["Privacy Policy"]
["Do Not Sell My Personal Information"]
["Terms of Service"]
["Performance Disclosure"]
["Accessibility"]
["Site Map"]
["Podcasts"]
["Earnings Calendar"]
["Client Support"]
["Contact Us"]
["Share Feedback"]
["Media"]
["Careers"]
["Advertise"]
["Testimonials"]
["Follow Us"]
["Facebook"]
["Twitter"]
["Linkedin"]
["You Tube"]
["Zacks Mobile App"]
["Download our Zacks App from the Apple App Store"]
["Download our Zacks App from Google Play"]
["Zacks Research is Reported On:"]
[]
["MSN"]
["Marketwatch"]
["Nasdaq"]
["Forbes"]
["Investors.com"]
["Morningstar"]
[]
["Reviewed by Accessible360 "]
["Zacks Investment Research is an A+ Rated BBB Accredited Business"]
["This page has not been authorized, sponsored, or otherwise approved or endorsed by the companies represented herein. Each of the company logos represented herein are trademarks of Microsoft Corporation; Dow Jones & Company; Nasdaq, Inc.; Forbes Media, LLC; Investor's Business Daily, Inc.; and Morningstar, Inc."]
["Copyright 2021 Zacks Investment Research | 10 S Riverside Plaza Suite #1600 | Chicago, IL 60606"]
["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.60% per year. These returns cover a period from January 1, 1988 through June 28, 2021. 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. Zacks 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.",null,null,null,null,null,null,null,null,null,null,null,null,null,10326,"ba"]
["Visit Performance Disclosure for information about the performance numbers displayed above.",null,null,null,null,null,null,null,null,null,null,null,null,null,10052]
["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."]
["This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply."]
["Due to inactivity, you will be"]
["signed out in approximately:"]
["CLICK TO CONTINUE WORKING"]

{"sheet":"Income","index":4,"n_rows":383,"n_cols":6,"rows_kept":383,"cut":false,"hidden":true,"merged":[]}
[{"$f":"Analysis!E2","v":"fb"}]
["Skip to main content"]
["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 of Service."]
["I accept X"]
["Zacks Invesment Research Home"]
[]
["Join"]
["Sign In"]
["Member Sign In"]
["Username or Email Address"]
["Password"]
["Keep Me Signed In What does \"Remember Me\" do?"]
["Don't Know Your Password?"]
["Close this window"]
[]
["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"]
[]
["Crypto"]
["Earnings Earnings"]
[]
["Earnings"]
["Earnings Calendar"]
["Earnings Releases"]
["Earnings ESP"]
["Earnings ESP Filter"]
[]
["Screening Screening"]
[]
["Screening"]
["Stock Screener"]
["Mutual Fund Screener"]
["ETF Screener"]
["Premium Screens"]
["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"]
["Testimonials"]
["Zacks.com Tutorial"]
[]
["Video"]
["Podcasts"]
["Services Services"]
["Close Services menu"]
["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"]
["Headline Trader"]
["Insider Trader"]
["Large-Cap Trader"]
["Options Trader"]
["Short Sell List"]
["Surprise Trader"]
["TAZR"]
[]
["Innovators"]
[]
[]
["Blockchain"]
["Commodity"]
["Healthcare"]
["Marijuana"]
["Technology"]
[]
["Quote or Search Search"]
[]
["Join"]
[]
["Sign In"]
[]
["Member Sign In"]
["Username or Email Address"]
["Password"]
["Keep Me Signed In What does \"Remember Me\" do?"]
["Don't Know Your Password?"]
["Close this window"]
[]
["Help"]
[]
["Zacks Invesment Research Home"]
["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 "]
["* indicates the important links in the menu"]
[]
["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 Dates and Announcements"]
["Key Company Metrics"]
["Broker Reports "]
["Insiders "]
["Earnings Transcripts"]
["Dividend History"]
[]
["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"]
[]
["Facebook, Inc. (FB)"]
["(Delayed Data from NSDQ)"]
["$373.06 USD"]
[373.06]
[11486171]
["-0.86 (-0.23%)"]
["Updated Sep 16, 2021 04:00 PM ET"]
["After-Market: $372.82 -0.24 (-0.06%) 5:04 PM ET"]
["Add to portfolio"]
["Zacks Rank:"]
["More Info"]
["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.25600000000000001]
[2,"Buy",0.19209999999999999]
[3,"Hold",0.1085]
[4,"Sell",6.6199999999999995E-2]
[5,"Strong Sell",3.32E-2]
["S&P",500,0.1133]
["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"]
["3-Hold of 5     3    "]
["Style Scores:"]
["More Info"]
["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"]
["C Value | B Growth | C Momentum | B VGM"]
["Industry Rank:"]
["More Info"]
["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"]
["Bottom 37% (160 out of 252)"]
["Industry: Internet - Services"]
["Zacks Premium FeatureView All Zacks #1 Ranked Stocks"]
["Trades from $1 "]
["Facebook, Inc. (FB) Quote Overview » Financials » Facebook, Inc. (FB) Income Statements "]
["Income Statements"]
["Enter Symbol"]
["Research for FB"]
["More Info"]
["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 Facebook, Inc. falls in the month of December ."]
["All items in Millions except EPS data."]
[null,44196,43830,43465,43100,42735]
["Sales",85965,70697,55838,40653,27638]
["Cost Of Goods",16692,12770,9355,5454,3789]
["Gross Profit",69273,57927,46483,35199,23849]
["Selling & Adminstrative & Depr. & Amort Expenses",36602,33941,21570,14996,11422]
["Income After Depreciation & Amortization","1989-06-12","1965-09-01","1968-03-16","1955-04-24","1934-01-08"]
["Non-Operating Income",509,826,"1901-03-23",391,91]
["Interest Expense",0,0,0,0,0]
["Pretax Income",33180,24812,25361,20594,12518]
["Income Taxes","1911-01-16","1917-04-27","1908-11-22","1912-10-03","1906-04-19"]
["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","1979-10-18","1950-08-10","1960-07-15","1943-08-16","1927-12-21"]
["Extras & Discontinued Operations",0,0,0,0,0]
["Net Income","1979-10-18","1950-08-10","1960-07-15","1943-08-16","1927-12-21"]
["Depreciation Footnote","2020-12-31","2019-12-31","2018-12-31","2017-12-31","2016-12-31"]
["Income Before Depreciation & Amortization",39533,29727,"1980-01-08",23228,14769]
["Depreciation & Amortization (Cash Flow)",6862,5741,"1911-10-24",3025,2342]
["Income After Depreciation & Amortization",32671,23986,"1968-03-16",20203,12427]
["Earnings Per Share Data",44196,43830,"2018-12-31",43100,42735]
["Average Shares",2888,2876,2921,2956,2925]
["Diluted EPS Before Non-Recurring Items",10.09,6.43,7.57,6.16,3.63]
["Diluted Net EPS",10.09,6.43,"1900-01-07T13:40:48",5.39,3.49]
["Fiscal Year end for Facebook, Inc. falls in the month of December ."]
["All items in Millions except EPS data."]
[null,44377,44286,"2020-12-31",44104,44012]
["Sales",29077,26171,28071,21470,18687]
["Cost Of Goods",5399,5131,5210,4194,3829]
["Gross Profit",23678,21040,22861,17276,14858]
["SG&A, R&D, and Dept/Amort Expenses",11311,9662,10086,9236,8895]
["Income After SG&A, R&D, and Dept/Amort Expenses","1933-11-09","1931-02-24","1934-12-22","1922-01-04","1916-04-28"]
["Non-Operating Income","1900-05-25",125,"1900-10-06",93,168]
["Interest Expense",0,0,0,0,0]
["Pretax Income",12513,11503,13055,8133,6131]
["Income Taxes","1905-10-19","1905-06-28","1905-01-08","1900-10-13","1902-08-10"]
["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",10394,9497,"1930-09-19",7846,5178]
["Extras & Discontinued Operations","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
["Net Income",10394,9497,"1930-09-19",7846,5178]
["Earnings Per Share Data","2021-06-30","2021-03-31","2020-12-31","2020-09-30","2020-06-30"]
["Average Shares",2877,2882,2890,2891,2879]
["Diluted EPS Before Non-Recurring Items",3.61,3.3,3.88,2.71,1.8]
["Diluted Net EPS",3.61,3.3,3.87,2.71,1.8]
["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"]
["Privacy Policy"]
["Do Not Sell My Personal Information"]
["Terms of Service"]
["Performance Disclosure"]
["Accessibility"]
["Site Map"]
["Podcasts"]
["Earnings Calendar"]
["Client Support"]
["Contact Us"]
["Share Feedback"]
["Media"]
["Careers"]
["Advertise"]
["Testimonials"]
["Follow Us"]
["Facebook"]
["Twitter"]
["Linkedin"]
["You Tube"]
["Zacks Mobile App"]
["Download our Zacks App from the Apple App Store"]
["Download our Zacks App from Google Play"]
["Zacks Research is Reported On:"]
[]
["MSN"]
["Marketwatch"]
["Nasdaq"]
["Forbes"]
["Investors.com"]
["Morningstar"]
[]
["Reviewed by Accessible360 "]
["Zacks Investment Research is an A+ Rated BBB Accredited Business"]
["This page has not been authorized, sponsored, or otherwise approved or endorsed by the companies represented herein. Each of the company logos represented herein are trademarks of Microsoft Corporation; Dow Jones & Company; Nasdaq, Inc.; Forbes Media, LLC; Investor's Business Daily, Inc.; and Morningstar, Inc."]
["Copyright 2021 Zacks Investment Research | 10 S Riverside Plaza Suite #1600 | Chicago, IL 60606"]
["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.60% per year. These returns cover a period from January 1, 1988 through June 28, 2021. 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. Zacks 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 Disclosure 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."]
["This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply."]
["Due to inactivity, you will be"]
["signed out in approximately:"]
["CLICK TO CONTINUE WORKING"]

{"sheet":"Bond rate","index":5,"n_rows":435,"n_cols":4,"rows_kept":435,"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"]
["Open navigation "]
["Mortgages"]
["Banking"]
["Credit cards"]
["Loans"]
["Investing"]
["Home equity"]
["Insurance"]
["Retirement"]
["Sign in"]
["Main Menu"]
["Mortgages"]
["Mortgages overview "]
["Buying a home"]
["Today's mortgage rates"]
["30-year mortgage rates"]
["15-year mortgage rates"]
["Calculate your mortgage payment"]
["How much house can you afford?"]
["Guide to getting a mortgage"]
["How to get the best mortgage rate"]
["Understanding current interest rates"]
["Refinance your existing loan"]
["Refinance rates"]
["30-year refinance rates"]
["15-year refinance rates"]
["Mortgage refinance calculator"]
["Mortgage refinance resources"]
["What is refinancing"]
["How to refinance your mortgage"]
["When cash-out refinancing makes sense"]
["Finding the right lender"]
["Best mortgage lenders"]
["Best online lenders"]
["Best lenders for first-time homebuyers"]
["Best VA mortgage lenders"]
["Best jumbo mortgage lenders"]
["Best lenders for all borrowing types"]
["Guide to finding the best lender"]
["All mortgage lender reviews"]
["Resources for all borrowers"]
["First time homebuyers"]
["Veteran resources"]
["FHA loans"]
["Jumbo loans"]
["Adjustable rate mortgages"]
["Mortgage relief"]
["Second home"]
["Closing costs"]
["Elevate your Bankrate experience"]
["Get insider access to our best financial tools and content"]
["Get started"]
["Main Menu"]
["Banking"]
["Banking overview "]
["Compare accounts"]
["CD rates"]
["Savings accounts"]
["Money market accounts"]
["1-year CD rates"]
["3-year CD rates"]
["5-year CD rates"]
["Checking accounts"]
["Best banks"]
["Use calculators"]
["Savings calculator"]
["CD calculator"]
["Compound savings calculator"]
["All banking calculators"]
["Get advice"]
["How to save money"]
["Federal Reserve news"]
["What is a savings account?"]
["What is a money market account?"]
["Which certificate of deposit account is best?"]
["How to open a savings account"]
["Tax advice"]
["Bank reviews"]
["Capital One Bank"]
["Marcus by Goldman Sachs"]
["American Express National Bank"]
["CIT Bank"]
["Synchrony Bank"]
["Barclays Bank"]
["All bank reviews"]
["Elevate your Bankrate experience"]
["Get insider access to our best financial tools and content"]
["Get started"]
["Main Menu"]
["Credit cards"]
["Credit cards overview "]
["Compare by category"]
["Best credit cards of 2021"]
["Rewards"]
["Travel"]
["Airline"]
["Cash back"]
["No annual fee"]
["Balance transfer"]
["0% APR"]
["Business"]
["Student"]
["No foreign transaction fees"]
["Compare by credit needed"]
["Excellent credit"]
["Good credit"]
["Fair credit"]
["Bad credit"]
["No credit history"]
["Secured credit cards"]
["Compare by issuer"]
["American Express"]
["Bank of America"]
["Capital One"]
["Chase"]
["Citi"]
["Discover"]
["Wells Fargo"]
["Get advice"]
["CardMatch™"]
["Credit card reviews"]
["Credit card payoff calculator"]
["Balance transfer calculator"]
["All credit card calculators"]
["Improving your credit"]
["Looking for the perfect credit card?"]
["Narrow your search with CardMatch™"]
["Find your match"]
["Main Menu"]
["Loans"]
["Loans overview "]
["Personal Loans"]
["Personal loan rates"]
["Personal loans for bad credit"]
["Low-interest personal loans"]
["How to calculate loan interest"]
["Personal loans lender reviews"]
["Personal loans knowledge base"]
["Student Loans"]
["Student loan rates"]
["Private student loans"]
["Student loans without co-signer"]
["Students loans for bad credit"]
["Student loan refinance rates"]
["How long to pay off student loan?"]
["Current student loans news"]
["Student loans lender reviews"]
["Student loans knowledge base"]
["Other Loans"]
["Auto loan rates"]
["Auto loans knowledge base"]
["Debt consolidation loan rates"]
["Home improvement loan rates"]
["Installment loan rates"]
["Emergency loan rates"]
["Loan calculators"]
["Loan calculator"]
["Personal loan calculator"]
["Loan payment calculator"]
["Student loan calculator"]
["Auto loan calculator"]
["Auto refinance calculator"]
["All calculators"]
["Elevate your Bankrate experience"]
["Get insider access to our best financial tools and content"]
["Get started"]
["Main Menu"]
["Investing"]
["Investing overview "]
["Best of"]
["Best investments"]
["Best short-term investments"]
["Best long-term investments"]
["Best investment apps"]
["Best cryptocurrency brokers"]
["Best index funds"]
["Best ETFs"]
["Best mutual funds"]
["Brokerages and robo-advisors"]
["Brokerage reviews"]
["E-Trade review"]
["Robinhood review"]
["TD Ameritrade review"]
["Robo-advisor reviews"]
["Betterment review"]
["Schwab Intelligent Portfolios review"]
["Wealthfront review"]
["Learn the basics"]
["How to start investing"]
["How to invest in stocks"]
["How to invest in ETFs"]
["How to invest in mutual funds"]
["How to buy an S&P 500 index fund"]
["How does a call option work?"]
["What are index funds and how do they work?"]
["What are put options?"]
["Additional resources"]
["Annuity calculator"]
["Currency converter"]
["Capital gains tax"]
["Cryptocurrency investing"]
["Investment goal calculator"]
["Low-risk investments"]
["Mutual funds vs. ETFs"]
["Passive income ideas"]
["Elevate your Bankrate experience"]
["Get insider access to our best financial tools and content"]
["Get started"]
["Main Menu"]
["Home equity"]
["Home equity overview "]
["Get the best rates"]
["Home equity loan rates"]
["Home equity line of credit rates"]
["Current interest rates"]
["Lender reviews"]
["Home equity lender reviews"]
["Figure review"]
["Third Federal Savings & Loan review"]
["Discover review"]
["Spring EQ review"]
["Use calculators"]
["Home equity calculator"]
["Home equity line of credit (HELOC) calculator"]
["Debt consolidation calculator"]
["Loan vs. line of credit calculator"]
["All home equity calculators"]
["Knowledge base"]
["Home equity loan and HELOC guide"]
["Home equity loans"]
["What is a home equity loan?"]
["What is a HELOC?"]
["How to borrow from home equity"]
["HELOC vs. Home equity loan"]
["Consolidate your debt using home equity"]
["Home equity loans with bad credit"]
["Elevate your Bankrate experience"]
["Get insider access to our best financial tools and content"]
["Get started"]
["Main Menu"]
["Insurance"]
["Insurance overview "]
["Car insurance"]
["Best car insurance companies"]
["Cheapest car insurance companies"]
["Car insurance quotes"]
["How much is car insurance?"]
["Car insurance by state"]
["Learn more about car insurance"]
["Homeowners insurance"]
["Best home insurance companies"]
["Cheapest home insurance companies"]
["Home insurance quotes"]
["How much is homeowners insurance?"]
["Home insurance by state"]
["Learn more about home insurance"]
["Other insurance"]
["Best life insurance companies"]
["Life insurance quotes"]
["Life insurance calculator"]
["Whole life insurance"]
["Term life insurance"]
["Learn more about life insurance"]
["Best renters insurance companies"]
["Learn more about renters insurance"]
["Company reviews"]
["Allstate Insurance"]
["Geico Insurance"]
["Lemonade Insurance"]
["Liberty Mutual Insurance"]
["Progressive Insurance"]
["State Farm Insurance"]
["Travelers Insurance"]
["Elevate your Bankrate experience"]
["Get insider access to our best financial tools and content"]
["Get started"]
["Main Menu"]
["Retirement"]
["Retirement overview "]
["Retirement plans & accounts"]
["Best retirement plans"]
["Best IRA accounts"]
["Best alternatives to a 401(k)"]
["Best Roth IRA accounts"]
["Best places to roll over your 401(k)"]
["Best retirement plans for self-employed"]
["What is a spousal IRA?"]
["401(k) contribution limits"]
["Learn the basics"]
["How to save for retirement"]
["How much to save for retirement"]
["How does an IRA work?"]
["How much should you contribute to your 401(k)?"]
["How does a Roth IRA work?"]
["How to pick 401(k) investments"]
["IRA vs. 401(k)"]
["Roth 401(k) vs. traditional 401(k)"]
["Retirement calculators"]
["All retirement calculators"]
["Retirement calculator"]
["Retirement plan income calculator"]
["Roth IRA calculator"]
["Social Security benefits calculator"]
["Traditional IRA calculator"]
["401(k) calculator"]
["401(k) vs. Roth IRA calculator"]
["Additional resources"]
["Best and worst states for retirement"]
["Best age to take Social Security"]
["How to avoid early withdrawals"]
["Inherited IRA rules"]
["Retirement withdrawal strategies"]
["Should you accept an early retirement offer?"]
["What to do if you're ready to retire"]
["What to do when you lose your 401(k) match"]
["Elevate your Bankrate experience"]
["Get insider access to our best financial tools and content"]
["Get started"]
[]
["My Dashboard"]
["Profile"]
["Email preferences"]
["Support"]
["Logout"]
[]
["Sign in Create Account"]
["Open search Close search "]
["Submit "]
[]
["myDashboard "]
["myMoney "]
["myLearning "]
["Profile "]
[]
["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: 11/10/2021"]
[null,"This week","Month ago","Year ago"]
["One-Year Treasury Constant Maturity",0.14000000000000001,0.1,0.12]
["91-day T-bill auction avg disc rate",0.05,0.04,0.1]
["182-day T-bill auction avg disc rate",7.0000000000000007E-2,0.06,0.11]
["Two-Year Treasury Constant Maturity",0.41,0.35,0.19]
["Five-Year Treasury Constant Maturity",1.08,1.08,0.46]
["Ten-Year Treasury Constant Maturity",1.46,1.59,0.98]
["One-Year CMT (Monthly)",0.11,0.08,0.13]
["One-Year MTA",0.08,0.08,0.62]
[]
["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"]
[]
["About us"]
["Press room"]
["Careers"]
["Advertise with us"]
["Site map"]
[]
["Help"]
[]
["Contact us"]
["Compare rates"]
["Latest news"]
["Popular topics"]
["Glossary"]
[]
["Legal"]
[]
["Privacy policy / California privacy policy"]
["Cookie Settings"]
["Do not sell my info"]
["Understanding Bankrate’s averages"]
["Terms of use"]
["GLBA annual notice"]
["Licenses"]
[]
["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."]
[]
["Bankrate, LLC NMLS ID# 1427381 | NMLS Consumer Access"]
["BR Tech Services, Inc. NMLS ID #1743443 | NMLS Consumer Access"]
[]
["Facebook Twitter Instagram "]
["Bankrate US | UK"]
[]
["© 2021 Bankrate, LLC. A Red Ventures company. All Rights Reserved."]

{"sheet":"CFlow","index":6,"n_rows":402,"n_cols":10,"rows_kept":402,"cut":false,"hidden":true,"merged":[]}
[{"$f":"Analysis!E2","v":"fb"}]
["Skip to main content"]
["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 of Service."]
["I accept X"]
["Zacks Investment Research Home"]
[]
["Join"]
["Sign In"]
["Member Sign In"]
["Username or Email Address"]
["Password"]
["Keep Me Signed In What does \"Remember Me\" do?"]
["Don't Know Your Password?"]
["Close this window"]
[]
["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"]
[]
["Crypto"]
["Earnings Earnings"]
[]
["Earnings"]
["Earnings Calendar"]
["Earnings Releases"]
["Earnings ESP"]
["Earnings ESP Filter"]
[]
["Screening Screening"]
[]
["Screening"]
["Stock Screener"]
["Mutual Fund Screener"]
["ETF Screener"]
["Premium Screens"]
["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"]
["Testimonials"]
["Zacks.com Tutorial"]
[]
["Video"]
["Podcasts"]
["Services Services"]
["Close Services menu"]
["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"]
["Headline Trader"]
["Insider Trader"]
["Large-Cap Trader"]
["Options Trader"]
["Short Sell List"]
["Surprise Trader"]
["TAZR"]
[]
["Innovators"]
[]
[]
["Blockchain"]
["Commodity"]
["Healthcare"]
["Marijuana"]
["Technology"]
[]
["Quote or Search Search"]
[]
["Join"]
[]
["Sign In"]
[]
["Member Sign In"]
["Username or Email Address"]
["Password"]
["Keep Me Signed In What does \"Remember Me\" do?"]
["Don't Know Your Password?"]
["Close this window"]
[]
["Help"]
[]
["Zacks Investment Research Home"]
["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 "]
["* indicates the important links in the menu"]
[]
["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 Dates and Announcements"]
["Key Company Metrics"]
["Broker Reports "]
["Insiders "]
["Earnings Transcripts"]
["Dividend History"]
[]
["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"]
[]
["Meta Platforms, Inc. (FB)"]
["(Delayed Data from NSDQ)"]
["$340.89 USD"]
[340.89]
[25396115]
["+13.15 (4.01%)"]
["Updated Nov 12, 2021 04:00 PM ET"]
["Add to portfolio"]
["Zacks Rank:"]
["More Info"]
["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.2535]
[2,"Buy",0.19]
[3,"Hold",0.1062]
[4,"Sell",6.3E-2]
[5,"Strong Sell",3.04E-2]
["S&P",500,0.1124]
["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"]
["4-Sell of 5       4  "]
["Style Scores:"]
["More Info"]
["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"]
["B Value | A Growth | B Momentum | A VGM"]
["Industry Rank:"]
["More Info"]
["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"]
["Bottom 25% (191 out of 253)"]
["Industry: Internet - Software"]
["Zacks Premium FeatureView All Zacks #1 Ranked Stocks"]
["Trades from $1 "]
["Meta Platforms, Inc. (FB) Quote Overview » Financials » Meta Platforms, Inc. (FB) Cash flow Statements "]
["Cash flow Statements"]
["Enter Symbol"]
["Research for FB"]
["More Info"]
["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 Meta Platforms Inc. falls in the month of December."]
["All data in Millions except Per Share data."]
["Cash Flow From Operations, Investments & Financial Activities"]
[null,44196,43830,43465,43100,42735]
["Cash Flow From Operations, Investments & Financial"]
["Activities"]
["Net Income (Loss)",29146,18485,22112,15934,10217]
["Depreciation/Amortization & Depletion",6862,5741,4315,3025,2342]
["Net Change from Assets/Liabilities",-2723,"1919-11-06",-1527,"1905-03-01","1902-01-27"]
["Net Cash from Discontinued Operations",0,0,0,0,0]
["Other Operating Activities",5462,4838,4374,3370,2791]
["Net Cash From Operating Activities",38747,36314,29274,24216,16108]
["Property & Equipment",-15115,-15102,-13915,-6733,-4491]
["Acquisition/ Disposition of Subsidiaries",-388,-508,-137,-122,-123]
["Investments",-14520,-4193,2474,-13250,-7186]
["Other Investing Activities",-36,-61,-25,67,61]
["Net Cash from Investing Activities",-30059,-19864,-11603,-20038,-11739]
["Uses of Funds"]
[null,44196,43830,43465,43100,42735]
["Issuance (Repurchase) of Capital Stock",-6272,-4202,-12879,-1976,0]
["Issuance (Repayment) of Debt",-604,-552,0,0,-312]
["Increase (Decrease) Short-Term Debt",0,0,0,0,0]
["Payment of Dividends & Other Distributions",0,0,0,0,0]
["Other Financing Activities",-3416,-2545,-2693,-3259,2]
["Net Cash from Financing Activities",-10292,-7299,-15572,-5235,-310]
["Effect of Exchange Rate Changes",279,4,-179,233,-63]
["Net Change In Cash & Equivalents",-1325,9155,1920,-824,3996]
["Cash at Beginning of Period",19279,10124,8204,8903,4907]
["Cash at End of Period",17954,19279,10124,8079,8903]
["Diluted Net EPS",10.09,6.43,7.57,5.39,3.49]
["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",null,null,null,null,null,null,null,"bats","aapl"]
["About Zacks",null,null,null,null,null,null,null,"bats","ccl"]
["Privacy Policy"]
["Do Not Sell My Personal Information",null,null,null,null,null,null,null,10.31,"CCL"]
["Terms of Service",null,null,null,null,null,null,null,242.46,"aapl"]
["Performance Disclosure"]
["Accessibility"]
["Site Map"]
["Podcasts"]
["Earnings Calendar"]
["Client Support"]
["Contact Us"]
["Share Feedback"]
["Media"]
["Careers"]
["Advertise"]
["Testimonials"]
["Follow Us"]
["Facebook"]
["Twitter"]
["Linkedin"]
["You Tube"]
["Zacks Mobile App"]
["Download our Zacks App from the Apple App Store"]
["Download our Zacks App from Google Play"]
["Zacks Research is Reported On:"]
[]
["MSN"]
["Marketwatch"]
["Nasdaq"]
["Forbes"]
["Investors.com"]
["Morningstar"]
[]
["Reviewed by Accessible360 "]
["Zacks Investment Research is an A+ Rated BBB Accredited Business"]
["This page has not been authorized, sponsored, or otherwise approved or endorsed by the companies represented herein. Each of the company logos represented herein are trademarks of Microsoft Corporation; Dow Jones & Company; Nasdaq, Inc.; Forbes Media, LLC; Investor's Business Daily, Inc.; and Morningstar, Inc."]
["Copyright 2021 Zacks Investment Research | 10 S Riverside Plaza Suite #1600 | Chicago, IL 60606"]
["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.35% per year. These returns cover a period from January 1, 1988 through October 4, 2021. 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. Zacks 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 Disclosure 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."]
["This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply."]
["Due to inactivity, you will be"]
["signed out in approximately:"]
["CLICK TO CONTINUE WORKING"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,55256,"AAPL"]
[null,null,null,null,null,null,null,2160,"CCL"]

{"sheet":"G-1","index":7,"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":8,"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":9,"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":"This company has not reported any Inventories"}]
["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":10,"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":11,"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":12,"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":14.13536201469045},{"$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":13,"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":14,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"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":15,"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":16,"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":17,"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-7a","index":18,"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":19,"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":20,"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":"This company has no Inventories, therefore Quick Ratio and Current Ratio values are the same"}]
["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 "]