{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["License","(1)Tbl. of Cnts.","(2)Dev.-Inv. & Lender Input","(3)Development Budget Input","(4)Income & Expense Input","(5)Project Summary"," (6)Development Budget","(7)Cost Mark-up Feasibility ","(8)Rent Constant Feasibility","(9)Annual Cash Flow Projection","(10)Sale Proceeds-Ratios","Data","(11)Decision Chart","(12)Holding Period Chart"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":0,"defined_names":263,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"(11)Decision Chart","index":12,"reason":"not_a_worksheet"},{"sheet":"(12)Holding Period Chart","index":13,"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":"License","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"(1)Tbl. of Cnts.","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"(2)Dev.-Inv. & Lender Input","index":2,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,0,1,3],[2,1,2,2],[5,1,5,2],[14,1,14,2],[22,1,22,2]]}
[]
["Developer/Investor and Lender Input Sheet"]
[null,"Developer/Investor Assumptions",null,null,null,0]
[null,1,"Target Profit Mark-up on Cost",0.15]
[null,2,"Target Spread Between Market Rent Constant and Cost Rent Constant",1.4999999999999999E-2]
[null,"Construction Loan Assumptions"]
[null,3,"Maximum Loan to Value Ratio",0.6]
[null,4,"Minimum Service Debt Coverage Ratio",1]
[null,5,"Minimum Equity Requirement (% of Total Project Cost)",0.2]
[null,6,"Interest Rate",5.5E-2]
[null,7,"Amortization Period",500]
[null,8,"Payments Per Year",12]
[null,9,"Loan Costs (% of Loan Amount or $ Amount)",1]
[null,10,"Construction Loan Amount Used (LTV = 1, DSCR = 2, and Minimum Equity Requirement =3)",3]
[null,"Permanent Loan Assumptions"]
[null,11,"Maximum Loan to Value Ratio",0.65]
[null,12,"Minimum Debt Service Coverage Ratio",1.2]
[null,13,"Interest Rate",0.05]
[null,14,"Amortization Period",30]
[null,15,"Payments Per Year",12]
[null,16,"Loan Costs (% of Loan Amount or $ Amount)",0.01]
[null,17,"Permanent Loan Amount Used (LTV = 1, and DSCR = 2)",1]
[null,"Project Assumptions"]
[null,18,"Market Capitalization Rate (Used by Lender for LTV and by Buyer if Bought upon Completion of Construction)",6.5000000000000002E-2]
[null,19,"Market Cost of Sale (If sold upon Completion of Construction)",0.02]
[null,20,"Disposition Capitalization Rate used for Cash Flow Forecast",0.06]
[null,21,"Disposition Cost of Sale used for Cash Flow Forecast",0.02]

{"sheet":"(3)Development Budget Input","index":3,"n_rows":55,"n_cols":4,"rows_kept":55,"cut":false,"hidden":false,"merged":[[39,1,39,2],[52,1,52,2],[1,0,1,2],[2,1,2,2],[7,1,7,2],[10,1,10,2],[25,1,25,2]]}
[]
["Development Budget Input Sheet"]
[null,"Project Land and Building"]
[null,1,"Category \"A\" Space Square Feet (GLA)",500000]
[null,2,"Category \"B\" Space Square Feet (GLA)",0]
[null,3,"Category \"C\" Space Square Feet (GLA)",0]
[null,4,"Land Size (Acres or Total Square Feet)",{"$f":"1000000/43560","v":22.956841138659321}]
[null,"Land Cost"]
[null,5,"Land Purchase Price (Per SF or Total Cost)",2.8]
[null,6,"Closing Costs (% of Cost or $ Amount)",1]
[null,"Architectural/Engineering/Entitlements"]
[null,7,"Architectural (Includes Reimbursables & Printing Costs)",{"$f":"0.4*D4","v":200000}]
[null,8,"Civil Engineering (Includes Site Planning)",{"$f":"0.22*D4","v":110000}]
[null,9,"Surveys",20000]
[null,10,"Environmental Site Assessment (ESA)",3200]
[null,11,"Geotechnical",14000]
[null,12,"Inspecting Architect/Engineer",5000]
[null,13,"Landscape Architect",14000]
[null,14,"Traffic Study",0]
[null,15,"Transportation Impact Fees",150000]
[null,16,"Water Connection Fees",0]
[null,17,"Sewer Capacity Fees",0]
[null,18,"Permit Fees (Including building permit)",75000]
[null,19,"Zoning Compliance(Includes legal fees)",7500]
[null,20,"Misc. Planning/Design",60000]
[null,"Construction Costs"]
[null,21,"Category \"A\" Space (Per Square Foot)",29.5]
[null,22,"Category \"B\" Space (Per Square Foot)",0]
[null,23,"Category \"C\" Space (Per Square Foot)",0]
[null,24,"Tenant Improvements (Per Square Foot) ",4]
[null,25,"Site Work (Includes Earthwork, Lighting, Site Demo, & Other)",200000]
[null,26,"Demolition ",0]
[null,27,"Asbestos Abatement",0]
[null,28,"Landscaping/Irrigation",15000]
[null,29,"Signs",5000]
[null,30,"Construction Materials Testing",241000]
[null,31,"Utility Fees",150000]
[null,32,"Builder's Risk",40000]
[null,33,"Performance Bond & Payment Bond",260000]
[null,"Financing/Carry"]
[null,34,"Construction Facility Fee (% of Total Project Cost or $ Amount)",0]
[null,35,"Construction Loan Costs (% of Loan Amount or $ Amount)",0]
[null,36,"First Construction Draw Average Outstanding Balance Over Construction Period (%)",1]
[null,37,"Remainder of Construction Loan Average Outstanding Balance Over Construction Period (%)",0.5]
[null,38,"Construction Period (Months)",12]
[null,39,"Legal Fees (Includes lease negotiation)",15000]
[null,40,"Construction Period Taxes & Insurance",30000]
[null,41,"Leasing Commissions (Category \"A\" Space) (Per Square Foot or $ Amount)",3]
[null,42,"Leasing Commissions (Category \"B\" Space) (Per Square Foot or $ Amount)",0]
[null,43,"Leasing Commissions (Category \"C\" Space) (Per Square Foot or $ Amount)",0]
[null,44,"Title Policy",10000]
[null,45,"Appraisal",10000]
[null,"Other Soft Costs and Miscellaneous"]
[null,46,"Contingency ",375000]
[null,47,"Developer Overhead Fee",450000]

{"sheet":"(4)Income & Expense Input","index":4,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,0,1,4],[2,1,2,2],[3,1,3,3],[30,1,30,2],[38,1,38,2],[13,1,13,3],[21,1,21,3],[22,1,22,2]]}
[]
["Income and Expense Input Sheet"]
[null,"End of Year",null,1,2,3,4,5,6,7,8,9,10,11]
[null,"Income, Vacancies, and Escalations"]
[null,1,"Category \"A\" Space (SF)",{"$f":"'(3)Development Budget Input'!D4","v":500000}]
[null,2,"Category \"A\" Space (Rent PSF & Annual Escalation)",6.62,2.5000000000000001E-2,{"$f":"E6","v":2.5000000000000001E-2},{"$f":"F6","v":2.5000000000000001E-2},2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2]
[null,3,"Category \"A\" Space Vacancy Rate",8.5000000000000006E-2,{"$f":"D7","v":8.5000000000000006E-2},{"$f":"E7","v":8.5000000000000006E-2},8.5000000000000006E-2,8.5000000000000006E-2,8.5000000000000006E-2,8.5000000000000006E-2,8.5000000000000006E-2,8.5000000000000006E-2,8.5000000000000006E-2,8.5000000000000006E-2]
[null,4,"Category \"B\" Space (SF)",{"$f":"'(3)Development Budget Input'!D5","v":0}]
[null,5,"Category \"B\" Space (Rent PSF & Annual Escalation)",null,null,{"$f":"E9","v":0},{"$f":"F9","v":0},0,0,0,0,0,0,0]
[null,6,"Category \"B\" Space Vacancy Rate",null,{"$f":"D10","v":0},{"$f":"E10","v":0},0,0,0,0,0,0,0,0]
[null,7,"Category \"C\" Space (SF)",{"$f":"'(3)Development Budget Input'!D6","v":0}]
[null,8,"Category \"C\" Space (Rent PSF & Annual Escalation)",null,null,{"$f":"E12","v":0},{"$f":"F12","v":0},0,0,0,0,0,0,0]
[null,9,"Category \"C\" Space Vacancy Rate",null,{"$f":"D13","v":0},{"$f":"E13","v":0},0,0,0,0,0,0,0,0]
[null,"Total Operating Expenses"]
[null,10,"Real Estate Taxes (Per Square Foot)",null,null,{"$f":"E15","v":0},{"$f":"F15","v":0},0,0,0,0,0,0,0]
[null,11,"Insurance (Per Square Foot)",null,null,0,{"$f":"F16","v":0},0,0,0,0,0,0,0]
[null,12,"Building Maintenance (Per Square Foot)",null,null,0,{"$f":"F17","v":0},0,0,0,0,0,0,0]
[null,13,"Common Area Utilities (Per Square Foot)",null,null,0,{"$f":"F18","v":0},0,0,0,0,0,0,0]
[null,14,"Common Area Maintenance (Per Square Foot)",null,null,0,{"$f":"F19","v":0},0,0,0,0,0,0,0]
[null,15,"Reserve for Replacements (Per Square Foot)",null,null,0,0,0,0,0,0,0,0,0]
[null,16,"Property Management( % of Collected Income)",null,{"$f":"D21","v":0},{"$f":"E21","v":0},0,0,0,0,0,0,0,0]
[null,"Operating Expense Pass-thrus"]
[null,"Category \"A\" Space"]
[null,17,"Real Estate Taxes (Per Square Foot)",null,null,{"$f":"E24","v":0},{"$f":"F24","v":0},0,0,0,0,0,0,0]
[null,18,"Insurance (Per Square Foot)",null,null,0,{"$f":"F25","v":0},0,0,0,0,0,0,0]
[null,19,"Building Maintenance (Per Square Foot)",null,null,0,{"$f":"F26","v":0},0,0,0,0,0,0,0]
[null,20,"Common Area Utilities (Per Square Foot)",null,null,0,{"$f":"F27","v":0},0,0,0,0,0,0,0]
[null,21,"Common Area Maintenance (Per Square Foot)",null,null,0,0,0,0,0,0,0,0,0]
[null,22,"Reserve for Replacements (Per Square Foot)",null,null,0,0,0,0,0,0,0,0,0]
[null,23,"Property Management( % of Collected Income)",null,{"$f":"D30","v":0},{"$f":"E30","v":0},0,0,0,0,0,0,0,0]
[null,"Category \"B\" Space"]
[null,24,"Real Estate Taxes (Per Square Foot)",null,null,{"$f":"E32","v":0},{"$f":"F32","v":0},0,0,0,0,0,0,0]
[null,25,"Insurance (Per Square Foot)",null,null,0,0,0,0,0,0,0,0,0]
[null,26,"Building Maintenance (Per Square Foot)",null,null,0,0,0,0,0,0,0,0,0]
[null,27,"Common Area Utilities (Per Square Foot)",null,null,0,0,0,0,0,0,0,0,0]
[null,28,"Common Area Maintenance (Per Square Foot)",null,null,0,0,0,0,0,0,0,0,0]
[null,29,"Reserve for Replacements (Per Square Foot)",null,null,0,0,0,0,0,0,0,0,0]
[null,30,"Property Management( % of Collected Income)",null,{"$f":"D38","v":0},{"$f":"E38","v":0},0,0,0,0,0,0,0,0]
[null,"Category \"C\" Space"]
[null,31,"Real Estate Taxes (Per Square Foot)",null,null,{"$f":"E40","v":0},{"$f":"F40","v":0},0,0,0,0,0,0,0]
[null,32,"Insurance (Per Square Foot)",null,null,0,0,0,0,0,0,0,0,0]
[null,33,"Building Maintenance (Per Square Foot)",null,null,0,0,0,0,0,0,0,0,0]
[null,34,"Common Area Utilities (Per Square Foot)",null,null,0,0,0,0,0,0,0,0,0]
[null,35,"Common Area Maintenance (Per Square Foot)",null,null,0,0,0,0,0,0,0,0,0]
[null,36,"Reserve for Replacements (Per Square Foot)",null,null,0,0,0,0,0,0,0,0,0]
[null,37,"Property Management( % of Collected Income)",null,{"$f":"D46","v":0},{"$f":"E46","v":0},0,0,0,0,0,0,0,0]

{"sheet":"(5)Project Summary","index":5,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[2,1,2,2],[20,1,20,2],[27,1,27,2],[19,1,19,2],[5,1,5,2],[11,1,11,2]]}
[]
["Project Summary"]
[null,"Developer/Investor Assumptions"]
[null,1,"     Target Profit Mark-up on Cost",{"$f":"'(2)Dev.-Inv. & Lender Input'!D4","v":0.15}]
[null,2,"     Target Spread Between Market Capitalization Rate and Cost Capitalization Rate",{"$f":"'(2)Dev.-Inv. & Lender Input'!D5","v":1.4999999999999999E-2}]
[null,"Project Size"]
[null,3,"     Category \"A\" Space (Square Feet)",{"$f":"'(3)Development Budget Input'!D4","v":500000}]
[null,4,"     Category \"B\" Space (Square Feet)",{"$f":"'(3)Development Budget Input'!D5","v":0}]
[null,5,"     Category \"C\" Space (Square Feet)",{"$f":"'(3)Development Budget Input'!D6","v":0}]
[null,6,"     Total Building Space (Square Feet)",{"$f":"D7+D8+D9","v":500000}]
[null,7,"     Total Land Size (Square Feet)",{"$f":"' (6)Development Budget'!H8","v":1000000}]
[null,"Project Cost"]
[null,8,"     Land Cost",{"$f":"' (6)Development Budget'!G13","v":2828000}]
[null,9,"     Architectural/Engineering/Entitlements",{"$f":"' (6)Development Budget'!G29","v":658700}]
[null,10,"     Construction Costs",{"$f":"' (6)Development Budget'!G44","v":17661000}]
[null,11,"     Financing/Carry",{"$f":"' (6)Development Budget'!G56","v":2292950}]
[null,12,"     Other Soft Costs and Miscellaneous",{"$f":"' (6)Development Budget'!G60","v":825000}]
[null,13,"  Total Project Cost",{"$f":"SUM(D13:D17)","v":24265650}]
[null,14,"  Indicated Value (Rounded to Nearest $1,000)",{"$f":"IF('(2)Dev.-Inv. & Lender Input'!D24=0,0,ROUND('(9)Annual Cash Flow Projection'!D48/'(2)Dev.-Inv. & Lender Input'!D24,-3))","v":46595000}]
[null,"Financing"]
[null,"  Construction Loan"]
[null,15,"     Loan Amount Using Loan to Value",{"$f":"'(2)Dev.-Inv. & Lender Input'!D7*'(5)Project Summary'!D19","v":27957000}]
[null,16,"     Loan Amount Using Debt Service Coverage Ratio",{"$f":"IF('(2)Dev.-Inv. & Lender Input'!D12=0,0,-(PV('(2)Dev.-Inv. & Lender Input'!D10/'(2)Dev.-Inv. & Lender Input'!D12,'(2)Dev.-Inv. & Lender Input'!D11*'(2)Dev.-Inv. & Lender Input'!D12,'(9)Annual Cash Flow Projection'!D48/'(2)Dev.-Inv. & Lender Input'!D8/'(2)Dev.-Inv. & Lender Input'!D12,0,0)))","v":55066363.636296794}]
[null,17,"     Loan Amount using Minimum Equity Requirement",{"$f":"' (6)Development Budget'!G61*(1-'(2)Dev.-Inv. & Lender Input'!D9)","v":19412520}]
[null,18,"  Construction Loan Amount Used for Analysis (Rounded Down to Nearest $1,000)",{"$f":"ROUNDDOWN(IF('(2)Dev.-Inv. & Lender Input'!D14=1,'(5)Project Summary'!D22,IF('(2)Dev.-Inv. & Lender Input'!D14=2,'(5)Project Summary'!D23,'(5)Project Summary'!D24)),-3)","v":19412000}]
[null,19,"  Construction Loan Costs",{"$f":"IF('(2)Dev.-Inv. & Lender Input'!D13<10,'(2)Dev.-Inv. & Lender Input'!D13*'(5)Project Summary'!D25/100,'(2)Dev.-Inv. & Lender Input'!D13)","v":194120}]
[null,20,"  Construction Loan Annual Mortgage Constant",{"$f":"IF('(2)Dev.-Inv. & Lender Input'!D12=0,0,(PMT('(2)Dev.-Inv. & Lender Input'!D10/'(2)Dev.-Inv. & Lender Input'!D12,'(2)Dev.-Inv. & Lender Input'!D11*'(2)Dev.-Inv. & Lender Input'!D12,-1,0,0))*'(2)Dev.-Inv. & Lender Input'!D12)","v":5.5000000000066773E-2}]
[null,"  Permanent Loan"]
[null,21,"     Loan Amount Using Loan to Value",{"$f":"'(2)Dev.-Inv. & Lender Input'!D16*'(5)Project Summary'!D19","v":30286750}]
[null,22,"     Loan Amount Using Debt Service Coverage Ratio",{"$f":"IF('(2)Dev.-Inv. & Lender Input'!D20=0,0,-(PV('(2)Dev.-Inv. & Lender Input'!D18/'(2)Dev.-Inv. & Lender Input'!D20,'(2)Dev.-Inv. & Lender Input'!D19*'(2)Dev.-Inv. & Lender Input'!D20,'(9)Annual Cash Flow Projection'!D48/'(2)Dev.-Inv. & Lender Input'!D17/'(2)Dev.-Inv. & Lender Input'!D20,0,0)))","v":39179293.018513717}]
[null,23,"  Permanent Loan Amount Used for Cash Flow Projection (Rounded Down to Nearest $1,000)",{"$f":"ROUNDDOWN(IF('(2)Dev.-Inv. & Lender Input'!D22=1,'(5)Project Summary'!D29,'(5)Project Summary'!D30),-3)","v":30286000}]
[null,24,"  Permanent Loan Costs",{"$f":"IF('(2)Dev.-Inv. & Lender Input'!D21<10,'(2)Dev.-Inv. & Lender Input'!D21*'(5)Project Summary'!D31,'(2)Dev.-Inv. & Lender Input'!D21)","v":302860}]
[null,25,"  Permanent Loan Annual Mortgage Constant",{"$f":"IF('(2)Dev.-Inv. & Lender Input'!D20=0,0,(PMT('(2)Dev.-Inv. & Lender Input'!D18/'(2)Dev.-Inv. & Lender Input'!D20,'(2)Dev.-Inv. & Lender Input'!D19*'(2)Dev.-Inv. & Lender Input'!D20,-1,0,0))*'(2)Dev.-Inv. & Lender Input'!D20)","v":6.4418594761456699E-2}]

