{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Data Entry","Income_Statement","Balance_Sheet","Cash_Flow","Ratios"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data Entry","index":0,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Input Data in positive numbers"]
[]
[null,null,null,null,"Fiscal Year"]
[null,"INPUT ITEMS",null,null,2009,2010,2011]
[]
[null,"INCOME STATEMENT"]
[]
[null,null,"Sales",null,10000000,12000000,20000000]
[null,null,"Costs of Goods Sold (COGS)",null,5000000,7000000,14000000]
[]
[null,"Other Expenses"]
[null,null,"R&D Expense",null,500000,500000,500000]
[null,null,"SG&A Expense",null,1000000,1000000,1000000,null,"If the company is publicly-traded, what is the Ticker?"]
[null,null,"Other Operating Expenses",null,200000,200000,200000,null,"Ticker:","AAPL"]
[]
[null,null,"Depreciation Expense",null,200000,200000,200000]
[null,null,"Interest Expense",null,500000,500000,500000]
[]
[null,null,"Tax Rate"]
[null,null,"Tax Expense",null,100000,100000,100000]
[]
[null,"BALANCE SHEET"]
[]
[null,"Assets"]
[null,null,"Cash",null,2000000,2000000,2000000]
[null,null,"Accounts Receivable",null,5000000,5000000,5000000]
[null,null,"Inventory",null,7000000,7000000,7000000]
[null,null,"Other Current Assets",null,1000000,1000000,1000000]
[]
[null,null,"Net PP&E",null,20000000,20000000,20000000]
[]
[null,"Liabilities"]
[null,null,"Accounts Payable",null,4000000,4000000,4000000]
[null,null,"Short Term Notes Payable",null,5000000,5000000,5000000]
[null,null,"Other Current Liabilities",null,2000000,2000000,2000000]
[]
[null,null,"Bank Loans & LT Debt",null,10000000,10000000,10000000]
[]
[null,"Owner's Equity"]
[null,null,"Common Stock",null,1000000,1000000,1000000]
[null,null,"Preferred Stock",null,2000000,2000000,2000000]
[null,null,"Retained Earnings",null,11000000,11000000,11000000]
[]
[null,null,"Capital Expenditures (for CF statement)",null,200000,200000,200000]

{"sheet":"Income_Statement","index":1,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Historical Income Statement",null,null,"Fiscal Year"]
[null,null,null,null,{"$f":"'Data Entry'!E5","v":2009},{"$f":"'Data Entry'!F5","v":2010},{"$f":"'Data Entry'!G5","v":2011},null,"CAGR"]
[]
[null,"Revenues",null,null,{"$f":"'Data Entry'!E9","v":10000000},{"$f":"'Data Entry'!F9","v":12000000},{"$f":"'Data Entry'!G9","v":20000000},null,{"$f":"RATE($G$3-$E$3,,E5,-G5)","v":0.41421356237309509}]
[null,null,"COGS",null,{"$f":"-'Data Entry'!E10","v":-5000000},{"$f":"-'Data Entry'!F10","v":-7000000},{"$f":"-'Data Entry'!G10","v":-14000000}]
[null,"Gross Profit",null,null,{"$f":"SUM(E5:E6)","v":5000000},{"$f":"SUM(F5:F6)","v":5000000},6000000]
[null,"Other Expenses"]
[null,null,"R&D",null,{"$f":"-'Data Entry'!E13","v":-500000},{"$f":"-'Data Entry'!F13","v":-500000},{"$f":"-'Data Entry'!G13","v":-500000}]
[null,null,"SG&A",null,{"$f":"-'Data Entry'!E14","v":-1000000},{"$f":"-'Data Entry'!F14","v":-1000000},{"$f":"-'Data Entry'!G14","v":-1000000}]
[null,null,"Other",null,{"$f":"-'Data Entry'!E15","v":-200000},{"$f":"-'Data Entry'!F15","v":-200000},{"$f":"-'Data Entry'!G15","v":-200000}]
[null,"EBITDA",null,null,{"$f":"E7+SUM(E9:E11)","v":3300000},{"$f":"F7+SUM(F9:F11)","v":3300000},4300000,null,{"$f":"RATE($G$3-$E$3,,E12,-G12)","v":0.14150352738408267}]
[null,null,"Depreciation Expense",null,{"$f":"-'Data Entry'!E17","v":-200000},{"$f":"-'Data Entry'!F17","v":-200000},{"$f":"-'Data Entry'!G17","v":-200000}]
[null,null,"Interest Expense",null,{"$f":"-'Data Entry'!E18","v":-500000},{"$f":"-'Data Entry'!F18","v":-500000},{"$f":"-'Data Entry'!G18","v":-500000}]
[null,"Profit (Loss) Before Tax",null,null,{"$f":"E12-SUM(E13:E14)","v":4000000},{"$f":"F12-SUM(F13:F14)","v":4000000},5000000]
[null,null,"Taxes",null,{"$f":"-'Data Entry'!E21","v":-100000},{"$f":"-'Data Entry'!F21","v":-100000},{"$f":"-'Data Entry'!G21","v":-100000}]
[null,"Net Profit (Loss)",null,null,{"$f":"E15+E16","v":3900000},{"$f":"F15+F16","v":3900000},4900000,null,{"$f":"RATE($G$3-$E$3,,E17,-G17)","v":0.12089707663560997}]
[]
[]
[null,"Ratios"]
[]
[null,"Gross Margin",null,null,{"$f":"E7/E5","v":0.5},{"$f":"F7/F5","v":0.41666666666666669},0.3]
[null,"EBITDA Margin",null,null,{"$f":"E12/E5","v":0.33},{"$f":"F12/F5","v":0.27500000000000002},0.215]
[null,"Net Margin",null,null,{"$f":"E17/E5","v":0.39},{"$f":"F17/F5","v":0.32500000000000001},0.245]

{"sheet":"Balance_Sheet","index":2,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Historical Balance Sheet",null,null,"Fiscal Year End,"]
[null,null,null,null,{"$f":"'Data Entry'!E5","v":2009},{"$f":"'Data Entry'!F5","v":2010},{"$f":"'Data Entry'!G5","v":2011}]
[]
[null,"Assets"]
[null,"Current Assets"]
[null,null,"Cash",null,{"$f":"'Data Entry'!E26","v":2000000},{"$f":"'Data Entry'!F26","v":2000000},{"$f":"'Data Entry'!G26","v":2000000}]
[null,null,"Accounts Receivable",null,{"$f":"'Data Entry'!E27","v":5000000},{"$f":"'Data Entry'!F27","v":5000000},{"$f":"'Data Entry'!G27","v":5000000}]
[null,null,"Inventory",null,{"$f":"'Data Entry'!E28","v":7000000},{"$f":"'Data Entry'!F28","v":7000000},{"$f":"'Data Entry'!G28","v":7000000}]
[null,null,"Other Current Assets",null,{"$f":"'Data Entry'!E29","v":1000000},{"$f":"'Data Entry'!F29","v":1000000},{"$f":"'Data Entry'!G29","v":1000000}]
[null,null,"Total Current Assets",null,{"$f":"SUM(E7:E10)","v":15000000},{"$f":"SUM(F7:F10)","v":15000000},15000000]
[null,"Fixed Assets"]
[null,null,"Net PP&E",null,{"$f":"'Data Entry'!E31","v":20000000},{"$f":"'Data Entry'!F31","v":20000000},{"$f":"'Data Entry'!G31","v":20000000}]
[null,null,"Total Fixed Assets",null,{"$f":"SUM(E13)","v":20000000},{"$f":"SUM(F13)","v":20000000},20000000]
[]
[null,"Total Assets",null,null,{"$f":"E11+E14","v":35000000},{"$f":"F11+F14","v":35000000},35000000]
[]
[null,"Liabilities"]
[null,"Current Liabilities"]
[null,null,"Accounts Payable",null,{"$f":"'Data Entry'!E34","v":4000000},{"$f":"'Data Entry'!F34","v":4000000},{"$f":"'Data Entry'!G34","v":4000000}]
[null,null,"Short Term Notes Payable",null,{"$f":"'Data Entry'!E35","v":5000000},{"$f":"'Data Entry'!F35","v":5000000},{"$f":"'Data Entry'!G35","v":5000000}]
[null,null,"Other Current Liabilities",null,{"$f":"'Data Entry'!E36","v":2000000},{"$f":"'Data Entry'!F36","v":2000000},{"$f":"'Data Entry'!G36","v":2000000}]
[null,null,"Total Current Liabilities",null,{"$f":"SUM(E20:E22)","v":11000000},{"$f":"SUM(F20:F22)","v":11000000},11000000]
[null,"Long-Term Liabilities"]
[null,null,"Bank Loans & LT Debt",null,{"$f":"'Data Entry'!E38","v":10000000},{"$f":"'Data Entry'!F38","v":10000000},{"$f":"'Data Entry'!G38","v":10000000}]
[null,null,"Total LT Liabilities",null,{"$f":"SUM(E25)","v":10000000},{"$f":"SUM(F25)","v":10000000},10000000]
[]
[null,"Total Liabilities",null,null,{"$f":"E23+E26","v":21000000},{"$f":"F23+F26","v":21000000},21000000]
[]
[null,"Owner's Equity"]
[null,null,"Common Stock",null,{"$f":"'Data Entry'!E41","v":1000000},{"$f":"'Data Entry'!F41","v":1000000},{"$f":"'Data Entry'!G41","v":1000000}]
[null,null,"Preferred Stock",null,{"$f":"'Data Entry'!E42","v":2000000},{"$f":"'Data Entry'!F42","v":2000000},{"$f":"'Data Entry'!G42","v":2000000}]
[null,null,"Retained Earnings",null,{"$f":"'Data Entry'!E43","v":11000000},{"$f":"'Data Entry'!F43","v":11000000},{"$f":"'Data Entry'!G43","v":11000000}]
[null,null,"Total Owner's Equity",null,{"$f":"SUM(E31:E33)","v":14000000},{"$f":"SUM(F31:F33)","v":14000000},14000000]
[]
[null,"Total Liabilities & Owner's Equity",null,null,{"$f":"E28+E34","v":35000000},{"$f":"F28+F34","v":35000000},35000000]
[]
[]
[null,"Check",null,null,{"$f":"E16-E36","v":0},{"$f":"F16-F36","v":0},0]
[]
[]
[null,"Ratios"]
[null,"Current Ratio",null,null,{"$f":"E11/E23","v":1.3636363636363635},{"$f":"F11/F23","v":1.3636363636363635},1.3636363636363635]
[null,"Quick Ratio",null,null,{"$f":"(E11-E9)/E23","v":0.72727272727272729},{"$f":"(F11-F9)/F23","v":0.72727272727272729},0.72727272727272729]
[null,"Debt Ratio",null,null,{"$f":"E28/E16","v":0.6},{"$f":"F28/F16","v":0.6},0.6]

{"sheet":"Cash_Flow","index":3,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Historical Cash Flow Statement",null,null,null,"Fiscal Year"]
[null,null,null,null,null,{"$f":"'Data Entry'!F5","v":2010},{"$f":"'Data Entry'!G5","v":2011}]
[]
[null,"Net Income",null,null,null,{"$f":"'Data Entry'!F9-'Data Entry'!F10-'Data Entry'!F13-'Data Entry'!F14-'Data Entry'!F15-'Data Entry'!F17-'Data Entry'!F18-'Data Entry'!F21","v":2500000},{"$f":"'Data Entry'!G9-'Data Entry'!G10-'Data Entry'!G13-'Data Entry'!G14-'Data Entry'!G15-'Data Entry'!G17-'Data Entry'!G18-'Data Entry'!G21","v":3500000}]
[null,null,"+ Depreciation",null,null,{"$f":"'Data Entry'!F17","v":200000},{"$f":"'Data Entry'!G17","v":200000}]
[null,null,"Change Accounts Receivable",null,null,{"$f":"'Data Entry'!E27-'Data Entry'!F27","v":0},{"$f":"'Data Entry'!F27-'Data Entry'!G27","v":0}]
[null,null,"Change Inventory",null,null,{"$f":"'Data Entry'!E28-'Data Entry'!F28","v":0},{"$f":"'Data Entry'!F28-'Data Entry'!G28","v":0}]
[null,null,"Change Other Current Assets",null,null,{"$f":"'Data Entry'!E29-'Data Entry'!F29","v":0},{"$f":"'Data Entry'!F29-'Data Entry'!G29","v":0}]
[null,null,"Change Accounts Payable",null,null,{"$f":"'Data Entry'!F34-'Data Entry'!E34","v":0},{"$f":"'Data Entry'!G34-'Data Entry'!F34","v":0}]
[null,null,"Change Other Current Liabilities",null,null,{"$f":"'Data Entry'!F36-'Data Entry'!E36","v":0},{"$f":"'Data Entry'!G36-'Data Entry'!F36","v":0}]
[null,null,null,"Operating Cash Flow",null,{"$f":"SUM(F5:F11)","v":2700000},{"$f":"SUM(G5:G11)","v":3700000}]
[]
[null,"Capital Expenditures",null,null,null,{"$f":"-'Data Entry'!F45","v":-200000},{"$f":"-'Data Entry'!G45","v":-200000}]
[null,null,null,"Investing Cash Flow",null,{"$f":"SUM(F14)","v":-200000},{"$f":"SUM(G14)","v":-200000}]
[]
[null,"Change Short Term Notes",null,null,null,{"$f":"'Data Entry'!F35-'Data Entry'!E35","v":0},{"$f":"'Data Entry'!G35-'Data Entry'!F35","v":0}]
[null,"Change Bank Loans",null,null,null,{"$f":"'Data Entry'!F38-'Data Entry'!E38","v":0},{"$f":"'Data Entry'!G38-'Data Entry'!F38","v":0}]
[null,"Change Common Stock",null,null,null,{"$f":"'Data Entry'!F41-'Data Entry'!E41","v":0},{"$f":"'Data Entry'!G41-'Data Entry'!F41","v":0}]
[null,"Change Preferred Stock",null,null,null,{"$f":"'Data Entry'!F42-'Data Entry'!E42","v":0},{"$f":"'Data Entry'!G42-'Data Entry'!F42","v":0}]
[null,null,null,"Financing Cash Flow",null,{"$f":"SUM(F17:F20)","v":0},{"$f":"SUM(G17:G20)","v":0}]
[]
[null,"Change in Cash",null,null,null,{"$f":"F12+F15+F21","v":2500000},{"$f":"G12+G15+G21","v":3500000}]

{"sheet":"Ratios","index":4,"n_rows":274,"n_cols":13,"rows_kept":274,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Ratio Analysis",null,"Fiscal Year"]
[null,null,null,{"$f":"'Data Entry'!E5","v":2009},{"$f":"'Data Entry'!F5","v":2010},{"$f":"'Data Entry'!G5","v":2011}]
[]
[null,"Liquidity","Current Ratio",{"$f":"('Data Entry'!E26+'Data Entry'!E27+'Data Entry'!E28+'Data Entry'!E29)/(SUM('Data Entry'!E34:E36))","v":1.3636363636363635},{"$f":"('Data Entry'!F26+'Data Entry'!F27+'Data Entry'!F28+'Data Entry'!F29)/(SUM('Data Entry'!F34:F36))","v":1.3636363636363635},{"$f":"('Data Entry'!G26+'Data Entry'!G27+'Data Entry'!G28+'Data Entry'!G29)/(SUM('Data Entry'!G34:G36))","v":1.3636363636363635}]
[null,null,"Quick Ratio",{"$f":"(SUM('Data Entry'!E26:E29)-'Data Entry'!E28)/SUM('Data Entry'!E34:E36)","v":0.72727272727272729},{"$f":"(SUM('Data Entry'!F26:F29)-'Data Entry'!F28)/SUM('Data Entry'!F34:F36)","v":0.72727272727272729},{"$f":"(SUM('Data Entry'!G26:G29)-'Data Entry'!G28)/SUM('Data Entry'!G34:G36)","v":0.72727272727272729}]
[null,null,"Average Collection Period",{"$f":"'Data Entry'!E27/('Data Entry'!E9/365)","v":182.5},{"$f":"'Data Entry'!F27/('Data Entry'!F9/365)","v":152.08333333333334},{"$f":"'Data Entry'!G27/('Data Entry'!G9/365)","v":91.25}]
[null,null,"AR Turnover",{"$f":"'Data Entry'!E9/'Data Entry'!E27","v":2},{"$f":"'Data Entry'!F9/'Data Entry'!F27","v":2.4},{"$f":"'Data Entry'!G9/'Data Entry'!G27","v":4}]
[null,null,"Inventory Turnover",{"$f":"'Data Entry'!E10/'Data Entry'!E28","v":0.7142857142857143},{"$f":"'Data Entry'!F10/'Data Entry'!F28","v":1},{"$f":"'Data Entry'!G10/'Data Entry'!G28","v":2}]
[]
[null,"Efficiency","Total Asset Turnover",{"$f":"'Data Entry'!E9/SUM('Data Entry'!E26:E31)","v":0.2857142857142857},{"$f":"'Data Entry'!F9/SUM('Data Entry'!F26:F31)","v":0.34285714285714286},{"$f":"'Data Entry'!G9/SUM('Data Entry'!G26:G31)","v":0.5714285714285714}]
[null,null,"Fixed Asset Turnover",{"$f":"'Data Entry'!E9/'Data Entry'!E31","v":0.5},{"$f":"'Data Entry'!F9/'Data Entry'!F31","v":0.6},{"$f":"'Data Entry'!G9/'Data Entry'!G31","v":1}]
[null,null,"OIROI",{"$f":"('Data Entry'!E9-'Data Entry'!E10-'Data Entry'!E13-'Data Entry'!E14-'Data Entry'!E15-'Data Entry'!E17)/SUM('Data Entry'!E26:E31)","v":8.8571428571428565E-2},{"$f":"('Data Entry'!F9-'Data Entry'!F10-'Data Entry'!F13-'Data Entry'!F14-'Data Entry'!F15-'Data Entry'!F17)/SUM('Data Entry'!F26:F31)","v":8.8571428571428565E-2},{"$f":"('Data Entry'!G9-'Data Entry'!G10-'Data Entry'!G13-'Data Entry'!G14-'Data Entry'!G15-'Data Entry'!G17)/SUM('Data Entry'!G26:G31)","v":0.11714285714285715}]
[]
[null,"Financing","Debt Ratio",{"$f":"SUM('Data Entry'!E34:E38)/SUM('Data Entry'!E26:E31)","v":0.6},{"$f":"SUM('Data Entry'!F34:F38)/SUM('Data Entry'!F26:F31)","v":0.6},{"$f":"SUM('Data Entry'!G34:G38)/SUM('Data Entry'!G26:G31)","v":0.6}]
[null,null,"Times Interest Earned",{"$f":"('Data Entry'!E9-'Data Entry'!E10-'Data Entry'!E13-'Data Entry'!E14-'Data Entry'!E15-'Data Entry'!E17)/'Data Entry'!E18","v":6.2},{"$f":"('Data Entry'!F9-'Data Entry'!F10-'Data Entry'!F13-'Data Entry'!F14-'Data Entry'!F15-'Data Entry'!F17)/'Data Entry'!F18","v":6.2},{"$f":"('Data Entry'!G9-'Data Entry'!G10-'Data Entry'!G13-'Data Entry'!G14-'Data Entry'!G15-'Data Entry'!G17)/'Data Entry'!G18","v":8.1999999999999993}]
[]
[null,"Profitability","ROA",{"$f":"('Data Entry'!E9-'Data Entry'!E10-'Data Entry'!E13-'Data Entry'!E14-'Data Entry'!E15-'Data Entry'!E17-'Data Entry'!E18-'Data Entry'!E21)/SUM('Data Entry'!E26:E31)","v":7.1428571428571425E-2},{"$f":"('Data Entry'!F9-'Data Entry'!F10-'Data Entry'!F13-'Data Entry'!F14-'Data Entry'!F15-'Data Entry'!F17-'Data Entry'!F18-'Data Entry'!F21)/SUM('Data Entry'!F26:F31)","v":7.1428571428571425E-2},{"$f":"('Data Entry'!G9-'Data Entry'!G10-'Data Entry'!G13-'Data Entry'!G14-'Data Entry'!G15-'Data Entry'!G17-'Data Entry'!G18-'Data Entry'!G21)/SUM('Data Entry'!G26:G31)","v":0.1}]
[null,null,"ROE",{"$f":"('Data Entry'!E9-'Data Entry'!E10-'Data Entry'!E13-'Data Entry'!E14-'Data Entry'!E15-'Data Entry'!E17-'Data Entry'!E18-'Data Entry'!E21)/SUM('Data Entry'!E41:E43)","v":0.17857142857142858},{"$f":"('Data Entry'!F9-'Data Entry'!F10-'Data Entry'!F13-'Data Entry'!F14-'Data Entry'!F15-'Data Entry'!F17-'Data Entry'!F18-'Data Entry'!F21)/SUM('Data Entry'!F41:F43)","v":0.17857142857142858},{"$f":"('Data Entry'!G9-'Data Entry'!G10-'Data Entry'!G13-'Data Entry'!G14-'Data Entry'!G15-'Data Entry'!G17-'Data Entry'!G18-'Data Entry'!G21)/SUM('Data Entry'!G41:G43)","v":0.25}]
[null,null,"Gross Margin",{"$f":"'Data Entry'!E10/'Data Entry'!E9","v":0.5},{"$f":"'Data Entry'!F10/'Data Entry'!F9","v":0.58333333333333337},{"$f":"'Data Entry'!G10/'Data Entry'!G9","v":0.7}]
[null,null,"EBITDA Margin",{"$f":"('Data Entry'!E9-'Data Entry'!E10-'Data Entry'!E13-'Data Entry'!E14-'Data Entry'!E15)/'Data Entry'!E9","v":0.33},{"$f":"('Data Entry'!F9-'Data Entry'!F10-'Data Entry'!F13-'Data Entry'!F14-'Data Entry'!F15)/'Data Entry'!F9","v":0.27500000000000002},{"$f":"('Data Entry'!G9-'Data Entry'!G10-'Data Entry'!G13-'Data Entry'!G14-'Data Entry'!G15)/'Data Entry'!G9","v":0.215}]
[null,null,"Net Profit Margin",{"$f":"('Data Entry'!E9-'Data Entry'!E10-'Data Entry'!E13-'Data Entry'!E14-'Data Entry'!E15-'Data Entry'!E17-'Data Entry'!E18-'Data Entry'!E21)/'Data Entry'!E9","v":0.25},{"$f":"('Data Entry'!F9-'Data Entry'!F10-'Data Entry'!F13-'Data Entry'!F14-'Data Entry'!F15-'Data Entry'!F17-'Data Entry'!F18-'Data Entry'!F21)/'Data Entry'!F9","v":0.20833333333333334},{"$f":"('Data Entry'!G9-'Data Entry'!G10-'Data Entry'!G13-'Data Entry'!G14-'Data Entry'!G15-'Data Entry'!G17-'Data Entry'!G18-'Data Entry'!G21)/'Data Entry'!G9","v":0.17499999999999999}]
[]
[null,"Other","Forward P/E",11.97]
[null,null,"Enterprise Value / EBITDA",11.84]
[null,null,"Beta",1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"AAPL"]
[null,null,null,null,null,null,null,"Skip to search."]
[null,null,null,null,null,null,null,"New User? Register"]
[null,null,null,null,null,null,null,"Sign In"]
[null,null,null,null,null,null,null,"Help"]
[null,null,null,null,null,null,null,"Preview Mail w/ Y! Toolbar"]
[]
[null,null,null,null,null,null,null,"Notifications Help"]
[]
[null,null,null,null,null,null,null,"Mail"]
[null,null,null,null,null,null,null,"My Y! "]
[null,null,null,null,null,null,null,"Yahoo!"]
[null,null,null,null,null,null,null,"Yahoo! Finance "]
[null,null,null,null,null,null,null,"Search","Search Web"]
[]
[null,null,null,null,null,null,null,"Home"]
[null,null,null,null,null,null,null,"Investing"]
[]
[null,null,null,null,null,null,null,"Market Overview"]
[null,null,null,null,null,null,null,"Market Stats"]
[null,null,null,null,null,null,null,"Stocks"]
[null,null,null,null,null,null,null,"Mutual Funds"]
[null,null,null,null,null,null,null,"ETFs"]
[null,null,null,null,null,null,null,"Bonds"]
[null,null,null,null,null,null,null,"Options"]
[null,null,null,null,null,null,null,"Industries"]
[null,null,null,null,null,null,null,"Currencies"]
[null,null,null,null,null,null,null,"Education"]
[null,null,null,null,null,null,null,"Commodities"]
[null,null,null,null,null,null,null,"News"]
[]
[null,null,null,null,null,null,null,"Markets"]
[null,null,null,null,null,null,null,"Investing Ideas"]
[null,null,null,null,null,null,null,"Special Editions"]
[null,null,null,null,null,null,null,"Company Finances"]
[null,null,null,null,null,null,null,"Video"]
[null,null,null,null,null,null,null,"Photos & Interactives"]
[null,null,null,null,null,null,null,"RSS Feeds"]
[null,null,null,null,null,null,null,"Personal Finance"]
[]
[null,null,null,null,null,null,null,"Saving & Spending"]
[null,null,null,null,null,null,null,"Career & Education"]
[null,null,null,null,null,null,null,"Lifestyle"]
[null,null,null,null,null,null,null,"Insurance"]
[null,null,null,null,null,null,null,"Loans"]
[null,null,null,null,null,null,null,"Real Estate"]
[null,null,null,null,null,null,null,"Retirement"]
[null,null,null,null,null,null,null,"Taxes"]
[null,null,null,null,null,null,null,"Lifelong Investing"]
[null,null,null,null,null,null,null,"GLOSSARY"]
[null,null,null,null,null,null,null,"My Portfolios"]
[]
[null,null,null,null,null,null,null,"Sign in to access My Portfolios"]
[null,null,null,null,null,null,null,"Free trial of Real-Time Quotes"]
[null,null,null,null,null,null,null,"EXCLUSIVES"]
[]
[null,null,null,null,null,null,null,"Breakout"]
[null,null,null,null,null,null,null,"The Daily Ticker"]
[null,null,null,null,null,null,null,"Daniel Gross"]
[null,null,null,null,null,null,null,"Financially Fit"]
[null,null,null,null,null,null,null,"FANTASY FINANCE"]
[null,null,null,null,null,null,null,"Search for share prices"]
[null,null,null,null,null,null,null,"Search for share prices"]
[null,null,null,null,null,null,null,"Wed, Apr 18, 2012, 1:38PM EDT - U.S. Markets close in 2 hrs 22 mins"]
[null,null,null,null,null,null,null," Dow Down 0.57% Nasdaq Down 0.47%"]
[]
[null,null,null,null,null,null,null,"More On AAPL"]
[null,null,null,null,null,null,null,"Quotes"]
[null,null,null,null,null,null,null,"Summary"]
[null,null,null,null,null,null,null,"Order Book"]
[null,null,null,null,null,null,null,"Options"]
[null,null,null,null,null,null,null,"Historical Prices"]
[null,null,null,null,null,null,null,"Charts"]
[null,null,null,null,null,null,null,"Interactive"]
[null,null,null,null,null,null,null,"Basic Chart"]
[null,null,null,null,null,null,null,"Basic Tech. Analysis"]
[null,null,null,null,null,null,null,"News & Info"]
[null,null,null,null,null,null,null,"Headlines"]
[null,null,null,null,null,null,null,"Financial Blogs"]
[null,null,null,null,null,null,null,"Company Events"]
[null,null,null,null,null,null,null,"Message Boards"]
[null,null,null,null,null,null,null,"Market Pulse"]
[null,null,null,null,null,null,null,"Company"]
[null,null,null,null,null,null,null,"Profile"]
[null,null,null,null,null,null,null,"Key Statistics"]
[null,null,null,null,null,null,null,"SEC Filings"]
[null,null,null,null,null,null,null,"Competitors"]
[null,null,null,null,null,null,null,"Industry"]
[null,null,null,null,null,null,null,"Components"]
[null,null,null,null,null,null,null,"Analyst Coverage"]
[null,null,null,null,null,null,null,"Analyst Opinion"]
[null,null,null,null,null,null,null,"Analyst Estimates"]
[null,null,null,null,null,null,null,"Research Reports"]
[null,null,null,null,null,null,null,"Star Analysts"]
[null,null,null,null,null,null,null,"Ownership"]
[null,null,null,null,null,null,null,"Major Holders"]
[null,null,null,null,null,null,null,"Insider Transactions"]
[null,null,null,null,null,null,null,"Insider Roster"]
[null,null,null,null,null,null,null,"Financials"]
[null,null,null,null,null,null,null,"Income Statement"]
[null,null,null,null,null,null,null,"Balance Sheet"]
[null,null,null,null,null,null,null,"Cash Flow"]
[null,null,null,null,null,null,null,null,null,"Advertisement"]
[]
[null,null,null,null,null,null,null,"Apple Inc. (AAPL)"]
[]
[null,null,null,null,null,null,null,"-NasdaqGS "]
[null,null,null,null,null,null,null,"604.53 Down5.17(0.85%) 1:38PM EDT - Nasdaq Real Time Price"]
[null,null,null,null,null,null,null,"Add to Portfolio"]
[null,null,null,null,null,null,null,"Key Statistics",null,"Get Key Statistics for: "]
[null,null,null,null,null,null,null,"Data provided by Capital IQ, except where noted.",null,null,null,"AdChoices"]
[null,null,null,null,null,null,null,"Valuation Measures"]
[null,null,null,null,null,null,null,"Market Cap (intraday)5:","565.22B"]
[null,null,null,null,null,null,null,"Enterprise Value (Apr 18, 2012)3:","538.31B",null,null,"Trading Information"]
[null,null,null,null,null,null,null,"Trailing P/E (ttm, intraday):",17.25,null,null,"Stock Price History"]
[null,null,null,null,null,null,null,"Forward P/E (fye Sep 24, 2013)1:",11.97,null,null,"Beta:",1]
[null,null,null,null,null,null,null,"PEG Ratio (5 yr expected)1:",0.73,null,null,"52-Week Change3:",0.80459999999999998]
[null,null,null,null,null,null,null,"Price/Sales (ttm):",4.45,null,null,"S&P500 52-Week Change3:",5.9499999999999997E-2]
[null,null,null,null,null,null,null,"Price/Book (mrq):",6.31,null,null,"52-Week High (Apr 10, 2012)3:",644]
[null,null,null,null,null,null,null,"Enterprise Value/Revenue (ttm)3:",4.21,null,null,"52-Week Low (Jun 20, 2011)3:",310.5]
[null,null,null,null,null,null,null,"Enterprise Value/EBITDA (ttm)6:",11.84,null,null,"50-Day Moving Average3:",586.76]
[null,null,null,null,null,null,null,"Financial Highlights",null,null,null,"200-Day Moving Average3:",460.57]
[null,null,null,null,null,null,null,"Fiscal Year",null,null,null,"Share Statistics"]
[null,null,null,null,null,null,null,"Fiscal Year Ends:","2012-09-24",null,null,"Avg Vol (3 month)3:",22173900]
[null,null,null,null,null,null,null,"Most Recent Quarter (mrq):","2011-12-31",null,null,"Avg Vol (10 day)3:",29252200]
[null,null,null,null,null,null,null,"Profitability",null,null,null,"Shares Outstanding5:","932.37M"]
[null,null,null,null,null,null,null,"Profit Margin (ttm):",0.25800000000000001,null,null,"Float:","931.67M"]
[null,null,null,null,null,null,null,"Operating Margin (ttm):",0.3387,null,null,"% Held by Insiders1:",6.4000000000000003E-3]
[null,null,null,null,null,null,null,"Management Effectiveness",null,null,null,"% Held by Institutions1:",0.70199999999999996]
[null,null,null,null,null,null,null,"Return on Assets (ttm):",0.24010000000000001,null,null,"Shares Short (as of Mar 30, 2012)3:","9.68M"]
[null,null,null,null,null,null,null,"Return on Equity (ttm):",0.45579999999999998,null,null,"Short Ratio (as of Mar 30, 2012)3:",0.4]
[null,null,null,null,null,null,null,"Income Statement",null,null,null,"Short % of Float (as of Mar 30, 2012)3:",0.01]
[null,null,null,null,null,null,null,"Revenue (ttm):","127.84B",null,null,"Shares Short (prior month)3:","9.87M"]
[null,null,null,null,null,null,null,"Revenue Per Share (ttm):",137.88,null,null,"Dividends & Splits"]
[null,null,null,null,null,null,null,"Qtrly Revenue Growth (yoy):",0.73299999999999998,null,null,"Forward Annual Dividend Rate4:","N/A"]
[null,null,null,null,null,null,null,"Gross Profit (ttm):","43.82B",null,null,"Forward Annual Dividend Yield4:","N/A"]
[null,null,null,null,null,null,null,"EBITDA (ttm)6:","45.45B",null,null,"Trailing Annual Dividend Yield3:","N/A"]
[null,null,null,null,null,null,null,"Net Income Avl to Common (ttm):","32.98B",null,null,"Trailing Annual Dividend Yield3:","N/A"]
[null,null,null,null,null,null,null,"Diluted EPS (ttm):",35.14,null,null,"5 Year Average Dividend Yield4:","N/A"]
[null,null,null,null,null,null,null,"Qtrly Earnings Growth (yoy):",1.1759999999999999,null,null,"Payout Ratio4:","N/A"]
[null,null,null,null,null,null,null,"Balance Sheet",null,null,null,"Dividend Date3:","N/A"]
[null,null,null,null,null,null,null,"Total Cash (mrq):","30.16B",null,null,"Ex-Dividend Date4:","1995-11-21"]
[null,null,null,null,null,null,null,"Total Cash Per Share (mrq):",32.340000000000003,null,null,"Last Split Factor (new per old)2:","02:01:00"]
[null,null,null,null,null,null,null,"Total Debt (mrq):",0,null,null,"Last Split Date3:","2005-02-28"]
[null,null,null,null,null,null,null,"Total Debt/Equity (mrq):","N/A"]
[null,null,null,null,null,null,null,"Current Ratio (mrq):",1.58]
[null,null,null,null,null,null,null,"Book Value Per Share (mrq):",96.6]
[null,null,null,null,null,null,null,"Cash Flow Statement"]
[null,null,null,null,null,null,null,"Operating Cash Flow (ttm):","45.31B"]
[null,null,null,null,null,null,null,"Levered Free Cash Flow (ttm):","26.06B"]
[]
[null,null,null,null,null,null,null,"View Financials"]
[null,null,null,null,null,null,null,"Income Statement - Balance Sheet - Cash Flow"]
[null,null,null,null,null,null,null,"See Key Statistics Help for definitions of terms used."]
[null,null,null,null,null,null,null,"Abbreviation Guide: K = Thousands; M = Millions; B = Billions"]
[null,null,null,null,null,null,null,"mrq = Most Recent Quarter (as of Dec 31, 2011) "]
[null,null,null,null,null,null,null,"ttm = Trailing Twelve Months (as of Dec 31, 2011) "]
[null,null,null,null,null,null,null,"yoy = Year Over Year (as of Dec 31, 2011) "]
[null,null,null,null,null,null,null,"lfy = Last Fiscal Year (as of Sep 24, 2011) "]
[null,null,null,null,null,null,null,"fye = Fiscal Year Ending"]
[null,null,null,null,null,null,null,"1 Data provided by Thomson Reuters"]
[null,null,null,null,null,null,null,"2 Data provided by EDGAR Online"]
[null,null,null,null,null,null,null,"3 Data derived from multiple sources or calculated by Yahoo! Finance"]
[null,null,null,null,null,null,null,"4 Data provided by Morningstar, Inc."]
[null,null,null,null,null,null,null,"5 Shares outstanding is taken from the most recently filed quarterly or annual report and Market Cap is calculated using shares outstanding."]
[null,null,null,null,null,null,null,"6 EBITDA is calculated by Capital IQ using methodology that may differ from that used by a company in its reporting"]
[]
[null,null,null,null,null,null,null,"Currency in USD."]
[]
[]
[null,null,null,null,null,null,null,"Copyright © 2012 Yahoo! Inc. All rights reserved. Privacy Policy - About Our Ads - Terms of Service - Copyright/IP Policy - Send Feedback - Yahoo! - ABC News Network"]
[null,null,null,null,null,null,null,"Quotes for NYSE, Nasdaq and NYSEAmex are Real-time and sourced from Nasdaq Last Sale when available. If not available from NLS, quotes will appear delayed from primary listing source."]
[null,null,null,null,null,null,null,"See also delay times for other exchanges. Quotes and other information supplied by independent providers identified on the Yahoo! Finance partner page.Quotes are updated automatically, but will be turned off after 25 minutes of inactivity. Quotes are delayed at least 15 minutes. All information provided \"as is\" for informational purposes only, not intended for trading purposes or advice. Neither Yahoo! nor any of independent providers is liable for any informational errors, incompleteness, or delays, or for any actions taken in reliance on information contained herein. By accessing the Yahoo! site, you agree not to redistribute the information found therein."]
[null,null,null,null,null,null,null,"Fundamental company data provided by Capital IQ. Historical chart data and daily updates provided by Commodity Systems, Inc. (CSI). International historical chart data, daily updates, fund summary, fund performance, dividend data and Morningstar Index data provided by Morningstar, Inc. US Financials data provided by Edgar Online and all other Financials provided by Capital IQ. International historical chart data, daily updates, fundAnalyst estimates data provided by Thomson Financial Network. All data povided by Thomson Financial Network is based solely upon research information provided by third party analysts. Yahoo! has not reviewed, and in no way endorses the validity of such data. Yahoo! and ThomsonFN shall not be liable for any actions taken in reliance thereon."]
[null,null,null,null,null,null,null,95941353]