{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Security Settings","Information","Main-Land Bid Price","Feasibility","Sensitivity Tables","Cash Budgets","Cash Flows","5 Year Model","10 Year Model","30 Year Model","Cash Flow Chart","Yield Chart","Growth Chart"],"not_rendered":{"charts":8,"images":32,"macros":1,"external_links":0,"defined_names":226,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Cash Flow Chart","index":10,"reason":"not_a_worksheet"},{"sheet":"Yield Chart","index":11,"reason":"not_a_worksheet"},{"sheet":"Growth Chart","index":12,"reason":"not_a_worksheet"}],"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":"Security Settings","index":0,"n_rows":73,"n_cols":4,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Warning: Content Blocked!"]
[]
[null,null,"Your Excel security settings are currently blocking some of the features in this FAST spreadsheet."]
[null,null,"The default settings for Microsoft Excel 2003 (and previous versions) and Excel 2007 do not allow"]
[null,null,"Macros contained in this spreadsheet to function properly and need to be changed."]
[]
[null,null,"For step by step instructions of how to change these settings and allow the content to be displayed"]
[null,null,"on your computer, please select either the \"Excel 2003 and Previous\" or \"Excel 2007\" button below."]
[]
[]
[]
[]
[]
[]
[null,null,"Instructions for: Microsoft Excel 2003 and Previous"]
[null,null,"Your Excel security settings must be changed to use FAST Tools.  Using the Excel menu commands, "]
[null,null,"perform the following steps to change your settings. These steps will only need to be performed once to"]
[null,null,"run FAST tools."]
[]
[null,null,"1. Reset Security Settings, select"]
[null,null,null,"Tools"]
[null,null,null,"Macro"]
[null,null,null,"Security"]
[null,null,null,"Medium"]
[]
[null,null,"2. Close this Excel workbook, select"]
[null,null,null,"File"]
[null,null,null,"Close"]
[null,null,null,"Do not save changes"]
[]
[null,null,"3. Reopen the Workbook via FAST menu or "]
[null,null,null,"File"]
[null,null,null,"Open"]
[null,null,null,"\"click on spreadsheet name\""]
[]
[null,null,"4. Click on Enable Macros when you see the dialog box similar to the one below."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Instructions for: Microsoft Excel 2007"]
[null,null,"Microsoft Excel 2007 uses a different method to enable the content in a FAST Spreadsheet. When "]
[null,null,"opening FAST Spreadsheets with Microsoft Excel 2007, a \"Security Warning\" box will appear"]
[null,null,"just below the menu bar at the top left hand corner of the screen. The following steps need to be "]
[null,null,"performed to run FAST programs."]
[]
[null,null,"1. Select the \"Options…\" button to open up Microsoft Office Security Options. "]
[]
[]
[]
[]
[]
[null,null,"2. To allow the FAST Spreadsheet to run properly, you must enable Macros to run by "]
[null,null,"    selecting “Enable this content” in the list of security options."]

{"sheet":"Information","index":1,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":false,"merged":[[48,4,50,4],[46,10,49,10],[3,5,5,10],[8,6,12,9],[21,11,22,12],[6,14,9,14],[3,11,5,11],[44,5,46,5],[18,6,22,9]]}
[]
[]
[]
[null,null,null,null,null,"Land Purchase Analysis"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ISERR(Macros)","v":false}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RAND()","v":0.89753094879804363}]
[null,null,null,"Support Provided By:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"macroCheck(1)*P16","v":0.89753094879804363}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Updated: 9/14/2004"]
[]
[null,null,null,"Updated 3/1/13"]

{"sheet":"Main-Land Bid Price","index":2,"n_rows":30,"n_cols":36,"rows_kept":30,"cut":false,"hidden":false,"merged":[[16,3,16,4],[7,3,7,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[5,3,5,4],[6,3,6,4],[14,3,14,4],[15,3,15,4]]}
[null,"                     Real Estate Purchase Analysis",null,null,null,null,null,null,null,null,{"$f":"IF(ABS(K2-K3)<3.33333333333333E-07*Aprice,0,1)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,1,"150% Declining Balance, half year",null,null,null,"Year","Rate","Depreciation","Remaining Basis"]
[null,"                          Used to determine the maximum bid price of a real estate investment opportunity and sensitivity to terms.",null,null,null,null,null,null,null,null,{"$f":"NPVRange","v":962.02176000000009},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,2,"200% Declining Balance, half year",null,null,null,1,0.1666666716337204,0]
[null,null,null,null,null,null,null,null,null,null,962.02178955078125,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,3,"Straight Line (half year)",null,null,null,2,0.33333332538604737,0]
[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,10,4,"Straight Line (full year)",null,null,null,3,0.33333332538604732,0]
[null,"Real Estate and Investment Information:",null," Financing Information:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,null,null,null,4,0.16666666269302371,0]
[null,"  Analysis price",8000,"    Down payment (%)",null,0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,null,"Straight Line (full year)"]
[null,"  Additional cash flows: year 1",350,"    Annual interest rate on loan (%)",null,0.06,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,null,{"$f":"MATCH(AC6,AC1:AC4,0)","v":4}]
[null," Optional: Enter specific cash flows ",null,"    Length of loan (years)",null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,null,{"$f":"IF(AC7=1,1.5,IF(AC7=2,2,1))","v":1}]
[null,"  Property taxes: year 1",30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,null,0]
[null,"  Annual cash flow growth rate (%)",0.02,"  Investor Information:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,null,{"$f":"(basis-Elect179)*Length","v":0}]
[null,"  Annual appreciation rate of land values (%)",0.02,"     Marginal tax rate (%)",null,0.28000000000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(AC10-temp)","v":0}]
[null,"  Closing fees (% initial purchase)",0.01,"     Capital gains tax rate (%)",null,0.15]
[null,"  Selling fees (% end of horizon)",0.04,"     After-tax discount rate (%)",null,0.04]
[null,"  Amount qualifying for depreciation ",0," Solver Information:"]
[null,"   Length to depreciate (years)",3,"   Investment return sensitivity range (%)",null,0.02]
[null,"   Depreciation method *",null,"   Cash flow sensitivity range (%)",null,0.1]
[null,"   Additional depreciation 1st year (179 election)",0]
[null,"Results"]
[null,"Profitability @ Analysis Price (NPV)",null," Maximum Bid Price"]
[null,"   5 year investment horizon",{"$f":"solve5","v":-164.59},null,"  5 year investment horizon",{"$f":"IF(change=0,'Sensitivity Tables'!H4,\"Click Solve\")","v":6929.9}]
[null,"  10 year investment horizon",{"$f":"solve10","v":22.87},null,"10 year investment horizon",{"$f":"IF(change=0,'Sensitivity Tables'!H5,\"Click Solve\")","v":8091.02}]
[null,"  30 year investment horizon",{"$f":"solve30","v":857.51},null,"30 year investment horizon",{"$f":"IF(change=0,'Sensitivity Tables'!H6,\"Click Solve\")","v":9622.2099999999991}]
[null," Investment Return @ Analysis Price",null," Initial Cash Flow Needed to Achieve Desired Return"]
[null,"   5 year investment horizon",{"$f":"'5 Year Model'!O14","v":2.5502889869823075E-2},null," 5 year investment horizon",{"$f":"IF(change=0,'Sensitivity Tables'!J32,\"Click Solve\")","v":399.41310687939614}]
[null,"  10 year investment horizon",{"$f":"'10 Year Model'!O19","v":4.0845098803794722E-2},null,"10 year investment horizon",{"$f":"IF(change=0,'Sensitivity Tables'!J33,\"Click Solve\")","v":346.40085431654677}]
[null,"  30 year investment horizon",{"$f":"'30 Year Model'!O39","v":4.7521675232664817E-2},null,"30 year investment horizon",{"$f":"IF(change=0,'Sensitivity Tables'!J38,\"Click Solve\")","v":296.05132926919782}]
[null," Cash Flow Growth Rate Needed to Achieve Desired Return",null," Appreciation Rate Needed to Achieve Desired Return"]
[null,"   5 year investment horizon",{"$f":"IF(change=0,'5 Year Model'!O37,\"Click Solve\")","v":9.4695762973893302E-2},null," 5 year investment horizon",{"$f":"IF(change=0,'5 Year Model'!O41,\"Click Solve\")","v":2.560602226161968E-2}]
[null,"  10 year investment horizon",{"$f":"IF(change=0,'10 Year Model'!O42,\"Click Solve\")","v":1.7338091706670104E-2},null,"10 year investment horizon",{"$f":"IF(change=0,'10 Year Model'!O46,\"Click Solve\")","v":1.9565241548574884E-2}]
[null,"  30 year investment horizon",{"$f":"IF(change=0,'30 Year Model'!O61,\"Click Solve\")","v":5.0630839885362966E-3},null,"30 year investment horizon",{"$f":"IF(change=0,'30 Year Model'!O65,\"Click Solve\")","v":1.0923428656204779E-2}]

{"sheet":"Feasibility","index":3,"n_rows":114,"n_cols":22,"rows_kept":114,"cut":false,"hidden":false,"merged":[[42,7,42,10]]}
["Analysis Price Entered As:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculation Section"]
[null,null,"80",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Gross",null,{"$f":"C7","v":478000},{"$f":"C7/(C7-C8)*E74","v":552162.4242424242}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Operating Costs",null,{"$f":"C8","v":313000},{"$f":"C8/C7*V2","v":361562.4242424242}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross"]
[null,"   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.25,null,{"$f":"IF($C$98>0,($S5)*U$2+C$98,\"\")","v":-77750},{"$f":"IF($E$98>0,($S5)*V$2+E$98,\"\")","v":-124290.08036601648}]
["Pre-Investment: Cash Flows & Profitability",null,"Values prior to RE Investment",null,"Subtotals",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S5+0.025","v":-0.22500000000000001},null,{"$f":"IF($C$98>0,($S6)*U$2+C$98,\"\")","v":-65800},{"$f":"IF($E$98>0,($S6)*V$2+E$98,\"\")","v":-110486.01975995587}]
[null,"Gross Revenue",478000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S6+0.025","v":-0.2},null,-53850,-96681.959153895266]
[null,"Operating Expenses ",313000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.17500000000000002,null,-41900.000000000015,-82877.898547834659]
[null,"Depreciation",43912,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.15000000000000002,null,-29950.000000000015,-69073.83794177408]
[null,"Interest Expense on Operating",12500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.12500000000000003,null,-18000.000000000015,-55269.777335713465]
[null,"Interest Expense on Term Debt",19500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.10000000000000003,null,-6050.0000000000146,-41465.716729652864]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-7.5000000000000039E-2,null,5899.9999999999782,-27661.656123592264]
[null,"Net Farm Income From Operations",null,null,{"$f":"C7-C8-C9-C10-C11","v":89088},null,null,null,null,null,null,null,null,null,null,null,null,null,-5.0000000000000037E-2,null,17849.999999999982,-13857.595517531656]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-2.5000000000000036E-2,null,29799.999999999985,-53.534911471049782]
[null,"Net Non-farm Income",12000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-3.4694469519536142E-17,null,41749.999999999985,13750.525694589554]
[null,"Family Living Withdrawals",65000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4999999999999967E-2,null,53699.999999999985,27554.58630065016]
[null,"Principal Payments on Term Debt",17500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.9999999999999968E-2,null,65649.999999999985,41358.646906710768]
[null,"Income Taxes",20750,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.4999999999999969E-2,null,77599.999999999985,55162.707512771369]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.9999999999999978E-2,null,89550,68966.768118831984]
[null,"Assets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.12499999999999997,null,101499.99999999999,82770.828724892577]
[null,"   Current Assets ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.14999999999999997,null,113449.99999999999,96574.889330953185]
[null,"      Cash and Marketable Securities ",72000,null,"<-Note: This will be used as the source of down payment, remainder financed",null,null,null,null,null,null,null,null,null,null,null,null,null,0.17499999999999996,null,125399.99999999999,110378.94993701379]
[null,"      Other Current Assets",170000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.19999999999999996,null,137350,124183.0105430744]
[null,"   Total Current Assets",null,null,{"$f":"C23+C22","v":242000},null,null,null,null,null,null,null,null,null,null,null,null,null,0.22499999999999995,null,149299.99999999997,137987.07114913498]
[null,"   Noncurrent Assets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.24999999999999994,null,161249.99999999997,151791.13175519559]
[null,"       Real Estate",290000]
[null,"       Other Nonreal Estate Assets",425000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Op Cost"]
[null,"   Total Noncurrent Assets",null,null,{"$f":"C27+C26","v":715000},null,null,null,null,null,null,null,null,null,null,null,null,null,-0.25,null,{"$f":"IF($C$98>0,-U$3*$S28+C$98,\"NA\")","v":120000},{"$f":"IF($E$98>0,-V$3*$S28+E$98,\"\")","v":104141.13175519562}]
[null,"Total Assets",null,null,{"$f":"E24+E28","v":957000},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S28+0.025","v":-0.22500000000000001},null,{"$f":"IF($C$98>0,-U$3*$S29+C$98,\"NA\")","v":112175},{"$f":"IF($E$98>0,-V$3*$S29+E$98,\"\")","v":95102.071149135008}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.2,null,104350,86063.01054307443]
[null,"Liabilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.17500000000000002,null,96525,77023.949937013822]
[null,"   Current Liabilities ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.15000000000000002,null,88700,67984.889330953214]
[null,"        Operating notes payable",92000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.12500000000000003,null,80875,58945.828724892606]
[null,"        Other current liabilities",32000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.10000000000000003,null,73050.000000000015,49906.768118832006]
[null,"   Total Current Liabilities",null,null,{"$f":"C34+C33","v":124000},null,null,null,null,null,null,null,null,null,null,null,null,null,-7.5000000000000039E-2,null,65225.000000000015,40867.707512771405]
[null,"   Noncurrent Liabilities",325000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.0000000000000037E-2,null,57400.000000000015,31828.646906710797]
[null,"Total Liabilities",null,null,{"$f":"E35+C36","v":449000},null,null,null,null,null,null,null,null,null,null,null,null,null,-2.5000000000000036E-2,null,49575.000000000015,22789.586300650193]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-3.4694469519536142E-17,null,41750.000000000007,13750.525694589587]
[null,"Total Equity",null,null,{"$f":"E29-E37","v":508000},null,null,null,null,null,null,null,null,null,null,null,null,null,2.4999999999999967E-2,null,33925.000000000007,4711.4650885289811]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.9999999999999968E-2,null,26100.000000000007,-4327.595517531623]
[null,"Simple Static Appraisal of Financial Condition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.4999999999999969E-2,null,18275.000000000011,-13366.656123592231]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.9999999999999978E-2,null,10450.000000000007,-22405.716729652835]
[null,"Balance Sheet Summary",null,null,null,null,null,"Net After Tax Cash Flows",null,null,null,null,null,null,null,null,null,null,0.12499999999999997,null,2625.0000000000073,-31444.777335713443]
[null,null,null,null,null,null,"Year","5 Year","10 Year","30 Year",null,null,null,null,null,null,null,null,{"$f":"S43+0.025","v":0.14999999999999997},null,{"$f":"IF($C$98>0,-U$3*$S44+C$98,\"NA\")","v":-5199.9999999999927},{"$f":"IF($E$98>0,-V$3*$S44+E$98,\"\")","v":-40483.837941774043}]
[null,null,null,null,null,null,"% Downpayment Needed for Break-even Cash Flow Year 1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"S44+0.025","v":0.17499999999999996},null,{"$f":"IF($C$98>0,-U$3*$S45+C$98,\"NA\")","v":-13024.999999999985},{"$f":"IF($E$98>0,-V$3*$S45+E$98,\"\")","v":-49522.898547834644}]
[null,null,"Pre-Investment",null,"Post-Investment",null,null,0.58286304182242554,0.58684118720014067,0.58949328411861757,null,null,null,null,null,null,null,null,{"$f":"S45+0.025","v":0.19999999999999996},null,{"$f":"IF($C$98>0,-U$3*$S46+C$98,\"NA\")","v":-20849.999999999985},{"$f":"IF($E$98>0,-V$3*$S46+E$98,\"\")","v":-58561.959153895245}]
[null,"Assets",null,null,null,null,0,{"$f":"$C$2*'5 Year Model'!O8","v":-166400},{"$f":"$C$2*'10 Year Model'!$O8","v":-166400},{"$f":"$C$2*'30 Year Model'!$O8","v":-166400},null,null,null,null,null,null,null,null,{"$f":"S46+0.025","v":0.22499999999999995},null,{"$f":"IF($C$98>0,-U$3*$S47+C$98,\"NA\")","v":-28674.999999999985},{"$f":"IF($E$98>0,-V$3*$S47+E$98,\"\")","v":-67601.019759955845}]
[null,"   Current Assets ",null,null,null,null,1,{"$f":"$C$2*'5 Year Model'!O9","v":-14994.187348888696},{"$f":"$C$2*'10 Year Model'!O9","v":-15173.387348888697},{"$f":"$C$2*'30 Year Model'!$O9","v":-15292.854015555366},null,null,null,null,null,null,null,null,{"$f":"S47+0.025","v":0.24999999999999994},null,{"$f":"IF($C$98>0,-U$3*$S48+C$98,\"NA\")","v":-36499.999999999985},{"$f":"IF($E$98>0,-V$3*$S48+E$98,\"\")","v":-76640.080366016453}]
[null,"      Cash and Marketable Securities",{"$f":"C22","v":72000},null,{"$f":"IF((C49+H47)<0,0,C49+H47)","v":0},null,2,{"$f":"$C$2*'5 Year Model'!O10","v":-14844.763616350026},{"$f":"$C$2*'10 Year Model'!O10","v":-15023.963616350027},{"$f":"$C$2*'30 Year Model'!$O10","v":-15143.430283016693}]
[null,"      Other Current Assets",{"$f":"C23","v":170000},null,{"$f":"(C50)","v":170000},null,3,{"$f":"$C$2*'5 Year Model'!O11","v":-14701.120059859037},{"$f":"$C$2*'10 Year Model'!O11","v":-14880.320059859037},{"$f":"$C$2*'30 Year Model'!$O11","v":-14999.786726525706}]
[null,"   Total Current Assets",{"$f":"C50+C49","v":242000},null,{"$f":"E50+E49","v":170000},null,4,{"$f":"$C$2*'5 Year Model'!O12","v":-14563.898401978586},{"$f":"$C$2*'10 Year Model'!O12","v":-14743.098401978585},{"$f":"$C$2*'30 Year Model'!$O12","v":-14862.565068645254}]
[null,"   Noncurrent Assets",null,null,null,null,5,{"$f":"$C$2*'5 Year Model'!O13","v":251717.47377866827},{"$f":"$C$2*'10 Year Model'!O13","v":-14612.984766865311},{"$f":"$C$2*'30 Year Model'!$O13","v":-14732.45143353198}]
[null,"       Real Estate",{"$f":"C26","v":290000},null,{"$f":"C53+NoAcres*Aprice+price10*closing*NoAcres","v":936400},null,6,null,{"$f":"$C$2*'10 Year Model'!O14","v":-14490.712462330037},{"$f":"$C$2*'30 Year Model'!$O14","v":-14610.179128996704}]
[null,"       Other Nonreal Estate Assets",{"$f":"C27","v":425000},null,{"$f":"C54","v":425000},null,7,null,{"$f":"$C$2*'10 Year Model'!O15","v":-14377.064931181141},{"$f":"$C$2*'30 Year Model'!$O15","v":-14496.53159784781}]
[null,"   Total Noncurrent Assets",{"$f":"C53+C54","v":715000},null,{"$f":"E53+E54","v":1361400},null,8,null,{"$f":"$C$2*'10 Year Model'!O16","v":-14272.878882054983},{"$f":"$C$2*'30 Year Model'!$O16","v":-14392.345548721652}]
[null,"Total Assets",{"$f":"C51+C55","v":957000},null,{"$f":"E51+E55","v":1531400},null,9,null,{"$f":"$C$2*'10 Year Model'!O17","v":-14179.047610550751},{"$f":"$C$2*'30 Year Model'!$O17","v":-14298.514277217419}]
[null,null,null,null,null,null,10,null,{"$f":"$C$2*'10 Year Model'!O18","v":410501.87550937245},{"$f":"$C$2*'30 Year Model'!$O18","v":-14215.99118880382}]
[null,"Liabilities",null,null,null,null,11,null,null,{"$f":"$C$2*'30 Year Model'!$O19","v":-14145.793535653918}]
[null,"   Current Liabilities ",null,null,null,null,12,null,null,{"$f":"$C$2*'30 Year Model'!$O20","v":-14089.006380294897}]
[null,"        Operating notes payable",{"$f":"C33","v":92000},null,{"$f":"IF((C49+H47)<0,C60-(C49+H47),C60)","v":186400},null,13,null,null,{"$f":"$C$2*'30 Year Model'!$O21","v":-14046.786799733811}]
[null,"        Other current liabilities",{"$f":"C34","v":32000},null,{"$f":"C61+'10 Year Model'!I9*NoAcres","v":45048.587348888694},null,14,null,null,{"$f":"$C$2*'30 Year Model'!$O22","v":-14020.368344540921}]
[null,"   Total Current Liabilities",{"$f":"C61+C60","v":124000},null,{"$f":"E61+E60","v":231448.58734888869},null,15,null,null,{"$f":"$C$2*'30 Year Model'!$O23","v":-14011.065768242355}]
[null,"   Noncurrent Liabilities",{"$f":"C36","v":325000},null,{"$f":"C63+NoAcres*Aprice*(1-DownPay)-'10 Year Model'!I9*NoAcres","v":791951.41265111126},null,16,null,null,{"$f":"$C$2*'30 Year Model'!$O24","v":-14020.280043295908}]
[null,"Total Liabilities",{"$f":"C63+C62","v":449000},null,{"$f":"E63+E62","v":1023400},null,17,null,null,{"$f":"$C$2*'30 Year Model'!$O25","v":-14049.50368090128}]
[null,null,null,null,null,null,18,null,null,{"$f":"$C$2*'30 Year Model'!$O26","v":-14100.326372932566}]
[null,"Total Equity",{"$f":"C56-C64","v":508000},null,{"$f":"E56-E64","v":508000},null,19,null,null,{"$f":"$C$2*'30 Year Model'!$O27","v":-14174.440975378728}]
[null,null,null,null,null,null,20,null,null,{"$f":"$C$2*'30 Year Model'!$O28","v":-14273.649853842491}]
[null,"Debt to Asset Ratio",{"$f":"C64/C56","v":0.46917450365726227},null,{"$f":"E64/E56","v":0.66827739323494839},null,21,null,null,{"$f":"$C$2*'30 Year Model'!$O29","v":27448.715736006357}]
[null,"Current Ratio",{"$f":"IF(C62>0,C51/C62,NA)","v":1.9516129032258065},null,{"$f":"IF(E62>0,E51/E62,NA)","v":0.73450437502018417},null,22,null,null,{"$f":"$C$2*'30 Year Model'!$O30","v":27996.495384059814}]
[null,null,null,null,null,null,23,null,null,{"$f":"$C$2*'30 Year Model'!$O31","v":28555.23062507435}]
[null,null,null,null,null,null,24,null,null,{"$f":"$C$2*'30 Year Model'!$O32","v":29125.140570909167}]
[null,"Income Summary","Pre-Investment",null,"Post-Investment",null,25,null,null,{"$f":"$C$2*'30 Year Model'!$O33","v":29706.448715660681}]
[null,null,null,null,null,null,26,null,null,{"$f":"$C$2*'30 Year Model'!$O34","v":30299.383023307229}]
[null,"Gross Revenue Less Operating Expenses",{"$f":"C7-C8","v":165000},null,{"$f":"C74+'10 Year Model'!D9*NoAcres-'10 Year Model'!E9*NoAcres+(price10*closing/10)*NoAcres","v":190600},null,27,null,null,{"$f":"$C$2*'30 Year Model'!$O35","v":30904.176017106714}]
[null,"Depreciation",{"$f":"C9","v":43912},null,{"$f":"C75+'10 Year Model'!J9*NoAcres","v":43912},null,28,null,null,{"$f":"$C$2*'30 Year Model'!$O36","v":31521.064870782171}]
[null,"Interest Expense on Operating",{"$f":"C10","v":12500},null,{"$f":"C76/C60*E60","v":25326.086956521736},null,29,null,null,{"$f":"$C$2*'30 Year Model'!$O37","v":32150.291501531156}]
[null,"Interest Expense on Term Debt",{"$f":"C11","v":19500},null,{"$f":"'10 Year Model'!H9*NoAcres+C77","v":48300},null,30,null,null,{"$f":"$C$2*'30 Year Model'!$O38","v":1074757.5763470309}]
[null,null,null,null,null,null,"Capital Debt Capacity Sensitivity"]
[null,"Net Farm Income From Operations",{"$f":"C74-SUM(C75:C77)","v":89088},null,{"$f":"E74-SUM(E75:E77)","v":73061.913043478271},null,"Estimated Impact of Gross Revenue Change on Capital Debt Replacement Margin"]
[]
[null,"Non-farm Income",{"$f":"C15","v":12000},null,{"$f":"C81","v":12000}]
[null,"Income Taxes",{"$f":"C18","v":20750},null,{"$f":"C82+('10 Year Model'!D9-'10 Year Model'!E9-'10 Year Model'!H9)*(IncomeTax)*NoAcres","v":19674.8}]
[]
[null,"Net Income",{"$f":"C79+C81-C82","v":80338},null,{"$f":"E79+E81-E82","v":65387.113043478268}]
[]
[null,"Rate of Return on Assets",{"$f":"(C84+C76+C77-C93)/C56","v":4.9464994775339603E-2},null,{"$f":"(E84+E76+E77-E93)/E56","v":4.8330416612250238E-2}]
[null,"Rate of Return on Equity",{"$f":"(C84-C93)/C66","v":3.0192913385826772E-2},null,{"$f":"(E84-E93)/E66","v":7.6203355015407102E-4}]
[]
[null,"Capital Debt Repayment Capacity",{"$f":"C72","v":"Pre-Investment"},null,"Post-Investment"]
[]
[null,"Net Income",{"$f":"C84","v":80338},null,{"$f":"E84","v":65387.113043478268}]
[null," PLUS: Depreciation",{"$f":"C75","v":43912},null,{"$f":"C92+'10 Year Model'!J9*NoAcres","v":43912}]
[null," LESS: Family Withdrawals",{"$f":"C16","v":65000},null,{"$f":"C93","v":65000}]
[null,null,null,null,null,null,"Estimated decrease in revenue",null,"Pre-Investment","Post-Investment"]
[null,"Capital Replacement and Term Debt Capacity",{"$f":"C91+C92-C93","v":59250},null,{"$f":"E91+E92-E93","v":44299.113043478268},null,"       to reduce margin to 0",null,{"$f":"IF(C98>0,C98/U2,\"NA\")","v":8.7343096234309622E-2},{"$f":"IF(E98>0,E98/V2,\"NA\")","v":2.490304499342837E-2}]
[null,"  LESS: Scheduled Principal Payments",{"$f":"C17","v":17500},null,{"$f":"C96+'10 Year Model'!I9*NoAcres","v":30548.587348888694}]
[null,null,null,null,null,null,"Capital Debt Capacity Sensitivity"]
[null,"Capital Replacement and Term Debt Margin",{"$f":"C95-C96","v":41750},null,{"$f":"E95-E96","v":13750.525694589574},null,"Estimated Impact of Operating Cost Change on Capital Debt Replacement Margin"]
[]
[null,"Term Debt and Capital Lease Ratio",{"$f":"(C98+C96+C11)/+(C96+C77)","v":2.1283783783783785},null,{"$f":"(E98+E96+E77)/+(E96+E77)","v":1.1743915288392721}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Estimated increase in operating",null,"Pre-Investment","Post-Investment"]
[null,null,null,null,null,null,"       costs to reduce margin to 0",null,{"$f":"IF(C98>0,C98/U3,\"NA\")","v":0.13338658146964857},{"$f":"IF(E98>0,E98/V3,\"NA\")","v":3.8030848264724477E-2}]

{"sheet":"Sensitivity Tables","index":4,"n_rows":97,"n_cols":22,"rows_kept":97,"cut":false,"hidden":false,"merged":[[18,1,18,2],[49,6,49,7],[19,1,19,2],[43,6,43,7],[47,6,47,7],[48,6,48,7],[39,7,39,10],[56,6,56,7],[45,7,45,10],[1,1,1,2],[32,6,32,7],[37,6,37,7],[29,7,29,10],[30,6,30,7],[41,6,41,7],[20,1,20,2],[23,7,23,10],[55,6,55,7],[51,8,51,10],[52,8,52,10],[54,6,54,7],[8,6,8,10],[40,6,40,7],[42,6,42,7],[22,5,22,10],[2,5,2,7],[14,5,14,10],[46,6,46,7],[15,6,15,10],[7,5,7,10],[31,6,31,7]]}
[null,null,null,null,null,"              Land Purchase Analysis: Sensitivity Tables",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Farmland Bid Price Estimator"]
[null,null,null,null,null,"Maximum Bid Prices:"]
[null,null,null,null,null,"5 Year Horizon",null,{"$f":"IF('5 Year Model'!O24<0,\"NA\",'5 Year Model'!O24)","v":6929.9}]
[null,{"$f":"'Cash Budgets'!A33","v":"Net Cash Flow: year 1"},{"$f":"CashFlows","v":350},null,null,"10 Year Horizon",null,{"$f":"IF('10 Year Model'!O28<0,\"NA\",'10 Year Model'!O28)","v":8091.02}]
[null,"Annual growth rate of net cash flows",{"$f":"CashFlowGr","v":0.02},null,null,"30 Year Horizon",null,{"$f":"IF('30 Year Model'!O48>0,'30 Year Model'!O48,\"NA\")","v":9622.2099999999991}]
[null,"Annual growth rate of land values",{"$f":"LandGr","v":0.02}]
[null,"Marginal income tax rate",{"$f":"MTR","v":0.28000000000000003},null,null,"Bid Prices at Alternative After-tax Investment Returns"]
[null,"Capital gains tax rate",{"$f":"CGTR","v":0.15},null,null,null,"After-tax Investment Return"]
[null,"Property tax rate",{"$f":"PropertyTaxAc/Aprice","v":3.7499999999999999E-3},null,null,null,{"$f":"H10-range/4","v":3.0000000000000002E-2},{"$f":"I10-range/4","v":3.5000000000000003E-2},{"$f":"discount","v":0.04},{"$f":"I10+range/4","v":4.4999999999999998E-2},{"$f":"J10+range/4","v":4.9999999999999996E-2}]
[null,"After-tax discount rate",{"$f":"DR","v":0.04},null,null,"5 Year Horizon",{"$f":"TRANSPOSE('5 Year Model'!P22:P26)","v":7633.81},7265.4,6929.9,6625.12,6346.46]
[null,"Closing fees (initial purchase)",{"$f":"ClosingFeeP","v":0.01},null,null,"10 Year Horizon",{"$f":"TRANSPOSE('10 Year Model'!P26:P30)","v":9358.9},8677.0300000000007,8091.02,7581.93,7135.58]
[null,"Selling fees (end of horizon)",{"$f":"SellingFeeP","v":0.04},null,null,"30 Year Horizon",{"$f":"TRANSPOSE('30 Year Model'!P46:P50)","v":13425.27},11184.41,9622.2099999999991,8471.94,7590.44]
[null,"Proportion financed",{"$f":"1-DownPay","v":0.75}]
[null,"Amortization period",{"$f":"LoanLength","v":20},null,null,{"$f":"\"Cash Flow Sensitivity Analysis @ After-tax Investment Return = \"&TEXT(I10,\"0.0%\")","v":"Cash Flow Sensitivity Analysis @ After-tax Investment Return = 4.0%"}]
[null,"Interest rate paid on debt",{"$f":"InterestRate","v":0.06},null,null,null,"Change in Initial Net Cash Flow"]
[null,"Investment yield sensitivity range",{"$f":"InvestS","v":0.02},null,null,null,{"$f":"-cashsensitiviy/2","v":-0.05},{"$f":"-cashsensitiviy/4","v":-2.5000000000000001E-2},0,{"$f":"+cashsensitiviy/4","v":2.5000000000000001E-2},{"$f":"2*cashsensitiviy/4","v":0.05}]
[null,"Analysis price",{"$f":"Aprice","v":8000},null,null,"Net Cash Flow ->",{"$f":"(1+G17)*CF","v":332.5},{"$f":"(1+H17)*CF","v":341.25},{"$f":"(1+I17)*CF","v":350},{"$f":"(1+J17)*CF","v":358.74999999999994},{"$f":"(1+K17)*CF","v":367.5}]
[null,null,null,null,null,"5 Year Horizon",{"$f":"'5 Year Model'!R48","v":6550.9},{"$f":"'5 Year Model'!R49","v":6740.41},{"$f":"I11","v":6929.9},{"$f":"'5 Year Model'!R51","v":7119.4},{"$f":"'5 Year Model'!R52","v":7308.8561}]
[null,null,null,null,null,"10 Year Horizon",{"$f":"'10 Year Model'!R48","v":7648.52},{"$f":"'10 Year Model'!R49","v":7869.78},{"$f":"I12","v":8091.02},{"$f":"'10 Year Model'!R51","v":8312.25},{"$f":"'10 Year Model'!R52","v":8533.4699999999993}]
[null,null,null,null,null,"30 Year Horizon",{"$f":"'30 Year Model'!R48","v":9095.99},{"$f":"'30 Year Model'!R49","v":9359.11},{"$f":"I13","v":9622.2099999999991},{"$f":"'30 Year Model'!R51","v":9885.32},{"$f":"'30 Year Model'!R52","v":10148.42}]
[]
[null,null,null,null,null,"Bid Prices at Alternative Growth Rates"]
[null,null,null,null,null,null,null,"Growth Rate:  Net Cash Flows & Land Values"]
[null,null,null,null,null,"    Growth rate ->",null,0,0.01,0.03,0.05,null,{"$f":"J55","v":2.5242089859053629E-2},{"$f":"J56","v":1.9626682669639042E-2},{"$f":"J57","v":1.469763373619957E-2}]
[null,null,null,null,null,"5 Year Horizon",null,{"$f":"TRANSPOSE('5 Year Model'!P28:P31)","v":4586.8500000000004},5520.47,9303.52,29469.41,null,{"$f":"analysis","v":8000}]
[null,null,null,null,null,"10 Year Horizon",null,{"$f":"TRANSPOSE('10 Year Model'!P32:P35)","v":5023.38},6199.87,11631.96,91355.81,null,null,{"$f":"M26","v":8000}]
[null,null,null,null,null,"30 Year Horizon",null,{"$f":"TRANSPOSE('30 Year Model'!P52:P55)","v":5437.28},6956.46,15515.89,"NA",null,null,null,{"$f":"N27","v":8000}]
[]
[null,null,null,null,null,{"$f":"\"Analysis price = $\"&TEXT(C18,\"0,000\")","v":"Analysis price = $8,000"},null,"Initial Cash Flow Needed to Achieve Return  "]
[null,null,null,null,null,null,"After-tax Investment Yield",null,{"$f":"G10","v":3.0000000000000002E-2},{"$f":"I10","v":0.04},{"$f":"K10","v":4.9999999999999996E-2}]
[null,null,null,null,null,"5 Year Horizon",{"$f":"'5 Year Model'!Q14","v":2.5502889869822853E-2},null,{"$f":"CFlow5L","v":365.35066669265558},{"$f":"CFlow5B","v":399.41310687939614},{"$f":"CFlow5H","v":433.37518719787482}]
[null,null,null,null,null,"10 Year Horizon",{"$f":"'10 Year Model'!Q19","v":4.0845098801470803E-2},null,{"$f":"CFlow10L","v":303.53623270573257},{"$f":"CFlow10B","v":346.40085431654677},{"$f":"CFlow10H","v":388.76580263392867}]
[null,{"$f":"IF(ROUND(C34,2)=0,0,1)","v":1},{"$f":"'5 Year Model'!O15+'10 Year Model'!O20+'30 Year Model'!O40+C38+C37-range-analysis","v":715.79000000000087},null,null,"30 Year Horizon"]
[]
[]
[null,null,0.02]
[null,null,8000,null,null,"30 Year Horizon",{"$f":"'30 Year Model'!Q39","v":4.7521675232664817E-2},null,{"$f":"CFlow30L","v":220.68531024119278},{"$f":"CFlow30B","v":296.05132926919782},{"$f":"CFlow30H","v":367.26613303011192}]
[]
[null,null,null,null,null,{"$f":"\"Analysis price = $\"&TEXT(C18,\"0,000\")","v":"Analysis price = $8,000"},null,"Cash Flow Growth to Achieve Yield"]
[null,null,null,null,null,null,"After-tax Investment Yield",null,{"$f":"I31","v":3.0000000000000002E-2},{"$f":"J31","v":0.04},{"$f":"K31","v":4.9999999999999996E-2}]
[null,null,null,null,null,"5 Year Horizon",{"$f":"G32","v":2.5502889869822853E-2}]
[null,null,null,null,null,"10 Year Horizon",{"$f":"G33","v":4.0845098801470803E-2}]
[null,null,null,null,null,"30 Year Horizon",{"$f":"G38","v":4.7521675232664817E-2}]
[]
[null,null,null,null,null,{"$f":"\"Analysis price = $\"&TEXT(C18,\"0,000\")","v":"Analysis price = $8,000"},null,"Land Appreciation Needed to Achieve Yield"]
[null,null,null,null,null,null,"After-tax Investment Yield",null,{"$f":"I37","v":0},{"$f":"J37","v":0},{"$f":"K37","v":0}]
[null,null,null,null,null,"5 Year Horizon",{"$f":"G42","v":2.5502889869822853E-2}]
[null,null,null,null,null,"10 Year Horizon",{"$f":"G43","v":4.0845098801470803E-2}]
[null,null,null,null,null,"30 Year Horizon",{"$f":"G44","v":4.7521675232664817E-2}]
[]
[null,null,null,null,null,{"$f":"\"Analysis price = $\"&TEXT(C18,\"0,000\")","v":"Analysis price = $8,000"},null,null,"Growth Rates :Cash Flows & Land Values "]
[null,null,null,null,null,{"$f":"\"Net cash flow  = \"&TEXT(CF,\"$0\")","v":"Net cash flow  = $350"},null,null,"Needed to Achieve After-Tax Investment Return"]
[null,null,null,null,null,"    After-tax Investment Return ->",null,null,{"$f":"I31","v":3.0000000000000002E-2},{"$f":"J31","v":0.04},{"$f":"K31","v":4.9999999999999996E-2}]
[null,null,null,null,null,"5 Year Horizon",null,null,{"$f":"gr5_L","v":2.1609104877170576E-2},{"$f":"gr5_b","v":2.5242089859053629E-2},{"$f":"gr5_h","v":2.8951081749911598E-2}]
[null,null,null,null,null,"10 Year Horizon",null,null,{"$f":"gr10_l","v":1.5290362287768172E-2},{"$f":"gr10_b","v":1.9626682669639042E-2},{"$f":"gr10_h","v":2.4112235989268396E-2}]
[null,null,null,null,null,"30 Year Horizon",null,null,{"$f":"gr30_l","v":7.6760682578727278E-3},{"$f":"gr30_b","v":1.469763373619957E-2},{"$f":"gr30_h","v":2.1752511787240077E-2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[8000]
[8000]
[8000]

{"sheet":"Cash Budgets","index":5,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Cash Budget for Investment"]
["Net Cash Flow Calculations","Enterprise 1","Enterprise 2","Enterprise 3","Total"]
[]
["% Total Investment",0,0,0,{"$f":"SUM(B5:D5)","v":0}]
["Market price per unit ",0,0,0]
["Average production units (bu./acre)",0,0,0]
["Other income/cash rent received",0,0,0]
["Total revenue ",{"$f":"B6*B7+B8","v":0},{"$f":"C6*C7+C8","v":0},{"$f":"D6*D7+D8","v":0},{"$f":"D9*$D$5+C9*$C$5+$B$5*B9","v":0}]
["Expenses(exclude property taxes entered in model)"]
[]
["Fertilizer",0,0,0,{"$f":"D12*$D$5+C12*$C$5+$B$5*B12","v":0}]
["Chemical",0,0,0,0]
["Seed",0,0,0,0]
["Utilities",0,0,0,0]
["Insurance",0,0,0,0]
["Salary and labor expense",0,0,0,0]
["Repairs",0,0,0,0]
["Machine hire",0,0,0,0]
["Fuel and transportation costs",0,0,0,0]
["Selling and advertising expenses",0,0,0,0]
["Building repairs",0,0,0,0]
["Storage & drying",0,0,0,0]
["Other operating expenses",0,0,0,0]
[]
["Sub-total",{"$f":"SUM(B12:B24)","v":0},{"$f":"SUM(C12:C24)","v":0},{"$f":"SUM(D12:D24)","v":0},0]
[]
["Working Capital & Nonreal Estate Interest",0,0,0,0]
["Depreciation Expense",0,0,0,0]
[]
["Total Expenses",{"$f":"SUM(B26:B29)","v":0},{"$f":"SUM(C26:C29)","v":0},{"$f":"SUM(D26:D29)","v":0},0]
[]
["Net Cash Flow: year 1",{"$f":"B9-B31","v":0},{"$f":"C9-C31","v":0},{"$f":"D9-D31","v":0},{"$f":"D33*$D$5+C33*$C$5+$B$5*B33","v":0}]

{"sheet":"Cash Flows","index":6,"n_rows":46,"n_cols":34,"rows_kept":46,"cut":false,"hidden":true,"merged":[[2,28,2,29],[3,28,3,29],[1,25,1,33],[5,25,5,26],[4,25,4,26],[3,25,3,26],[3,31,3,32]]}
[]
[null,null,null,null,"Number of Acres",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X3=V3,1,IF(V4=X3,2,3))","v":2},null,{"$f":"IF(year=1,'5 Year Model'!AA1:AI1,IF(year=2,'10 Year Model'!AA1:AI1,'30 Year Model'!AA1:AI1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 Year Model",null,"10 Year Model",null,"Model ",null,null,"Max Bid Price"]
[null,null,null,null,"Analysis Price",{"$f":"analysis","v":8000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10 Year Model",null,null,null,"Analysis Price/Acre",null,null,{"$f":"IF(year=1,'Sensitivity Tables'!A95,IF(year=2,'Sensitivity Tables'!A96,'Sensitivity Tables'!A97))","v":8000},null,null,{"$f":"IF(year=1,'5 Year Model'!AG2:AO2,IF(year=2,'10 Year Model'!AG2:AO2,'30 Year Model'!AG2:AO2))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(year=1,'5 Year Model'!AI2:AQ2,IF(year=2,'10 Year Model'!AI2:AQ2,'30 Year Model'!AI2:AQ2))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30 Year Model",null,null,null,"Acres",null,null,null,null,null,{"$f":"IF(year=1,'5 Year Model'!AG3:AO3,IF(year=2,'10 Year Model'!AG3:AO3,'30 Year Model'!AG3:AO3))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH3:AP3,IF(year=2,'10 Year Model'!AH3:AP3,'30 Year Model'!AH3:AP3))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI3:AQ3,IF(year=2,'10 Year Model'!AI3:AQ3,'30 Year Model'!AI3:AQ3))","v":{"$error":"#VALUE!"}}]
[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,"Total Purchase",null,{"$f":"IF(year=1,'5 Year Model'!AC4:AK4,IF(year=2,'10 Year Model'!AC4:AK4,'30 Year Model'!AC4:AK4))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"IF(year=1,'5 Year Model'!AG4:AO4,IF(year=2,'10 Year Model'!AG4:AO4,'30 Year Model'!AG4:AO4))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AB5:AJ5,IF(year=2,'10 Year Model'!AB5:AJ5,'30 Year Model'!AB5:AJ5))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC5:AK5,IF(year=2,'10 Year Model'!AC5:AK5,'30 Year Model'!AC5:AK5))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD5:AL5,IF(year=2,'10 Year Model'!AD5:AL5,'30 Year Model'!AD5:AL5))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE5:AM5,IF(year=2,'10 Year Model'!AE5:AM5,'30 Year Model'!AE5:AM5))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF5:AN5,IF(year=2,'10 Year Model'!AF5:AN5,'30 Year Model'!AF5:AN5))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG5:AO5,IF(year=2,'10 Year Model'!AG5:AO5,'30 Year Model'!AG5:AO5))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH5:AP5,IF(year=2,'10 Year Model'!AH5:AP5,'30 Year Model'!AH5:AP5))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI5:AQ5,IF(year=2,'10 Year Model'!AI5:AQ5,'30 Year Model'!AI5:AQ5))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA6:AI6,IF(year=2,'10 Year Model'!AA6:AI6,'30 Year Model'!AA6:AI6))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB6:AJ6,IF(year=2,'10 Year Model'!AB6:AJ6,'30 Year Model'!AB6:AJ6))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC6:AK6,IF(year=2,'10 Year Model'!AC6:AK6,'30 Year Model'!AC6:AK6))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD6:AL6,IF(year=2,'10 Year Model'!AD6:AL6,'30 Year Model'!AD6:AL6))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE6:AM6,IF(year=2,'10 Year Model'!AE6:AM6,'30 Year Model'!AE6:AM6))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF6:AN6,IF(year=2,'10 Year Model'!AF6:AN6,'30 Year Model'!AF6:AN6))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG6:AO6,IF(year=2,'10 Year Model'!AG6:AO6,'30 Year Model'!AG6:AO6))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH6:AP6,IF(year=2,'10 Year Model'!AH6:AP6,'30 Year Model'!AH6:AP6))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI6:AQ6,IF(year=2,'10 Year Model'!AI6:AQ6,'30 Year Model'!AI6:AQ6))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AB7:AJ7,IF(year=2,'10 Year Model'!AB7:AJ7,'30 Year Model'!AB7:AJ7))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC7:AK7,IF(year=2,'10 Year Model'!AC7:AK7,'30 Year Model'!AC7:AK7))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD7:AL7,IF(year=2,'10 Year Model'!AD7:AL7,'30 Year Model'!AD7:AL7))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE7:AM7,IF(year=2,'10 Year Model'!AE7:AM7,'30 Year Model'!AE7:AM7))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF7:AN7,IF(year=2,'10 Year Model'!AF7:AN7,'30 Year Model'!AF7:AN7))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG7:AO7,IF(year=2,'10 Year Model'!AG7:AO7,'30 Year Model'!AG7:AO7))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH7:AP7,IF(year=2,'10 Year Model'!AH7:AP7,'30 Year Model'!AH7:AP7))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI7:AQ7,IF(year=2,'10 Year Model'!AI7:AQ7,'30 Year Model'!AI7:AQ7))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA8:AI8,IF(year=2,'10 Year Model'!AA8:AI8,'30 Year Model'!AA8:AI8))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB8:AJ8,IF(year=2,'10 Year Model'!AB8:AJ8,'30 Year Model'!AB8:AJ8))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC8:AK8,IF(year=2,'10 Year Model'!AC8:AK8,'30 Year Model'!AC8:AK8))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD8:AL8,IF(year=2,'10 Year Model'!AD8:AL8,'30 Year Model'!AD8:AL8))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE8:AM8,IF(year=2,'10 Year Model'!AE8:AM8,'30 Year Model'!AE8:AM8))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF8:AN8,IF(year=2,'10 Year Model'!AF8:AN8,'30 Year Model'!AF8:AN8))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG8:AO8,IF(year=2,'10 Year Model'!AG8:AO8,'30 Year Model'!AG8:AO8))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH8:AP8,IF(year=2,'10 Year Model'!AH8:AP8,'30 Year Model'!AH8:AP8))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI8:AQ8,IF(year=2,'10 Year Model'!AI8:AQ8,'30 Year Model'!AI8:AQ8))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA9:AI9,IF(year=2,'10 Year Model'!AA9:AI9,'30 Year Model'!AA9:AI9))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB9:AJ9,IF(year=2,'10 Year Model'!AB9:AJ9,'30 Year Model'!AB9:AJ9))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC9:AK9,IF(year=2,'10 Year Model'!AC9:AK9,'30 Year Model'!AC9:AK9))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD9:AL9,IF(year=2,'10 Year Model'!AD9:AL9,'30 Year Model'!AD9:AL9))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE9:AM9,IF(year=2,'10 Year Model'!AE9:AM9,'30 Year Model'!AE9:AM9))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF9:AN9,IF(year=2,'10 Year Model'!AF9:AN9,'30 Year Model'!AF9:AN9))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG9:AO9,IF(year=2,'10 Year Model'!AG9:AO9,'30 Year Model'!AG9:AO9))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH9:AP9,IF(year=2,'10 Year Model'!AH9:AP9,'30 Year Model'!AH9:AP9))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI9:AQ9,IF(year=2,'10 Year Model'!AI9:AQ9,'30 Year Model'!AI9:AQ9))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA10:AI10,IF(year=2,'10 Year Model'!AA10:AI10,'30 Year Model'!AA10:AI10))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB10:AJ10,IF(year=2,'10 Year Model'!AB10:AJ10,'30 Year Model'!AB10:AJ10))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC10:AK10,IF(year=2,'10 Year Model'!AC10:AK10,'30 Year Model'!AC10:AK10))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD10:AL10,IF(year=2,'10 Year Model'!AD10:AL10,'30 Year Model'!AD10:AL10))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE10:AM10,IF(year=2,'10 Year Model'!AE10:AM10,'30 Year Model'!AE10:AM10))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF10:AN10,IF(year=2,'10 Year Model'!AF10:AN10,'30 Year Model'!AF10:AN10))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG10:AO10,IF(year=2,'10 Year Model'!AG10:AO10,'30 Year Model'!AG10:AO10))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH10:AP10,IF(year=2,'10 Year Model'!AH10:AP10,'30 Year Model'!AH10:AP10))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI10:AQ10,IF(year=2,'10 Year Model'!AI10:AQ10,'30 Year Model'!AI10:AQ10))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA11:AI11,IF(year=2,'10 Year Model'!AA11:AI11,'30 Year Model'!AA11:AI11))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB11:AJ11,IF(year=2,'10 Year Model'!AB11:AJ11,'30 Year Model'!AB11:AJ11))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC11:AK11,IF(year=2,'10 Year Model'!AC11:AK11,'30 Year Model'!AC11:AK11))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD11:AL11,IF(year=2,'10 Year Model'!AD11:AL11,'30 Year Model'!AD11:AL11))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE11:AM11,IF(year=2,'10 Year Model'!AE11:AM11,'30 Year Model'!AE11:AM11))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF11:AN11,IF(year=2,'10 Year Model'!AF11:AN11,'30 Year Model'!AF11:AN11))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG11:AO11,IF(year=2,'10 Year Model'!AG11:AO11,'30 Year Model'!AG11:AO11))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH11:AP11,IF(year=2,'10 Year Model'!AH11:AP11,'30 Year Model'!AH11:AP11))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI11:AQ11,IF(year=2,'10 Year Model'!AI11:AQ11,'30 Year Model'!AI11:AQ11))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA12:AI12,IF(year=2,'10 Year Model'!AA12:AI12,'30 Year Model'!AA12:AI12))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB12:AJ12,IF(year=2,'10 Year Model'!AB12:AJ12,'30 Year Model'!AB12:AJ12))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC12:AK12,IF(year=2,'10 Year Model'!AC12:AK12,'30 Year Model'!AC12:AK12))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD12:AL12,IF(year=2,'10 Year Model'!AD12:AL12,'30 Year Model'!AD12:AL12))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE12:AM12,IF(year=2,'10 Year Model'!AE12:AM12,'30 Year Model'!AE12:AM12))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF12:AN12,IF(year=2,'10 Year Model'!AF12:AN12,'30 Year Model'!AF12:AN12))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG12:AO12,IF(year=2,'10 Year Model'!AG12:AO12,'30 Year Model'!AG12:AO12))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH12:AP12,IF(year=2,'10 Year Model'!AH12:AP12,'30 Year Model'!AH12:AP12))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI12:AQ12,IF(year=2,'10 Year Model'!AI12:AQ12,'30 Year Model'!AI12:AQ12))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA13:AI13,IF(year=2,'10 Year Model'!AA13:AI13,'30 Year Model'!AA13:AI13))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB13:AJ13,IF(year=2,'10 Year Model'!AB13:AJ13,'30 Year Model'!AB13:AJ13))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC13:AK13,IF(year=2,'10 Year Model'!AC13:AK13,'30 Year Model'!AC13:AK13))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD13:AL13,IF(year=2,'10 Year Model'!AD13:AL13,'30 Year Model'!AD13:AL13))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE13:AM13,IF(year=2,'10 Year Model'!AE13:AM13,'30 Year Model'!AE13:AM13))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF13:AN13,IF(year=2,'10 Year Model'!AF13:AN13,'30 Year Model'!AF13:AN13))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG13:AO13,IF(year=2,'10 Year Model'!AG13:AO13,'30 Year Model'!AG13:AO13))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH13:AP13,IF(year=2,'10 Year Model'!AH13:AP13,'30 Year Model'!AH13:AP13))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI13:AQ13,IF(year=2,'10 Year Model'!AI13:AQ13,'30 Year Model'!AI13:AQ13))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA14:AI14,IF(year=2,'10 Year Model'!AA14:AI14,'30 Year Model'!AA14:AI14))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB14:AJ14,IF(year=2,'10 Year Model'!AB14:AJ14,'30 Year Model'!AB14:AJ14))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC14:AK14,IF(year=2,'10 Year Model'!AC14:AK14,'30 Year Model'!AC14:AK14))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD14:AL14,IF(year=2,'10 Year Model'!AD14:AL14,'30 Year Model'!AD14:AL14))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE14:AM14,IF(year=2,'10 Year Model'!AE14:AM14,'30 Year Model'!AE14:AM14))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF14:AN14,IF(year=2,'10 Year Model'!AF14:AN14,'30 Year Model'!AF14:AN14))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG14:AO14,IF(year=2,'10 Year Model'!AG14:AO14,'30 Year Model'!AG14:AO14))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH14:AP14,IF(year=2,'10 Year Model'!AH14:AP14,'30 Year Model'!AH14:AP14))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI14:AQ14,IF(year=2,'10 Year Model'!AI14:AQ14,'30 Year Model'!AI14:AQ14))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA15:AI15,IF(year=2,'10 Year Model'!AA15:AI15,'30 Year Model'!AA15:AI15))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB15:AJ15,IF(year=2,'10 Year Model'!AB15:AJ15,'30 Year Model'!AB15:AJ15))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC15:AK15,IF(year=2,'10 Year Model'!AC15:AK15,'30 Year Model'!AC15:AK15))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD15:AL15,IF(year=2,'10 Year Model'!AD15:AL15,'30 Year Model'!AD15:AL15))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE15:AM15,IF(year=2,'10 Year Model'!AE15:AM15,'30 Year Model'!AE15:AM15))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF15:AN15,IF(year=2,'10 Year Model'!AF15:AN15,'30 Year Model'!AF15:AN15))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG15:AO15,IF(year=2,'10 Year Model'!AG15:AO15,'30 Year Model'!AG15:AO15))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH15:AP15,IF(year=2,'10 Year Model'!AH15:AP15,'30 Year Model'!AH15:AP15))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI15:AQ15,IF(year=2,'10 Year Model'!AI15:AQ15,'30 Year Model'!AI15:AQ15))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA16:AI16,IF(year=2,'10 Year Model'!AA16:AI16,'30 Year Model'!AA16:AI16))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB16:AJ16,IF(year=2,'10 Year Model'!AB16:AJ16,'30 Year Model'!AB16:AJ16))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC16:AK16,IF(year=2,'10 Year Model'!AC16:AK16,'30 Year Model'!AC16:AK16))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD16:AL16,IF(year=2,'10 Year Model'!AD16:AL16,'30 Year Model'!AD16:AL16))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE16:AM16,IF(year=2,'10 Year Model'!AE16:AM16,'30 Year Model'!AE16:AM16))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF16:AN16,IF(year=2,'10 Year Model'!AF16:AN16,'30 Year Model'!AF16:AN16))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG16:AO16,IF(year=2,'10 Year Model'!AG16:AO16,'30 Year Model'!AG16:AO16))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH16:AP16,IF(year=2,'10 Year Model'!AH16:AP16,'30 Year Model'!AH16:AP16))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI16:AQ16,IF(year=2,'10 Year Model'!AI16:AQ16,'30 Year Model'!AI16:AQ16))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA17:AI17,IF(year=2,'10 Year Model'!AA17:AI17,'30 Year Model'!AA17:AI17))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB17:AJ17,IF(year=2,'10 Year Model'!AB17:AJ17,'30 Year Model'!AB17:AJ17))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC17:AK17,IF(year=2,'10 Year Model'!AC17:AK17,'30 Year Model'!AC17:AK17))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD17:AL17,IF(year=2,'10 Year Model'!AD17:AL17,'30 Year Model'!AD17:AL17))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE17:AM17,IF(year=2,'10 Year Model'!AE17:AM17,'30 Year Model'!AE17:AM17))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF17:AN17,IF(year=2,'10 Year Model'!AF17:AN17,'30 Year Model'!AF17:AN17))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG17:AO17,IF(year=2,'10 Year Model'!AG17:AO17,'30 Year Model'!AG17:AO17))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH17:AP17,IF(year=2,'10 Year Model'!AH17:AP17,'30 Year Model'!AH17:AP17))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI17:AQ17,IF(year=2,'10 Year Model'!AI17:AQ17,'30 Year Model'!AI17:AQ17))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA18:AI18,IF(year=2,'10 Year Model'!AA18:AI18,'30 Year Model'!AA18:AI18))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB18:AJ18,IF(year=2,'10 Year Model'!AB18:AJ18,'30 Year Model'!AB18:AJ18))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC18:AK18,IF(year=2,'10 Year Model'!AC18:AK18,'30 Year Model'!AC18:AK18))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD18:AL18,IF(year=2,'10 Year Model'!AD18:AL18,'30 Year Model'!AD18:AL18))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE18:AM18,IF(year=2,'10 Year Model'!AE18:AM18,'30 Year Model'!AE18:AM18))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF18:AN18,IF(year=2,'10 Year Model'!AF18:AN18,'30 Year Model'!AF18:AN18))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG18:AO18,IF(year=2,'10 Year Model'!AG18:AO18,'30 Year Model'!AG18:AO18))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH18:AP18,IF(year=2,'10 Year Model'!AH18:AP18,'30 Year Model'!AH18:AP18))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI18:AQ18,IF(year=2,'10 Year Model'!AI18:AQ18,'30 Year Model'!AI18:AQ18))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA19:AI19,IF(year=2,'10 Year Model'!AA19:AI19,'30 Year Model'!AA19:AI19))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB19:AJ19,IF(year=2,'10 Year Model'!AB19:AJ19,'30 Year Model'!AB19:AJ19))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC19:AK19,IF(year=2,'10 Year Model'!AC19:AK19,'30 Year Model'!AC19:AK19))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD19:AL19,IF(year=2,'10 Year Model'!AD19:AL19,'30 Year Model'!AD19:AL19))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE19:AM19,IF(year=2,'10 Year Model'!AE19:AM19,'30 Year Model'!AE19:AM19))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF19:AN19,IF(year=2,'10 Year Model'!AF19:AN19,'30 Year Model'!AF19:AN19))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG19:AO19,IF(year=2,'10 Year Model'!AG19:AO19,'30 Year Model'!AG19:AO19))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH19:AP19,IF(year=2,'10 Year Model'!AH19:AP19,'30 Year Model'!AH19:AP19))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI19:AQ19,IF(year=2,'10 Year Model'!AI19:AQ19,'30 Year Model'!AI19:AQ19))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA20:AI20,IF(year=2,'10 Year Model'!AA20:AI20,'30 Year Model'!AA20:AI20))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB20:AJ20,IF(year=2,'10 Year Model'!AB20:AJ20,'30 Year Model'!AB20:AJ20))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC20:AK20,IF(year=2,'10 Year Model'!AC20:AK20,'30 Year Model'!AC20:AK20))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD20:AL20,IF(year=2,'10 Year Model'!AD20:AL20,'30 Year Model'!AD20:AL20))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE20:AM20,IF(year=2,'10 Year Model'!AE20:AM20,'30 Year Model'!AE20:AM20))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF20:AN20,IF(year=2,'10 Year Model'!AF20:AN20,'30 Year Model'!AF20:AN20))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG20:AO20,IF(year=2,'10 Year Model'!AG20:AO20,'30 Year Model'!AG20:AO20))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH20:AP20,IF(year=2,'10 Year Model'!AH20:AP20,'30 Year Model'!AH20:AP20))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI20:AQ20,IF(year=2,'10 Year Model'!AI20:AQ20,'30 Year Model'!AI20:AQ20))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA21:AI21,IF(year=2,'10 Year Model'!AA21:AI21,'30 Year Model'!AA21:AI21))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB21:AJ21,IF(year=2,'10 Year Model'!AB21:AJ21,'30 Year Model'!AB21:AJ21))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC21:AK21,IF(year=2,'10 Year Model'!AC21:AK21,'30 Year Model'!AC21:AK21))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD21:AL21,IF(year=2,'10 Year Model'!AD21:AL21,'30 Year Model'!AD21:AL21))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE21:AM21,IF(year=2,'10 Year Model'!AE21:AM21,'30 Year Model'!AE21:AM21))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF21:AN21,IF(year=2,'10 Year Model'!AF21:AN21,'30 Year Model'!AF21:AN21))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG21:AO21,IF(year=2,'10 Year Model'!AG21:AO21,'30 Year Model'!AG21:AO21))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH21:AP21,IF(year=2,'10 Year Model'!AH21:AP21,'30 Year Model'!AH21:AP21))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI21:AQ21,IF(year=2,'10 Year Model'!AI21:AQ21,'30 Year Model'!AI21:AQ21))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA22:AI22,IF(year=2,'10 Year Model'!AA22:AI22,'30 Year Model'!AA22:AI22))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB22:AJ22,IF(year=2,'10 Year Model'!AB22:AJ22,'30 Year Model'!AB22:AJ22))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC22:AK22,IF(year=2,'10 Year Model'!AC22:AK22,'30 Year Model'!AC22:AK22))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD22:AL22,IF(year=2,'10 Year Model'!AD22:AL22,'30 Year Model'!AD22:AL22))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE22:AM22,IF(year=2,'10 Year Model'!AE22:AM22,'30 Year Model'!AE22:AM22))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF22:AN22,IF(year=2,'10 Year Model'!AF22:AN22,'30 Year Model'!AF22:AN22))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG22:AO22,IF(year=2,'10 Year Model'!AG22:AO22,'30 Year Model'!AG22:AO22))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH22:AP22,IF(year=2,'10 Year Model'!AH22:AP22,'30 Year Model'!AH22:AP22))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI22:AQ22,IF(year=2,'10 Year Model'!AI22:AQ22,'30 Year Model'!AI22:AQ22))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA23:AI23,IF(year=2,'10 Year Model'!AA23:AI23,'30 Year Model'!AA23:AI23))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB23:AJ23,IF(year=2,'10 Year Model'!AB23:AJ23,'30 Year Model'!AB23:AJ23))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC23:AK23,IF(year=2,'10 Year Model'!AC23:AK23,'30 Year Model'!AC23:AK23))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD23:AL23,IF(year=2,'10 Year Model'!AD23:AL23,'30 Year Model'!AD23:AL23))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE23:AM23,IF(year=2,'10 Year Model'!AE23:AM23,'30 Year Model'!AE23:AM23))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF23:AN23,IF(year=2,'10 Year Model'!AF23:AN23,'30 Year Model'!AF23:AN23))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG23:AO23,IF(year=2,'10 Year Model'!AG23:AO23,'30 Year Model'!AG23:AO23))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH23:AP23,IF(year=2,'10 Year Model'!AH23:AP23,'30 Year Model'!AH23:AP23))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI23:AQ23,IF(year=2,'10 Year Model'!AI23:AQ23,'30 Year Model'!AI23:AQ23))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA24:AI24,IF(year=2,'10 Year Model'!AA24:AI24,'30 Year Model'!AA24:AI24))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB24:AJ24,IF(year=2,'10 Year Model'!AB24:AJ24,'30 Year Model'!AB24:AJ24))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC24:AK24,IF(year=2,'10 Year Model'!AC24:AK24,'30 Year Model'!AC24:AK24))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD24:AL24,IF(year=2,'10 Year Model'!AD24:AL24,'30 Year Model'!AD24:AL24))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE24:AM24,IF(year=2,'10 Year Model'!AE24:AM24,'30 Year Model'!AE24:AM24))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF24:AN24,IF(year=2,'10 Year Model'!AF24:AN24,'30 Year Model'!AF24:AN24))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG24:AO24,IF(year=2,'10 Year Model'!AG24:AO24,'30 Year Model'!AG24:AO24))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH24:AP24,IF(year=2,'10 Year Model'!AH24:AP24,'30 Year Model'!AH24:AP24))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI24:AQ24,IF(year=2,'10 Year Model'!AI24:AQ24,'30 Year Model'!AI24:AQ24))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA25:AI25,IF(year=2,'10 Year Model'!AA25:AI25,'30 Year Model'!AA25:AI25))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB25:AJ25,IF(year=2,'10 Year Model'!AB25:AJ25,'30 Year Model'!AB25:AJ25))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC25:AK25,IF(year=2,'10 Year Model'!AC25:AK25,'30 Year Model'!AC25:AK25))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD25:AL25,IF(year=2,'10 Year Model'!AD25:AL25,'30 Year Model'!AD25:AL25))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE25:AM25,IF(year=2,'10 Year Model'!AE25:AM25,'30 Year Model'!AE25:AM25))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF25:AN25,IF(year=2,'10 Year Model'!AF25:AN25,'30 Year Model'!AF25:AN25))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG25:AO25,IF(year=2,'10 Year Model'!AG25:AO25,'30 Year Model'!AG25:AO25))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH25:AP25,IF(year=2,'10 Year Model'!AH25:AP25,'30 Year Model'!AH25:AP25))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI25:AQ25,IF(year=2,'10 Year Model'!AI25:AQ25,'30 Year Model'!AI25:AQ25))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA26:AI26,IF(year=2,'10 Year Model'!AA26:AI26,'30 Year Model'!AA26:AI26))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB26:AJ26,IF(year=2,'10 Year Model'!AB26:AJ26,'30 Year Model'!AB26:AJ26))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC26:AK26,IF(year=2,'10 Year Model'!AC26:AK26,'30 Year Model'!AC26:AK26))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD26:AL26,IF(year=2,'10 Year Model'!AD26:AL26,'30 Year Model'!AD26:AL26))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE26:AM26,IF(year=2,'10 Year Model'!AE26:AM26,'30 Year Model'!AE26:AM26))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF26:AN26,IF(year=2,'10 Year Model'!AF26:AN26,'30 Year Model'!AF26:AN26))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG26:AO26,IF(year=2,'10 Year Model'!AG26:AO26,'30 Year Model'!AG26:AO26))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH26:AP26,IF(year=2,'10 Year Model'!AH26:AP26,'30 Year Model'!AH26:AP26))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI26:AQ26,IF(year=2,'10 Year Model'!AI26:AQ26,'30 Year Model'!AI26:AQ26))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA27:AI27,IF(year=2,'10 Year Model'!AA27:AI27,'30 Year Model'!AA27:AI27))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB27:AJ27,IF(year=2,'10 Year Model'!AB27:AJ27,'30 Year Model'!AB27:AJ27))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC27:AK27,IF(year=2,'10 Year Model'!AC27:AK27,'30 Year Model'!AC27:AK27))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD27:AL27,IF(year=2,'10 Year Model'!AD27:AL27,'30 Year Model'!AD27:AL27))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE27:AM27,IF(year=2,'10 Year Model'!AE27:AM27,'30 Year Model'!AE27:AM27))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF27:AN27,IF(year=2,'10 Year Model'!AF27:AN27,'30 Year Model'!AF27:AN27))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG27:AO27,IF(year=2,'10 Year Model'!AG27:AO27,'30 Year Model'!AG27:AO27))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH27:AP27,IF(year=2,'10 Year Model'!AH27:AP27,'30 Year Model'!AH27:AP27))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI27:AQ27,IF(year=2,'10 Year Model'!AI27:AQ27,'30 Year Model'!AI27:AQ27))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA28:AI28,IF(year=2,'10 Year Model'!AA28:AI28,'30 Year Model'!AA28:AI28))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB28:AJ28,IF(year=2,'10 Year Model'!AB28:AJ28,'30 Year Model'!AB28:AJ28))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC28:AK28,IF(year=2,'10 Year Model'!AC28:AK28,'30 Year Model'!AC28:AK28))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD28:AL28,IF(year=2,'10 Year Model'!AD28:AL28,'30 Year Model'!AD28:AL28))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE28:AM28,IF(year=2,'10 Year Model'!AE28:AM28,'30 Year Model'!AE28:AM28))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF28:AN28,IF(year=2,'10 Year Model'!AF28:AN28,'30 Year Model'!AF28:AN28))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG28:AO28,IF(year=2,'10 Year Model'!AG28:AO28,'30 Year Model'!AG28:AO28))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH28:AP28,IF(year=2,'10 Year Model'!AH28:AP28,'30 Year Model'!AH28:AP28))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI28:AQ28,IF(year=2,'10 Year Model'!AI28:AQ28,'30 Year Model'!AI28:AQ28))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA29:AI29,IF(year=2,'10 Year Model'!AA29:AI29,'30 Year Model'!AA29:AI29))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB29:AJ29,IF(year=2,'10 Year Model'!AB29:AJ29,'30 Year Model'!AB29:AJ29))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC29:AK29,IF(year=2,'10 Year Model'!AC29:AK29,'30 Year Model'!AC29:AK29))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD29:AL29,IF(year=2,'10 Year Model'!AD29:AL29,'30 Year Model'!AD29:AL29))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE29:AM29,IF(year=2,'10 Year Model'!AE29:AM29,'30 Year Model'!AE29:AM29))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF29:AN29,IF(year=2,'10 Year Model'!AF29:AN29,'30 Year Model'!AF29:AN29))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG29:AO29,IF(year=2,'10 Year Model'!AG29:AO29,'30 Year Model'!AG29:AO29))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH29:AP29,IF(year=2,'10 Year Model'!AH29:AP29,'30 Year Model'!AH29:AP29))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI29:AQ29,IF(year=2,'10 Year Model'!AI29:AQ29,'30 Year Model'!AI29:AQ29))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA30:AI30,IF(year=2,'10 Year Model'!AA30:AI30,'30 Year Model'!AA30:AI30))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB30:AJ30,IF(year=2,'10 Year Model'!AB30:AJ30,'30 Year Model'!AB30:AJ30))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC30:AK30,IF(year=2,'10 Year Model'!AC30:AK30,'30 Year Model'!AC30:AK30))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD30:AL30,IF(year=2,'10 Year Model'!AD30:AL30,'30 Year Model'!AD30:AL30))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE30:AM30,IF(year=2,'10 Year Model'!AE30:AM30,'30 Year Model'!AE30:AM30))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF30:AN30,IF(year=2,'10 Year Model'!AF30:AN30,'30 Year Model'!AF30:AN30))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG30:AO30,IF(year=2,'10 Year Model'!AG30:AO30,'30 Year Model'!AG30:AO30))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH30:AP30,IF(year=2,'10 Year Model'!AH30:AP30,'30 Year Model'!AH30:AP30))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI30:AQ30,IF(year=2,'10 Year Model'!AI30:AQ30,'30 Year Model'!AI30:AQ30))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA31:AI31,IF(year=2,'10 Year Model'!AA31:AI31,'30 Year Model'!AA31:AI31))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB31:AJ31,IF(year=2,'10 Year Model'!AB31:AJ31,'30 Year Model'!AB31:AJ31))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC31:AK31,IF(year=2,'10 Year Model'!AC31:AK31,'30 Year Model'!AC31:AK31))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD31:AL31,IF(year=2,'10 Year Model'!AD31:AL31,'30 Year Model'!AD31:AL31))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE31:AM31,IF(year=2,'10 Year Model'!AE31:AM31,'30 Year Model'!AE31:AM31))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF31:AN31,IF(year=2,'10 Year Model'!AF31:AN31,'30 Year Model'!AF31:AN31))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG31:AO31,IF(year=2,'10 Year Model'!AG31:AO31,'30 Year Model'!AG31:AO31))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH31:AP31,IF(year=2,'10 Year Model'!AH31:AP31,'30 Year Model'!AH31:AP31))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI31:AQ31,IF(year=2,'10 Year Model'!AI31:AQ31,'30 Year Model'!AI31:AQ31))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA32:AI32,IF(year=2,'10 Year Model'!AA32:AI32,'30 Year Model'!AA32:AI32))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB32:AJ32,IF(year=2,'10 Year Model'!AB32:AJ32,'30 Year Model'!AB32:AJ32))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC32:AK32,IF(year=2,'10 Year Model'!AC32:AK32,'30 Year Model'!AC32:AK32))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD32:AL32,IF(year=2,'10 Year Model'!AD32:AL32,'30 Year Model'!AD32:AL32))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE32:AM32,IF(year=2,'10 Year Model'!AE32:AM32,'30 Year Model'!AE32:AM32))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF32:AN32,IF(year=2,'10 Year Model'!AF32:AN32,'30 Year Model'!AF32:AN32))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG32:AO32,IF(year=2,'10 Year Model'!AG32:AO32,'30 Year Model'!AG32:AO32))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH32:AP32,IF(year=2,'10 Year Model'!AH32:AP32,'30 Year Model'!AH32:AP32))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI32:AQ32,IF(year=2,'10 Year Model'!AI32:AQ32,'30 Year Model'!AI32:AQ32))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA33:AI33,IF(year=2,'10 Year Model'!AA33:AI33,'30 Year Model'!AA33:AI33))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB33:AJ33,IF(year=2,'10 Year Model'!AB33:AJ33,'30 Year Model'!AB33:AJ33))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC33:AK33,IF(year=2,'10 Year Model'!AC33:AK33,'30 Year Model'!AC33:AK33))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD33:AL33,IF(year=2,'10 Year Model'!AD33:AL33,'30 Year Model'!AD33:AL33))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE33:AM33,IF(year=2,'10 Year Model'!AE33:AM33,'30 Year Model'!AE33:AM33))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF33:AN33,IF(year=2,'10 Year Model'!AF33:AN33,'30 Year Model'!AF33:AN33))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG33:AO33,IF(year=2,'10 Year Model'!AG33:AO33,'30 Year Model'!AG33:AO33))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH33:AP33,IF(year=2,'10 Year Model'!AH33:AP33,'30 Year Model'!AH33:AP33))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI33:AQ33,IF(year=2,'10 Year Model'!AI33:AQ33,'30 Year Model'!AI33:AQ33))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA34:AI34,IF(year=2,'10 Year Model'!AA34:AI34,'30 Year Model'!AA34:AI34))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB34:AJ34,IF(year=2,'10 Year Model'!AB34:AJ34,'30 Year Model'!AB34:AJ34))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC34:AK34,IF(year=2,'10 Year Model'!AC34:AK34,'30 Year Model'!AC34:AK34))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD34:AL34,IF(year=2,'10 Year Model'!AD34:AL34,'30 Year Model'!AD34:AL34))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE34:AM34,IF(year=2,'10 Year Model'!AE34:AM34,'30 Year Model'!AE34:AM34))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF34:AN34,IF(year=2,'10 Year Model'!AF34:AN34,'30 Year Model'!AF34:AN34))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG34:AO34,IF(year=2,'10 Year Model'!AG34:AO34,'30 Year Model'!AG34:AO34))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH34:AP34,IF(year=2,'10 Year Model'!AH34:AP34,'30 Year Model'!AH34:AP34))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI34:AQ34,IF(year=2,'10 Year Model'!AI34:AQ34,'30 Year Model'!AI34:AQ34))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA35:AI35,IF(year=2,'10 Year Model'!AA35:AI35,'30 Year Model'!AA35:AI35))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB35:AJ35,IF(year=2,'10 Year Model'!AB35:AJ35,'30 Year Model'!AB35:AJ35))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC35:AK35,IF(year=2,'10 Year Model'!AC35:AK35,'30 Year Model'!AC35:AK35))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD35:AL35,IF(year=2,'10 Year Model'!AD35:AL35,'30 Year Model'!AD35:AL35))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE35:AM35,IF(year=2,'10 Year Model'!AE35:AM35,'30 Year Model'!AE35:AM35))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF35:AN35,IF(year=2,'10 Year Model'!AF35:AN35,'30 Year Model'!AF35:AN35))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG35:AO35,IF(year=2,'10 Year Model'!AG35:AO35,'30 Year Model'!AG35:AO35))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH35:AP35,IF(year=2,'10 Year Model'!AH35:AP35,'30 Year Model'!AH35:AP35))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI35:AQ35,IF(year=2,'10 Year Model'!AI35:AQ35,'30 Year Model'!AI35:AQ35))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA36:AI36,IF(year=2,'10 Year Model'!AA36:AI36,'30 Year Model'!AA36:AI36))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB36:AJ36,IF(year=2,'10 Year Model'!AB36:AJ36,'30 Year Model'!AB36:AJ36))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC36:AK36,IF(year=2,'10 Year Model'!AC36:AK36,'30 Year Model'!AC36:AK36))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD36:AL36,IF(year=2,'10 Year Model'!AD36:AL36,'30 Year Model'!AD36:AL36))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE36:AM36,IF(year=2,'10 Year Model'!AE36:AM36,'30 Year Model'!AE36:AM36))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF36:AN36,IF(year=2,'10 Year Model'!AF36:AN36,'30 Year Model'!AF36:AN36))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG36:AO36,IF(year=2,'10 Year Model'!AG36:AO36,'30 Year Model'!AG36:AO36))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH36:AP36,IF(year=2,'10 Year Model'!AH36:AP36,'30 Year Model'!AH36:AP36))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI36:AQ36,IF(year=2,'10 Year Model'!AI36:AQ36,'30 Year Model'!AI36:AQ36))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA37:AI37,IF(year=2,'10 Year Model'!AA37:AI37,'30 Year Model'!AA37:AI37))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB37:AJ37,IF(year=2,'10 Year Model'!AB37:AJ37,'30 Year Model'!AB37:AJ37))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC37:AK37,IF(year=2,'10 Year Model'!AC37:AK37,'30 Year Model'!AC37:AK37))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD37:AL37,IF(year=2,'10 Year Model'!AD37:AL37,'30 Year Model'!AD37:AL37))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE37:AM37,IF(year=2,'10 Year Model'!AE37:AM37,'30 Year Model'!AE37:AM37))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF37:AN37,IF(year=2,'10 Year Model'!AF37:AN37,'30 Year Model'!AF37:AN37))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG37:AO37,IF(year=2,'10 Year Model'!AG37:AO37,'30 Year Model'!AG37:AO37))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH37:AP37,IF(year=2,'10 Year Model'!AH37:AP37,'30 Year Model'!AH37:AP37))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI37:AQ37,IF(year=2,'10 Year Model'!AI37:AQ37,'30 Year Model'!AI37:AQ37))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA38:AI38,IF(year=2,'10 Year Model'!AA38:AI38,'30 Year Model'!AA38:AI38))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB38:AJ38,IF(year=2,'10 Year Model'!AB38:AJ38,'30 Year Model'!AB38:AJ38))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC38:AK38,IF(year=2,'10 Year Model'!AC38:AK38,'30 Year Model'!AC38:AK38))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD38:AL38,IF(year=2,'10 Year Model'!AD38:AL38,'30 Year Model'!AD38:AL38))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE38:AM38,IF(year=2,'10 Year Model'!AE38:AM38,'30 Year Model'!AE38:AM38))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF38:AN38,IF(year=2,'10 Year Model'!AF38:AN38,'30 Year Model'!AF38:AN38))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG38:AO38,IF(year=2,'10 Year Model'!AG38:AO38,'30 Year Model'!AG38:AO38))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH38:AP38,IF(year=2,'10 Year Model'!AH38:AP38,'30 Year Model'!AH38:AP38))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI38:AQ38,IF(year=2,'10 Year Model'!AI38:AQ38,'30 Year Model'!AI38:AQ38))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA39:AI39,IF(year=2,'10 Year Model'!AA39:AI39,'30 Year Model'!AA39:AI39))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB39:AJ39,IF(year=2,'10 Year Model'!AB39:AJ39,'30 Year Model'!AB39:AJ39))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC39:AK39,IF(year=2,'10 Year Model'!AC39:AK39,'30 Year Model'!AC39:AK39))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD39:AL39,IF(year=2,'10 Year Model'!AD39:AL39,'30 Year Model'!AD39:AL39))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE39:AM39,IF(year=2,'10 Year Model'!AE39:AM39,'30 Year Model'!AE39:AM39))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF39:AN39,IF(year=2,'10 Year Model'!AF39:AN39,'30 Year Model'!AF39:AN39))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG39:AO39,IF(year=2,'10 Year Model'!AG39:AO39,'30 Year Model'!AG39:AO39))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH39:AP39,IF(year=2,'10 Year Model'!AH39:AP39,'30 Year Model'!AH39:AP39))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI39:AQ39,IF(year=2,'10 Year Model'!AI39:AQ39,'30 Year Model'!AI39:AQ39))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA40:AI40,IF(year=2,'10 Year Model'!AA40:AI40,'30 Year Model'!AA40:AI40))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB40:AJ40,IF(year=2,'10 Year Model'!AB40:AJ40,'30 Year Model'!AB40:AJ40))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC40:AK40,IF(year=2,'10 Year Model'!AC40:AK40,'30 Year Model'!AC40:AK40))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD40:AL40,IF(year=2,'10 Year Model'!AD40:AL40,'30 Year Model'!AD40:AL40))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE40:AM40,IF(year=2,'10 Year Model'!AE40:AM40,'30 Year Model'!AE40:AM40))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF40:AN40,IF(year=2,'10 Year Model'!AF40:AN40,'30 Year Model'!AF40:AN40))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG40:AO40,IF(year=2,'10 Year Model'!AG40:AO40,'30 Year Model'!AG40:AO40))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH40:AP40,IF(year=2,'10 Year Model'!AH40:AP40,'30 Year Model'!AH40:AP40))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI40:AQ40,IF(year=2,'10 Year Model'!AI40:AQ40,'30 Year Model'!AI40:AQ40))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA41:AI41,IF(year=2,'10 Year Model'!AA41:AI41,'30 Year Model'!AA41:AI41))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB41:AJ41,IF(year=2,'10 Year Model'!AB41:AJ41,'30 Year Model'!AB41:AJ41))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC41:AK41,IF(year=2,'10 Year Model'!AC41:AK41,'30 Year Model'!AC41:AK41))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD41:AL41,IF(year=2,'10 Year Model'!AD41:AL41,'30 Year Model'!AD41:AL41))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE41:AM41,IF(year=2,'10 Year Model'!AE41:AM41,'30 Year Model'!AE41:AM41))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF41:AN41,IF(year=2,'10 Year Model'!AF41:AN41,'30 Year Model'!AF41:AN41))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG41:AO41,IF(year=2,'10 Year Model'!AG41:AO41,'30 Year Model'!AG41:AO41))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH41:AP41,IF(year=2,'10 Year Model'!AH41:AP41,'30 Year Model'!AH41:AP41))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI41:AQ41,IF(year=2,'10 Year Model'!AI41:AQ41,'30 Year Model'!AI41:AQ41))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA42:AI42,IF(year=2,'10 Year Model'!AA42:AI42,'30 Year Model'!AA42:AI42))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB42:AJ42,IF(year=2,'10 Year Model'!AB42:AJ42,'30 Year Model'!AB42:AJ42))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC42:AK42,IF(year=2,'10 Year Model'!AC42:AK42,'30 Year Model'!AC42:AK42))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD42:AL42,IF(year=2,'10 Year Model'!AD42:AL42,'30 Year Model'!AD42:AL42))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE42:AM42,IF(year=2,'10 Year Model'!AE42:AM42,'30 Year Model'!AE42:AM42))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF42:AN42,IF(year=2,'10 Year Model'!AF42:AN42,'30 Year Model'!AF42:AN42))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG42:AO42,IF(year=2,'10 Year Model'!AG42:AO42,'30 Year Model'!AG42:AO42))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH42:AP42,IF(year=2,'10 Year Model'!AH42:AP42,'30 Year Model'!AH42:AP42))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI42:AQ42,IF(year=2,'10 Year Model'!AI42:AQ42,'30 Year Model'!AI42:AQ42))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AA43:AI43,IF(year=2,'10 Year Model'!AA43:AI43,'30 Year Model'!AA43:AI43))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AB43:AJ43,IF(year=2,'10 Year Model'!AB43:AJ43,'30 Year Model'!AB43:AJ43))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC43:AK43,IF(year=2,'10 Year Model'!AC43:AK43,'30 Year Model'!AC43:AK43))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD43:AL43,IF(year=2,'10 Year Model'!AD43:AL43,'30 Year Model'!AD43:AL43))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE43:AM43,IF(year=2,'10 Year Model'!AE43:AM43,'30 Year Model'!AE43:AM43))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AF43:AN43,IF(year=2,'10 Year Model'!AF43:AN43,'30 Year Model'!AF43:AN43))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AG43:AO43,IF(year=2,'10 Year Model'!AG43:AO43,'30 Year Model'!AG43:AO43))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AH43:AP43,IF(year=2,'10 Year Model'!AH43:AP43,'30 Year Model'!AH43:AP43))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AI43:AQ43,IF(year=2,'10 Year Model'!AI43:AQ43,'30 Year Model'!AI43:AQ43))","v":{"$error":"#VALUE!"}}]
[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(year=1,'5 Year Model'!AB44:AJ44,IF(year=2,'10 Year Model'!AB44:AJ44,'30 Year Model'!AB44:AJ44))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AC44:AK44,IF(year=2,'10 Year Model'!AC44:AK44,'30 Year Model'!AC44:AK44))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AD44:AL44,IF(year=2,'10 Year Model'!AD44:AL44,'30 Year Model'!AD44:AL44))","v":{"$error":"#VALUE!"}},{"$f":"IF(year=1,'5 Year Model'!AE44:AM44,IF(year=2,'10 Year Model'!AE44:AM44,'30 Year Model'!AE44:AM44))","v":{"$error":"#VALUE!"}}]