{"sheet":" (6)Development Budget","index":6,"n_rows":70,"n_cols":8,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,0,1,2],[8,1,8,4],[13,2,13,3]]}
[]
["Total Project Budget"]
[null,null,"Project Land and Building"]
[null,1,"Category \"A\" Space Square Feet",null,null,null,null,{"$f":"'(3)Development Budget Input'!D4","v":500000}]
[null,2,"Category \"B\" Space Square Feet",null,null,null,null,{"$f":"'(3)Development Budget Input'!D5","v":0}]
[null,3,"Category \"C\" Space Square Feet",null,null,null,null,{"$f":"'(3)Development Budget Input'!D6","v":0}]
[null,4,"Total Building Square Feet",null,null,null,null,{"$f":"SUM(H4:H6)","v":500000}]
[null,5,"Land Size Square Feet",null,null,{"$f":"'(3)Development Budget Input'!D7","v":22.956841138659321},"Acres or SF",{"$f":"IF(F8>100,F8,43560*F8)","v":1000000}]
[null,"Total Component Cost and Component Cost PSF (GLA)"]
[null,null,"Land Costs",null,null,null,"$","$/sf"]
[null,6,"Land Purchase Price (Per Square Foot or Total $ Amount).",{"$f":"'(3)Development Budget Input'!D9","v":2.8},"Per SF or Total $ Amount",null,{"$f":"IF(D11<100,H8*D11,D11)","v":2800000},{"$f":"IF($H$7=0,0,G11/$H$7)","v":5.6}]
[null,7,"Closing Costs",null,null,null,{"$f":"IF('(3)Development Budget Input'!D10<20,'(3)Development Budget Input'!D10*' (6)Development Budget'!G11/100,'(3)Development Budget Input'!D10)","v":28000},{"$f":"IF($H$7=0,0,G12/$H$7)","v":5.6000000000000001E-2}]
[null,8,"Subtotal Land Cost ",null,null,null,{"$f":"SUM(G11:G12)","v":2828000},{"$f":"SUM(H11:H12)","v":5.6559999999999997}]
[null,null,"Architectural/Engineering/Entitlements"]
[null,9,"Architectural (Includes Reimbursables & Printing Costs)",null,null,null,{"$f":"'(3)Development Budget Input'!D12","v":200000},{"$f":"IF($H$7=0,0,G15/$H$7)","v":0.4}]
[null,10,"Civil Engineering (Includes Site Planning)",null,null,null,{"$f":"'(3)Development Budget Input'!D13","v":110000},{"$f":"IF($H$7=0,0,G16/$H$7)","v":0.22}]
[null,11,"Surveys",null,null,null,{"$f":"'(3)Development Budget Input'!D14","v":20000},0.04]
[null,12,"Environmental Site Assessment (ESA)",null,null,null,{"$f":"'(3)Development Budget Input'!D15","v":3200},6.4000000000000003E-3]
[null,13,"Geotechnical",null,null,null,{"$f":"'(3)Development Budget Input'!D16","v":14000},2.8000000000000001E-2]
[null,14,"Inspecting Architect/Engineer",null,null,null,{"$f":"'(3)Development Budget Input'!D17","v":5000},0.01]
[null,15,"Landscape Architect",null,null,null,{"$f":"'(3)Development Budget Input'!D18","v":14000},2.8000000000000001E-2]
[null,16,"Traffic Study",null,null,null,{"$f":"'(3)Development Budget Input'!D19","v":0},0]
[null,17,"Transportation Impact Fees",null,null,null,{"$f":"'(3)Development Budget Input'!D20","v":150000},0.3]
[null,18,"Water Connection Fees",null,null,null,{"$f":"'(3)Development Budget Input'!D21","v":0},0]
[null,19,"Sewer Capacity Fees",null,null,null,{"$f":"'(3)Development Budget Input'!D22","v":0},0]
[null,20,"Permit Fees (Including building permit)",null,null,null,{"$f":"'(3)Development Budget Input'!D23","v":75000},0.15]
[null,21,"Zoning Compliance(Includes legal fees)",null,null,null,{"$f":"'(3)Development Budget Input'!D24","v":7500},1.4999999999999999E-2]
[null,22,"Misc. Planning/Design",null,null,null,{"$f":"'(3)Development Budget Input'!D25","v":60000},0.12]
[null,23,"Subtotal Architectural/Engineering/Entitlements",null,null,null,{"$f":"SUM(G15:G28)","v":658700},{"$f":"SUM(H15:H28)","v":1.3173999999999997}]
[null,null,"Construction Costs"]
[null,24,"Category \"A\" Space",null,{"$f":"'(3)Development Budget Input'!D27","v":29.5},"/SF",{"$f":"E31*H4","v":14750000},{"$f":"IF($H$7=0,0,G31/$H$7)","v":29.5}]
[null,25,"Category \"B\" Space",null,{"$f":"'(3)Development Budget Input'!D28","v":0},"/SF",{"$f":"E32*H5","v":0},{"$f":"IF($H$7=0,0,G32/$H$7)","v":0}]
[null,26,"Category \"C\" Space",null,{"$f":"'(3)Development Budget Input'!D29","v":0},"/SF",{"$f":"E33*H6","v":0},0]
[null,27,"Tenant Improvements ",null,{"$f":"'(3)Development Budget Input'!D30","v":4},"/SF",{"$f":"E34*H7","v":2000000},4]
[null,28,"Site Work (Includes Earthwork, Lighting, Site Demo, and Other)",null,null,null,{"$f":"'(3)Development Budget Input'!D31","v":200000},0.4]
[null,29,"Demolition (Building only)",null,null,null,{"$f":"'(3)Development Budget Input'!D32","v":0},0]
[null,30,"Asbestos Abatement",null,null,null,{"$f":"'(3)Development Budget Input'!D33","v":0},0]
[null,31,"Landscaping/Irrigation",null,null,null,{"$f":"'(3)Development Budget Input'!D34","v":15000},0.03]
[null,32,"Signs",null,null,null,{"$f":"'(3)Development Budget Input'!D35","v":5000},0.01]
[null,33,"Construction Materials Testing",null,null,null,{"$f":"'(3)Development Budget Input'!D36","v":241000},0.48199999999999998]
[null,34,"Utility Fees",null,null,null,{"$f":"'(3)Development Budget Input'!D37","v":150000},0.3]
[null,35,"Builder's Risk",null,null,null,{"$f":"'(3)Development Budget Input'!D38","v":40000},0.08]
[null,36,"Performance Bond & Payment Bond",null,null,null,{"$f":"'(3)Development Budget Input'!D39","v":260000},0.52]
[null,37,"Subtotal Construction Costs",null,null,null,{"$f":"SUM(G31:G43)","v":17661000},{"$f":"SUM(H31:H43)","v":35.321999999999996}]
[null,null,"Financing/Carry"]
[null,38,"Construction Facility Fee",null,null,null,{"$f":"IF('(3)Development Budget Input'!D41<10,'(3)Development Budget Input'!D41*' (6)Development Budget'!G61/100,'(3)Development Budget Input'!D41)","v":0},{"$f":"IF($H$7=0,0,G46/$H$7)","v":0}]
[null,39,"Construction Loan Costs",null,null,null,{"$f":"'(5)Project Summary'!D26","v":194120},{"$f":"IF($H$7=0,0,G47/$H$7)","v":0.38823999999999997}]
[null,40,"Construction Period Interest",null,null,null,{"$f":"F69","v":533830},{"$f":"IF($H$7=0,0,G48/$H$7)","v":1.0676600000000001}]
[null,41,"Legal Fees (Includes lease negotiation)",null,null,null,{"$f":"'(3)Development Budget Input'!D46","v":15000},0.03]
[null,42,"Construction Period Taxes & Insurance",null,null,null,{"$f":"'(3)Development Budget Input'!D47","v":30000},0.06]
[null,43,"Leasing Commissions Per Square Foot (Category \"A\" Space)",null,{"$f":"IF('(3)Development Budget Input'!D48<10,'(3)Development Budget Input'!D48,0)","v":3},"/SF",{"$f":"IF('(3)Development Budget Input'!D48>10,'(3)Development Budget Input'!D48,'(3)Development Budget Input'!D48*' (6)Development Budget'!H4)","v":1500000},3]
[null,44,"Leasing Commissions Per Square Foot (Category \"B\" Space)",null,{"$f":"IF('(3)Development Budget Input'!D49<10,'(3)Development Budget Input'!D49,0)","v":0},"/SF",{"$f":"IF('(3)Development Budget Input'!D49>10,'(3)Development Budget Input'!D49,'(3)Development Budget Input'!D49*' (6)Development Budget'!H5)","v":0},0]
[null,45,"Leasing Commissions Per Square Foot (Category \"C\" Space)",null,{"$f":"IF('(3)Development Budget Input'!D50<10,'(3)Development Budget Input'!D50,0)","v":0},"/SF",{"$f":"IF('(3)Development Budget Input'!D50>10,'(3)Development Budget Input'!D50,'(3)Development Budget Input'!D50*' (6)Development Budget'!H6)","v":0},0]
[null,46,"Title Policy",null,null,null,{"$f":"'(3)Development Budget Input'!D51","v":10000},0.02]
[null,47,"Appraisal",null,null,null,{"$f":"'(3)Development Budget Input'!D52","v":10000},0.02]
[null,48,"Subtotal Financing/Carry",null,null,null,{"$f":"SUM(G46:G55)","v":2292950},{"$f":"SUM(H46:H55)","v":4.5858999999999988}]
[null,null,"Other Soft Costs & Miscellaneous"]
[null,49,"Contingency ",null,null,null,{"$f":"'(3)Development Budget Input'!D54","v":375000},{"$f":"IF($H$7=0,0,G58/$H$7)","v":0.75}]
[null,50,"Developer Overhead Fee",null,null,null,{"$f":"'(3)Development Budget Input'!D55","v":450000},{"$f":"IF($H$7=0,0,G59/$H$7)","v":0.9}]
[null,51,"Subtotal Other Soft Costs & Miscellaneous",null,null,null,{"$f":"SUM(G58:G59)","v":825000},{"$f":"SUM(H58:H59)","v":1.65}]
[null,52,"TOTAL PROJECT COSTS:",null,null,null,{"$f":"G13+G29+G44+G56+G60","v":24265650},{"$f":"H60+H56+H44+H29+H13","v":48.531299999999995}]
[null,53,"LESS:  CONSTRUCTION LOAN",null,null,null,{"$f":"'(5)Project Summary'!D25","v":19412000},{"$f":"IF($H$7=0,0,G62/$H$7)","v":38.823999999999998}]
[null,54,"EQUITY REQUIRED",null,null,null,{"$f":"G61-G62","v":4853650},{"$f":"IF($H$7=0,0,G63/$H$7)","v":9.7073}]
[null,null,"Interest Calculations"]
[null,null,null,null,"Average Balance","Interest"]
[null,55,"Equity Required",{"$f":"G63","v":4853650}]
[null,56,"Construction Loan Draw Applied to Land Costs and A/E/E",{"$f":"IF(((G13+G29)-D66)<0,0,((G13+G29)-D66))","v":0},{"$f":"'(3)Development Budget Input'!D43","v":1},{"$f":"D67*E67*D69/12*D70","v":0}]
[null,57,"Balance of Construction Loan",{"$f":"G62-D67","v":19412000},{"$f":"'(3)Development Budget Input'!D44","v":0.5},{"$f":"D68*E68*D69/12*D70","v":533830}]
[null,58,"Construction Loan Interest Rate",{"$f":"'(2)Dev.-Inv. & Lender Input'!D10","v":5.5E-2},null,{"$f":"F67+F68","v":533830}]
[null,59,"Construction Period (Months)",{"$f":"'(3)Development Budget Input'!D45","v":12}]

{"sheet":"(7)Cost Mark-up Feasibility ","index":7,"n_rows":124,"n_cols":12,"rows_kept":124,"cut":false,"hidden":false,"merged":[[1,0,1,7],[2,1,2,4],[2,6,2,9],[18,1,18,4],[18,6,18,9],[21,2,21,3],[22,2,22,3],[19,7,19,8],[20,7,20,8],[21,7,21,8],[19,2,19,3],[20,2,20,3]]}
[]
["Cost Mark-up Feasibility"]
[null,"\"Front Door Approach\"",null,null,null,null,"\"Back Door Approach\""]
[null,1,null,"Total Project Cost",{"$f":"H86","v":0},null,1,null,"Potential Rental Income",{"$f":"L80","v":0}]
[null,2,"x","Target Mark-up",{"$f":"H87","v":0},null,2,"-","Vacancy and Credit Losses",{"$f":"L81","v":0}]
[null,3,"=","Required Profit",{"$f":"H88","v":0},null,3,"=","Effective Rental Income",0]
[null,4,"+","Total Project Cost",{"$f":"H86","v":0},null,4,"+","Collected Pass-thrus",0]
[null,5,"=","Required Net Value",{"$f":"H90","v":0},null,5,"=","Gross Operating Income",0]
[null,6,"+","Cost of Sale",0,null,6,"-","Operating Expenses",0]
[null,7,"=","Required Total Value",0,null,7,"=","Net Operating Income",0]
[null,8,"x","Market Capitalization Rate",0,null,8,"÷","Market Capitalization Rate",0]
[null,9,"=","Required NOI",0,null,9,"=","Total Value",0]
[null,10,"+","Operating Expenses",0,null,10,"-","Cost of Sale",0]
[null,11,"=","Gross Operating Income",0,null,11,"=","Net Value",0]
[null,12,"-","Collected Pass-Thrus",0,null,12,"-","Profit",0]
[null,13,"=","Effective Rental Income",0,null,13,"=","Justified Total Cost",0]
[null,14,"+","Vacancy and Credit Losses",0,null,14,"-","All Costs Except Land",0]
[null,15,"=","Potential Rental Income",0,null,15,"=","Justified Land Cost (Including Acquisition Costs)",{"$f":"$L$94","v":0}]
[null,"Minimum Rents Per Square Foot Needed to Achieve Target",null,null,null,null,"Justified Land Cost Breakdown"]
[null,16,"Weighted Average Rent Per Square Foot",null,{"$f":"H101","v":0},null,16,"Per Acre (Including Acquisition Costs)",null,{"$f":"$L$95","v":0}]
[null,17,"Category \"A\" Space Rent Per Square Foot",null,{"$f":"H102","v":0},null,17,"Per Square Foot (Including Acquisition Costs)",null,{"$f":"$L$96","v":0}]
[null,18,"Category \"B\" Space Rent Per Square Foot",null,{"$f":"H103","v":0},null,18,"Total Cost (Including Acquisition Costs)",null,{"$f":"$L$94","v":0}]
[null,19,"Category \"C\" Space Rent Per Square Foot",null,{"$f":"H104","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(('(4)Income & Expense Input'!D5+'(4)Income & Expense Input'!D8+'(4)Income & Expense Input'!D11)=0,0,(('(4)Income & Expense Input'!D5*'(4)Income & Expense Input'!D6)+('(4)Income & Expense Input'!D8*'(4)Income & Expense Input'!D9)+('(4)Income & Expense Input'!D11*'(4)Income & Expense Input'!D12))/('(4)Income & Expense Input'!D5+'(4)Income & Expense Input'!D8+'(4)Income & Expense Input'!D11))","v":6.62},null,null,null,null,null,null,{"$f":"'(9)Annual Cash Flow Projection'!D8","v":3310000},null,0]
[null,null,{"$f":"IF('(9)Annual Cash Flow Projection'!D8=0,0,('(9)Annual Cash Flow Projection'!D8-'(9)Annual Cash Flow Projection'!D12)/'(9)Annual Cash Flow Projection'!D8)","v":8.5000000000000006E-2},null,{"$f":"IF(C86=0,0,(C86-C94)/C86)","v":0.38887793763436723},null,null,null,null,{"$f":"SUM('(9)Annual Cash Flow Projection'!D9:D11)","v":281350},null,0]
[null,null,{"$f":"IF(('(4)Income & Expense Input'!D5+'(4)Income & Expense Input'!D8+'(4)Income & Expense Input'!D11)=0,0,(('(4)Income & Expense Input'!D5*'(4)Income & Expense Input'!D7+'(4)Income & Expense Input'!D8*'(4)Income & Expense Input'!D10+'(4)Income & Expense Input'!D11*'(4)Income & Expense Input'!D13))/('(4)Income & Expense Input'!D5+'(4)Income & Expense Input'!D8+'(4)Income & Expense Input'!D11))","v":8.5000000000000006E-2},null,null,null,null,null,null,{"$f":"J80-J81","v":3028650},null,0]
[null,{"$f":"C121","v":500000},{"$f":"'(4)Income & Expense Input'!D6","v":6.62},{"$f":"B83*C83","v":3310000},null,null,null,null,null,{"$f":"SUM('(9)Annual Cash Flow Projection'!D16:D22)+SUM('(9)Annual Cash Flow Projection'!D24:D30)+SUM('(9)Annual Cash Flow Projection'!D32:D38)","v":0},null,0]
[null,{"$f":"C122","v":0},{"$f":"'(4)Income & Expense Input'!D9","v":0},{"$f":"B84*C84","v":0},null,null,null,null,null,{"$f":"J82+J83","v":3028650},null,0]
[null,{"$f":"C123","v":0},{"$f":"'(4)Income & Expense Input'!D12","v":0},{"$f":"B85*C85","v":0},null,null,null,null,null,{"$f":"SUM('(9)Annual Cash Flow Projection'!D41:D47)","v":0},null,0]
[null,null,{"$f":"IF(C124=0,0,D86/C124)","v":6.62},{"$f":"D83+D84+D85","v":3310000},null,{"$f":"' (6)Development Budget'!G61","v":24265650},null,0,null,{"$f":"J84-J85","v":3028650},null,0]
[null,null,null,null,null,{"$f":"'(2)Dev.-Inv. & Lender Input'!D4","v":0.15},null,0,null,{"$f":"'(2)Dev.-Inv. & Lender Input'!D24","v":6.5000000000000002E-2},null,0]
[null,{"$f":"C121","v":500000},{"$f":"C83*(1-E81)","v":4.0456280528604891},{"$f":"B88*C88","v":2022814.0264302446},null,{"$f":"F86*F87","v":3639847.5},null,0,null,{"$f":"IF(J87=0,0,J86/J87)","v":46594615.384615384},null,0]
[null,{"$f":"C122","v":0},{"$f":"C84*(1-E81)","v":0},{"$f":"B89*C89","v":0},null,{"$f":"F86","v":24265650},null,0,null,{"$f":"J88*'(2)Dev.-Inv. & Lender Input'!D25","v":931892.30769230775},null,0]
[null,{"$f":"C123","v":0},{"$f":"C85*(1-E81)","v":0},{"$f":"B90*C90","v":0},null,{"$f":"F88+F89","v":27905497.5},null,0,null,{"$f":"J88-J89","v":45662723.07692308},null,0]
[null,{"$f":"B88+B89+B90","v":500000},{"$f":"D91/B91","v":4.0456280528604891},{"$f":"D88+D89+D90","v":2022814.0264302446},null,{"$f":"F90/(1-'(2)Dev.-Inv. & Lender Input'!D25)-F90","v":569499.94897959381},null,0,null,{"$f":"-(J90/(1+'(2)Dev.-Inv. & Lender Input'!D4)-'(7)Cost Mark-up Feasibility '!J90)","v":5956007.3578595296},null,0]
[null,null,null,null,null,{"$f":"F90+F91","v":28474997.448979594},null,0,null,{"$f":"J90-J91","v":39706715.71906355},null,0]
[null,null,null,null,null,{"$f":"'(2)Dev.-Inv. & Lender Input'!D24","v":6.5000000000000002E-2},null,0,null,{"$f":"' (6)Development Budget'!G61-' (6)Development Budget'!G13","v":21437650},null,0]
[null,null,4.0456280528604891,null,null,{"$f":"F92*F93","v":1850874.8341836736},null,0,null,{"$f":"J92-J93","v":18269065.71906355},null,0]
[null,null,{"$f":"B91*C94","v":2022814.0264302446},null,{"$f":"C102","v":0},{"$f":"C103","v":0},{"$f":"F95+F96","v":0},0,null,{"$f":"IF('(3)Development Budget Input'!D7=0,0,IF('(3)Development Budget Input'!D7<100,'(7)Cost Mark-up Feasibility '!J94/'(3)Development Budget Input'!D7,'(7)Cost Mark-up Feasibility '!J94/('(3)Development Budget Input'!D7/43560)))","v":795800.50272240827},null,0]
[null,null,{"$f":"C95*C81","v":171939.1922465708},null,{"$f":"C101","v":0},{"$f":"E95+E96","v":0},null,0,null,{"$f":"J95/43560","v":18.269065719063551},null,0]
[null,null,{"$f":"C95-C96","v":1850874.8341836738},null,null,{"$f":"F94+F95+F96","v":1850874.8341836736},null,0,null,{"$f":"' (6)Development Budget'!G61","v":24265650},null,0]
[null,null,{"$f":"('(4)Income & Expense Input'!D5*(1-'(4)Income & Expense Input'!D7))*SUM('(4)Income & Expense Input'!D24:D29)+('(4)Income & Expense Input'!D8*(1-'(4)Income & Expense Input'!D10))*SUM('(4)Income & Expense Input'!D32:D37)+('(4)Income & Expense Input'!D11*(1-'(4)Income & Expense Input'!D13))*SUM('(4)Income & Expense Input'!D40:D45)","v":0},null,null,{"$f":"C99","v":0},null,0,null,{"$f":"J92-J97","v":15441065.71906355},null,0]
[null,null,{"$f":"D119","v":0},null,null,{"$f":"C98","v":0},{"$f":"F98+F99","v":0},0]
[null,null,{"$f":"C97+C98+C99","v":1850874.8341836738},null,null,{"$f":"F97-F98-F99","v":1850874.8341836736},null,0]
[null,null,{"$f":"('(4)Income & Expense Input'!D5+'(4)Income & Expense Input'!D8+'(4)Income & Expense Input'!D11)*SUM('(4)Income & Expense Input'!D15:D19)","v":0},null,null,{"$f":"(F100/(1-C81))-F100","v":171939.19224657072},null,0]
[null,null,{"$f":"('(4)Income & Expense Input'!D5+'(4)Income & Expense Input'!D8+'(4)Income & Expense Input'!D11)*'(4)Income & Expense Input'!D20","v":0},null,null,{"$f":"F100+F101","v":2022814.0264302443},null,0]
[null,null,{"$f":"C100*'(4)Income & Expense Input'!D21","v":0},null,null,{"$f":"IF(C124=0,0,F102/C124)","v":4.0456280528604882},null,0]
[null,null,{"$f":"C100-C101-C102-C103","v":1850874.8341836738},null,null,{"$f":"C83*(1-E81)","v":4.0456280528604891},null,0]
[null,null,null,null,null,{"$f":"C84*(1-E81)","v":0}]
[null,null,{"$f":"('(4)Income & Expense Input'!D5*(1-'(4)Income & Expense Input'!D7))*SUM('(4)Income & Expense Input'!D24:D29)","v":0},null,null,{"$f":"C85*(1-E81)","v":0}]
[null,null,{"$f":"('(4)Income & Expense Input'!D8*(1-'(4)Income & Expense Input'!D10))*SUM('(4)Income & Expense Input'!D32:D37)","v":0}]
[null,null,{"$f":"('(4)Income & Expense Input'!D11*(1-'(4)Income & Expense Input'!D13))*SUM('(4)Income & Expense Input'!D40:D45)","v":0}]
[null,null,{"$f":"C106+C107+C108","v":0}]
[]
[null,null,{"$f":"C121*C88","v":2022814.0264302446},{"$f":"C111*(1-'(4)Income & Expense Input'!D7)","v":1850874.8341836738}]
[null,null,{"$f":"C122*C89","v":0},{"$f":"C112*(1-'(4)Income & Expense Input'!D10)","v":0}]
[null,null,{"$f":"C123*C90","v":0},{"$f":"C113*(1-'(4)Income & Expense Input'!D13)","v":0}]
[null,null,{"$f":"C111+C112+C113","v":2022814.0264302446},{"$f":"D111+D112+D113","v":1850874.8341836738}]
[]
[null,null,null,{"$f":"((C106+D111)/(1-'(4)Income & Expense Input'!D30))-(C106+D111)","v":0}]
[null,null,null,{"$f":"((C107+D112)/(1-'(4)Income & Expense Input'!D38))-(C107+D112)","v":0}]
[null,null,null,{"$f":"((C108+D113)/(1-'(4)Income & Expense Input'!D46))-(C108+D113)","v":0}]
[null,null,null,{"$f":"D116+D117+D118","v":0}]
[]
[null,null,{"$f":"'(4)Income & Expense Input'!D5","v":500000}]
[null,null,{"$f":"'(4)Income & Expense Input'!D8","v":0}]
[null,null,{"$f":"'(4)Income & Expense Input'!D11","v":0}]
[null,null,{"$f":"C121+C122+C123","v":500000}]

