{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Inputs-Inv","Inputs-Oper","Cash Flow","PartnershipCF","8YRDCF"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":111,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7]]}
["INVESTMENT MODEL INSTRUCTIONS"]
["TEST APARTMENT MODEL"]
["Fred Mertz Apartments"]
["555 Main Street"]
["Erehwon, WI"]
[]
["Color Codes"]
["Green","User Input Fields"]
["Blue","Calculated Field -- User can overide as desired"]
["Tan","Constant that rarely changes (e.g. tax rates)"]
["Red","Calculation -- do not change"]
["Gray","Background headings -- should not need to be changed"]
[]
["Worksheets in this Workbook"]
["Instructions","Brief explanation of model organization"]
[]
["Inputs-Inv","Input sheet for basic property, mortgage and investment parameters"]
[]
["Inputs-Oper","Detailed entry form for rents, expenses and growth rate assumptions"]
[]
["Cash Flow","Detailed cash flow model; heavy on analysis, light on formatting"]
[]
["PartnershipCF","Managing Partner and Limited Partner (Investor) cash flow calculations"]
[]
["8YRDCF","Output table showing an 8-year DCF model and investment returns"]
[]
["How to Run this Model"]
["1. Enter property investment and operating assumptions in the \"Inputs-Inv\" and \"Inputs-Oper\""]
["    worksheets.  Enter data into green fields.  Overide calculated or assumed inputs as desired"]
["    in the blue fields."]
[]
[]
[]
["COMMENTS"]
["The complex tax consequences associated with selling a property at a loss are not considered."]

{"sheet":"Inputs-Inv","index":1,"n_rows":50,"n_cols":7,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7]]}
["INVESTMENT MODEL INPUTS"]
["APARTMENT INVESTMENT"]
["Merz Apartments"]
["555 Main Street"]
[]
["INVESTMENT INFORMATION",null,null,null,"BUILDING INFORMATION"]
["Overall Investment",null,null,null,"Building Name:","PropName","Mertz Apartments"]
["Asking Price:","ASKPRICE",6000000,null,"Address:","PropAddr","555 Main Street"]
[]
["Purchase Price:","PURPRICE",5950000]
["Capital Costs","CAPCOST",50000]
["Total Acquisition Cost","PRICE+CAPS",{"$f":"PURPRICE+CAPCOST","v":6000000}]
[]
["Valuation & Reversion Rates",null,null,null,"TAX INFORMATION"]
["Cap Rate (OAR, Going-in)","CAPIN",0.08]
["Reversionary Cap Rate","CAPOUT",8.5000000000000006E-2,null,"Income Tax Rate","TAXRATE",0.39]
["Discount Rate","DISCRATE",0.12,null,"K Gains Rate (St & Fed)","KTRATE",0.2]
["Cost of Sale","COSTSALE",0.03,null,"K Gains Rate Depreciation","KTRDEPR",0.25]
[]
["Debt Terms",null,null,null,"Land/Total Value","LANDTOVALUE",0.2]
["LTV Ratio","LTV",0.85,null,"IRS Useful Life","TAXLIFE",39]
["Loan Amount","LOANAMT",{"$f":"PRICE_CAPS*LTV","v":5100000}]
["Equity Required","EQUITY",{"$f":"PRICE_CAPS-LOANAMT","v":900000},null,"Investor's AGI","AGI",80000]
[null,null,null,null,"Investor's Other Passive Income","OPY",10000]
[null,null,null,null,"Passive Loss Limit","PLL",{"$f":"SUM(MAXA((25000-IF(AGI>=100000,0.5*(AGI-100000),0)),0),OPY)","v":35000}]
["Principal","M1PRINCIP",{"$f":"LOANAMT","v":5100000}]
["Interest Rate","M1INT",8.2500000000000004E-2]
["Term","M1TERM",5,"Years"]
["Amortization","M1AMORT",30,"Years"]
[]
["Required Equity IRR","EQRATE",0.15]
[]
["PARTNERSHIP STRUCTURE"]
[]
["General (Managing) Partner",null,null,null,"Limited Partner (Investor)"]
["Equity Investment","GPEQ",0,null,"Equity Investment","LPEQ",{"$f":"1-C36","v":1}]
["Cash Assessments","GPASSES",{"$f":"C36","v":0},null,"Cash Assessments","LPASSES",1]
["Cash from Operations","GPCASHOPS",0.3,null,"Cash from Operations","LPCASHOPS",0.7]
["Taxable Income/Loss","GPTI",{"$f":"C38","v":0.3},null,"Taxable Income/Loss","LPTI",0.7]
["Cash from Sale","GPREV",{"$f":"C38","v":0.3},null,"Cash from Sale","LPREV",0.7]
["Gain/Loss from Sale","GPGAIN",{"$f":"C38","v":0.3},null,"Gain/Loss from Sale","LPGAIN",0.7]
[]
["Tax Rate","GPTAXRATE",0.28000000000000003,null,"Tax Rate","LPTAXRATE",0.28000000000000003]
["K Gains Rate (St & Fed)","GPKTRATE",0.2,null,"K Gains Rate (St & Fed)","LPKTRATE",{"$f":"C44","v":0.2}]
["K Gains Rate Depreciation","GPKTRDEPR",0.25,null,"K Gains Rate Depreciation","LPKTRDEPR",{"$f":"C45","v":0.25}]
[]
[]
["Investor's AGI","GPAGI",80000,null,"Investor's AGI"]
["Investor's Other Passive Income","GPOPI",10000,null,"Investor's Other Passive Income","LPOPI",10000]
["Passive Loss Limit","GPPLL",{"$f":"SUM(MAXA((25000-IF(AGI>=100000,0.5*(AGI-100000),0)),0),OPY)","v":35000},null,"Passive Loss Limit","LPPLL",{"$f":"G49","v":10000}]

{"sheet":"Inputs-Oper","index":2,"n_rows":59,"n_cols":28,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,0,0,17],[1,0,1,17],[2,0,2,17],[3,0,3,17]]}
["PRO FORMA OPERATING ASSUMPTIONS"]
["APARTMENT INVESTMENT"]
["Merz Apartments"]
["555 Main Street"]
[]
["RENTAL INCOME ASSUMPTIONS"]
[null,null,null,null,null,null,"Monthly Rent",null,"GROWTH RATE ASSUMPTIONS"]
[null,null,"Unit Type","MNEM","# Units",null,"Year 1",null,"Stabilized","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20"]
[null,"T1","Efficiency","QTYT1",15,"RENTT1",700,null,0.04]
[null,"T2","1BR1BA","QTYT2",25,"RENTT2",750,null,{"$f":"$I$9","v":0.04}]
[null,"T3","2BR1BA","QTYT3",25,"RENTT3",800,null,{"$f":"$I$9","v":0.04}]
[null,"T4","2BR2BA","QTYT4",15,"RENTT4",825,null,0.04]
[null,"T5",null,"QTYT5",null,"RENTT5",null,null,0.04]
[null,"T6",null,"QTYT6",null,"RENTT6",null,null,0.04]
[null,"T7",null,"QTYT7",null,"RENTT7",null,null,0.04]
[null,"T8",null,"QTYT8",null,"RENTT8",null,null,0.04]
[null,null,"TOTAL",null,{"$f":"SUM(E9:E16)","v":80},null,{"$f":"QTYT1*RENTT1+QTYT2*RENTT2+QTYT3*RENTT3+QTYT4*RENTT4+QTYT5*RENTT5+QTYT6*RENTT6+QTYT7*RENTT7+QTYT8*RENTT8","v":61625}]
[null,null,null,null,null,null,{"$f":"G17*12","v":739500},"Annual"]
[]
["OTHER INCOME ASSUMPTIONS (annual)"]
[null,"OINCTYP1","Parking",null,null,"OINC1",250,null,{"$f":"$I$9","v":0.04}]
[null,"OINCTYP2","Laundry",null,null,"OINC2",250,null,{"$f":"$I$9","v":0.04}]
[null,"OINCTYP3","Vending",null,null,"OINC3",250,null,{"$f":"$I$9","v":0.04}]
[null,"OINCTYP4","Miscellaneous",null,null,"OINC4",250,null,{"$f":"$I$9","v":0.04}]
[]
[null,null,"TOTAL",null,null,null,{"$f":"SUM(G21:G25)","v":1000},"Annual"]
[]
["VACANCY AND COLLECTION LOSS ASSUMPTIONS"]
[null,null,null,null,null,null,"Year 1",null,"Stabilized","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20"]
[null,null,"Rental Income",null,null,null,0.05,null,0.05]
[null,null,"Other Income",null,null,null,{"$f":"G30","v":0.05},null,{"$f":"I30","v":0.05}]
[]
[]
["OPERATING EXPENSES"]
[]
[null,null,"Utilities",null,null,null,24000,null,0.04]
[null,null,"Personnel",null,null,null,18000,null,{"$f":"$I$36","v":0.04}]
[null,null,"Rubbish Removal",null,null,null,8500,null,{"$f":"$I$36","v":0.04}]
[null,null,"Grounds/park/Snow",null,null,null,7200,null,0.04]
[null,null,"Maintenance",null,null,null,24000,null,0.04]
[null,null,"Leasing Bonus",null,null,null,0,null,0.04]
[null,null,"Advertising",null,null,null,10000,null,0.04]
[null,null,"Administration",null,null,null,2000,null,0.04]
[null,null,"Telephone",null,null,null,1800,null,0.04]
[null,null,"Insurance",null,null,null,7800,null,0.04]
[null,null,"Taxes",null,null,null,150000,null,0.04]
[null,null,"PM Fee",null,null,null,40000,null,0.04]
[null,null,"Legal",null,null,null,1800,null,0.04]
[null,null,"Accounting",null,null,null,2000,null,0.04]
[null,null,"Reserves",null,null,null,7920,null,0.04]
[null,null,"X",null,null,null,null,null,0.04]
[null,null,"X",null,null,null,null,null,0.04]
[null,null,"X",null,null,null,null,null,0.04]
[null,null,"X",null,null,null,null,null,0.04]
[null,null,"X",null,null,null,null,null,0.04]
[null,null,"X",null,null,null,null,null,0.04]
[null,null,"X",null,null,null,null,null,0.04]
[null,null,"X",null,null,null,null,null,0.04]
["Total Operating Expenses","Total Operating Expenses",null,null,null,null,{"$f":"SUM(G36:G58)","v":305020}]