{"sheet":"5 Year Model","index":7,"n_rows":52,"n_cols":35,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,26,0,34]]}
[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,"Cash Flow for Equivalent  Investments 5 Year Model"]
[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,"Analysis Price/Acre",{"$f":"price5","v":8000},null,null,null,"Certificate of Deposit",null,{"$f":"AC4","v":8000}]
["    ",null,{"$f":"'Sensitivity Tables'!$B$34","v":1},null,"   5 year horizon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acres",20,null,null,null,"Interest Rate",null,{"$f":"O14/(1-IncomeTax)","v":3.5420680374754272E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Analysis Price",null,null,null,null,null,null,null,null,null,null,"Total Purchase",{"$f":"price5","v":8000},null,null,null,"After Tax Cash Flows Reinvested Annually"]
[null,null,null,null,"Property Taxes",null,null,null,"Downpayment &",null,null,null,null,"Analysis Price:",{"$f":"analysis","v":8000},null,{"$f":"analysis","v":8000},null,null,null,null,null,null,null,null,null,null,"Net Cash Flows",null,"Income","After Tax",null,null,"Income","End-of-Year"]
[null,null,null,"Net","and Amortized","Debt","Debt","Interest ","Principal",null,"After Tax","Capital ",null,"Ending","Net After ",null,"Net Present",null,null,null,null,null,null,null,null,null,"Year","Including RE Taxes","Debt Payments","Taxes","Cash Flows",null,"Interest Income","Taxes","Value"]
[null,null,"Year","Cash Flows","Closing Costs","Payments","Outstanding","Payments","Payments","Depreciation","Cash Flows","Gains Tax","Land Value","Debt Value","Tax Cash Flows",null,"Value Calc.",null,null,{"$f":"solve5","v":-164.59},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"After Taxes"]
[null,"Initial Investment",0,null,null,null,null,null,{"$f":"O5*(1-financed)","v":2000},null,null,null,null,null,{"$f":"-(price5*closing)-I8","v":-2080},null,-2080,null,{"$f":"Q5","v":8000},-164.59,null,null,null,null,null,null,{"$f":"C8","v":0},{"$f":"price5*closing","v":80},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"price5*closing","v":80},null,null,null,{"$f":"AI2","v":8000}]
[null,{"$f":"CF","v":350},1,{"$f":"factor*CFlow5*(1+growcf5)^('5 Year Model'!C9-1)*acres","v":350},{"$f":"acres*PropertyTaxAc*(1+growcf5)^('5 Year Model'!C9-1)+(closing*price5/5)","v":46},{"$f":"IF(interest*amort>0,PMT(interest,amort,-'5 Year Model'!O5*financed),0)","v":523.10734186110869},{"$f":"O5*financed","v":6000},{"$f":"G9*interest","v":360},{"$f":"F9-H9","v":163.10734186110869},{"$f":"+Elect179+'Main-Land Bid Price'!AI2","v":0},{"$f":"(D9-E9-H9)*(1-IncomeTax)-I9+(closing*price5/5)+J9*IncomeTax","v":-187.42734186110869},null,{"$f":"O5*(1+growland5)","v":8160},null,{"$f":"K9","v":-187.42734186110869},null,-187.42734186110869,null,null,null,null,null,null,null,null,null,1,{"$f":"D9-E9+(closing*price5/5)","v":320},{"$f":"F9","v":523.10734186110869},{"$f":"AB9-AE9-AC9","v":-15.680000000000007},{"$f":"K9","v":-187.42734186110869},null,{"$f":"(1+$AI$3)^AA8*$AI$2*$AI$3","v":283.36544299803415},{"$f":"AG9*IncomeTax","v":79.342324039449565},{"$f":"AI8+AG9-AH9","v":8204.0231189585847}]
[null,{"$f":"GROWcf","v":0.02},2,{"$f":"factor*CFlow5*(1+growcf5)^('5 Year Model'!C10-1)*acres","v":357},{"$f":"acres*PropertyTaxAc*(1+growcf5)^('5 Year Model'!C10-1)+(closing*price5/5)","v":46.6},{"$f":"IF(C10<=amort,F9,0)","v":523.10734186110869},{"$f":"IF(C10<=amort,G9-I9,0)","v":5836.8926581388914},{"$f":"G10*interest","v":350.21355948833349},{"$f":"F10-H10","v":172.89378237277521},{"$f":"+'Main-Land Bid Price'!AI3","v":0},{"$f":"(D10-E10-H10)*(1-IncomeTax)-I10+(closing*price5/5)+J10*IncomeTax","v":-185.55954520437533},null,{"$f":"M9*(1+growland5)","v":8323.2000000000007},null,{"$f":"K10","v":-185.55954520437533},null,-185.55954520437533,null,null,null,null,null,null,null,null,null,2,{"$f":"D10-E10+(closing*price5/5)","v":326.39999999999998},{"$f":"F10","v":523.10734186110869},{"$f":"AB10-AE10-AC10","v":-11.147796656733362},{"$f":"K10","v":-185.55954520437533},null,{"$f":"AI9*$AI$3","v":290.59208068372669},{"$f":"AG10*IncomeTax","v":81.365782591443477},{"$f":"AI9+AG10-AH10","v":8413.2494170508689}]
[null,{"$f":"GROWland","v":0.02},3,{"$f":"factor*CFlow5*(1+growcf5)^('5 Year Model'!C11-1)*acres","v":364.14},{"$f":"acres*PropertyTaxAc*(1+growcf5)^('5 Year Model'!C11-1)+(closing*price5/5)","v":47.212000000000003},{"$f":"IF(C11<=amort,F10,0)","v":523.10734186110869},{"$f":"IF(C11<=amort,G10-I10,0)","v":5663.9988757661158},{"$f":"G11*interest","v":339.83993254596692},{"$f":"F11-H11","v":183.26740931514178},{"$f":"+'Main-Land Bid Price'!AI4","v":0},{"$f":"(D11-E11-H11)*(1-IncomeTax)-I11+(closing*price5/5)+J11*IncomeTax","v":-183.76400074823795},null,{"$f":"M10*(1+growland5)","v":8489.6640000000007},null,{"$f":"K11","v":-183.76400074823795},null,-183.76400074823795,null,null,null,null,null,null,null,null,null,3,{"$f":"D11-E11+(closing*price5/5)","v":332.928},{"$f":"F11","v":523.10734186110869},{"$f":"AB11-AE11-AC11","v":-6.4153411128708058},{"$f":"K11","v":-183.76400074823795},null,{"$f":"AI10*$AI$3","v":298.00301851444652},{"$f":"AG11*IncomeTax","v":83.440845184045031},{"$f":"AI10+AG11-AH11","v":8627.8115903812704}]
[null,2.8951081749911598E-2,4,{"$f":"factor*CFlow5*(1+growcf5)^('5 Year Model'!C12-1)*acres","v":371.4228},{"$f":"acres*PropertyTaxAc*(1+growcf5)^('5 Year Model'!C12-1)+(closing*price5/5)","v":47.836239999999997},{"$f":"IF(C12<=amort,F11,0)","v":523.10734186110869},{"$f":"IF(C12<=amort,G11-I11,0)","v":5480.731466450974},{"$f":"G12*interest","v":328.84388798705845},{"$f":"F12-H12","v":194.26345387405024},{"$f":"+'Main-Land Bid Price'!AI5","v":0},{"$f":"(D12-E12-H12)*(1-IncomeTax)-I12+(closing*price5/5)+J12*IncomeTax","v":-182.04873002473232},null,{"$f":"M11*(1+growland5)","v":8659.4572800000005},null,{"$f":"K12","v":-182.04873002473232},null,-182.04873002473232,null,null,null,null,null,null,null,null,null,4,{"$f":"D12-E12+(closing*price5/5)","v":339.58656000000002},{"$f":"F12","v":523.10734186110869},{"$f":"AB12-AE12-AC12","v":-1.4720518363764086},{"$f":"K12","v":-182.04873002473232},null,{"$f":"AI11*$AI$3","v":305.6029566764953},{"$f":"AG12*IncomeTax","v":85.568827869418698},{"$f":"AI11+AG12-AH12","v":8847.8457191883481}]
[null,"Terminal Value",5,{"$f":"factor*CFlow5*(1+growcf5)^('5 Year Model'!C13-1)*acres","v":378.85125599999998},{"$f":"acres*PropertyTaxAc*(1+growcf5)^('5 Year Model'!C13-1)+(closing*price5/5)","v":48.4729648},{"$f":"IF(C13<=amort,F12,0)","v":523.10734186110869},{"$f":"IF(C13<=amort,G12-I12,0)","v":5286.4680125769237},{"$f":"G13*interest","v":317.18808075461538},{"$f":"F13-H13","v":205.91926110649331},{"$f":"+'Main-Land Bid Price'!AI6","v":0},{"$f":"(D13-E13-H13)*(1-IncomeTax)-I13-(M13*closingEH)+(closing*price5/5)+J13*IncomeTax","v":-533.72816660981641},{"$f":"(M13+J14-O5-M13*closingEH)*CapitalGainsTax","v":71.90108528639999},{"$f":"M12*(1+growland5)","v":8832.6464255999999},{"$f":"G13-I13","v":5080.54875147043},{"$f":"K13+M13-L13-N13","v":3146.4684222333535},null,3146.4684222333535,null,null,null,null,null,null,null,null,null,5,{"$f":"D13-E13+(closing*price5/5)-M13*closingEH","v":-6.9275658239999984},{"$f":"F13","v":523.10734186110869},{"$f":"AB13-AE13-AC13","v":3.6932589247077203},{"$f":"K13","v":-533.72816660981641},null,{"$f":"AI12*$AI$3","v":313.39671522450834},{"$f":"AG13*IncomeTax","v":87.751080262862345},{"$f":"AI12+AG13-AH13","v":9073.4913541499936}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J9:J13)","v":0},null,null,null,null,{"$f":"IRR(range5)","v":2.5502889869823075E-2},{"$f":"SUM(P8:P13)","v":0},{"$f":"IRR(Q8:Q13,0)","v":2.5502889869822853E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"solve5*100","v":-16459},"Base",{"$f":"ROUND(NPV(discount,'5 Year Model'!$O$9:$O$13)+$O$8,2)","v":-164.59},null,399.41310687939614,null,null,null,null,null,null,null,null,null,null,"Final Debt Value",null,null,{"$f":"N13+0.000001","v":5080.5487524704304}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Base  \"&TEXT(-range/2,\"0.0%\")","v":"Base  -1.0%"},{"$f":"ROUND(NPV(discount-range/2,'5 Year Model'!$O$9:$O$13)+$O$8,2)","v":-52.62},null,365.35066669265558,null,null,null,null,null,null,null,null,null,null,"Final Land Value",null,null,{"$f":"M13-L13","v":8760.7453403136005}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Base  \"&TEXT(-range/4,\"0.0%\")","v":"Base  -0.5%"},{"$f":"ROUND(NPV(discount-range/4,'5 Year Model'!$O$9:$O$13)+$O$8,0)","v":-109}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Base   \"&TEXT(range/4,\"0.0%\")","v":"Base   0.5%"},{"$f":"ROUND(NPV(discount+range/4,'5 Year Model'!$O$9:$O$13)+$O$8,2)","v":-218.08},null,null,null,null,null,null,null,null,null,null,null,null,"Net Present Value",null,null,{"$f":"solve5","v":-164.59}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Base   \"&TEXT(range/2,\"0.0%\")","v":"Base   1.0%"},{"$f":"ROUND(NPV(discount+range/2,'5 Year Model'!$O$9:$O$13)+$O$8,2)","v":-269.98},null,433.37518719787482,null,null,null,null,null,null,null,null,null,null,"After-tax Yield",null,null,{"$f":"O14","v":2.5502889869823075E-2}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bid price  \"&TEXT(-range/2,\"0.0%\")","v":"Bid price  -1.0%"},7633.81,{"$f":"IF(O22<0,\"NA\",O22)","v":7633.81}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bid price  \"&TEXT(-range/4,\"0.0%\")","v":"Bid price  -0.5%"},7265.4,{"$f":"IF(O23<0,\"NA\",O23)","v":7265.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bid Price",6929.9,{"$f":"IF(O24<0,\"NA\",O24)","v":6929.9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bid price   \"&TEXT(range/4,\"0.0%\")","v":"Bid price   0.5%"},6625.12,{"$f":"IF(O25<0,\"NA\",O25)","v":6625.12}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bid price   \"&TEXT(range/2,\"0.0%\")","v":"Bid price   1.0%"},6346.46,{"$f":"IF(O26<0,\"NA\",O26)","v":6346.46}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1882.15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bid Price Grow 0",4586.8500000000004,{"$f":"IF(O28<0,\"NA\",O28)","v":4586.8500000000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bid Price Grow 1.0",5520.47,{"$f":"IF(O29<0,\"NA\",O29)","v":5520.47}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bid Price Grow 2.5",9303.52,{"$f":"IF(O30<0,\"NA\",O30)","v":9303.52}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bid Price Grow 5.0",29469.41,{"$f":"IF(O31<0,\"NA\",O31)","v":29469.41}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Growth rate \"&TEXT('Sensitivity Tables'!$I$54,\"0.0%\")","v":"Growth rate 3.0%"},2.1609104877170576E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Growth rate \"&TEXT('Sensitivity Tables'!$J$54,\"0.0%\")","v":"Growth rate 4.0%"},2.5242089859053629E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Growth rate \"&TEXT('Sensitivity Tables'!$K$54,\"0.0%\")","v":"Growth rate 5.0%"},2.8951081749911598E-2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Cash Growth rate \"&TEXT('Sensitivity Tables'!$J$54,\"0.0%\")","v":"Cash Growth rate 4.0%"},9.4695762973893302E-2]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Land Growth rate \"&TEXT('Sensitivity Tables'!$J$54,\"0.0%\")","v":"Land Growth rate 4.0%"},2.560602226161968E-2]
[]
[]
[]
[]
[]
[null,"Factor",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1107.24,null,6550.9,{"$f":"IF(Q48<0,\"NA\",Q48)","v":6550.9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1136.3699999999999,null,6740.41,{"$f":"IF(Q49<0,\"NA\",Q49)","v":6740.41}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1194.6500000000001,null,7119.4,{"$f":"IF(Q51<0,\"NA\",Q51)","v":7119.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1223.7873,null,7308.8561,{"$f":"IF(Q52<0,\"NA\",Q52)","v":7308.8561}]

{"sheet":"10 Year Model","index":8,"n_rows":52,"n_cols":35,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,26,0,34]]}
[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,"Cash Flow for Equivalent  Investments 10 Year Model"]
[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,"Analysis Price/Acre",{"$f":"AC4/AC3","v":8000},null,null,null,"Certificate of Deposit",null,{"$f":"AC4","v":8000}]
[null,null,{"$f":"'Sensitivity Tables'!$B$34","v":1},null,"    10 year horizon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acres",{"$f":"acres","v":1},null,null,null,"Interest Rate",null,{"$f":"O19/(1-IncomeTax)","v":5.6729303894159339E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Analysis Price",null,null,null,null,null,null,null,null,null,null,"Total Purchase",{"$f":"price10","v":8000},null,null,null,"After Tax Cash Flows Reinvested Annually"]
[null,null,null,null,"Property Taxes",null,null,null,"Downpayment &",null,null,null,null,"Analysis Price:",{"$f":"analysis","v":8000},null,{"$f":"'Sensitivity Tables'!C18","v":8000},null,null,null,null,null,null,null,null,null,null,"Net Cash Flows",null,"Income","After Tax",null,null,"Income","End-of-Year"]
[null,1,null,"Net","and Amortized","Debt","Debt","Interest ","Principal",null,"After Tax","Capital ",null,"Ending","Net After Tax",null,"Net Present",null,null,null,null,null,null,null,null,null,"Year","Including RE Taxes","Debt Payments","Taxes","Cash Flows",null,"Interest Income","Taxes","Value"]
[null,null,"Year","Cash Flows","Closing Costs","Payments","Outstanding","Payments","Payments","Depreciation","Cash Flows","Gains Tax","Land Value","Debt Value","Cash Flows",null,"Value Calc.",null,null,null,null,null,null,null,null,null,null,"& Loan Fees",null,null,null,null,null,null,"After Taxes"]
[null,"Initial Investment",0,null,null,null,null,null,{"$f":"O5*(1-financed)","v":2000},null,{"$f":"-I8","v":-2000},null,null,null,{"$f":"-(price10*closing)-I8","v":-2080},null,-2080,null,null,null,null,null,null,null,null,null,{"$f":"C8","v":0},{"$f":"price10*closing","v":80},{"$f":"F8","v":0},null,{"$f":"price10*closing","v":80},null,null,null,{"$f":"AI2","v":8000}]
[null,{"$f":"CF","v":350},1,{"$f":"factor*CFlow10*(1+growcf10)^('10 Year Model'!C9-1)*acres","v":350},{"$f":"acres*PropertyTaxAc*(1+growcf10)^('10 Year Model'!C9-1)+(price10*closing/10)","v":38},{"$f":"IF(interest*amort>0,PMT(interest,amort,-'10 Year Model'!O5*financed),0)","v":523.10734186110869},{"$f":"O5*financed","v":6000},{"$f":"G9*interest","v":360},{"$f":"F9-H9","v":163.10734186110869},{"$f":"+Elect179+'Main-Land Bid Price'!AI2","v":0},{"$f":"(D9-E9-H9)*(1-IncomeTax)-I9+(price10*closing/10)+J9*IncomeTax","v":-189.6673418611087},null,{"$f":"O5*(1+growland10)","v":8160},null,{"$f":"K9","v":-189.6673418611087},null,-189.6673418611087,null,null,null,null,null,null,null,null,null,1,{"$f":"D9-E9+(closing*price10/10)","v":320},523.10734186110869,{"$f":"AB9-AE9-AC9","v":-13.439999999999998},{"$f":"K9","v":-189.6673418611087},null,{"$f":"(1+$AI$3)^AA8*$AI$2*$AI$3","v":453.83443115327469},{"$f":"AG9*IncomeTax","v":127.07364072291692},{"$f":"AI8+AG9-AH9","v":8326.7607904303586}]
[null,{"$f":"GROWcf","v":0.02},2,{"$f":"factor*CFlow10*(1+growcf10)^('10 Year Model'!C10-1)*acres","v":357},{"$f":"acres*PropertyTaxAc*(1+growcf10)^('10 Year Model'!C10-1)+(price10*closing/10)","v":38.6},{"$f":"IF(C10<=amort,F9,0)","v":523.10734186110869},{"$f":"IF(C10<=amort,G9-I9,0)","v":5836.8926581388914},{"$f":"G10*interest","v":350.21355948833349},{"$f":"F10-H10","v":172.89378237277521},{"$f":"+'Main-Land Bid Price'!AI3","v":0},-187.79954520437533,null,{"$f":"M9*(1+growland10)","v":8323.2000000000007},null,{"$f":"K10","v":-187.79954520437533},null,-187.79954520437533,null,null,null,null,null,null,null,null,null,2,{"$f":"D10-E10+(closing*price10/10)","v":326.39999999999998},523.10734186110869,-8.9077966567333533,-187.79954520437533,null,{"$f":"AI9*$AI$3","v":472.37134333429424},{"$f":"AG10*IncomeTax","v":132.2639761336024},8666.8681576310501]
[null,{"$f":"GROWland","v":0.02},3,{"$f":"factor*CFlow10*(1+growcf10)^('10 Year Model'!C11-1)*acres","v":364.14},{"$f":"acres*PropertyTaxAc*(1+growcf10)^('10 Year Model'!C11-1)+(price10*closing/10)","v":39.212000000000003},{"$f":"IF(C11<=amort,F10,0)","v":523.10734186110869},{"$f":"IF(C11<=amort,G10-I10,0)","v":5663.9988757661158},339.83993254596692,183.26740931514178,{"$f":"+'Main-Land Bid Price'!AI4","v":0},-186.00400074823796,null,{"$f":"M10*(1+growland10)","v":8489.6640000000007},null,-186.00400074823796,null,-186.00400074823796,null,null,null,null,null,null,null,null,null,3,332.928,523.10734186110869,-4.1753411128707967,-186.00400074823796,null,491.66539752486472,137.66631130696214,9020.8672438489521]
[null,2.4112235989268396E-2,4,{"$f":"factor*CFlow10*(1+growcf10)^('10 Year Model'!C12-1)*acres","v":371.4228},{"$f":"acres*PropertyTaxAc*(1+growcf10)^('10 Year Model'!C12-1)+(price10*closing/10)","v":39.836239999999997},523.10734186110869,5480.731466450974,328.84388798705845,194.26345387405024,{"$f":"+'Main-Land Bid Price'!AI5","v":0},-184.2887300247323,null,8659.4572800000005,null,-184.2887300247323,null,-184.2887300247323,null,null,null,null,null,null,null,null,null,4,339.58656000000002,523.10734186110869,0.76794816362360052,-184.2887300247323,null,511.74751926517479,143.28930539424894,9389.3254577198768]
[null,null,5,{"$f":"factor*CFlow10*(1+growcf10)^('10 Year Model'!C13-1)*acres","v":378.85125599999998},{"$f":"acres*PropertyTaxAc*(1+growcf10)^('10 Year Model'!C13-1)+(price10*closing/10)","v":40.4729648},523.10734186110869,5286.4680125769237,317.18808075461538,205.91926110649331,{"$f":"+'Main-Land Bid Price'!AI6","v":0},-182.66230958581639,null,8832.6464255999999,null,-182.66230958581639,null,-182.66230958581639,null,null,null,null,null,null,null,null,null,5,346.37829119999998,523.10734186110869,5.9332589247077294,-182.66230958581639,null,532.64989725215764,149.14197123060416,9772.8333837414302]
[null,null,6,{"$f":"factor*CFlow10*(1+growcf10)^('10 Year Model'!C14-1)*acres","v":386.42828112000001},{"$f":"acres*PropertyTaxAc*(1+growcf10)^('10 Year Model'!C14-1)+(price10*closing/10)","v":41.122424096000003},523.10734186110869,5080.54875147043,304.83292508822581,218.27441677288289,{"$f":"+'Main-Land Bid Price'!AI7","v":0},-181.13390577912546,null,9009.2993541119995,null,-181.13390577912546,null,-181.13390577912546,null,null,null,null,null,null,null,null,null,{"$f":"C14","v":6},353.30585702400003,{"$f":"F14","v":523.10734186110869},11.332420942016824,-181.13390577912546,null,554.40603493325307,155.23368978131089,10172.005728893371]
[null,null,7,{"$f":"factor*CFlow10*(1+growcf10)^('10 Year Model'!C15-1)*acres","v":394.15684674240003},{"$f":"acres*PropertyTaxAc*(1+growcf10)^('10 Year Model'!C15-1)+(price10*closing/10)","v":41.784872577920005},523.10734186110869,4862.2743346975476,291.73646008185284,231.37088177925585,{"$f":"+'Main-Land Bid Price'!AI8","v":0},-179.71331163976427,null,9189.4853411942404,null,-179.71331163976427,null,-179.71331163976427,null,null,null,null,null,null,null,null,null,{"$f":"C15","v":7},360.37197416448004,{"$f":"F15","v":523.10734186110869},16.977943943135642,-179.71331163976427,null,577.05080420752188,161.57422517810613,10587.482307922786]
[null,null,8,{"$f":"factor*CFlow10*(1+growcf10)^('10 Year Model'!C16-1)*acres","v":402.03998367724796},{"$f":"acres*PropertyTaxAc*(1+growcf10)^('10 Year Model'!C16-1)+(price10*closing/10)","v":42.460570029478397},523.10734186110869,4630.9034529182918,277.85420717509749,245.25313468601121,{"$f":"+'Main-Land Bid Price'!AI9","v":0},-178.41098602568729,null,9373.2750480181257,null,-178.41098602568729,null,-178.41098602568729,null,null,null,null,null,null,null,null,null,{"$f":"C16","v":8},367.57941364776957,{"$f":"F16","v":523.10734186110869},22.88305781234817,-178.41098602568729,null,600.62050132018726,168.17374036965245,11019.929068873322]
[null,null,9,{"$f":"factor*CFlow10*(1+growcf10)^('10 Year Model'!C17-1)*acres","v":410.08078335079296},{"$f":"acres*PropertyTaxAc*(1+growcf10)^('10 Year Model'!C17-1)+(price10*closing/10)","v":43.149781430067968},523.10734186110869,4385.6503182322804,263.13901909393684,259.96832276717186,{"$f":"+'Main-Land Bid Price'!AI10","v":0},-177.23809513188439,null,9560.7405489784887,null,-177.23809513188439,null,-177.23809513188439,null,null,null,null,null,null,null,null,null,{"$f":"C17","v":9},374.93100192072501,{"$f":"F17","v":523.10734186110869},29.061755191500765,-177.23809513188439,null,625.15290504019504,175.04281341125463,11470.039160502261]
[null,"Terminal Value",10,{"$f":"factor*CFlow10*(1+growcf10)^('10 Year Model'!C18-1)*acres","v":418.28239901780881},{"$f":"acres*PropertyTaxAc*(1+growcf10)^('10 Year Model'!C18-1)+(price10*closing/10)","v":43.852777058669325},523.10734186110869,4125.6819954651082,247.5409197279065,275.5664221332022,{"$f":"+'Main-Land Bid Price'!AI11","v":0},{"$f":"(D18-E18-H18)*(1-IncomeTax)-I18-(M18*closingEH)+(price10*closing/10)+J18*IncomeTax","v":-566.28477092503681},{"$f":"(M18+J19-O5-M18*closingEH)*CapitalGainsTax","v":204.28157183396056},9751.9553599580595,{"$f":"G18-I18","v":3850.115573331906},{"$f":"K18+M18-L18-N18","v":5131.2734438671559},null,5131.2734438671559,null,null,null,null,null,null,null,null,null,{"$f":"C18","v":10},{"$f":"D18-E18+(closing*price10/10)-M18*closingEH","v":-7.6485924391829485},{"$f":"F18","v":523.10734186110869},{"$f":"AB18-AE18-AC18","v":35.528836624745168},-566.28477092503681,null,650.68733721404101,182.19245441993149,11938.534043296371]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J9:J18)","v":0},null,null,null,null,{"$f":"IRR(Range10)","v":4.0845098803794722E-2},"Yield",{"$f":"IRR(Q8:Q18,0)","v":4.0845098801470803E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"solve10*100","v":2287}," Base",{"$f":"ROUND(NPV(discount,'10 Year Model'!$O$9:$O$18)+$O$8,2)","v":22.87},null,346.40085431654677,null,null,null,null,null,null,null,null,null,null,"Final Debt Value",null,null,{"$f":"N18+0.0000001","v":3850.1155734319059}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Base  \"&TEXT(-range/2,\"0.0%\")","v":"Base  -1.0%"},{"$f":"ROUND(NPV(discount-range/2,'10 Year Model'!$O$9:$O$18)+$O$8,2)","v":310.97000000000003},null,303.53623270573257,null,null,null,null,null,null,null,null,null,null,"Final Land Value",null,null,{"$f":"M18-L18","v":9547.6737881240988}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Base  \"&TEXT(-range/4,\"0.0%\")","v":"Base  -0.5%"},{"$f":"ROUND(NPV(discount-range/4,'10 Year Model'!$O$9:$O$18)+$O$8,2)","v":162.79}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Base   \"&TEXT(range/4,\"0.0%\")","v":"Base   0.5%"},{"$f":"ROUND(NPV(discount+range/4,'10 Year Model'!$O$9:$O$18)+$O$8,2)","v":-109.28},null,null,null,null,null,null,null,null,null,null,null,null,"Net Present Value",null,null,{"$f":"solve10","v":22.87}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Base   \"&TEXT(range/2,\"0.0%\")","v":"Base   1.0%"},{"$f":"ROUND(NPV(discount+range/2,'10 Year Model'!$O$9:$O$18)+$O$8,2)","v":-234.12},null,388.76580263392867,null,null,null,null,null,null,null,null,null,null,"After-tax Yield",null,null,{"$f":"O19","v":4.0845098803794722E-2}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bid price  \"&TEXT(-range/2,\"0.0%\")","v":"Bid price  -1.0%"},9358.9,{"$f":"IF(O26<0,\"NA\",O26)","v":9358.9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bid price  \"&TEXT(-range/4,\"0.0%\")","v":"Bid price  -0.5%"},8677.0300000000007,{"$f":"IF(O27<0,\"NA\",O27)","v":8677.0300000000007}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bid Price",8091.02,{"$f":"IF(O28<0,\"NA\",O28)","v":8091.02}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bid price   \"&TEXT(range/4,\"0.0%\")","v":"Bid price   0.5%"},7581.93,{"$f":"IF(O29<0,\"NA\",O29)","v":7581.93}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bid price   \"&TEXT(range/2,\"0.0%\")","v":"Bid price   1.0%"},7135.58,{"$f":"IF(O30<0,\"NA\",O30)","v":7135.58}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bid Price Grow 0",5023.38,{"$f":"IF(O32<0,\"NA\",O32)","v":5023.38}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bid Price Grow 1.0",6199.87,{"$f":"IF(O33<0,\"NA\",O33)","v":6199.87}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bid Price Grow 2.5",11631.96,{"$f":"IF(O34<0,\"NA\",O34)","v":11631.96}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bid Price Grow 5.0",91355.81,{"$f":"IF(O35<0,\"NA\",O35)","v":91355.81}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Growth rate \"&TEXT('Sensitivity Tables'!$I$54,\"0.0%\")","v":"Growth rate 3.0%"},1.5290362287768172E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Growth rate \"&TEXT('Sensitivity Tables'!$J$54,\"0.0%\")","v":"Growth rate 4.0%"},1.9626682669639042E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Growth rate \"&TEXT('Sensitivity Tables'!$K$54,\"0.0%\")","v":"Growth rate 5.0%"},2.4112235989268396E-2]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Cash Growth rate \"&TEXT('Sensitivity Tables'!$J$54,\"0.0%\")","v":"Cash Growth rate 4.0%"},1.7338091706670104E-2]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Land Growth rate \"&TEXT('Sensitivity Tables'!$J$54,\"0.0%\")","v":"Land Growth rate 4.0%"},1.9565241548574884E-2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7648.52,{"$f":"IF(Q48<0,\"NA\",Q48)","v":7648.52}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7869.78,{"$f":"IF(Q49<0,\"NA\",Q49)","v":7869.78}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8312.25,{"$f":"IF(Q51<0,\"NA\",Q51)","v":8312.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8533.4699999999993,{"$f":"IF(Q52<0,\"NA\",Q52)","v":8533.4699999999993}]