{"sheet":"(8)Rent Constant Feasibility","index":8,"n_rows":124,"n_cols":12,"rows_kept":124,"cut":false,"hidden":false,"merged":[[18,2,18,3],[19,2,19,3],[16,7,16,8],[17,7,17,8],[18,7,18,8],[16,2,16,3],[17,2,17,3],[1,0,1,7],[2,1,2,4],[2,6,2,9],[15,1,15,4],[15,6,15,9]]}
[]
["Rent Constant Feasibility"]
[null,"\"Front Door Approach\"",null,null,null,null,"\"Back Door Approach\""]
[null,1,null,"Market Rent Constant",{"$f":"H89","v":0},null,1,null,"Potential Rental Income",{"$f":"L80","v":0}]
[null,2,"+","Cost of Sale Adjustment",{"$f":"H90","v":0},null,2,"-","Vacancy and Credit Losses",{"$f":"L81","v":0}]
[null,3,"+","Rent Constant Spread",0,null,3,"=","Effective Rental Income",0]
[null,4,"=","Cost Rent Constant",0,null,4,"+","Collected Pass-thrus",0]
[null,5,"x","Total Project Cost",0,null,5,"=","Gross Operating Income",0]
[null,6,"=","Required NOI",0,null,6,"-","Operating Expenses",0]
[null,7,"+","Operating Expenses",0,null,7,"=","Net Operating Income",0]
[null,8,"=","Gross Operating Income",0,null,8,"÷","Cost Rent Constant",0]
[null,9,"-","Collected Pass-Thrus",0,null,9,"=","Justified Total Cost",0]
[null,10,"=","Effective Rental Income",0,null,10,"-","All Costs Except Land",0]
[null,11,"+","Vacancy and Credit Losses",0,null,11,"=","Justified Land Cost (including Acquisition Costs)",{"$f":"$L$90","v":0}]
[null,12,"=","Potential Rental Income",0]
[null,"Minimum Rents Per Square Foot Needed to Achieve Target",null,null,null,null,"Justified Land Cost Breakdown"]
[null,13,"Weighted Average Rent Per Square Foot",null,{"$f":"H101","v":0},null,12,"Per Acre (Including Acquisition Costs)",null,{"$f":"$L$91","v":0}]
[null,14,"Category \"A\" Space Rent Per Square Foot",null,{"$f":"H102","v":0},null,13,"Per Square Foot (Including Acquisition Costs)",null,{"$f":"$L$92","v":0}]
[null,15,"Category \"B\" Space Rent Per Square Foot",null,{"$f":"H103","v":0},null,14,"Total Cost (Including Acquisition Costs)",null,{"$f":"$L$90","v":0}]
[null,16,"Category \"C\" Space Rent Per Square Foot",null,{"$f":"H104","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(('(4)Income & Expense Input'!D5+'(4)Income & Expense Input'!D8+'(4)Income & Expense Input'!D11)=0,0,(('(4)Income & Expense Input'!D5*'(4)Income & Expense Input'!D6)+('(4)Income & Expense Input'!D8*'(4)Income & Expense Input'!D9)+('(4)Income & Expense Input'!D11*'(4)Income & Expense Input'!D12))/('(4)Income & Expense Input'!D5+'(4)Income & Expense Input'!D8+'(4)Income & Expense Input'!D11))","v":6.62},null,null,null,null,null,null,{"$f":"'(9)Annual Cash Flow Projection'!D8","v":3310000},null,0]
[null,null,{"$f":"IF('(9)Annual Cash Flow Projection'!D8=0,0,('(9)Annual Cash Flow Projection'!D8-'(9)Annual Cash Flow Projection'!D12)/'(9)Annual Cash Flow Projection'!D8)","v":8.5000000000000006E-2},null,{"$f":"IF(C86=0,0,(C86-C94)/C86)","v":0.34840898500948597},null,null,null,null,{"$f":"SUM('(9)Annual Cash Flow Projection'!D9:D11)","v":281350},null,0]
[null,null,{"$f":"IF(('(4)Income & Expense Input'!D5+'(4)Income & Expense Input'!D8+'(4)Income & Expense Input'!D11)=0,0,(('(4)Income & Expense Input'!D5*'(4)Income & Expense Input'!D7+'(4)Income & Expense Input'!D8*'(4)Income & Expense Input'!D10+'(4)Income & Expense Input'!D11*'(4)Income & Expense Input'!D13))/('(4)Income & Expense Input'!D5+'(4)Income & Expense Input'!D8+'(4)Income & Expense Input'!D11))","v":8.5000000000000006E-2},null,null,null,null,null,null,{"$f":"J80-J81","v":3028650},null,0]
[null,{"$f":"C121","v":500000},{"$f":"'(4)Income & Expense Input'!D6","v":6.62},{"$f":"B83*C83","v":3310000},null,null,null,null,null,{"$f":"SUM('(9)Annual Cash Flow Projection'!D16:D22)+SUM('(9)Annual Cash Flow Projection'!D24:D30)+SUM('(9)Annual Cash Flow Projection'!D32:D38)","v":0},null,0]
[null,{"$f":"C122","v":0},{"$f":"'(4)Income & Expense Input'!D9","v":0},{"$f":"B84*C84","v":0},null,null,null,null,null,{"$f":"J82+J83","v":3028650},null,0]
[null,{"$f":"C123","v":0},{"$f":"'(4)Income & Expense Input'!D12","v":0},{"$f":"B85*C85","v":0},null,null,null,null,null,{"$f":"SUM('(9)Annual Cash Flow Projection'!D41:D47)","v":0},null,0]
[null,null,{"$f":"IF(C124=0,0,D86/C124)","v":6.62},{"$f":"D83+D84+D85","v":3310000},null,null,null,null,null,{"$f":"J84-J85","v":3028650},null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"'(2)Dev.-Inv. & Lender Input'!D5+'(2)Dev.-Inv. & Lender Input'!D24/(1-'(2)Dev.-Inv. & Lender Input'!D25)-'(2)Dev.-Inv. & Lender Input'!D24+'(2)Dev.-Inv. & Lender Input'!D24","v":8.1326530612244902E-2},null,0]
[null,{"$f":"C121","v":500000},{"$f":"C83*(1-E81)","v":4.3135325192372029},{"$f":"B88*C88","v":2156766.2596186013},null,null,null,null,null,{"$f":"IF(J87=0,0,J86/J87)","v":37240614.805520698},null,0]
[null,{"$f":"C122","v":0},{"$f":"C84*(1-E81)","v":0},{"$f":"B89*C89","v":0},null,{"$f":"'(2)Dev.-Inv. & Lender Input'!D24","v":6.5000000000000002E-2},null,0,null,{"$f":"' (6)Development Budget'!G61-' (6)Development Budget'!G13","v":21437650},null,0]
[null,{"$f":"C123","v":0},{"$f":"C85*(1-E81)","v":0},{"$f":"B90*C90","v":0},null,{"$f":"F89/(1-'(2)Dev.-Inv. & Lender Input'!D25)-'(8)Rent Constant Feasibility'!F89","v":1.3265306122449E-3},null,0,null,{"$f":"J88-J89","v":15802964.805520698},null,0]
[null,{"$f":"B88+B89+B90","v":500000},{"$f":"IF(B91=0,0,D91/B91)","v":4.3135325192372029},{"$f":"D88+D89+D90","v":2156766.2596186013},null,{"$f":"'(2)Dev.-Inv. & Lender Input'!D5","v":1.4999999999999999E-2},null,0,null,{"$f":"IF(J90=0,0,IF('(3)Development Budget Input'!D7<100,J90/'(3)Development Budget Input'!D7,J90/('(3)Development Budget Input'!D7/43560)))","v":688377.14692848164},null,0]
[null,null,null,null,null,{"$f":"F89+F90+F91","v":8.1326530612244902E-2},null,0,null,{"$f":"J91/43560","v":15.802964805520698},null,0]
[null,null,null,null,null,{"$f":"' (6)Development Budget'!G61","v":24265650},null,0,null,{"$f":"' (6)Development Budget'!G61","v":24265650},null,0]
[null,null,4.3135325192372029,null,null,{"$f":"F92*F93","v":1973441.1275510206},null,0,null,{"$f":"J88-J93","v":12974964.805520698},null,0]
[null,null,{"$f":"B91*C94","v":2156766.2596186013},null,{"$f":"C102","v":0},{"$f":"C103","v":0},{"$f":"F95+F96","v":0},0]
[null,null,{"$f":"C95*C81","v":183325.13206758111},null,{"$f":"C101","v":0},{"$f":"E95+E96","v":0},null,0]
[null,null,{"$f":"C95-C96","v":1973441.1275510201},null,null,{"$f":"F94+F95+F96","v":1973441.1275510206},null,0]
[null,null,{"$f":"('(4)Income & Expense Input'!D5*(1-'(4)Income & Expense Input'!D7))*SUM('(4)Income & Expense Input'!D24:D29)+('(4)Income & Expense Input'!D8*(1-'(4)Income & Expense Input'!D10))*SUM('(4)Income & Expense Input'!D32:D37)+('(4)Income & Expense Input'!D11*(1-'(4)Income & Expense Input'!D13))*SUM('(4)Income & Expense Input'!D40:D45)","v":0},null,null,{"$f":"C99","v":0},null,0]
[null,null,{"$f":"D119","v":0},null,null,{"$f":"C98","v":0},{"$f":"F98+F99","v":0},0]
[null,null,{"$f":"C97+C98+C99","v":1973441.1275510201},null,null,{"$f":"F97-F98-F99","v":1973441.1275510206},null,0]
[null,null,{"$f":"('(4)Income & Expense Input'!D5+'(4)Income & Expense Input'!D8+'(4)Income & Expense Input'!D11)*SUM('(4)Income & Expense Input'!D15:D19)","v":0},null,null,{"$f":"(F100/(1-C81))-F100","v":183325.13206758117},null,0]
[null,null,{"$f":"('(4)Income & Expense Input'!D5+'(4)Income & Expense Input'!D8+'(4)Income & Expense Input'!D11)*'(4)Income & Expense Input'!D20","v":0},null,null,{"$f":"F100+F101","v":2156766.2596186018},null,0]
[null,null,{"$f":"C100*'(4)Income & Expense Input'!D21","v":0},null,null,{"$f":"IF(C124=0,0,F102/C124)","v":4.3135325192372038},null,0]
[null,null,{"$f":"C100-C101-C102-C103","v":1973441.1275510201},null,null,{"$f":"C83*(1-E81)","v":4.3135325192372029},null,0]
[null,null,null,null,null,{"$f":"C84*(1-E81)","v":0}]
[null,null,{"$f":"('(4)Income & Expense Input'!D5*(1-'(4)Income & Expense Input'!D7))*SUM('(4)Income & Expense Input'!D24:D29)","v":0},null,null,{"$f":"C85*(1-E81)","v":0}]
[null,null,{"$f":"('(4)Income & Expense Input'!D8*(1-'(4)Income & Expense Input'!D10))*SUM('(4)Income & Expense Input'!D32:D37)","v":0}]
[null,null,{"$f":"('(4)Income & Expense Input'!D11*(1-'(4)Income & Expense Input'!D13))*SUM('(4)Income & Expense Input'!D40:D45)","v":0}]
[null,null,{"$f":"C106+C107+C108","v":0}]
[]
[null,null,{"$f":"C121*C88","v":2156766.2596186013},{"$f":"C111*(1-'(4)Income & Expense Input'!D7)","v":1973441.1275510204}]
[null,null,{"$f":"C122*C89","v":0},{"$f":"C112*(1-'(4)Income & Expense Input'!D10)","v":0}]
[null,null,{"$f":"C123*C90","v":0},{"$f":"C113*(1-'(4)Income & Expense Input'!D13)","v":0}]
[null,null,{"$f":"C111+C112+C113","v":2156766.2596186013},{"$f":"D111+D112+D113","v":1973441.1275510204}]
[]
[null,null,null,{"$f":"((C106+D111)/(1-'(4)Income & Expense Input'!D30))-(C106+D111)","v":0}]
[null,null,null,{"$f":"((C107+D112)/(1-'(4)Income & Expense Input'!D38))-(C107+D112)","v":0}]
[null,null,null,{"$f":"((C108+D113)/(1-'(4)Income & Expense Input'!D46))-(C108+D113)","v":0}]
[null,null,null,{"$f":"D116+D117+D118","v":0}]
[]
[null,null,{"$f":"'(4)Income & Expense Input'!D5","v":500000}]
[null,null,{"$f":"'(4)Income & Expense Input'!D8","v":0}]
[null,null,{"$f":"'(4)Income & Expense Input'!D11","v":0}]
[null,null,{"$f":"C121+C122+C123","v":500000}]

