{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["DCF Model","Income Statement","Balance Sheet","Cash Flow","Key Stats","S&P data","Treasury yield"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":256,"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":"DCF Model","index":0,"n_rows":68,"n_cols":8,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,7,0,8],[0,1,0,6],[4,0,4,8],[5,0,5,8],[13,5,13,6],[14,5,14,6],[18,0,18,8],[19,0,19,8],[31,0,31,8],[17,0,17,8],[30,0,30,8],[32,0,32,8],[43,0,43,8],[44,0,44,8],[50,3,50,6],[66,4,66,6],[47,3,47,7],[59,0,59,8],[58,0,58,8],[45,0,45,8],[60,0,60,8]]}
["December 6th, 2012","                      Discounted Cash Flow Model                    ",null,null,null,null,null,"By Ryan Hutchins     "]
[]
[null,null,null,"Company Ticker"]
[]
[]
["Discount Rate (Required Rate of Return)"]
[]
[]
["Beta "]
["Market Return"]
["Risk Free Rate"]
["General market risk premium"]
["Ke Regardless "]
["ke = rf + beta(risk premium)",null,null,null,null,"Use Ke Regardless?"]
["Use cash in FCF Calulations? (Y/N)",null,null,null,null,"Use Cash in FCF?"]
[]
["Current Price"]
[]
[]
[{"$f":"\"Weighted Average Cost of Capital using Market Weights for \"&TEXT(C3,\"MMM-YYYY\")","v":"Weighted Average Cost of Capital using Market Weights for Jan-1900"}]
[]
[null,null,null,null,"Rate","1- Tax","Rate AT"]
["Cost of Equity (Ke) - from above"]
["Cost of Debt (Kd) - from 2011"]
["   rate to Add from Current Debt %"]
[]
["    Weight of Debt (LTD/Enterprise Value)"]
["    Weight of Equity (1-weight of debt)"]
["Weighted Average Cost of Capital"]
["  WACC = (Wd+Kd) + (We*Ke)"]
[]
[]
["Free Cash Flow to the Firm"]
[]
[]
["EBIT "]
["- Taxes"]
["EBIT after tax"]
["+ Depreciation Expense (from CFO line 1)"]
["- Capital Expenditures (change in Gross PP&E)"]
["- Change in Net Working Capital (-(WCCF-PrevWCCF) "]
["Operating Free Cash Flow (after tax)"]
[]
[]
[]
["Intrinsic Value"]
[]
["Estimated constant growth period rate: G"]
[]
["Free Cash Flow to the Firm (FCFF)"]
[null,null,null,"Operating Free Cash Flows"]
["Operating Free Cash Flows",null,null,null,null,null,"Future"]
["Present Value of Firm"]
["  Minus:  Debt"]
["  Plus:    Cash & CE"]
["Value of Equity"]
["Shares Outstanding "]
["Intrinsic Value"]
[]
[]
["Recommendation"]
[]
["WACC",null,null,"1 Yr Value","3 Yr Value","Cont. Value","Tot. Value"]
["Present Value of FCFF"]
["  % of Total Value"]
["Valuation:  WACC= 0.0%"]
["Current Price",null,{"$f":"D17","v":0},null,"Discounted at the firms WACC"]
["Under (over) valued (IV/Price)",null,null,null,"Recommendation",null,{"$f":"IF(C68=\"NA\",\"NA\",IF(C68>0.1,\"  Buy\",IF(C68<-0.1,\"  Sell\",\"  Hold\")))","v":"  Hold"}]

{"sheet":"Income Statement","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Balance Sheet","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Cash Flow","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Key Stats","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"S&P data","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Treasury yield","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}