{"sheet":"Cash Flow","index":3,"n_rows":172,"n_cols":33,"rows_kept":172,"cut":false,"hidden":false,"merged":[[0,0,0,12],[1,0,1,12]]}
[{"$f":"PropName&\" Operating Projections\"","v":"Mertz Apartments Operating Projections"}]
[{"$f":"PropAddr","v":"555 Main Street"}]
[]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20","Year 21"]
["GROSS POTENTIAL INCOME"]
["Rental Income"]
[null,{"$f":"T1_","v":"Efficiency"},null,{"$f":"RENTT1*QTYT1*12","v":126000},{"$f":"D7*(1+(IF(ISBLANK('Inputs-Oper'!J9),'Inputs-Oper'!$I9,'Inputs-Oper'!J9)))","v":131040},{"$f":"E7*(1+(IF(ISBLANK('Inputs-Oper'!K9),'Inputs-Oper'!$I9,'Inputs-Oper'!K9)))","v":136281.60000000001},{"$f":"F7*(1+(IF(ISBLANK('Inputs-Oper'!L9),'Inputs-Oper'!$I9,'Inputs-Oper'!L9)))","v":141732.864},{"$f":"G7*(1+(IF(ISBLANK('Inputs-Oper'!M9),'Inputs-Oper'!$I9,'Inputs-Oper'!M9)))","v":147402.17856},{"$f":"H7*(1+(IF(ISBLANK('Inputs-Oper'!N9),'Inputs-Oper'!$I9,'Inputs-Oper'!N9)))","v":153298.26570240001},{"$f":"I7*(1+(IF(ISBLANK('Inputs-Oper'!O9),'Inputs-Oper'!$I9,'Inputs-Oper'!O9)))","v":159430.19633049602},{"$f":"J7*(1+(IF(ISBLANK('Inputs-Oper'!P9),'Inputs-Oper'!$I9,'Inputs-Oper'!P9)))","v":165807.40418371587},{"$f":"K7*(1+(IF(ISBLANK('Inputs-Oper'!Q9),'Inputs-Oper'!$I9,'Inputs-Oper'!Q9)))","v":172439.7003510645},{"$f":"L7*(1+(IF(ISBLANK('Inputs-Oper'!R9),'Inputs-Oper'!$I9,'Inputs-Oper'!R9)))","v":179337.28836510709},{"$f":"M7*(1+(IF(ISBLANK('Inputs-Oper'!S9),'Inputs-Oper'!$I9,'Inputs-Oper'!S9)))","v":186510.77989971137},{"$f":"N7*(1+(IF(ISBLANK('Inputs-Oper'!T9),'Inputs-Oper'!$I9,'Inputs-Oper'!T9)))","v":193971.21109569984},{"$f":"O7*(1+(IF(ISBLANK('Inputs-Oper'!U9),'Inputs-Oper'!$I9,'Inputs-Oper'!U9)))","v":201730.05953952784},{"$f":"P7*(1+(IF(ISBLANK('Inputs-Oper'!V9),'Inputs-Oper'!$I9,'Inputs-Oper'!V9)))","v":209799.26192110896},{"$f":"Q7*(1+(IF(ISBLANK('Inputs-Oper'!W9),'Inputs-Oper'!$I9,'Inputs-Oper'!W9)))","v":218191.23239795334},{"$f":"R7*(1+(IF(ISBLANK('Inputs-Oper'!X9),'Inputs-Oper'!$I9,'Inputs-Oper'!X9)))","v":226918.88169387149},{"$f":"S7*(1+(IF(ISBLANK('Inputs-Oper'!Y9),'Inputs-Oper'!$I9,'Inputs-Oper'!Y9)))","v":235995.63696162635},{"$f":"T7*(1+(IF(ISBLANK('Inputs-Oper'!Z9),'Inputs-Oper'!$I9,'Inputs-Oper'!Z9)))","v":245435.46244009142},{"$f":"U7*(1+(IF(ISBLANK('Inputs-Oper'!AA9),'Inputs-Oper'!$I9,'Inputs-Oper'!AA9)))","v":255252.8809376951},{"$f":"V7*(1+(IF(ISBLANK('Inputs-Oper'!AB9),'Inputs-Oper'!$I9,'Inputs-Oper'!AB9)))","v":265462.99617520289},{"$f":"W7*(1+(IF(ISBLANK('Inputs-Oper'!AC9),'Inputs-Oper'!$I9,'Inputs-Oper'!AC9)))","v":276081.516022211}]
[null,{"$f":"T2_","v":"1BR1BA"},null,{"$f":"RENTT2*QTYT2*12","v":225000},{"$f":"D8*(1+(IF(ISBLANK('Inputs-Oper'!J10),'Inputs-Oper'!$I10,'Inputs-Oper'!J10)))","v":234000},{"$f":"E8*(1+(IF(ISBLANK('Inputs-Oper'!K10),'Inputs-Oper'!$I10,'Inputs-Oper'!K10)))","v":243360},{"$f":"F8*(1+(IF(ISBLANK('Inputs-Oper'!L10),'Inputs-Oper'!$I10,'Inputs-Oper'!L10)))","v":253094.39999999999},{"$f":"G8*(1+(IF(ISBLANK('Inputs-Oper'!M10),'Inputs-Oper'!$I10,'Inputs-Oper'!M10)))","v":263218.17599999998},{"$f":"H8*(1+(IF(ISBLANK('Inputs-Oper'!N10),'Inputs-Oper'!$I10,'Inputs-Oper'!N10)))","v":273746.90304},{"$f":"I8*(1+(IF(ISBLANK('Inputs-Oper'!O10),'Inputs-Oper'!$I10,'Inputs-Oper'!O10)))","v":284696.77916159999},{"$f":"J8*(1+(IF(ISBLANK('Inputs-Oper'!P10),'Inputs-Oper'!$I10,'Inputs-Oper'!P10)))","v":296084.65032806399},{"$f":"K8*(1+(IF(ISBLANK('Inputs-Oper'!Q10),'Inputs-Oper'!$I10,'Inputs-Oper'!Q10)))","v":307928.03634118655},{"$f":"L8*(1+(IF(ISBLANK('Inputs-Oper'!R10),'Inputs-Oper'!$I10,'Inputs-Oper'!R10)))","v":320245.15779483406},{"$f":"M8*(1+(IF(ISBLANK('Inputs-Oper'!S10),'Inputs-Oper'!$I10,'Inputs-Oper'!S10)))","v":333054.96410662745},{"$f":"N8*(1+(IF(ISBLANK('Inputs-Oper'!T10),'Inputs-Oper'!$I10,'Inputs-Oper'!T10)))","v":346377.16267089255},{"$f":"O8*(1+(IF(ISBLANK('Inputs-Oper'!U10),'Inputs-Oper'!$I10,'Inputs-Oper'!U10)))","v":360232.24917772826},{"$f":"P8*(1+(IF(ISBLANK('Inputs-Oper'!V10),'Inputs-Oper'!$I10,'Inputs-Oper'!V10)))","v":374641.53914483741},{"$f":"Q8*(1+(IF(ISBLANK('Inputs-Oper'!W10),'Inputs-Oper'!$I10,'Inputs-Oper'!W10)))","v":389627.20071063092},{"$f":"R8*(1+(IF(ISBLANK('Inputs-Oper'!X10),'Inputs-Oper'!$I10,'Inputs-Oper'!X10)))","v":405212.28873905615},{"$f":"S8*(1+(IF(ISBLANK('Inputs-Oper'!Y10),'Inputs-Oper'!$I10,'Inputs-Oper'!Y10)))","v":421420.78028861841},{"$f":"T8*(1+(IF(ISBLANK('Inputs-Oper'!Z10),'Inputs-Oper'!$I10,'Inputs-Oper'!Z10)))","v":438277.61150016316},{"$f":"U8*(1+(IF(ISBLANK('Inputs-Oper'!AA10),'Inputs-Oper'!$I10,'Inputs-Oper'!AA10)))","v":455808.71596016968},{"$f":"V8*(1+(IF(ISBLANK('Inputs-Oper'!AB10),'Inputs-Oper'!$I10,'Inputs-Oper'!AB10)))","v":474041.06459857646},{"$f":"W8*(1+(IF(ISBLANK('Inputs-Oper'!AC10),'Inputs-Oper'!$I10,'Inputs-Oper'!AC10)))","v":493002.70718251955}]
[null,{"$f":"T3_","v":"2BR1BA"},null,{"$f":"RENTT3*QTYT3*12","v":240000},{"$f":"D9*(1+(IF(ISBLANK('Inputs-Oper'!J11),'Inputs-Oper'!$I11,'Inputs-Oper'!J11)))","v":249600},{"$f":"E9*(1+(IF(ISBLANK('Inputs-Oper'!K11),'Inputs-Oper'!$I11,'Inputs-Oper'!K11)))","v":259584},{"$f":"F9*(1+(IF(ISBLANK('Inputs-Oper'!L11),'Inputs-Oper'!$I11,'Inputs-Oper'!L11)))","v":269967.35999999999},{"$f":"G9*(1+(IF(ISBLANK('Inputs-Oper'!M11),'Inputs-Oper'!$I11,'Inputs-Oper'!M11)))","v":280766.05440000002},{"$f":"H9*(1+(IF(ISBLANK('Inputs-Oper'!N11),'Inputs-Oper'!$I11,'Inputs-Oper'!N11)))","v":291996.69657600002},{"$f":"I9*(1+(IF(ISBLANK('Inputs-Oper'!O11),'Inputs-Oper'!$I11,'Inputs-Oper'!O11)))","v":303676.56443904003},{"$f":"J9*(1+(IF(ISBLANK('Inputs-Oper'!P11),'Inputs-Oper'!$I11,'Inputs-Oper'!P11)))","v":315823.62701660162},{"$f":"K9*(1+(IF(ISBLANK('Inputs-Oper'!Q11),'Inputs-Oper'!$I11,'Inputs-Oper'!Q11)))","v":328456.57209726569},{"$f":"L9*(1+(IF(ISBLANK('Inputs-Oper'!R11),'Inputs-Oper'!$I11,'Inputs-Oper'!R11)))","v":341594.83498115634},{"$f":"M9*(1+(IF(ISBLANK('Inputs-Oper'!S11),'Inputs-Oper'!$I11,'Inputs-Oper'!S11)))","v":355258.62838040263},{"$f":"N9*(1+(IF(ISBLANK('Inputs-Oper'!T11),'Inputs-Oper'!$I11,'Inputs-Oper'!T11)))","v":369468.97351561877},{"$f":"O9*(1+(IF(ISBLANK('Inputs-Oper'!U11),'Inputs-Oper'!$I11,'Inputs-Oper'!U11)))","v":384247.73245624354},{"$f":"P9*(1+(IF(ISBLANK('Inputs-Oper'!V11),'Inputs-Oper'!$I11,'Inputs-Oper'!V11)))","v":399617.64175449329},{"$f":"Q9*(1+(IF(ISBLANK('Inputs-Oper'!W11),'Inputs-Oper'!$I11,'Inputs-Oper'!W11)))","v":415602.34742467303},{"$f":"R9*(1+(IF(ISBLANK('Inputs-Oper'!X11),'Inputs-Oper'!$I11,'Inputs-Oper'!X11)))","v":432226.44132165995},{"$f":"S9*(1+(IF(ISBLANK('Inputs-Oper'!Y11),'Inputs-Oper'!$I11,'Inputs-Oper'!Y11)))","v":449515.49897452636},{"$f":"T9*(1+(IF(ISBLANK('Inputs-Oper'!Z11),'Inputs-Oper'!$I11,'Inputs-Oper'!Z11)))","v":467496.11893350742},{"$f":"U9*(1+(IF(ISBLANK('Inputs-Oper'!AA11),'Inputs-Oper'!$I11,'Inputs-Oper'!AA11)))","v":486195.96369084774},{"$f":"V9*(1+(IF(ISBLANK('Inputs-Oper'!AB11),'Inputs-Oper'!$I11,'Inputs-Oper'!AB11)))","v":505643.80223848164},{"$f":"W9*(1+(IF(ISBLANK('Inputs-Oper'!AC11),'Inputs-Oper'!$I11,'Inputs-Oper'!AC11)))","v":525869.55432802089}]
[null,{"$f":"T4_","v":"2BR2BA"},null,{"$f":"RENTT4*QTYT4*12","v":148500},{"$f":"D10*(1+(IF(ISBLANK('Inputs-Oper'!J12),'Inputs-Oper'!$I12,'Inputs-Oper'!J12)))","v":154440},{"$f":"E10*(1+(IF(ISBLANK('Inputs-Oper'!K12),'Inputs-Oper'!$I12,'Inputs-Oper'!K12)))","v":160617.60000000001},{"$f":"F10*(1+(IF(ISBLANK('Inputs-Oper'!L12),'Inputs-Oper'!$I12,'Inputs-Oper'!L12)))","v":167042.304},{"$f":"G10*(1+(IF(ISBLANK('Inputs-Oper'!M12),'Inputs-Oper'!$I12,'Inputs-Oper'!M12)))","v":173723.99616000001},{"$f":"H10*(1+(IF(ISBLANK('Inputs-Oper'!N12),'Inputs-Oper'!$I12,'Inputs-Oper'!N12)))","v":180672.95600640003},{"$f":"I10*(1+(IF(ISBLANK('Inputs-Oper'!O12),'Inputs-Oper'!$I12,'Inputs-Oper'!O12)))","v":187899.87424665602},{"$f":"J10*(1+(IF(ISBLANK('Inputs-Oper'!P12),'Inputs-Oper'!$I12,'Inputs-Oper'!P12)))","v":195415.86921652226},{"$f":"K10*(1+(IF(ISBLANK('Inputs-Oper'!Q12),'Inputs-Oper'!$I12,'Inputs-Oper'!Q12)))","v":203232.50398518317},{"$f":"L10*(1+(IF(ISBLANK('Inputs-Oper'!R12),'Inputs-Oper'!$I12,'Inputs-Oper'!R12)))","v":211361.80414459051},{"$f":"M10*(1+(IF(ISBLANK('Inputs-Oper'!S12),'Inputs-Oper'!$I12,'Inputs-Oper'!S12)))","v":219816.27631037415},{"$f":"N10*(1+(IF(ISBLANK('Inputs-Oper'!T12),'Inputs-Oper'!$I12,'Inputs-Oper'!T12)))","v":228608.92736278911},{"$f":"O10*(1+(IF(ISBLANK('Inputs-Oper'!U12),'Inputs-Oper'!$I12,'Inputs-Oper'!U12)))","v":237753.28445730067},{"$f":"P10*(1+(IF(ISBLANK('Inputs-Oper'!V12),'Inputs-Oper'!$I12,'Inputs-Oper'!V12)))","v":247263.41583559272},{"$f":"Q10*(1+(IF(ISBLANK('Inputs-Oper'!W12),'Inputs-Oper'!$I12,'Inputs-Oper'!W12)))","v":257153.95246901643},{"$f":"R10*(1+(IF(ISBLANK('Inputs-Oper'!X12),'Inputs-Oper'!$I12,'Inputs-Oper'!X12)))","v":267440.11056777707},{"$f":"S10*(1+(IF(ISBLANK('Inputs-Oper'!Y12),'Inputs-Oper'!$I12,'Inputs-Oper'!Y12)))","v":278137.71499048814},{"$f":"T10*(1+(IF(ISBLANK('Inputs-Oper'!Z12),'Inputs-Oper'!$I12,'Inputs-Oper'!Z12)))","v":289263.22359010769},{"$f":"U10*(1+(IF(ISBLANK('Inputs-Oper'!AA12),'Inputs-Oper'!$I12,'Inputs-Oper'!AA12)))","v":300833.75253371202},{"$f":"V10*(1+(IF(ISBLANK('Inputs-Oper'!AB12),'Inputs-Oper'!$I12,'Inputs-Oper'!AB12)))","v":312867.1026350605},{"$f":"W10*(1+(IF(ISBLANK('Inputs-Oper'!AC12),'Inputs-Oper'!$I12,'Inputs-Oper'!AC12)))","v":325381.78674046294}]
[null,{"$f":"T5_","v":0},null,{"$f":"RENTT5*QTYT5*12","v":0},{"$f":"D11*(1+(IF(ISBLANK('Inputs-Oper'!J13),'Inputs-Oper'!$I13,'Inputs-Oper'!J13)))","v":0},{"$f":"E11*(1+(IF(ISBLANK('Inputs-Oper'!K13),'Inputs-Oper'!$I13,'Inputs-Oper'!K13)))","v":0},{"$f":"F11*(1+(IF(ISBLANK('Inputs-Oper'!L13),'Inputs-Oper'!$I13,'Inputs-Oper'!L13)))","v":0},{"$f":"G11*(1+(IF(ISBLANK('Inputs-Oper'!M13),'Inputs-Oper'!$I13,'Inputs-Oper'!M13)))","v":0},{"$f":"H11*(1+(IF(ISBLANK('Inputs-Oper'!N13),'Inputs-Oper'!$I13,'Inputs-Oper'!N13)))","v":0},{"$f":"I11*(1+(IF(ISBLANK('Inputs-Oper'!O13),'Inputs-Oper'!$I13,'Inputs-Oper'!O13)))","v":0},{"$f":"J11*(1+(IF(ISBLANK('Inputs-Oper'!P13),'Inputs-Oper'!$I13,'Inputs-Oper'!P13)))","v":0},{"$f":"K11*(1+(IF(ISBLANK('Inputs-Oper'!Q13),'Inputs-Oper'!$I13,'Inputs-Oper'!Q13)))","v":0},{"$f":"L11*(1+(IF(ISBLANK('Inputs-Oper'!R13),'Inputs-Oper'!$I13,'Inputs-Oper'!R13)))","v":0},{"$f":"M11*(1+(IF(ISBLANK('Inputs-Oper'!S13),'Inputs-Oper'!$I13,'Inputs-Oper'!S13)))","v":0},{"$f":"N11*(1+(IF(ISBLANK('Inputs-Oper'!T13),'Inputs-Oper'!$I13,'Inputs-Oper'!T13)))","v":0},{"$f":"O11*(1+(IF(ISBLANK('Inputs-Oper'!U13),'Inputs-Oper'!$I13,'Inputs-Oper'!U13)))","v":0},{"$f":"P11*(1+(IF(ISBLANK('Inputs-Oper'!V13),'Inputs-Oper'!$I13,'Inputs-Oper'!V13)))","v":0},{"$f":"Q11*(1+(IF(ISBLANK('Inputs-Oper'!W13),'Inputs-Oper'!$I13,'Inputs-Oper'!W13)))","v":0},{"$f":"R11*(1+(IF(ISBLANK('Inputs-Oper'!X13),'Inputs-Oper'!$I13,'Inputs-Oper'!X13)))","v":0},{"$f":"S11*(1+(IF(ISBLANK('Inputs-Oper'!Y13),'Inputs-Oper'!$I13,'Inputs-Oper'!Y13)))","v":0},{"$f":"T11*(1+(IF(ISBLANK('Inputs-Oper'!Z13),'Inputs-Oper'!$I13,'Inputs-Oper'!Z13)))","v":0},{"$f":"U11*(1+(IF(ISBLANK('Inputs-Oper'!AA13),'Inputs-Oper'!$I13,'Inputs-Oper'!AA13)))","v":0},{"$f":"V11*(1+(IF(ISBLANK('Inputs-Oper'!AB13),'Inputs-Oper'!$I13,'Inputs-Oper'!AB13)))","v":0},{"$f":"W11*(1+(IF(ISBLANK('Inputs-Oper'!AC13),'Inputs-Oper'!$I13,'Inputs-Oper'!AC13)))","v":0}]
[null,{"$f":"T6_","v":0},null,{"$f":"RENTT6*QTYT6*12","v":0},{"$f":"D12*(1+(IF(ISBLANK('Inputs-Oper'!J14),'Inputs-Oper'!$I14,'Inputs-Oper'!J14)))","v":0},{"$f":"E12*(1+(IF(ISBLANK('Inputs-Oper'!K14),'Inputs-Oper'!$I14,'Inputs-Oper'!K14)))","v":0},{"$f":"F12*(1+(IF(ISBLANK('Inputs-Oper'!L14),'Inputs-Oper'!$I14,'Inputs-Oper'!L14)))","v":0},{"$f":"G12*(1+(IF(ISBLANK('Inputs-Oper'!M14),'Inputs-Oper'!$I14,'Inputs-Oper'!M14)))","v":0},{"$f":"H12*(1+(IF(ISBLANK('Inputs-Oper'!N14),'Inputs-Oper'!$I14,'Inputs-Oper'!N14)))","v":0},{"$f":"I12*(1+(IF(ISBLANK('Inputs-Oper'!O14),'Inputs-Oper'!$I14,'Inputs-Oper'!O14)))","v":0},{"$f":"J12*(1+(IF(ISBLANK('Inputs-Oper'!P14),'Inputs-Oper'!$I14,'Inputs-Oper'!P14)))","v":0},{"$f":"K12*(1+(IF(ISBLANK('Inputs-Oper'!Q14),'Inputs-Oper'!$I14,'Inputs-Oper'!Q14)))","v":0},{"$f":"L12*(1+(IF(ISBLANK('Inputs-Oper'!R14),'Inputs-Oper'!$I14,'Inputs-Oper'!R14)))","v":0},{"$f":"M12*(1+(IF(ISBLANK('Inputs-Oper'!S14),'Inputs-Oper'!$I14,'Inputs-Oper'!S14)))","v":0},{"$f":"N12*(1+(IF(ISBLANK('Inputs-Oper'!T14),'Inputs-Oper'!$I14,'Inputs-Oper'!T14)))","v":0},{"$f":"O12*(1+(IF(ISBLANK('Inputs-Oper'!U14),'Inputs-Oper'!$I14,'Inputs-Oper'!U14)))","v":0},{"$f":"P12*(1+(IF(ISBLANK('Inputs-Oper'!V14),'Inputs-Oper'!$I14,'Inputs-Oper'!V14)))","v":0},{"$f":"Q12*(1+(IF(ISBLANK('Inputs-Oper'!W14),'Inputs-Oper'!$I14,'Inputs-Oper'!W14)))","v":0},{"$f":"R12*(1+(IF(ISBLANK('Inputs-Oper'!X14),'Inputs-Oper'!$I14,'Inputs-Oper'!X14)))","v":0},{"$f":"S12*(1+(IF(ISBLANK('Inputs-Oper'!Y14),'Inputs-Oper'!$I14,'Inputs-Oper'!Y14)))","v":0},{"$f":"T12*(1+(IF(ISBLANK('Inputs-Oper'!Z14),'Inputs-Oper'!$I14,'Inputs-Oper'!Z14)))","v":0},{"$f":"U12*(1+(IF(ISBLANK('Inputs-Oper'!AA14),'Inputs-Oper'!$I14,'Inputs-Oper'!AA14)))","v":0},{"$f":"V12*(1+(IF(ISBLANK('Inputs-Oper'!AB14),'Inputs-Oper'!$I14,'Inputs-Oper'!AB14)))","v":0},{"$f":"W12*(1+(IF(ISBLANK('Inputs-Oper'!AC14),'Inputs-Oper'!$I14,'Inputs-Oper'!AC14)))","v":0}]
[null,{"$f":"T7_","v":0},null,{"$f":"RENTT7*QTYT7*12","v":0},{"$f":"D13*(1+(IF(ISBLANK('Inputs-Oper'!J15),'Inputs-Oper'!$I15,'Inputs-Oper'!J15)))","v":0},{"$f":"E13*(1+(IF(ISBLANK('Inputs-Oper'!K15),'Inputs-Oper'!$I15,'Inputs-Oper'!K15)))","v":0},{"$f":"F13*(1+(IF(ISBLANK('Inputs-Oper'!L15),'Inputs-Oper'!$I15,'Inputs-Oper'!L15)))","v":0},{"$f":"G13*(1+(IF(ISBLANK('Inputs-Oper'!M15),'Inputs-Oper'!$I15,'Inputs-Oper'!M15)))","v":0},{"$f":"H13*(1+(IF(ISBLANK('Inputs-Oper'!N15),'Inputs-Oper'!$I15,'Inputs-Oper'!N15)))","v":0},{"$f":"I13*(1+(IF(ISBLANK('Inputs-Oper'!O15),'Inputs-Oper'!$I15,'Inputs-Oper'!O15)))","v":0},{"$f":"J13*(1+(IF(ISBLANK('Inputs-Oper'!P15),'Inputs-Oper'!$I15,'Inputs-Oper'!P15)))","v":0},{"$f":"K13*(1+(IF(ISBLANK('Inputs-Oper'!Q15),'Inputs-Oper'!$I15,'Inputs-Oper'!Q15)))","v":0},{"$f":"L13*(1+(IF(ISBLANK('Inputs-Oper'!R15),'Inputs-Oper'!$I15,'Inputs-Oper'!R15)))","v":0},{"$f":"M13*(1+(IF(ISBLANK('Inputs-Oper'!S15),'Inputs-Oper'!$I15,'Inputs-Oper'!S15)))","v":0},{"$f":"N13*(1+(IF(ISBLANK('Inputs-Oper'!T15),'Inputs-Oper'!$I15,'Inputs-Oper'!T15)))","v":0},{"$f":"O13*(1+(IF(ISBLANK('Inputs-Oper'!U15),'Inputs-Oper'!$I15,'Inputs-Oper'!U15)))","v":0},{"$f":"P13*(1+(IF(ISBLANK('Inputs-Oper'!V15),'Inputs-Oper'!$I15,'Inputs-Oper'!V15)))","v":0},{"$f":"Q13*(1+(IF(ISBLANK('Inputs-Oper'!W15),'Inputs-Oper'!$I15,'Inputs-Oper'!W15)))","v":0},{"$f":"R13*(1+(IF(ISBLANK('Inputs-Oper'!X15),'Inputs-Oper'!$I15,'Inputs-Oper'!X15)))","v":0},{"$f":"S13*(1+(IF(ISBLANK('Inputs-Oper'!Y15),'Inputs-Oper'!$I15,'Inputs-Oper'!Y15)))","v":0},{"$f":"T13*(1+(IF(ISBLANK('Inputs-Oper'!Z15),'Inputs-Oper'!$I15,'Inputs-Oper'!Z15)))","v":0},{"$f":"U13*(1+(IF(ISBLANK('Inputs-Oper'!AA15),'Inputs-Oper'!$I15,'Inputs-Oper'!AA15)))","v":0},{"$f":"V13*(1+(IF(ISBLANK('Inputs-Oper'!AB15),'Inputs-Oper'!$I15,'Inputs-Oper'!AB15)))","v":0},{"$f":"W13*(1+(IF(ISBLANK('Inputs-Oper'!AC15),'Inputs-Oper'!$I15,'Inputs-Oper'!AC15)))","v":0}]
[null,{"$f":"T8_","v":0},null,{"$f":"RENTT8*QTYT8*12","v":0},{"$f":"D14*(1+(IF(ISBLANK('Inputs-Oper'!J16),'Inputs-Oper'!$I16,'Inputs-Oper'!J16)))","v":0},{"$f":"E14*(1+(IF(ISBLANK('Inputs-Oper'!K16),'Inputs-Oper'!$I16,'Inputs-Oper'!K16)))","v":0},{"$f":"F14*(1+(IF(ISBLANK('Inputs-Oper'!L16),'Inputs-Oper'!$I16,'Inputs-Oper'!L16)))","v":0},{"$f":"G14*(1+(IF(ISBLANK('Inputs-Oper'!M16),'Inputs-Oper'!$I16,'Inputs-Oper'!M16)))","v":0},{"$f":"H14*(1+(IF(ISBLANK('Inputs-Oper'!N16),'Inputs-Oper'!$I16,'Inputs-Oper'!N16)))","v":0},{"$f":"I14*(1+(IF(ISBLANK('Inputs-Oper'!O16),'Inputs-Oper'!$I16,'Inputs-Oper'!O16)))","v":0},{"$f":"J14*(1+(IF(ISBLANK('Inputs-Oper'!P16),'Inputs-Oper'!$I16,'Inputs-Oper'!P16)))","v":0},{"$f":"K14*(1+(IF(ISBLANK('Inputs-Oper'!Q16),'Inputs-Oper'!$I16,'Inputs-Oper'!Q16)))","v":0},{"$f":"L14*(1+(IF(ISBLANK('Inputs-Oper'!R16),'Inputs-Oper'!$I16,'Inputs-Oper'!R16)))","v":0},{"$f":"M14*(1+(IF(ISBLANK('Inputs-Oper'!S16),'Inputs-Oper'!$I16,'Inputs-Oper'!S16)))","v":0},{"$f":"N14*(1+(IF(ISBLANK('Inputs-Oper'!T16),'Inputs-Oper'!$I16,'Inputs-Oper'!T16)))","v":0},{"$f":"O14*(1+(IF(ISBLANK('Inputs-Oper'!U16),'Inputs-Oper'!$I16,'Inputs-Oper'!U16)))","v":0},{"$f":"P14*(1+(IF(ISBLANK('Inputs-Oper'!V16),'Inputs-Oper'!$I16,'Inputs-Oper'!V16)))","v":0},{"$f":"Q14*(1+(IF(ISBLANK('Inputs-Oper'!W16),'Inputs-Oper'!$I16,'Inputs-Oper'!W16)))","v":0},{"$f":"R14*(1+(IF(ISBLANK('Inputs-Oper'!X16),'Inputs-Oper'!$I16,'Inputs-Oper'!X16)))","v":0},{"$f":"S14*(1+(IF(ISBLANK('Inputs-Oper'!Y16),'Inputs-Oper'!$I16,'Inputs-Oper'!Y16)))","v":0},{"$f":"T14*(1+(IF(ISBLANK('Inputs-Oper'!Z16),'Inputs-Oper'!$I16,'Inputs-Oper'!Z16)))","v":0},{"$f":"U14*(1+(IF(ISBLANK('Inputs-Oper'!AA16),'Inputs-Oper'!$I16,'Inputs-Oper'!AA16)))","v":0},{"$f":"V14*(1+(IF(ISBLANK('Inputs-Oper'!AB16),'Inputs-Oper'!$I16,'Inputs-Oper'!AB16)))","v":0},{"$f":"W14*(1+(IF(ISBLANK('Inputs-Oper'!AC16),'Inputs-Oper'!$I16,'Inputs-Oper'!AC16)))","v":0}]
[]
["Potential Rental Income",null,null,{"$f":"SUM(D7:D14)","v":739500},{"$f":"SUM(E7:E14)","v":769080},799843.2,831836.92799999996,865110.40512000001,899714.82132480014,935703.41417779215,973131.55074490374,1012056.8127747,1052539.0852856878,1094640.6486971155,1138426.2746450002,1183963.3256308003,1231321.8586560322,1280574.7330022738,1331797.7223223648,1385069.6312152594,1440472.4164638696,1498091.3131224243,1558014.9656473214,{"$f":"SUM(X7:X14)","v":1620335.5642732144}]
[]
["Other Income"]
[null,{"$f":"OINCTYP1","v":"Parking"},null,{"$f":"OINC1","v":250},{"$f":"D19*(1+(IF(ISBLANK('Inputs-Oper'!J21),'Inputs-Oper'!$I21,'Inputs-Oper'!J21)))","v":260},{"$f":"E19*(1+(IF(ISBLANK('Inputs-Oper'!K21),'Inputs-Oper'!$I21,'Inputs-Oper'!K21)))","v":270.40000000000003},{"$f":"F19*(1+(IF(ISBLANK('Inputs-Oper'!L21),'Inputs-Oper'!$I21,'Inputs-Oper'!L21)))","v":281.21600000000007},{"$f":"G19*(1+(IF(ISBLANK('Inputs-Oper'!M21),'Inputs-Oper'!$I21,'Inputs-Oper'!M21)))","v":292.46464000000009},{"$f":"H19*(1+(IF(ISBLANK('Inputs-Oper'!N21),'Inputs-Oper'!$I21,'Inputs-Oper'!N21)))","v":304.16322560000009},{"$f":"I19*(1+(IF(ISBLANK('Inputs-Oper'!O21),'Inputs-Oper'!$I21,'Inputs-Oper'!O21)))","v":316.32975462400009},{"$f":"J19*(1+(IF(ISBLANK('Inputs-Oper'!P21),'Inputs-Oper'!$I21,'Inputs-Oper'!P21)))","v":328.9829448089601},{"$f":"K19*(1+(IF(ISBLANK('Inputs-Oper'!Q21),'Inputs-Oper'!$I21,'Inputs-Oper'!Q21)))","v":342.14226260131852},{"$f":"L19*(1+(IF(ISBLANK('Inputs-Oper'!R21),'Inputs-Oper'!$I21,'Inputs-Oper'!R21)))","v":355.82795310537125},{"$f":"M19*(1+(IF(ISBLANK('Inputs-Oper'!S21),'Inputs-Oper'!$I21,'Inputs-Oper'!S21)))","v":370.0610712295861},{"$f":"N19*(1+(IF(ISBLANK('Inputs-Oper'!T21),'Inputs-Oper'!$I21,'Inputs-Oper'!T21)))","v":384.86351407876958},{"$f":"O19*(1+(IF(ISBLANK('Inputs-Oper'!U21),'Inputs-Oper'!$I21,'Inputs-Oper'!U21)))","v":400.25805464192035},{"$f":"P19*(1+(IF(ISBLANK('Inputs-Oper'!V21),'Inputs-Oper'!$I21,'Inputs-Oper'!V21)))","v":416.26837682759719},{"$f":"Q19*(1+(IF(ISBLANK('Inputs-Oper'!W21),'Inputs-Oper'!$I21,'Inputs-Oper'!W21)))","v":432.91911190070107},{"$f":"R19*(1+(IF(ISBLANK('Inputs-Oper'!X21),'Inputs-Oper'!$I21,'Inputs-Oper'!X21)))","v":450.23587637672915},{"$f":"S19*(1+(IF(ISBLANK('Inputs-Oper'!Y21),'Inputs-Oper'!$I21,'Inputs-Oper'!Y21)))","v":468.24531143179831},{"$f":"T19*(1+(IF(ISBLANK('Inputs-Oper'!Z21),'Inputs-Oper'!$I21,'Inputs-Oper'!Z21)))","v":486.97512388907029},{"$f":"U19*(1+(IF(ISBLANK('Inputs-Oper'!AA21),'Inputs-Oper'!$I21,'Inputs-Oper'!AA21)))","v":506.45412884463315},{"$f":"V19*(1+(IF(ISBLANK('Inputs-Oper'!AB21),'Inputs-Oper'!$I21,'Inputs-Oper'!AB21)))","v":526.71229399841855},{"$f":"W19*(1+(IF(ISBLANK('Inputs-Oper'!AC21),'Inputs-Oper'!$I21,'Inputs-Oper'!AC21)))","v":547.78078575835525}]
[null,{"$f":"OINCTYP2","v":"Laundry"},null,{"$f":"OINC2","v":250},{"$f":"D20*(1+(IF(ISBLANK('Inputs-Oper'!J22),'Inputs-Oper'!$I22,'Inputs-Oper'!J22)))","v":260},{"$f":"E20*(1+(IF(ISBLANK('Inputs-Oper'!K22),'Inputs-Oper'!$I22,'Inputs-Oper'!K22)))","v":270.40000000000003},{"$f":"F20*(1+(IF(ISBLANK('Inputs-Oper'!L22),'Inputs-Oper'!$I22,'Inputs-Oper'!L22)))","v":281.21600000000007},{"$f":"G20*(1+(IF(ISBLANK('Inputs-Oper'!M22),'Inputs-Oper'!$I22,'Inputs-Oper'!M22)))","v":292.46464000000009},{"$f":"H20*(1+(IF(ISBLANK('Inputs-Oper'!N22),'Inputs-Oper'!$I22,'Inputs-Oper'!N22)))","v":304.16322560000009},{"$f":"I20*(1+(IF(ISBLANK('Inputs-Oper'!O22),'Inputs-Oper'!$I22,'Inputs-Oper'!O22)))","v":316.32975462400009},{"$f":"J20*(1+(IF(ISBLANK('Inputs-Oper'!P22),'Inputs-Oper'!$I22,'Inputs-Oper'!P22)))","v":328.9829448089601},{"$f":"K20*(1+(IF(ISBLANK('Inputs-Oper'!Q22),'Inputs-Oper'!$I22,'Inputs-Oper'!Q22)))","v":342.14226260131852},{"$f":"L20*(1+(IF(ISBLANK('Inputs-Oper'!R22),'Inputs-Oper'!$I22,'Inputs-Oper'!R22)))","v":355.82795310537125},{"$f":"M20*(1+(IF(ISBLANK('Inputs-Oper'!S22),'Inputs-Oper'!$I22,'Inputs-Oper'!S22)))","v":370.0610712295861},{"$f":"N20*(1+(IF(ISBLANK('Inputs-Oper'!T22),'Inputs-Oper'!$I22,'Inputs-Oper'!T22)))","v":384.86351407876958},{"$f":"O20*(1+(IF(ISBLANK('Inputs-Oper'!U22),'Inputs-Oper'!$I22,'Inputs-Oper'!U22)))","v":400.25805464192035},{"$f":"P20*(1+(IF(ISBLANK('Inputs-Oper'!V22),'Inputs-Oper'!$I22,'Inputs-Oper'!V22)))","v":416.26837682759719},{"$f":"Q20*(1+(IF(ISBLANK('Inputs-Oper'!W22),'Inputs-Oper'!$I22,'Inputs-Oper'!W22)))","v":432.91911190070107},{"$f":"R20*(1+(IF(ISBLANK('Inputs-Oper'!X22),'Inputs-Oper'!$I22,'Inputs-Oper'!X22)))","v":450.23587637672915},{"$f":"S20*(1+(IF(ISBLANK('Inputs-Oper'!Y22),'Inputs-Oper'!$I22,'Inputs-Oper'!Y22)))","v":468.24531143179831},{"$f":"T20*(1+(IF(ISBLANK('Inputs-Oper'!Z22),'Inputs-Oper'!$I22,'Inputs-Oper'!Z22)))","v":486.97512388907029},{"$f":"U20*(1+(IF(ISBLANK('Inputs-Oper'!AA22),'Inputs-Oper'!$I22,'Inputs-Oper'!AA22)))","v":506.45412884463315},{"$f":"V20*(1+(IF(ISBLANK('Inputs-Oper'!AB22),'Inputs-Oper'!$I22,'Inputs-Oper'!AB22)))","v":526.71229399841855},{"$f":"W20*(1+(IF(ISBLANK('Inputs-Oper'!AC22),'Inputs-Oper'!$I22,'Inputs-Oper'!AC22)))","v":547.78078575835525}]
[null,{"$f":"OINCTYP3","v":"Vending"},null,{"$f":"OINC3","v":250},{"$f":"D21*(1+(IF(ISBLANK('Inputs-Oper'!J23),'Inputs-Oper'!$I23,'Inputs-Oper'!J23)))","v":260},{"$f":"E21*(1+(IF(ISBLANK('Inputs-Oper'!K23),'Inputs-Oper'!$I23,'Inputs-Oper'!K23)))","v":270.40000000000003},{"$f":"F21*(1+(IF(ISBLANK('Inputs-Oper'!L23),'Inputs-Oper'!$I23,'Inputs-Oper'!L23)))","v":281.21600000000007},{"$f":"G21*(1+(IF(ISBLANK('Inputs-Oper'!M23),'Inputs-Oper'!$I23,'Inputs-Oper'!M23)))","v":292.46464000000009},{"$f":"H21*(1+(IF(ISBLANK('Inputs-Oper'!N23),'Inputs-Oper'!$I23,'Inputs-Oper'!N23)))","v":304.16322560000009},{"$f":"I21*(1+(IF(ISBLANK('Inputs-Oper'!O23),'Inputs-Oper'!$I23,'Inputs-Oper'!O23)))","v":316.32975462400009},{"$f":"J21*(1+(IF(ISBLANK('Inputs-Oper'!P23),'Inputs-Oper'!$I23,'Inputs-Oper'!P23)))","v":328.9829448089601},{"$f":"K21*(1+(IF(ISBLANK('Inputs-Oper'!Q23),'Inputs-Oper'!$I23,'Inputs-Oper'!Q23)))","v":342.14226260131852},{"$f":"L21*(1+(IF(ISBLANK('Inputs-Oper'!R23),'Inputs-Oper'!$I23,'Inputs-Oper'!R23)))","v":355.82795310537125},{"$f":"M21*(1+(IF(ISBLANK('Inputs-Oper'!S23),'Inputs-Oper'!$I23,'Inputs-Oper'!S23)))","v":370.0610712295861},{"$f":"N21*(1+(IF(ISBLANK('Inputs-Oper'!T23),'Inputs-Oper'!$I23,'Inputs-Oper'!T23)))","v":384.86351407876958},{"$f":"O21*(1+(IF(ISBLANK('Inputs-Oper'!U23),'Inputs-Oper'!$I23,'Inputs-Oper'!U23)))","v":400.25805464192035},{"$f":"P21*(1+(IF(ISBLANK('Inputs-Oper'!V23),'Inputs-Oper'!$I23,'Inputs-Oper'!V23)))","v":416.26837682759719},{"$f":"Q21*(1+(IF(ISBLANK('Inputs-Oper'!W23),'Inputs-Oper'!$I23,'Inputs-Oper'!W23)))","v":432.91911190070107},{"$f":"R21*(1+(IF(ISBLANK('Inputs-Oper'!X23),'Inputs-Oper'!$I23,'Inputs-Oper'!X23)))","v":450.23587637672915},{"$f":"S21*(1+(IF(ISBLANK('Inputs-Oper'!Y23),'Inputs-Oper'!$I23,'Inputs-Oper'!Y23)))","v":468.24531143179831},{"$f":"T21*(1+(IF(ISBLANK('Inputs-Oper'!Z23),'Inputs-Oper'!$I23,'Inputs-Oper'!Z23)))","v":486.97512388907029},{"$f":"U21*(1+(IF(ISBLANK('Inputs-Oper'!AA23),'Inputs-Oper'!$I23,'Inputs-Oper'!AA23)))","v":506.45412884463315},{"$f":"V21*(1+(IF(ISBLANK('Inputs-Oper'!AB23),'Inputs-Oper'!$I23,'Inputs-Oper'!AB23)))","v":526.71229399841855},{"$f":"W21*(1+(IF(ISBLANK('Inputs-Oper'!AC23),'Inputs-Oper'!$I23,'Inputs-Oper'!AC23)))","v":547.78078575835525}]
[null,{"$f":"OINCTYP4","v":"Miscellaneous"},null,{"$f":"OINC4","v":250},{"$f":"D22*(1+(IF(ISBLANK('Inputs-Oper'!J24),'Inputs-Oper'!$I24,'Inputs-Oper'!J24)))","v":260},{"$f":"E22*(1+(IF(ISBLANK('Inputs-Oper'!K24),'Inputs-Oper'!$I24,'Inputs-Oper'!K24)))","v":270.40000000000003},{"$f":"F22*(1+(IF(ISBLANK('Inputs-Oper'!L24),'Inputs-Oper'!$I24,'Inputs-Oper'!L24)))","v":281.21600000000007},{"$f":"G22*(1+(IF(ISBLANK('Inputs-Oper'!M24),'Inputs-Oper'!$I24,'Inputs-Oper'!M24)))","v":292.46464000000009},{"$f":"H22*(1+(IF(ISBLANK('Inputs-Oper'!N24),'Inputs-Oper'!$I24,'Inputs-Oper'!N24)))","v":304.16322560000009},{"$f":"I22*(1+(IF(ISBLANK('Inputs-Oper'!O24),'Inputs-Oper'!$I24,'Inputs-Oper'!O24)))","v":316.32975462400009},{"$f":"J22*(1+(IF(ISBLANK('Inputs-Oper'!P24),'Inputs-Oper'!$I24,'Inputs-Oper'!P24)))","v":328.9829448089601},{"$f":"K22*(1+(IF(ISBLANK('Inputs-Oper'!Q24),'Inputs-Oper'!$I24,'Inputs-Oper'!Q24)))","v":342.14226260131852},{"$f":"L22*(1+(IF(ISBLANK('Inputs-Oper'!R24),'Inputs-Oper'!$I24,'Inputs-Oper'!R24)))","v":355.82795310537125},{"$f":"M22*(1+(IF(ISBLANK('Inputs-Oper'!S24),'Inputs-Oper'!$I24,'Inputs-Oper'!S24)))","v":370.0610712295861},{"$f":"N22*(1+(IF(ISBLANK('Inputs-Oper'!T24),'Inputs-Oper'!$I24,'Inputs-Oper'!T24)))","v":384.86351407876958},{"$f":"O22*(1+(IF(ISBLANK('Inputs-Oper'!U24),'Inputs-Oper'!$I24,'Inputs-Oper'!U24)))","v":400.25805464192035},{"$f":"P22*(1+(IF(ISBLANK('Inputs-Oper'!V24),'Inputs-Oper'!$I24,'Inputs-Oper'!V24)))","v":416.26837682759719},{"$f":"Q22*(1+(IF(ISBLANK('Inputs-Oper'!W24),'Inputs-Oper'!$I24,'Inputs-Oper'!W24)))","v":432.91911190070107},{"$f":"R22*(1+(IF(ISBLANK('Inputs-Oper'!X24),'Inputs-Oper'!$I24,'Inputs-Oper'!X24)))","v":450.23587637672915},{"$f":"S22*(1+(IF(ISBLANK('Inputs-Oper'!Y24),'Inputs-Oper'!$I24,'Inputs-Oper'!Y24)))","v":468.24531143179831},{"$f":"T22*(1+(IF(ISBLANK('Inputs-Oper'!Z24),'Inputs-Oper'!$I24,'Inputs-Oper'!Z24)))","v":486.97512388907029},{"$f":"U22*(1+(IF(ISBLANK('Inputs-Oper'!AA24),'Inputs-Oper'!$I24,'Inputs-Oper'!AA24)))","v":506.45412884463315},{"$f":"V22*(1+(IF(ISBLANK('Inputs-Oper'!AB24),'Inputs-Oper'!$I24,'Inputs-Oper'!AB24)))","v":526.71229399841855},{"$f":"W22*(1+(IF(ISBLANK('Inputs-Oper'!AC24),'Inputs-Oper'!$I24,'Inputs-Oper'!AC24)))","v":547.78078575835525}]
["     Total",null,null,{"$f":"SUM(D19:D22)","v":1000},{"$f":"SUM(E19:E22)","v":1040},1081.6000000000001,1124.8640000000003,1169.8585600000004,1216.6529024000004,1265.3190184960004,1315.9317792358404,1368.5690504052741,1423.311812421485,1480.2442849183444,1539.4540563150783,1601.0322185676814,1665.0735073103888,1731.6764476028043,1800.9435055069166,1872.9812457271933,1947.9004955562812,2025.8165153785326,2106.8491759936742,2191.123143033421]
[]
["Potential Gross Income",null,null,{"$f":"D16+D23","v":740500},{"$f":"E16+E23","v":770120},800924.79999999993,832961.7919999999,866280.26367999997,900931.47422720015,936968.73319628811,974447.48252413957,1013425.3818251053,1053962.3970981094,1096120.8929820338,1139965.7287013154,1185564.3578493681,1232986.9321633426,1282306.4094498768,1333598.6658278718,1386942.6124609867,1442420.3169594258,1500117.1296378027,1560121.814823315,{"$f":"X16+X23","v":1622526.6874162478}]
[]
["Less: Vacancy and Collection"]
[null,"Rental Income",null,{"$f":"-D16*'Inputs-Oper'!G30","v":-36975},{"$f":"-E16*(IF(ISBLANK('Inputs-Oper'!J30),'Inputs-Oper'!$I30,'Inputs-Oper'!J30))","v":-38454},{"$f":"-F16*(IF(ISBLANK('Inputs-Oper'!K30),'Inputs-Oper'!$I30,'Inputs-Oper'!K30))","v":-39992.160000000003},{"$f":"-G16*(IF(ISBLANK('Inputs-Oper'!L30),'Inputs-Oper'!$I30,'Inputs-Oper'!L30))","v":-41591.846400000002},{"$f":"-H16*(IF(ISBLANK('Inputs-Oper'!M30),'Inputs-Oper'!$I30,'Inputs-Oper'!M30))","v":-43255.520256000003},{"$f":"-I16*(IF(ISBLANK('Inputs-Oper'!N30),'Inputs-Oper'!$I30,'Inputs-Oper'!N30))","v":-44985.741066240007},{"$f":"-J16*(IF(ISBLANK('Inputs-Oper'!O30),'Inputs-Oper'!$I30,'Inputs-Oper'!O30))","v":-46785.170708889607},{"$f":"-K16*(IF(ISBLANK('Inputs-Oper'!P30),'Inputs-Oper'!$I30,'Inputs-Oper'!P30))","v":-48656.57753724519},{"$f":"-L16*(IF(ISBLANK('Inputs-Oper'!Q30),'Inputs-Oper'!$I30,'Inputs-Oper'!Q30))","v":-50602.840638735004},{"$f":"-M16*(IF(ISBLANK('Inputs-Oper'!R30),'Inputs-Oper'!$I30,'Inputs-Oper'!R30))","v":-52626.954264284395},{"$f":"-N16*(IF(ISBLANK('Inputs-Oper'!S30),'Inputs-Oper'!$I30,'Inputs-Oper'!S30))","v":-54732.032434855777},{"$f":"-O16*(IF(ISBLANK('Inputs-Oper'!T30),'Inputs-Oper'!$I30,'Inputs-Oper'!T30))","v":-56921.313732250012},{"$f":"-P16*(IF(ISBLANK('Inputs-Oper'!U30),'Inputs-Oper'!$I30,'Inputs-Oper'!U30))","v":-59198.16628154002},{"$f":"-Q16*(IF(ISBLANK('Inputs-Oper'!V30),'Inputs-Oper'!$I30,'Inputs-Oper'!V30))","v":-61566.092932801614},{"$f":"-R16*(IF(ISBLANK('Inputs-Oper'!W30),'Inputs-Oper'!$I30,'Inputs-Oper'!W30))","v":-64028.736650113693},{"$f":"-S16*(IF(ISBLANK('Inputs-Oper'!X30),'Inputs-Oper'!$I30,'Inputs-Oper'!X30))","v":-66589.886116118243},{"$f":"-T16*(IF(ISBLANK('Inputs-Oper'!Y30),'Inputs-Oper'!$I30,'Inputs-Oper'!Y30))","v":-69253.481560762972},{"$f":"-U16*(IF(ISBLANK('Inputs-Oper'!Z30),'Inputs-Oper'!$I30,'Inputs-Oper'!Z30))","v":-72023.620823193487},{"$f":"-V16*(IF(ISBLANK('Inputs-Oper'!AA30),'Inputs-Oper'!$I30,'Inputs-Oper'!AA30))","v":-74904.565656121224},{"$f":"-W16*(IF(ISBLANK('Inputs-Oper'!AB30),'Inputs-Oper'!$I30,'Inputs-Oper'!AB30))","v":-77900.748282366068},{"$f":"-X16*(IF(ISBLANK('Inputs-Oper'!AC30),'Inputs-Oper'!$I30,'Inputs-Oper'!AC30))","v":-81016.778213660727}]
[null,"Other Income",null,{"$f":"-D23*'Inputs-Oper'!G31","v":-50},{"$f":"-E23*(IF(ISBLANK('Inputs-Oper'!J31),'Inputs-Oper'!$I31,'Inputs-Oper'!J31))","v":-52},{"$f":"-F23*(IF(ISBLANK('Inputs-Oper'!K31),'Inputs-Oper'!$I31,'Inputs-Oper'!K31))","v":-54.080000000000013},{"$f":"-G23*(IF(ISBLANK('Inputs-Oper'!L31),'Inputs-Oper'!$I31,'Inputs-Oper'!L31))","v":-56.243200000000016},{"$f":"-H23*(IF(ISBLANK('Inputs-Oper'!M31),'Inputs-Oper'!$I31,'Inputs-Oper'!M31))","v":-58.49292800000002},{"$f":"-I23*(IF(ISBLANK('Inputs-Oper'!N31),'Inputs-Oper'!$I31,'Inputs-Oper'!N31))","v":-60.832645120000024},{"$f":"-J23*(IF(ISBLANK('Inputs-Oper'!O31),'Inputs-Oper'!$I31,'Inputs-Oper'!O31))","v":-63.265950924800023},{"$f":"-K23*(IF(ISBLANK('Inputs-Oper'!P31),'Inputs-Oper'!$I31,'Inputs-Oper'!P31))","v":-65.796588961792025},{"$f":"-L23*(IF(ISBLANK('Inputs-Oper'!Q31),'Inputs-Oper'!$I31,'Inputs-Oper'!Q31))","v":-68.428452520263704},{"$f":"-M23*(IF(ISBLANK('Inputs-Oper'!R31),'Inputs-Oper'!$I31,'Inputs-Oper'!R31))","v":-71.165590621074259},{"$f":"-N23*(IF(ISBLANK('Inputs-Oper'!S31),'Inputs-Oper'!$I31,'Inputs-Oper'!S31))","v":-74.012214245917221},{"$f":"-O23*(IF(ISBLANK('Inputs-Oper'!T31),'Inputs-Oper'!$I31,'Inputs-Oper'!T31))","v":-76.972702815753919},{"$f":"-P23*(IF(ISBLANK('Inputs-Oper'!U31),'Inputs-Oper'!$I31,'Inputs-Oper'!U31))","v":-80.051610928384079},{"$f":"-Q23*(IF(ISBLANK('Inputs-Oper'!V31),'Inputs-Oper'!$I31,'Inputs-Oper'!V31))","v":-83.253675365519442},{"$f":"-R23*(IF(ISBLANK('Inputs-Oper'!W31),'Inputs-Oper'!$I31,'Inputs-Oper'!W31))","v":-86.583822380140219},{"$f":"-S23*(IF(ISBLANK('Inputs-Oper'!X31),'Inputs-Oper'!$I31,'Inputs-Oper'!X31))","v":-90.047175275345836},{"$f":"-T23*(IF(ISBLANK('Inputs-Oper'!Y31),'Inputs-Oper'!$I31,'Inputs-Oper'!Y31))","v":-93.649062286359666},{"$f":"-U23*(IF(ISBLANK('Inputs-Oper'!Z31),'Inputs-Oper'!$I31,'Inputs-Oper'!Z31))","v":-97.395024777814058},{"$f":"-V23*(IF(ISBLANK('Inputs-Oper'!AA31),'Inputs-Oper'!$I31,'Inputs-Oper'!AA31))","v":-101.29082576892664},{"$f":"-W23*(IF(ISBLANK('Inputs-Oper'!AB31),'Inputs-Oper'!$I31,'Inputs-Oper'!AB31))","v":-105.34245879968371},{"$f":"-X23*(IF(ISBLANK('Inputs-Oper'!AC31),'Inputs-Oper'!$I31,'Inputs-Oper'!AC31))","v":-109.55615715167106}]
["     Total",null,null,{"$f":"SUM(D28:D29)","v":-37025},{"$f":"SUM(E28:E29)","v":-38506},{"$f":"SUM(F28:F29)","v":-40046.240000000005},-41648.089599999999,-43314.013184000003,-45046.573711360004,-46848.436659814404,-48722.374126206982,-50671.269091255264,-52698.119854905468,-54806.044649101692,-56998.286435065762,-59278.217892468405,-61649.346608167136,-64115.320472493833,-66679.933291393594,-69347.130623049336,-72121.015847971299,-75005.85648189015,-78006.090741165754,-81126.334370812401]
[]
["Effective Gross Income",null,null,{"$f":"D25+D30","v":703475},{"$f":"E25+E30","v":731614},760878.55999999994,791313.70239999995,822966.25049599994,855884.90051584016,890120.29653647367,925725.10839793261,962754.11273385002,1001264.2772432039,1041314.8483329321,1082967.4422662496,1126286.1399568997,1171337.5855551756,1218191.088977383,1266918.7325364782,1317595.4818379374,1370299.3011114546,1425111.2731559125,1482115.7240821493,{"$f":"X25+X30","v":1541400.3530454354}]
[]
["OPERATING EXPENSES"]
[]
[null,{"$f":"'Inputs-Oper'!C36","v":"Utilities"},null,{"$f":"-'Inputs-Oper'!G36","v":-24000},{"$f":"D36*(1+(IF(ISBLANK('Inputs-Oper'!J36),'Inputs-Oper'!$I36,'Inputs-Oper'!J36)))","v":-24960},{"$f":"E36*(1+(IF(ISBLANK('Inputs-Oper'!K36),'Inputs-Oper'!$I36,'Inputs-Oper'!K36)))","v":-25958.400000000001},{"$f":"F36*(1+(IF(ISBLANK('Inputs-Oper'!L36),'Inputs-Oper'!$I36,'Inputs-Oper'!L36)))","v":-26996.736000000001},{"$f":"G36*(1+(IF(ISBLANK('Inputs-Oper'!M36),'Inputs-Oper'!$I36,'Inputs-Oper'!M36)))","v":-28076.605440000003},{"$f":"H36*(1+(IF(ISBLANK('Inputs-Oper'!N36),'Inputs-Oper'!$I36,'Inputs-Oper'!N36)))","v":-29199.669657600003},{"$f":"I36*(1+(IF(ISBLANK('Inputs-Oper'!O36),'Inputs-Oper'!$I36,'Inputs-Oper'!O36)))","v":-30367.656443904005},{"$f":"J36*(1+(IF(ISBLANK('Inputs-Oper'!P36),'Inputs-Oper'!$I36,'Inputs-Oper'!P36)))","v":-31582.362701660168},{"$f":"K36*(1+(IF(ISBLANK('Inputs-Oper'!Q36),'Inputs-Oper'!$I36,'Inputs-Oper'!Q36)))","v":-32845.657209726574},{"$f":"L36*(1+(IF(ISBLANK('Inputs-Oper'!R36),'Inputs-Oper'!$I36,'Inputs-Oper'!R36)))","v":-34159.483498115638},{"$f":"M36*(1+(IF(ISBLANK('Inputs-Oper'!S36),'Inputs-Oper'!$I36,'Inputs-Oper'!S36)))","v":-35525.862838040266},{"$f":"N36*(1+(IF(ISBLANK('Inputs-Oper'!T36),'Inputs-Oper'!$I36,'Inputs-Oper'!T36)))","v":-36946.897351561878},{"$f":"O36*(1+(IF(ISBLANK('Inputs-Oper'!U36),'Inputs-Oper'!$I36,'Inputs-Oper'!U36)))","v":-38424.773245624354},{"$f":"P36*(1+(IF(ISBLANK('Inputs-Oper'!V36),'Inputs-Oper'!$I36,'Inputs-Oper'!V36)))","v":-39961.764175449331},{"$f":"Q36*(1+(IF(ISBLANK('Inputs-Oper'!W36),'Inputs-Oper'!$I36,'Inputs-Oper'!W36)))","v":-41560.234742467306},{"$f":"R36*(1+(IF(ISBLANK('Inputs-Oper'!X36),'Inputs-Oper'!$I36,'Inputs-Oper'!X36)))","v":-43222.644132166002},{"$f":"S36*(1+(IF(ISBLANK('Inputs-Oper'!Y36),'Inputs-Oper'!$I36,'Inputs-Oper'!Y36)))","v":-44951.549897452642},{"$f":"T36*(1+(IF(ISBLANK('Inputs-Oper'!Z36),'Inputs-Oper'!$I36,'Inputs-Oper'!Z36)))","v":-46749.611893350746},{"$f":"U36*(1+(IF(ISBLANK('Inputs-Oper'!AA36),'Inputs-Oper'!$I36,'Inputs-Oper'!AA36)))","v":-48619.596369084778},{"$f":"V36*(1+(IF(ISBLANK('Inputs-Oper'!AB36),'Inputs-Oper'!$I36,'Inputs-Oper'!AB36)))","v":-50564.380223848173},{"$f":"W36*(1+(IF(ISBLANK('Inputs-Oper'!AC36),'Inputs-Oper'!$I36,'Inputs-Oper'!AC36)))","v":-52586.955432802104}]
[null,{"$f":"'Inputs-Oper'!C37","v":"Personnel"},null,{"$f":"-'Inputs-Oper'!G37","v":-18000},{"$f":"D37*(1+(IF(ISBLANK('Inputs-Oper'!J37),'Inputs-Oper'!$I37,'Inputs-Oper'!J37)))","v":-18720},{"$f":"E37*(1+(IF(ISBLANK('Inputs-Oper'!K37),'Inputs-Oper'!$I37,'Inputs-Oper'!K37)))","v":-19468.8},{"$f":"F37*(1+(IF(ISBLANK('Inputs-Oper'!L37),'Inputs-Oper'!$I37,'Inputs-Oper'!L37)))","v":-20247.552},{"$f":"G37*(1+(IF(ISBLANK('Inputs-Oper'!M37),'Inputs-Oper'!$I37,'Inputs-Oper'!M37)))","v":-21057.45408},{"$f":"H37*(1+(IF(ISBLANK('Inputs-Oper'!N37),'Inputs-Oper'!$I37,'Inputs-Oper'!N37)))","v":-21899.752243200001},{"$f":"I37*(1+(IF(ISBLANK('Inputs-Oper'!O37),'Inputs-Oper'!$I37,'Inputs-Oper'!O37)))","v":-22775.742332928003},{"$f":"J37*(1+(IF(ISBLANK('Inputs-Oper'!P37),'Inputs-Oper'!$I37,'Inputs-Oper'!P37)))","v":-23686.772026245122},{"$f":"K37*(1+(IF(ISBLANK('Inputs-Oper'!Q37),'Inputs-Oper'!$I37,'Inputs-Oper'!Q37)))","v":-24634.242907294927},{"$f":"L37*(1+(IF(ISBLANK('Inputs-Oper'!R37),'Inputs-Oper'!$I37,'Inputs-Oper'!R37)))","v":-25619.612623586727},{"$f":"M37*(1+(IF(ISBLANK('Inputs-Oper'!S37),'Inputs-Oper'!$I37,'Inputs-Oper'!S37)))","v":-26644.397128530196},{"$f":"N37*(1+(IF(ISBLANK('Inputs-Oper'!T37),'Inputs-Oper'!$I37,'Inputs-Oper'!T37)))","v":-27710.173013671403},{"$f":"O37*(1+(IF(ISBLANK('Inputs-Oper'!U37),'Inputs-Oper'!$I37,'Inputs-Oper'!U37)))","v":-28818.579934218262},{"$f":"P37*(1+(IF(ISBLANK('Inputs-Oper'!V37),'Inputs-Oper'!$I37,'Inputs-Oper'!V37)))","v":-29971.323131586993},{"$f":"Q37*(1+(IF(ISBLANK('Inputs-Oper'!W37),'Inputs-Oper'!$I37,'Inputs-Oper'!W37)))","v":-31170.176056850472},{"$f":"R37*(1+(IF(ISBLANK('Inputs-Oper'!X37),'Inputs-Oper'!$I37,'Inputs-Oper'!X37)))","v":-32416.983099124493},{"$f":"S37*(1+(IF(ISBLANK('Inputs-Oper'!Y37),'Inputs-Oper'!$I37,'Inputs-Oper'!Y37)))","v":-33713.662423089474},{"$f":"T37*(1+(IF(ISBLANK('Inputs-Oper'!Z37),'Inputs-Oper'!$I37,'Inputs-Oper'!Z37)))","v":-35062.208920013058},{"$f":"U37*(1+(IF(ISBLANK('Inputs-Oper'!AA37),'Inputs-Oper'!$I37,'Inputs-Oper'!AA37)))","v":-36464.697276813582},{"$f":"V37*(1+(IF(ISBLANK('Inputs-Oper'!AB37),'Inputs-Oper'!$I37,'Inputs-Oper'!AB37)))","v":-37923.285167886126},{"$f":"W37*(1+(IF(ISBLANK('Inputs-Oper'!AC37),'Inputs-Oper'!$I37,'Inputs-Oper'!AC37)))","v":-39440.216574601574}]
[null,{"$f":"'Inputs-Oper'!C38","v":"Rubbish Removal"},null,{"$f":"-'Inputs-Oper'!G38","v":-8500},{"$f":"D38*(1+(IF(ISBLANK('Inputs-Oper'!J38),'Inputs-Oper'!$I38,'Inputs-Oper'!J38)))","v":-8840},{"$f":"E38*(1+(IF(ISBLANK('Inputs-Oper'!K38),'Inputs-Oper'!$I38,'Inputs-Oper'!K38)))","v":-9193.6},{"$f":"F38*(1+(IF(ISBLANK('Inputs-Oper'!L38),'Inputs-Oper'!$I38,'Inputs-Oper'!L38)))","v":-9561.344000000001},{"$f":"G38*(1+(IF(ISBLANK('Inputs-Oper'!M38),'Inputs-Oper'!$I38,'Inputs-Oper'!M38)))","v":-9943.7977600000013},{"$f":"H38*(1+(IF(ISBLANK('Inputs-Oper'!N38),'Inputs-Oper'!$I38,'Inputs-Oper'!N38)))","v":-10341.549670400002},{"$f":"I38*(1+(IF(ISBLANK('Inputs-Oper'!O38),'Inputs-Oper'!$I38,'Inputs-Oper'!O38)))","v":-10755.211657216001},{"$f":"J38*(1+(IF(ISBLANK('Inputs-Oper'!P38),'Inputs-Oper'!$I38,'Inputs-Oper'!P38)))","v":-11185.420123504642},{"$f":"K38*(1+(IF(ISBLANK('Inputs-Oper'!Q38),'Inputs-Oper'!$I38,'Inputs-Oper'!Q38)))","v":-11632.836928444829},{"$f":"L38*(1+(IF(ISBLANK('Inputs-Oper'!R38),'Inputs-Oper'!$I38,'Inputs-Oper'!R38)))","v":-12098.150405582623},{"$f":"M38*(1+(IF(ISBLANK('Inputs-Oper'!S38),'Inputs-Oper'!$I38,'Inputs-Oper'!S38)))","v":-12582.076421805928},{"$f":"N38*(1+(IF(ISBLANK('Inputs-Oper'!T38),'Inputs-Oper'!$I38,'Inputs-Oper'!T38)))","v":-13085.359478678167},{"$f":"O38*(1+(IF(ISBLANK('Inputs-Oper'!U38),'Inputs-Oper'!$I38,'Inputs-Oper'!U38)))","v":-13608.773857825294},{"$f":"P38*(1+(IF(ISBLANK('Inputs-Oper'!V38),'Inputs-Oper'!$I38,'Inputs-Oper'!V38)))","v":-14153.124812138307},{"$f":"Q38*(1+(IF(ISBLANK('Inputs-Oper'!W38),'Inputs-Oper'!$I38,'Inputs-Oper'!W38)))","v":-14719.24980462384},{"$f":"R38*(1+(IF(ISBLANK('Inputs-Oper'!X38),'Inputs-Oper'!$I38,'Inputs-Oper'!X38)))","v":-15308.019796808794},{"$f":"S38*(1+(IF(ISBLANK('Inputs-Oper'!Y38),'Inputs-Oper'!$I38,'Inputs-Oper'!Y38)))","v":-15920.340588681147},{"$f":"T38*(1+(IF(ISBLANK('Inputs-Oper'!Z38),'Inputs-Oper'!$I38,'Inputs-Oper'!Z38)))","v":-16557.154212228394},{"$f":"U38*(1+(IF(ISBLANK('Inputs-Oper'!AA38),'Inputs-Oper'!$I38,'Inputs-Oper'!AA38)))","v":-17219.440380717529},{"$f":"V38*(1+(IF(ISBLANK('Inputs-Oper'!AB38),'Inputs-Oper'!$I38,'Inputs-Oper'!AB38)))","v":-17908.21799594623},{"$f":"W38*(1+(IF(ISBLANK('Inputs-Oper'!AC38),'Inputs-Oper'!$I38,'Inputs-Oper'!AC38)))","v":-18624.546715784079}]
[null,{"$f":"'Inputs-Oper'!C39","v":"Grounds/park/Snow"},null,{"$f":"-'Inputs-Oper'!G39","v":-7200},{"$f":"D39*(1+(IF(ISBLANK('Inputs-Oper'!J39),'Inputs-Oper'!$I39,'Inputs-Oper'!J39)))","v":-7488},{"$f":"E39*(1+(IF(ISBLANK('Inputs-Oper'!K39),'Inputs-Oper'!$I39,'Inputs-Oper'!K39)))","v":-7787.52},{"$f":"F39*(1+(IF(ISBLANK('Inputs-Oper'!L39),'Inputs-Oper'!$I39,'Inputs-Oper'!L39)))","v":-8099.0208000000011},{"$f":"G39*(1+(IF(ISBLANK('Inputs-Oper'!M39),'Inputs-Oper'!$I39,'Inputs-Oper'!M39)))","v":-8422.9816320000009},{"$f":"H39*(1+(IF(ISBLANK('Inputs-Oper'!N39),'Inputs-Oper'!$I39,'Inputs-Oper'!N39)))","v":-8759.900897280002},{"$f":"I39*(1+(IF(ISBLANK('Inputs-Oper'!O39),'Inputs-Oper'!$I39,'Inputs-Oper'!O39)))","v":-9110.2969331712029},{"$f":"J39*(1+(IF(ISBLANK('Inputs-Oper'!P39),'Inputs-Oper'!$I39,'Inputs-Oper'!P39)))","v":-9474.7088104980521},{"$f":"K39*(1+(IF(ISBLANK('Inputs-Oper'!Q39),'Inputs-Oper'!$I39,'Inputs-Oper'!Q39)))","v":-9853.6971629179752},{"$f":"L39*(1+(IF(ISBLANK('Inputs-Oper'!R39),'Inputs-Oper'!$I39,'Inputs-Oper'!R39)))","v":-10247.845049434694},{"$f":"M39*(1+(IF(ISBLANK('Inputs-Oper'!S39),'Inputs-Oper'!$I39,'Inputs-Oper'!S39)))","v":-10657.758851412082},{"$f":"N39*(1+(IF(ISBLANK('Inputs-Oper'!T39),'Inputs-Oper'!$I39,'Inputs-Oper'!T39)))","v":-11084.069205468566},{"$f":"O39*(1+(IF(ISBLANK('Inputs-Oper'!U39),'Inputs-Oper'!$I39,'Inputs-Oper'!U39)))","v":-11527.431973687309},{"$f":"P39*(1+(IF(ISBLANK('Inputs-Oper'!V39),'Inputs-Oper'!$I39,'Inputs-Oper'!V39)))","v":-11988.529252634802},{"$f":"Q39*(1+(IF(ISBLANK('Inputs-Oper'!W39),'Inputs-Oper'!$I39,'Inputs-Oper'!W39)))","v":-12468.070422740195},{"$f":"R39*(1+(IF(ISBLANK('Inputs-Oper'!X39),'Inputs-Oper'!$I39,'Inputs-Oper'!X39)))","v":-12966.793239649804},{"$f":"S39*(1+(IF(ISBLANK('Inputs-Oper'!Y39),'Inputs-Oper'!$I39,'Inputs-Oper'!Y39)))","v":-13485.464969235796},{"$f":"T39*(1+(IF(ISBLANK('Inputs-Oper'!Z39),'Inputs-Oper'!$I39,'Inputs-Oper'!Z39)))","v":-14024.883568005229},{"$f":"U39*(1+(IF(ISBLANK('Inputs-Oper'!AA39),'Inputs-Oper'!$I39,'Inputs-Oper'!AA39)))","v":-14585.878910725438},{"$f":"V39*(1+(IF(ISBLANK('Inputs-Oper'!AB39),'Inputs-Oper'!$I39,'Inputs-Oper'!AB39)))","v":-15169.314067154455},{"$f":"W39*(1+(IF(ISBLANK('Inputs-Oper'!AC39),'Inputs-Oper'!$I39,'Inputs-Oper'!AC39)))","v":-15776.086629840634}]
[null,{"$f":"'Inputs-Oper'!C40","v":"Maintenance"},null,{"$f":"-'Inputs-Oper'!G40","v":-24000},{"$f":"D40*(1+(IF(ISBLANK('Inputs-Oper'!J40),'Inputs-Oper'!$I40,'Inputs-Oper'!J40)))","v":-24960},{"$f":"E40*(1+(IF(ISBLANK('Inputs-Oper'!K40),'Inputs-Oper'!$I40,'Inputs-Oper'!K40)))","v":-25958.400000000001},{"$f":"F40*(1+(IF(ISBLANK('Inputs-Oper'!L40),'Inputs-Oper'!$I40,'Inputs-Oper'!L40)))","v":-26996.736000000001},{"$f":"G40*(1+(IF(ISBLANK('Inputs-Oper'!M40),'Inputs-Oper'!$I40,'Inputs-Oper'!M40)))","v":-28076.605440000003},{"$f":"H40*(1+(IF(ISBLANK('Inputs-Oper'!N40),'Inputs-Oper'!$I40,'Inputs-Oper'!N40)))","v":-29199.669657600003},{"$f":"I40*(1+(IF(ISBLANK('Inputs-Oper'!O40),'Inputs-Oper'!$I40,'Inputs-Oper'!O40)))","v":-30367.656443904005},{"$f":"J40*(1+(IF(ISBLANK('Inputs-Oper'!P40),'Inputs-Oper'!$I40,'Inputs-Oper'!P40)))","v":-31582.362701660168},{"$f":"K40*(1+(IF(ISBLANK('Inputs-Oper'!Q40),'Inputs-Oper'!$I40,'Inputs-Oper'!Q40)))","v":-32845.657209726574},{"$f":"L40*(1+(IF(ISBLANK('Inputs-Oper'!R40),'Inputs-Oper'!$I40,'Inputs-Oper'!R40)))","v":-34159.483498115638},{"$f":"M40*(1+(IF(ISBLANK('Inputs-Oper'!S40),'Inputs-Oper'!$I40,'Inputs-Oper'!S40)))","v":-35525.862838040266},{"$f":"N40*(1+(IF(ISBLANK('Inputs-Oper'!T40),'Inputs-Oper'!$I40,'Inputs-Oper'!T40)))","v":-36946.897351561878},{"$f":"O40*(1+(IF(ISBLANK('Inputs-Oper'!U40),'Inputs-Oper'!$I40,'Inputs-Oper'!U40)))","v":-38424.773245624354},{"$f":"P40*(1+(IF(ISBLANK('Inputs-Oper'!V40),'Inputs-Oper'!$I40,'Inputs-Oper'!V40)))","v":-39961.764175449331},{"$f":"Q40*(1+(IF(ISBLANK('Inputs-Oper'!W40),'Inputs-Oper'!$I40,'Inputs-Oper'!W40)))","v":-41560.234742467306},{"$f":"R40*(1+(IF(ISBLANK('Inputs-Oper'!X40),'Inputs-Oper'!$I40,'Inputs-Oper'!X40)))","v":-43222.644132166002},{"$f":"S40*(1+(IF(ISBLANK('Inputs-Oper'!Y40),'Inputs-Oper'!$I40,'Inputs-Oper'!Y40)))","v":-44951.549897452642},{"$f":"T40*(1+(IF(ISBLANK('Inputs-Oper'!Z40),'Inputs-Oper'!$I40,'Inputs-Oper'!Z40)))","v":-46749.611893350746},{"$f":"U40*(1+(IF(ISBLANK('Inputs-Oper'!AA40),'Inputs-Oper'!$I40,'Inputs-Oper'!AA40)))","v":-48619.596369084778},{"$f":"V40*(1+(IF(ISBLANK('Inputs-Oper'!AB40),'Inputs-Oper'!$I40,'Inputs-Oper'!AB40)))","v":-50564.380223848173},{"$f":"W40*(1+(IF(ISBLANK('Inputs-Oper'!AC40),'Inputs-Oper'!$I40,'Inputs-Oper'!AC40)))","v":-52586.955432802104}]
[null,{"$f":"'Inputs-Oper'!C41","v":"Leasing Bonus"},null,{"$f":"-'Inputs-Oper'!G41","v":0},{"$f":"D41*(1+(IF(ISBLANK('Inputs-Oper'!J41),'Inputs-Oper'!$I41,'Inputs-Oper'!J41)))","v":0},{"$f":"E41*(1+(IF(ISBLANK('Inputs-Oper'!K41),'Inputs-Oper'!$I41,'Inputs-Oper'!K41)))","v":0},{"$f":"F41*(1+(IF(ISBLANK('Inputs-Oper'!L41),'Inputs-Oper'!$I41,'Inputs-Oper'!L41)))","v":0},{"$f":"G41*(1+(IF(ISBLANK('Inputs-Oper'!M41),'Inputs-Oper'!$I41,'Inputs-Oper'!M41)))","v":0},{"$f":"H41*(1+(IF(ISBLANK('Inputs-Oper'!N41),'Inputs-Oper'!$I41,'Inputs-Oper'!N41)))","v":0},{"$f":"I41*(1+(IF(ISBLANK('Inputs-Oper'!O41),'Inputs-Oper'!$I41,'Inputs-Oper'!O41)))","v":0},{"$f":"J41*(1+(IF(ISBLANK('Inputs-Oper'!P41),'Inputs-Oper'!$I41,'Inputs-Oper'!P41)))","v":0},{"$f":"K41*(1+(IF(ISBLANK('Inputs-Oper'!Q41),'Inputs-Oper'!$I41,'Inputs-Oper'!Q41)))","v":0},{"$f":"L41*(1+(IF(ISBLANK('Inputs-Oper'!R41),'Inputs-Oper'!$I41,'Inputs-Oper'!R41)))","v":0},{"$f":"M41*(1+(IF(ISBLANK('Inputs-Oper'!S41),'Inputs-Oper'!$I41,'Inputs-Oper'!S41)))","v":0},{"$f":"N41*(1+(IF(ISBLANK('Inputs-Oper'!T41),'Inputs-Oper'!$I41,'Inputs-Oper'!T41)))","v":0},{"$f":"O41*(1+(IF(ISBLANK('Inputs-Oper'!U41),'Inputs-Oper'!$I41,'Inputs-Oper'!U41)))","v":0},{"$f":"P41*(1+(IF(ISBLANK('Inputs-Oper'!V41),'Inputs-Oper'!$I41,'Inputs-Oper'!V41)))","v":0},{"$f":"Q41*(1+(IF(ISBLANK('Inputs-Oper'!W41),'Inputs-Oper'!$I41,'Inputs-Oper'!W41)))","v":0},{"$f":"R41*(1+(IF(ISBLANK('Inputs-Oper'!X41),'Inputs-Oper'!$I41,'Inputs-Oper'!X41)))","v":0},{"$f":"S41*(1+(IF(ISBLANK('Inputs-Oper'!Y41),'Inputs-Oper'!$I41,'Inputs-Oper'!Y41)))","v":0},{"$f":"T41*(1+(IF(ISBLANK('Inputs-Oper'!Z41),'Inputs-Oper'!$I41,'Inputs-Oper'!Z41)))","v":0},{"$f":"U41*(1+(IF(ISBLANK('Inputs-Oper'!AA41),'Inputs-Oper'!$I41,'Inputs-Oper'!AA41)))","v":0},{"$f":"V41*(1+(IF(ISBLANK('Inputs-Oper'!AB41),'Inputs-Oper'!$I41,'Inputs-Oper'!AB41)))","v":0},{"$f":"W41*(1+(IF(ISBLANK('Inputs-Oper'!AC41),'Inputs-Oper'!$I41,'Inputs-Oper'!AC41)))","v":0}]
[null,{"$f":"'Inputs-Oper'!C42","v":"Advertising"},null,{"$f":"-'Inputs-Oper'!G42","v":-10000},{"$f":"D42*(1+(IF(ISBLANK('Inputs-Oper'!J42),'Inputs-Oper'!$I42,'Inputs-Oper'!J42)))","v":-10400},{"$f":"E42*(1+(IF(ISBLANK('Inputs-Oper'!K42),'Inputs-Oper'!$I42,'Inputs-Oper'!K42)))","v":-10816},{"$f":"F42*(1+(IF(ISBLANK('Inputs-Oper'!L42),'Inputs-Oper'!$I42,'Inputs-Oper'!L42)))","v":-11248.640000000001},{"$f":"G42*(1+(IF(ISBLANK('Inputs-Oper'!M42),'Inputs-Oper'!$I42,'Inputs-Oper'!M42)))","v":-11698.585600000002},{"$f":"H42*(1+(IF(ISBLANK('Inputs-Oper'!N42),'Inputs-Oper'!$I42,'Inputs-Oper'!N42)))","v":-12166.529024000003},{"$f":"I42*(1+(IF(ISBLANK('Inputs-Oper'!O42),'Inputs-Oper'!$I42,'Inputs-Oper'!O42)))","v":-12653.190184960004},{"$f":"J42*(1+(IF(ISBLANK('Inputs-Oper'!P42),'Inputs-Oper'!$I42,'Inputs-Oper'!P42)))","v":-13159.317792358404},{"$f":"K42*(1+(IF(ISBLANK('Inputs-Oper'!Q42),'Inputs-Oper'!$I42,'Inputs-Oper'!Q42)))","v":-13685.690504052742},{"$f":"L42*(1+(IF(ISBLANK('Inputs-Oper'!R42),'Inputs-Oper'!$I42,'Inputs-Oper'!R42)))","v":-14233.118124214852},{"$f":"M42*(1+(IF(ISBLANK('Inputs-Oper'!S42),'Inputs-Oper'!$I42,'Inputs-Oper'!S42)))","v":-14802.442849183446},{"$f":"N42*(1+(IF(ISBLANK('Inputs-Oper'!T42),'Inputs-Oper'!$I42,'Inputs-Oper'!T42)))","v":-15394.540563150784},{"$f":"O42*(1+(IF(ISBLANK('Inputs-Oper'!U42),'Inputs-Oper'!$I42,'Inputs-Oper'!U42)))","v":-16010.322185676816},{"$f":"P42*(1+(IF(ISBLANK('Inputs-Oper'!V42),'Inputs-Oper'!$I42,'Inputs-Oper'!V42)))","v":-16650.73507310389},{"$f":"Q42*(1+(IF(ISBLANK('Inputs-Oper'!W42),'Inputs-Oper'!$I42,'Inputs-Oper'!W42)))","v":-17316.764476028045},{"$f":"R42*(1+(IF(ISBLANK('Inputs-Oper'!X42),'Inputs-Oper'!$I42,'Inputs-Oper'!X42)))","v":-18009.435055069167},{"$f":"S42*(1+(IF(ISBLANK('Inputs-Oper'!Y42),'Inputs-Oper'!$I42,'Inputs-Oper'!Y42)))","v":-18729.812457271935},{"$f":"T42*(1+(IF(ISBLANK('Inputs-Oper'!Z42),'Inputs-Oper'!$I42,'Inputs-Oper'!Z42)))","v":-19479.004955562814},{"$f":"U42*(1+(IF(ISBLANK('Inputs-Oper'!AA42),'Inputs-Oper'!$I42,'Inputs-Oper'!AA42)))","v":-20258.165153785329},{"$f":"V42*(1+(IF(ISBLANK('Inputs-Oper'!AB42),'Inputs-Oper'!$I42,'Inputs-Oper'!AB42)))","v":-21068.491759936744},{"$f":"W42*(1+(IF(ISBLANK('Inputs-Oper'!AC42),'Inputs-Oper'!$I42,'Inputs-Oper'!AC42)))","v":-21911.231430334214}]
[null,{"$f":"'Inputs-Oper'!C43","v":"Administration"},null,{"$f":"-'Inputs-Oper'!G43","v":-2000},{"$f":"D43*(1+(IF(ISBLANK('Inputs-Oper'!J43),'Inputs-Oper'!$I43,'Inputs-Oper'!J43)))","v":-2080},{"$f":"E43*(1+(IF(ISBLANK('Inputs-Oper'!K43),'Inputs-Oper'!$I43,'Inputs-Oper'!K43)))","v":-2163.2000000000003},{"$f":"F43*(1+(IF(ISBLANK('Inputs-Oper'!L43),'Inputs-Oper'!$I43,'Inputs-Oper'!L43)))","v":-2249.7280000000005},{"$f":"G43*(1+(IF(ISBLANK('Inputs-Oper'!M43),'Inputs-Oper'!$I43,'Inputs-Oper'!M43)))","v":-2339.7171200000007},{"$f":"H43*(1+(IF(ISBLANK('Inputs-Oper'!N43),'Inputs-Oper'!$I43,'Inputs-Oper'!N43)))","v":-2433.3058048000007},{"$f":"I43*(1+(IF(ISBLANK('Inputs-Oper'!O43),'Inputs-Oper'!$I43,'Inputs-Oper'!O43)))","v":-2530.6380369920007},{"$f":"J43*(1+(IF(ISBLANK('Inputs-Oper'!P43),'Inputs-Oper'!$I43,'Inputs-Oper'!P43)))","v":-2631.8635584716808},{"$f":"K43*(1+(IF(ISBLANK('Inputs-Oper'!Q43),'Inputs-Oper'!$I43,'Inputs-Oper'!Q43)))","v":-2737.1381008105482},{"$f":"L43*(1+(IF(ISBLANK('Inputs-Oper'!R43),'Inputs-Oper'!$I43,'Inputs-Oper'!R43)))","v":-2846.62362484297},{"$f":"M43*(1+(IF(ISBLANK('Inputs-Oper'!S43),'Inputs-Oper'!$I43,'Inputs-Oper'!S43)))","v":-2960.4885698366888},{"$f":"N43*(1+(IF(ISBLANK('Inputs-Oper'!T43),'Inputs-Oper'!$I43,'Inputs-Oper'!T43)))","v":-3078.9081126301567},{"$f":"O43*(1+(IF(ISBLANK('Inputs-Oper'!U43),'Inputs-Oper'!$I43,'Inputs-Oper'!U43)))","v":-3202.0644371353628},{"$f":"P43*(1+(IF(ISBLANK('Inputs-Oper'!V43),'Inputs-Oper'!$I43,'Inputs-Oper'!V43)))","v":-3330.1470146207776},{"$f":"Q43*(1+(IF(ISBLANK('Inputs-Oper'!W43),'Inputs-Oper'!$I43,'Inputs-Oper'!W43)))","v":-3463.3528952056085},{"$f":"R43*(1+(IF(ISBLANK('Inputs-Oper'!X43),'Inputs-Oper'!$I43,'Inputs-Oper'!X43)))","v":-3601.8870110138332},{"$f":"S43*(1+(IF(ISBLANK('Inputs-Oper'!Y43),'Inputs-Oper'!$I43,'Inputs-Oper'!Y43)))","v":-3745.9624914543865},{"$f":"T43*(1+(IF(ISBLANK('Inputs-Oper'!Z43),'Inputs-Oper'!$I43,'Inputs-Oper'!Z43)))","v":-3895.8009911125623},{"$f":"U43*(1+(IF(ISBLANK('Inputs-Oper'!AA43),'Inputs-Oper'!$I43,'Inputs-Oper'!AA43)))","v":-4051.6330307570652},{"$f":"V43*(1+(IF(ISBLANK('Inputs-Oper'!AB43),'Inputs-Oper'!$I43,'Inputs-Oper'!AB43)))","v":-4213.6983519873484},{"$f":"W43*(1+(IF(ISBLANK('Inputs-Oper'!AC43),'Inputs-Oper'!$I43,'Inputs-Oper'!AC43)))","v":-4382.246286066842}]
[null,{"$f":"'Inputs-Oper'!C44","v":"Telephone"},null,{"$f":"-'Inputs-Oper'!G44","v":-1800},{"$f":"D44*(1+(IF(ISBLANK('Inputs-Oper'!J44),'Inputs-Oper'!$I44,'Inputs-Oper'!J44)))","v":-1872},{"$f":"E44*(1+(IF(ISBLANK('Inputs-Oper'!K44),'Inputs-Oper'!$I44,'Inputs-Oper'!K44)))","v":-1946.88},{"$f":"F44*(1+(IF(ISBLANK('Inputs-Oper'!L44),'Inputs-Oper'!$I44,'Inputs-Oper'!L44)))","v":-2024.7552000000003},{"$f":"G44*(1+(IF(ISBLANK('Inputs-Oper'!M44),'Inputs-Oper'!$I44,'Inputs-Oper'!M44)))","v":-2105.7454080000002},{"$f":"H44*(1+(IF(ISBLANK('Inputs-Oper'!N44),'Inputs-Oper'!$I44,'Inputs-Oper'!N44)))","v":-2189.9752243200005},{"$f":"I44*(1+(IF(ISBLANK('Inputs-Oper'!O44),'Inputs-Oper'!$I44,'Inputs-Oper'!O44)))","v":-2277.5742332928007},{"$f":"J44*(1+(IF(ISBLANK('Inputs-Oper'!P44),'Inputs-Oper'!$I44,'Inputs-Oper'!P44)))","v":-2368.677202624513},{"$f":"K44*(1+(IF(ISBLANK('Inputs-Oper'!Q44),'Inputs-Oper'!$I44,'Inputs-Oper'!Q44)))","v":-2463.4242907294938},{"$f":"L44*(1+(IF(ISBLANK('Inputs-Oper'!R44),'Inputs-Oper'!$I44,'Inputs-Oper'!R44)))","v":-2561.9612623586736},{"$f":"M44*(1+(IF(ISBLANK('Inputs-Oper'!S44),'Inputs-Oper'!$I44,'Inputs-Oper'!S44)))","v":-2664.4397128530204},{"$f":"N44*(1+(IF(ISBLANK('Inputs-Oper'!T44),'Inputs-Oper'!$I44,'Inputs-Oper'!T44)))","v":-2771.0173013671415},{"$f":"O44*(1+(IF(ISBLANK('Inputs-Oper'!U44),'Inputs-Oper'!$I44,'Inputs-Oper'!U44)))","v":-2881.8579934218274},{"$f":"P44*(1+(IF(ISBLANK('Inputs-Oper'!V44),'Inputs-Oper'!$I44,'Inputs-Oper'!V44)))","v":-2997.1323131587005},{"$f":"Q44*(1+(IF(ISBLANK('Inputs-Oper'!W44),'Inputs-Oper'!$I44,'Inputs-Oper'!W44)))","v":-3117.0176056850487},{"$f":"R44*(1+(IF(ISBLANK('Inputs-Oper'!X44),'Inputs-Oper'!$I44,'Inputs-Oper'!X44)))","v":-3241.6983099124509},{"$f":"S44*(1+(IF(ISBLANK('Inputs-Oper'!Y44),'Inputs-Oper'!$I44,'Inputs-Oper'!Y44)))","v":-3371.366242308949},{"$f":"T44*(1+(IF(ISBLANK('Inputs-Oper'!Z44),'Inputs-Oper'!$I44,'Inputs-Oper'!Z44)))","v":-3506.2208920013072},{"$f":"U44*(1+(IF(ISBLANK('Inputs-Oper'!AA44),'Inputs-Oper'!$I44,'Inputs-Oper'!AA44)))","v":-3646.4697276813595},{"$f":"V44*(1+(IF(ISBLANK('Inputs-Oper'!AB44),'Inputs-Oper'!$I44,'Inputs-Oper'!AB44)))","v":-3792.3285167886138},{"$f":"W44*(1+(IF(ISBLANK('Inputs-Oper'!AC44),'Inputs-Oper'!$I44,'Inputs-Oper'!AC44)))","v":-3944.0216574601586}]
[null,{"$f":"'Inputs-Oper'!C45","v":"Insurance"},null,{"$f":"-'Inputs-Oper'!G45","v":-7800},{"$f":"D45*(1+(IF(ISBLANK('Inputs-Oper'!J45),'Inputs-Oper'!$I45,'Inputs-Oper'!J45)))","v":-8112},{"$f":"E45*(1+(IF(ISBLANK('Inputs-Oper'!K45),'Inputs-Oper'!$I45,'Inputs-Oper'!K45)))","v":-8436.48},{"$f":"F45*(1+(IF(ISBLANK('Inputs-Oper'!L45),'Inputs-Oper'!$I45,'Inputs-Oper'!L45)))","v":-8773.9392000000007},{"$f":"G45*(1+(IF(ISBLANK('Inputs-Oper'!M45),'Inputs-Oper'!$I45,'Inputs-Oper'!M45)))","v":-9124.8967680000005},{"$f":"H45*(1+(IF(ISBLANK('Inputs-Oper'!N45),'Inputs-Oper'!$I45,'Inputs-Oper'!N45)))","v":-9489.8926387200008},{"$f":"I45*(1+(IF(ISBLANK('Inputs-Oper'!O45),'Inputs-Oper'!$I45,'Inputs-Oper'!O45)))","v":-9869.4883442688006},{"$f":"J45*(1+(IF(ISBLANK('Inputs-Oper'!P45),'Inputs-Oper'!$I45,'Inputs-Oper'!P45)))","v":-10264.267878039553},{"$f":"K45*(1+(IF(ISBLANK('Inputs-Oper'!Q45),'Inputs-Oper'!$I45,'Inputs-Oper'!Q45)))","v":-10674.838593161136},{"$f":"L45*(1+(IF(ISBLANK('Inputs-Oper'!R45),'Inputs-Oper'!$I45,'Inputs-Oper'!R45)))","v":-11101.832136887582},{"$f":"M45*(1+(IF(ISBLANK('Inputs-Oper'!S45),'Inputs-Oper'!$I45,'Inputs-Oper'!S45)))","v":-11545.905422363086},{"$f":"N45*(1+(IF(ISBLANK('Inputs-Oper'!T45),'Inputs-Oper'!$I45,'Inputs-Oper'!T45)))","v":-12007.741639257611},{"$f":"O45*(1+(IF(ISBLANK('Inputs-Oper'!U45),'Inputs-Oper'!$I45,'Inputs-Oper'!U45)))","v":-12488.051304827915},{"$f":"P45*(1+(IF(ISBLANK('Inputs-Oper'!V45),'Inputs-Oper'!$I45,'Inputs-Oper'!V45)))","v":-12987.573357021032},{"$f":"Q45*(1+(IF(ISBLANK('Inputs-Oper'!W45),'Inputs-Oper'!$I45,'Inputs-Oper'!W45)))","v":-13507.076291301873},{"$f":"R45*(1+(IF(ISBLANK('Inputs-Oper'!X45),'Inputs-Oper'!$I45,'Inputs-Oper'!X45)))","v":-14047.359342953949},{"$f":"S45*(1+(IF(ISBLANK('Inputs-Oper'!Y45),'Inputs-Oper'!$I45,'Inputs-Oper'!Y45)))","v":-14609.253716672107},{"$f":"T45*(1+(IF(ISBLANK('Inputs-Oper'!Z45),'Inputs-Oper'!$I45,'Inputs-Oper'!Z45)))","v":-15193.623865338992},{"$f":"U45*(1+(IF(ISBLANK('Inputs-Oper'!AA45),'Inputs-Oper'!$I45,'Inputs-Oper'!AA45)))","v":-15801.368819952551},{"$f":"V45*(1+(IF(ISBLANK('Inputs-Oper'!AB45),'Inputs-Oper'!$I45,'Inputs-Oper'!AB45)))","v":-16433.423572750653},{"$f":"W45*(1+(IF(ISBLANK('Inputs-Oper'!AC45),'Inputs-Oper'!$I45,'Inputs-Oper'!AC45)))","v":-17090.760515660681}]
[null,{"$f":"'Inputs-Oper'!C46","v":"Taxes"},null,{"$f":"-'Inputs-Oper'!G46","v":-150000},{"$f":"D46*(1+(IF(ISBLANK('Inputs-Oper'!J46),'Inputs-Oper'!$I46,'Inputs-Oper'!J46)))","v":-156000},{"$f":"E46*(1+(IF(ISBLANK('Inputs-Oper'!K46),'Inputs-Oper'!$I46,'Inputs-Oper'!K46)))","v":-162240},{"$f":"F46*(1+(IF(ISBLANK('Inputs-Oper'!L46),'Inputs-Oper'!$I46,'Inputs-Oper'!L46)))","v":-168729.60000000001},{"$f":"G46*(1+(IF(ISBLANK('Inputs-Oper'!M46),'Inputs-Oper'!$I46,'Inputs-Oper'!M46)))","v":-175478.78400000001},{"$f":"H46*(1+(IF(ISBLANK('Inputs-Oper'!N46),'Inputs-Oper'!$I46,'Inputs-Oper'!N46)))","v":-182497.93536000003},{"$f":"I46*(1+(IF(ISBLANK('Inputs-Oper'!O46),'Inputs-Oper'!$I46,'Inputs-Oper'!O46)))","v":-189797.85277440003},{"$f":"J46*(1+(IF(ISBLANK('Inputs-Oper'!P46),'Inputs-Oper'!$I46,'Inputs-Oper'!P46)))","v":-197389.76688537604},{"$f":"K46*(1+(IF(ISBLANK('Inputs-Oper'!Q46),'Inputs-Oper'!$I46,'Inputs-Oper'!Q46)))","v":-205285.35756079108},{"$f":"L46*(1+(IF(ISBLANK('Inputs-Oper'!R46),'Inputs-Oper'!$I46,'Inputs-Oper'!R46)))","v":-213496.77186322273},{"$f":"M46*(1+(IF(ISBLANK('Inputs-Oper'!S46),'Inputs-Oper'!$I46,'Inputs-Oper'!S46)))","v":-222036.64273775165},{"$f":"N46*(1+(IF(ISBLANK('Inputs-Oper'!T46),'Inputs-Oper'!$I46,'Inputs-Oper'!T46)))","v":-230918.10844726174},{"$f":"O46*(1+(IF(ISBLANK('Inputs-Oper'!U46),'Inputs-Oper'!$I46,'Inputs-Oper'!U46)))","v":-240154.83278515222},{"$f":"P46*(1+(IF(ISBLANK('Inputs-Oper'!V46),'Inputs-Oper'!$I46,'Inputs-Oper'!V46)))","v":-249761.02609655831},{"$f":"Q46*(1+(IF(ISBLANK('Inputs-Oper'!W46),'Inputs-Oper'!$I46,'Inputs-Oper'!W46)))","v":-259751.46714042066},{"$f":"R46*(1+(IF(ISBLANK('Inputs-Oper'!X46),'Inputs-Oper'!$I46,'Inputs-Oper'!X46)))","v":-270141.52582603751},{"$f":"S46*(1+(IF(ISBLANK('Inputs-Oper'!Y46),'Inputs-Oper'!$I46,'Inputs-Oper'!Y46)))","v":-280947.186859079},{"$f":"T46*(1+(IF(ISBLANK('Inputs-Oper'!Z46),'Inputs-Oper'!$I46,'Inputs-Oper'!Z46)))","v":-292185.07433344214},{"$f":"U46*(1+(IF(ISBLANK('Inputs-Oper'!AA46),'Inputs-Oper'!$I46,'Inputs-Oper'!AA46)))","v":-303872.47730677982},{"$f":"V46*(1+(IF(ISBLANK('Inputs-Oper'!AB46),'Inputs-Oper'!$I46,'Inputs-Oper'!AB46)))","v":-316027.37639905105},{"$f":"W46*(1+(IF(ISBLANK('Inputs-Oper'!AC46),'Inputs-Oper'!$I46,'Inputs-Oper'!AC46)))","v":-328668.47145501309}]
[null,{"$f":"'Inputs-Oper'!C47","v":"PM Fee"},null,{"$f":"-'Inputs-Oper'!G47","v":-40000},{"$f":"D47*(1+(IF(ISBLANK('Inputs-Oper'!J47),'Inputs-Oper'!$I47,'Inputs-Oper'!J47)))","v":-41600},{"$f":"E47*(1+(IF(ISBLANK('Inputs-Oper'!K47),'Inputs-Oper'!$I47,'Inputs-Oper'!K47)))","v":-43264},{"$f":"F47*(1+(IF(ISBLANK('Inputs-Oper'!L47),'Inputs-Oper'!$I47,'Inputs-Oper'!L47)))","v":-44994.560000000005},{"$f":"G47*(1+(IF(ISBLANK('Inputs-Oper'!M47),'Inputs-Oper'!$I47,'Inputs-Oper'!M47)))","v":-46794.342400000009},{"$f":"H47*(1+(IF(ISBLANK('Inputs-Oper'!N47),'Inputs-Oper'!$I47,'Inputs-Oper'!N47)))","v":-48666.116096000012},{"$f":"I47*(1+(IF(ISBLANK('Inputs-Oper'!O47),'Inputs-Oper'!$I47,'Inputs-Oper'!O47)))","v":-50612.760739840014},{"$f":"J47*(1+(IF(ISBLANK('Inputs-Oper'!P47),'Inputs-Oper'!$I47,'Inputs-Oper'!P47)))","v":-52637.271169433618},{"$f":"K47*(1+(IF(ISBLANK('Inputs-Oper'!Q47),'Inputs-Oper'!$I47,'Inputs-Oper'!Q47)))","v":-54742.762016210967},{"$f":"L47*(1+(IF(ISBLANK('Inputs-Oper'!R47),'Inputs-Oper'!$I47,'Inputs-Oper'!R47)))","v":-56932.472496859409},{"$f":"M47*(1+(IF(ISBLANK('Inputs-Oper'!S47),'Inputs-Oper'!$I47,'Inputs-Oper'!S47)))","v":-59209.771396733784},{"$f":"N47*(1+(IF(ISBLANK('Inputs-Oper'!T47),'Inputs-Oper'!$I47,'Inputs-Oper'!T47)))","v":-61578.162252603135},{"$f":"O47*(1+(IF(ISBLANK('Inputs-Oper'!U47),'Inputs-Oper'!$I47,'Inputs-Oper'!U47)))","v":-64041.288742707264},{"$f":"P47*(1+(IF(ISBLANK('Inputs-Oper'!V47),'Inputs-Oper'!$I47,'Inputs-Oper'!V47)))","v":-66602.940292415558},{"$f":"Q47*(1+(IF(ISBLANK('Inputs-Oper'!W47),'Inputs-Oper'!$I47,'Inputs-Oper'!W47)))","v":-69267.057904112182},{"$f":"R47*(1+(IF(ISBLANK('Inputs-Oper'!X47),'Inputs-Oper'!$I47,'Inputs-Oper'!X47)))","v":-72037.740220276668},{"$f":"S47*(1+(IF(ISBLANK('Inputs-Oper'!Y47),'Inputs-Oper'!$I47,'Inputs-Oper'!Y47)))","v":-74919.249829087741},{"$f":"T47*(1+(IF(ISBLANK('Inputs-Oper'!Z47),'Inputs-Oper'!$I47,'Inputs-Oper'!Z47)))","v":-77916.019822251255},{"$f":"U47*(1+(IF(ISBLANK('Inputs-Oper'!AA47),'Inputs-Oper'!$I47,'Inputs-Oper'!AA47)))","v":-81032.660615141314},{"$f":"V47*(1+(IF(ISBLANK('Inputs-Oper'!AB47),'Inputs-Oper'!$I47,'Inputs-Oper'!AB47)))","v":-84273.967039746974},{"$f":"W47*(1+(IF(ISBLANK('Inputs-Oper'!AC47),'Inputs-Oper'!$I47,'Inputs-Oper'!AC47)))","v":-87644.925721336855}]
[null,{"$f":"'Inputs-Oper'!C48","v":"Legal"},null,{"$f":"-'Inputs-Oper'!G48","v":-1800},{"$f":"D48*(1+(IF(ISBLANK('Inputs-Oper'!J48),'Inputs-Oper'!$I48,'Inputs-Oper'!J48)))","v":-1872},{"$f":"E48*(1+(IF(ISBLANK('Inputs-Oper'!K48),'Inputs-Oper'!$I48,'Inputs-Oper'!K48)))","v":-1946.88},{"$f":"F48*(1+(IF(ISBLANK('Inputs-Oper'!L48),'Inputs-Oper'!$I48,'Inputs-Oper'!L48)))","v":-2024.7552000000003},{"$f":"G48*(1+(IF(ISBLANK('Inputs-Oper'!M48),'Inputs-Oper'!$I48,'Inputs-Oper'!M48)))","v":-2105.7454080000002},{"$f":"H48*(1+(IF(ISBLANK('Inputs-Oper'!N48),'Inputs-Oper'!$I48,'Inputs-Oper'!N48)))","v":-2189.9752243200005},{"$f":"I48*(1+(IF(ISBLANK('Inputs-Oper'!O48),'Inputs-Oper'!$I48,'Inputs-Oper'!O48)))","v":-2277.5742332928007},{"$f":"J48*(1+(IF(ISBLANK('Inputs-Oper'!P48),'Inputs-Oper'!$I48,'Inputs-Oper'!P48)))","v":-2368.677202624513},{"$f":"K48*(1+(IF(ISBLANK('Inputs-Oper'!Q48),'Inputs-Oper'!$I48,'Inputs-Oper'!Q48)))","v":-2463.4242907294938},{"$f":"L48*(1+(IF(ISBLANK('Inputs-Oper'!R48),'Inputs-Oper'!$I48,'Inputs-Oper'!R48)))","v":-2561.9612623586736},{"$f":"M48*(1+(IF(ISBLANK('Inputs-Oper'!S48),'Inputs-Oper'!$I48,'Inputs-Oper'!S48)))","v":-2664.4397128530204},{"$f":"N48*(1+(IF(ISBLANK('Inputs-Oper'!T48),'Inputs-Oper'!$I48,'Inputs-Oper'!T48)))","v":-2771.0173013671415},{"$f":"O48*(1+(IF(ISBLANK('Inputs-Oper'!U48),'Inputs-Oper'!$I48,'Inputs-Oper'!U48)))","v":-2881.8579934218274},{"$f":"P48*(1+(IF(ISBLANK('Inputs-Oper'!V48),'Inputs-Oper'!$I48,'Inputs-Oper'!V48)))","v":-2997.1323131587005},{"$f":"Q48*(1+(IF(ISBLANK('Inputs-Oper'!W48),'Inputs-Oper'!$I48,'Inputs-Oper'!W48)))","v":-3117.0176056850487},{"$f":"R48*(1+(IF(ISBLANK('Inputs-Oper'!X48),'Inputs-Oper'!$I48,'Inputs-Oper'!X48)))","v":-3241.6983099124509},{"$f":"S48*(1+(IF(ISBLANK('Inputs-Oper'!Y48),'Inputs-Oper'!$I48,'Inputs-Oper'!Y48)))","v":-3371.366242308949},{"$f":"T48*(1+(IF(ISBLANK('Inputs-Oper'!Z48),'Inputs-Oper'!$I48,'Inputs-Oper'!Z48)))","v":-3506.2208920013072},{"$f":"U48*(1+(IF(ISBLANK('Inputs-Oper'!AA48),'Inputs-Oper'!$I48,'Inputs-Oper'!AA48)))","v":-3646.4697276813595},{"$f":"V48*(1+(IF(ISBLANK('Inputs-Oper'!AB48),'Inputs-Oper'!$I48,'Inputs-Oper'!AB48)))","v":-3792.3285167886138},{"$f":"W48*(1+(IF(ISBLANK('Inputs-Oper'!AC48),'Inputs-Oper'!$I48,'Inputs-Oper'!AC48)))","v":-3944.0216574601586}]
[null,{"$f":"'Inputs-Oper'!C49","v":"Accounting"},null,{"$f":"-'Inputs-Oper'!G49","v":-2000},{"$f":"D49*(1+(IF(ISBLANK('Inputs-Oper'!J49),'Inputs-Oper'!$I49,'Inputs-Oper'!J49)))","v":-2080},{"$f":"E49*(1+(IF(ISBLANK('Inputs-Oper'!K49),'Inputs-Oper'!$I49,'Inputs-Oper'!K49)))","v":-2163.2000000000003},{"$f":"F49*(1+(IF(ISBLANK('Inputs-Oper'!L49),'Inputs-Oper'!$I49,'Inputs-Oper'!L49)))","v":-2249.7280000000005},{"$f":"G49*(1+(IF(ISBLANK('Inputs-Oper'!M49),'Inputs-Oper'!$I49,'Inputs-Oper'!M49)))","v":-2339.7171200000007},{"$f":"H49*(1+(IF(ISBLANK('Inputs-Oper'!N49),'Inputs-Oper'!$I49,'Inputs-Oper'!N49)))","v":-2433.3058048000007},{"$f":"I49*(1+(IF(ISBLANK('Inputs-Oper'!O49),'Inputs-Oper'!$I49,'Inputs-Oper'!O49)))","v":-2530.6380369920007},{"$f":"J49*(1+(IF(ISBLANK('Inputs-Oper'!P49),'Inputs-Oper'!$I49,'Inputs-Oper'!P49)))","v":-2631.8635584716808},{"$f":"K49*(1+(IF(ISBLANK('Inputs-Oper'!Q49),'Inputs-Oper'!$I49,'Inputs-Oper'!Q49)))","v":-2737.1381008105482},{"$f":"L49*(1+(IF(ISBLANK('Inputs-Oper'!R49),'Inputs-Oper'!$I49,'Inputs-Oper'!R49)))","v":-2846.62362484297},{"$f":"M49*(1+(IF(ISBLANK('Inputs-Oper'!S49),'Inputs-Oper'!$I49,'Inputs-Oper'!S49)))","v":-2960.4885698366888},{"$f":"N49*(1+(IF(ISBLANK('Inputs-Oper'!T49),'Inputs-Oper'!$I49,'Inputs-Oper'!T49)))","v":-3078.9081126301567},{"$f":"O49*(1+(IF(ISBLANK('Inputs-Oper'!U49),'Inputs-Oper'!$I49,'Inputs-Oper'!U49)))","v":-3202.0644371353628},{"$f":"P49*(1+(IF(ISBLANK('Inputs-Oper'!V49),'Inputs-Oper'!$I49,'Inputs-Oper'!V49)))","v":-3330.1470146207776},{"$f":"Q49*(1+(IF(ISBLANK('Inputs-Oper'!W49),'Inputs-Oper'!$I49,'Inputs-Oper'!W49)))","v":-3463.3528952056085},{"$f":"R49*(1+(IF(ISBLANK('Inputs-Oper'!X49),'Inputs-Oper'!$I49,'Inputs-Oper'!X49)))","v":-3601.8870110138332},{"$f":"S49*(1+(IF(ISBLANK('Inputs-Oper'!Y49),'Inputs-Oper'!$I49,'Inputs-Oper'!Y49)))","v":-3745.9624914543865},{"$f":"T49*(1+(IF(ISBLANK('Inputs-Oper'!Z49),'Inputs-Oper'!$I49,'Inputs-Oper'!Z49)))","v":-3895.8009911125623},{"$f":"U49*(1+(IF(ISBLANK('Inputs-Oper'!AA49),'Inputs-Oper'!$I49,'Inputs-Oper'!AA49)))","v":-4051.6330307570652},{"$f":"V49*(1+(IF(ISBLANK('Inputs-Oper'!AB49),'Inputs-Oper'!$I49,'Inputs-Oper'!AB49)))","v":-4213.6983519873484},{"$f":"W49*(1+(IF(ISBLANK('Inputs-Oper'!AC49),'Inputs-Oper'!$I49,'Inputs-Oper'!AC49)))","v":-4382.246286066842}]
[null,{"$f":"'Inputs-Oper'!C50","v":"Reserves"},null,{"$f":"-'Inputs-Oper'!G50","v":-7920},{"$f":"D50*(1+(IF(ISBLANK('Inputs-Oper'!J50),'Inputs-Oper'!$I50,'Inputs-Oper'!J50)))","v":-8236.8000000000011},{"$f":"E50*(1+(IF(ISBLANK('Inputs-Oper'!K50),'Inputs-Oper'!$I50,'Inputs-Oper'!K50)))","v":-8566.2720000000008},{"$f":"F50*(1+(IF(ISBLANK('Inputs-Oper'!L50),'Inputs-Oper'!$I50,'Inputs-Oper'!L50)))","v":-8908.9228800000019},{"$f":"G50*(1+(IF(ISBLANK('Inputs-Oper'!M50),'Inputs-Oper'!$I50,'Inputs-Oper'!M50)))","v":-9265.2797952000019},{"$f":"H50*(1+(IF(ISBLANK('Inputs-Oper'!N50),'Inputs-Oper'!$I50,'Inputs-Oper'!N50)))","v":-9635.8909870080024},{"$f":"I50*(1+(IF(ISBLANK('Inputs-Oper'!O50),'Inputs-Oper'!$I50,'Inputs-Oper'!O50)))","v":-10021.326626488322},{"$f":"J50*(1+(IF(ISBLANK('Inputs-Oper'!P50),'Inputs-Oper'!$I50,'Inputs-Oper'!P50)))","v":-10422.179691547855},{"$f":"K50*(1+(IF(ISBLANK('Inputs-Oper'!Q50),'Inputs-Oper'!$I50,'Inputs-Oper'!Q50)))","v":-10839.066879209769},{"$f":"L50*(1+(IF(ISBLANK('Inputs-Oper'!R50),'Inputs-Oper'!$I50,'Inputs-Oper'!R50)))","v":-11272.62955437816},{"$f":"M50*(1+(IF(ISBLANK('Inputs-Oper'!S50),'Inputs-Oper'!$I50,'Inputs-Oper'!S50)))","v":-11723.534736553287},{"$f":"N50*(1+(IF(ISBLANK('Inputs-Oper'!T50),'Inputs-Oper'!$I50,'Inputs-Oper'!T50)))","v":-12192.476126015419},{"$f":"O50*(1+(IF(ISBLANK('Inputs-Oper'!U50),'Inputs-Oper'!$I50,'Inputs-Oper'!U50)))","v":-12680.175171056037},{"$f":"P50*(1+(IF(ISBLANK('Inputs-Oper'!V50),'Inputs-Oper'!$I50,'Inputs-Oper'!V50)))","v":-13187.382177898278},{"$f":"Q50*(1+(IF(ISBLANK('Inputs-Oper'!W50),'Inputs-Oper'!$I50,'Inputs-Oper'!W50)))","v":-13714.87746501421},{"$f":"R50*(1+(IF(ISBLANK('Inputs-Oper'!X50),'Inputs-Oper'!$I50,'Inputs-Oper'!X50)))","v":-14263.472563614778},{"$f":"S50*(1+(IF(ISBLANK('Inputs-Oper'!Y50),'Inputs-Oper'!$I50,'Inputs-Oper'!Y50)))","v":-14834.011466159369},{"$f":"T50*(1+(IF(ISBLANK('Inputs-Oper'!Z50),'Inputs-Oper'!$I50,'Inputs-Oper'!Z50)))","v":-15427.371924805744},{"$f":"U50*(1+(IF(ISBLANK('Inputs-Oper'!AA50),'Inputs-Oper'!$I50,'Inputs-Oper'!AA50)))","v":-16044.466801797975},{"$f":"V50*(1+(IF(ISBLANK('Inputs-Oper'!AB50),'Inputs-Oper'!$I50,'Inputs-Oper'!AB50)))","v":-16686.245473869894},{"$f":"W50*(1+(IF(ISBLANK('Inputs-Oper'!AC50),'Inputs-Oper'!$I50,'Inputs-Oper'!AC50)))","v":-17353.69529282469}]
[null,{"$f":"'Inputs-Oper'!C51","v":"X"},null,{"$f":"-'Inputs-Oper'!G51","v":0},{"$f":"D51*(1+(IF(ISBLANK('Inputs-Oper'!J51),'Inputs-Oper'!$I51,'Inputs-Oper'!J51)))","v":0},{"$f":"E51*(1+(IF(ISBLANK('Inputs-Oper'!K51),'Inputs-Oper'!$I51,'Inputs-Oper'!K51)))","v":0},{"$f":"F51*(1+(IF(ISBLANK('Inputs-Oper'!L51),'Inputs-Oper'!$I51,'Inputs-Oper'!L51)))","v":0},{"$f":"G51*(1+(IF(ISBLANK('Inputs-Oper'!M51),'Inputs-Oper'!$I51,'Inputs-Oper'!M51)))","v":0},{"$f":"H51*(1+(IF(ISBLANK('Inputs-Oper'!N51),'Inputs-Oper'!$I51,'Inputs-Oper'!N51)))","v":0},{"$f":"I51*(1+(IF(ISBLANK('Inputs-Oper'!O51),'Inputs-Oper'!$I51,'Inputs-Oper'!O51)))","v":0},{"$f":"J51*(1+(IF(ISBLANK('Inputs-Oper'!P51),'Inputs-Oper'!$I51,'Inputs-Oper'!P51)))","v":0},{"$f":"K51*(1+(IF(ISBLANK('Inputs-Oper'!Q51),'Inputs-Oper'!$I51,'Inputs-Oper'!Q51)))","v":0},{"$f":"L51*(1+(IF(ISBLANK('Inputs-Oper'!R51),'Inputs-Oper'!$I51,'Inputs-Oper'!R51)))","v":0},{"$f":"M51*(1+(IF(ISBLANK('Inputs-Oper'!S51),'Inputs-Oper'!$I51,'Inputs-Oper'!S51)))","v":0},{"$f":"N51*(1+(IF(ISBLANK('Inputs-Oper'!T51),'Inputs-Oper'!$I51,'Inputs-Oper'!T51)))","v":0},{"$f":"O51*(1+(IF(ISBLANK('Inputs-Oper'!U51),'Inputs-Oper'!$I51,'Inputs-Oper'!U51)))","v":0},{"$f":"P51*(1+(IF(ISBLANK('Inputs-Oper'!V51),'Inputs-Oper'!$I51,'Inputs-Oper'!V51)))","v":0},{"$f":"Q51*(1+(IF(ISBLANK('Inputs-Oper'!W51),'Inputs-Oper'!$I51,'Inputs-Oper'!W51)))","v":0},{"$f":"R51*(1+(IF(ISBLANK('Inputs-Oper'!X51),'Inputs-Oper'!$I51,'Inputs-Oper'!X51)))","v":0},{"$f":"S51*(1+(IF(ISBLANK('Inputs-Oper'!Y51),'Inputs-Oper'!$I51,'Inputs-Oper'!Y51)))","v":0},{"$f":"T51*(1+(IF(ISBLANK('Inputs-Oper'!Z51),'Inputs-Oper'!$I51,'Inputs-Oper'!Z51)))","v":0},{"$f":"U51*(1+(IF(ISBLANK('Inputs-Oper'!AA51),'Inputs-Oper'!$I51,'Inputs-Oper'!AA51)))","v":0},{"$f":"V51*(1+(IF(ISBLANK('Inputs-Oper'!AB51),'Inputs-Oper'!$I51,'Inputs-Oper'!AB51)))","v":0},{"$f":"W51*(1+(IF(ISBLANK('Inputs-Oper'!AC51),'Inputs-Oper'!$I51,'Inputs-Oper'!AC51)))","v":0}]
[null,{"$f":"'Inputs-Oper'!C52","v":"X"},null,{"$f":"-'Inputs-Oper'!G52","v":0},{"$f":"D52*(1+(IF(ISBLANK('Inputs-Oper'!J52),'Inputs-Oper'!$I52,'Inputs-Oper'!J52)))","v":0},{"$f":"E52*(1+(IF(ISBLANK('Inputs-Oper'!K52),'Inputs-Oper'!$I52,'Inputs-Oper'!K52)))","v":0},{"$f":"F52*(1+(IF(ISBLANK('Inputs-Oper'!L52),'Inputs-Oper'!$I52,'Inputs-Oper'!L52)))","v":0},{"$f":"G52*(1+(IF(ISBLANK('Inputs-Oper'!M52),'Inputs-Oper'!$I52,'Inputs-Oper'!M52)))","v":0},{"$f":"H52*(1+(IF(ISBLANK('Inputs-Oper'!N52),'Inputs-Oper'!$I52,'Inputs-Oper'!N52)))","v":0},{"$f":"I52*(1+(IF(ISBLANK('Inputs-Oper'!O52),'Inputs-Oper'!$I52,'Inputs-Oper'!O52)))","v":0},{"$f":"J52*(1+(IF(ISBLANK('Inputs-Oper'!P52),'Inputs-Oper'!$I52,'Inputs-Oper'!P52)))","v":0},{"$f":"K52*(1+(IF(ISBLANK('Inputs-Oper'!Q52),'Inputs-Oper'!$I52,'Inputs-Oper'!Q52)))","v":0},{"$f":"L52*(1+(IF(ISBLANK('Inputs-Oper'!R52),'Inputs-Oper'!$I52,'Inputs-Oper'!R52)))","v":0},{"$f":"M52*(1+(IF(ISBLANK('Inputs-Oper'!S52),'Inputs-Oper'!$I52,'Inputs-Oper'!S52)))","v":0},{"$f":"N52*(1+(IF(ISBLANK('Inputs-Oper'!T52),'Inputs-Oper'!$I52,'Inputs-Oper'!T52)))","v":0},{"$f":"O52*(1+(IF(ISBLANK('Inputs-Oper'!U52),'Inputs-Oper'!$I52,'Inputs-Oper'!U52)))","v":0},{"$f":"P52*(1+(IF(ISBLANK('Inputs-Oper'!V52),'Inputs-Oper'!$I52,'Inputs-Oper'!V52)))","v":0},{"$f":"Q52*(1+(IF(ISBLANK('Inputs-Oper'!W52),'Inputs-Oper'!$I52,'Inputs-Oper'!W52)))","v":0},{"$f":"R52*(1+(IF(ISBLANK('Inputs-Oper'!X52),'Inputs-Oper'!$I52,'Inputs-Oper'!X52)))","v":0},{"$f":"S52*(1+(IF(ISBLANK('Inputs-Oper'!Y52),'Inputs-Oper'!$I52,'Inputs-Oper'!Y52)))","v":0},{"$f":"T52*(1+(IF(ISBLANK('Inputs-Oper'!Z52),'Inputs-Oper'!$I52,'Inputs-Oper'!Z52)))","v":0},{"$f":"U52*(1+(IF(ISBLANK('Inputs-Oper'!AA52),'Inputs-Oper'!$I52,'Inputs-Oper'!AA52)))","v":0},{"$f":"V52*(1+(IF(ISBLANK('Inputs-Oper'!AB52),'Inputs-Oper'!$I52,'Inputs-Oper'!AB52)))","v":0},{"$f":"W52*(1+(IF(ISBLANK('Inputs-Oper'!AC52),'Inputs-Oper'!$I52,'Inputs-Oper'!AC52)))","v":0}]
[null,{"$f":"'Inputs-Oper'!C53","v":"X"},null,{"$f":"-'Inputs-Oper'!G53","v":0},{"$f":"D53*(1+(IF(ISBLANK('Inputs-Oper'!J53),'Inputs-Oper'!$I53,'Inputs-Oper'!J53)))","v":0},{"$f":"E53*(1+(IF(ISBLANK('Inputs-Oper'!K53),'Inputs-Oper'!$I53,'Inputs-Oper'!K53)))","v":0},{"$f":"F53*(1+(IF(ISBLANK('Inputs-Oper'!L53),'Inputs-Oper'!$I53,'Inputs-Oper'!L53)))","v":0},{"$f":"G53*(1+(IF(ISBLANK('Inputs-Oper'!M53),'Inputs-Oper'!$I53,'Inputs-Oper'!M53)))","v":0},{"$f":"H53*(1+(IF(ISBLANK('Inputs-Oper'!N53),'Inputs-Oper'!$I53,'Inputs-Oper'!N53)))","v":0},{"$f":"I53*(1+(IF(ISBLANK('Inputs-Oper'!O53),'Inputs-Oper'!$I53,'Inputs-Oper'!O53)))","v":0},{"$f":"J53*(1+(IF(ISBLANK('Inputs-Oper'!P53),'Inputs-Oper'!$I53,'Inputs-Oper'!P53)))","v":0},{"$f":"K53*(1+(IF(ISBLANK('Inputs-Oper'!Q53),'Inputs-Oper'!$I53,'Inputs-Oper'!Q53)))","v":0},{"$f":"L53*(1+(IF(ISBLANK('Inputs-Oper'!R53),'Inputs-Oper'!$I53,'Inputs-Oper'!R53)))","v":0},{"$f":"M53*(1+(IF(ISBLANK('Inputs-Oper'!S53),'Inputs-Oper'!$I53,'Inputs-Oper'!S53)))","v":0},{"$f":"N53*(1+(IF(ISBLANK('Inputs-Oper'!T53),'Inputs-Oper'!$I53,'Inputs-Oper'!T53)))","v":0},{"$f":"O53*(1+(IF(ISBLANK('Inputs-Oper'!U53),'Inputs-Oper'!$I53,'Inputs-Oper'!U53)))","v":0},{"$f":"P53*(1+(IF(ISBLANK('Inputs-Oper'!V53),'Inputs-Oper'!$I53,'Inputs-Oper'!V53)))","v":0},{"$f":"Q53*(1+(IF(ISBLANK('Inputs-Oper'!W53),'Inputs-Oper'!$I53,'Inputs-Oper'!W53)))","v":0},{"$f":"R53*(1+(IF(ISBLANK('Inputs-Oper'!X53),'Inputs-Oper'!$I53,'Inputs-Oper'!X53)))","v":0},{"$f":"S53*(1+(IF(ISBLANK('Inputs-Oper'!Y53),'Inputs-Oper'!$I53,'Inputs-Oper'!Y53)))","v":0},{"$f":"T53*(1+(IF(ISBLANK('Inputs-Oper'!Z53),'Inputs-Oper'!$I53,'Inputs-Oper'!Z53)))","v":0},{"$f":"U53*(1+(IF(ISBLANK('Inputs-Oper'!AA53),'Inputs-Oper'!$I53,'Inputs-Oper'!AA53)))","v":0},{"$f":"V53*(1+(IF(ISBLANK('Inputs-Oper'!AB53),'Inputs-Oper'!$I53,'Inputs-Oper'!AB53)))","v":0},{"$f":"W53*(1+(IF(ISBLANK('Inputs-Oper'!AC53),'Inputs-Oper'!$I53,'Inputs-Oper'!AC53)))","v":0}]
[null,{"$f":"'Inputs-Oper'!C54","v":"X"},null,{"$f":"-'Inputs-Oper'!G54","v":0},{"$f":"D54*(1+(IF(ISBLANK('Inputs-Oper'!J54),'Inputs-Oper'!$I54,'Inputs-Oper'!J54)))","v":0},{"$f":"E54*(1+(IF(ISBLANK('Inputs-Oper'!K54),'Inputs-Oper'!$I54,'Inputs-Oper'!K54)))","v":0},{"$f":"F54*(1+(IF(ISBLANK('Inputs-Oper'!L54),'Inputs-Oper'!$I54,'Inputs-Oper'!L54)))","v":0},{"$f":"G54*(1+(IF(ISBLANK('Inputs-Oper'!M54),'Inputs-Oper'!$I54,'Inputs-Oper'!M54)))","v":0},{"$f":"H54*(1+(IF(ISBLANK('Inputs-Oper'!N54),'Inputs-Oper'!$I54,'Inputs-Oper'!N54)))","v":0},{"$f":"I54*(1+(IF(ISBLANK('Inputs-Oper'!O54),'Inputs-Oper'!$I54,'Inputs-Oper'!O54)))","v":0},{"$f":"J54*(1+(IF(ISBLANK('Inputs-Oper'!P54),'Inputs-Oper'!$I54,'Inputs-Oper'!P54)))","v":0},{"$f":"K54*(1+(IF(ISBLANK('Inputs-Oper'!Q54),'Inputs-Oper'!$I54,'Inputs-Oper'!Q54)))","v":0},{"$f":"L54*(1+(IF(ISBLANK('Inputs-Oper'!R54),'Inputs-Oper'!$I54,'Inputs-Oper'!R54)))","v":0},{"$f":"M54*(1+(IF(ISBLANK('Inputs-Oper'!S54),'Inputs-Oper'!$I54,'Inputs-Oper'!S54)))","v":0},{"$f":"N54*(1+(IF(ISBLANK('Inputs-Oper'!T54),'Inputs-Oper'!$I54,'Inputs-Oper'!T54)))","v":0},{"$f":"O54*(1+(IF(ISBLANK('Inputs-Oper'!U54),'Inputs-Oper'!$I54,'Inputs-Oper'!U54)))","v":0},{"$f":"P54*(1+(IF(ISBLANK('Inputs-Oper'!V54),'Inputs-Oper'!$I54,'Inputs-Oper'!V54)))","v":0},{"$f":"Q54*(1+(IF(ISBLANK('Inputs-Oper'!W54),'Inputs-Oper'!$I54,'Inputs-Oper'!W54)))","v":0},{"$f":"R54*(1+(IF(ISBLANK('Inputs-Oper'!X54),'Inputs-Oper'!$I54,'Inputs-Oper'!X54)))","v":0},{"$f":"S54*(1+(IF(ISBLANK('Inputs-Oper'!Y54),'Inputs-Oper'!$I54,'Inputs-Oper'!Y54)))","v":0},{"$f":"T54*(1+(IF(ISBLANK('Inputs-Oper'!Z54),'Inputs-Oper'!$I54,'Inputs-Oper'!Z54)))","v":0},{"$f":"U54*(1+(IF(ISBLANK('Inputs-Oper'!AA54),'Inputs-Oper'!$I54,'Inputs-Oper'!AA54)))","v":0},{"$f":"V54*(1+(IF(ISBLANK('Inputs-Oper'!AB54),'Inputs-Oper'!$I54,'Inputs-Oper'!AB54)))","v":0},{"$f":"W54*(1+(IF(ISBLANK('Inputs-Oper'!AC54),'Inputs-Oper'!$I54,'Inputs-Oper'!AC54)))","v":0}]
[null,{"$f":"'Inputs-Oper'!C55","v":"X"},null,{"$f":"-'Inputs-Oper'!G55","v":0},{"$f":"D55*(1+(IF(ISBLANK('Inputs-Oper'!J55),'Inputs-Oper'!$I55,'Inputs-Oper'!J55)))","v":0},{"$f":"E55*(1+(IF(ISBLANK('Inputs-Oper'!K55),'Inputs-Oper'!$I55,'Inputs-Oper'!K55)))","v":0},{"$f":"F55*(1+(IF(ISBLANK('Inputs-Oper'!L55),'Inputs-Oper'!$I55,'Inputs-Oper'!L55)))","v":0},{"$f":"G55*(1+(IF(ISBLANK('Inputs-Oper'!M55),'Inputs-Oper'!$I55,'Inputs-Oper'!M55)))","v":0},{"$f":"H55*(1+(IF(ISBLANK('Inputs-Oper'!N55),'Inputs-Oper'!$I55,'Inputs-Oper'!N55)))","v":0},{"$f":"I55*(1+(IF(ISBLANK('Inputs-Oper'!O55),'Inputs-Oper'!$I55,'Inputs-Oper'!O55)))","v":0},{"$f":"J55*(1+(IF(ISBLANK('Inputs-Oper'!P55),'Inputs-Oper'!$I55,'Inputs-Oper'!P55)))","v":0},{"$f":"K55*(1+(IF(ISBLANK('Inputs-Oper'!Q55),'Inputs-Oper'!$I55,'Inputs-Oper'!Q55)))","v":0},{"$f":"L55*(1+(IF(ISBLANK('Inputs-Oper'!R55),'Inputs-Oper'!$I55,'Inputs-Oper'!R55)))","v":0},{"$f":"M55*(1+(IF(ISBLANK('Inputs-Oper'!S55),'Inputs-Oper'!$I55,'Inputs-Oper'!S55)))","v":0},{"$f":"N55*(1+(IF(ISBLANK('Inputs-Oper'!T55),'Inputs-Oper'!$I55,'Inputs-Oper'!T55)))","v":0},{"$f":"O55*(1+(IF(ISBLANK('Inputs-Oper'!U55),'Inputs-Oper'!$I55,'Inputs-Oper'!U55)))","v":0},{"$f":"P55*(1+(IF(ISBLANK('Inputs-Oper'!V55),'Inputs-Oper'!$I55,'Inputs-Oper'!V55)))","v":0},{"$f":"Q55*(1+(IF(ISBLANK('Inputs-Oper'!W55),'Inputs-Oper'!$I55,'Inputs-Oper'!W55)))","v":0},{"$f":"R55*(1+(IF(ISBLANK('Inputs-Oper'!X55),'Inputs-Oper'!$I55,'Inputs-Oper'!X55)))","v":0},{"$f":"S55*(1+(IF(ISBLANK('Inputs-Oper'!Y55),'Inputs-Oper'!$I55,'Inputs-Oper'!Y55)))","v":0},{"$f":"T55*(1+(IF(ISBLANK('Inputs-Oper'!Z55),'Inputs-Oper'!$I55,'Inputs-Oper'!Z55)))","v":0},{"$f":"U55*(1+(IF(ISBLANK('Inputs-Oper'!AA55),'Inputs-Oper'!$I55,'Inputs-Oper'!AA55)))","v":0},{"$f":"V55*(1+(IF(ISBLANK('Inputs-Oper'!AB55),'Inputs-Oper'!$I55,'Inputs-Oper'!AB55)))","v":0},{"$f":"W55*(1+(IF(ISBLANK('Inputs-Oper'!AC55),'Inputs-Oper'!$I55,'Inputs-Oper'!AC55)))","v":0}]
[null,{"$f":"'Inputs-Oper'!C56","v":"X"},null,{"$f":"-'Inputs-Oper'!G56","v":0},{"$f":"D56*(1+(IF(ISBLANK('Inputs-Oper'!J56),'Inputs-Oper'!$I56,'Inputs-Oper'!J56)))","v":0},{"$f":"E56*(1+(IF(ISBLANK('Inputs-Oper'!K56),'Inputs-Oper'!$I56,'Inputs-Oper'!K56)))","v":0},{"$f":"F56*(1+(IF(ISBLANK('Inputs-Oper'!L56),'Inputs-Oper'!$I56,'Inputs-Oper'!L56)))","v":0},{"$f":"G56*(1+(IF(ISBLANK('Inputs-Oper'!M56),'Inputs-Oper'!$I56,'Inputs-Oper'!M56)))","v":0},{"$f":"H56*(1+(IF(ISBLANK('Inputs-Oper'!N56),'Inputs-Oper'!$I56,'Inputs-Oper'!N56)))","v":0},{"$f":"I56*(1+(IF(ISBLANK('Inputs-Oper'!O56),'Inputs-Oper'!$I56,'Inputs-Oper'!O56)))","v":0},{"$f":"J56*(1+(IF(ISBLANK('Inputs-Oper'!P56),'Inputs-Oper'!$I56,'Inputs-Oper'!P56)))","v":0},{"$f":"K56*(1+(IF(ISBLANK('Inputs-Oper'!Q56),'Inputs-Oper'!$I56,'Inputs-Oper'!Q56)))","v":0},{"$f":"L56*(1+(IF(ISBLANK('Inputs-Oper'!R56),'Inputs-Oper'!$I56,'Inputs-Oper'!R56)))","v":0},{"$f":"M56*(1+(IF(ISBLANK('Inputs-Oper'!S56),'Inputs-Oper'!$I56,'Inputs-Oper'!S56)))","v":0},{"$f":"N56*(1+(IF(ISBLANK('Inputs-Oper'!T56),'Inputs-Oper'!$I56,'Inputs-Oper'!T56)))","v":0},{"$f":"O56*(1+(IF(ISBLANK('Inputs-Oper'!U56),'Inputs-Oper'!$I56,'Inputs-Oper'!U56)))","v":0},{"$f":"P56*(1+(IF(ISBLANK('Inputs-Oper'!V56),'Inputs-Oper'!$I56,'Inputs-Oper'!V56)))","v":0},{"$f":"Q56*(1+(IF(ISBLANK('Inputs-Oper'!W56),'Inputs-Oper'!$I56,'Inputs-Oper'!W56)))","v":0},{"$f":"R56*(1+(IF(ISBLANK('Inputs-Oper'!X56),'Inputs-Oper'!$I56,'Inputs-Oper'!X56)))","v":0},{"$f":"S56*(1+(IF(ISBLANK('Inputs-Oper'!Y56),'Inputs-Oper'!$I56,'Inputs-Oper'!Y56)))","v":0},{"$f":"T56*(1+(IF(ISBLANK('Inputs-Oper'!Z56),'Inputs-Oper'!$I56,'Inputs-Oper'!Z56)))","v":0},{"$f":"U56*(1+(IF(ISBLANK('Inputs-Oper'!AA56),'Inputs-Oper'!$I56,'Inputs-Oper'!AA56)))","v":0},{"$f":"V56*(1+(IF(ISBLANK('Inputs-Oper'!AB56),'Inputs-Oper'!$I56,'Inputs-Oper'!AB56)))","v":0},{"$f":"W56*(1+(IF(ISBLANK('Inputs-Oper'!AC56),'Inputs-Oper'!$I56,'Inputs-Oper'!AC56)))","v":0}]
[null,{"$f":"'Inputs-Oper'!C57","v":"X"},null,{"$f":"-'Inputs-Oper'!G57","v":0},{"$f":"D57*(1+(IF(ISBLANK('Inputs-Oper'!J57),'Inputs-Oper'!$I57,'Inputs-Oper'!J57)))","v":0},{"$f":"E57*(1+(IF(ISBLANK('Inputs-Oper'!K57),'Inputs-Oper'!$I57,'Inputs-Oper'!K57)))","v":0},{"$f":"F57*(1+(IF(ISBLANK('Inputs-Oper'!L57),'Inputs-Oper'!$I57,'Inputs-Oper'!L57)))","v":0},{"$f":"G57*(1+(IF(ISBLANK('Inputs-Oper'!M57),'Inputs-Oper'!$I57,'Inputs-Oper'!M57)))","v":0},{"$f":"H57*(1+(IF(ISBLANK('Inputs-Oper'!N57),'Inputs-Oper'!$I57,'Inputs-Oper'!N57)))","v":0},{"$f":"I57*(1+(IF(ISBLANK('Inputs-Oper'!O57),'Inputs-Oper'!$I57,'Inputs-Oper'!O57)))","v":0},{"$f":"J57*(1+(IF(ISBLANK('Inputs-Oper'!P57),'Inputs-Oper'!$I57,'Inputs-Oper'!P57)))","v":0},{"$f":"K57*(1+(IF(ISBLANK('Inputs-Oper'!Q57),'Inputs-Oper'!$I57,'Inputs-Oper'!Q57)))","v":0},{"$f":"L57*(1+(IF(ISBLANK('Inputs-Oper'!R57),'Inputs-Oper'!$I57,'Inputs-Oper'!R57)))","v":0},{"$f":"M57*(1+(IF(ISBLANK('Inputs-Oper'!S57),'Inputs-Oper'!$I57,'Inputs-Oper'!S57)))","v":0},{"$f":"N57*(1+(IF(ISBLANK('Inputs-Oper'!T57),'Inputs-Oper'!$I57,'Inputs-Oper'!T57)))","v":0},{"$f":"O57*(1+(IF(ISBLANK('Inputs-Oper'!U57),'Inputs-Oper'!$I57,'Inputs-Oper'!U57)))","v":0},{"$f":"P57*(1+(IF(ISBLANK('Inputs-Oper'!V57),'Inputs-Oper'!$I57,'Inputs-Oper'!V57)))","v":0},{"$f":"Q57*(1+(IF(ISBLANK('Inputs-Oper'!W57),'Inputs-Oper'!$I57,'Inputs-Oper'!W57)))","v":0},{"$f":"R57*(1+(IF(ISBLANK('Inputs-Oper'!X57),'Inputs-Oper'!$I57,'Inputs-Oper'!X57)))","v":0},{"$f":"S57*(1+(IF(ISBLANK('Inputs-Oper'!Y57),'Inputs-Oper'!$I57,'Inputs-Oper'!Y57)))","v":0},{"$f":"T57*(1+(IF(ISBLANK('Inputs-Oper'!Z57),'Inputs-Oper'!$I57,'Inputs-Oper'!Z57)))","v":0},{"$f":"U57*(1+(IF(ISBLANK('Inputs-Oper'!AA57),'Inputs-Oper'!$I57,'Inputs-Oper'!AA57)))","v":0},{"$f":"V57*(1+(IF(ISBLANK('Inputs-Oper'!AB57),'Inputs-Oper'!$I57,'Inputs-Oper'!AB57)))","v":0},{"$f":"W57*(1+(IF(ISBLANK('Inputs-Oper'!AC57),'Inputs-Oper'!$I57,'Inputs-Oper'!AC57)))","v":0}]
[null,{"$f":"'Inputs-Oper'!C58","v":"X"},null,{"$f":"-'Inputs-Oper'!G58","v":0},{"$f":"D58*(1+(IF(ISBLANK('Inputs-Oper'!J58),'Inputs-Oper'!$I58,'Inputs-Oper'!J58)))","v":0},{"$f":"E58*(1+(IF(ISBLANK('Inputs-Oper'!K58),'Inputs-Oper'!$I58,'Inputs-Oper'!K58)))","v":0},{"$f":"F58*(1+(IF(ISBLANK('Inputs-Oper'!L58),'Inputs-Oper'!$I58,'Inputs-Oper'!L58)))","v":0},{"$f":"G58*(1+(IF(ISBLANK('Inputs-Oper'!M58),'Inputs-Oper'!$I58,'Inputs-Oper'!M58)))","v":0},{"$f":"H58*(1+(IF(ISBLANK('Inputs-Oper'!N58),'Inputs-Oper'!$I58,'Inputs-Oper'!N58)))","v":0},{"$f":"I58*(1+(IF(ISBLANK('Inputs-Oper'!O58),'Inputs-Oper'!$I58,'Inputs-Oper'!O58)))","v":0},{"$f":"J58*(1+(IF(ISBLANK('Inputs-Oper'!P58),'Inputs-Oper'!$I58,'Inputs-Oper'!P58)))","v":0},{"$f":"K58*(1+(IF(ISBLANK('Inputs-Oper'!Q58),'Inputs-Oper'!$I58,'Inputs-Oper'!Q58)))","v":0},{"$f":"L58*(1+(IF(ISBLANK('Inputs-Oper'!R58),'Inputs-Oper'!$I58,'Inputs-Oper'!R58)))","v":0},{"$f":"M58*(1+(IF(ISBLANK('Inputs-Oper'!S58),'Inputs-Oper'!$I58,'Inputs-Oper'!S58)))","v":0},{"$f":"N58*(1+(IF(ISBLANK('Inputs-Oper'!T58),'Inputs-Oper'!$I58,'Inputs-Oper'!T58)))","v":0},{"$f":"O58*(1+(IF(ISBLANK('Inputs-Oper'!U58),'Inputs-Oper'!$I58,'Inputs-Oper'!U58)))","v":0},{"$f":"P58*(1+(IF(ISBLANK('Inputs-Oper'!V58),'Inputs-Oper'!$I58,'Inputs-Oper'!V58)))","v":0},{"$f":"Q58*(1+(IF(ISBLANK('Inputs-Oper'!W58),'Inputs-Oper'!$I58,'Inputs-Oper'!W58)))","v":0},{"$f":"R58*(1+(IF(ISBLANK('Inputs-Oper'!X58),'Inputs-Oper'!$I58,'Inputs-Oper'!X58)))","v":0},{"$f":"S58*(1+(IF(ISBLANK('Inputs-Oper'!Y58),'Inputs-Oper'!$I58,'Inputs-Oper'!Y58)))","v":0},{"$f":"T58*(1+(IF(ISBLANK('Inputs-Oper'!Z58),'Inputs-Oper'!$I58,'Inputs-Oper'!Z58)))","v":0},{"$f":"U58*(1+(IF(ISBLANK('Inputs-Oper'!AA58),'Inputs-Oper'!$I58,'Inputs-Oper'!AA58)))","v":0},{"$f":"V58*(1+(IF(ISBLANK('Inputs-Oper'!AB58),'Inputs-Oper'!$I58,'Inputs-Oper'!AB58)))","v":0},{"$f":"W58*(1+(IF(ISBLANK('Inputs-Oper'!AC58),'Inputs-Oper'!$I58,'Inputs-Oper'!AC58)))","v":0}]
["    Total Operating Expenses",null,null,{"$f":"SUM(D36:D58)","v":-305020},{"$f":"SUM(E36:E58)","v":-317220.8},-329909.63200000004,-343106.01728000003,-356830.25797120004,-371103.46829004807,-385947.60702164989,-401385.51130251598,-417440.93175461661,-434138.56902480131,-451504.11178579339,-469564.27625722514,-488346.84730751422,-507880.72119981481,-528195.95004780742,-549323.78804971976,-571296.7395717086,-594148.6091545769,-617914.55352075992,-642631.13566159038,-668336.38108805392]
[null,"Per Unit Expenses",null,{"$f":"D59/'Inputs-Oper'!$E$17","v":-3812.75},{"$f":"E59/'Inputs-Oper'!$E$17","v":-3965.2599999999998},{"$f":"F59/'Inputs-Oper'!$E$17","v":-4123.8704000000007},{"$f":"G59/'Inputs-Oper'!$E$17","v":-4288.8252160000002},{"$f":"H59/'Inputs-Oper'!$E$17","v":-4460.3782246400006},{"$f":"I59/'Inputs-Oper'!$E$17","v":-4638.7933536256005},{"$f":"J59/'Inputs-Oper'!$E$17","v":-4824.3450877706236},{"$f":"K59/'Inputs-Oper'!$E$17","v":-5017.3188912814494},{"$f":"L59/'Inputs-Oper'!$E$17","v":-5218.0116469327077},{"$f":"M59/'Inputs-Oper'!$E$17","v":-5426.7321128100166},{"$f":"N59/'Inputs-Oper'!$E$17","v":-5643.801397322417},{"$f":"O59/'Inputs-Oper'!$E$17","v":-5869.5534532153142},{"$f":"P59/'Inputs-Oper'!$E$17","v":-6104.3355913439282},{"$f":"Q59/'Inputs-Oper'!$E$17","v":-6348.509014997685},{"$f":"R59/'Inputs-Oper'!$E$17","v":-6602.4493755975927},{"$f":"S59/'Inputs-Oper'!$E$17","v":-6866.5473506214967},{"$f":"T59/'Inputs-Oper'!$E$17","v":-7141.2092446463575},{"$f":"U59/'Inputs-Oper'!$E$17","v":-7426.8576144322114},{"$f":"V59/'Inputs-Oper'!$E$17","v":-7723.9319190094993},{"$f":"W59/'Inputs-Oper'!$E$17","v":-8032.8891957698797},{"$f":"X59/'Inputs-Oper'!$E$17","v":-8354.2047636006737}]
[]
["NET OPERATING INCOME (NOI)",null,null,{"$f":"D32+D59","v":398455},{"$f":"E32+E59","v":414393.2},430968.9279999999,448207.68511999992,466135.99252479989,484781.43222579209,504172.68951482378,524339.59709541663,545313.18097923347,567125.70821840269,589810.73654713877,613403.16600902448,637939.29264938552,663456.86435536074,689995.13892957557,717594.94448675844,746298.74226622877,776150.69195687771,807196.71963515261,839484.58842055895,{"$f":"X32+X59","v":873063.97195738147}]
[]
[null,"Less Depreciation",null,{"$f":"-(PRICE_CAPS*(1-LANDTOVALUE))/TAXLIFE","v":-123076.92307692308},{"$f":"-(PRICE_CAPS*(1-LANDTOVALUE))/TAXLIFE","v":-123076.92307692308},-123076.92307692308,-123076.92307692308,-123076.92307692308,-123076.92307692308,-123076.92307692308,-123076.92307692308,-123076.92307692308,-123076.92307692308,-123076.92307692308,-123076.92307692308,-123076.92307692308,-123076.92307692308,-123076.92307692308,-123076.92307692308,-123076.92307692308,-123076.92307692308,-123076.92307692308,-123076.92307692308,-123076.92307692308]
[null,"Less Interest Payment",null,{"$f":"D115","v":-419240.01544558536},{"$f":"E115","v":-415766.47207557596},-411995.27334558964,-407900.91253127344,-403455.69718249608,-398629.56182385795,-393389.86460506823,-387701.16652587987,-381524.99174232595,-374819.56733307801,-367539.54076584894,-359635.67315286584,-351054.50622075796,-341738.00074238703,-331623.14398510894,-320641.52352046734,-308718.86451270152,-295774.52735652495,-281720.96226642141,-266463.11712851468,{"$f":"X115","v":-249897.79461001093}]
["Taxable Income",null,null,{"$f":"D62+D64+D65","v":-143861.93852250843},{"$f":"E62+E64+E65","v":-124450.19515249901},-104103.2684225128,-82770.150488196581,-60396.627734619251,-36925.052674988925,-12294.098167167511,13561.507492613688,40711.266159984458,69229.21780840162,99194.272704366769,130690.56977923558,163807.86335170449,198641.94053605059,235295.07186754351,273876.49788936798,314502.95467660413,357299.24152342963,402398.83429180807,449944.54821512115,500089.25427044742]
[null,"Plus Depreciation",null,{"$f":"-D64","v":123076.92307692308},{"$f":"-E64","v":123076.92307692308},123076.92307692308,123076.92307692308,123076.92307692308,123076.92307692308,123076.92307692308,123076.92307692308,123076.92307692308,123076.92307692308,123076.92307692308,123076.92307692308,123076.92307692308,123076.92307692308,123076.92307692308,123076.92307692308,123076.92307692308,123076.92307692308,123076.92307692308,123076.92307692308,{"$f":"-X64","v":123076.92307692308}]
[null,"Less Principal Payment",null,{"$f":"D116","v":-40535.146233580075},{"$f":"E116","v":-44008.689603589475},-47779.8883335758,-51874.249147891998,-56319.46449666936,-61145.59985530749,-66385.297074097209,-72073.995153285563,-78250.169936839491,-84955.594346087426,-92235.620913316496,-100139.4885262996,-108720.65545840748,-118037.16093677841,-128152.0176940565,-139133.6381586981,-151056.29716646392,-164000.63432264049,-178054.19941274403,-193312.04455065075,{"$f":"X116","v":-209877.36706915451}]
["Before Tax Cash Flow",null,null,{"$f":"D66+D67+D68","v":-61320.161679165423},{"$f":"E66+E67+E68","v":-45381.961679165412},-28806.233679165525,-11567.476559165501,6360.8308456344676,25006.270546626663,44397.527835658359,64564.435416251188,85538.01930006803,107350.54653923726,130035.57486797334,153628.00432985905,178164.13097022008,203681.70267619524,230219.97725041007,257819.78280759294,286523.58058706328,316375.53027771221,347421.55795598717,379709.42674139352,413288.81027821603]
[null,"Less Taxes",null,{"$f":"IF(-D66<=PLL,-TAXRATE*D66,TAXRATE*PLL)","v":13650},{"$f":"IF(-E74<=PLL,-TAXRATE*E74,TAXRATE*PLL)","v":13650},{"$f":"IF(-F74<=PLL,-TAXRATE*F74,TAXRATE*PLL)","v":13650},13650,13650,13650,13650,13650,13650,13650,-3079.023871120869,-50969.322213901876,-63885.066707164755,-77470.35680905974,-91765.078028341974,-106811.83417685352,-122656.15232387562,-139346.70419413756,-156935.54537380516,-175478.37380389727,0]
["After Tax Cash Flow",null,null,{"$f":"D69+D70","v":-47670.161679165423},{"$f":"E69+E70","v":-31731.961679165412},-15156.233679165525,2082.5234408344986,20010.830845634468,38656.270546626663,58047.527835658359,78214.435416251188,99188.01930006803,121000.54653923726,126956.55099685247,102658.68211595717,114279.06426305533,126211.3458671355,138454.89922206808,151007.94863073941,163867.42826318764,177028.82608357465,190486.01258218201,204231.05293749625,413288.81027821603]
[]
["PASSIVE LOSSES"]
["Sum of PLCF and Current Taxable Income",null,null,null,{"$f":"D75+E66","v":-233312.13367500744},{"$f":"E75+F66","v":-302415.40209752024},-350185.55258571682,-375582.18032033608,-377507.232995325,-354801.33116249251,-306239.82366987882,-230528.55750989437,-126299.33970149275,7894.9330028740223,130690.56977923558,163807.86335170449,198641.94053605059,235295.07186754351,273876.49788936798,314502.95467660413,357299.24152342963,402398.83429180807,449944.54821512115]
["Balance of Passive Loss Carried Forward (PLCF)",null,null,{"$f":"IF(-D66>=PLL,D66+PLL,0)","v":-108861.93852250843},{"$f":"IF(-E74>=PLL,E74+PLL,0)","v":-198312.13367500744},-267415.40209752024,-315185.55258571682,-340582.18032033608,-342507.232995325,-319801.33116249251,-271239.82366987882,-195528.55750989437,-91299.339701492747,0,0,0,0,0,0,0,0,0,0]
[]
["REVERSION"]
["Gross Sale Price",null,null,{"$f":"E62/CAPOUT","v":4875214.1176470583},{"$f":"F62/CAPOUT","v":5070222.6823529396},5273031.5896470575,5483952.8532329397,5703310.9673622595,5931443.4060567496,6168701.1422990188,6415449.1879909812,6672067.1555106193,6938949.8417310435,7216507.835400288,7505168.1488162996,7805374.8747689491,8117589.8697597124,8442293.4645500984,8779985.2031321023,9131184.6112573836,9496431.9957076777,9876289.2755359877,10271340.846557429]
[null,"Less Cost of Sale",null,{"$f":"-COSTSALE*'Cash Flow'!D78","v":-146256.42352941175},{"$f":"-COSTSALE*'Cash Flow'!E78","v":-152106.68047058818},{"$f":"-COSTSALE*'Cash Flow'!F78","v":-158190.94768941173},{"$f":"-COSTSALE*'Cash Flow'!G78","v":-164518.58559698818},{"$f":"-COSTSALE*'Cash Flow'!H78","v":-171099.32902086779},{"$f":"-COSTSALE*'Cash Flow'!I78","v":-177943.30218170249},{"$f":"-COSTSALE*'Cash Flow'!J78","v":-185061.03426897054},{"$f":"-COSTSALE*'Cash Flow'!K78","v":-192463.47563972944},{"$f":"-COSTSALE*'Cash Flow'!L78","v":-200162.01466531857},{"$f":"-COSTSALE*'Cash Flow'!M78","v":-208168.49525193131},{"$f":"-COSTSALE*'Cash Flow'!N78","v":-216495.23506200864},{"$f":"-COSTSALE*'Cash Flow'!O78","v":-225155.04446448898},{"$f":"-COSTSALE*'Cash Flow'!P78","v":-234161.24624306845},{"$f":"-COSTSALE*'Cash Flow'!Q78","v":-243527.69609279136},{"$f":"-COSTSALE*'Cash Flow'!R78","v":-253268.80393650295},{"$f":"-COSTSALE*'Cash Flow'!S78","v":-263399.55609396304},{"$f":"-COSTSALE*'Cash Flow'!T78","v":-273935.53833772149},{"$f":"-COSTSALE*'Cash Flow'!U78","v":-284892.9598712303},{"$f":"-COSTSALE*'Cash Flow'!V78","v":-296288.67826607963},{"$f":"-COSTSALE*'Cash Flow'!W78","v":-308140.22539672285}]
["Net Sale Price",null,null,{"$f":"D78+D79","v":4728957.6941176467},4918116.001882351,5114840.6419576453,5319434.2676359517,5532211.6383413915,5753500.1038750475,5983640.1080300482,6222985.7123512514,6471905.1408453006,6730781.3464791123,7000012.6003382793,7280013.1043518111,7571213.6285258811,7874062.1736669214,8189024.6606135955,8516585.6470381394,8857249.072919663,9211539.035836447,9580000.5972699076,9963200.6211607065]
[null,"Less Outstanding Mortgage",null,{"$f":"-D117","v":-5059464.8537664199},-5015456.1641628304,-4967676.2758292546,-4915802.0266813627,-4859482.5621846933,-4798336.9623293858,-4731951.6652552886,-4659877.670102003,-4581627.5001651635,-4496671.9058190761,-4404436.2849057596,-4304296.79637946,-4195576.1409210525,-4077538.9799842741,-3949386.9622902176,-3810253.3241315195,-3659197.0269650556,-3495196.3926424151,-3317142.1932296711,-3123830.1486790203]
["Before Tax Equity Reversion (BTER)",null,null,{"$f":"D80+D81","v":-330507.15964877326},{"$f":"E80+E81","v":-97340.162280479446},147164.36612839065,403632.2409545891,672729.07615669817,955163.14154566173,1251688.4427747596,1563108.0422492484,1890277.6406801371,2234109.4406600362,2595576.3154325197,2975716.3079723511,3375637.4876048286,3796523.1936826473,4239637.6983233783,4706332.3229066199,5198052.0459546074,5716342.6431940319,6262858.404040236,6839370.4724816866]
[null,"Less Taxes Due on Sale (See Below)",null,{"$f":"D109","v":0},{"$f":"E109","v":0},0,0,-49399.063431501621,-135490.41058414639,-143844.30960150433,-246503.0238901207,-342198.3935901582,-445588.70904783159,-548464.05852919433,-635233.3901011314,-724242.72570517613,-815581.66550261504,-909343.39366118051,-1005624.8217153201,-1104526.7376608555,-1206153.9610134433,-1310615.504069366,-1418024.7396167566]
["After Tax Equity Reversion (ATER)",null,null,{"$f":"SUM(D82:D83)","v":-330507.15964877326},{"$f":"SUM(E82:E83)","v":-97340.162280479446},147164.36612839065,403632.2409545891,623330.01272519655,819672.73096151534,1107844.1331732552,1316605.0183591277,1548079.2470899788,1788520.7316122046,2047112.2569033252,2340482.9178712196,2651394.7618996524,2980941.528180032,3330294.3046621978,3700707.5011912999,4093525.3082937519,4510188.6821805891,4952242.8999708705,5421345.7328649303]
[]
["CAPITAL GAINS TAX ESTIMATE"]
["Capital Gain, Part 1, neglecting Accumulated Depreciation"]
[null,"Net Sale Price",null,{"$f":"D80","v":4728957.6941176467},4918116.001882351,5114840.6419576453,5319434.2676359517,5532211.6383413915,5753500.1038750475,5983640.1080300482,6222985.7123512514,6471905.1408453006,6730781.3464791123,7000012.6003382793,7280013.1043518111,7571213.6285258811,7874062.1736669214,8189024.6606135955,8516585.6470381394,8857249.072919663,9211539.035836447,9580000.5972699076,9963200.6211607065]
[null,"Less Purchase Price",null,{"$f":"-PURPRICE","v":-5950000},{"$f":"-PURPRICE","v":-5950000},-5950000,-5950000,-5950000,-5950000,-5950000,-5950000,-5950000,-5950000,-5950000,-5950000,-5950000,-5950000,-5950000,-5950000,-5950000,-5950000,-5950000,-5950000]
["Capital Gain, Part 1, neglecting PLCF",null,null,{"$f":"MAX(D88+D89,0)","v":0},{"$f":"MAX(E88+E89,0)","v":0},0,0,0,0,33640.108030048199,272985.71235125139,521905.14084530063,780781.34647911228,1050012.6003382793,1330013.1043518111,1621213.6285258811,1924062.1736669214,2239024.6606135955,2566585.6470381394,2907249.072919663,3261539.035836447,3630000.5972699076,4013200.6211607065]
["Capital Gain, Part 1, After Passive Loss Carry Forward",null,null,{"$f":"MAX(SUM(D90,D75),0)","v":0},{"$f":"MAX(SUM(E90,E75),0)","v":0},0,0,0,0,0,1745.8886813725694,326376.58333540626,689482.00677761948,1050012.6003382793,1330013.1043518111,1621213.6285258811,1924062.1736669214,2239024.6606135955,2566585.6470381394,2907249.072919663,3261539.035836447,3630000.5972699076,4013200.6211607065]
["(Memo: Remaining PLCF, After Adjusting Part I Capital Gains)",null,null,{"$f":"IF(D90>=0,-((D91-D90)-D75),0)","v":-108861.93852250843},{"$f":"IF(E90>=0,-((E91-E90)-E75),0)","v":-198312.13367500744},-267415.40209752024,-315185.55258571682,-340582.18032033608,-342507.232995325,-286161.22313244431,0,0,5.8207660913467407E-11,0,0,0,0,0,0,0,0,0,0]
[]
["Capital Gain Part II, Adjustment for Accumulated Depreciation"]
[null,"Accumulated Depreciation",null,{"$f":"SUM($D$67:D67)","v":123076.92307692308},{"$f":"SUM($D$67:E67)","v":246153.84615384616},{"$f":"SUM($D$67:F67)","v":369230.76923076925},{"$f":"SUM($D$67:G67)","v":492307.69230769231},{"$f":"SUM($D$67:H67)","v":615384.61538461538},{"$f":"SUM($D$67:I67)","v":738461.5384615385},{"$f":"SUM($D$67:J67)","v":861538.46153846162},{"$f":"SUM($D$67:K67)","v":984615.38461538474},{"$f":"SUM($D$67:L67)","v":1107692.3076923077},{"$f":"SUM($D$67:M67)","v":1230769.2307692308},{"$f":"SUM($D$67:N67)","v":1353846.1538461538},{"$f":"SUM($D$67:O67)","v":1476923.0769230768},{"$f":"SUM($D$67:P67)","v":1599999.9999999998},{"$f":"SUM($D$67:Q67)","v":1723076.9230769228},{"$f":"SUM($D$67:R67)","v":1846153.8461538458},{"$f":"SUM($D$67:S67)","v":1969230.7692307688},{"$f":"SUM($D$67:T67)","v":2092307.6923076918},{"$f":"SUM($D$67:U67)","v":2215384.615384615},{"$f":"SUM($D$67:V67)","v":2338461.538461538},{"$f":"SUM($D$67:W67)","v":2461538.461538461}]
[null,"Accumulated Depreciation, After PLCF",null,{"$f":"D95+D92","v":14214.984554414652},{"$f":"E95+E92","v":47841.712478838715},101815.367133249,177122.13972197549,274802.4350642793,395954.3054662135,575377.23840601731,984615.38461538474,1107692.3076923077,1230769.2307692308,1353846.1538461538,1476923.0769230768,1599999.9999999998,1723076.9230769228,1846153.8461538458,1969230.7692307688,2092307.6923076918,2215384.615384615,2338461.538461538,2461538.461538461]
["(Memo: PLCF, After Adj. Part I & Part II Capital Gains)",null,null,{"$f":"-((D96-D95)-D92)","v":0},{"$f":"-((E96-E95)-E92)","v":0},{"$f":"-((F96-F95)-F92)","v":0},0,0,0,0,0,0,5.8207660913467407E-11,0,0,0,0,0,0,0,0,0,0]
[]
["Memo: Capital Gain or Loss?"]
[null,"Net Sales Price",null,{"$f":"D80","v":4728957.6941176467},{"$f":"E80","v":4918116.001882351},5114840.6419576453,5319434.2676359517,5532211.6383413915,5753500.1038750475,5983640.1080300482,6222985.7123512514,6471905.1408453006,6730781.3464791123,7000012.6003382793,7280013.1043518111,7571213.6285258811,7874062.1736669214,8189024.6606135955,8516585.6470381394,8857249.072919663,9211539.035836447,9580000.5972699076,9963200.6211607065]
[null,"Adjusted Basis",null,{"$f":"-SUM(D89+D95)","v":5826923.076923077},5703846.153846154,5580769.230769231,5457692.307692308,5334615.384615385,5211538.461538462,5088461.538461538,4965384.615384615,4842307.692307692,4719230.769230769,4596153.846153846,4473076.923076923,4350000,4226923.076923077,4103846.153846154,3980769.230769231,3857692.307692308,3734615.384615385,3611538.461538462,3488461.538461539]
[null,"Gain Realized on Sale",null,{"$f":"D100-D101","v":-1097965.3828054303},{"$f":"E100-E101","v":-785730.15196380299},-465928.58881158568,-138258.04005635623,197596.25372600649,541961.64233658556,895178.56956851017,1257601.0969666364,1629597.4485376086,2011550.5772483433,2403858.7541844333,2806936.1812748881,3221213.6285258811,3647139.0967438444,4085178.5067674415,4535816.4162689084,4999556.7652273551,5476923.6512210621,5968462.1357314456,6474739.0826991675]
[null,"Is Gain Realized on Sale Greater Than Accumulated Depreciation?",null,{"$f":"IF(D102>D95,\"Yes\",\"No\")","v":"No"},{"$f":"IF(E102>E95,\"Yes\",\"No\")","v":"No"},"No","No","No","No","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes"]
[]
["Taxes Due on Sale"]
[null,"Tax on Part I of Capital Gains",null,{"$f":"-D91*KTRATE","v":0},{"$f":"-E91*KTRATE","v":0},0,0,0,0,0,-349.1777362745139,-65275.316667081257,-137896.40135552391,-210002.52006765586,-266002.62087036221,-324242.72570517624,-384812.43473338429,-447804.93212271912,-513317.12940762792,-581449.81458393263,-652307.80716728943,-726000.11945398152,-802640.1242321413]
[null,"Tax on Part II, Accumulated Depreciation",null,{"$f":"MIN(-KTRDEPR*IF(D102>D96,D96,D102),0)","v":0},{"$f":"MIN(-KTRDEPR*IF(E102>E95,E96,E102),0)","v":0},0,0,-49399.063431501621,-135490.41058414639,-143844.30960150433,-246153.84615384619,-276923.07692307694,-307692.30769230769,-338461.53846153844,-369230.76923076919,-399999.99999999994,-430769.23076923069,-461538.46153846144,-492307.6923076922,-523076.92307692295,-553846.15384615376,-584615.38461538451,-615384.61538461526]
[null,"Reduction in Tax Liability on Active and Portfolio Income"]
[null,"Total Taxes Due on Sale",null,{"$f":"SUM(D106:D108)","v":0},{"$f":"SUM(E106:E108)","v":0},0,0,-49399.063431501621,-135490.41058414639,-143844.30960150433,-246503.0238901207,-342198.3935901582,-445588.70904783159,-548464.05852919433,-635233.3901011314,-724242.72570517613,-815581.66550261504,-909343.39366118051,-1005624.8217153201,-1104526.7376608555,-1206153.9610134433,-1310615.504069366,-1418024.7396167566]
[]
[]
["LOAN AMORTIZATION SCHEDULE"]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
["Mortgage Payment",null,null,{"$f":"-12*PMT(M1INT/12,M1AMORT*12,-LOANAMT)","v":-459775.16167916544},{"$f":"-12*PMT(M1INT/12,M1AMORT*12,-LOANAMT)","v":-459775.16167916544},-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544,-459775.16167916544]
[null,"Interest",null,{"$f":"D114-D116","v":-419240.01544558536},{"$f":"E114-E116","v":-415766.47207557596},-411995.27334558964,-407900.91253127344,-403455.69718249608,-398629.56182385795,-393389.86460506823,-387701.16652587987,-381524.99174232595,-374819.56733307801,-367539.54076584894,-359635.67315286584,-351054.50622075796,-341738.00074238703,-331623.14398510894,-320641.52352046734,-308718.86451270152,-295774.52735652495,-281720.96226642141,-266463.11712851468,{"$f":"X114-X116","v":-249897.79461001093},-231912.954177971,-212386.95430657594,-191187.72974750912,-168171.89829889755,-143183.79103134107,-116054.39941196796,-86600.232205279986,-54622.074419384357,-19903.639903696137]
[null,"Principal",null,{"$f":"-C117+D117","v":-40535.146233580075},{"$f":"-D117+E117","v":-44008.689603589475},-47779.8883335758,-51874.249147891998,-56319.46449666936,-61145.59985530749,-66385.297074097209,-72073.995153285563,-78250.169936839491,-84955.594346087426,-92235.620913316496,-100139.4885262996,-108720.65545840748,-118037.16093677841,-128152.0176940565,-139133.6381586981,-151056.29716646392,-164000.63432264049,-178054.19941274403,-193312.04455065075,{"$f":"-W117+X117","v":-209877.36706915451},-227862.20750119444,-247388.2073725895,-268587.43193165632,-291603.26338026789,-316591.37064782437,-343720.76226719748,-373174.92947388545,-405153.08725978108,-439871.5217754693]
[null,"Loan Balance",{"$f":"LOANAMT","v":5100000},{"$f":"PV(M1INT/12,(M1AMORT-D113)*12,-(-D114/12))","v":5059464.8537664199},{"$f":"PV(M1INT/12,(M1AMORT-E113)*12,-(-E114/12))","v":5015456.1641628304},4967676.2758292546,4915802.0266813627,4859482.5621846933,4798336.9623293858,4731951.6652552886,4659877.670102003,4581627.5001651635,4496671.9058190761,4404436.2849057596,4304296.79637946,4195576.1409210525,4077538.9799842741,3949386.9622902176,3810253.3241315195,3659197.0269650556,3495196.3926424151,3317142.1932296711,3123830.1486790203,{"$f":"PV(M1INT/12,(M1AMORT-X113)*12,-(-X114/12))","v":2913952.7816098658},2686090.5741086714,2438702.3667360819,2170114.9348044256,1878511.6714241577,1561920.3007763333,1218199.5385091358,845024.60903525038,439871.5217754693,0]
[]
[]
["INVESTOR RETURN CALCULATIONS"]
[]
[null,"Overall Property Return Measures"]
[]
[null,"Overall IRR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Present Value at \"&TEXT(DISCRATE, \"0.00%\")","v":"Present Value at 12.00%"}]
["1 Year",{"$f":"IRR(C125:W125,0.12)","v":-0.14543121764705891},{"$f":"-PRICE_CAPS","v":-6000000},{"$f":"D$62+D$80","v":5127412.6941176467},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NPV(DISCRATE,D125:W125)","v":4578047.0483193267}]
["2 Year",{"$f":"IRR(C126:W126,0.12)","v":-2.3474645135900252E-2},{"$f":"-PRICE_CAPS","v":-6000000},{"$f":"D$62","v":398455},{"$f":"E$62+E$80","v":5332509.2018823512},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NPV(DISCRATE,D126:W126)","v":4606807.0805822304}]
["3 Year",2.0901751049784645E-2,-6000000,398455,414393.2,{"$f":"F$62+F$80","v":5545809.5699576456},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4633512.824826357]
["4 Year",4.3792406176262455E-2,-6000000,398455,414393.2,430968.9279999999,{"$f":"G$62+G$80","v":5767641.9527559513},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4658311.0159101877]
["5 Year",5.7729360339658031E-2,-6000000,398455,414393.2,430968.9279999999,448207.68511999992,{"$f":"H$62+H$80","v":5998347.6308661913},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4681337.9076308887]
["6 Year",6.7086815778821363E-2,-6000000,398455,414393.2,430968.9279999999,448207.68511999992,466135.99252479989,{"$f":"I$62+I$80","v":6238281.5361008393},null,null,null,null,null,null,null,null,null,null,null,null,null,null,4702720.0213715397]
["7 Year",7.3789267442556428E-2,-6000000,398455,414393.2,430968.9279999999,448207.68511999992,466135.99252479989,484781.43222579209,{"$f":"J$62+J$80","v":6487812.7975448724},null,null,null,null,null,null,null,null,null,null,null,null,null,4722574.8412735723]
["8 Year",7.8815644986078848E-2,-6000000,398455,414393.2,430968.9279999999,448207.68511999992,466135.99252479989,484781.43222579209,504172.68951482378,{"$f":"K$62+K$80","v":6747325.3094466683},null,null,null,null,null,null,null,null,null,null,null,null,4741011.4597540312]
["9 Year",8.2716483061735069E-2,-6000000,398455,414393.2,430968.9279999999,448207.68511999992,466135.99252479989,484781.43222579209,504172.68951482378,524339.59709541663,{"$f":"L$62+L$80","v":7017218.3218245339},null,null,null,null,null,null,null,null,null,null,null,4758131.1769144572]
["10 Year",8.5825145598924735E-2,-6000000,398455,414393.2,430968.9279999999,448207.68511999992,466135.99252479989,484781.43222579209,504172.68951482378,524339.59709541663,545313.18097923347,{"$f":"M$62+M$80","v":7297907.0546975154},null,null,null,null,null,null,null,null,null,null,4774028.0571348518]
["11 Year",8.8355298204421784E-2,-6000000,398455,414393.2,430968.9279999999,448207.68511999992,466135.99252479989,484781.43222579209,504172.68951482378,524339.59709541663,545313.18097923347,567125.70821840269,{"$f":"N$62+N$80","v":7589823.3368854178},null,null,null,null,null,null,null,null,null,4788789.4459109353]
["12 Year",9.0450208563021217E-2,-6000000,398455,414393.2,430968.9279999999,448207.68511999992,466135.99252479989,484781.43222579209,504172.68951482378,524339.59709541663,545313.18097923347,567125.70821840269,589810.73654713877,{"$f":"O$62+O$80","v":7893416.2703608358},null,null,null,null,null,null,null,null,4802496.4497744385]
["13 Year",9.2209535176746016E-2,-6000000,398455,414393.2,430968.9279999999,448207.68511999992,466135.99252479989,484781.43222579209,504172.68951482378,524339.59709541663,545313.18097923347,567125.70821840269,589810.73654713877,613403.16600902448,{"$f":"P$62+P$80","v":8209152.9211752666},null,null,null,null,null,null,null,4815224.3819334069]
["14 Year",9.3704748492705825E-2,-6000000,398455,414393.2,430968.9279999999,448207.68511999992,466135.99252479989,484781.43222579209,504172.68951482378,524339.59709541663,545313.18097923347,567125.70821840269,589810.73654713877,613403.16600902448,637939.29264938552,{"$f":"Q$62+Q$80","v":8537519.0380222816},null,null,null,null,null,null,4827043.1760810213]
["15 Year",9.498844027646558E-2,-6000000,398455,414393.2,430968.9279999999,448207.68511999992,466135.99252479989,484781.43222579209,504172.68951482378,524339.59709541663,545313.18097923347,567125.70821840269,589810.73654713877,613403.16600902448,637939.29264938552,663456.86435536074,{"$f":"R$62+R$80","v":8879019.7995431703},null,null,null,null,null,4838017.7706466615]
["16 Year",9.6100172009915497E-2,-6000000,398455,414393.2,430968.9279999999,448207.68511999992,466135.99252479989,484781.43222579209,504172.68951482378,524339.59709541663,545313.18097923347,567125.70821840269,589810.73654713877,613403.16600902448,637939.29264938552,663456.86435536074,689995.13892957557,{"$f":"S$62+S$80","v":9234180.5915248971},null,null,null,null,4848208.465600471]
["17 Year",9.7070275849735488E-2,-6000000,398455,414393.2,430968.9279999999,448207.68511999992,466135.99252479989,484781.43222579209,504172.68951482378,524339.59709541663,545313.18097923347,567125.70821840269,589810.73654713877,613403.16600902448,637939.29264938552,663456.86435536074,689995.13892957557,{"$f":"S$62","v":717594.94448675844},{"$f":"T$62+T$80","v":9603547.8151858915},null,null,null,4857671.2537718648]
["18 Year",9.7922398277290323E-2,-6000000,{"$f":"D$62","v":398455},414393.2,430968.9279999999,448207.68511999992,466135.99252479989,484781.43222579209,504172.68951482378,524339.59709541663,545313.18097923347,567125.70821840269,589810.73654713877,613403.16600902448,637939.29264938552,663456.86435536074,689995.13892957557,{"$f":"S$62","v":717594.94448675844},{"$f":"T$62","v":746298.74226622877},{"$f":"U$62+U$80","v":9987689.7277933247},null,null,4866458.1285024453]
["19 Year",9.8675246304347652E-2,-6000000,398455,414393.2,430968.9279999999,448207.68511999992,466135.99252479989,484781.43222579209,504172.68951482378,524339.59709541663,545313.18097923347,567125.70821840269,589810.73654713877,613403.16600902448,637939.29264938552,663456.86435536074,689995.13892957557,{"$f":"S$62","v":717594.94448675844},{"$f":"T$62","v":746298.74226622877},{"$f":"U$62","v":776150.69195687771},{"$f":"V$62+V$80","v":10387197.316905061},null,4874617.3693236988]
["20 Year",9.9343813422517524E-2,-6000000,{"$f":"D$62","v":398455},414393.2,430968.9279999999,448207.68511999992,466135.99252479989,484781.43222579209,504172.68951482378,524339.59709541663,545313.18097923347,567125.70821840269,589810.73654713877,613403.16600902448,637939.29264938552,663456.86435536074,689995.13892957557,{"$f":"S$62","v":717594.94448675844},{"$f":"T$62","v":746298.74226622877},{"$f":"U$62","v":776150.69195687771},{"$f":"V$62","v":807196.71963515261},{"$f":"W$62+W$80","v":10802685.209581265},4882193.8072291492]
[]
[null,"Value by Direct Cap",{"$f":"D62/CAPIN","v":4980687.5}]
[]
[null,"Equity Return Measures"]
[]
[null,"Cash on Cash (EDR)",null,{"$f":"D69/EQUITY","v":-6.8133512976850469E-2},-5.0424401865739349E-2,-3.2006926310183918E-2,-1.2852751732406112E-2,7.0675898284827416E-3,2.7784745051807405E-2,4.9330586484064839E-2,7.1738261573612433E-2,9.5042243666742257E-2,0.11927838504359695,0.14448397207552593,0.17069778258873228,0.19796014552246677,0.22631300297355028,0.25579997472267785,0.28646642534176991,0.31835953398562589,0.35152836697523582,0.38602395328443018,0.42189936304599279]
[]
[null,"Overall IRR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Present Value at \"&TEXT(EQRATE, \"0.00%\")","v":"Present Value at 15.00%"}]
["1 Year",{"$f":"IRR(C153:W153,0.12)","v":{"$error":"#NUM!"}},{"$f":"-EQUITY","v":-900000},{"$f":"D$69+D$82","v":-391827.3213279387},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NPV(EQRATE,D153:W153)","v":-340719.40985038149}]
["2 Year",{"$f":"IRR(C154:W154,0.12)","v":{"$error":"#NUM!"}},{"$f":"-EQUITY","v":-900000},{"$f":"D$69","v":-61320.161679165423},{"$f":"E$69+E$82","v":-142722.12395964487},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NPV(EQRATE,D154:W154)","v":-161240.30993624587}]
["3 Year",-0.54464003869469191,-900000,{"$f":"D$69","v":-61320.161679165423},-45381.961679165412,{"$f":"F$69+F$82","v":118358.13244922513},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-9814.7693285190144]
["4 Year",-0.23075459831601086,-900000,-61320.161679165423,-45381.961679165412,-28806.233679165525,{"$f":"G$69+G$82","v":392064.76439542358},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,117586.57263225125]
["5 Year",-8.8026634661851566E-2,-900000,-61320.161679165423,-45381.961679165412,-28806.233679165525,-11567.476559165501,{"$f":"H$69+H$82","v":679089.90700233262},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,224436.23177791465]
["6 Year",-1.0361620899145607E-2,-900000,-61320.161679165423,-45381.961679165412,-28806.233679165525,-11567.476559165501,6360.8308456344676,{"$f":"I$69+I$82","v":980169.41209228837},null,null,null,null,null,null,null,null,null,null,null,null,null,null,313725.27146999555]
["7 Year",3.59975365345655E-2,-900000,-61320.161679165423,-45381.961679165412,-28806.233679165525,-11567.476559165501,6360.8308456344676,25006.270546626663,{"$f":"J$69+J$82","v":1296085.9706104179},null,null,null,null,null,null,null,null,null,null,null,null,null,388028.61005935882]
["8 Year",6.5458167626255781E-2,-900000,-61320.161679165423,-45381.961679165412,-28806.233679165525,-11567.476559165501,6360.8308456344676,25006.270546626663,44397.527835658359,{"$f":"K$69+K$82","v":1627672.4776654996},null,null,null,null,null,null,null,null,null,null,null,null,449561.58216610871]
["9 Year",8.5054396310463076E-2,-900000,-61320.161679165423,-45381.961679165412,-28806.233679165525,-11567.476559165501,6360.8308456344676,25006.270546626663,44397.527835658359,64564.435416251188,{"$f":"L$69+L$82","v":1975815.6599802051},null,null,null,null,null,null,null,null,null,null,null,500228.91569428472]
["10 Year",9.8546873361802456E-2,-900000,-61320.161679165423,-45381.961679165412,-28806.233679165525,-11567.476559165501,6360.8308456344676,25006.270546626663,44397.527835658359,64564.435416251188,85538.01930006803,{"$f":"M$69+M$82","v":2341459.9871992734},null,null,null,null,null,null,null,null,null,null,541667.13296095328]
["11 Year",0.10808755869043152,-900000,-61320.161679165423,-45381.961679165412,-28806.233679165525,-11567.476559165501,6360.8308456344676,25006.270546626663,44397.527835658359,64564.435416251188,85538.01930006803,107350.54653923726,{"$f":"N$69+N$82","v":2725611.8903004928},null,null,null,null,null,null,null,null,null,575281.25099791668]
["12 Year",0.11497538204901336,-900000,-61320.161679165423,-45381.961679165412,-28806.233679165525,-11567.476559165501,6360.8308456344676,25006.270546626663,44397.527835658359,64564.435416251188,85538.01930006803,107350.54653923726,130035.57486797334,{"$f":"O$69+O$82","v":3129344.3123022104},null,null,null,null,null,null,null,null,602276.54032225092]
["13 Year",0.12002896795631024,-900000,-61320.161679165423,-45381.961679165412,-28806.233679165525,-11567.476559165501,6360.8308456344676,25006.270546626663,44397.527835658359,64564.435416251188,85538.01930006803,107350.54653923726,130035.57486797334,153628.00432985905,{"$f":"P$69+P$82","v":3553801.6185750486},null,null,null,null,null,null,null,623686.00096265005]
["14 Year",0.1237829657115328,-900000,-61320.161679165423,-45381.961679165412,-28806.233679165525,-11567.476559165501,6360.8308456344676,25006.270546626663,44397.527835658359,64564.435416251188,85538.01930006803,107350.54653923726,130035.57486797334,153628.00432985905,178164.13097022008,{"$f":"Q$69+Q$82","v":4000204.8963588425},null,null,null,null,null,null,640394.12726810121]
["15 Year",0.12659716816583511,-900000,-61320.161679165423,-45381.961679165412,-28806.233679165525,-11567.476559165501,6360.8308456344676,25006.270546626663,44397.527835658359,64564.435416251188,85538.01930006803,107350.54653923726,130035.57486797334,153628.00432985905,178164.13097022008,203681.70267619524,{"$f":"R$69+R$82","v":4469857.6755737886},null,null,null,null,null,653157.45727245254]
["16 Year",0.1287199404887025,-900000,-61320.161679165423,-45381.961679165412,-28806.233679165525,-11567.476559165501,6360.8308456344676,25006.270546626663,44397.527835658359,64564.435416251188,85538.01930006803,107350.54653923726,130035.57486797334,153628.00432985905,178164.13097022008,203681.70267619524,230219.97725041007,{"$f":"S$69+S$82","v":4964152.1057142131},null,null,null,null,662622.33663006802]
["17 Year",0.13032652120399812,-900000,-61320.161679165423,-45381.961679165412,-28806.233679165525,-11567.476559165501,6360.8308456344676,25006.270546626663,44397.527835658359,64564.435416251188,85538.01930006803,107350.54653923726,130035.57486797334,153628.00432985905,178164.13097022008,203681.70267619524,230219.97725041007,257819.78280759294,{"$f":"T$69+T$82","v":5484575.6265416704},null,null,null,669340.27005948441]
["18 Year",0.13154292033420178,-900000,-61320.161679165423,-45381.961679165412,-28806.233679165525,-11567.476559165501,6360.8308456344676,25006.270546626663,44397.527835658359,64564.435416251188,85538.01930006803,107350.54653923726,130035.57486797334,153628.00432985905,178164.13097022008,203681.70267619524,230219.97725041007,257819.78280759294,286523.58058706328,{"$f":"U$69+U$82","v":6032718.1734717442},null,null,673781.18369198532]
["19 Year",0.13246126184494433,-900000,-61320.161679165423,-45381.961679165412,-28806.233679165525,-11567.476559165501,6360.8308456344676,25006.270546626663,44397.527835658359,64564.435416251188,85538.01930006803,107350.54653923726,130035.57486797334,153628.00432985905,178164.13097022008,203681.70267619524,230219.97725041007,257819.78280759294,286523.58058706328,316375.53027771221,{"$f":"V$69+V$82","v":6610279.9619962228},null,676344.87872803095]
["20 Year",0.13314988289404339,-900000,-61320.161679165423,-45381.961679165412,-28806.233679165525,-11567.476559165501,6360.8308456344676,25006.270546626663,44397.527835658359,64564.435416251188,85538.01930006803,107350.54653923726,130035.57486797334,153628.00432985905,178164.13097022008,203681.70267619524,230219.97725041007,257819.78280759294,286523.58058706328,316375.53027771221,347421.55795598717,{"$f":"W$69+W$82","v":7219079.8992230799},677370.91949484858]

{"sheet":"PartnershipCF","index":4,"n_rows":87,"n_cols":22,"rows_kept":87,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,9]]}
["PARTNERSHIP CASH FLOWS"]
["APARTMENT INVESTMENT"]
[{"$f":"PropName","v":"Mertz Apartments"}]
[{"$f":"PropAddr","v":"555 Main Street"}]
[]
["OVERALL PROPERTY CASH FLOWS"]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20","Year 21"]
["BTCF",{"$f":"'Cash Flow'!D69","v":-61320.161679165423},{"$f":"'Cash Flow'!E69","v":-45381.961679165412},{"$f":"'Cash Flow'!F69","v":-28806.233679165525},{"$f":"'Cash Flow'!G69","v":-11567.476559165501},{"$f":"'Cash Flow'!H69","v":6360.8308456344676},{"$f":"'Cash Flow'!I69","v":25006.270546626663},{"$f":"'Cash Flow'!J69","v":44397.527835658359},{"$f":"'Cash Flow'!K69","v":64564.435416251188},{"$f":"'Cash Flow'!L69","v":85538.01930006803},{"$f":"'Cash Flow'!M69","v":107350.54653923726},{"$f":"'Cash Flow'!N69","v":130035.57486797334},{"$f":"'Cash Flow'!O69","v":153628.00432985905},{"$f":"'Cash Flow'!P69","v":178164.13097022008},{"$f":"'Cash Flow'!Q69","v":203681.70267619524},{"$f":"'Cash Flow'!R69","v":230219.97725041007},{"$f":"'Cash Flow'!S69","v":257819.78280759294},{"$f":"'Cash Flow'!T69","v":286523.58058706328},{"$f":"'Cash Flow'!U69","v":316375.53027771221},{"$f":"'Cash Flow'!V69","v":347421.55795598717},{"$f":"'Cash Flow'!W69","v":379709.42674139352},{"$f":"'Cash Flow'!X69","v":413288.81027821603}]
["Taxable Income",{"$f":"'Cash Flow'!D66","v":-143861.93852250843},{"$f":"'Cash Flow'!E66","v":-124450.19515249901},{"$f":"'Cash Flow'!F66","v":-104103.2684225128},{"$f":"'Cash Flow'!G66","v":-82770.150488196581},{"$f":"'Cash Flow'!H66","v":-60396.627734619251},{"$f":"'Cash Flow'!I66","v":-36925.052674988925},{"$f":"'Cash Flow'!J66","v":-12294.098167167511},{"$f":"'Cash Flow'!K66","v":13561.507492613688},{"$f":"'Cash Flow'!L66","v":40711.266159984458},{"$f":"'Cash Flow'!M66","v":69229.21780840162},{"$f":"'Cash Flow'!N66","v":99194.272704366769},{"$f":"'Cash Flow'!O66","v":130690.56977923558},{"$f":"'Cash Flow'!P66","v":163807.86335170449},{"$f":"'Cash Flow'!Q66","v":198641.94053605059},{"$f":"'Cash Flow'!R66","v":235295.07186754351},{"$f":"'Cash Flow'!S66","v":273876.49788936798},{"$f":"'Cash Flow'!T66","v":314502.95467660413},{"$f":"'Cash Flow'!U66","v":357299.24152342963},{"$f":"'Cash Flow'!V66","v":402398.83429180807},{"$f":"'Cash Flow'!W66","v":449944.54821512115},{"$f":"'Cash Flow'!X66","v":500089.25427044742}]
[]
["BTER",{"$f":"'Cash Flow'!D82","v":-330507.15964877326},{"$f":"'Cash Flow'!E82","v":-97340.162280479446},{"$f":"'Cash Flow'!F82","v":147164.36612839065},{"$f":"'Cash Flow'!G82","v":403632.2409545891},{"$f":"'Cash Flow'!H82","v":672729.07615669817},{"$f":"'Cash Flow'!I82","v":955163.14154566173},{"$f":"'Cash Flow'!J82","v":1251688.4427747596},{"$f":"'Cash Flow'!K82","v":1563108.0422492484},{"$f":"'Cash Flow'!L82","v":1890277.6406801371},{"$f":"'Cash Flow'!M82","v":2234109.4406600362},{"$f":"'Cash Flow'!N82","v":2595576.3154325197},{"$f":"'Cash Flow'!O82","v":2975716.3079723511},{"$f":"'Cash Flow'!P82","v":3375637.4876048286},{"$f":"'Cash Flow'!Q82","v":3796523.1936826473},{"$f":"'Cash Flow'!R82","v":4239637.6983233783},{"$f":"'Cash Flow'!S82","v":4706332.3229066199},{"$f":"'Cash Flow'!T82","v":5198052.0459546074},{"$f":"'Cash Flow'!U82","v":5716342.6431940319},{"$f":"'Cash Flow'!V82","v":6262858.404040236},{"$f":"'Cash Flow'!W82","v":6839370.4724816866}]
["Capital Gain",{"$f":"'Cash Flow'!D91","v":0},{"$f":"'Cash Flow'!E91","v":0},{"$f":"'Cash Flow'!F91","v":0},{"$f":"'Cash Flow'!G91","v":0},{"$f":"'Cash Flow'!H91","v":0},{"$f":"'Cash Flow'!I91","v":0},{"$f":"'Cash Flow'!J91","v":0},{"$f":"'Cash Flow'!K91","v":1745.8886813725694},{"$f":"'Cash Flow'!L91","v":326376.58333540626},{"$f":"'Cash Flow'!M91","v":689482.00677761948},{"$f":"'Cash Flow'!N91","v":1050012.6003382793},{"$f":"'Cash Flow'!O91","v":1330013.1043518111},{"$f":"'Cash Flow'!P91","v":1621213.6285258811},{"$f":"'Cash Flow'!Q91","v":1924062.1736669214},{"$f":"'Cash Flow'!R91","v":2239024.6606135955},{"$f":"'Cash Flow'!S91","v":2566585.6470381394},{"$f":"'Cash Flow'!T91","v":2907249.072919663},{"$f":"'Cash Flow'!U91","v":3261539.035836447},{"$f":"'Cash Flow'!V91","v":3630000.5972699076},{"$f":"'Cash Flow'!W91","v":4013200.6211607065}]
["Capital Gain, Part I, Gain on Sale",{"$f":"'Cash Flow'!D90","v":0},{"$f":"'Cash Flow'!E90","v":0},{"$f":"'Cash Flow'!F90","v":0},{"$f":"'Cash Flow'!G90","v":0},{"$f":"'Cash Flow'!H90","v":0},{"$f":"'Cash Flow'!I90","v":0},{"$f":"'Cash Flow'!J90","v":33640.108030048199},{"$f":"'Cash Flow'!K90","v":272985.71235125139},{"$f":"'Cash Flow'!L90","v":521905.14084530063},{"$f":"'Cash Flow'!M90","v":780781.34647911228},{"$f":"'Cash Flow'!N90","v":1050012.6003382793},{"$f":"'Cash Flow'!O90","v":1330013.1043518111},{"$f":"'Cash Flow'!P90","v":1621213.6285258811},{"$f":"'Cash Flow'!Q90","v":1924062.1736669214},{"$f":"'Cash Flow'!R90","v":2239024.6606135955},{"$f":"'Cash Flow'!S90","v":2566585.6470381394},{"$f":"'Cash Flow'!T90","v":2907249.072919663},{"$f":"'Cash Flow'!U90","v":3261539.035836447},{"$f":"'Cash Flow'!V90","v":3630000.5972699076},{"$f":"'Cash Flow'!W90","v":4013200.6211607065}]
["Capital Gain, Part II, Depr Recapture",{"$f":"'Cash Flow'!D95","v":123076.92307692308},{"$f":"'Cash Flow'!E95","v":246153.84615384616},{"$f":"'Cash Flow'!F95","v":369230.76923076925},{"$f":"'Cash Flow'!G95","v":492307.69230769231},{"$f":"'Cash Flow'!H95","v":615384.61538461538},{"$f":"'Cash Flow'!I95","v":738461.5384615385},{"$f":"'Cash Flow'!J95","v":861538.46153846162},{"$f":"'Cash Flow'!K95","v":984615.38461538474},{"$f":"'Cash Flow'!L95","v":1107692.3076923077},{"$f":"'Cash Flow'!M95","v":1230769.2307692308},{"$f":"'Cash Flow'!N95","v":1353846.1538461538},{"$f":"'Cash Flow'!O95","v":1476923.0769230768},{"$f":"'Cash Flow'!P95","v":1599999.9999999998},{"$f":"'Cash Flow'!Q95","v":1723076.9230769228},{"$f":"'Cash Flow'!R95","v":1846153.8461538458},{"$f":"'Cash Flow'!S95","v":1969230.7692307688},{"$f":"'Cash Flow'!T95","v":2092307.6923076918},{"$f":"'Cash Flow'!U95","v":2215384.615384615},{"$f":"'Cash Flow'!V95","v":2338461.538461538},{"$f":"'Cash Flow'!W95","v":2461538.461538461}]
["Gain Realized on Sale",{"$f":"'Cash Flow'!D102","v":-1097965.3828054303},{"$f":"'Cash Flow'!E102","v":-785730.15196380299},{"$f":"'Cash Flow'!F102","v":-465928.58881158568},{"$f":"'Cash Flow'!G102","v":-138258.04005635623},{"$f":"'Cash Flow'!H102","v":197596.25372600649},{"$f":"'Cash Flow'!I102","v":541961.64233658556},{"$f":"'Cash Flow'!J102","v":895178.56956851017},{"$f":"'Cash Flow'!K102","v":1257601.0969666364},{"$f":"'Cash Flow'!L102","v":1629597.4485376086},{"$f":"'Cash Flow'!M102","v":2011550.5772483433},{"$f":"'Cash Flow'!N102","v":2403858.7541844333},{"$f":"'Cash Flow'!O102","v":2806936.1812748881},{"$f":"'Cash Flow'!P102","v":3221213.6285258811},{"$f":"'Cash Flow'!Q102","v":3647139.0967438444},{"$f":"'Cash Flow'!R102","v":4085178.5067674415},{"$f":"'Cash Flow'!S102","v":4535816.4162689084},{"$f":"'Cash Flow'!T102","v":4999556.7652273551},{"$f":"'Cash Flow'!U102","v":5476923.6512210621},{"$f":"'Cash Flow'!V102","v":5968462.1357314456},{"$f":"'Cash Flow'!W102","v":6474739.0826991675}]
[]
["GENERAL PARTNER CASH FLOWS"]
["BTCF",{"$f":"B8*GPCASHOPS","v":-18396.048503749626},-13614.588503749623,-8641.8701037496576,-3470.2429677496502,1908.2492536903401,7501.8811639879987,13319.258350697508,19369.330624875354,25661.40579002041,32205.163961771177,39010.672460392001,46088.40129895771,53449.23929106602,61104.510802858567,69065.993175123018,77345.934842277886,85957.074176118986,94912.659083313658,104226.46738679615,113912.82802241805]
[]
["Taxes",{"$f":"B29","v":9800.0000000000018},{"$f":"C29","v":9800.0000000000018},9800.0000000000018,8835.586417200213,5073.3167297080172,3101.7044246990699,1032.704246042071,-1139.1666293795497,-3419.7463574386948,-5815.2542959057364,-8332.3189071668094,-10978.00786145579,-13759.860521543178,-16685.923005028249,-19764.786036873655,-23005.625822706912,-26418.248192834748,-30013.136287968089,-33801.502080511884,-37795.342050070176]
[]
["BTER",{"$f":"B11*GPREV","v":-99152.147894631969},-29202.048684143832,44149.309838517198,121089.67228637672,201818.72284700946,286548.94246369851,375506.53283242788,468932.41267477447,567083.29220404115,670232.83219801087,778672.89462975587,892714.8923917053,1012691.2462814485,1138956.9581047941,1271891.3094970135,1411899.6968719859,1559415.6137863821,1714902.7929582095,1878857.5212120707,2051811.1417445058]
[]
[]
["PASSIVE LOSSES"]
["Taxable Income",{"$f":"B9*GPTI","v":-43158.581556752528},-37335.0585457497,-31230.98052675384,-24831.045146458975,-18118.988320385775,-11077.515802496677,-3688.2294501502529,4068.452247784106,12213.379847995337,20768.765342520484,29758.281811310029,39207.170933770671,49142.359005511345,59592.582160815175,70588.521560263049,82162.949366810397,94350.886402981239,107189.77245702888,120719.65028754242,134983.36446453634]
["Balance of PLCF",{"$f":"IF(-B26>=GPPLL,B26+GPPLL,0)","v":-8158.5815567525278},{"$f":"IF(-C28>=GPPLL,C28+GPPLL,0)","v":-10493.640102502228},-6724.6206292560673,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Sum of PLCF and Current TI",null,{"$f":"B27+C26","v":-45493.640102502228},{"$f":"C27+D26","v":-41724.620629256067},-31555.665775715042,-18118.988320385775,-11077.515802496677,-3688.2294501502529,4068.452247784106,12213.379847995337,20768.765342520484,29758.281811310029,39207.170933770671,49142.359005511345,59592.582160815175,70588.521560263049,82162.949366810397,94350.886402981239,107189.77245702888,120719.65028754242,134983.36446453634]
["GP Taxes",{"$f":"IF(-B26<=GPPLL,-GPTAXRATE*B26,GPTAXRATE*GPPLL)","v":9800.0000000000018},{"$f":"IF(-C28<=GPPLL,-GPTAXRATE*C28,GPTAXRATE*GPPLL)","v":9800.0000000000018},9800.0000000000018,8835.586417200213,5073.3167297080172,3101.7044246990699,1032.704246042071,-1139.1666293795497,-3419.7463574386948,-5815.2542959057364,-8332.3189071668094,-10978.00786145579,-13759.860521543178,-16685.923005028249,-19764.786036873655,-23005.625822706912,-26418.248192834748,-30013.136287968089,-33801.502080511884,-37795.342050070176]
[]
["CAPITAL GAINS TAXES"]
["Cap Gain Part I, Gain Realized on Sale"]
["GP Share of Gain",{"$f":"B13*GPGAIN","v":0},0,0,0,0,0,10092.032409014459,81895.713705375412,156571.54225359019,234234.40394373369,315003.78010148375,399003.93130554334,486364.08855776431,577218.65210007643,671707.39818407863,769975.69411144184,872174.72187589889,978461.71075093409,1089000.1791809723,1203960.186348212]
["GP Share of Gain, after PLCF",{"$f":"MAX(B33+B27,0)","v":0},{"$f":"MAX(C33+C27,0)","v":0},0,0,0,0,10092.032409014459,81895.713705375412,156571.54225359019,234234.40394373369,315003.78010148375,399003.93130554334,486364.08855776431,577218.65210007643,671707.39818407863,769975.69411144184,872174.72187589889,978461.71075093409,1089000.1791809723,1203960.186348212]
["Tax on Part I of Gain",{"$f":"-B34*GPKTRATE","v":0},0,0,0,0,0,-2018.4064818028919,-16379.142741075084,-31314.308450718039,-46846.880788746741,-63000.756020296751,-79800.786261108675,-97272.817711552867,-115443.73042001529,-134341.47963681573,-153995.13882228837,-174434.9443751798,-195692.34215018683,-217800.03583619447,-240792.0372696424]
["Memo: Remaining PLCF",{"$f":"IF(B33>=0,-((B34-B33)-B27),0)","v":-8158.5815567525278},{"$f":"IF(C33>=0,-((C34-C33)-C27),0)","v":-10493.640102502228},-6724.6206292560673,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Cap Gain Part II, depreciation recapture"]
["GP Share of Gain",{"$f":"B14*GPGAIN","v":36923.076923076922},73846.153846153844,110769.23076923077,147692.30769230769,184615.3846153846,221538.46153846153,258461.53846153847,295384.61538461543,332307.69230769231,369230.76923076919,406153.84615384613,443076.92307692301,479999.99999999988,516923.07692307682,553846.15384615376,590769.23076923063,627692.30769230751,664615.38461538451,701538.46153846139,738461.53846153826]
["GP Share of Gain, after PLCF",{"$f":"MAX(B39+B36,0)","v":28764.495366324394},{"$f":"MAX(C39+C36,0)","v":63352.513743651616},104044.6101399747,147692.30769230769,184615.3846153846,221538.46153846153,258461.53846153847,295384.61538461543,332307.69230769231,369230.76923076919,406153.84615384613,443076.92307692301,479999.99999999988,516923.07692307682,553846.15384615376,590769.23076923063,627692.30769230751,664615.38461538451,701538.46153846139,738461.53846153826]
["GP Share; Gain Realized on Sale",{"$f":"B15*GPGAIN","v":-329389.61484162911},-235719.04558914088,-139778.57664347571,-41477.41201690687,59278.876117801941,162588.49270097565,268553.57087055303,377280.32908999088,488879.23456128256,603465.17317450291,721157.62625532993,842080.85438246641,966364.08855776431,1094141.7290231532,1225553.5520302325,1360744.9248806725,1499867.0295682065,1643077.0953663185,1790538.6407194335,1942421.7248097502]
["Tax on Part II of Gain",{"$f":"MIN(-GPKTRDEPR*IF(B41>B40,B40,B41),0)","v":0},0,0,0,-14819.719029450485,-40647.123175243913,-64615.384615384617,-73846.153846153858,-83076.923076923078,-92307.692307692298,-101538.46153846153,-110769.23076923075,-119999.99999999997,-129230.76923076921,-138461.53846153844,-147692.30769230766,-156923.07692307688,-166153.84615384613,-175384.61538461535,-184615.38461538457]
["Memo: Remaining PLCF"]
[]
["GP Total Capital Gains Tax",{"$f":"B35+B42","v":0},{"$f":"C35+C42","v":0},0,0,-14819.719029450485,-40647.123175243913,-66633.79109718751,-90225.29658722895,-114391.23152764112,-139154.57309643904,-164539.21755875828,-190570.01703033943,-217272.81771155284,-244674.49965078448,-272803.01809835416,-301687.446514596,-331358.0212982567,-361846.18830403296,-393184.65122080978,-425407.42188502697]
[]
[]
[]
["LIMITED PARTNER CASH FLOWS"]
["BTCF",{"$f":"B8*LPCASHOPS","v":-42924.11317541579},-31767.373175415785,-20164.363575415868,-8097.2335914158502,4452.5815919441266,17504.389382638663,31078.269484960849,45195.10479137583,59876.613510047617,75145.38257746608,91024.902407581336,107539.60303090133,124714.89167915405,142577.19187333665,161153.98407528704,180473.84796531504,200566.50641094428,221462.87119439853,243195.090569191,265796.59871897544]
[]
["Taxable Income",{"$f":"B9*LPTI","v":-100703.3569657559},-87115.136606749307,-72872.287895758956,-57939.105341737602,-42277.639414233476,-25847.536872492245,-8605.8687170172561,9493.0552448295803,28497.886311989118,48460.452465881128,69435.990893056733,91483.398845464893,114665.50434619313,139049.3583752354,164706.55030728044,191713.54852255757,220152.06827362289,250109.46906640072,281679.18400426564,314961.18375058478]
["Taxes"]
[]
["BTER",{"$f":"B11*LPREV","v":-231355.01175414128},-68138.113596335606,103015.05628987345,282542.56866821233,470910.35330968868,668614.19908196316,876181.90994233172,1094175.6295744737,1323194.3484760958,1563876.6084620252,1816903.4208027637,2083001.4155806457,2362946.2413233798,2657566.2355778529,2967746.3888263647,3294432.6260346337,3638636.4321682248,4001439.8502358221,4384000.8828281648,4787559.3307371801]
[]
["PASSIVE LOSSES"]
["Taxable Income",{"$f":"B41*LPTI","v":-230572.73038914037},-165003.3319123986,-97845.003650432991,-29034.188411834806,41495.213282461358,113811.94489068295,187987.4996093871,264096.23036299361,342215.46419289778,422425.62122215203,504810.33837873093,589456.59806772647,676454.86199043493,765899.21031620714,857887.48642116273,952521.44741647062,1049906.9206977445,1150153.9667564228,1253377.0485036033,1359695.2073668251]
["Balance of PLCF",{"$f":"IF(-B58>=LPPLL,B58+LPPLL,0)","v":-220572.73038914037},-155003.3319123986,-87845.003650432991,-19034.188411834806,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Sum of PLCF and Current TI",null,{"$f":"B59+C58","v":-385576.062301539},{"$f":"C59+D58","v":-252848.33556283161},-116879.1920622678,22461.024870626552,113811.94489068295,187987.4996093871,264096.23036299361,342215.46419289778,422425.62122215203,504810.33837873093,589456.59806772647,676454.86199043493,765899.21031620714,857887.48642116273,952521.44741647062,1049906.9206977445,1150153.9667564228,1253377.0485036033,1359695.2073668251]
["LP Taxes",{"$f":"IF(-B58<=LPPLL,-LPTAXRATE*B58,LPTAXRATE*LPPLL)","v":2800.0000000000005},2800.0000000000005,2800.0000000000005,2800.0000000000005,-11618.659719089181,-31867.344569391229,-52636.499890628394,-73946.944501638223,-95820.329974011387,-118279.17394220257,-141346.89474604468,-165047.84745896343,-189407.36135732179,-214451.77888853801,-240208.49619792559,-266706.00527661177,-293973.93779536849,-322043.11069179839,-350945.57358100894,-380714.65806271107]
[]
["CAPITAL GAINS TAXES"]
["Cap Gain Part I, Gain Realized on Sale"]
["LP Share of Gain",{"$f":"B13*LPGAIN","v":0},0,0,0,0,0,23548.075621033739,191089.99864587595,365333.59859171044,546546.94253537862,735008.82023679547,931009.17304626771,1134849.5399681167,1346843.521566845,1567317.2624295168,1796609.9529266974,2035074.351043764,2283077.3250855128,2541000.4180889353,2809240.4348124946]
["LP Share of Gain, after PLCF",{"$f":"MAX(B65+B59,0)","v":0},0,0,0,0,0,23548.075621033739,191089.99864587595,365333.59859171044,546546.94253537862,735008.82023679547,931009.17304626771,1134849.5399681167,1346843.521566845,1567317.2624295168,1796609.9529266974,2035074.351043764,2283077.3250855128,2541000.4180889353,2809240.4348124946]
["Tax on Part I of Gain",{"$f":"-B66*LPKTRATE","v":0},0,0,0,0,0,-4709.6151242067481,-38217.999729175193,-73066.719718342094,-109309.38850707572,-147001.76404735909,-186201.83460925356,-226969.90799362335,-269368.704313369,-313463.45248590334,-359321.99058533949,-407014.87020875281,-456615.4650171026,-508200.08361778711,-561848.08696249896]
["Memo: Remaining PLCF",{"$f":"IF(B65>=0,-((B66-B65)-B59),0)","v":-220572.73038914037},{"$f":"IF(C65>=0,-((C66-C65)-C59),0)","v":-155003.3319123986},{"$f":"IF(D65>=0,-((D66-D65)-D59),0)","v":-87845.003650432991},-19034.188411834806,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Cap Gain Part II, depreciation recapture"]
["LP Share of Gain",{"$f":"B14*LPGAIN","v":86153.846153846156},172307.69230769231,258461.53846153847,344615.38461538462,430769.23076923075,516923.07692307694,603076.92307692312,689230.76923076925,775384.61538461538,861538.4615384615,947692.30769230751,1033846.1538461536,1119999.9999999998,1206153.8461538458,1292307.692307692,1378461.538461538,1464615.3846153843,1550769.2307692305,1636923.0769230765,1723076.9230769225]
["LP Share of Gain, after PLCF",{"$f":"MAX(B71+B68,0)","v":0},17304.360395293712,170616.53481110546,325581.1962035498,430769.23076923075,516923.07692307694,603076.92307692312,689230.76923076925,775384.61538461538,861538.4615384615,947692.30769230751,1033846.1538461536,1119999.9999999998,1206153.8461538458,1292307.692307692,1378461.538461538,1464615.3846153843,1550769.2307692305,1636923.0769230765,1723076.9230769225]
["LP Share; Gain Realized on Sale",{"$f":"B47*LPGAIN","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Tax on Part II of Gain",{"$f":"MIN(-LPKTRDEPR*IF(B73>B72,B72,B73),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Memo: Remaining PLCF"]
[]
["LP Total Capital Gains Tax",{"$f":"B67+B74","v":0},{"$f":"C67+C74","v":0},{"$f":"D67+D74","v":0},0,0,0,-4709.6151242067481,-38217.999729175193,-73066.719718342094,-109309.38850707572,-147001.76404735909,-186201.83460925356,-226969.90799362335,-269368.704313369,-313463.45248590334,-359321.99058533949,-407014.87020875281,-456615.4650171026,-508200.08361778711,-561848.08696249896]
[]
[]
["Cash Flows",{"$f":"B7","v":"Year 1"},{"$f":"C7","v":"Year 2"},{"$f":"D7","v":"Year 3"},"Year 4","Year 5","Year 6","Year 7","Year 8","IRR"]
[]
[{"$f":"-EQUITY","v":-900000},{"$f":"B$50","v":-42924.11317541579},-31767.373175415785,{"$f":"D$50+D55","v":82850.692714457575},null,null,null,null,null,{"$f":"IRR(A82:I82,0.12)","v":-0.58888602361541209}]
[-900000,-42924.11317541579,-31767.373175415785,{"$f":"D$50","v":-20164.363575415868},{"$f":"E$50+E55","v":274445.33507679647},null,null,null,null,-0.28996718062822535]
[-900000,-42924.11317541579,-31767.373175415785,{"$f":"D$50","v":-20164.363575415868},{"$f":"E$50","v":-8097.2335914158502},{"$f":"F$50+F55","v":475362.93490163283},null,null,null,-0.14511958789616375]
[-900000,-42924.11317541579,-31767.373175415785,{"$f":"D$50","v":-20164.363575415868},{"$f":"E$50","v":-8097.2335914158502},{"$f":"F$50","v":4452.5815919441266},{"$f":"G$50+G55","v":686118.58846460178},null,null,-6.2524623099968313E-2]
[-900000,-42924.11317541579,-31767.373175415785,{"$f":"D$50","v":-20164.363575415868},{"$f":"E$50","v":-8097.2335914158502},{"$f":"F$50","v":4452.5815919441266},{"$f":"G$50","v":17504.389382638663},{"$f":"H$50+H55","v":907260.17942729255},null,-1.1215157943601728E-2]
[-900000,-42924.11317541579,-31767.373175415785,{"$f":"D$50","v":-20164.363575415868},{"$f":"E$50","v":-8097.2335914158502},{"$f":"F$50","v":4452.5815919441266},{"$f":"G$50","v":17504.389382638663},{"$f":"H$50","v":31078.269484960849},{"$f":"I$50+I55","v":1139370.7343658495},2.2611743065943379E-2]

{"sheet":"8YRDCF","index":5,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["8-YEAR PRO FORMA"]
["APARTMENT INVESTMENT"]
[{"$f":"PropName","v":"Mertz Apartments"}]
[{"$f":"PropAddr","v":"555 Main Street"}]
[]
[null,null,null,{"$f":"'Cash Flow'!D4","v":"Year 1"},{"$f":"'Cash Flow'!E4","v":"Year 2"},{"$f":"'Cash Flow'!F4","v":"Year 3"},{"$f":"'Cash Flow'!G4","v":"Year 4"},{"$f":"'Cash Flow'!H4","v":"Year 5"},{"$f":"'Cash Flow'!I4","v":"Year 6"},{"$f":"'Cash Flow'!J4","v":"Year 7"},{"$f":"'Cash Flow'!K4","v":"Year 8"},{"$f":"'Cash Flow'!L4","v":"Year 9"}]
[{"$f":"'Cash Flow'!A5","v":"GROSS POTENTIAL INCOME"}]
[{"$f":"'Cash Flow'!A16","v":"Potential Rental Income"},null,null,{"$f":"'Cash Flow'!D16","v":739500},{"$f":"'Cash Flow'!E16","v":769080},{"$f":"'Cash Flow'!F16","v":799843.2},{"$f":"'Cash Flow'!G16","v":831836.92799999996},{"$f":"'Cash Flow'!H16","v":865110.40512000001},{"$f":"'Cash Flow'!I16","v":899714.82132480014},{"$f":"'Cash Flow'!J16","v":935703.41417779215},{"$f":"'Cash Flow'!K16","v":973131.55074490374},{"$f":"'Cash Flow'!L16","v":1012056.8127747}]
[{"$f":"'Cash Flow'!A18","v":"Other Income"},null,null,{"$f":"'Cash Flow'!D23","v":1000},{"$f":"'Cash Flow'!E23","v":1040},{"$f":"'Cash Flow'!F23","v":1081.6000000000001},{"$f":"'Cash Flow'!G23","v":1124.8640000000003},{"$f":"'Cash Flow'!H23","v":1169.8585600000004},{"$f":"'Cash Flow'!I23","v":1216.6529024000004},{"$f":"'Cash Flow'!J23","v":1265.3190184960004},{"$f":"'Cash Flow'!K23","v":1315.9317792358404},{"$f":"'Cash Flow'!L23","v":1368.5690504052741}]
[{"$f":"'Cash Flow'!A25","v":"Potential Gross Income"},null,null,{"$f":"'Cash Flow'!D25","v":740500},{"$f":"'Cash Flow'!E25","v":770120},{"$f":"'Cash Flow'!F25","v":800924.79999999993},{"$f":"'Cash Flow'!G25","v":832961.7919999999},{"$f":"'Cash Flow'!H25","v":866280.26367999997},{"$f":"'Cash Flow'!I25","v":900931.47422720015},{"$f":"'Cash Flow'!J25","v":936968.73319628811},{"$f":"'Cash Flow'!K25","v":974447.48252413957},{"$f":"'Cash Flow'!L25","v":1013425.3818251053}]
[]
[{"$f":"'Cash Flow'!A27","v":"Less: Vacancy and Collection"}]
[null,{"$f":"'Cash Flow'!B28","v":"Rental Income"},null,{"$f":"'Cash Flow'!D28","v":-36975},{"$f":"'Cash Flow'!E28","v":-38454},{"$f":"'Cash Flow'!F28","v":-39992.160000000003},{"$f":"'Cash Flow'!G28","v":-41591.846400000002},{"$f":"'Cash Flow'!H28","v":-43255.520256000003},{"$f":"'Cash Flow'!I28","v":-44985.741066240007},{"$f":"'Cash Flow'!J28","v":-46785.170708889607},{"$f":"'Cash Flow'!K28","v":-48656.57753724519},{"$f":"'Cash Flow'!L28","v":-50602.840638735004}]
[null,{"$f":"'Cash Flow'!B29","v":"Other Income"},null,{"$f":"'Cash Flow'!D29","v":-50},{"$f":"'Cash Flow'!E29","v":-52},{"$f":"'Cash Flow'!F29","v":-54.080000000000013},{"$f":"'Cash Flow'!G29","v":-56.243200000000016},{"$f":"'Cash Flow'!H29","v":-58.49292800000002},{"$f":"'Cash Flow'!I29","v":-60.832645120000024},{"$f":"'Cash Flow'!J29","v":-63.265950924800023},{"$f":"'Cash Flow'!K29","v":-65.796588961792025},{"$f":"'Cash Flow'!L29","v":-68.428452520263704}]
[{"$f":"'Cash Flow'!A30","v":"     Total"},null,null,{"$f":"'Cash Flow'!D30","v":-37025},{"$f":"'Cash Flow'!E30","v":-38506},{"$f":"'Cash Flow'!F30","v":-40046.240000000005},{"$f":"'Cash Flow'!G30","v":-41648.089599999999},{"$f":"'Cash Flow'!H30","v":-43314.013184000003},{"$f":"'Cash Flow'!I30","v":-45046.573711360004},{"$f":"'Cash Flow'!J30","v":-46848.436659814404},{"$f":"'Cash Flow'!K30","v":-48722.374126206982},{"$f":"'Cash Flow'!L30","v":-50671.269091255264}]
[]
[{"$f":"'Cash Flow'!A32","v":"Effective Gross Income"},null,null,{"$f":"'Cash Flow'!D32","v":703475},{"$f":"'Cash Flow'!E32","v":731614},{"$f":"'Cash Flow'!F32","v":760878.55999999994},{"$f":"'Cash Flow'!G32","v":791313.70239999995},{"$f":"'Cash Flow'!H32","v":822966.25049599994},{"$f":"'Cash Flow'!I32","v":855884.90051584016},{"$f":"'Cash Flow'!J32","v":890120.29653647367},{"$f":"'Cash Flow'!K32","v":925725.10839793261},{"$f":"'Cash Flow'!L32","v":962754.11273385002}]
[]
[{"$f":"'Cash Flow'!A34","v":"OPERATING EXPENSES"}]
[{"$f":"'Cash Flow'!A59","v":"    Total Operating Expenses"},null,null,{"$f":"'Cash Flow'!D59","v":-305020},{"$f":"'Cash Flow'!E59","v":-317220.8},{"$f":"'Cash Flow'!F59","v":-329909.63200000004},{"$f":"'Cash Flow'!G59","v":-343106.01728000003},{"$f":"'Cash Flow'!H59","v":-356830.25797120004},{"$f":"'Cash Flow'!I59","v":-371103.46829004807},{"$f":"'Cash Flow'!J59","v":-385947.60702164989},{"$f":"'Cash Flow'!K59","v":-401385.51130251598},{"$f":"'Cash Flow'!L59","v":-417440.93175461661}]
[null,{"$f":"'Cash Flow'!B60","v":"Per Unit Expenses"},null,{"$f":"'Cash Flow'!D60","v":-3812.75},{"$f":"'Cash Flow'!E60","v":-3965.2599999999998},{"$f":"'Cash Flow'!F60","v":-4123.8704000000007},{"$f":"'Cash Flow'!G60","v":-4288.8252160000002},{"$f":"'Cash Flow'!H60","v":-4460.3782246400006},{"$f":"'Cash Flow'!I60","v":-4638.7933536256005},{"$f":"'Cash Flow'!J60","v":-4824.3450877706236},{"$f":"'Cash Flow'!K60","v":-5017.3188912814494},{"$f":"'Cash Flow'!L60","v":-5218.0116469327077}]
[]
[{"$f":"'Cash Flow'!A62","v":"NET OPERATING INCOME (NOI)"},null,null,{"$f":"'Cash Flow'!D62","v":398455},{"$f":"'Cash Flow'!E62","v":414393.2},{"$f":"'Cash Flow'!F62","v":430968.9279999999},{"$f":"'Cash Flow'!G62","v":448207.68511999992},{"$f":"'Cash Flow'!H62","v":466135.99252479989},{"$f":"'Cash Flow'!I62","v":484781.43222579209},{"$f":"'Cash Flow'!J62","v":504172.68951482378},{"$f":"'Cash Flow'!K62","v":524339.59709541663},{"$f":"'Cash Flow'!L62","v":545313.18097923347}]
[]
[null,"Less Debt Service",null,{"$f":"'Cash Flow'!D65+'Cash Flow'!D68","v":-459775.16167916544},{"$f":"'Cash Flow'!E65+'Cash Flow'!E68","v":-459775.16167916544},{"$f":"'Cash Flow'!F65+'Cash Flow'!F68","v":-459775.16167916544},{"$f":"'Cash Flow'!G65+'Cash Flow'!G68","v":-459775.16167916544},{"$f":"'Cash Flow'!H65+'Cash Flow'!H68","v":-459775.16167916544},{"$f":"'Cash Flow'!I65+'Cash Flow'!I68","v":-459775.16167916544},{"$f":"'Cash Flow'!J65+'Cash Flow'!J68","v":-459775.16167916544},{"$f":"'Cash Flow'!K65+'Cash Flow'!K68","v":-459775.16167916544}]
[{"$f":"'Cash Flow'!A69","v":"Before Tax Cash Flow"},null,null,{"$f":"'Cash Flow'!D69","v":-61320.161679165423},{"$f":"'Cash Flow'!E69","v":-45381.961679165412},{"$f":"'Cash Flow'!F69","v":-28806.233679165525},{"$f":"'Cash Flow'!G69","v":-11567.476559165501},{"$f":"'Cash Flow'!H69","v":6360.8308456344676},{"$f":"'Cash Flow'!I69","v":25006.270546626663},{"$f":"'Cash Flow'!J69","v":44397.527835658359},{"$f":"'Cash Flow'!K69","v":64564.435416251188}]
[null,{"$f":"'Cash Flow'!B70","v":"Less Taxes"},null,{"$f":"'Cash Flow'!D70","v":13650},{"$f":"'Cash Flow'!E70","v":13650},{"$f":"'Cash Flow'!F70","v":13650},{"$f":"'Cash Flow'!G70","v":13650},{"$f":"'Cash Flow'!H70","v":13650},{"$f":"'Cash Flow'!I70","v":13650},{"$f":"'Cash Flow'!J70","v":13650},{"$f":"'Cash Flow'!K70","v":13650}]
[{"$f":"'Cash Flow'!A71","v":"After Tax Cash Flow"},null,null,{"$f":"'Cash Flow'!D71","v":-47670.161679165423},{"$f":"'Cash Flow'!E71","v":-31731.961679165412},{"$f":"'Cash Flow'!F71","v":-15156.233679165525},{"$f":"'Cash Flow'!G71","v":2082.5234408344986},{"$f":"'Cash Flow'!H71","v":20010.830845634468},{"$f":"'Cash Flow'!I71","v":38656.270546626663},{"$f":"'Cash Flow'!J71","v":58047.527835658359},{"$f":"'Cash Flow'!K71","v":78214.435416251188}]
[]
[{"$f":"'Cash Flow'!A77","v":"REVERSION"}]
[{"$f":"'Cash Flow'!A78","v":"Gross Sale Price"},null,null,null,null,null,null,null,null,null,{"$f":"'Cash Flow'!K78","v":6415449.1879909812}]
[null,{"$f":"'Cash Flow'!B79","v":"Less Cost of Sale"},null,null,null,null,null,null,null,null,{"$f":"'Cash Flow'!K79","v":-192463.47563972944}]
[{"$f":"'Cash Flow'!A80","v":"Net Sale Price"},null,null,null,null,null,null,null,null,null,{"$f":"'Cash Flow'!K80","v":6222985.7123512514}]
[null,{"$f":"'Cash Flow'!B81","v":"Less Outstanding Mortgage"},null,null,null,null,null,null,null,null,{"$f":"'Cash Flow'!K81","v":-4659877.670102003}]
[{"$f":"'Cash Flow'!A82","v":"Before Tax Equity Reversion (BTER)"},null,null,null,null,null,null,null,null,null,{"$f":"'Cash Flow'!K82","v":1563108.0422492484}]
[null,{"$f":"'Cash Flow'!B83","v":"Less Taxes Due on Sale (See Below)"},null,null,null,null,null,null,null,null,{"$f":"'Cash Flow'!K83","v":-246503.0238901207}]
[{"$f":"'Cash Flow'!A84","v":"After Tax Equity Reversion (ATER)"},null,null,null,null,null,null,null,null,null,{"$f":"'Cash Flow'!K84","v":1316605.0183591277}]
[]
["RETURN MEASURES",null,null,{"$f":"D6","v":"Year 1"},{"$f":"E6","v":"Year 2"},"Year 3","Year 4","Year 5","Year 6","Year 7","Year 8"]
[]
["Debt Coverage Ratio (DCR)",null,null,{"$f":"-D23/D25","v":0.86663011230268439},{"$f":"-E23/E25","v":0.9012953167947918},0.93734712946658316,0.97484101464524653,1.0138346552310564,1.0543880414402991,1.0965635630979111,1.1404261056218272]
[]
["Overall Cash Flows",null,{"$f":"-PRICE_CAPS","v":-6000000},{"$f":"D23","v":398455},{"$f":"E23","v":414393.2},430968.9279999999,448207.68511999992,466135.99252479989,484781.43222579209,504172.68951482378,{"$f":"K23+K33","v":6747325.3094466683}]
[null,"IRR",{"$f":"IRR(C43:K43,0.12)","v":7.8815644986078848E-2}]
[null,{"$f":"\"PV @ \"&TEXT(DISCRATE,\"0%\")","v":"PV @ 12%"},{"$f":"NPV(DISCRATE,'8YRDCF'!D43:K43)","v":4741011.4597540312}]
[null,"IRR at various holding periods",null,{"$f":"'Cash Flow'!$B125","v":-0.14543121764705891},{"$f":"'Cash Flow'!$B126","v":-2.3474645135900252E-2},{"$f":"'Cash Flow'!$B127","v":2.0901751049784645E-2},{"$f":"'Cash Flow'!$B128","v":4.3792406176262455E-2},{"$f":"'Cash Flow'!$B129","v":5.7729360339658031E-2},{"$f":"'Cash Flow'!$B130","v":6.7086815778821363E-2},{"$f":"'Cash Flow'!$B131","v":7.3789267442556428E-2},{"$f":"'Cash Flow'!$B132","v":7.8815644986078848E-2}]
[]
["Equity Cash Flows",null,{"$f":"-EQUITY","v":-900000},{"$f":"D26","v":-61320.161679165423},{"$f":"E26","v":-45381.961679165412},-28806.233679165525,-11567.476559165501,6360.8308456344676,25006.270546626663,44397.527835658359,{"$f":"K26+K35","v":1627672.4776654996}]
[null,"Cash-on-Cash",null,{"$f":"-D48/$C$48","v":-6.8133512976850469E-2},{"$f":"-E48/$C$48","v":-5.0424401865739349E-2},-3.2006926310183918E-2,-1.2852751732406112E-2,7.0675898284827416E-3,2.7784745051807405E-2,4.9330586484064839E-2]
[null,"IRR",{"$f":"IRR(C48:K48,0.12)","v":6.5458167626255781E-2}]
[]
["After Tax Cash Flow",null,{"$f":"C48","v":-900000},{"$f":"D28","v":-47670.161679165423},{"$f":"E28","v":-31731.961679165412},-15156.233679165525,2082.5234408344986,20010.830845634468,38656.270546626663,58047.527835658359,{"$f":"K28+K37","v":1394819.4537753789}]
[null,"IRR",{"$f":"IRR(C52:K52,0.12)","v":5.5994674687832813E-2}]
[]
["Return - Managing Members"]
[null,"Cash Flow",null,{"$f":"PartnershipCF!B18","v":-18396.048503749626},{"$f":"PartnershipCF!C18","v":-13614.588503749623},{"$f":"PartnershipCF!D18","v":-8641.8701037496576},{"$f":"PartnershipCF!E18","v":-3470.2429677496502},{"$f":"PartnershipCF!F18","v":1908.2492536903401},{"$f":"PartnershipCF!G18","v":7501.8811639879987},{"$f":"PartnershipCF!H18","v":13319.258350697508},{"$f":"PartnershipCF!I18","v":19369.330624875354}]
[]
["Investor IRR Calculations (3 to 8 year hold)",null,null,null,null,{"$f":"PartnershipCF!$J82","v":-0.58888602361541209},{"$f":"PartnershipCF!$J83","v":-0.28996718062822535},{"$f":"PartnershipCF!$J84","v":-0.14511958789616375},{"$f":"PartnershipCF!$J85","v":-6.2524623099968313E-2},{"$f":"PartnershipCF!$J86","v":-1.1215157943601728E-2},{"$f":"PartnershipCF!$J87","v":2.2611743065943379E-2}]