{"sheet":"(9)Annual Cash Flow Projection","index":9,"n_rows":50,"n_cols":14,"rows_kept":50,"cut":false,"hidden":false,"merged":[[39,1,39,2],[1,1,1,5],[2,1,2,2],[3,1,3,2],[14,1,14,2],[22,1,22,2],[30,1,30,2]]}
[]
[null,"Annual Cash Flow Projection"]
[null,"End of Year",null,1,2,3,4,5,6,7,8,9,10,11]
[null,"Potential Rental Income"]
[null,1,"Category \"A\" Space",{"$f":"'(4)Income & Expense Input'!D5*'(4)Income & Expense Input'!D6","v":3310000},{"$f":"D5*(1+'(4)Income & Expense Input'!E6)","v":3392749.9999999995},{"$f":"E5*(1+'(4)Income & Expense Input'!F6)","v":3477568.7499999991},{"$f":"F5*(1+'(4)Income & Expense Input'!G6)","v":3564507.9687499986},{"$f":"G5*(1+'(4)Income & Expense Input'!H6)","v":3653620.6679687481},{"$f":"H5*(1+'(4)Income & Expense Input'!I6)","v":3744961.1846679663},{"$f":"I5*(1+'(4)Income & Expense Input'!J6)","v":3838585.214284665},{"$f":"J5*(1+'(4)Income & Expense Input'!K6)","v":3934549.8446417814},{"$f":"K5*(1+'(4)Income & Expense Input'!L6)","v":4032913.5907578254},{"$f":"L5*(1+'(4)Income & Expense Input'!M6)","v":4133736.4305267707},{"$f":"M5*(1+'(4)Income & Expense Input'!N6)","v":4237079.8412899394}]
[null,2,"Category \"B\" Space",{"$f":"'(4)Income & Expense Input'!D8*'(4)Income & Expense Input'!D9","v":0},{"$f":"D6*(1+'(4)Income & Expense Input'!E9)","v":0},{"$f":"E6*(1+'(4)Income & Expense Input'!F9)","v":0},{"$f":"F6*(1+'(4)Income & Expense Input'!G9)","v":0},{"$f":"G6*(1+'(4)Income & Expense Input'!H9)","v":0},{"$f":"H6*(1+'(4)Income & Expense Input'!I9)","v":0},{"$f":"I6*(1+'(4)Income & Expense Input'!J9)","v":0},{"$f":"J6*(1+'(4)Income & Expense Input'!K9)","v":0},{"$f":"K6*(1+'(4)Income & Expense Input'!L9)","v":0},{"$f":"L6*(1+'(4)Income & Expense Input'!M9)","v":0},{"$f":"M6*(1+'(4)Income & Expense Input'!N9)","v":0}]
[null,3,"Category \"C\" Space",{"$f":"'(4)Income & Expense Input'!D11*'(4)Income & Expense Input'!D12","v":0},{"$f":"D7*(1+'(4)Income & Expense Input'!E12)","v":0},{"$f":"E7*(1+'(4)Income & Expense Input'!F12)","v":0},{"$f":"F7*(1+'(4)Income & Expense Input'!G12)","v":0},{"$f":"G7*(1+'(4)Income & Expense Input'!H12)","v":0},{"$f":"H7*(1+'(4)Income & Expense Input'!I12)","v":0},{"$f":"I7*(1+'(4)Income & Expense Input'!J12)","v":0},{"$f":"J7*(1+'(4)Income & Expense Input'!K12)","v":0},{"$f":"K7*(1+'(4)Income & Expense Input'!L12)","v":0},{"$f":"L7*(1+'(4)Income & Expense Input'!M12)","v":0},{"$f":"M7*(1+'(4)Income & Expense Input'!N12)","v":0}]
[null,4,"Total Potential Rental Income",{"$f":"SUM(D5:D7)","v":3310000},{"$f":"SUM(E5:E7)","v":3392749.9999999995},3477568.7499999991,3564507.9687499986,3653620.6679687481,3744961.1846679663,3838585.214284665,3934549.8446417814,4032913.5907578254,4133736.4305267707,4237079.8412899394]
[null,5,"Category \"A\" Space Vacancy",{"$f":"D5*'(4)Income & Expense Input'!D7","v":281350},{"$f":"E5*'(4)Income & Expense Input'!E7","v":288383.75},{"$f":"F5*'(4)Income & Expense Input'!F7","v":295593.34374999994},{"$f":"G5*'(4)Income & Expense Input'!G7","v":302983.17734374991},{"$f":"H5*'(4)Income & Expense Input'!H7","v":310557.75677734363},{"$f":"I5*'(4)Income & Expense Input'!I7","v":318321.70069677714},{"$f":"J5*'(4)Income & Expense Input'!J7","v":326279.74321419653},{"$f":"K5*'(4)Income & Expense Input'!K7","v":334436.73679455143},{"$f":"L5*'(4)Income & Expense Input'!L7","v":342797.65521441516},{"$f":"M5*'(4)Income & Expense Input'!M7","v":351367.5965947755},{"$f":"N5*'(4)Income & Expense Input'!N7","v":360151.78650964488}]
[null,6,"Category \"B\" Space Vacancy",{"$f":"D6*'(4)Income & Expense Input'!D10","v":0},{"$f":"E6*'(4)Income & Expense Input'!E10","v":0},{"$f":"F6*'(4)Income & Expense Input'!F10","v":0},{"$f":"G6*'(4)Income & Expense Input'!G10","v":0},{"$f":"H6*'(4)Income & Expense Input'!H10","v":0},{"$f":"I6*'(4)Income & Expense Input'!I10","v":0},{"$f":"J6*'(4)Income & Expense Input'!J10","v":0},{"$f":"K6*'(4)Income & Expense Input'!K10","v":0},{"$f":"L6*'(4)Income & Expense Input'!L10","v":0},{"$f":"M6*'(4)Income & Expense Input'!M10","v":0},{"$f":"N6*'(4)Income & Expense Input'!N10","v":0}]
[null,7,"Category \"C\" Space Vacancy",{"$f":"D7*'(4)Income & Expense Input'!D13","v":0},{"$f":"E7*'(4)Income & Expense Input'!E13","v":0},{"$f":"F7*'(4)Income & Expense Input'!F13","v":0},{"$f":"G7*'(4)Income & Expense Input'!G13","v":0},{"$f":"H7*'(4)Income & Expense Input'!H13","v":0},{"$f":"I7*'(4)Income & Expense Input'!I13","v":0},{"$f":"J7*'(4)Income & Expense Input'!J13","v":0},{"$f":"K7*'(4)Income & Expense Input'!K13","v":0},{"$f":"L7*'(4)Income & Expense Input'!L13","v":0},{"$f":"M7*'(4)Income & Expense Input'!M13","v":0},{"$f":"N7*'(4)Income & Expense Input'!N13","v":0}]
[null,8,"Effective Rental Income",{"$f":"D8-SUM(D9:D11)","v":3028650},{"$f":"E8-SUM(E9:E11)","v":3104366.2499999995},3181975.4062499991,3261524.7914062487,3343062.9111914043,3426639.4839711892,3512305.4710704684,3600113.10784723,3690115.9355434105,3782368.8339319951,3876928.0547802947]
[null,9,"Weighted Average RSF",{"$f":"IF(('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11)=0,0,D8/('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11))","v":6.62},{"$f":"IF(('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11)=0,0,E8/('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11))","v":6.785499999999999},{"$f":"IF(('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11)=0,0,F8/('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11))","v":6.9551374999999984},{"$f":"IF(('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11)=0,0,G8/('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11))","v":7.1290159374999975},{"$f":"IF(('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11)=0,0,H8/('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11))","v":7.3072413359374959},{"$f":"IF(('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11)=0,0,I8/('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11))","v":7.4899223693359325},{"$f":"IF(('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11)=0,0,J8/('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11))","v":7.6771704285693296},{"$f":"IF(('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11)=0,0,K8/('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11))","v":7.869099689283563},{"$f":"IF(('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11)=0,0,L8/('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11))","v":8.065827181515651},{"$f":"IF(('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11)=0,0,M8/('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11))","v":8.2674728610535411},{"$f":"IF(('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11)=0,0,N8/('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11))","v":8.4741596825798791}]
[null,10,"Weighted Average Vacancy Rate",{"$f":"IF(D8=0,0,SUM(D9:D11)/D8)","v":8.5000000000000006E-2},{"$f":"IF(E8=0,0,SUM(E9:E11)/E8)","v":8.5000000000000006E-2},{"$f":"IF(F8=0,0,SUM(F9:F11)/F8)","v":8.5000000000000006E-2},8.5000000000000006E-2,8.5000000000000006E-2,8.5000000000000006E-2,8.5000000000000006E-2,8.5000000000000006E-2,8.5000000000000006E-2,8.5000000000000006E-2,8.5000000000000006E-2]
[null,"Category \"A\" Space Pass-thrus"]
[null,11,"Real Estate Taxes",{"$f":"('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D24)*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D24)*(1+'(4)Income & Expense Input'!E24))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D24)*(1+'(4)Income & Expense Input'!E24)*(1+'(4)Income & Expense Input'!F24))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D24)*(1+'(4)Income & Expense Input'!E24)*(1+'(4)Income & Expense Input'!F24)*(1+'(4)Income & Expense Input'!G24))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D24)*(1+'(4)Income & Expense Input'!E24)*(1+'(4)Income & Expense Input'!F24)*(1+'(4)Income & Expense Input'!G24)*(1+'(4)Income & Expense Input'!H24))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D24)*(1+'(4)Income & Expense Input'!E24)*(1+'(4)Income & Expense Input'!F24)*(1+'(4)Income & Expense Input'!G24)*(1+'(4)Income & Expense Input'!H24)*(1+'(4)Income & Expense Input'!I24))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D24)*(1+'(4)Income & Expense Input'!E24)*(1+'(4)Income & Expense Input'!F24)*(1+'(4)Income & Expense Input'!G24)*(1+'(4)Income & Expense Input'!H24)*(1+'(4)Income & Expense Input'!I24)*(1+'(4)Income & Expense Input'!J24))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D24)*(1+'(4)Income & Expense Input'!E24)*(1+'(4)Income & Expense Input'!F24)*(1+'(4)Income & Expense Input'!G24)*(1+'(4)Income & Expense Input'!H24)*(1+'(4)Income & Expense Input'!I24)*(1+'(4)Income & Expense Input'!J24)*(1+'(4)Income & Expense Input'!K24))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D24)*(1+'(4)Income & Expense Input'!E24)*(1+'(4)Income & Expense Input'!F24)*(1+'(4)Income & Expense Input'!G24)*(1+'(4)Income & Expense Input'!H24)*(1+'(4)Income & Expense Input'!I24)*(1+'(4)Income & Expense Input'!J24)*(1+'(4)Income & Expense Input'!K24)*(1+'(4)Income & Expense Input'!L24))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D24)*(1+'(4)Income & Expense Input'!E24)*(1+'(4)Income & Expense Input'!F24)*(1+'(4)Income & Expense Input'!G24)*(1+'(4)Income & Expense Input'!H24)*(1+'(4)Income & Expense Input'!I24)*(1+'(4)Income & Expense Input'!J24)*(1+'(4)Income & Expense Input'!K24)*(1+'(4)Income & Expense Input'!L24)*(1+'(4)Income & Expense Input'!M24))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D24)*(1+'(4)Income & Expense Input'!E24)*(1+'(4)Income & Expense Input'!F24)*(1+'(4)Income & Expense Input'!G24)*(1+'(4)Income & Expense Input'!H24)*(1+'(4)Income & Expense Input'!I24)*(1+'(4)Income & Expense Input'!J24)*(1+'(4)Income & Expense Input'!K24)*(1+'(4)Income & Expense Input'!L24)*(1+'(4)Income & Expense Input'!M24)*(1+'(4)Income & Expense Input'!N24))*(1-'(4)Income & Expense Input'!$D$7)","v":0}]
[null,12,"Insurance",{"$f":"('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D25)*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D25)*(1+'(4)Income & Expense Input'!E25))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D25)*(1+'(4)Income & Expense Input'!E25)*(1+'(4)Income & Expense Input'!F25))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D25)*(1+'(4)Income & Expense Input'!E25)*(1+'(4)Income & Expense Input'!F25)*(1+'(4)Income & Expense Input'!G25))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D25)*(1+'(4)Income & Expense Input'!E25)*(1+'(4)Income & Expense Input'!F25)*(1+'(4)Income & Expense Input'!G25)*(1+'(4)Income & Expense Input'!H25))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D25)*(1+'(4)Income & Expense Input'!E25)*(1+'(4)Income & Expense Input'!F25)*(1+'(4)Income & Expense Input'!G25)*(1+'(4)Income & Expense Input'!H25)*(1+'(4)Income & Expense Input'!I25))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D25)*(1+'(4)Income & Expense Input'!E25)*(1+'(4)Income & Expense Input'!F25)*(1+'(4)Income & Expense Input'!G25)*(1+'(4)Income & Expense Input'!H25)*(1+'(4)Income & Expense Input'!I25)*(1+'(4)Income & Expense Input'!J25))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D25)*(1+'(4)Income & Expense Input'!E25)*(1+'(4)Income & Expense Input'!F25)*(1+'(4)Income & Expense Input'!G25)*(1+'(4)Income & Expense Input'!H25)*(1+'(4)Income & Expense Input'!I25)*(1+'(4)Income & Expense Input'!J25)*(1+'(4)Income & Expense Input'!K25))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D25)*(1+'(4)Income & Expense Input'!E25)*(1+'(4)Income & Expense Input'!F25)*(1+'(4)Income & Expense Input'!G25)*(1+'(4)Income & Expense Input'!H25)*(1+'(4)Income & Expense Input'!I25)*(1+'(4)Income & Expense Input'!J25)*(1+'(4)Income & Expense Input'!K25)*(1+'(4)Income & Expense Input'!L25))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D25)*(1+'(4)Income & Expense Input'!E25)*(1+'(4)Income & Expense Input'!F25)*(1+'(4)Income & Expense Input'!G25)*(1+'(4)Income & Expense Input'!H25)*(1+'(4)Income & Expense Input'!I25)*(1+'(4)Income & Expense Input'!J25)*(1+'(4)Income & Expense Input'!K25)*(1+'(4)Income & Expense Input'!L25)*(1+'(4)Income & Expense Input'!M25))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D25)*(1+'(4)Income & Expense Input'!E25)*(1+'(4)Income & Expense Input'!F25)*(1+'(4)Income & Expense Input'!G25)*(1+'(4)Income & Expense Input'!H25)*(1+'(4)Income & Expense Input'!I25)*(1+'(4)Income & Expense Input'!J25)*(1+'(4)Income & Expense Input'!K25)*(1+'(4)Income & Expense Input'!L25)*(1+'(4)Income & Expense Input'!M25)*(1+'(4)Income & Expense Input'!N25))*(1-'(4)Income & Expense Input'!$D$7)","v":0}]
[null,13,"Building Maintenance",{"$f":"('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D26)*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D26)*(1+'(4)Income & Expense Input'!E26))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D26)*(1+'(4)Income & Expense Input'!E26)*(1+'(4)Income & Expense Input'!F26))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D26)*(1+'(4)Income & Expense Input'!E26)*(1+'(4)Income & Expense Input'!F26)*(1+'(4)Income & Expense Input'!G26))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D26)*(1+'(4)Income & Expense Input'!E26)*(1+'(4)Income & Expense Input'!F26)*(1+'(4)Income & Expense Input'!G26)*(1+'(4)Income & Expense Input'!H26))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D26)*(1+'(4)Income & Expense Input'!E26)*(1+'(4)Income & Expense Input'!F26)*(1+'(4)Income & Expense Input'!G26)*(1+'(4)Income & Expense Input'!H26)*(1+'(4)Income & Expense Input'!I26))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D26)*(1+'(4)Income & Expense Input'!E26)*(1+'(4)Income & Expense Input'!F26)*(1+'(4)Income & Expense Input'!G26)*(1+'(4)Income & Expense Input'!H26)*(1+'(4)Income & Expense Input'!I26)*(1+'(4)Income & Expense Input'!J26))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D26)*(1+'(4)Income & Expense Input'!E26)*(1+'(4)Income & Expense Input'!F26)*(1+'(4)Income & Expense Input'!G26)*(1+'(4)Income & Expense Input'!H26)*(1+'(4)Income & Expense Input'!I26)*(1+'(4)Income & Expense Input'!J26)*(1+'(4)Income & Expense Input'!K26))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D26)*(1+'(4)Income & Expense Input'!E26)*(1+'(4)Income & Expense Input'!F26)*(1+'(4)Income & Expense Input'!G26)*(1+'(4)Income & Expense Input'!H26)*(1+'(4)Income & Expense Input'!I26)*(1+'(4)Income & Expense Input'!J26)*(1+'(4)Income & Expense Input'!K26)*(1+'(4)Income & Expense Input'!L26))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D26)*(1+'(4)Income & Expense Input'!E26)*(1+'(4)Income & Expense Input'!F26)*(1+'(4)Income & Expense Input'!G26)*(1+'(4)Income & Expense Input'!H26)*(1+'(4)Income & Expense Input'!I26)*(1+'(4)Income & Expense Input'!J26)*(1+'(4)Income & Expense Input'!K26)*(1+'(4)Income & Expense Input'!L26)*(1+'(4)Income & Expense Input'!M26))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D26)*(1+'(4)Income & Expense Input'!E26)*(1+'(4)Income & Expense Input'!F26)*(1+'(4)Income & Expense Input'!G26)*(1+'(4)Income & Expense Input'!H26)*(1+'(4)Income & Expense Input'!I26)*(1+'(4)Income & Expense Input'!J26)*(1+'(4)Income & Expense Input'!K26)*(1+'(4)Income & Expense Input'!L26)*(1+'(4)Income & Expense Input'!M26)*(1+'(4)Income & Expense Input'!N26))*(1-'(4)Income & Expense Input'!$D$7)","v":0}]
[null,14,"Common Area Utilities",{"$f":"('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D27)*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D27)*(1+'(4)Income & Expense Input'!E27))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D27)*(1+'(4)Income & Expense Input'!E27)*(1+'(4)Income & Expense Input'!F27))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D27)*(1+'(4)Income & Expense Input'!E27)*(1+'(4)Income & Expense Input'!F27)*(1+'(4)Income & Expense Input'!G27))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D27)*(1+'(4)Income & Expense Input'!E27)*(1+'(4)Income & Expense Input'!F27)*(1+'(4)Income & Expense Input'!G27)*(1+'(4)Income & Expense Input'!H27))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D27)*(1+'(4)Income & Expense Input'!E27)*(1+'(4)Income & Expense Input'!F27)*(1+'(4)Income & Expense Input'!G27)*(1+'(4)Income & Expense Input'!H27)*(1+'(4)Income & Expense Input'!I27))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D27)*(1+'(4)Income & Expense Input'!E27)*(1+'(4)Income & Expense Input'!F27)*(1+'(4)Income & Expense Input'!G27)*(1+'(4)Income & Expense Input'!H27)*(1+'(4)Income & Expense Input'!I27)*(1+'(4)Income & Expense Input'!J27))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D27)*(1+'(4)Income & Expense Input'!E27)*(1+'(4)Income & Expense Input'!F27)*(1+'(4)Income & Expense Input'!G27)*(1+'(4)Income & Expense Input'!H27)*(1+'(4)Income & Expense Input'!I27)*(1+'(4)Income & Expense Input'!J27)*(1+'(4)Income & Expense Input'!K27))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D27)*(1+'(4)Income & Expense Input'!E27)*(1+'(4)Income & Expense Input'!F27)*(1+'(4)Income & Expense Input'!G27)*(1+'(4)Income & Expense Input'!H27)*(1+'(4)Income & Expense Input'!I27)*(1+'(4)Income & Expense Input'!J27)*(1+'(4)Income & Expense Input'!K27)*(1+'(4)Income & Expense Input'!L27))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D27)*(1+'(4)Income & Expense Input'!E27)*(1+'(4)Income & Expense Input'!F27)*(1+'(4)Income & Expense Input'!G27)*(1+'(4)Income & Expense Input'!H27)*(1+'(4)Income & Expense Input'!I27)*(1+'(4)Income & Expense Input'!J27)*(1+'(4)Income & Expense Input'!K27)*(1+'(4)Income & Expense Input'!L27)*(1+'(4)Income & Expense Input'!M27))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D27)*(1+'(4)Income & Expense Input'!E27)*(1+'(4)Income & Expense Input'!F27)*(1+'(4)Income & Expense Input'!G27)*(1+'(4)Income & Expense Input'!H27)*(1+'(4)Income & Expense Input'!I27)*(1+'(4)Income & Expense Input'!J27)*(1+'(4)Income & Expense Input'!K27)*(1+'(4)Income & Expense Input'!L27)*(1+'(4)Income & Expense Input'!M27)*(1+'(4)Income & Expense Input'!N27))*(1-'(4)Income & Expense Input'!$D$7)","v":0}]
[null,15,"Common Area Maintenance",{"$f":"('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D28)*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D28)*(1+'(4)Income & Expense Input'!E28))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D28)*(1+'(4)Income & Expense Input'!E28)*(1+'(4)Income & Expense Input'!F28))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D28)*(1+'(4)Income & Expense Input'!E28)*(1+'(4)Income & Expense Input'!F28)*(1+'(4)Income & Expense Input'!G28))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D28)*(1+'(4)Income & Expense Input'!E28)*(1+'(4)Income & Expense Input'!F28)*(1+'(4)Income & Expense Input'!G28)*(1+'(4)Income & Expense Input'!H28))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D28)*(1+'(4)Income & Expense Input'!E28)*(1+'(4)Income & Expense Input'!F28)*(1+'(4)Income & Expense Input'!G28)*(1+'(4)Income & Expense Input'!H28)*(1+'(4)Income & Expense Input'!I28))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D28)*(1+'(4)Income & Expense Input'!E28)*(1+'(4)Income & Expense Input'!F28)*(1+'(4)Income & Expense Input'!G28)*(1+'(4)Income & Expense Input'!H28)*(1+'(4)Income & Expense Input'!I28)*(1+'(4)Income & Expense Input'!J28))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D28)*(1+'(4)Income & Expense Input'!E28)*(1+'(4)Income & Expense Input'!F28)*(1+'(4)Income & Expense Input'!G28)*(1+'(4)Income & Expense Input'!H28)*(1+'(4)Income & Expense Input'!I28)*(1+'(4)Income & Expense Input'!J28)*(1+'(4)Income & Expense Input'!K28))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D28)*(1+'(4)Income & Expense Input'!E28)*(1+'(4)Income & Expense Input'!F28)*(1+'(4)Income & Expense Input'!G28)*(1+'(4)Income & Expense Input'!H28)*(1+'(4)Income & Expense Input'!I28)*(1+'(4)Income & Expense Input'!J28)*(1+'(4)Income & Expense Input'!K28)*(1+'(4)Income & Expense Input'!L28))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D28)*(1+'(4)Income & Expense Input'!E28)*(1+'(4)Income & Expense Input'!F28)*(1+'(4)Income & Expense Input'!G28)*(1+'(4)Income & Expense Input'!H28)*(1+'(4)Income & Expense Input'!I28)*(1+'(4)Income & Expense Input'!J28)*(1+'(4)Income & Expense Input'!K28)*(1+'(4)Income & Expense Input'!L28)*(1+'(4)Income & Expense Input'!M28))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D28)*(1+'(4)Income & Expense Input'!E28)*(1+'(4)Income & Expense Input'!F28)*(1+'(4)Income & Expense Input'!G28)*(1+'(4)Income & Expense Input'!H28)*(1+'(4)Income & Expense Input'!I28)*(1+'(4)Income & Expense Input'!J28)*(1+'(4)Income & Expense Input'!K28)*(1+'(4)Income & Expense Input'!L28)*(1+'(4)Income & Expense Input'!M28)*(1+'(4)Income & Expense Input'!N28))*(1-'(4)Income & Expense Input'!$D$7)","v":0}]
[null,16,"Reserve for Replacements",{"$f":"('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D29)*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D29)*(1+'(4)Income & Expense Input'!E29))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D29)*(1+'(4)Income & Expense Input'!E29)*(1+'(4)Income & Expense Input'!F29))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D29)*(1+'(4)Income & Expense Input'!E29)*(1+'(4)Income & Expense Input'!F29)*(1+'(4)Income & Expense Input'!G29))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D29)*(1+'(4)Income & Expense Input'!E29)*(1+'(4)Income & Expense Input'!F29)*(1+'(4)Income & Expense Input'!G29)*(1+'(4)Income & Expense Input'!H29))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D29)*(1+'(4)Income & Expense Input'!E29)*(1+'(4)Income & Expense Input'!F29)*(1+'(4)Income & Expense Input'!G29)*(1+'(4)Income & Expense Input'!H29)*(1+'(4)Income & Expense Input'!I29))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D29)*(1+'(4)Income & Expense Input'!E29)*(1+'(4)Income & Expense Input'!F29)*(1+'(4)Income & Expense Input'!G29)*(1+'(4)Income & Expense Input'!H29)*(1+'(4)Income & Expense Input'!I29)*(1+'(4)Income & Expense Input'!J29))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D29)*(1+'(4)Income & Expense Input'!E29)*(1+'(4)Income & Expense Input'!F29)*(1+'(4)Income & Expense Input'!G29)*(1+'(4)Income & Expense Input'!H29)*(1+'(4)Income & Expense Input'!I29)*(1+'(4)Income & Expense Input'!J29)*(1+'(4)Income & Expense Input'!K29))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D29)*(1+'(4)Income & Expense Input'!E29)*(1+'(4)Income & Expense Input'!F29)*(1+'(4)Income & Expense Input'!G29)*(1+'(4)Income & Expense Input'!H29)*(1+'(4)Income & Expense Input'!I29)*(1+'(4)Income & Expense Input'!J29)*(1+'(4)Income & Expense Input'!K29)*(1+'(4)Income & Expense Input'!L29))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D29)*(1+'(4)Income & Expense Input'!E29)*(1+'(4)Income & Expense Input'!F29)*(1+'(4)Income & Expense Input'!G29)*(1+'(4)Income & Expense Input'!H29)*(1+'(4)Income & Expense Input'!I29)*(1+'(4)Income & Expense Input'!J29)*(1+'(4)Income & Expense Input'!K29)*(1+'(4)Income & Expense Input'!L29)*(1+'(4)Income & Expense Input'!M29))*(1-'(4)Income & Expense Input'!$D$7)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$5*'(4)Income & Expense Input'!D29)*(1+'(4)Income & Expense Input'!E29)*(1+'(4)Income & Expense Input'!F29)*(1+'(4)Income & Expense Input'!G29)*(1+'(4)Income & Expense Input'!H29)*(1+'(4)Income & Expense Input'!I29)*(1+'(4)Income & Expense Input'!J29)*(1+'(4)Income & Expense Input'!K29)*(1+'(4)Income & Expense Input'!L29)*(1+'(4)Income & Expense Input'!M29)*(1+'(4)Income & Expense Input'!N29))*(1-'(4)Income & Expense Input'!$D$7)","v":0}]
[null,17,"Property Management",{"$f":"((D5-D9+SUM(D16:D21))/(1-'(4)Income & Expense Input'!D30))-(D5-D9+SUM(D16:D21))","v":0},{"$f":"((E5-E9+SUM(E16:E21))/(1-'(4)Income & Expense Input'!E30))-(E5-E9+SUM(E16:E21))","v":0},{"$f":"((F5-F9+SUM(F16:F21))/(1-'(4)Income & Expense Input'!F30))-(F5-F9+SUM(F16:F21))","v":0},{"$f":"((G5-G9+SUM(G16:G21))/(1-'(4)Income & Expense Input'!G30))-(G5-G9+SUM(G16:G21))","v":0},{"$f":"((H5-H9+SUM(H16:H21))/(1-'(4)Income & Expense Input'!H30))-(H5-H9+SUM(H16:H21))","v":0},{"$f":"((I5-I9+SUM(I16:I21))/(1-'(4)Income & Expense Input'!I30))-(I5-I9+SUM(I16:I21))","v":0},{"$f":"((J5-J9+SUM(J16:J21))/(1-'(4)Income & Expense Input'!J30))-(J5-J9+SUM(J16:J21))","v":0},{"$f":"((K5-K9+SUM(K16:K21))/(1-'(4)Income & Expense Input'!K30))-(K5-K9+SUM(K16:K21))","v":0},{"$f":"((L5-L9+SUM(L16:L21))/(1-'(4)Income & Expense Input'!L30))-(L5-L9+SUM(L16:L21))","v":0},{"$f":"((M5-M9+SUM(M16:M21))/(1-'(4)Income & Expense Input'!M30))-(M5-M9+SUM(M16:M21))","v":0},{"$f":"((N5-N9+SUM(N16:N21))/(1-'(4)Income & Expense Input'!N30))-(N5-N9+SUM(N16:N21))","v":0}]
[null,"Category \"B\" Space Pass-thrus"]
[null,18,"Real Estate Taxes",{"$f":"('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D32)*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D32)*(1+'(4)Income & Expense Input'!E32))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D32)*(1+'(4)Income & Expense Input'!E32)*(1+'(4)Income & Expense Input'!F32))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D32)*(1+'(4)Income & Expense Input'!E32)*(1+'(4)Income & Expense Input'!F32)*(1+'(4)Income & Expense Input'!G32))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D32)*(1+'(4)Income & Expense Input'!E32)*(1+'(4)Income & Expense Input'!F32)*(1+'(4)Income & Expense Input'!G32)*(1+'(4)Income & Expense Input'!H32))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D32)*(1+'(4)Income & Expense Input'!E32)*(1+'(4)Income & Expense Input'!F32)*(1+'(4)Income & Expense Input'!G32)*(1+'(4)Income & Expense Input'!H32)*(1+'(4)Income & Expense Input'!I32))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D32)*(1+'(4)Income & Expense Input'!E32)*(1+'(4)Income & Expense Input'!F32)*(1+'(4)Income & Expense Input'!G32)*(1+'(4)Income & Expense Input'!H32)*(1+'(4)Income & Expense Input'!I32)*(1+'(4)Income & Expense Input'!J32))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D32)*(1+'(4)Income & Expense Input'!E32)*(1+'(4)Income & Expense Input'!F32)*(1+'(4)Income & Expense Input'!G32)*(1+'(4)Income & Expense Input'!H32)*(1+'(4)Income & Expense Input'!I32)*(1+'(4)Income & Expense Input'!J32)*(1+'(4)Income & Expense Input'!K32))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D32)*(1+'(4)Income & Expense Input'!E32)*(1+'(4)Income & Expense Input'!F32)*(1+'(4)Income & Expense Input'!G32)*(1+'(4)Income & Expense Input'!H32)*(1+'(4)Income & Expense Input'!I32)*(1+'(4)Income & Expense Input'!J32)*(1+'(4)Income & Expense Input'!K32)*(1+'(4)Income & Expense Input'!L32))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D32)*(1+'(4)Income & Expense Input'!E32)*(1+'(4)Income & Expense Input'!F32)*(1+'(4)Income & Expense Input'!G32)*(1+'(4)Income & Expense Input'!H32)*(1+'(4)Income & Expense Input'!I32)*(1+'(4)Income & Expense Input'!J32)*(1+'(4)Income & Expense Input'!K32)*(1+'(4)Income & Expense Input'!L32)*(1+'(4)Income & Expense Input'!M32))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D32)*(1+'(4)Income & Expense Input'!E32)*(1+'(4)Income & Expense Input'!F32)*(1+'(4)Income & Expense Input'!G32)*(1+'(4)Income & Expense Input'!H32)*(1+'(4)Income & Expense Input'!I32)*(1+'(4)Income & Expense Input'!J32)*(1+'(4)Income & Expense Input'!K32)*(1+'(4)Income & Expense Input'!L32)*(1+'(4)Income & Expense Input'!M32)*(1+'(4)Income & Expense Input'!N32))*(1-'(4)Income & Expense Input'!$D$10)","v":0}]
[null,19,"Insurance",{"$f":"('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D33)*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D33)*(1+'(4)Income & Expense Input'!E33))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D33)*(1+'(4)Income & Expense Input'!E33)*(1+'(4)Income & Expense Input'!F33))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D33)*(1+'(4)Income & Expense Input'!E33)*(1+'(4)Income & Expense Input'!F33)*(1+'(4)Income & Expense Input'!G33))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D33)*(1+'(4)Income & Expense Input'!E33)*(1+'(4)Income & Expense Input'!F33)*(1+'(4)Income & Expense Input'!G33)*(1+'(4)Income & Expense Input'!H33))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D33)*(1+'(4)Income & Expense Input'!E33)*(1+'(4)Income & Expense Input'!F33)*(1+'(4)Income & Expense Input'!G33)*(1+'(4)Income & Expense Input'!H33)*(1+'(4)Income & Expense Input'!I33))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D33)*(1+'(4)Income & Expense Input'!E33)*(1+'(4)Income & Expense Input'!F33)*(1+'(4)Income & Expense Input'!G33)*(1+'(4)Income & Expense Input'!H33)*(1+'(4)Income & Expense Input'!I33)*(1+'(4)Income & Expense Input'!J33))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D33)*(1+'(4)Income & Expense Input'!E33)*(1+'(4)Income & Expense Input'!F33)*(1+'(4)Income & Expense Input'!G33)*(1+'(4)Income & Expense Input'!H33)*(1+'(4)Income & Expense Input'!I33)*(1+'(4)Income & Expense Input'!J33)*(1+'(4)Income & Expense Input'!K33))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D33)*(1+'(4)Income & Expense Input'!E33)*(1+'(4)Income & Expense Input'!F33)*(1+'(4)Income & Expense Input'!G33)*(1+'(4)Income & Expense Input'!H33)*(1+'(4)Income & Expense Input'!I33)*(1+'(4)Income & Expense Input'!J33)*(1+'(4)Income & Expense Input'!K33)*(1+'(4)Income & Expense Input'!L33))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D33)*(1+'(4)Income & Expense Input'!E33)*(1+'(4)Income & Expense Input'!F33)*(1+'(4)Income & Expense Input'!G33)*(1+'(4)Income & Expense Input'!H33)*(1+'(4)Income & Expense Input'!I33)*(1+'(4)Income & Expense Input'!J33)*(1+'(4)Income & Expense Input'!K33)*(1+'(4)Income & Expense Input'!L33)*(1+'(4)Income & Expense Input'!M33))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D33)*(1+'(4)Income & Expense Input'!E33)*(1+'(4)Income & Expense Input'!F33)*(1+'(4)Income & Expense Input'!G33)*(1+'(4)Income & Expense Input'!H33)*(1+'(4)Income & Expense Input'!I33)*(1+'(4)Income & Expense Input'!J33)*(1+'(4)Income & Expense Input'!K33)*(1+'(4)Income & Expense Input'!L33)*(1+'(4)Income & Expense Input'!M33)*(1+'(4)Income & Expense Input'!N33))*(1-'(4)Income & Expense Input'!$D$10)","v":0}]
[null,20,"Building Maintenance",{"$f":"('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D34)*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D34)*(1+'(4)Income & Expense Input'!E34))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D34)*(1+'(4)Income & Expense Input'!E34)*(1+'(4)Income & Expense Input'!F34))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D34)*(1+'(4)Income & Expense Input'!E34)*(1+'(4)Income & Expense Input'!F34)*(1+'(4)Income & Expense Input'!G34))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D34)*(1+'(4)Income & Expense Input'!E34)*(1+'(4)Income & Expense Input'!F34)*(1+'(4)Income & Expense Input'!G34)*(1+'(4)Income & Expense Input'!H34))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D34)*(1+'(4)Income & Expense Input'!E34)*(1+'(4)Income & Expense Input'!F34)*(1+'(4)Income & Expense Input'!G34)*(1+'(4)Income & Expense Input'!H34)*(1+'(4)Income & Expense Input'!I34))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D34)*(1+'(4)Income & Expense Input'!E34)*(1+'(4)Income & Expense Input'!F34)*(1+'(4)Income & Expense Input'!G34)*(1+'(4)Income & Expense Input'!H34)*(1+'(4)Income & Expense Input'!I34)*(1+'(4)Income & Expense Input'!J34))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D34)*(1+'(4)Income & Expense Input'!E34)*(1+'(4)Income & Expense Input'!F34)*(1+'(4)Income & Expense Input'!G34)*(1+'(4)Income & Expense Input'!H34)*(1+'(4)Income & Expense Input'!I34)*(1+'(4)Income & Expense Input'!J34)*(1+'(4)Income & Expense Input'!K34))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D34)*(1+'(4)Income & Expense Input'!E34)*(1+'(4)Income & Expense Input'!F34)*(1+'(4)Income & Expense Input'!G34)*(1+'(4)Income & Expense Input'!H34)*(1+'(4)Income & Expense Input'!I34)*(1+'(4)Income & Expense Input'!J34)*(1+'(4)Income & Expense Input'!K34)*(1+'(4)Income & Expense Input'!L34))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D34)*(1+'(4)Income & Expense Input'!E34)*(1+'(4)Income & Expense Input'!F34)*(1+'(4)Income & Expense Input'!G34)*(1+'(4)Income & Expense Input'!H34)*(1+'(4)Income & Expense Input'!I34)*(1+'(4)Income & Expense Input'!J34)*(1+'(4)Income & Expense Input'!K34)*(1+'(4)Income & Expense Input'!L34)*(1+'(4)Income & Expense Input'!M34))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D34)*(1+'(4)Income & Expense Input'!E34)*(1+'(4)Income & Expense Input'!F34)*(1+'(4)Income & Expense Input'!G34)*(1+'(4)Income & Expense Input'!H34)*(1+'(4)Income & Expense Input'!I34)*(1+'(4)Income & Expense Input'!J34)*(1+'(4)Income & Expense Input'!K34)*(1+'(4)Income & Expense Input'!L34)*(1+'(4)Income & Expense Input'!M34)*(1+'(4)Income & Expense Input'!N34))*(1-'(4)Income & Expense Input'!$D$10)","v":0}]
[null,21,"Common Area Utilities",{"$f":"('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D35)*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D35)*(1+'(4)Income & Expense Input'!E35))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D35)*(1+'(4)Income & Expense Input'!E35)*(1+'(4)Income & Expense Input'!F35))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D35)*(1+'(4)Income & Expense Input'!E35)*(1+'(4)Income & Expense Input'!F35)*(1+'(4)Income & Expense Input'!G35))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D35)*(1+'(4)Income & Expense Input'!E35)*(1+'(4)Income & Expense Input'!F35)*(1+'(4)Income & Expense Input'!G35)*(1+'(4)Income & Expense Input'!H35))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D35)*(1+'(4)Income & Expense Input'!E35)*(1+'(4)Income & Expense Input'!F35)*(1+'(4)Income & Expense Input'!G35)*(1+'(4)Income & Expense Input'!H35)*(1+'(4)Income & Expense Input'!I35))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D35)*(1+'(4)Income & Expense Input'!E35)*(1+'(4)Income & Expense Input'!F35)*(1+'(4)Income & Expense Input'!G35)*(1+'(4)Income & Expense Input'!H35)*(1+'(4)Income & Expense Input'!I35)*(1+'(4)Income & Expense Input'!J35))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D35)*(1+'(4)Income & Expense Input'!E35)*(1+'(4)Income & Expense Input'!F35)*(1+'(4)Income & Expense Input'!G35)*(1+'(4)Income & Expense Input'!H35)*(1+'(4)Income & Expense Input'!I35)*(1+'(4)Income & Expense Input'!J35)*(1+'(4)Income & Expense Input'!K35))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D35)*(1+'(4)Income & Expense Input'!E35)*(1+'(4)Income & Expense Input'!F35)*(1+'(4)Income & Expense Input'!G35)*(1+'(4)Income & Expense Input'!H35)*(1+'(4)Income & Expense Input'!I35)*(1+'(4)Income & Expense Input'!J35)*(1+'(4)Income & Expense Input'!K35)*(1+'(4)Income & Expense Input'!L35))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D35)*(1+'(4)Income & Expense Input'!E35)*(1+'(4)Income & Expense Input'!F35)*(1+'(4)Income & Expense Input'!G35)*(1+'(4)Income & Expense Input'!H35)*(1+'(4)Income & Expense Input'!I35)*(1+'(4)Income & Expense Input'!J35)*(1+'(4)Income & Expense Input'!K35)*(1+'(4)Income & Expense Input'!L35)*(1+'(4)Income & Expense Input'!M35))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D35)*(1+'(4)Income & Expense Input'!E35)*(1+'(4)Income & Expense Input'!F35)*(1+'(4)Income & Expense Input'!G35)*(1+'(4)Income & Expense Input'!H35)*(1+'(4)Income & Expense Input'!I35)*(1+'(4)Income & Expense Input'!J35)*(1+'(4)Income & Expense Input'!K35)*(1+'(4)Income & Expense Input'!L35)*(1+'(4)Income & Expense Input'!M35)*(1+'(4)Income & Expense Input'!N35))*(1-'(4)Income & Expense Input'!$D$10)","v":0}]
[null,22,"Common Area Maintenance",{"$f":"('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D36)*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D36)*(1+'(4)Income & Expense Input'!E36))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D36)*(1+'(4)Income & Expense Input'!E36)*(1+'(4)Income & Expense Input'!F36))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D36)*(1+'(4)Income & Expense Input'!E36)*(1+'(4)Income & Expense Input'!F36)*(1+'(4)Income & Expense Input'!G36))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D36)*(1+'(4)Income & Expense Input'!E36)*(1+'(4)Income & Expense Input'!F36)*(1+'(4)Income & Expense Input'!G36)*(1+'(4)Income & Expense Input'!H36))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D36)*(1+'(4)Income & Expense Input'!E36)*(1+'(4)Income & Expense Input'!F36)*(1+'(4)Income & Expense Input'!G36)*(1+'(4)Income & Expense Input'!H36)*(1+'(4)Income & Expense Input'!I36))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D36)*(1+'(4)Income & Expense Input'!E36)*(1+'(4)Income & Expense Input'!F36)*(1+'(4)Income & Expense Input'!G36)*(1+'(4)Income & Expense Input'!H36)*(1+'(4)Income & Expense Input'!I36)*(1+'(4)Income & Expense Input'!J36))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D36)*(1+'(4)Income & Expense Input'!E36)*(1+'(4)Income & Expense Input'!F36)*(1+'(4)Income & Expense Input'!G36)*(1+'(4)Income & Expense Input'!H36)*(1+'(4)Income & Expense Input'!I36)*(1+'(4)Income & Expense Input'!J36)*(1+'(4)Income & Expense Input'!K36))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D36)*(1+'(4)Income & Expense Input'!E36)*(1+'(4)Income & Expense Input'!F36)*(1+'(4)Income & Expense Input'!G36)*(1+'(4)Income & Expense Input'!H36)*(1+'(4)Income & Expense Input'!I36)*(1+'(4)Income & Expense Input'!J36)*(1+'(4)Income & Expense Input'!K36)*(1+'(4)Income & Expense Input'!L36))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D36)*(1+'(4)Income & Expense Input'!E36)*(1+'(4)Income & Expense Input'!F36)*(1+'(4)Income & Expense Input'!G36)*(1+'(4)Income & Expense Input'!H36)*(1+'(4)Income & Expense Input'!I36)*(1+'(4)Income & Expense Input'!J36)*(1+'(4)Income & Expense Input'!K36)*(1+'(4)Income & Expense Input'!L36)*(1+'(4)Income & Expense Input'!M36))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D36)*(1+'(4)Income & Expense Input'!E36)*(1+'(4)Income & Expense Input'!F36)*(1+'(4)Income & Expense Input'!G36)*(1+'(4)Income & Expense Input'!H36)*(1+'(4)Income & Expense Input'!I36)*(1+'(4)Income & Expense Input'!J36)*(1+'(4)Income & Expense Input'!K36)*(1+'(4)Income & Expense Input'!L36)*(1+'(4)Income & Expense Input'!M36)*(1+'(4)Income & Expense Input'!N36))*(1-'(4)Income & Expense Input'!$D$10)","v":0}]
[null,23,"Reserve for Replacements",{"$f":"('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D37)*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D37)*(1+'(4)Income & Expense Input'!E37))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D37)*(1+'(4)Income & Expense Input'!E37)*(1+'(4)Income & Expense Input'!F37))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D37)*(1+'(4)Income & Expense Input'!E37)*(1+'(4)Income & Expense Input'!F37)*(1+'(4)Income & Expense Input'!G37))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D37)*(1+'(4)Income & Expense Input'!E37)*(1+'(4)Income & Expense Input'!F37)*(1+'(4)Income & Expense Input'!G37)*(1+'(4)Income & Expense Input'!H37))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D37)*(1+'(4)Income & Expense Input'!E37)*(1+'(4)Income & Expense Input'!F37)*(1+'(4)Income & Expense Input'!G37)*(1+'(4)Income & Expense Input'!H37)*(1+'(4)Income & Expense Input'!I37))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D37)*(1+'(4)Income & Expense Input'!E37)*(1+'(4)Income & Expense Input'!F37)*(1+'(4)Income & Expense Input'!G37)*(1+'(4)Income & Expense Input'!H37)*(1+'(4)Income & Expense Input'!I37)*(1+'(4)Income & Expense Input'!J37))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D37)*(1+'(4)Income & Expense Input'!E37)*(1+'(4)Income & Expense Input'!F37)*(1+'(4)Income & Expense Input'!G37)*(1+'(4)Income & Expense Input'!H37)*(1+'(4)Income & Expense Input'!I37)*(1+'(4)Income & Expense Input'!J37)*(1+'(4)Income & Expense Input'!K37))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D37)*(1+'(4)Income & Expense Input'!E37)*(1+'(4)Income & Expense Input'!F37)*(1+'(4)Income & Expense Input'!G37)*(1+'(4)Income & Expense Input'!H37)*(1+'(4)Income & Expense Input'!I37)*(1+'(4)Income & Expense Input'!J37)*(1+'(4)Income & Expense Input'!K37)*(1+'(4)Income & Expense Input'!L37))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D37)*(1+'(4)Income & Expense Input'!E37)*(1+'(4)Income & Expense Input'!F37)*(1+'(4)Income & Expense Input'!G37)*(1+'(4)Income & Expense Input'!H37)*(1+'(4)Income & Expense Input'!I37)*(1+'(4)Income & Expense Input'!J37)*(1+'(4)Income & Expense Input'!K37)*(1+'(4)Income & Expense Input'!L37)*(1+'(4)Income & Expense Input'!M37))*(1-'(4)Income & Expense Input'!$D$10)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$8*'(4)Income & Expense Input'!D37)*(1+'(4)Income & Expense Input'!E37)*(1+'(4)Income & Expense Input'!F37)*(1+'(4)Income & Expense Input'!G37)*(1+'(4)Income & Expense Input'!H37)*(1+'(4)Income & Expense Input'!I37)*(1+'(4)Income & Expense Input'!J37)*(1+'(4)Income & Expense Input'!K37)*(1+'(4)Income & Expense Input'!L37)*(1+'(4)Income & Expense Input'!M37)*(1+'(4)Income & Expense Input'!N37))*(1-'(4)Income & Expense Input'!$D$10)","v":0}]
[null,24,"Property Management",{"$f":"((D6-D10+SUM(D24:D29))/(1-'(4)Income & Expense Input'!D38))-(D6-D10+SUM(D24:D29))","v":0},{"$f":"((E6-E10+SUM(E24:E29))/(1-'(4)Income & Expense Input'!E38))-(E6-E10+SUM(E24:E29))","v":0},{"$f":"((F6-F10+SUM(F24:F29))/(1-'(4)Income & Expense Input'!F38))-(F6-F10+SUM(F24:F29))","v":0},{"$f":"((G6-G10+SUM(G24:G29))/(1-'(4)Income & Expense Input'!G38))-(G6-G10+SUM(G24:G29))","v":0},{"$f":"((H6-H10+SUM(H24:H29))/(1-'(4)Income & Expense Input'!H38))-(H6-H10+SUM(H24:H29))","v":0},{"$f":"((I6-I10+SUM(I24:I29))/(1-'(4)Income & Expense Input'!I38))-(I6-I10+SUM(I24:I29))","v":0},{"$f":"((J6-J10+SUM(J24:J29))/(1-'(4)Income & Expense Input'!J38))-(J6-J10+SUM(J24:J29))","v":0},{"$f":"((K6-K10+SUM(K24:K29))/(1-'(4)Income & Expense Input'!K38))-(K6-K10+SUM(K24:K29))","v":0},{"$f":"((L6-L10+SUM(L24:L29))/(1-'(4)Income & Expense Input'!L38))-(L6-L10+SUM(L24:L29))","v":0},{"$f":"((M6-M10+SUM(M24:M29))/(1-'(4)Income & Expense Input'!M38))-(M6-M10+SUM(M24:M29))","v":0},{"$f":"((N6-N10+SUM(N24:N29))/(1-'(4)Income & Expense Input'!N38))-(N6-N10+SUM(N24:N29))","v":0}]
[null,"Category \"C\" Space Pass-thrus"]
[null,25,"Real Estate Taxes",{"$f":"('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D40)*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D40)*(1+'(4)Income & Expense Input'!E40))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D40)*(1+'(4)Income & Expense Input'!E40)*(1+'(4)Income & Expense Input'!F40))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D40)*(1+'(4)Income & Expense Input'!E40)*(1+'(4)Income & Expense Input'!F40)*(1+'(4)Income & Expense Input'!G40))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D40)*(1+'(4)Income & Expense Input'!E40)*(1+'(4)Income & Expense Input'!F40)*(1+'(4)Income & Expense Input'!G40)*(1+'(4)Income & Expense Input'!H40))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D40)*(1+'(4)Income & Expense Input'!E40)*(1+'(4)Income & Expense Input'!F40)*(1+'(4)Income & Expense Input'!G40)*(1+'(4)Income & Expense Input'!H40)*(1+'(4)Income & Expense Input'!I40))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D40)*(1+'(4)Income & Expense Input'!E40)*(1+'(4)Income & Expense Input'!F40)*(1+'(4)Income & Expense Input'!G40)*(1+'(4)Income & Expense Input'!H40)*(1+'(4)Income & Expense Input'!I40)*(1+'(4)Income & Expense Input'!J40))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D40)*(1+'(4)Income & Expense Input'!E40)*(1+'(4)Income & Expense Input'!F40)*(1+'(4)Income & Expense Input'!G40)*(1+'(4)Income & Expense Input'!H40)*(1+'(4)Income & Expense Input'!I40)*(1+'(4)Income & Expense Input'!J40)*(1+'(4)Income & Expense Input'!K40))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D40)*(1+'(4)Income & Expense Input'!E40)*(1+'(4)Income & Expense Input'!F40)*(1+'(4)Income & Expense Input'!G40)*(1+'(4)Income & Expense Input'!H40)*(1+'(4)Income & Expense Input'!I40)*(1+'(4)Income & Expense Input'!J40)*(1+'(4)Income & Expense Input'!K40)*(1+'(4)Income & Expense Input'!L40))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D40)*(1+'(4)Income & Expense Input'!E40)*(1+'(4)Income & Expense Input'!F40)*(1+'(4)Income & Expense Input'!G40)*(1+'(4)Income & Expense Input'!H40)*(1+'(4)Income & Expense Input'!I40)*(1+'(4)Income & Expense Input'!J40)*(1+'(4)Income & Expense Input'!K40)*(1+'(4)Income & Expense Input'!L40)*(1+'(4)Income & Expense Input'!M40))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D40)*(1+'(4)Income & Expense Input'!E40)*(1+'(4)Income & Expense Input'!F40)*(1+'(4)Income & Expense Input'!G40)*(1+'(4)Income & Expense Input'!H40)*(1+'(4)Income & Expense Input'!I40)*(1+'(4)Income & Expense Input'!J40)*(1+'(4)Income & Expense Input'!K40)*(1+'(4)Income & Expense Input'!L40)*(1+'(4)Income & Expense Input'!M40)*(1+'(4)Income & Expense Input'!N40))*(1-'(4)Income & Expense Input'!$D$13)","v":0}]
[null,26,"Insurance",{"$f":"('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D41)*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D41)*(1+'(4)Income & Expense Input'!E41))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D41)*(1+'(4)Income & Expense Input'!E41)*(1+'(4)Income & Expense Input'!F41))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D41)*(1+'(4)Income & Expense Input'!E41)*(1+'(4)Income & Expense Input'!F41)*(1+'(4)Income & Expense Input'!G41))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D41)*(1+'(4)Income & Expense Input'!E41)*(1+'(4)Income & Expense Input'!F41)*(1+'(4)Income & Expense Input'!G41)*(1+'(4)Income & Expense Input'!H41))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D41)*(1+'(4)Income & Expense Input'!E41)*(1+'(4)Income & Expense Input'!F41)*(1+'(4)Income & Expense Input'!G41)*(1+'(4)Income & Expense Input'!H41)*(1+'(4)Income & Expense Input'!I41))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D41)*(1+'(4)Income & Expense Input'!E41)*(1+'(4)Income & Expense Input'!F41)*(1+'(4)Income & Expense Input'!G41)*(1+'(4)Income & Expense Input'!H41)*(1+'(4)Income & Expense Input'!I41)*(1+'(4)Income & Expense Input'!J41))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D41)*(1+'(4)Income & Expense Input'!E41)*(1+'(4)Income & Expense Input'!F41)*(1+'(4)Income & Expense Input'!G41)*(1+'(4)Income & Expense Input'!H41)*(1+'(4)Income & Expense Input'!I41)*(1+'(4)Income & Expense Input'!J41)*(1+'(4)Income & Expense Input'!K41))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D41)*(1+'(4)Income & Expense Input'!E41)*(1+'(4)Income & Expense Input'!F41)*(1+'(4)Income & Expense Input'!G41)*(1+'(4)Income & Expense Input'!H41)*(1+'(4)Income & Expense Input'!I41)*(1+'(4)Income & Expense Input'!J41)*(1+'(4)Income & Expense Input'!K41)*(1+'(4)Income & Expense Input'!L41))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D41)*(1+'(4)Income & Expense Input'!E41)*(1+'(4)Income & Expense Input'!F41)*(1+'(4)Income & Expense Input'!G41)*(1+'(4)Income & Expense Input'!H41)*(1+'(4)Income & Expense Input'!I41)*(1+'(4)Income & Expense Input'!J41)*(1+'(4)Income & Expense Input'!K41)*(1+'(4)Income & Expense Input'!L41)*(1+'(4)Income & Expense Input'!M41))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D41)*(1+'(4)Income & Expense Input'!E41)*(1+'(4)Income & Expense Input'!F41)*(1+'(4)Income & Expense Input'!G41)*(1+'(4)Income & Expense Input'!H41)*(1+'(4)Income & Expense Input'!I41)*(1+'(4)Income & Expense Input'!J41)*(1+'(4)Income & Expense Input'!K41)*(1+'(4)Income & Expense Input'!L41)*(1+'(4)Income & Expense Input'!M41)*(1+'(4)Income & Expense Input'!N41))*(1-'(4)Income & Expense Input'!$D$13)","v":0}]
[null,27,"Building Maintenance",{"$f":"('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D42)*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D42)*(1+'(4)Income & Expense Input'!E42))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D42)*(1+'(4)Income & Expense Input'!E42)*(1+'(4)Income & Expense Input'!F42))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D42)*(1+'(4)Income & Expense Input'!E42)*(1+'(4)Income & Expense Input'!F42)*(1+'(4)Income & Expense Input'!G42))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D42)*(1+'(4)Income & Expense Input'!E42)*(1+'(4)Income & Expense Input'!F42)*(1+'(4)Income & Expense Input'!G42)*(1+'(4)Income & Expense Input'!H42))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D42)*(1+'(4)Income & Expense Input'!E42)*(1+'(4)Income & Expense Input'!F42)*(1+'(4)Income & Expense Input'!G42)*(1+'(4)Income & Expense Input'!H42)*(1+'(4)Income & Expense Input'!I42))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D42)*(1+'(4)Income & Expense Input'!E42)*(1+'(4)Income & Expense Input'!F42)*(1+'(4)Income & Expense Input'!G42)*(1+'(4)Income & Expense Input'!H42)*(1+'(4)Income & Expense Input'!I42)*(1+'(4)Income & Expense Input'!J42))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D42)*(1+'(4)Income & Expense Input'!E42)*(1+'(4)Income & Expense Input'!F42)*(1+'(4)Income & Expense Input'!G42)*(1+'(4)Income & Expense Input'!H42)*(1+'(4)Income & Expense Input'!I42)*(1+'(4)Income & Expense Input'!J42)*(1+'(4)Income & Expense Input'!K42))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D42)*(1+'(4)Income & Expense Input'!E42)*(1+'(4)Income & Expense Input'!F42)*(1+'(4)Income & Expense Input'!G42)*(1+'(4)Income & Expense Input'!H42)*(1+'(4)Income & Expense Input'!I42)*(1+'(4)Income & Expense Input'!J42)*(1+'(4)Income & Expense Input'!K42)*(1+'(4)Income & Expense Input'!L42))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D42)*(1+'(4)Income & Expense Input'!E42)*(1+'(4)Income & Expense Input'!F42)*(1+'(4)Income & Expense Input'!G42)*(1+'(4)Income & Expense Input'!H42)*(1+'(4)Income & Expense Input'!I42)*(1+'(4)Income & Expense Input'!J42)*(1+'(4)Income & Expense Input'!K42)*(1+'(4)Income & Expense Input'!L42)*(1+'(4)Income & Expense Input'!M42))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D42)*(1+'(4)Income & Expense Input'!E42)*(1+'(4)Income & Expense Input'!F42)*(1+'(4)Income & Expense Input'!G42)*(1+'(4)Income & Expense Input'!H42)*(1+'(4)Income & Expense Input'!I42)*(1+'(4)Income & Expense Input'!J42)*(1+'(4)Income & Expense Input'!K42)*(1+'(4)Income & Expense Input'!L42)*(1+'(4)Income & Expense Input'!M42)*(1+'(4)Income & Expense Input'!N42))*(1-'(4)Income & Expense Input'!$D$13)","v":0}]
[null,28,"Common Area Utilities",{"$f":"('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D43)*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D43)*(1+'(4)Income & Expense Input'!E43))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D43)*(1+'(4)Income & Expense Input'!E43)*(1+'(4)Income & Expense Input'!F43))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D43)*(1+'(4)Income & Expense Input'!E43)*(1+'(4)Income & Expense Input'!F43)*(1+'(4)Income & Expense Input'!G43))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D43)*(1+'(4)Income & Expense Input'!E43)*(1+'(4)Income & Expense Input'!F43)*(1+'(4)Income & Expense Input'!G43)*(1+'(4)Income & Expense Input'!H43))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D43)*(1+'(4)Income & Expense Input'!E43)*(1+'(4)Income & Expense Input'!F43)*(1+'(4)Income & Expense Input'!G43)*(1+'(4)Income & Expense Input'!H43)*(1+'(4)Income & Expense Input'!I43))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D43)*(1+'(4)Income & Expense Input'!E43)*(1+'(4)Income & Expense Input'!F43)*(1+'(4)Income & Expense Input'!G43)*(1+'(4)Income & Expense Input'!H43)*(1+'(4)Income & Expense Input'!I43)*(1+'(4)Income & Expense Input'!J43))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D43)*(1+'(4)Income & Expense Input'!E43)*(1+'(4)Income & Expense Input'!F43)*(1+'(4)Income & Expense Input'!G43)*(1+'(4)Income & Expense Input'!H43)*(1+'(4)Income & Expense Input'!I43)*(1+'(4)Income & Expense Input'!J43)*(1+'(4)Income & Expense Input'!K43))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D43)*(1+'(4)Income & Expense Input'!E43)*(1+'(4)Income & Expense Input'!F43)*(1+'(4)Income & Expense Input'!G43)*(1+'(4)Income & Expense Input'!H43)*(1+'(4)Income & Expense Input'!I43)*(1+'(4)Income & Expense Input'!J43)*(1+'(4)Income & Expense Input'!K43)*(1+'(4)Income & Expense Input'!L43))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D43)*(1+'(4)Income & Expense Input'!E43)*(1+'(4)Income & Expense Input'!F43)*(1+'(4)Income & Expense Input'!G43)*(1+'(4)Income & Expense Input'!H43)*(1+'(4)Income & Expense Input'!I43)*(1+'(4)Income & Expense Input'!J43)*(1+'(4)Income & Expense Input'!K43)*(1+'(4)Income & Expense Input'!L43)*(1+'(4)Income & Expense Input'!M43))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D43)*(1+'(4)Income & Expense Input'!E43)*(1+'(4)Income & Expense Input'!F43)*(1+'(4)Income & Expense Input'!G43)*(1+'(4)Income & Expense Input'!H43)*(1+'(4)Income & Expense Input'!I43)*(1+'(4)Income & Expense Input'!J43)*(1+'(4)Income & Expense Input'!K43)*(1+'(4)Income & Expense Input'!L43)*(1+'(4)Income & Expense Input'!M43)*(1+'(4)Income & Expense Input'!N43))*(1-'(4)Income & Expense Input'!$D$13)","v":0}]
[null,29,"Common Area Maintenance",{"$f":"('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D44)*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D44)*(1+'(4)Income & Expense Input'!E44))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D44)*(1+'(4)Income & Expense Input'!E44)*(1+'(4)Income & Expense Input'!F44))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D44)*(1+'(4)Income & Expense Input'!E44)*(1+'(4)Income & Expense Input'!F44)*(1+'(4)Income & Expense Input'!G44))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D44)*(1+'(4)Income & Expense Input'!E44)*(1+'(4)Income & Expense Input'!F44)*(1+'(4)Income & Expense Input'!G44)*(1+'(4)Income & Expense Input'!H44))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D44)*(1+'(4)Income & Expense Input'!E44)*(1+'(4)Income & Expense Input'!F44)*(1+'(4)Income & Expense Input'!G44)*(1+'(4)Income & Expense Input'!H44)*(1+'(4)Income & Expense Input'!I44))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D44)*(1+'(4)Income & Expense Input'!E44)*(1+'(4)Income & Expense Input'!F44)*(1+'(4)Income & Expense Input'!G44)*(1+'(4)Income & Expense Input'!H44)*(1+'(4)Income & Expense Input'!I44)*(1+'(4)Income & Expense Input'!J44))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D44)*(1+'(4)Income & Expense Input'!E44)*(1+'(4)Income & Expense Input'!F44)*(1+'(4)Income & Expense Input'!G44)*(1+'(4)Income & Expense Input'!H44)*(1+'(4)Income & Expense Input'!I44)*(1+'(4)Income & Expense Input'!J44)*(1+'(4)Income & Expense Input'!K44))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D44)*(1+'(4)Income & Expense Input'!E44)*(1+'(4)Income & Expense Input'!F44)*(1+'(4)Income & Expense Input'!G44)*(1+'(4)Income & Expense Input'!H44)*(1+'(4)Income & Expense Input'!I44)*(1+'(4)Income & Expense Input'!J44)*(1+'(4)Income & Expense Input'!K44)*(1+'(4)Income & Expense Input'!L44))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D44)*(1+'(4)Income & Expense Input'!E44)*(1+'(4)Income & Expense Input'!F44)*(1+'(4)Income & Expense Input'!G44)*(1+'(4)Income & Expense Input'!H44)*(1+'(4)Income & Expense Input'!I44)*(1+'(4)Income & Expense Input'!J44)*(1+'(4)Income & Expense Input'!K44)*(1+'(4)Income & Expense Input'!L44)*(1+'(4)Income & Expense Input'!M44))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D44)*(1+'(4)Income & Expense Input'!E44)*(1+'(4)Income & Expense Input'!F44)*(1+'(4)Income & Expense Input'!G44)*(1+'(4)Income & Expense Input'!H44)*(1+'(4)Income & Expense Input'!I44)*(1+'(4)Income & Expense Input'!J44)*(1+'(4)Income & Expense Input'!K44)*(1+'(4)Income & Expense Input'!L44)*(1+'(4)Income & Expense Input'!M44)*(1+'(4)Income & Expense Input'!N44))*(1-'(4)Income & Expense Input'!$D$13)","v":0}]
[null,30,"Reserve for Replacements",{"$f":"('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D45)*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D45)*(1+'(4)Income & Expense Input'!E45))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D45)*(1+'(4)Income & Expense Input'!E45)*(1+'(4)Income & Expense Input'!F45))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D45)*(1+'(4)Income & Expense Input'!E45)*(1+'(4)Income & Expense Input'!F45)*(1+'(4)Income & Expense Input'!G45))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D45)*(1+'(4)Income & Expense Input'!E45)*(1+'(4)Income & Expense Input'!F45)*(1+'(4)Income & Expense Input'!G45)*(1+'(4)Income & Expense Input'!H45))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D45)*(1+'(4)Income & Expense Input'!E45)*(1+'(4)Income & Expense Input'!F45)*(1+'(4)Income & Expense Input'!G45)*(1+'(4)Income & Expense Input'!H45)*(1+'(4)Income & Expense Input'!I45))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D45)*(1+'(4)Income & Expense Input'!E45)*(1+'(4)Income & Expense Input'!F45)*(1+'(4)Income & Expense Input'!G45)*(1+'(4)Income & Expense Input'!H45)*(1+'(4)Income & Expense Input'!I45)*(1+'(4)Income & Expense Input'!J45))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D45)*(1+'(4)Income & Expense Input'!E45)*(1+'(4)Income & Expense Input'!F45)*(1+'(4)Income & Expense Input'!G45)*(1+'(4)Income & Expense Input'!H45)*(1+'(4)Income & Expense Input'!I45)*(1+'(4)Income & Expense Input'!J45)*(1+'(4)Income & Expense Input'!K45))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D45)*(1+'(4)Income & Expense Input'!E45)*(1+'(4)Income & Expense Input'!F45)*(1+'(4)Income & Expense Input'!G45)*(1+'(4)Income & Expense Input'!H45)*(1+'(4)Income & Expense Input'!I45)*(1+'(4)Income & Expense Input'!J45)*(1+'(4)Income & Expense Input'!K45)*(1+'(4)Income & Expense Input'!L45))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D45)*(1+'(4)Income & Expense Input'!E45)*(1+'(4)Income & Expense Input'!F45)*(1+'(4)Income & Expense Input'!G45)*(1+'(4)Income & Expense Input'!H45)*(1+'(4)Income & Expense Input'!I45)*(1+'(4)Income & Expense Input'!J45)*(1+'(4)Income & Expense Input'!K45)*(1+'(4)Income & Expense Input'!L45)*(1+'(4)Income & Expense Input'!M45))*(1-'(4)Income & Expense Input'!$D$13)","v":0},{"$f":"(('(4)Income & Expense Input'!$D$11*'(4)Income & Expense Input'!D45)*(1+'(4)Income & Expense Input'!E45)*(1+'(4)Income & Expense Input'!F45)*(1+'(4)Income & Expense Input'!G45)*(1+'(4)Income & Expense Input'!H45)*(1+'(4)Income & Expense Input'!I45)*(1+'(4)Income & Expense Input'!J45)*(1+'(4)Income & Expense Input'!K45)*(1+'(4)Income & Expense Input'!L45)*(1+'(4)Income & Expense Input'!M45)*(1+'(4)Income & Expense Input'!N45))*(1-'(4)Income & Expense Input'!$D$13)","v":0}]
[null,31,"Property Management",{"$f":"((D7-D11+SUM(D32:D37))/(1-'(4)Income & Expense Input'!D46))-(D7-D11+SUM(D32:D37))","v":0},{"$f":"((E7-E11+SUM(E32:E37))/(1-'(4)Income & Expense Input'!E46))-(E7-E11+SUM(E32:E37))","v":0},{"$f":"((F7-F11+SUM(F32:F37))/(1-'(4)Income & Expense Input'!F46))-(F7-F11+SUM(F32:F37))","v":0},{"$f":"((G7-G11+SUM(G32:G37))/(1-'(4)Income & Expense Input'!G46))-(G7-G11+SUM(G32:G37))","v":0},{"$f":"((H7-H11+SUM(H32:H37))/(1-'(4)Income & Expense Input'!H46))-(H7-H11+SUM(H32:H37))","v":0},{"$f":"((I7-I11+SUM(I32:I37))/(1-'(4)Income & Expense Input'!I46))-(I7-I11+SUM(I32:I37))","v":0},{"$f":"((J7-J11+SUM(J32:J37))/(1-'(4)Income & Expense Input'!J46))-(J7-J11+SUM(J32:J37))","v":0},{"$f":"((K7-K11+SUM(K32:K37))/(1-'(4)Income & Expense Input'!K46))-(K7-K11+SUM(K32:K37))","v":0},{"$f":"((L7-L11+SUM(L32:L37))/(1-'(4)Income & Expense Input'!L46))-(L7-L11+SUM(L32:L37))","v":0},{"$f":"((M7-M11+SUM(M32:M37))/(1-'(4)Income & Expense Input'!M46))-(M7-M11+SUM(M32:M37))","v":0},{"$f":"((N7-N11+SUM(N32:N37))/(1-'(4)Income & Expense Input'!N46))-(N7-N11+SUM(N32:N37))","v":0}]
[null,32,"Gross Operating Income",{"$f":"D12+SUM(D16:D22)+SUM(D24:D30)+SUM(D32:D38)","v":3028650},{"$f":"E12+SUM(E16:E22)+SUM(E24:E30)+SUM(E32:E38)","v":3104366.2499999995},3181975.4062499991,3261524.7914062487,3343062.9111914043,3426639.4839711892,3512305.4710704684,3600113.10784723,3690115.9355434105,3782368.8339319951,3876928.0547802947]
[null,"Operating Expenses"]
[null,33,"Real Estate Taxes",{"$f":"('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11)*'(4)Income & Expense Input'!D15","v":0},{"$f":"D41*(1+'(4)Income & Expense Input'!E15)","v":0},{"$f":"E41*(1+'(4)Income & Expense Input'!F15)","v":0},{"$f":"F41*(1+'(4)Income & Expense Input'!G15)","v":0},{"$f":"G41*(1+'(4)Income & Expense Input'!H15)","v":0},{"$f":"H41*(1+'(4)Income & Expense Input'!I15)","v":0},{"$f":"I41*(1+'(4)Income & Expense Input'!J15)","v":0},{"$f":"J41*(1+'(4)Income & Expense Input'!K15)","v":0},{"$f":"K41*(1+'(4)Income & Expense Input'!L15)","v":0},{"$f":"L41*(1+'(4)Income & Expense Input'!M15)","v":0},{"$f":"M41*(1+'(4)Income & Expense Input'!N15)","v":0}]
[null,34,"Insurance",{"$f":"('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11)*'(4)Income & Expense Input'!D16","v":0},{"$f":"D42*(1+'(4)Income & Expense Input'!E16)","v":0},{"$f":"E42*(1+'(4)Income & Expense Input'!F16)","v":0},{"$f":"F42*(1+'(4)Income & Expense Input'!G16)","v":0},{"$f":"G42*(1+'(4)Income & Expense Input'!H16)","v":0},{"$f":"H42*(1+'(4)Income & Expense Input'!I16)","v":0},{"$f":"I42*(1+'(4)Income & Expense Input'!J16)","v":0},{"$f":"J42*(1+'(4)Income & Expense Input'!K16)","v":0},{"$f":"K42*(1+'(4)Income & Expense Input'!L16)","v":0},{"$f":"L42*(1+'(4)Income & Expense Input'!M16)","v":0},{"$f":"M42*(1+'(4)Income & Expense Input'!N16)","v":0}]
[null,35,"Building Maintenance",{"$f":"('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11)*'(4)Income & Expense Input'!D17","v":0},{"$f":"D43*(1+'(4)Income & Expense Input'!E17)","v":0},{"$f":"E43*(1+'(4)Income & Expense Input'!F17)","v":0},{"$f":"F43*(1+'(4)Income & Expense Input'!G17)","v":0},{"$f":"G43*(1+'(4)Income & Expense Input'!H17)","v":0},{"$f":"H43*(1+'(4)Income & Expense Input'!I17)","v":0},{"$f":"I43*(1+'(4)Income & Expense Input'!J17)","v":0},{"$f":"J43*(1+'(4)Income & Expense Input'!K17)","v":0},{"$f":"K43*(1+'(4)Income & Expense Input'!L17)","v":0},{"$f":"L43*(1+'(4)Income & Expense Input'!M17)","v":0},{"$f":"M43*(1+'(4)Income & Expense Input'!N17)","v":0}]
[null,36,"Common Area Utilities",{"$f":"('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11)*'(4)Income & Expense Input'!D18","v":0},{"$f":"D44*(1+'(4)Income & Expense Input'!E18)","v":0},{"$f":"E44*(1+'(4)Income & Expense Input'!F18)","v":0},{"$f":"F44*(1+'(4)Income & Expense Input'!G18)","v":0},{"$f":"G44*(1+'(4)Income & Expense Input'!H18)","v":0},{"$f":"H44*(1+'(4)Income & Expense Input'!I18)","v":0},{"$f":"I44*(1+'(4)Income & Expense Input'!J18)","v":0},{"$f":"J44*(1+'(4)Income & Expense Input'!K18)","v":0},{"$f":"K44*(1+'(4)Income & Expense Input'!L18)","v":0},{"$f":"L44*(1+'(4)Income & Expense Input'!M18)","v":0},{"$f":"M44*(1+'(4)Income & Expense Input'!N18)","v":0}]
[null,37,"Common Area Maintenance",{"$f":"('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11)*'(4)Income & Expense Input'!D19","v":0},{"$f":"D45*(1+'(4)Income & Expense Input'!E19)","v":0},{"$f":"E45*(1+'(4)Income & Expense Input'!F19)","v":0},{"$f":"F45*(1+'(4)Income & Expense Input'!G19)","v":0},{"$f":"G45*(1+'(4)Income & Expense Input'!H19)","v":0},{"$f":"H45*(1+'(4)Income & Expense Input'!I19)","v":0},{"$f":"I45*(1+'(4)Income & Expense Input'!J19)","v":0},{"$f":"J45*(1+'(4)Income & Expense Input'!K19)","v":0},{"$f":"K45*(1+'(4)Income & Expense Input'!L19)","v":0},{"$f":"L45*(1+'(4)Income & Expense Input'!M19)","v":0},{"$f":"M45*(1+'(4)Income & Expense Input'!N19)","v":0}]
[null,38,"Reserve for Replacements",{"$f":"('(4)Income & Expense Input'!$D$5+'(4)Income & Expense Input'!$D$8+'(4)Income & Expense Input'!$D$11)*'(4)Income & Expense Input'!D20","v":0},{"$f":"D46*(1+'(4)Income & Expense Input'!E20)","v":0},{"$f":"E46*(1+'(4)Income & Expense Input'!F20)","v":0},{"$f":"F46*(1+'(4)Income & Expense Input'!G20)","v":0},{"$f":"G46*(1+'(4)Income & Expense Input'!H20)","v":0},{"$f":"H46*(1+'(4)Income & Expense Input'!I20)","v":0},{"$f":"I46*(1+'(4)Income & Expense Input'!J20)","v":0},{"$f":"J46*(1+'(4)Income & Expense Input'!K20)","v":0},{"$f":"K46*(1+'(4)Income & Expense Input'!L20)","v":0},{"$f":"L46*(1+'(4)Income & Expense Input'!M20)","v":0},{"$f":"M46*(1+'(4)Income & Expense Input'!N20)","v":0}]
[null,39,"Property Management",{"$f":"'(4)Income & Expense Input'!D21*'(9)Annual Cash Flow Projection'!D39","v":0},{"$f":"'(4)Income & Expense Input'!E21*'(9)Annual Cash Flow Projection'!E39","v":0},{"$f":"'(4)Income & Expense Input'!F21*'(9)Annual Cash Flow Projection'!F39","v":0},{"$f":"'(4)Income & Expense Input'!G21*'(9)Annual Cash Flow Projection'!G39","v":0},{"$f":"'(4)Income & Expense Input'!H21*'(9)Annual Cash Flow Projection'!H39","v":0},{"$f":"'(4)Income & Expense Input'!I21*'(9)Annual Cash Flow Projection'!I39","v":0},{"$f":"'(4)Income & Expense Input'!J21*'(9)Annual Cash Flow Projection'!J39","v":0},{"$f":"'(4)Income & Expense Input'!K21*'(9)Annual Cash Flow Projection'!K39","v":0},{"$f":"'(4)Income & Expense Input'!L21*'(9)Annual Cash Flow Projection'!L39","v":0},{"$f":"'(4)Income & Expense Input'!M21*'(9)Annual Cash Flow Projection'!M39","v":0},{"$f":"'(4)Income & Expense Input'!N21*'(9)Annual Cash Flow Projection'!N39","v":0}]
[null,40,"Net Operating Income",{"$f":"D39-SUM(D41:D47)","v":3028650},{"$f":"E39-SUM(E41:E47)","v":3104366.2499999995},3181975.4062499991,3261524.7914062487,3343062.9111914043,3426639.4839711892,3512305.4710704684,3600113.10784723,3690115.9355434105,3782368.8339319951,3876928.0547802947]
[null,41,"Less:  Annual Debt Service",{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$20=0,0,(PMT('(2)Dev.-Inv. & Lender Input'!$D$18/'(2)Dev.-Inv. & Lender Input'!$D$20,'(2)Dev.-Inv. & Lender Input'!$D$19*'(2)Dev.-Inv. & Lender Input'!$D$20,-'(5)Project Summary'!$D$31,0,0))*'(2)Dev.-Inv. & Lender Input'!$D$20)","v":1950981.5609454773},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$20=0,0,(PMT('(2)Dev.-Inv. & Lender Input'!$D$18/'(2)Dev.-Inv. & Lender Input'!$D$20,'(2)Dev.-Inv. & Lender Input'!$D$19*'(2)Dev.-Inv. & Lender Input'!$D$20,-'(5)Project Summary'!$D$31,0,0))*'(2)Dev.-Inv. & Lender Input'!$D$20)","v":1950981.5609454773},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$20=0,0,(PMT('(2)Dev.-Inv. & Lender Input'!$D$18/'(2)Dev.-Inv. & Lender Input'!$D$20,'(2)Dev.-Inv. & Lender Input'!$D$19*'(2)Dev.-Inv. & Lender Input'!$D$20,-'(5)Project Summary'!$D$31,0,0))*'(2)Dev.-Inv. & Lender Input'!$D$20)","v":1950981.5609454773},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$20=0,0,(PMT('(2)Dev.-Inv. & Lender Input'!$D$18/'(2)Dev.-Inv. & Lender Input'!$D$20,'(2)Dev.-Inv. & Lender Input'!$D$19*'(2)Dev.-Inv. & Lender Input'!$D$20,-'(5)Project Summary'!$D$31,0,0))*'(2)Dev.-Inv. & Lender Input'!$D$20)","v":1950981.5609454773},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$20=0,0,(PMT('(2)Dev.-Inv. & Lender Input'!$D$18/'(2)Dev.-Inv. & Lender Input'!$D$20,'(2)Dev.-Inv. & Lender Input'!$D$19*'(2)Dev.-Inv. & Lender Input'!$D$20,-'(5)Project Summary'!$D$31,0,0))*'(2)Dev.-Inv. & Lender Input'!$D$20)","v":1950981.5609454773},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$20=0,0,(PMT('(2)Dev.-Inv. & Lender Input'!$D$18/'(2)Dev.-Inv. & Lender Input'!$D$20,'(2)Dev.-Inv. & Lender Input'!$D$19*'(2)Dev.-Inv. & Lender Input'!$D$20,-'(5)Project Summary'!$D$31,0,0))*'(2)Dev.-Inv. & Lender Input'!$D$20)","v":1950981.5609454773},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$20=0,0,(PMT('(2)Dev.-Inv. & Lender Input'!$D$18/'(2)Dev.-Inv. & Lender Input'!$D$20,'(2)Dev.-Inv. & Lender Input'!$D$19*'(2)Dev.-Inv. & Lender Input'!$D$20,-'(5)Project Summary'!$D$31,0,0))*'(2)Dev.-Inv. & Lender Input'!$D$20)","v":1950981.5609454773},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$20=0,0,(PMT('(2)Dev.-Inv. & Lender Input'!$D$18/'(2)Dev.-Inv. & Lender Input'!$D$20,'(2)Dev.-Inv. & Lender Input'!$D$19*'(2)Dev.-Inv. & Lender Input'!$D$20,-'(5)Project Summary'!$D$31,0,0))*'(2)Dev.-Inv. & Lender Input'!$D$20)","v":1950981.5609454773},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$20=0,0,(PMT('(2)Dev.-Inv. & Lender Input'!$D$18/'(2)Dev.-Inv. & Lender Input'!$D$20,'(2)Dev.-Inv. & Lender Input'!$D$19*'(2)Dev.-Inv. & Lender Input'!$D$20,-'(5)Project Summary'!$D$31,0,0))*'(2)Dev.-Inv. & Lender Input'!$D$20)","v":1950981.5609454773},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$20=0,0,(PMT('(2)Dev.-Inv. & Lender Input'!$D$18/'(2)Dev.-Inv. & Lender Input'!$D$20,'(2)Dev.-Inv. & Lender Input'!$D$19*'(2)Dev.-Inv. & Lender Input'!$D$20,-'(5)Project Summary'!$D$31,0,0))*'(2)Dev.-Inv. & Lender Input'!$D$20)","v":1950981.5609454773}]
[null,42,"Cash Flow Before Taxes",{"$f":"D48-D49","v":1077668.4390545227},{"$f":"E48-E49","v":1153384.6890545222},1230993.8453045217,1310543.2304607714,1392081.350245927,1475657.9230257119,1561323.9101249911,1649131.5469017527,1739134.3745979331,1831387.2729865178]