{"sheet":"30 Year Model","index":9,"n_rows":65,"n_cols":35,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,26,0,34]]}
[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,"Cash Flow for Equivalent  Investments 30 Year Model"]
[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,"Analysis Price/Acre",{"$f":"AC4/AC3","v":8000},null,null,null,"Certificate of Deposit",null,{"$f":"AC4","v":8000}]
[null,null,{"$f":"'Sensitivity Tables'!$B$34","v":1},null,"  30 year horizon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acres",{"$f":"acres","v":1},null,null,null,"Interest Rate",null,{"$f":"O39/(1-IncomeTax)","v":6.6002326712034473E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Analysis Price",null,null,null,null,null,null,null,null,null,null,"Total Purchase",{"$f":"price30","v":8000},null,null,null,"After Tax Cash Flows Reinvested Annually"]
[null,null,null,null,"Property Taxes",null,null,null,"Downpayment &",null,null,null,null,"Analysis Price",{"$f":"analysis","v":8000},null,{"$f":"analysis","v":8000},null,null,null,null,null,null,null,null,null,null,"Net Cash Flows",null,"Income","After Tax",null,null,"Income","End-of-Year"]
[null,null,null,"Net","and Amortized","Debt","Debt","Interest ","Principal",null,"After Tax","Capital ",null,"Ending","Net After ",null,"Net Present",null,null,null,null,null,null,null,null,null,"Year","Including RE Taxes","Debt Payments","Taxes","Cash Flows",null,"Interest Income","Taxes","Value"]
[null,null,"Year","Cash Flows","Closing Costs","Payments","Outstanding","Payments","Payments","Depreciation","Cash Flows","Gains Tax","Land Value","Debt Value","Tax Cash Flows",null,"Value Calc.",null,null,null,null,null,null,null,null,null,null,"& Loan Fees",null,null,null,null,null,null,"After Taxes"]
[null,"Initial Investment",0,null,null,null,null,null,{"$f":"O5*(1-financed)","v":2000},null,{"$f":"-I8","v":-2000},null,null,null,{"$f":"-(price30*closing)-I8","v":-2080},null,-2080,null,null,null,null,null,null,null,null,null,{"$f":"C8","v":0},{"$f":"price30*closing","v":80},{"$f":"F8","v":0},null,{"$f":"price30*closing","v":80},null,null,null,{"$f":"AI2","v":8000}]
[null,{"$f":"CF","v":350},1,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C9-1)*acres","v":350},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C9-1)+(price30*closing/30)","v":32.666666666666664},{"$f":"IF(interest*amort>0,PMT(interest,amort,-'30 Year Model'!O5*financed),0)","v":523.10734186110869},{"$f":"O5*financed","v":6000},{"$f":"G9*interest","v":360},{"$f":"F9-H9","v":163.10734186110869},{"$f":"+Elect179+'Main-Land Bid Price'!AI2","v":0},{"$f":"(D9-E9-H9)*(1-IncomeTax)-I9+(price30*closing/30)+J9*IncomeTax","v":-191.16067519444206},null,{"$f":"O5*(1+growland30)","v":8160},null,{"$f":"K9","v":-191.16067519444206},null,-191.16067519444206,null,null,null,null,null,null,null,null,null,{"$f":"C9","v":1},{"$f":"D9-E9+(closing*price30/30)","v":320},{"$f":"F9","v":523.10734186110869},{"$f":"AB9-AE9-AC9","v":-11.946666666666601},{"$f":"K9","v":-191.16067519444206},null,{"$f":"(1+$AI$3)^AA8*$AI$2*$AI$3","v":528.01861369627579},{"$f":"AG9*IncomeTax","v":147.84521183495724},{"$f":"AI8+AG9-AH9","v":8380.1734018613188}]
[null,{"$f":"GROWcf","v":0.02},2,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C10-1)*acres","v":357},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C10-1)+(price30*closing/30)","v":33.266666666666666},{"$f":"IF(C10<=amort,F9,0)","v":523.10734186110869},{"$f":"IF(C10<=amort,G9-I9,0)","v":5836.8926581388914},{"$f":"G10*interest","v":350.21355948833349},{"$f":"F10-H10","v":172.89378237277521},{"$f":"'Main-Land Bid Price'!AI3","v":0},-189.29287853770865,null,{"$f":"M9*(1+growland30)","v":8323.2000000000007},null,{"$f":"K10","v":-189.29287853770865},null,-189.29287853770865,null,null,null,null,null,null,null,null,null,2,{"$f":"D10-E10+(closing*price30/30)","v":326.40000000000003},523.10734186110869,{"$f":"AB10-AE10-AC10","v":-7.4144633234000139},-189.29287853770865,null,{"$f":"AI9*$AI$3","v":553.11094277315215},{"$f":"AG10*IncomeTax","v":154.87106397648262},{"$f":"AI9+AG10-AH10","v":8778.4132806579873}]
[null,{"$f":"GROWland","v":0.02},{"$f":"C10+1","v":3},{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C11-1)*acres","v":364.14},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C11-1)+(price30*closing/30)","v":33.878666666666668},523.10734186110869,{"$f":"IF(C11<=amort,G10-I10,0)","v":5663.9988757661158},339.83993254596692,183.26740931514178,{"$f":"'Main-Land Bid Price'!AI4","v":0},-187.49733408157132,null,{"$f":"M10*(1+growland30)","v":8489.6640000000007},null,-187.49733408157132,null,-187.49733408157132,null,null,null,null,null,null,null,null,null,3,332.928,523.10734186110869,-2.6820077795373436,-187.49733408157132,null,{"$f":"AI10*$AI$3","v":579.39570136325085},162.23079638171026,9195.5781856395279]
[null,2.1752511787240077E-2,{"$f":"C11+1","v":4},{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C12-1)*acres","v":371.4228},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C12-1)+(price30*closing/30)","v":34.502906666666661},523.10734186110869,5480.731466450974,328.84388798705845,194.26345387405024,{"$f":"'Main-Land Bid Price'!AI5","v":0},-185.78206335806567,null,8659.4572800000005,null,-185.78206335806567,null,-185.78206335806567,null,null,null,null,null,null,null,null,null,4,339.58656000000002,523.10734186110869,2.2612814969569399,-185.78206335806567,null,606.92955571463733,169.94027560009846,9632.5674657540676]
[null,null,{"$f":"C12+1","v":5},{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C13-1)*acres","v":378.85125599999998},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C13-1)+(price30*closing/30)","v":35.139631466666664},523.10734186110869,5286.4680125769237,317.18808075461538,205.91926110649331,{"$f":"'Main-Land Bid Price'!AI6","v":0},-184.15564291914976,null,8832.6464255999999,null,-184.15564291914976,null,-184.15564291914976,null,null,null,null,null,null,null,null,null,5,346.37829119999998,523.10734186110869,7.4265922580410688,-184.15564291914976,null,635.77186495041394,178.01612218611592,10090.323208518364]
[null,null,6,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C14-1)*acres","v":386.42828112000001},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C14-1)+(price30*closing/30)","v":35.789090762666667},523.10734186110869,5080.54875147043,304.83292508822581,218.27441677288289,{"$f":"'Main-Land Bid Price'!AI7","v":0},-182.6272391124588,null,9009.2993541119995,null,-182.6272391124588,null,-182.6272391124588,null,null,null,null,null,null,null,null,null,6,353.30585702400003,523.10734186110869,12.825754275350164,-182.6272391124588,null,665.984809038653,186.47574653082285,10569.832271026195]
[null,null,7,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C15-1)*acres","v":394.15684674240003},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C15-1)+(price30*closing/30)","v":36.451539244586669},523.10734186110869,4862.2743346975476,291.73646008185284,231.37088177925585,{"$f":"'Main-Land Bid Price'!AI8","v":0},-181.20664497309764,null,9189.4853411942404,null,-181.20664497309764,null,-181.20664497309764,null,null,null,null,null,null,null,null,null,7,360.37197416448004,523.10734186110869,18.471277276468982,-181.20664497309764,null,697.63352284367625,195.33738639622936,11072.128407473641]
[null,null,8,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C16-1)*acres","v":402.03998367724796},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C16-1)+(price30*closing/30)","v":37.127236696145062},523.10734186110869,4630.9034529182918,277.85420717509749,245.25313468601121,{"$f":"'Main-Land Bid Price'!AI9","v":0},-179.90431935902066,null,9373.2750480181257,null,-179.90431935902066,null,-179.90431935902066,null,null,null,null,null,null,null,null,null,8,367.57941364776957,523.10734186110869,24.376391145681509,-179.90431935902066,null,730.78623654767318,204.62014623334852,11598.294497787967]
[null,null,9,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C17-1)*acres","v":410.08078335079296},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C17-1)+(price30*closing/30)","v":37.816448096734632},523.10734186110869,4385.6503182322804,263.13901909393684,259.96832276717186,{"$f":"'Main-Land Bid Price'!AI10","v":0},-178.73142846521773,null,9560.7405489784887,null,-178.73142846521773,null,-178.73142846521773,null,null,null,null,null,null,null,null,null,9,374.93100192072501,523.10734186110869,30.555088524834105,-178.73142846521773,null,765.51442274539318,214.3440383687101,12149.46488216465]
[null,null,10,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C18-1)*acres","v":418.28239901780881},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C18-1)+(price30*closing/30)","v":38.519443725335989},523.10734186110869,4125.6819954651082,247.5409197279065,275.5664221332022,{"$f":"'Main-Land Bid Price'!AI11","v":0},-177.69988986004776,null,9751.9553599580595,null,-177.69988986004776,null,-177.69988986004776,null,null,null,null,null,null,null,null,null,{"$f":"C18","v":10},382.42962195913952,{"$f":"F18","v":523.10734186110869},{"$f":"AB18-AE18-AC18","v":37.022169958078621},{"$f":"K18","v":-177.69988986004776},null,{"$f":"AI17*$AI$3","v":801.8929505290206},224.53002614812578,{"$f":"AI17+AG18-AH18","v":12726.827806545543}]
[null,null,11,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C19-1)*acres","v":426.648046998165},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C19-1)+(price30*closing/30)","v":39.236499266509377},523.10734186110869,3850.115573331906,231.00693439991434,292.10040746119432,{"$f":"'Main-Land Bid Price'!AI12","v":0},-176.82241919567397,null,9946.9944671572212,null,-176.82241919567397,null,-176.82241919567397,null,null,null,null,null,null,null,null,null,11,390.0782143983223,523.10734186110869,43.79329173288761,-176.82241919567397,null,840.00024689542397,235.20006913071873,13331.627984310249]
[null,null,12,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C20-1)*acres","v":435.18100793812823},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C20-1)+(price30*closing/30)","v":39.967895918506223},523.10734186110869,3558.0151658707118,213.48090995224271,309.62643190886598,{"$f":"'Main-Land Bid Price'!AI13","v":0},-176.11257975368622,null,10145.934356500366,null,-176.11257975368622,null,-176.11257975368622,null,null,null,null,null,null,null,null,null,12,397.87977868628872,523.10734186110869,50.885016578866271,-176.11257975368622,null,879.91846582374671,246.3771704306491,13965.169279703347]
[null,null,13,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C21-1)*acres","v":443.88462809689082},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C21-1)+(price30*closing/30)","v":40.713920503543022},523.10734186110869,3248.3887339618459,194.90332403771075,328.20401782339798,{"$f":"'Main-Land Bid Price'!AI14","v":0},-175.58483499667264,null,10348.853043630374,null,-175.58483499667264,null,-175.58483499667264,null,null,null,null,null,null,null,null,null,13,405.83737426001449,523.10734186110869,58.314867395578403,-175.58483499667264,null,921.7336653878474,258.08542630859728,14628.817518782598]
[null,null,14,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C22-1)*acres","v":452.76232065882863},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C22-1)+(price30*closing/30)","v":41.47486558028055},523.10734186110869,2920.184716138448,175.21108296830687,347.89625889280182,{"$f":"'Main-Land Bid Price'!AI15","v":0},-175.25460430676151,null,10555.830104502982,null,-175.25460430676151,null,-175.25460430676151,null,null,null,null,null,null,null,null,null,14,413.95412174521476,523.10734186110869,66.101384190867634,-175.25460430676151,null,965.53599328542259,270.35007811991835,15324.003433948103]
[null,null,15,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C23-1)*acres","v":461.81756707200526},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C23-1)+(price30*closing/30)","v":42.25102955855283},523.10734186110869,2572.288457245646,154.33730743473876,368.77003442636993,{"$f":"'Main-Land Bid Price'!AI16","v":0},-175.13832210302945,null,10766.946706593042,null,-175.13832210302945,null,-175.13832210302945,null,null,null,null,null,null,null,null,null,15,422.23320418011912,523.10734186110869,74.264184422039875,-175.13832210302945,null,1011.4198811837808,283.19756673145866,16052.225748400426]
[null,null,16,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C24-1)*acres","v":471.05391841344522},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C24-1)+(price30*closing/30)","v":43.042716816390538},523.10734186110869,2203.5184228192761,132.21110536915657,390.8962364919521,{"$f":"'Main-Land Bid Price'!AI17","v":0},-175.25350054119886,null,10982.285640724904,null,-175.25350054119886,null,-175.25350054119886,null,null,null,null,null,null,null,null,null,16,430.67786826372134,523.10734186110869,82.824026943811532,-175.25350054119886,null,1059.4842483012569,296.65558952435197,16815.054407177333]
[null,null,17,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C25-1)*acres","v":480.4749967817142},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C25-1)+(price30*closing/30)","v":43.850237819385022},523.10734186110869,1812.622186327324,108.75733117963944,414.35001068146926,{"$f":"'Main-Land Bid Price'!AI18","v":0},-175.618796011266,null,11201.931353539401,null,-175.618796011266,null,-175.618796011266,null,null,null,null,null,null,null,null,null,17,439.29142562899585,523.10734186110869,91.802879779153159,-175.618796011266,null,1109.8327146631534,310.75316010568298,17614.133961734802]
[null,null,18,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C26-1)*acres","v":490.08449671734854},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C26-1)+(price30*closing/30)","v":44.673909242439393},523.10734186110869,1398.2721756458548,83.896330538751286,439.21101132235742,{"$f":"'Main-Land Bid Price'!AI19","v":0},-176.25407966165707,null,11425.969980610189,null,-176.25407966165707,null,-176.25407966165707,null,null,null,null,null,null,null,null,null,18,448.07725414157585,523.10734186110869,101.22399194212426,-176.25407966165707,null,1162.5738244919626,325.52067085774956,18451.187115369015]
[null,null,19,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C27-1)*acres","v":499.88618665169543},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C27-1)+(price30*closing/30)","v":45.514054093954847},523.10734186110869,959.06116432349734,57.543669859409839,465.56367200169888,{"$f":"'Main-Land Bid Price'!AI20","v":0},-177.18051219223409,null,11654.489380222392,null,-177.18051219223409,null,-177.18051219223409,null,null,null,null,null,null,null,null,null,19,457.03879922440728,523.10734186110869,111.11196955553271,-177.18051219223409,null,1217.8212802134667,340.98995845977072,19328.018437122711]
[null,null,20,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C28-1)*acres","v":509.88391038472935},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C28-1)+(price30*closing/30)","v":46.371001842500611},523.10734186110869,493.49749232179846,29.609849539307906,493.49749232180079,{"$f":"'Main-Land Bid Price'!AI21","v":0},-178.42062317303115,null,11887.57916782684,null,-178.42062317303115,null,-178.42062317303115,null,null,null,null,null,null,null,null,null,20,466.17957520889541,523.10734186110869,121.4928565208179,-178.42062317303115,null,1275.6941875831992,357.19437252329584,20246.518252182614]
[null,null,21,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C29-1)*acres","v":520.08158859242394},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C29-1)+(price30*closing/30)","v":47.245088546017293},0,0,0,0,{"$f":"'Main-Land Bid Price'!AI22","v":0},343.10894670007946,null,12125.330751183377,null,343.10894670007946,null,343.10894670007946,null,null,null,null,null,null,null,null,null,21,475.50316671307331,0,132.39422001299386,343.10894670007946,null,1336.317312461726,374.16884748928334,21208.666717155054]
[null,null,22,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C30-1)*acres","v":530.48322036427237},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C30-1)+(price30*closing/30)","v":48.136656983604304},0,0,0,0,{"$f":"'Main-Land Bid Price'!AI23","v":0},349.95619230074766,null,12367.837366207044,null,349.95619230074766,null,349.95619230074766,null,null,null,null,null,null,null,null,null,22,485.01323004733473,0,135.05703774658707,349.95619230074766,null,1399.8213497923196,391.94997794184951,22216.538089005524]
[null,null,23,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C31-1)*acres","v":541.09288477155792},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C31-1)+(price30*closing/30)","v":49.046056789943059},0,0,0,0,{"$f":"'Main-Land Bid Price'!AI24","v":0},356.94038281342938,null,12615.194113531186,null,356.94038281342938,null,356.94038281342938,null,null,null,null,null,null,null,null,null,23,494.71349464828154,0,137.77311183485216,356.94038281342938,null,1466.3432053609006,410.57609750105217,23272.305196865371]
[null,null,24,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C32-1)*acres","v":551.91474246698897},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C32-1)+(price30*closing/30)","v":49.973644592408576},0,0,0,0,{"$f":"'Main-Land Bid Price'!AI25","v":0},364.06425713636457,null,12867.49799580181,null,364.06425713636457,null,364.06425713636457,null,null,null,null,null,null,null,null,null,24,504.60776454124709,0,140.54350740488252,364.06425713636457,null,1536.026290945686,430.08736146479214,24378.244126346264]
[null,null,25,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C33-1)*acres","v":562.95303731632873},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C33-1)+(price30*closing/30)","v":50.919784150923412},0,0,0,0,{"$f":"'Main-Land Bid Price'!AI26","v":0},371.33060894575851,null,13124.847955717847,null,371.33060894575851,null,371.33060894575851,null,null,null,null,null,null,null,null,null,25,514.69991983207194,0,143.36931088631343,371.33060894575851,null,1609.0208334928416,450.5258333779957,25536.739126461111]
[null,null,26,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C34-1)*acres","v":574.21209806265529},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C34-1)+(price30*closing/30)","v":51.884846500608553},0,0,0,0,{"$f":"'Main-Land Bid Price'!AI27","v":0},378.74228779134035,null,13387.344914832203,null,378.74228779134035,null,378.74228779134035,null,null,null,null,null,null,null,null,null,26,524.99391822871337,0,146.25163043737302,378.74228779134035,null,1685.48419898468,471.93557571571046,26750.28774973008]
[null,null,27,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C35-1)*acres","v":585.69634002390853},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C35-1)+(price30*closing/30)","v":52.869210097287393},0,0,0,0,{"$f":"'Main-Land Bid Price'!AI28","v":0},386.30220021383394,null,13655.091813128847,null,386.30220021383394,null,386.30220021383394,null,null,null,null,null,null,null,null,null,27,535.49379659328781,0,149.19159637945387,386.30220021383394,null,1765.5812316986182,494.36274487561315,28021.506236553087]
[null,null,28,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C36-1)*acres","v":597.41026682438655},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C36-1)+(price30*closing/30)","v":53.873260965899796},0,0,0,0,{"$f":"'Main-Land Bid Price'!AI29","v":0},394.01331088477713,null,13928.193649391424,null,394.01331088477713,null,394.01331088477713,null,null,null,null,null,null,null,null,null,28,546.20367252515337,0,152.19036164037624,394.01331088477713,null,1849.4846095882883,517.8556906847208,29353.135155456654]
[null,null,29,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C37-1)*acres","v":609.35847216087438},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C37-1)+(price30*closing/30)","v":54.897392851884476},0,0,0,0,{"$f":"'Main-Land Bid Price'!AI30","v":0},401.87864376913944,null,14206.757522379252,null,401.87864376913944,null,401.87864376913944,null,null,null,null,null,null,null,null,null,29,557.12774597565658,0,155.24910220651714,401.87864376913944,null,1937.375216552955,542.46506063482741,30748.045311374783]
[null,"Terminal Value",30,{"$f":"factor*CFlow30*(1+growcf30)^('30 Year Model'!C38-1)*acres","v":621.54564160409177},{"$f":"acres*PropertyTaxAc*(1+growcf30)^('30 Year Model'!C38-1)+(price30*closing/30)","v":55.942007375588823},{"$f":"IF(C38<=amort,F30,0)","v":0},0,{"$f":"G38*interest","v":0},{"$f":"F38-H38","v":0},{"$f":"'Main-Land Bid Price'!AI31","v":0},{"$f":"(D38-E38-H38)*(1-IncomeTax)-I38-(M38*closingEH)+(price30*closing/30)+J38*IncomeTax","v":-169.73442360188469},{"$f":"(M38+J39-O5-M38*closingEH)*CapitalGainsTax","v":886.68854488706461},14490.892672826838,{"$f":"G38-I38","v":0},{"$f":"K38+M38-L38-N38","v":13434.469704337887},null,13434.469704337887,null,null,null,null,null,null,null,null,null,30,{"$f":"D38-E38+(closing*price30/30)-M38*closingEH","v":-11.365406017903865},0,158.36901758398082,-169.73442360188469,null,2029.4425323977982,568.24390907138354,32209.243934701193]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J9:J38)","v":0},null,null,null,null,{"$f":"IRR(O8:O38,0)","v":4.7521675232664817E-2},null,{"$f":"IRR(Q8:Q38,0)","v":4.7521675232664817E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"solve30*100","v":85751},"Base",{"$f":"ROUND(NPV(discount,'30 Year Model'!$O$9:$O$38)+$O$8,2)","v":857.51},null,296.05132926919782,null,null,null,null,null,null,null,null,null,null,"Final Debt Value",null,null,{"$f":"N38+0.0000001","v":9.9999999999999995E-8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Base  \"&TEXT(-range/2,\"0.0%\")","v":"Base  -1.0%"},{"$f":"ROUND(NPV(discount-range/2,'30 Year Model'!$O$9:$O$38)+$O$8,2)","v":2362.52},null,220.68531024119278,null,null,null,null,null,null,null,null,null,null,"Final Land Value",null,null,{"$f":"M38-L38","v":13604.204127939773}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Base  \"&TEXT(-range/4,\"0.0%\")","v":"Base  -0.5%"},{"$f":"ROUND(NPV(discount-range/4,'30 Year Model'!$O$9:$O$38)+$O$8,2)","v":1550.99}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Base   \"&TEXT(range/4,\"0.0%\")","v":"Base   0.5%"},{"$f":"ROUND(NPV(discount+range/4,'30 Year Model'!$O$9:$O$38)+$O$8,2)","v":265.10000000000002},null,null,null,null,null,null,null,null,null,null,null,null,"Net Present Value",null,null,{"$f":"solve30","v":857.51}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Base   \"&TEXT(range/2,\"0.0%\")","v":"Base   1.0%"},{"$f":"ROUND(NPV(discount+range/2,'30 Year Model'!$O$9:$O$38)+$O$8,2)","v":-240.71},null,367.26613303011192,null,null,null,null,null,null,null,null,null,null,"After-tax Yield",null,null,{"$f":"O39","v":4.7521675232664817E-2}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bid price  \"&TEXT(-range/2,\"0.0%\")","v":"Bid price  -1.0%"},13425.27,{"$f":"IF(O46<0,\"NA\",O46)","v":13425.27}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bid price  \"&TEXT(-range/4,\"0.0%\")","v":"Bid price  -0.5%"},11184.41,{"$f":"IF(O47<0,\"NA\",O47)","v":11184.41}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bid Price",9622.2099999999991,{"$f":"IF(O48<0,\"NA\",O48)","v":9622.2099999999991},9095.99,{"$f":"IF(Q48<0,\"NA\",Q48)","v":9095.99}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bid price   \"&TEXT(range/4,\"0.0%\")","v":"Bid price   0.5%"},8471.94,{"$f":"IF(O49<0,\"NA\",O49)","v":8471.94},9359.11,{"$f":"IF(Q49<0,\"NA\",Q49)","v":9359.11}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bid price   \"&TEXT(range/2,\"0.0%\")","v":"Bid price   1.0%"},7590.44,{"$f":"IF(O50<0,\"NA\",O50)","v":7590.44}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2719.81,null,9885.32,{"$f":"IF(Q51<0,\"NA\",Q51)","v":9885.32}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bid Price Grow 0",5437.28,{"$f":"IF(O52<0,\"NA\",O52)","v":5437.28},10148.42,{"$f":"IF(Q52<0,\"NA\",Q52)","v":10148.42}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bid Price Grow 1.0",6956.46,{"$f":"IF(O53<0,\"NA\",O53)","v":6956.46}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bid Price Grow 2.5",15515.89,{"$f":"IF(O54<0,\"NA\",O54)","v":15515.89}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bid Price Grow 5.0",-74365.33,{"$f":"IF(O55<0,\"NA\",O55)","v":"NA"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Growth rate \"&TEXT('Sensitivity Tables'!$I$54,\"0.0%\")","v":"Growth rate 3.0%"},7.6760682578727278E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Growth rate \"&TEXT('Sensitivity Tables'!$J$54,\"0.0%\")","v":"Growth rate 4.0%"},1.469763373619957E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Growth rate \"&TEXT('Sensitivity Tables'!$K$54,\"0.0%\")","v":"Growth rate 5.0%"},2.1752511787240077E-2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Cash Growth rate \"&TEXT('Sensitivity Tables'!$J$54,\"0.0%\")","v":"Cash Growth rate 4.0%"},5.0630839885362966E-3]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Land Growth rate \"&TEXT('Sensitivity Tables'!$J$54,\"0.0%\")","v":"Land Growth rate 4.0%"},1.0923428656204779E-2]