{"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)",8.66,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",6.5000000000000002E-2,{"$f":"D7","v":6.5000000000000002E-2},{"$f":"E7","v":6.5000000000000002E-2},6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-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":62285000}]
[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":37371000}]
[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":73609999.999910653}]
[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":40485250}]
[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":52372947.270270154}]
[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":40485000}]
[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":404850}]
[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":[[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],[1,0,1,7],[2,1,2,4],[2,6,2,9],[18,1,18,4],[18,6,18,9]]}
[]
["Cost Mark-up Feasibility"]
[null,"\"Front Door Approach\"",null,null,null,null,"\"Back Door Approach\""]
[null,1,null,"Total Project Cost",{"$f":"H86","v":24265650},null,1,null,"Potential Rental Income",{"$f":"L80","v":4330000}]
[null,2,"x","Target Mark-up",{"$f":"H87","v":0.15},null,2,"-","Vacancy and Credit Losses",{"$f":"L81","v":281450}]
[null,3,"=","Required Profit",{"$f":"H88","v":3639847.5},null,3,"=","Effective Rental Income",4048550]
[null,4,"+","Total Project Cost",{"$f":"H86","v":24265650},null,4,"+","Collected Pass-thrus",0]
[null,5,"=","Required Net Value",{"$f":"H90","v":27905497.5},null,5,"=","Gross Operating Income",4048550]
[null,6,"+","Cost of Sale",569499.94897959381,null,6,"-","Operating Expenses",0]
[null,7,"=","Required Total Value",28474997.448979594,null,7,"=","Net Operating Income",4048550]
[null,8,"x","Market Capitalization Rate",6.5000000000000002E-2,null,8,"÷","Market Capitalization Rate",6.5000000000000002E-2]
[null,9,"=","Required NOI",1850874.8341836736,null,9,"=","Total Value",62285384.615384616]
[null,10,"+","Operating Expenses",0,null,10,"-","Cost of Sale",1245707.6923076923]
[null,11,"=","Gross Operating Income",1850874.8341836736,null,11,"=","Net Value",61039676.92307692]
[null,12,"-","Collected Pass-Thrus",0,null,12,"-","Profit",7961696.989966549]
[null,13,"=","Effective Rental Income",1850874.8341836736,null,13,"=","Justified Total Cost",53077979.933110371]
[null,14,"+","Vacancy and Credit Losses",128670.44301811629,null,14,"-","All Costs Except Land",21437650]
[null,15,"=","Potential Rental Income",1979545.2772017899,null,15,"=","Justified Land Cost (Including Acquisition Costs)",{"$f":"$L$94","v":31640329.933110371}]
[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":3.9590905544035797},null,16,"Per Acre (Including Acquisition Costs)",null,{"$f":"$L$95","v":1378252.7718862877}]
[null,17,"Category \"A\" Space Rent Per Square Foot",null,{"$f":"H102","v":3.9590905544035802},null,17,"Per Square Foot (Including Acquisition Costs)",null,{"$f":"$L$96","v":31.640329933110369}]
[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":31640329.933110371}]
[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":8.66},null,null,null,null,null,null,{"$f":"'(9)Annual Cash Flow Projection'!D8","v":4330000},null,4330000]
[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":6.5000000000000002E-2},null,{"$f":"IF(C86=0,0,(C86-C94)/C86)","v":0.54283019002268129},null,null,null,null,{"$f":"SUM('(9)Annual Cash Flow Projection'!D9:D11)","v":281450},null,281450]
[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":6.5000000000000002E-2},null,null,null,null,null,null,{"$f":"J80-J81","v":4048550},null,4048550]
[null,{"$f":"C121","v":500000},{"$f":"'(4)Income & Expense Input'!D6","v":8.66},{"$f":"B83*C83","v":4330000},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":4048550},null,4048550]
[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":8.66},{"$f":"D83+D84+D85","v":4330000},null,{"$f":"' (6)Development Budget'!G61","v":24265650},null,24265650,null,{"$f":"J84-J85","v":4048550},null,4048550]
[null,null,null,null,null,{"$f":"'(2)Dev.-Inv. & Lender Input'!D4","v":0.15},null,0.15,null,{"$f":"'(2)Dev.-Inv. & Lender Input'!D24","v":6.5000000000000002E-2},null,6.5000000000000002E-2]
[null,{"$f":"C121","v":500000},{"$f":"C83*(1-E81)","v":3.9590905544035802},{"$f":"B88*C88","v":1979545.2772017901},null,{"$f":"F86*F87","v":3639847.5},null,3639847.5,null,{"$f":"IF(J87=0,0,J86/J87)","v":62285384.615384616},null,62285384.615384616]
[null,{"$f":"C122","v":0},{"$f":"C84*(1-E81)","v":0},{"$f":"B89*C89","v":0},null,{"$f":"F86","v":24265650},null,24265650,null,{"$f":"J88*'(2)Dev.-Inv. & Lender Input'!D25","v":1245707.6923076923},null,1245707.6923076923]
[null,{"$f":"C123","v":0},{"$f":"C85*(1-E81)","v":0},{"$f":"B90*C90","v":0},null,{"$f":"F88+F89","v":27905497.5},null,27905497.5,null,{"$f":"J88-J89","v":61039676.92307692},null,61039676.92307692]
[null,{"$f":"B88+B89+B90","v":500000},{"$f":"D91/B91","v":3.9590905544035802},{"$f":"D88+D89+D90","v":1979545.2772017901},null,{"$f":"F90/(1-'(2)Dev.-Inv. & Lender Input'!D25)-F90","v":569499.94897959381},null,569499.94897959381,null,{"$f":"-(J90/(1+'(2)Dev.-Inv. & Lender Input'!D4)-'(7)Cost Mark-up Feasibility '!J90)","v":7961696.989966549},null,7961696.989966549]
[null,null,null,null,null,{"$f":"F90+F91","v":28474997.448979594},null,28474997.448979594,null,{"$f":"J90-J91","v":53077979.933110371},null,53077979.933110371]
[null,null,null,null,null,{"$f":"'(2)Dev.-Inv. & Lender Input'!D24","v":6.5000000000000002E-2},null,6.5000000000000002E-2,null,{"$f":"' (6)Development Budget'!G61-' (6)Development Budget'!G13","v":21437650},null,21437650]
[null,null,3.9590905544035797,null,null,{"$f":"F92*F93","v":1850874.8341836736},null,1850874.8341836736,null,{"$f":"J92-J93","v":31640329.933110371},null,31640329.933110371]
[null,null,{"$f":"B91*C94","v":1979545.2772017899},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":1378252.7718862877},null,1378252.7718862877]
[null,null,{"$f":"C95*C81","v":128670.44301811635},null,{"$f":"C101","v":0},{"$f":"E95+E96","v":0},null,1850874.8341836736,null,{"$f":"J95/43560","v":31.640329933110369},null,31.640329933110369]
[null,null,{"$f":"C95-C96","v":1850874.8341836736},null,null,{"$f":"F94+F95+F96","v":1850874.8341836736},null,0,null,{"$f":"' (6)Development Budget'!G61","v":24265650},null,24265650]
[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,1850874.8341836736,null,{"$f":"J92-J97","v":28812329.933110371},null,28812329.933110371]
[null,null,{"$f":"D119","v":0},null,null,{"$f":"C98","v":0},{"$f":"F98+F99","v":0},128670.44301811629]
[null,null,{"$f":"C97+C98+C99","v":1850874.8341836736},null,null,{"$f":"F97-F98-F99","v":1850874.8341836736},null,1979545.2772017899]
[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":128670.44301811629},null,3.9590905544035797]
[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":1979545.2772017899},null,3.9590905544035802]
[null,null,{"$f":"C100*'(4)Income & Expense Input'!D21","v":0},null,null,{"$f":"IF(C124=0,0,F102/C124)","v":3.9590905544035797},null,0]
[null,null,{"$f":"C100-C101-C102-C103","v":1850874.8341836736},null,null,{"$f":"C83*(1-E81)","v":3.9590905544035802},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":1979545.2772017901},{"$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":1979545.2772017901},{"$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":[[1,0,1,7],[2,1,2,4],[2,6,2,9],[15,1,15,4],[15,6,15,9],[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]]}
[]
["Rent Constant Feasibility"]
[null,"\"Front Door Approach\"",null,null,null,null,"\"Back Door Approach\""]
[null,1,null,"Market Rent Constant",{"$f":"H89","v":6.5000000000000002E-2},null,1,null,"Potential Rental Income",{"$f":"L80","v":4330000}]
[null,2,"+","Cost of Sale Adjustment",{"$f":"H90","v":1.3265306122449E-3},null,2,"-","Vacancy and Credit Losses",{"$f":"L81","v":281450}]
[null,3,"+","Rent Constant Spread",1.4999999999999999E-2,null,3,"=","Effective Rental Income",4048550]
[null,4,"=","Cost Rent Constant",8.1326530612244902E-2,null,4,"+","Collected Pass-thrus",0]
[null,5,"x","Total Project Cost",24265650,null,5,"=","Gross Operating Income",4048550]
[null,6,"=","Required NOI",1973441.1275510206,null,6,"-","Operating Expenses",0]
[null,7,"+","Operating Expenses",0,null,7,"=","Net Operating Income",4048550]
[null,8,"=","Gross Operating Income",1973441.1275510206,null,8,"÷","Cost Rent Constant",8.1326530612244902E-2]
[null,9,"-","Collected Pass-Thrus",0,null,9,"=","Justified Total Cost",49781417.816813044]
[null,10,"=","Effective Rental Income",1973441.1275510206,null,10,"-","All Costs Except Land",21437650]
[null,11,"+","Vacancy and Credit Losses",137191.09442868037,null,11,"=","Justified Land Cost (including Acquisition Costs)",{"$f":"$L$90","v":28343767.816813044}]
[null,12,"=","Potential Rental Income",2110632.221979701]
[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":4.2212644439594023},null,12,"Per Acre (Including Acquisition Costs)",null,{"$f":"$L$91","v":1234654.5261003762}]
[null,14,"Category \"A\" Space Rent Per Square Foot",null,{"$f":"H102","v":4.2212644439594023},null,13,"Per Square Foot (Including Acquisition Costs)",null,{"$f":"$L$92","v":28.343767816813042}]
[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":28343767.816813044}]
[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":8.66},null,null,null,null,null,null,{"$f":"'(9)Annual Cash Flow Projection'!D8","v":4330000},null,4330000]
[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":6.5000000000000002E-2},null,{"$f":"IF(C86=0,0,(C86-C94)/C86)","v":0.51255606882685889},null,null,null,null,{"$f":"SUM('(9)Annual Cash Flow Projection'!D9:D11)","v":281450},null,281450]
[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":6.5000000000000002E-2},null,null,null,null,null,null,{"$f":"J80-J81","v":4048550},null,4048550]
[null,{"$f":"C121","v":500000},{"$f":"'(4)Income & Expense Input'!D6","v":8.66},{"$f":"B83*C83","v":4330000},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":4048550},null,4048550]
[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":8.66},{"$f":"D83+D84+D85","v":4330000},null,null,null,null,null,{"$f":"J84-J85","v":4048550},null,4048550]
[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,8.1326530612244902E-2]
[null,{"$f":"C121","v":500000},{"$f":"C83*(1-E81)","v":4.2212644439594023},{"$f":"B88*C88","v":2110632.221979701},null,null,null,null,null,{"$f":"IF(J87=0,0,J86/J87)","v":49781417.816813044},null,49781417.816813044]
[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,6.5000000000000002E-2,null,{"$f":"' (6)Development Budget'!G61-' (6)Development Budget'!G13","v":21437650},null,21437650]
[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,1.3265306122449E-3,null,{"$f":"J88-J89","v":28343767.816813044},null,28343767.816813044]
[null,{"$f":"B88+B89+B90","v":500000},{"$f":"IF(B91=0,0,D91/B91)","v":4.2212644439594023},{"$f":"D88+D89+D90","v":2110632.221979701},null,{"$f":"'(2)Dev.-Inv. & Lender Input'!D5","v":1.4999999999999999E-2},null,1.4999999999999999E-2,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":1234654.5261003762},null,1234654.5261003762]
[null,null,null,null,null,{"$f":"F89+F90+F91","v":8.1326530612244902E-2},null,8.1326530612244902E-2,null,{"$f":"J91/43560","v":28.343767816813042},null,28.343767816813042]
[null,null,null,null,null,{"$f":"' (6)Development Budget'!G61","v":24265650},null,24265650,null,{"$f":"' (6)Development Budget'!G61","v":24265650},null,24265650]
[null,null,4.2212644439594023,null,null,{"$f":"F92*F93","v":1973441.1275510206},null,1973441.1275510206,null,{"$f":"J88-J93","v":25515767.816813044},null,25515767.816813044]
[null,null,{"$f":"B91*C94","v":2110632.221979701},null,{"$f":"C102","v":0},{"$f":"C103","v":0},{"$f":"F95+F96","v":0},0]
[null,null,{"$f":"C95*C81","v":137191.09442868058},null,{"$f":"C101","v":0},{"$f":"E95+E96","v":0},null,1973441.1275510206]
[null,null,{"$f":"C95-C96","v":1973441.1275510204},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,1973441.1275510206]
[null,null,{"$f":"D119","v":0},null,null,{"$f":"C98","v":0},{"$f":"F98+F99","v":0},137191.09442868037]
[null,null,{"$f":"C97+C98+C99","v":1973441.1275510204},null,null,{"$f":"F97-F98-F99","v":1973441.1275510206},null,2110632.221979701]
[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":137191.09442868037},null,4.2212644439594023]
[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":2110632.221979701},null,4.2212644439594023]
[null,null,{"$f":"C100*'(4)Income & Expense Input'!D21","v":0},null,null,{"$f":"IF(C124=0,0,F102/C124)","v":4.2212644439594023},null,0]
[null,null,{"$f":"C100-C101-C102-C103","v":1973441.1275510204},null,null,{"$f":"C83*(1-E81)","v":4.2212644439594023},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":2110632.221979701},{"$f":"C111*(1-'(4)Income & Expense Input'!D7)","v":1973441.1275510206}]
[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":2110632.221979701},{"$f":"D111+D112+D113","v":1973441.1275510206}]
[]
[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":4330000},{"$f":"D5*(1+'(4)Income & Expense Input'!E6)","v":4438250},{"$f":"E5*(1+'(4)Income & Expense Input'!F6)","v":4549206.25},{"$f":"F5*(1+'(4)Income & Expense Input'!G6)","v":4662936.40625},{"$f":"G5*(1+'(4)Income & Expense Input'!H6)","v":4779509.81640625},{"$f":"H5*(1+'(4)Income & Expense Input'!I6)","v":4898997.5618164055},{"$f":"I5*(1+'(4)Income & Expense Input'!J6)","v":5021472.5008618152},{"$f":"J5*(1+'(4)Income & Expense Input'!K6)","v":5147009.3133833604},{"$f":"K5*(1+'(4)Income & Expense Input'!L6)","v":5275684.5462179435},{"$f":"L5*(1+'(4)Income & Expense Input'!M6)","v":5407576.6598733915},{"$f":"M5*(1+'(4)Income & Expense Input'!N6)","v":5542766.0763702262}]
[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":4330000},{"$f":"SUM(E5:E7)","v":4438250},4549206.25,4662936.40625,4779509.81640625,4898997.5618164055,5021472.5008618152,5147009.3133833604,5275684.5462179435,5407576.6598733915,5542766.0763702262]
[null,5,"Category \"A\" Space Vacancy",{"$f":"D5*'(4)Income & Expense Input'!D7","v":281450},{"$f":"E5*'(4)Income & Expense Input'!E7","v":288486.25},{"$f":"F5*'(4)Income & Expense Input'!F7","v":295698.40625},{"$f":"G5*'(4)Income & Expense Input'!G7","v":303090.86640624999},{"$f":"H5*'(4)Income & Expense Input'!H7","v":310668.13806640625},{"$f":"I5*'(4)Income & Expense Input'!I7","v":318434.84151806636},{"$f":"J5*'(4)Income & Expense Input'!J7","v":326395.71255601797},{"$f":"K5*'(4)Income & Expense Input'!K7","v":334555.60536991846},{"$f":"L5*'(4)Income & Expense Input'!L7","v":342919.49550416635},{"$f":"M5*'(4)Income & Expense Input'!M7","v":351492.48289177049},{"$f":"N5*'(4)Income & Expense Input'!N7","v":360279.79496406473}]
[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":4048550},{"$f":"E8-SUM(E9:E11)","v":4149763.75},4253507.84375,4359845.5398437502,4468841.6783398436,4580562.7202983387,4695076.7883057976,4812453.7080134423,4932765.0507137775,5056084.1769816214,5182486.2814061614]
[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":8.66},{"$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":8.8765000000000001},{"$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":9.0984125000000002},{"$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":9.3258728125000001},{"$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":9.5590196328125003},{"$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":9.7979951236328109},{"$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":10.042945001723631},{"$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":10.294018626766722},{"$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":10.551369092435888},{"$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":10.815153319746782},{"$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":11.085532152740452}]
[null,10,"Weighted Average Vacancy Rate",{"$f":"IF(D8=0,0,SUM(D9:D11)/D8)","v":6.5000000000000002E-2},{"$f":"IF(E8=0,0,SUM(E9:E11)/E8)","v":6.5000000000000002E-2},{"$f":"IF(F8=0,0,SUM(F9:F11)/F8)","v":6.5000000000000002E-2},6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-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":4048550},{"$f":"E12+SUM(E16:E22)+SUM(E24:E30)+SUM(E32:E38)","v":4149763.75},4253507.84375,4359845.5398437502,4468841.6783398436,4580562.7202983387,4695076.7883057976,4812453.7080134423,4932765.0507137775,5056084.1769816214,5182486.2814061614]
[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":4048550},{"$f":"E39-SUM(E41:E47)","v":4149763.75},4253507.84375,4359845.5398437502,4468841.6783398436,4580562.7202983387,4695076.7883057976,4812453.7080134423,4932765.0507137775,5056084.1769816214,5182486.2814061614]
[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":2607986.8089175741},{"$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":2607986.8089175741},{"$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":2607986.8089175741},{"$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":2607986.8089175741},{"$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":2607986.8089175741},{"$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":2607986.8089175741},{"$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":2607986.8089175741},{"$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":2607986.8089175741},{"$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":2607986.8089175741},{"$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":2607986.8089175741}]
[null,42,"Cash Flow Before Taxes",{"$f":"D48-D49","v":1440563.1910824259},{"$f":"E48-E49","v":1541776.9410824259},1645521.0348324259,1751858.7309261761,1860854.8694222695,1972575.9113807646,2087089.9793882235,2204466.8990958682,2324778.2417962034,2448097.3680640473]

{"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":62285000}]
[null,2,"Less:  Cost of Sale",{"$f":"D4*'(2)Dev.-Inv. & Lender Input'!D25","v":1245700}]
[null,3,"Less:  Construction Loan",{"$f":"'(5)Project Summary'!D25","v":19412000}]
[null,4,"Sale Proceeds Before Tax",{"$f":"D4-D5-D6","v":41627300}]
[null,"Loan Proceeds"]
[null,5,"New Loan",{"$f":"'(5)Project Summary'!D31","v":40485000}]
[null,6,"Less:  Old Loan",{"$f":"'(5)Project Summary'!D25","v":19412000}]
[null,7,"Gross Loan Proceeds",{"$f":"D9-D10","v":21073000}]
[null,8,"Less:  Loan Costs",{"$f":"'(5)Project Summary'!D32","v":404850}]
[null,9,"Net loan Proceeds",{"$f":"D11-D12","v":20668150}]
[null,"Investment Base"]
[null,10,"Sale Proceeds Before Tax",{"$f":"D7","v":41627300}]
[null,11,"Less:  Net Loan Proceeds",{"$f":"D13","v":20668150}]
[null,12,"Investment Base",{"$f":"D15-D16","v":20959150}]
[null,"Financial Feasibility Measures"]
[null,13,"Pro Forma Profit",{"$f":"D4-D5-'(5)Project Summary'!D18","v":36773650}]
[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":1.5154766891913845}]
[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":0.10051631101779591}]
[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.8731947196447651E-2},{"$f":"IF($D$17<=0,0,'(9)Annual Cash Flow Projection'!E50/('(10)Sale Proceeds-Ratios'!$D$17))","v":7.3561043319143468E-2},{"$f":"IF($D$17<=0,0,'(9)Annual Cash Flow Projection'!F50/('(10)Sale Proceeds-Ratios'!$D$17))","v":7.8510866844906685E-2},{"$f":"IF($D$17<=0,0,'(9)Annual Cash Flow Projection'!G50/('(10)Sale Proceeds-Ratios'!$D$17))","v":8.3584435958813985E-2},{"$f":"IF($D$17<=0,0,'(9)Annual Cash Flow Projection'!H50/('(10)Sale Proceeds-Ratios'!$D$17))","v":8.8784844300568946E-2},{"$f":"IF($D$17<=0,0,'(9)Annual Cash Flow Projection'!I50/('(10)Sale Proceeds-Ratios'!$D$17))","v":9.4115262850867742E-2},{"$f":"IF($D$17<=0,0,'(9)Annual Cash Flow Projection'!J50/('(10)Sale Proceeds-Ratios'!$D$17))","v":9.9578941864924081E-2},{"$f":"IF($D$17<=0,0,'(9)Annual Cash Flow Projection'!K50/('(10)Sale Proceeds-Ratios'!$D$17))","v":0.10517921285433179},{"$f":"IF($D$17<=0,0,'(9)Annual Cash Flow Projection'!L50/('(10)Sale Proceeds-Ratios'!$D$17))","v":0.11091949061847467},{"$f":"IF($D$17<=0,0,'(9)Annual Cash Flow Projection'!M50/('(10)Sale Proceeds-Ratios'!$D$17))","v":0.11680327532672113}]
[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.5000401380749778E-2},{"$f":"IF('(5)Project Summary'!$D$19=0,0,'(9)Annual Cash Flow Projection'!E48/'(5)Project Summary'!$D$19)","v":6.6625411415268523E-2},{"$f":"IF('(5)Project Summary'!$D$19=0,0,'(9)Annual Cash Flow Projection'!F48/'(5)Project Summary'!$D$19)","v":6.829104670065024E-2},{"$f":"IF('(5)Project Summary'!$D$19=0,0,'(9)Annual Cash Flow Projection'!G48/'(5)Project Summary'!$D$19)","v":6.9998322868166499E-2},{"$f":"IF('(5)Project Summary'!$D$19=0,0,'(9)Annual Cash Flow Projection'!H48/'(5)Project Summary'!$D$19)","v":7.1748280939870651E-2},{"$f":"IF('(5)Project Summary'!$D$19=0,0,'(9)Annual Cash Flow Projection'!I48/'(5)Project Summary'!$D$19)","v":7.3541987963367403E-2},{"$f":"IF('(5)Project Summary'!$D$19=0,0,'(9)Annual Cash Flow Projection'!J48/'(5)Project Summary'!$D$19)","v":7.5380537662451591E-2},{"$f":"IF('(5)Project Summary'!$D$19=0,0,'(9)Annual Cash Flow Projection'!K48/'(5)Project Summary'!$D$19)","v":7.7265051104012883E-2},{"$f":"IF('(5)Project Summary'!$D$19=0,0,'(9)Annual Cash Flow Projection'!L48/'(5)Project Summary'!$D$19)","v":7.9196677381613192E-2},{"$f":"IF('(5)Project Summary'!$D$19=0,0,'(9)Annual Cash Flow Projection'!M48/'(5)Project Summary'!$D$19)","v":8.1176594316153511E-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.5523659805934069},{"$f":"IF('(9)Annual Cash Flow Projection'!E49=0,0,'(9)Annual Cash Flow Projection'!E48/'(9)Annual Cash Flow Projection'!E49)","v":1.591175130108242},{"$f":"IF('(9)Annual Cash Flow Projection'!F49=0,0,'(9)Annual Cash Flow Projection'!F48/'(9)Annual Cash Flow Projection'!F49)","v":1.630954508360948},{"$f":"IF('(9)Annual Cash Flow Projection'!G49=0,0,'(9)Annual Cash Flow Projection'!G48/'(9)Annual Cash Flow Projection'!G49)","v":1.671728371069972},{"$f":"IF('(9)Annual Cash Flow Projection'!H49=0,0,'(9)Annual Cash Flow Projection'!H48/'(9)Annual Cash Flow Projection'!H49)","v":1.713521580346721},{"$f":"IF('(9)Annual Cash Flow Projection'!I49=0,0,'(9)Annual Cash Flow Projection'!I48/'(9)Annual Cash Flow Projection'!I49)","v":1.7563596198553886},{"$f":"IF('(9)Annual Cash Flow Projection'!J49=0,0,'(9)Annual Cash Flow Projection'!J48/'(9)Annual Cash Flow Projection'!J49)","v":1.8002686103517735},{"$f":"IF('(9)Annual Cash Flow Projection'!K49=0,0,'(9)Annual Cash Flow Projection'!K48/'(9)Annual Cash Flow Projection'!K49)","v":1.8452753256105678},{"$f":"IF('(9)Annual Cash Flow Projection'!L49=0,0,'(9)Annual Cash Flow Projection'!L48/'(9)Annual Cash Flow Projection'!L49)","v":1.8914072087508318},{"$f":"IF('(9)Annual Cash Flow Projection'!M49=0,0,'(9)Annual Cash Flow Projection'!M48/'(9)Annual Cash Flow Projection'!M49)","v":1.9386923889696024}]
[null,19,"Loan to Value",{"$f":"IF(D44=0,0,D46/D44)","v":0.57672018767038735},0.55379785579688356,0.53121014944197964,0.50893657452309882,0.48697146018135451,0.46530152861156088,0.44390259546705296,0.42277430685013273,0.40189888112308159,0.38126002673896608]
[null,20,"Internal Rate of Return (Investment Base)",{"$f":"D63","v":0.3995130933857256},{"$f":"E63","v":0.26575687016000615},0.22251194913691963,0.20045222479344726,0.18671929461485814,0.17715587034140667,0.17000944651326622,0.16439582000412689,0.15983078486316216,0.15602139137848292]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":69163000},{"$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":70892000},{"$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":72664000},{"$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":74481000},{"$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":76343000},{"$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":78251000},{"$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":80208000},{"$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":82213000},{"$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":84268000},{"$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":86375000},null,1]
[null,null,"Less:  Cost of Sale",{"$f":"D44*'(2)Dev.-Inv. & Lender Input'!$D$25","v":1383260},{"$f":"E44*'(2)Dev.-Inv. & Lender Input'!$D$25","v":1417840},{"$f":"F44*'(2)Dev.-Inv. & Lender Input'!$D$25","v":1453280},{"$f":"G44*'(2)Dev.-Inv. & Lender Input'!$D$25","v":1489620},{"$f":"H44*'(2)Dev.-Inv. & Lender Input'!$D$25","v":1526860},{"$f":"I44*'(2)Dev.-Inv. & Lender Input'!$D$25","v":1565020},{"$f":"J44*'(2)Dev.-Inv. & Lender Input'!$D$25","v":1604160},{"$f":"K44*'(2)Dev.-Inv. & Lender Input'!$D$25","v":1644260},{"$f":"L44*'(2)Dev.-Inv. & Lender Input'!$D$25","v":1685360},{"$f":"M44*'(2)Dev.-Inv. & Lender Input'!$D$25","v":1727500},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":39887698.339846998},{"$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":39259837.593152672},{"$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":38599854.299052007},{"$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":37906105.007054925},{"$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":37176862.184625149},{"$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":36410309.91538325},{"$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":35604539.377221383},{"$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":34757544.089069963},{"$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":33867214.914479837},{"$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":32931334.809578195},null,3]
[null,null,"Sale Proceeds Before Tax",{"$f":"D44-D45-D46","v":27892041.660153002},{"$f":"E44-E45-E46","v":30214322.406847328},32610865.700947993,35085274.992945075,37639277.815374851,40275670.08461675,42999300.622778617,45811195.910930037,48715425.085520163,51716165.190421805,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,{"$f":"D7-D13","v":20959150},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":-20959150},{"$f":"D51","v":-20959150},{"$f":"E51","v":-20959150},-20959150,-20959150,-20959150,-20959150,-20959150,-20959150,-20959150,null,8]
[null,null,1,{"$f":"'(9)Annual Cash Flow Projection'!D50+D47","v":29332604.851235427},{"$f":"'(9)Annual Cash Flow Projection'!$D$50","v":1440563.1910824259},{"$f":"'(9)Annual Cash Flow Projection'!$D$50","v":1440563.1910824259},{"$f":"'(9)Annual Cash Flow Projection'!$D$50","v":1440563.1910824259},{"$f":"'(9)Annual Cash Flow Projection'!$D$50","v":1440563.1910824259},{"$f":"'(9)Annual Cash Flow Projection'!$D$50","v":1440563.1910824259},{"$f":"'(9)Annual Cash Flow Projection'!$D$50","v":1440563.1910824259},{"$f":"'(9)Annual Cash Flow Projection'!$D$50","v":1440563.1910824259},{"$f":"'(9)Annual Cash Flow Projection'!$D$50","v":1440563.1910824259},{"$f":"'(9)Annual Cash Flow Projection'!$D$50","v":1440563.1910824259},null,9]
[null,null,2,0,{"$f":"'(9)Annual Cash Flow Projection'!E50+E47","v":31756099.347929753},{"$f":"'(9)Annual Cash Flow Projection'!$E$50","v":1541776.9410824259},{"$f":"'(9)Annual Cash Flow Projection'!$E$50","v":1541776.9410824259},{"$f":"'(9)Annual Cash Flow Projection'!$E$50","v":1541776.9410824259},{"$f":"'(9)Annual Cash Flow Projection'!$E$50","v":1541776.9410824259},{"$f":"'(9)Annual Cash Flow Projection'!$E$50","v":1541776.9410824259},{"$f":"'(9)Annual Cash Flow Projection'!$E$50","v":1541776.9410824259},{"$f":"'(9)Annual Cash Flow Projection'!$E$50","v":1541776.9410824259},{"$f":"'(9)Annual Cash Flow Projection'!$E$50","v":1541776.9410824259},null,10]
[null,null,3,0,0,{"$f":"'(9)Annual Cash Flow Projection'!F50+F47","v":34256386.735780418},{"$f":"'(9)Annual Cash Flow Projection'!$F$50","v":1645521.0348324259},{"$f":"'(9)Annual Cash Flow Projection'!$F$50","v":1645521.0348324259},{"$f":"'(9)Annual Cash Flow Projection'!$F$50","v":1645521.0348324259},{"$f":"'(9)Annual Cash Flow Projection'!$F$50","v":1645521.0348324259},{"$f":"'(9)Annual Cash Flow Projection'!$F$50","v":1645521.0348324259},{"$f":"'(9)Annual Cash Flow Projection'!$F$50","v":1645521.0348324259},{"$f":"'(9)Annual Cash Flow Projection'!$F$50","v":1645521.0348324259}]
[null,null,4,0,0,0,{"$f":"'(9)Annual Cash Flow Projection'!G50+G47","v":36837133.723871253},{"$f":"'(9)Annual Cash Flow Projection'!$G$50","v":1751858.7309261761},{"$f":"'(9)Annual Cash Flow Projection'!$G$50","v":1751858.7309261761},{"$f":"'(9)Annual Cash Flow Projection'!$G$50","v":1751858.7309261761},{"$f":"'(9)Annual Cash Flow Projection'!$G$50","v":1751858.7309261761},{"$f":"'(9)Annual Cash Flow Projection'!$G$50","v":1751858.7309261761},{"$f":"'(9)Annual Cash Flow Projection'!$G$50","v":1751858.7309261761}]
[null,null,5,0,0,0,0,{"$f":"'(9)Annual Cash Flow Projection'!H50+H47","v":39500132.684797123},{"$f":"'(9)Annual Cash Flow Projection'!$H$50","v":1860854.8694222695},{"$f":"'(9)Annual Cash Flow Projection'!$H$50","v":1860854.8694222695},{"$f":"'(9)Annual Cash Flow Projection'!$H$50","v":1860854.8694222695},{"$f":"'(9)Annual Cash Flow Projection'!$H$50","v":1860854.8694222695},{"$f":"'(9)Annual Cash Flow Projection'!$H$50","v":1860854.8694222695}]
[null,null,6,0,0,0,0,0,{"$f":"'(9)Annual Cash Flow Projection'!I50+I47","v":42248245.995997518},{"$f":"'(9)Annual Cash Flow Projection'!$I$50","v":1972575.9113807646},{"$f":"'(9)Annual Cash Flow Projection'!$I$50","v":1972575.9113807646},{"$f":"'(9)Annual Cash Flow Projection'!$I$50","v":1972575.9113807646},{"$f":"'(9)Annual Cash Flow Projection'!$I$50","v":1972575.9113807646}]
[null,null,7,0,0,0,0,0,0,{"$f":"'(9)Annual Cash Flow Projection'!J50+J47","v":45086390.602166839},{"$f":"'(9)Annual Cash Flow Projection'!$J$50","v":2087089.9793882235},{"$f":"'(9)Annual Cash Flow Projection'!$J$50","v":2087089.9793882235},{"$f":"'(9)Annual Cash Flow Projection'!$J$50","v":2087089.9793882235}]
[null,null,8,0,0,0,0,0,0,0,{"$f":"'(9)Annual Cash Flow Projection'!K50+K47","v":48015662.810025908},{"$f":"'(9)Annual Cash Flow Projection'!$K$50","v":2204466.8990958682},{"$f":"'(9)Annual Cash Flow Projection'!$K$50","v":2204466.8990958682}]
[null,null,9,0,0,0,0,0,0,0,0,{"$f":"'(9)Annual Cash Flow Projection'!L50+L47","v":51040203.327316366},{"$f":"'(9)Annual Cash Flow Projection'!L50","v":2324778.2417962034}]
[null,null,10,0,0,0,0,0,0,0,0,0,{"$f":"'(9)Annual Cash Flow Projection'!M50+M47","v":54164262.558485851}]
[]
[null,null,null,{"$f":"IF(D44=0,0,IRR(D51:D61))","v":0.3995130933857256},{"$f":"IF(E44=0,0,IRR(E51:E61))","v":0.26575687016000615},0.22251194913691963,0.20045222479344726,0.18671929461485814,0.17715587034140667,0.17000944651326622,0.16439582000412689,0.15983078486316216,0.15602139137848292]

{"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":50000754.851235427},{"$f":"NPV(B5,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":53864812.539012179},{"$f":"NPV(B5,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":57906876.867945269},{"$f":"NPV(B5,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":62133144.89086853},{"$f":"NPV(B5,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":66548002.582720578},{"$f":"NPV(B5,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":71156970.763343245},{"$f":"NPV(B5,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":75967691.280893326},{"$f":"NPV(B5,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":80984053.468140617},{"$f":"NPV(B5,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":86213060.884526938},{"$f":"NPV(B5,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":91661898.357492641}]
[null,0.02,{"$f":"NPV(B6,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":49425605.736505315},{"$f":"NPV(B6,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":52603438.161124401},{"$f":"NPV(B6,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":55842933.039410412},{"$f":"NPV(B6,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":59144803.439218476},{"$f":"NPV(B6,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":62507919.781094156},{"$f":"NPV(B6,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":65932099.59596967},{"$f":"NPV(B6,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":69418873.418136507},{"$f":"NPV(B6,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":72966300.46236524},{"$f":"NPV(B6,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":76575044.765025765},{"$f":"NPV(B6,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":80245716.999337167}]
[null,0.04,{"$f":"NPV(B7,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":48872577.741572529},{"$f":"NPV(B7,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":51413605.867839754},{"$f":"NPV(B7,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":53932569.433799006},{"$f":"NPV(B7,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":56430164.865237609},{"$f":"NPV(B7,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":58905354.532063521},{"$f":"NPV(B7,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":61358014.314018331},{"$f":"NPV(B7,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":63789518.564203292},{"$f":"NPV(B7,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":66198158.567687213},{"$f":"NPV(B7,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":68584536.275162667},{"$f":"NPV(B7,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":70949159.807377815}]
[null,0.06,{"$f":"NPV(B8,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":48340418.727580592},{"$f":"NPV(B8,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":50289987.246775649},{"$f":"NPV(B8,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":52161670.737612247},{"$f":"NPV(B8,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":53959419.253249615},{"$f":"NPV(B8,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":55685392.23638276},{"$f":"NPV(B8,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":57342480.598034635},{"$f":"NPV(B8,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":58934747.2461394},{"$f":"NPV(B8,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":60463377.351363041},{"$f":"NPV(B8,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":61931484.21858006},{"$f":"NPV(B8,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":63341940.268366225}]
[null,0.08,{"$f":"NPV(B9,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":47827969.30669947},{"$f":"NPV(B9,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":49227741.558898121},{"$f":"NPV(B9,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":50517654.282112077},{"$f":"NPV(B9,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":51706490.659621105},{"$f":"NPV(B9,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":52800892.732110277},{"$f":"NPV(B9,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":53807794.118244216},{"$f":"NPV(B9,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":54734766.001955532},{"$f":"NPV(B9,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":55586455.670570828},{"$f":"NPV(B9,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":56368900.954740852},{"$f":"NPV(B9,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":57087593.576339148}]
[null,0.1,{"$f":"NPV(B10,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":47334154.410214022},{"$f":"NPV(B10,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":48222463.105884641},{"$f":"NPV(B10,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":48989279.100060716},{"$f":"NPV(B10,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":49648511.019211359},{"$f":"NPV(B10,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":50211270.761502638},{"$f":"NPV(B10,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":50688274.036628462},{"$f":"NPV(B10,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":51090155.617638044},{"$f":"NPV(B10,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":51424376.491355628},{"$f":"NPV(B10,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":51699144.175035045},{"$f":"NPV(B10,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":51921716.374586195}]
[null,0.12,{"$f":"NPV(B11,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":46857975.760031626},{"$f":"NPV(B11,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":47270135.109966569},{"$f":"NPV(B11,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":47566481.712861106},{"$f":"NPV(B11,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":47765376.080966935},{"$f":"NPV(B11,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":47881485.626947306},{"$f":"NPV(B11,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":47928224.801377803},{"$f":"NPV(B11,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":47918110.321503401},{"$f":"NPV(B11,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":47860131.314036503},{"$f":"NPV(B11,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":47763366.62886326},{"$f":"NPV(B11,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":47635538.895289503}]
[null,0.14000000000000001,{"$f":"NPV(B12,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":46398505.132662654},{"$f":"NPV(B12,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":46367089.201110885},{"$f":"NPV(B12,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":46240234.508961663},{"$f":"NPV(B12,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":46039369.394884929},{"$f":"NPV(B12,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":45781201.199991196},{"$f":"NPV(B12,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":45480272.292574868},{"$f":"NPV(B12,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":45149423.225848332},{"$f":"NPV(B12,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":44797623.227019727},{"$f":"NPV(B12,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":44433361.614808671},{"$f":"NPV(B12,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":44063455.983929664}]
[null,0.16,{"$f":"NPV(B13,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":45954878.32003054},{"$f":"NPV(B13,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":45509969.745530151},{"$f":"NPV(B13,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":45002423.274681047},{"$f":"NPV(B13,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":44454842.949668989},{"$f":"NPV(B13,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":43884085.186196849},{"$f":"NPV(B13,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":43304000.469846681},{"$f":"NPV(B13,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":42726060.023083463},{"$f":"NPV(B13,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":42157637.180399537},{"$f":"NPV(B13,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":41605229.785841152},{"$f":"NPV(B13,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":41073513.802516431}]
[null,0.18,{"$f":"NPV(B14,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":45526289.704436809},{"$f":"NPV(B14,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":44695702.36527364},{"$f":"NPV(B14,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":43845741.010717295},{"$f":"NPV(B14,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":42997945.127579361},{"$f":"NPV(B14,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":42167222.643422484},{"$f":"NPV(B14,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":41364830.209946617},{"$f":"NPV(B14,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":40599198.415805787},{"$f":"NPV(B14,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":39874640.304419801},{"$f":"NPV(B14,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":39194437.569054544},{"$f":"NPV(B14,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":38560115.185727388}]
[null,0.2,{"$f":"NPV(B15,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":45111987.376029521},{"$f":"NPV(B15,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":43921466.095297687},{"$f":"NPV(B15,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":42763595.636711821},{"$f":"NPV(B15,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":41656388.307783224},{"$f":"NPV(B15,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":40610623.572243996},{"$f":"NPV(B15,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":39633094.093702823},{"$f":"NPV(B15,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":38727637.829990625},{"$f":"NPV(B15,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":37894230.740655258},{"$f":"NPV(B15,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":37131944.07388366},{"$f":"NPV(B15,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":36438399.12119431}]
[null,0.22,{"$f":"NPV(B16,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":44711268.730520844},{"$f":"NPV(B16,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":43184668.705354959},{"$f":"NPV(B16,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":41750029.572248369},{"$f":"NPV(B16,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":40419249.795452356},{"$f":"NPV(B16,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":39196808.226813272},{"$f":"NPV(B16,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":38083270.323029138},{"$f":"NPV(B16,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":37076504.718413703},{"$f":"NPV(B16,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":36171095.378134035},{"$f":"NPV(B16,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":35361152.261496201},{"$f":"NPV(B16,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":34639889.853276514}]
[null,0.24,{"$f":"NPV(B17,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":44323476.492931798},{"$f":"NPV(B17,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":42482924.782044724},{"$f":"NPV(B17,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":40799649.501386195},{"$f":"NPV(B17,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":39276800.846066535},{"$f":"NPV(B17,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":37910456.84872891},{"$f":"NPV(B17,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":36693346.333699629},{"$f":"NPV(B17,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":35616194.75389795},{"$f":"NPV(B17,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":34667368.633088678},{"$f":"NPV(B17,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":33835498.870371744},{"$f":"NPV(B17,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":33109113.547368638}]
[null,0.26,{"$f":"NPV(B18,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":43947995.120028116},{"$f":"NPV(B18,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":41814036.223666921},{"$f":"NPV(B18,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":39907564.89185369},{"$f":"NPV(B18,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":38220359.443889335},{"$f":"NPV(B18,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":36738112.971962489},{"$f":"NPV(B18,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":35444288.482855633},{"$f":"NPV(B18,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":34321505.588818088},{"$f":"NPV(B18,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":33351308.566805545},{"$f":"NPV(B18,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":32516541.523878388},{"$f":"NPV(B18,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":31800955.800297737}]
[null,0.28000000000000003,{"$f":"NPV(B19,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":43584247.540027678},{"$f":"NPV(B19,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":41175974.848947302},{"$f":"NPV(B19,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":39069334.059446029},{"$f":"NPV(B19,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":37242163.220530413},{"$f":"NPV(B19,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":35667931.412289947},{"$f":"NPV(B19,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":34319598.78490404},{"$f":"NPV(B19,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":33170923.477828726},{"$f":"NPV(B19,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":32196225.102049775},{"$f":"NPV(B19,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":31372434.474466555},{"$f":"NPV(B19,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":30678588.99841598}]
[null,0.3,{"$f":"NPV(B20,'(10)Sale Proceeds-Ratios'!$D$52:$D$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":43231692.193258017},{"$f":"NPV(B20,'(10)Sale Proceeds-Ratios'!$E$52:$E$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":40566866.861737818},{"$f":"NPV(B20,'(10)Sale Proceeds-Ratios'!$F$52:$F$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":38280916.751077317},{"$f":"NPV(B20,'(10)Sale Proceeds-Ratios'!$G$52:$G$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":36335259.495602667},{"$f":"NPV(B20,'(10)Sale Proceeds-Ratios'!$H$52:$H$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":34689463.640029982},{"$f":"NPV(B20,'(10)Sale Proceeds-Ratios'!$I$52:$I$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":33304943.315320686},{"$f":"NPV(B20,'(10)Sale Proceeds-Ratios'!$J$52:$J$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":32146034.570459843},{"$f":"NPV(B20,'(10)Sale Proceeds-Ratios'!$K$52:$K$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":31179609.278799616},{"$f":"NPV(B20,'(10)Sale Proceeds-Ratios'!$L$52:$L$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":30376709.390986808},{"$f":"NPV(B20,'(10)Sale Proceeds-Ratios'!$M$52:$M$61)+'(10)Sale Proceeds-Ratios'!$D$13","v":29711839.934651114}]
[]
[null,null,null,null,null,null,{"$f":"'(10)Sale Proceeds-Ratios'!D7","v":41627300}]
[null,null,null,null,null,null,{"$f":"G22","v":41627300}]
[null,null,null,null,null,null,{"$f":"G23","v":41627300}]
[null,null,null,null,null,null,41627300]
[null,null,null,null,null,null,41627300]
[null,null,null,null,null,null,41627300]
[null,null,null,null,null,null,41627300]
[null,null,null,null,null,null,41627300]
[null,null,null,null,null,null,41627300]
[null,null,null,null,null,null,41627300]
[null,null,null,null,null,null,41627300]
[null,null,null,null,null,null,41627300]
[null,null,null,null,null,null,41627300]
[null,null,null,null,null,null,41627300]
[null,null,null,null,null,null,41627300]
[null,null,null,null,null,null,41627300]