{"sheet":"(10)Sale Proceeds-Ratios","index":10,"n_rows":63,"n_cols":15,"rows_kept":63,"cut":false,"hidden":false,"merged":[[1,0,1,9],[17,1,17,4],[21,1,21,6],[22,1,22,2],[2,1,2,2],[7,1,7,2],[13,1,13,2]]}
[]
["Sale Proceeds and Measures of Investment Performance"]
[null,"Sale Proceeds"]
[null,1,"Sale Price",{"$f":"'(5)Project Summary'!D19","v":46595000}]
[null,2,"Less:  Cost of Sale",{"$f":"D4*'(2)Dev.-Inv. & Lender Input'!D25","v":931900}]
[null,3,"Less:  Construction Loan",{"$f":"'(5)Project Summary'!D25","v":19412000}]
[null,4,"Sale Proceeds Before Tax",{"$f":"D4-D5-D6","v":26251100}]
[null,"Loan Proceeds"]
[null,5,"New Loan",{"$f":"'(5)Project Summary'!D31","v":30286000}]
[null,6,"Less:  Old Loan",{"$f":"'(5)Project Summary'!D25","v":19412000}]
[null,7,"Gross Loan Proceeds",{"$f":"D9-D10","v":10874000}]
[null,8,"Less:  Loan Costs",{"$f":"'(5)Project Summary'!D32","v":302860}]
[null,9,"Net loan Proceeds",{"$f":"D11-D12","v":10571140}]
[null,"Investment Base"]
[null,10,"Sale Proceeds Before Tax",{"$f":"D7","v":26251100}]
[null,11,"Less:  Net Loan Proceeds",{"$f":"D13","v":10571140}]
[null,12,"Investment Base",{"$f":"D15-D16","v":15679960}]
[null,"Financial Feasibility Measures"]
[null,13,"Pro Forma Profit",{"$f":"D4-D5-'(5)Project Summary'!D18","v":21397450}]
[null,14,"Net Profit Mark-up on Cost",{"$f":"IF('(7)Cost Mark-up Feasibility '!J97<=0,0,('(7)Cost Mark-up Feasibility '!J88-'(7)Cost Mark-up Feasibility '!J89-'(7)Cost Mark-up Feasibility '!J97)/'(7)Cost Mark-up Feasibility '!J97)","v":0.88178445979906084}]
[null,15,"Net Rent Constant Spread",{"$f":"IF('(2)Dev.-Inv. & Lender Input'!D25<=0,0,('(9)Annual Cash Flow Projection'!D48/' (6)Development Budget'!G61)-('(2)Dev.-Inv. & Lender Input'!D24/(1-'(2)Dev.-Inv. & Lender Input'!D25)))","v":5.8485703966264221E-2}]
[null,"Performance Based on Hold and Refinance"]
[null,"End of Year",null,1,2,3,4,5,6,7,8,9,10]
[null,16,"Cash on Cash (Investment Base)",{"$f":"IF($D$17<=0,0,'(9)Annual Cash Flow Projection'!D50/('(10)Sale Proceeds-Ratios'!$D$17))","v":6.8729029860696247E-2},{"$f":"IF($D$17<=0,0,'(9)Annual Cash Flow Projection'!E50/('(10)Sale Proceeds-Ratios'!$D$17))","v":7.3557884653693131E-2},{"$f":"IF($D$17<=0,0,'(9)Annual Cash Flow Projection'!F50/('(10)Sale Proceeds-Ratios'!$D$17))","v":7.8507460816514954E-2},{"$f":"IF($D$17<=0,0,'(9)Annual Cash Flow Projection'!G50/('(10)Sale Proceeds-Ratios'!$D$17))","v":8.3580776383407315E-2},{"$f":"IF($D$17<=0,0,'(9)Annual Cash Flow Projection'!H50/('(10)Sale Proceeds-Ratios'!$D$17))","v":8.8780924839471975E-2},{"$f":"IF($D$17<=0,0,'(9)Annual Cash Flow Projection'!I50/('(10)Sale Proceeds-Ratios'!$D$17))","v":9.4111077006938271E-2},{"$f":"IF($D$17<=0,0,'(9)Annual Cash Flow Projection'!J50/('(10)Sale Proceeds-Ratios'!$D$17))","v":9.9574482978591214E-2},{"$f":"IF($D$17<=0,0,'(9)Annual Cash Flow Projection'!K50/('(10)Sale Proceeds-Ratios'!$D$17))","v":0.10517447409953551},{"$f":"IF($D$17<=0,0,'(9)Annual Cash Flow Projection'!L50/('(10)Sale Proceeds-Ratios'!$D$17))","v":0.11091446499850338},{"$f":"IF($D$17<=0,0,'(9)Annual Cash Flow Projection'!M50/('(10)Sale Proceeds-Ratios'!$D$17))","v":0.11679795566994544}]
[null,17,"Return on Asset",{"$f":"IF('(5)Project Summary'!$D$19=0,0,'(9)Annual Cash Flow Projection'!D48/'(5)Project Summary'!$D$19)","v":6.4999463461744816E-2},{"$f":"IF('(5)Project Summary'!$D$19=0,0,'(9)Annual Cash Flow Projection'!E48/'(5)Project Summary'!$D$19)","v":6.6624450048288431E-2},{"$f":"IF('(5)Project Summary'!$D$19=0,0,'(9)Annual Cash Flow Projection'!F48/'(5)Project Summary'!$D$19)","v":6.8290061299495636E-2},{"$f":"IF('(5)Project Summary'!$D$19=0,0,'(9)Annual Cash Flow Projection'!G48/'(5)Project Summary'!$D$19)","v":6.9997312831983016E-2},{"$f":"IF('(5)Project Summary'!$D$19=0,0,'(9)Annual Cash Flow Projection'!H48/'(5)Project Summary'!$D$19)","v":7.1747245652782579E-2},{"$f":"IF('(5)Project Summary'!$D$19=0,0,'(9)Annual Cash Flow Projection'!I48/'(5)Project Summary'!$D$19)","v":7.3540926794102138E-2},{"$f":"IF('(5)Project Summary'!$D$19=0,0,'(9)Annual Cash Flow Projection'!J48/'(5)Project Summary'!$D$19)","v":7.5379449963954681E-2},{"$f":"IF('(5)Project Summary'!$D$19=0,0,'(9)Annual Cash Flow Projection'!K48/'(5)Project Summary'!$D$19)","v":7.7263936213053552E-2},{"$f":"IF('(5)Project Summary'!$D$19=0,0,'(9)Annual Cash Flow Projection'!L48/'(5)Project Summary'!$D$19)","v":7.9195534618379873E-2},{"$f":"IF('(5)Project Summary'!$D$19=0,0,'(9)Annual Cash Flow Projection'!M48/'(5)Project Summary'!$D$19)","v":8.1175422983839368E-2}]
[null,18,"Debt Service Coverage Ratio",{"$f":"IF('(9)Annual Cash Flow Projection'!D49=0,0,'(9)Annual Cash Flow Projection'!D48/'(9)Annual Cash Flow Projection'!D49)","v":1.5523724368426461},{"$f":"IF('(9)Annual Cash Flow Projection'!E49=0,0,'(9)Annual Cash Flow Projection'!E48/'(9)Annual Cash Flow Projection'!E49)","v":1.591181747763712},{"$f":"IF('(9)Annual Cash Flow Projection'!F49=0,0,'(9)Annual Cash Flow Projection'!F48/'(9)Annual Cash Flow Projection'!F49)","v":1.6309612914578044},{"$f":"IF('(9)Annual Cash Flow Projection'!G49=0,0,'(9)Annual Cash Flow Projection'!G48/'(9)Annual Cash Flow Projection'!G49)","v":1.6717353237442494},{"$f":"IF('(9)Annual Cash Flow Projection'!H49=0,0,'(9)Annual Cash Flow Projection'!H48/'(9)Annual Cash Flow Projection'!H49)","v":1.7135287068378553},{"$f":"IF('(9)Annual Cash Flow Projection'!I49=0,0,'(9)Annual Cash Flow Projection'!I48/'(9)Annual Cash Flow Projection'!I49)","v":1.7563669245088016},{"$f":"IF('(9)Annual Cash Flow Projection'!J49=0,0,'(9)Annual Cash Flow Projection'!J48/'(9)Annual Cash Flow Projection'!J49)","v":1.8002760976215215},{"$f":"IF('(9)Annual Cash Flow Projection'!K49=0,0,'(9)Annual Cash Flow Projection'!K48/'(9)Annual Cash Flow Projection'!K49)","v":1.8452830000620595},{"$f":"IF('(9)Annual Cash Flow Projection'!L49=0,0,'(9)Annual Cash Flow Projection'!L48/'(9)Annual Cash Flow Projection'!L49)","v":1.8914150750636107},{"$f":"IF('(9)Annual Cash Flow Projection'!M49=0,0,'(9)Annual Cash Flow Projection'!M48/'(9)Annual Cash Flow Projection'!M49)","v":1.9387004519402007}]
[null,19,"Loan to Value",{"$f":"IF(D44=0,0,D46/D44)","v":0.57672492416632393},0.55379633578363896,0.53120478815723304,0.5089339429132036,0.48696835634593616,0.46530130400187542,0.4439023246499938,0.42277336414762795,0.40189994140645879,0.38126220927092991]
[null,20,"Internal Rate of Return (Investment Base)",{"$f":"D63","v":0.39941157934159843},{"$f":"E63","v":0.26572609539386161},0.22249743572080138,0.20043809702778237,0.18670818778067888,0.17714449489831408,0.16999957840325086,0.16438736260908415,0.15982229426784222,0.15601321170170634]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sale Price (Rounded)",{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$26=0,0,ROUND('(9)Annual Cash Flow Projection'!E48/'(2)Dev.-Inv. & Lender Input'!$D$26,-3))","v":51739000},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$26=0,0,ROUND('(9)Annual Cash Flow Projection'!F48/'(2)Dev.-Inv. & Lender Input'!$D$26,-3))","v":53033000},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$26=0,0,ROUND('(9)Annual Cash Flow Projection'!G48/'(2)Dev.-Inv. & Lender Input'!$D$26,-3))","v":54359000},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$26=0,0,ROUND('(9)Annual Cash Flow Projection'!H48/'(2)Dev.-Inv. & Lender Input'!$D$26,-3))","v":55718000},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$26=0,0,ROUND('(9)Annual Cash Flow Projection'!I48/'(2)Dev.-Inv. & Lender Input'!$D$26,-3))","v":57111000},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$26=0,0,ROUND('(9)Annual Cash Flow Projection'!J48/'(2)Dev.-Inv. & Lender Input'!$D$26,-3))","v":58538000},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$26=0,0,ROUND('(9)Annual Cash Flow Projection'!K48/'(2)Dev.-Inv. & Lender Input'!$D$26,-3))","v":60002000},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$26=0,0,ROUND('(9)Annual Cash Flow Projection'!L48/'(2)Dev.-Inv. & Lender Input'!$D$26,-3))","v":61502000},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$26=0,0,ROUND('(9)Annual Cash Flow Projection'!M48/'(2)Dev.-Inv. & Lender Input'!$D$26,-3))","v":63039000},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$26=0,0,ROUND('(9)Annual Cash Flow Projection'!N48/'(2)Dev.-Inv. & Lender Input'!$D$26,-3))","v":64615000},null,1]
[null,null,"Less:  Cost of Sale",{"$f":"D44*'(2)Dev.-Inv. & Lender Input'!$D$25","v":1034780},{"$f":"E44*'(2)Dev.-Inv. & Lender Input'!$D$25","v":1060660},{"$f":"F44*'(2)Dev.-Inv. & Lender Input'!$D$25","v":1087180},{"$f":"G44*'(2)Dev.-Inv. & Lender Input'!$D$25","v":1114360},{"$f":"H44*'(2)Dev.-Inv. & Lender Input'!$D$25","v":1142220},{"$f":"I44*'(2)Dev.-Inv. & Lender Input'!$D$25","v":1170760},{"$f":"J44*'(2)Dev.-Inv. & Lender Input'!$D$25","v":1200040},{"$f":"K44*'(2)Dev.-Inv. & Lender Input'!$D$25","v":1230040},{"$f":"L44*'(2)Dev.-Inv. & Lender Input'!$D$25","v":1260780},{"$f":"M44*'(2)Dev.-Inv. & Lender Input'!$D$25","v":1292300},null,2]
[null,null,"Less:  Mortgage",{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$20=0,0,FV('(2)Dev.-Inv. & Lender Input'!$D$18/'(2)Dev.-Inv. & Lender Input'!$D$20,D23*'(2)Dev.-Inv. & Lender Input'!$D$20,'(9)Annual Cash Flow Projection'!D49/'(2)Dev.-Inv. & Lender Input'!$D$20,-'(5)Project Summary'!$D$31,0))","v":29839170.851441432},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$20=0,0,FV('(2)Dev.-Inv. & Lender Input'!$D$18/'(2)Dev.-Inv. & Lender Input'!$D$20,E23*'(2)Dev.-Inv. & Lender Input'!$D$20,'(9)Annual Cash Flow Projection'!E49/'(2)Dev.-Inv. & Lender Input'!$D$20,-'(5)Project Summary'!$D$31,0))","v":29369481.075613726},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$20=0,0,FV('(2)Dev.-Inv. & Lender Input'!$D$18/'(2)Dev.-Inv. & Lender Input'!$D$20,F23*'(2)Dev.-Inv. & Lender Input'!$D$20,'(9)Annual Cash Flow Projection'!F49/'(2)Dev.-Inv. & Lender Input'!$D$20,-'(5)Project Summary'!$D$31,0))","v":28875761.079439029},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$20=0,0,FV('(2)Dev.-Inv. & Lender Input'!$D$18/'(2)Dev.-Inv. & Lender Input'!$D$20,G23*'(2)Dev.-Inv. & Lender Input'!$D$20,'(9)Annual Cash Flow Projection'!G49/'(2)Dev.-Inv. & Lender Input'!$D$20,-'(5)Project Summary'!$D$31,0))","v":28356781.431237876},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$20=0,0,FV('(2)Dev.-Inv. & Lender Input'!$D$18/'(2)Dev.-Inv. & Lender Input'!$D$20,H23*'(2)Dev.-Inv. & Lender Input'!$D$20,'(9)Annual Cash Flow Projection'!H49/'(2)Dev.-Inv. & Lender Input'!$D$20,-'(5)Project Summary'!$D$31,0))","v":27811249.799272761},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$20=0,0,FV('(2)Dev.-Inv. & Lender Input'!$D$18/'(2)Dev.-Inv. & Lender Input'!$D$20,I23*'(2)Dev.-Inv. & Lender Input'!$D$20,'(9)Annual Cash Flow Projection'!I49/'(2)Dev.-Inv. & Lender Input'!$D$20,-'(5)Project Summary'!$D$31,0))","v":27237807.733661782},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$20=0,0,FV('(2)Dev.-Inv. & Lender Input'!$D$18/'(2)Dev.-Inv. & Lender Input'!$D$20,J23*'(2)Dev.-Inv. & Lender Input'!$D$20,'(9)Annual Cash Flow Projection'!J49/'(2)Dev.-Inv. & Lender Input'!$D$20,-'(5)Project Summary'!$D$31,0))","v":26635027.283648927},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$20=0,0,FV('(2)Dev.-Inv. & Lender Input'!$D$18/'(2)Dev.-Inv. & Lender Input'!$D$20,K23*'(2)Dev.-Inv. & Lender Input'!$D$20,'(9)Annual Cash Flow Projection'!K49/'(2)Dev.-Inv. & Lender Input'!$D$20,-'(5)Project Summary'!$D$31,0))","v":26001407.441807415},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$20=0,0,FV('(2)Dev.-Inv. & Lender Input'!$D$18/'(2)Dev.-Inv. & Lender Input'!$D$20,L23*'(2)Dev.-Inv. & Lender Input'!$D$20,'(9)Annual Cash Flow Projection'!L49/'(2)Dev.-Inv. & Lender Input'!$D$20,-'(5)Project Summary'!$D$31,0))","v":25335370.406321757},{"$f":"IF('(2)Dev.-Inv. & Lender Input'!$D$20=0,0,FV('(2)Dev.-Inv. & Lender Input'!$D$18/'(2)Dev.-Inv. & Lender Input'!$D$20,M23*'(2)Dev.-Inv. & Lender Input'!$D$20,'(9)Annual Cash Flow Projection'!M49/'(2)Dev.-Inv. & Lender Input'!$D$20,-'(5)Project Summary'!$D$31,0))","v":24635257.652041137},null,3]
[null,null,"Sale Proceeds Before Tax",{"$f":"D44-D45-D46","v":20865049.148558568},{"$f":"E44-E45-E46","v":22602858.924386274},24396058.920560971,26246858.568762124,28157530.200727239,30129432.266338218,32166932.716351073,34270552.558192581,36442849.593678243,38687442.347958863,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,{"$f":"D7-D13","v":15679960},null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,1,2,3,4,5,6,7,8,9,10,null,7]
[null,null,0,{"$f":"-(D7-D13)","v":-15679960},{"$f":"D51","v":-15679960},{"$f":"E51","v":-15679960},-15679960,-15679960,-15679960,-15679960,-15679960,-15679960,-15679960,null,8]
[null,null,1,{"$f":"'(9)Annual Cash Flow Projection'!D50+D47","v":21942717.587613091},{"$f":"'(9)Annual Cash Flow Projection'!$D$50","v":1077668.4390545227},{"$f":"'(9)Annual Cash Flow Projection'!$D$50","v":1077668.4390545227},{"$f":"'(9)Annual Cash Flow Projection'!$D$50","v":1077668.4390545227},{"$f":"'(9)Annual Cash Flow Projection'!$D$50","v":1077668.4390545227},{"$f":"'(9)Annual Cash Flow Projection'!$D$50","v":1077668.4390545227},{"$f":"'(9)Annual Cash Flow Projection'!$D$50","v":1077668.4390545227},{"$f":"'(9)Annual Cash Flow Projection'!$D$50","v":1077668.4390545227},{"$f":"'(9)Annual Cash Flow Projection'!$D$50","v":1077668.4390545227},{"$f":"'(9)Annual Cash Flow Projection'!$D$50","v":1077668.4390545227},null,9]
[null,null,2,0,{"$f":"'(9)Annual Cash Flow Projection'!E50+E47","v":23756243.613440797},{"$f":"'(9)Annual Cash Flow Projection'!$E$50","v":1153384.6890545222},{"$f":"'(9)Annual Cash Flow Projection'!$E$50","v":1153384.6890545222},{"$f":"'(9)Annual Cash Flow Projection'!$E$50","v":1153384.6890545222},{"$f":"'(9)Annual Cash Flow Projection'!$E$50","v":1153384.6890545222},{"$f":"'(9)Annual Cash Flow Projection'!$E$50","v":1153384.6890545222},{"$f":"'(9)Annual Cash Flow Projection'!$E$50","v":1153384.6890545222},{"$f":"'(9)Annual Cash Flow Projection'!$E$50","v":1153384.6890545222},{"$f":"'(9)Annual Cash Flow Projection'!$E$50","v":1153384.6890545222},null,10]
[null,null,3,0,0,{"$f":"'(9)Annual Cash Flow Projection'!F50+F47","v":25627052.765865494},{"$f":"'(9)Annual Cash Flow Projection'!$F$50","v":1230993.8453045217},{"$f":"'(9)Annual Cash Flow Projection'!$F$50","v":1230993.8453045217},{"$f":"'(9)Annual Cash Flow Projection'!$F$50","v":1230993.8453045217},{"$f":"'(9)Annual Cash Flow Projection'!$F$50","v":1230993.8453045217},{"$f":"'(9)Annual Cash Flow Projection'!$F$50","v":1230993.8453045217},{"$f":"'(9)Annual Cash Flow Projection'!$F$50","v":1230993.8453045217},{"$f":"'(9)Annual Cash Flow Projection'!$F$50","v":1230993.8453045217}]
[null,null,4,0,0,0,{"$f":"'(9)Annual Cash Flow Projection'!G50+G47","v":27557401.799222894},{"$f":"'(9)Annual Cash Flow Projection'!$G$50","v":1310543.2304607714},{"$f":"'(9)Annual Cash Flow Projection'!$G$50","v":1310543.2304607714},{"$f":"'(9)Annual Cash Flow Projection'!$G$50","v":1310543.2304607714},{"$f":"'(9)Annual Cash Flow Projection'!$G$50","v":1310543.2304607714},{"$f":"'(9)Annual Cash Flow Projection'!$G$50","v":1310543.2304607714},{"$f":"'(9)Annual Cash Flow Projection'!$G$50","v":1310543.2304607714}]
[null,null,5,0,0,0,0,{"$f":"'(9)Annual Cash Flow Projection'!H50+H47","v":29549611.550973166},{"$f":"'(9)Annual Cash Flow Projection'!$H$50","v":1392081.350245927},{"$f":"'(9)Annual Cash Flow Projection'!$H$50","v":1392081.350245927},{"$f":"'(9)Annual Cash Flow Projection'!$H$50","v":1392081.350245927},{"$f":"'(9)Annual Cash Flow Projection'!$H$50","v":1392081.350245927},{"$f":"'(9)Annual Cash Flow Projection'!$H$50","v":1392081.350245927}]
[null,null,6,0,0,0,0,0,{"$f":"'(9)Annual Cash Flow Projection'!I50+I47","v":31605090.18936393},{"$f":"'(9)Annual Cash Flow Projection'!$I$50","v":1475657.9230257119},{"$f":"'(9)Annual Cash Flow Projection'!$I$50","v":1475657.9230257119},{"$f":"'(9)Annual Cash Flow Projection'!$I$50","v":1475657.9230257119},{"$f":"'(9)Annual Cash Flow Projection'!$I$50","v":1475657.9230257119}]
[null,null,7,0,0,0,0,0,0,{"$f":"'(9)Annual Cash Flow Projection'!J50+J47","v":33728256.626476064},{"$f":"'(9)Annual Cash Flow Projection'!$J$50","v":1561323.9101249911},{"$f":"'(9)Annual Cash Flow Projection'!$J$50","v":1561323.9101249911},{"$f":"'(9)Annual Cash Flow Projection'!$J$50","v":1561323.9101249911}]
[null,null,8,0,0,0,0,0,0,0,{"$f":"'(9)Annual Cash Flow Projection'!K50+K47","v":35919684.105094336},{"$f":"'(9)Annual Cash Flow Projection'!$K$50","v":1649131.5469017527},{"$f":"'(9)Annual Cash Flow Projection'!$K$50","v":1649131.5469017527}]
[null,null,9,0,0,0,0,0,0,0,0,{"$f":"'(9)Annual Cash Flow Projection'!L50+L47","v":38181983.968276173},{"$f":"'(9)Annual Cash Flow Projection'!L50","v":1739134.3745979331}]
[null,null,10,0,0,0,0,0,0,0,0,0,{"$f":"'(9)Annual Cash Flow Projection'!M50+M47","v":40518829.620945379}]
[]
[null,null,null,{"$f":"IF(D44=0,0,IRR(D51:D61))","v":0.39941157934159843},{"$f":"IF(E44=0,0,IRR(E51:E61))","v":0.26572609539386161},0.22249743572080138,0.20043809702778237,0.18670818778067888,0.17714449489831408,0.16999957840325086,0.16438736260908415,0.15982229426784222,0.15601321170170634]

{"sheet":"Data","index":11,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,1,2,3,4,5,6,7,8,9,10]
[null,0,{"$f":"NPV(B5,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":32513857.587613091},{"$f":"NPV(B5,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":35405052.052495316},{"$f":"NPV(B5,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":38429245.893974543},{"$f":"NPV(B5,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":41590588.772636458},{"$f":"NPV(B5,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":44893341.754847504},{"$f":"NPV(B5,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":48340901.743484199},{"$f":"NPV(B5,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":51939726.103622042},{"$f":"NPV(B5,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":55692477.492365301},{"$f":"NPV(B5,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":59603908.902448893},{"$f":"NPV(B5,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":63679888.929716036}]
[null,0.02,{"$f":"NPV(B6,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":32083608.223150089},{"$f":"NPV(B6,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":34461437.406071134},{"$f":"NPV(B6,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":36885219.231115326},{"$f":"NPV(B6,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":39355047.640731961},{"$f":"NPV(B6,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":41871001.004638612},{"$f":"NPV(B6,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":44432273.992692366},{"$f":"NPV(B6,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":47040677.491747692},{"$f":"NPV(B6,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":49694531.320627868},{"$f":"NPV(B6,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":52393920.843766354},{"$f":"NPV(B6,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":55139727.535324454}]
[null,0.04,{"$f":"NPV(B7,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":31669906.911166433},{"$f":"NPV(B7,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":33571342.283707008},{"$f":"NPV(B7,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":35456085.22552377},{"$f":"NPV(B7,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":37324260.231089808},{"$f":"NPV(B7,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":39175962.253101572},{"$f":"NPV(B7,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":41010486.7853944},{"$f":"NPV(B7,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":42829461.832014449},{"$f":"NPV(B7,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":44631398.007144921},{"$f":"NPV(B7,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":46416396.407062314},{"$f":"NPV(B7,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":48185203.130517729}]
[null,0.06,{"$f":"NPV(B8,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":31271816.969446313},{"$f":"NPV(B8,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":32730780.582804013},{"$f":"NPV(B8,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":34131284.275463089},{"$f":"NPV(B8,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":35475926.116236374},{"$f":"NPV(B8,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":36767144.500497296},{"$f":"NPV(B8,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":38006541.390819751},{"$f":"NPV(B8,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":39197697.536718935},{"$f":"NPV(B8,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":40341304.292525157},{"$f":"NPV(B8,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":41439393.290145561},{"$f":"NPV(B8,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":42494429.436041087}]
[null,0.08,{"$f":"NPV(B9,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":30888471.099641748},{"$f":"NPV(B9,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":31936131.021621808},{"$f":"NPV(B9,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":32901403.343809988},{"$f":"NPV(B9,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":33790538.2067765},{"$f":"NPV(B9,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":34609282.717076778},{"$f":"NPV(B9,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":35362308.684729718},{"$f":"NPV(B9,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":36055769.385736793},{"$f":"NPV(B9,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":36692960.763825305},{"$f":"NPV(B9,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":37278145.60510435},{"$f":"NPV(B9,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":37815705.761774406}]
[null,0.1,{"$f":"NPV(B10,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":30519065.079648264},{"$f":"NPV(B10,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":31184097.765620466},{"$f":"NPV(B10,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":31758033.114261031},{"$f":"NPV(B10,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":32250989.187347449},{"$f":"NPV(B10,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":32672015.523933265},{"$f":"NPV(B10,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":33028654.086513929},{"$f":"NPV(B10,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":33329303.74648973},{"$f":"NPV(B10,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":33579378.814342014},{"$f":"NPV(B10,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":33784801.587761939},{"$f":"NPV(B10,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":33951238.724270344}]
[null,0.12,{"$f":"NPV(B11,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":30162852.131797399},{"$f":"NPV(B11,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":30471675.925687067},{"$f":"NPV(B11,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":30693645.14443199},{"$f":"NPV(B11,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":30842239.317556493},{"$f":"NPV(B11,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":30929129.36584812},{"$f":"NPV(B11,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":30963912.816795748},{"$f":"NPV(B11,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":30956355.186932497},{"$f":"NPV(B11,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":30913026.37726118},{"$f":"NPV(B11,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":30840531.178068075},{"$f":"NPV(B11,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":30744852.991614565}]
[null,0.14000000000000001,{"$f":"NPV(B12,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":29819137.883871131},{"$f":"NPV(B12,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":29796121.25112569},{"$f":"NPV(B12,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":29701485.919380657},{"$f":"NPV(B12,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":29551035.14130155},{"$f":"NPV(B12,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":29357930.12339304},{"$f":"NPV(B12,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":29132645.199985474},{"$f":"NPV(B12,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":28885151.341889214},{"$f":"NPV(B12,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":28622014.987548038},{"$f":"NPV(B12,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":28349425.817609984},{"$f":"NPV(B12,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":28072663.566610742}]
[null,0.16,{"$f":"NPV(B13,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":29487275.851390596},{"$f":"NPV(B13,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":29154923.444369834},{"$f":"NPV(B13,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":28775485.232969083},{"$f":"NPV(B13,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":28365670.575770956},{"$f":"NPV(B13,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":27938718.90076796},{"$f":"NPV(B13,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":27504616.766572796},{"$f":"NPV(B13,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":27072277.841338132},{"$f":"NPV(B13,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":26647085.212643571},{"$f":"NPV(B13,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":26233760.730565593},{"$f":"NPV(B13,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":25835959.13620133}]
[null,0.18,{"$f":"NPV(B14,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":29166663.379333127},{"$f":"NPV(B14,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":28545782.610977545},{"$f":"NPV(B14,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":27910176.752473082},{"$f":"NPV(B14,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":27275783.397847921},{"$f":"NPV(B14,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":26654353.285354406},{"$f":"NPV(B14,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":26053959.533045858},{"$f":"NPV(B14,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":25481211.645368129},{"$f":"NPV(B14,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":24939213.025480356},{"$f":"NPV(B14,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":24430298.239740036},{"$f":"NPV(B14,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":23955745.137323141}]
[null,0.2,{"$f":"NPV(B15,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":28856737.989677578},{"$f":"NPV(B15,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":27966588.43076821},{"$f":"NPV(B15,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":27100628.972783238},{"$f":"NPV(B15,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":26272181.391065322},{"$f":"NPV(B15,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":25489878.981591709},{"$f":"NPV(B15,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":24758479.867762312},{"$f":"NPV(B15,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":24081131.380873289},{"$f":"NPV(B15,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":23457701.318741769},{"$f":"NPV(B15,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":22887390.394476496},{"$f":"NPV(B15,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":22368539.19146885}]
[null,0.22,{"$f":"NPV(B16,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":28556974.088207453},{"$f":"NPV(B16,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":27415401.696511231},{"$f":"NPV(B16,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":26342385.055313423},{"$f":"NPV(B16,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":25346693.423137784},{"$f":"NPV(B16,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":24432219.586646944},{"$f":"NPV(B16,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":23599085.398960531},{"$f":"NPV(B16,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":22845948.803662166},{"$f":"NPV(B16,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":22168652.122182935},{"$f":"NPV(B16,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":21562698.209577806},{"$f":"NPV(B16,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":21023116.311575744}]
[null,0.24,{"$f":"NPV(B17,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":28266879.990010556},{"$f":"NPV(B17,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":26890437.917448234},{"$f":"NPV(B17,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":25631410.285165474},{"$f":"NPV(B17,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":24492041.541168012},{"$f":"NPV(B17,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":23469914.560223609},{"$f":"NPV(B17,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":22559308.945678435},{"$f":"NPV(B17,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":21753517.473329823},{"$f":"NPV(B17,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":21043738.833817579},{"$f":"NPV(B17,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":20421388.743194968},{"$f":"NPV(B17,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":19877977.91582926}]
[null,0.26,{"$f":"NPV(B18,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":27985995.228264358},{"$f":"NPV(B18,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":26390052.727796357},{"$f":"NPV(B18,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":24964046.077615984},{"$f":"NPV(B18,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":23701730.837054253},{"$f":"NPV(B18,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":22592897.270280834},{"$f":"NPV(B18,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":21624911.801141612},{"$f":"NPV(B18,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":20784983.987116627},{"$f":"NPV(B18,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":20059215.846300006},{"$f":"NPV(B18,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":19434704.10526352},{"$f":"NPV(B18,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":18899375.049214993}]
[null,0.28000000000000003,{"$f":"NPV(B19,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":27713888.115322728},{"$f":"NPV(B19,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":25912728.876605581},{"$f":"NPV(B19,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":24336969.629136182},{"$f":"NPV(B19,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":22969954.379446089},{"$f":"NPV(B19,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":21792306.466733567},{"$f":"NPV(B19,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":20783552.135380834},{"$f":"NPV(B19,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":19924254.315914363},{"$f":"NPV(B19,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":19195116.763934821},{"$f":"NPV(B19,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":18578821.196164496},{"$f":"NPV(B19,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":18059757.893374074}]
[null,0.3,{"$f":"NPV(B20,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":27450153.528933145},{"$f":"NPV(B20,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":25457064.606042411},{"$f":"NPV(B20,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":23747158.444987945},{"$f":"NPV(B20,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":22291510.954526693},{"$f":"NPV(B20,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":21060325.721188709},{"$f":"NPV(B20,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":20024507.01123324},{"$f":"NPV(B20,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":19157553.403427076},{"$f":"NPV(B20,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":18434603.013752826},{"$f":"NPV(B20,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":17833939.641223229},{"$f":"NPV(B20,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":17336554.62279819}]
[]
[null,null,null,null,null,null,{"$f":"'(10)Sale Proceeds-Ratios'!D7","v":26251100}]
[null,null,null,null,null,null,{"$f":"G22","v":26251100}]
[null,null,null,null,null,null,{"$f":"G23","v":26251100}]
[null,null,null,null,null,null,26251100]
[null,null,null,null,null,null,26251100]
[null,null,null,null,null,null,26251100]
[null,null,null,null,null,null,26251100]
[null,null,null,null,null,null,26251100]
[null,null,null,null,null,null,26251100]
[null,null,null,null,null,null,26251100]
[null,null,null,null,null,null,26251100]
[null,null,null,null,null,null,26251100]
[null,null,null,null,null,null,26251100]
[null,null,null,null,null,null,26251100]
[null,null,null,null,null,null,26251100]
[null,null,null,null,null,null,26251100]