{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["LICENSE","(1)Table of Contents","Lease Input","Occupancy Costs","(4)Lease A Owner","(5)Lease B Input","(6)Lease B Tenant","(7)Lease B Owner","(8)Lease C Input","(9)Lease C Tenant","(10)Lease C Owner","(11)Before Tax Summary","(12)After Tax Summary"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"LICENSE","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"(1)Table of Contents","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Lease Input","index":2,"n_rows":135,"n_cols":14,"rows_kept":135,"cut":false,"hidden":false,"merged":[[41,1,41,2],[36,1,36,2],[23,1,23,2],[7,5,7,6],[1,1,1,2],[22,1,22,2],[31,1,31,2],[2,1,2,2]]}
[]
[null,{"$f":"CONCATENATE(\"Lease Input Sheet - \",TEXT(TODAY(),\"m/d/yyyy\"))","v":"Lease Input Sheet - 8/16/2021"}]
[null,"Lease Assumptions"]
[null,1,"Lease Term in Years",null,null,null,100]
[null,2,"Rentable Square Feet"]
[null,3,"Base Rent"]
[null,4,"Base Rent Fixed Escalation Per SF Annually"]
[null,5,"Base Rent Concession (Number of Months)"]
[null,6,"Parking"]
[null,7,"Real Estate Taxes"]
[null,8,"Real Estate Tax Stop"]
[null,9,"Operating Expenses"]
[null,10,"Operating Expense Stop "]
[null,11,"Total Tenant Improvements"]
[null,12,"Tenant Improvement Allowance"]
[null,13,"Amortized TI's / Interest Rate"]
[null,14,"Total Moving Expense"]
[null,15,"Moving Expense Allowance"]
[null,16,"Total Existing Lease Buyout"]
[null,17,"Existing Lease Buyout Allowance"]
[null,18,"Leasing Commission"]
[null,19,"Sales Per SF / % of Sales / Sales Threshold",null,null,{"$f":"IF(E22=0,0,(D5*D6)/E22)","v":0}]
[null,"Escalation Assumptions"]
[null,"End of Year",null,null,1,2,3,4,5,6,7,8,9,10]
[null,20,"Base Rent",null,"N/A",null,{"$f":"F25","v":0},{"$f":"G25","v":0},0,0,0,0,0,0]
[null,21,"Parking",null,"N/A",null,{"$f":"F26","v":0},0,0,0,0,0,0,0]
[null,22,"Real Estate Taxes",null,"N/A",null,0,0,0,0,0,0,0,0]
[null,23,"Real Estate Tax Stop",null,"N/A",null,0,0,0,0,0,0,0,0]
[null,24,"Operating Expenses",null,"N/A",null,0,0,0,0,0,0,0,0]
[null,25,"Operating Expense Stop",null,"N/A",null,0,0,0,0,0,0,0,0]
[null,26,"Gross Sales ",null,"N/A",null,0,0,0,0,0,0,0,0]
[null,"Tenant Assumptions"]
[null,27,"Before Tax Discount Rate /After Tax Discount Rate"]
[null,28,"Marginal Tax Rate"]
[null,29,"Tenant Improvements Useful Life",null,"Year 1",{"$f":"ROUND((H35/12)*11.5,5)","v":0},"Yrs. 2,3,4, etc",{"$f":"IF(D35=0,0,ROUND(1/D35,5))","v":0}]
[null,30,"Bonus Depreciation Allowance (%)"]
[null,"Owner Assumptions"]
[null,31,"Before Tax Discount Rate / After Tax Discount Rate"]
[null,32,"Marginal Tax Rate",null,null,{"$f":"ROUND((H39/12)*11.5,5)","v":0},"Yrs. 2,3,4, etc",{"$f":"IF(D40=0,0,ROUND(1/D40,5))","v":0}]
[null,33,"Tenant Improvements Useful Life",null,"Year 1"]
[null,34,"Bonus Depreciation Allowance (%)"]
[null,"GAAP Accounting Reporting"]
[null,35,"Tenant's Incremental Borrowing Rate"]
[null,36,"Reasonable Cap Rate to Apply to Initial Base Rent"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,6,null,1]
[null,null,"Base Rent Per SF",1]
[null,null,"Total Base Rent",1]
[null,null,null,1]
[null,9,null,1]
[null,null,"Parking Per SF",1]
[null,null,"Total Parking",1]
[null,null,null,1]
[null,10,null,1]
[null,null,"Real Estate Taxes Per SF",1]
[null,null,"Total Real Estate Taxes",1]
[null,null,null,1]
[null,11,null,1]
[null,null,"Real Estate Tax Stop Per SF",1]
[null,null,"Total Real Estate Tax Stop",1]
[null,null,null,1]
[null,12,null,1]
[null,null,"Operating Expenses Per SF",1]
[null,null,"Total Operating Expenses",1]
[null,null,null,1]
[null,13,null,1]
[null,null,"Operating Expense Stop Per SF",1]
[null,null,"Total Operating Expense Stop",1]
[null,null,null,1]
[null,14,null,1]
[null,null,"Tenant Improvements Per SF",1]
[null,null,"Total Tenant Improvements",1]
[null,null,null,1]
[null,15,null,1]
[null,null,"Tenant Improvements Allowance Per SF",1]
[null,null,"Total Tenant Improvements Allowance",1]
[null,null,null,1]
[null,16,null,1]
[null,null,"Amortized TI's Per SF",1]
[null,null,"Total Amortized TI'l",1]
[null,null,null,1]

{"sheet":"Occupancy Costs","index":3,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,1,3],[29,1,29,2],[29,3,29,4],[29,5,29,6],[3,1,3,2],[2,1,2,2],[22,1,22,2],[13,1,13,2]]}
[]
[null,"Occupancy Cost Spreadsheet"]
[null,"Total Occupancy Costs"]
[null,"End of Year",null,"0",1,2,3,4,5,6,7,8,9,10]
[null,1,"Base Rent",null,{"$f":"IF('Lease Input'!D6<'Lease Input'!G4,'Lease Input'!D5*'Lease Input'!D6,'Lease Input'!D6)","v":0},{"$f":"IF(F4<='Lease Input'!$D$4,IF('Lease Input'!$D$7>0,'Occupancy Costs'!E5+('Lease Input'!$D$5*'Lease Input'!$D$7),E5*(1+'Lease Input'!F25)),0)","v":0},{"$f":"IF(G4<='Lease Input'!$D$4,IF('Lease Input'!$D$7>0,'Occupancy Costs'!F5+('Lease Input'!$D$5*'Lease Input'!$D$7),F5*(1+'Lease Input'!G25)),0)","v":0},{"$f":"IF(H4<='Lease Input'!$D$4,IF('Lease Input'!$D$7>0,'Occupancy Costs'!G5+('Lease Input'!$D$5*'Lease Input'!$D$7),G5*(1+'Lease Input'!H25)),0)","v":0},{"$f":"IF(I4<='Lease Input'!$D$4,IF('Lease Input'!$D$7>0,'Occupancy Costs'!H5+('Lease Input'!$D$5*'Lease Input'!$D$7),H5*(1+'Lease Input'!I25)),0)","v":0},{"$f":"IF(J4<='Lease Input'!$D$4,IF('Lease Input'!$D$7>0,'Occupancy Costs'!I5+('Lease Input'!$D$5*'Lease Input'!$D$7),I5*(1+'Lease Input'!J25)),0)","v":0},{"$f":"IF(K4<='Lease Input'!$D$4,IF('Lease Input'!$D$7>0,'Occupancy Costs'!J5+('Lease Input'!$D$5*'Lease Input'!$D$7),J5*(1+'Lease Input'!K25)),0)","v":0},{"$f":"IF(L4<='Lease Input'!$D$4,IF('Lease Input'!$D$7>0,'Occupancy Costs'!K5+('Lease Input'!$D$5*'Lease Input'!$D$7),K5*(1+'Lease Input'!L25)),0)","v":0},{"$f":"IF(M4<='Lease Input'!$D$4,IF('Lease Input'!$D$7>0,'Occupancy Costs'!L5+('Lease Input'!$D$5*'Lease Input'!$D$7),L5*(1+'Lease Input'!M25)),0)","v":0},{"$f":"IF(N4<='Lease Input'!$D$4,IF('Lease Input'!$D$7>0,'Occupancy Costs'!M5+('Lease Input'!$D$5*'Lease Input'!$D$7),M5*(1+'Lease Input'!N25)),0)","v":0}]
[null,2,"+Percentage Rent",null,{"$f":"MAX(0,('Lease Input'!$D$22*'Lease Input'!$D$5-'Lease Input'!$F$22)*'Lease Input'!$E$22)","v":0},{"$f":"IF(F4<='Lease Input'!$D$4,MAX(0,(('Lease Input'!$D$22*'Lease Input'!$D$5*(1+'Lease Input'!$F$31)-'Lease Input'!$F$22))*'Lease Input'!$E$22),0)","v":0},{"$f":"IF(G4<='Lease Input'!D5,MAX(0,((('Lease Input'!$D$22*'Lease Input'!$D$5*(1+'Lease Input'!$F$31)*(1+'Lease Input'!$G$31)-'Lease Input'!$F$22)))*'Lease Input'!$E$22),0)","v":0},{"$f":"IF(H4<='Lease Input'!D4,MAX(0,(((('Lease Input'!$D$22*'Lease Input'!$D$5*(1+'Lease Input'!$F$31)*(1+'Lease Input'!$G$31)*(1+'Lease Input'!$H$31)-'Lease Input'!$F$22))))*'Lease Input'!$E$22),0)","v":0},{"$f":"IF(I4<='Lease Input'!D4,MAX(0,((((('Lease Input'!$D$22*'Lease Input'!$D$5*(1+'Lease Input'!$F$31)*(1+'Lease Input'!$G$31)*(1+'Lease Input'!$H$31)*(1+'Lease Input'!$I$31)-'Lease Input'!$F$22)))))*'Lease Input'!$E$22),0)","v":0},{"$f":"IF(J4<='Lease Input'!D4,MAX(0,(((((('Lease Input'!$D$22*'Lease Input'!$D$5*(1+'Lease Input'!$F$31)*(1+'Lease Input'!$G$31)*(1+'Lease Input'!$H$31)*(1+'Lease Input'!$I$31)*(1+'Lease Input'!$J$31)-'Lease Input'!$F$22))))))*'Lease Input'!$E$22),0)","v":0},{"$f":"IF(K4<='Lease Input'!D4,MAX(0,((((((('Lease Input'!$D$22*'Lease Input'!$D$5*(1+'Lease Input'!$F$31)*(1+'Lease Input'!$G$31)*(1+'Lease Input'!$H$31)*(1+'Lease Input'!$I$31)*(1+'Lease Input'!$J$31)*(1+'Lease Input'!$K$31)-'Lease Input'!$F$22)))))))*'Lease Input'!$E$22),0)","v":0},{"$f":"IF(L4<='Lease Input'!D4,MAX(0,(((((((('Lease Input'!$D$22*'Lease Input'!$D$5*(1+'Lease Input'!$F$31)*(1+'Lease Input'!$G$31)*(1+'Lease Input'!$H$31)*(1+'Lease Input'!$I$31)*(1+'Lease Input'!$J$31)*(1+'Lease Input'!$K$31)*(1+'Lease Input'!$L$31)-'Lease Input'!$F$22))))))))*'Lease Input'!$E$22),0)","v":0},{"$f":"IF(M4<='Lease Input'!D4,MAX(0,((((((((('Lease Input'!$D$22*'Lease Input'!$D$5*(1+'Lease Input'!$F$31)*(1+'Lease Input'!$G$31)*(1+'Lease Input'!$H$31)*(1+'Lease Input'!$I$31)*(1+'Lease Input'!$J$31)*(1+'Lease Input'!$K$31)*(1+'Lease Input'!$L$31)*(1+'Lease Input'!$M$31)-'Lease Input'!$F$22)))))))))*'Lease Input'!$E$22),0)","v":0},{"$f":"IF(N4<='Lease Input'!D4,MAX(0,(((((((((('Lease Input'!$D$22*'Lease Input'!$D$5*(1+'Lease Input'!$F$31)*(1+'Lease Input'!$G$31)*(1+'Lease Input'!$H$31)*(1+'Lease Input'!$I$31)*(1+'Lease Input'!$J$31)*(1+'Lease Input'!$K$31)*(1+'Lease Input'!$L$31)*(1+'Lease Input'!$M$31)*(1+'Lease Input'!$N$31)-'Lease Input'!$F$22))))))))))*'Lease Input'!$E$22),0)","v":0}]
[null,3,"+Amortized TI's Additional Rent",null,{"$f":"IF('Lease Input'!$D$4=0,0,-PMT('Lease Input'!$E$16/12,'Lease Input'!$D$4*12,$D$20,0,0)*12)","v":0},{"$f":"IF(F4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-PMT('Lease Input'!$E$16/12,'Lease Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(G4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-PMT('Lease Input'!$E$16/12,'Lease Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(H4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-PMT('Lease Input'!$E$16/12,'Lease Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(I4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-PMT('Lease Input'!$E$16/12,'Lease Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(J4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-PMT('Lease Input'!$E$16/12,'Lease Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(K4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-PMT('Lease Input'!$E$16/12,'Lease Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(L4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-PMT('Lease Input'!$E$16/12,'Lease Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(M4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-PMT('Lease Input'!$E$16/12,'Lease Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(N4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-PMT('Lease Input'!$E$16/12,'Lease Input'!$D$4*12,$D$20,0,0)*12),0)","v":0}]
[null,4,"+Parking",null,{"$f":"IF('Lease Input'!D9<'Lease Input'!G4,'Lease Input'!D9*'Lease Input'!D5,'Lease Input'!D9)","v":0},{"$f":"IF(F4<='Lease Input'!$D$4,E8*(1+'Lease Input'!F26),0)","v":0},{"$f":"IF(G4<='Lease Input'!$D$4,F8*(1+'Lease Input'!G26),0)","v":0},{"$f":"IF(H4<='Lease Input'!$D$4,G8*(1+'Lease Input'!H26),0)","v":0},{"$f":"IF(I4<='Lease Input'!$D$4,H8*(1+'Lease Input'!I26),0)","v":0},{"$f":"IF(J4<='Lease Input'!$D$4,I8*(1+'Lease Input'!J26),0)","v":0},{"$f":"IF(K4<='Lease Input'!$D$4,J8*(1+'Lease Input'!K26),0)","v":0},{"$f":"IF(L4<='Lease Input'!$D$4,K8*(1+'Lease Input'!L26),0)","v":0},{"$f":"IF(M4<='Lease Input'!$D$4,L8*(1+'Lease Input'!M26),0)","v":0},{"$f":"IF(N4<='Lease Input'!$D$4,M8*(1+'Lease Input'!N26),0)","v":0}]
[null,5,"+Real Estate Taxes",null,{"$f":"IF('Lease Input'!D10<'Lease Input'!G4,'Lease Input'!D10*'Lease Input'!D5,'Lease Input'!D10)","v":0},{"$f":"IF(F4<='Lease Input'!$D$4,E9*(1+'Lease Input'!F27),0)","v":0},{"$f":"IF(G4<='Lease Input'!$D$4,F9*(1+'Lease Input'!G27),0)","v":0},{"$f":"IF(H4<='Lease Input'!$D$4,G9*(1+'Lease Input'!H27),0)","v":0},{"$f":"IF(I4<='Lease Input'!$D$4,H9*(1+'Lease Input'!I27),0)","v":0},{"$f":"IF(J4<='Lease Input'!$D$4,I9*(1+'Lease Input'!J27),0)","v":0},{"$f":"IF(K4<='Lease Input'!$D$4,J9*(1+'Lease Input'!K27),0)","v":0},{"$f":"IF(L4<='Lease Input'!$D$4,K9*(1+'Lease Input'!L27),0)","v":0},{"$f":"IF(M4<='Lease Input'!$D$4,L9*(1+'Lease Input'!M27),0)","v":0},{"$f":"IF(N4<='Lease Input'!$D$4,M9*(1+'Lease Input'!N27),0)","v":0}]
[null,6,"+Operating Expenses",null,{"$f":"IF('Lease Input'!D12<'Lease Input'!G4,'Lease Input'!D12*'Lease Input'!D5,'Lease Input'!D12)","v":0},{"$f":"IF(F4<='Lease Input'!$D$4,E10*(1+'Lease Input'!F29),0)","v":0},{"$f":"IF(G4<='Lease Input'!$D$4,F10*(1+'Lease Input'!G29),0)","v":0},{"$f":"IF(H4<='Lease Input'!$D$4,G10*(1+'Lease Input'!H29),0)","v":0},{"$f":"IF(I4<='Lease Input'!$D$4,H10*(1+'Lease Input'!I29),0)","v":0},{"$f":"IF(J4<='Lease Input'!$D$4,I10*(1+'Lease Input'!J29),0)","v":0},{"$f":"IF(K4<='Lease Input'!$D$4,J10*(1+'Lease Input'!K29),0)","v":0},{"$f":"IF(L4<='Lease Input'!$D$4,K10*(1+'Lease Input'!L29),0)","v":0},{"$f":"IF(M4<='Lease Input'!$D$4,L10*(1+'Lease Input'!M29),0)","v":0},{"$f":"IF(N4<='Lease Input'!$D$4,M10*(1+'Lease Input'!N29),0)","v":0}]
[null,7,"+Tenant Improvements",{"$f":"IF('Lease Input'!D14<'Lease Input'!G4,'Lease Input'!D14*'Lease Input'!D5,'Lease Input'!D14)","v":0}]
[null,8,"+Moving Expense",{"$f":"'Lease Input'!D17","v":0}]
[null,9,"+Existing Lease Buyout ",{"$f":"'Lease Input'!D19","v":0}]
[null,"Contributions From Owner"]
[null,10,"-Rent Concession",null,{"$f":"E5/12*'Lease Input'!D8","v":0}]
[null,11,"-Parking Stop"]
[null,12,"-Real Estate Tax Stop",null,{"$f":"IF('Lease Input'!D11<'Lease Input'!G4,'Lease Input'!D11*'Lease Input'!D5,'Lease Input'!D11)","v":0},{"$f":"IF(F4<='Lease Input'!$D$4,E17*(1+'Lease Input'!F28),0)","v":0},{"$f":"IF(G4<='Lease Input'!$D$4,F17*(1+'Lease Input'!G28),0)","v":0},{"$f":"IF(H4<='Lease Input'!$D$4,G17*(1+'Lease Input'!H28),0)","v":0},{"$f":"IF(I4<='Lease Input'!$D$4,H17*(1+'Lease Input'!I28),0)","v":0},{"$f":"IF(J4<='Lease Input'!$D$4,I17*(1+'Lease Input'!J28),0)","v":0},{"$f":"IF(K4<='Lease Input'!$D$4,J17*(1+'Lease Input'!K28),0)","v":0},{"$f":"IF(L4<='Lease Input'!$D$4,K17*(1+'Lease Input'!L28),0)","v":0},{"$f":"IF(M4<='Lease Input'!$D$4,L17*(1+'Lease Input'!M28),0)","v":0},{"$f":"IF(N4<='Lease Input'!$D$4,M17*(1+'Lease Input'!N28),0)","v":0}]
[null,13,"-Operating Expense Stop",null,{"$f":"IF('Lease Input'!D13<'Lease Input'!G4,'Lease Input'!D13*'Lease Input'!D5,'Lease Input'!D13)","v":0},{"$f":"IF(F4<='Lease Input'!$D$4,E18*(1+'Lease Input'!F30),0)","v":0},{"$f":"IF(G4<='Lease Input'!$D$4,F18*(1+'Lease Input'!G30),0)","v":0},{"$f":"IF(H4<='Lease Input'!$D$4,G18*(1+'Lease Input'!H30),0)","v":0},{"$f":"IF(I4<='Lease Input'!$D$4,H18*(1+'Lease Input'!I30),0)","v":0},{"$f":"IF(J4<='Lease Input'!$D$4,I18*(1+'Lease Input'!J30),0)","v":0},{"$f":"IF(K4<='Lease Input'!$D$4,J18*(1+'Lease Input'!K30),0)","v":0},{"$f":"IF(L4<='Lease Input'!$D$4,K18*(1+'Lease Input'!L30),0)","v":0},{"$f":"IF(M4<='Lease Input'!$D$4,L18*(1+'Lease Input'!M30),0)","v":0},{"$f":"IF(N4<='Lease Input'!$D$4,M18*(1+'Lease Input'!N30),0)","v":0}]
[null,14,"-Tenant Improvement Allowance",{"$f":"IF('Lease Input'!D15<'Lease Input'!G4,'Lease Input'!D15*'Lease Input'!D5,'Lease Input'!D15)","v":0}]
[null,15,"-Amortized Tenant Improvements",{"$f":"IF('Lease Input'!D16<'Lease Input'!G4,'Lease Input'!D16*'Lease Input'!D5,'Lease Input'!D16)","v":0}]
[null,16,"-Moving Expense Allowance",{"$f":"'Lease Input'!D18","v":0}]
[null,17,"-Existing Lease Buyout Allowance",{"$f":"'Lease Input'!D20","v":0}]
[null,"Tenant Occupancy Costs"]
[null,18,"=TENANT BEFORE TAX OCCUPANCY COST",{"$f":"SUM(D5:D13)-SUM(D15:D22)","v":0},0,0,0,0,0,{"$f":"SUM(J5:J13)-SUM(J15:J22)","v":0},0,0,0,0]
[null,19,"-Tax Savings (Annual Expenditures)",null,{"$f":"E24*'Lease Input'!$D$34","v":0},{"$f":"F24*'Lease Input'!$D$34","v":0},{"$f":"G24*'Lease Input'!$D$34","v":0},{"$f":"H24*'Lease Input'!$D$34","v":0},{"$f":"I24*'Lease Input'!$D$34","v":0},{"$f":"J24*'Lease Input'!$D$34","v":0},{"$f":"K24*'Lease Input'!$D$34","v":0},{"$f":"L24*'Lease Input'!$D$34","v":0},{"$f":"M24*'Lease Input'!$D$34","v":0},{"$f":"N24*'Lease Input'!$D$34","v":0}]
[null,20,"-Tax Savings (Tenant Improvements)",null,{"$f":"IF(E4<'Lease Input'!D4,((D11-D19-D20)*(1-'Lease Input'!D36)*'Lease Input'!F35*'Lease Input'!D34)+(D11-D19-D20)*'Lease Input'!D36*'Lease Input'!D34,(D11-D19-D20)*'Lease Input'!D34)","v":0},{"$f":"IF(F4<'Lease Input'!$D$4,($D$11-$D$19-$D$20)*(1-'Lease Input'!$D$36)*'Lease Input'!$H$35*'Lease Input'!$D$34,IF(F4='Lease Input'!$D$4,($D$11-$D$19-$D$20)*'Lease Input'!$D$34-SUM('Occupancy Costs'!$E$26:E26),0))","v":0},{"$f":"IF(G4<'Lease Input'!$D$4,($D$11-$D$19-$D$20)*(1-'Lease Input'!$D$36)*'Lease Input'!$H$35*'Lease Input'!$D$34,IF(G4='Lease Input'!$D$4,($D$11-$D$19-$D$20)*'Lease Input'!$D$34-SUM('Occupancy Costs'!$E$26:F26),0))","v":0},{"$f":"IF(H4<'Lease Input'!$D$4,($D$11-$D$19-$D$20)*(1-'Lease Input'!$D$36)*'Lease Input'!$H$35*'Lease Input'!$D$34,IF(H4='Lease Input'!$D$4,($D$11-$D$19-$D$20)*'Lease Input'!$D$34-SUM('Occupancy Costs'!$E$26:G26),0))","v":0},{"$f":"IF(I4<'Lease Input'!$D$4,($D$11-$D$19-$D$20)*(1-'Lease Input'!$D$36)*'Lease Input'!$H$35*'Lease Input'!$D$34,IF(I4='Lease Input'!$D$4,($D$11-$D$19-$D$20)*'Lease Input'!$D$34-SUM('Occupancy Costs'!$E$26:H26),0))","v":0},{"$f":"IF(J4<'Lease Input'!$D$4,($D$11-$D$19-$D$20)*(1-'Lease Input'!$D$36)*'Lease Input'!$H$35*'Lease Input'!$D$34,IF(J4='Lease Input'!$D$4,($D$11-$D$19-$D$20)*'Lease Input'!$D$34-SUM('Occupancy Costs'!$E$26:I26),0))","v":0},{"$f":"IF(K4<'Lease Input'!$D$4,($D$11-$D$19-$D$20)*(1-'Lease Input'!$D$36)*'Lease Input'!$H$35*'Lease Input'!$D$34,IF(K4='Lease Input'!$D$4,($D$11-$D$19-$D$20)*'Lease Input'!$D$34-SUM('Occupancy Costs'!$E$26:J26),0))","v":0},{"$f":"IF(L4<'Lease Input'!$D$4,($D$11-$D$19-$D$20)*(1-'Lease Input'!$D$36)*'Lease Input'!$H$35*'Lease Input'!$D$34,IF(L4='Lease Input'!$D$4,($D$11-$D$19-$D$20)*'Lease Input'!$D$34-SUM('Occupancy Costs'!$E$26:K26),0))","v":0},{"$f":"IF(M4<'Lease Input'!$D$4,($D$11-$D$19-$D$20)*(1-'Lease Input'!$D$36)*'Lease Input'!$H$35*'Lease Input'!$D$34,IF(M4='Lease Input'!$D$4,($D$11-$D$19-$D$20)*'Lease Input'!$D$34-SUM('Occupancy Costs'!$E$26:L26),0))","v":0},{"$f":"IF(N4<'Lease Input'!$D$4,($D$11-$D$19-$D$20)*(1-'Lease Input'!$D$36)*'Lease Input'!$H$35*'Lease Input'!$D$34,IF(N4='Lease Input'!$D$4,($D$11-$D$19-$D$20)*'Lease Input'!$D$34-SUM('Occupancy Costs'!$E$26:M26),0))","v":0}]
[null,21,"-Tax Savings (Moving Expenses)",null,{"$f":"(D12-D21)*'Lease Input'!D34","v":0}]
[null,22,"-Tax Savings (Existing Lease Buyout)",null,{"$f":"(D13-D22)*'Lease Input'!D34","v":0}]
[null,23,"=TENANT AFTER TAX OCCUPANCY COST",{"$f":"D24-D25-D26-D27-D28","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Summary",null,"Before Tax",null,"After Tax"]
[null,24,"TOTAL EFFECTIVE RENT:",null,{"$f":"SUM(D24:N24)","v":0},null,{"$f":"SUM(D29:N29)","v":0}]
[null,25,"TOTAL EFFECTIVE RATE:",null,{"$f":"IF('Lease Input'!D5=0,0,E31/'Lease Input'!D5)","v":0},null,{"$f":"IF('Lease Input'!D5=0,0,G31/'Lease Input'!D5)","v":0}]
[null,26,"AVERAGE ANNUAL EFFECTIVE RENT:",null,{"$f":"IF('Lease Input'!D4=0,0,E31/'Lease Input'!D4)","v":0},null,{"$f":"IF('Lease Input'!D4=0,0,G31/'Lease Input'!D4)","v":0}]
[null,27,"AVERAGE ANNUAL EFFECTIVE RATE:",null,{"$f":"IF('Lease Input'!D5=0,0,E33/'Lease Input'!D5)","v":0},null,{"$f":"IF('Lease Input'!D5=0,0,G33/'Lease Input'!D5)","v":0}]
[null,28,"DISCOUNTED EFFECTIVE RENT            @",{"$f":"'Lease Input'!D33","v":0},{"$f":"NPV(D35,E24:N24)+D24","v":0},{"$f":"'Lease Input'!E33","v":0},{"$f":"NPV(F35,E29:N29)+D29","v":0}]

{"sheet":"(4)Lease A Owner","index":4,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":true,"merged":[[1,1,1,4],[2,1,2,2],[10,1,10,2],[27,5,27,6],[19,1,19,2],[27,1,27,2],[3,1,3,2],[27,3,27,4]]}
[]
[null,"Lease \"A\" Owner Spreadsheet"]
[null,"Collections"]
[null,"End of Year",null,"0",1,2,3,4,5,6,7,8,9,10]
[null,1,"Base Rent",null,{"$f":"'Occupancy Costs'!E5","v":0},{"$f":"'Occupancy Costs'!F5","v":0},{"$f":"'Occupancy Costs'!G5","v":0},{"$f":"'Occupancy Costs'!H5","v":0},{"$f":"'Occupancy Costs'!I5","v":0},{"$f":"'Occupancy Costs'!J5","v":0},{"$f":"'Occupancy Costs'!K5","v":0},{"$f":"'Occupancy Costs'!L5","v":0},{"$f":"'Occupancy Costs'!M5","v":0},{"$f":"'Occupancy Costs'!N5","v":0}]
[null,2,"+Percentage Rent",null,{"$f":"'Occupancy Costs'!E6","v":0},{"$f":"'Occupancy Costs'!F6","v":0},{"$f":"'Occupancy Costs'!G6","v":0},{"$f":"'Occupancy Costs'!H6","v":0},{"$f":"'Occupancy Costs'!I6","v":0},{"$f":"'Occupancy Costs'!J6","v":0},{"$f":"'Occupancy Costs'!K6","v":0},{"$f":"'Occupancy Costs'!L6","v":0},{"$f":"'Occupancy Costs'!M6","v":0},{"$f":"'Occupancy Costs'!N6","v":0}]
[null,3,"+Amortized TI's Additional Rent",null,{"$f":"'Occupancy Costs'!E7","v":0},{"$f":"'Occupancy Costs'!F7","v":0},{"$f":"'Occupancy Costs'!G7","v":0},{"$f":"'Occupancy Costs'!H7","v":0},{"$f":"'Occupancy Costs'!I7","v":0},{"$f":"'Occupancy Costs'!J7","v":0},{"$f":"'Occupancy Costs'!K7","v":0},{"$f":"'Occupancy Costs'!L7","v":0},{"$f":"'Occupancy Costs'!M7","v":0},{"$f":"'Occupancy Costs'!N7","v":0}]
[null,4,"+Parking From Tenant",null,{"$f":"'Occupancy Costs'!E8","v":0},{"$f":"'Occupancy Costs'!F8","v":0},{"$f":"'Occupancy Costs'!G8","v":0},{"$f":"'Occupancy Costs'!H8","v":0},{"$f":"'Occupancy Costs'!I8","v":0},{"$f":"'Occupancy Costs'!J8","v":0},{"$f":"'Occupancy Costs'!K8","v":0},{"$f":"'Occupancy Costs'!L8","v":0},{"$f":"'Occupancy Costs'!M8","v":0},{"$f":"'Occupancy Costs'!N8","v":0}]
[null,5,"+Real Estate Taxes From Tenant",null,{"$f":"'Occupancy Costs'!E9-'Occupancy Costs'!E17","v":0},{"$f":"'Occupancy Costs'!F9-'Occupancy Costs'!F17","v":0},{"$f":"'Occupancy Costs'!G9-'Occupancy Costs'!G17","v":0},{"$f":"'Occupancy Costs'!H9-'Occupancy Costs'!H17","v":0},{"$f":"'Occupancy Costs'!I9-'Occupancy Costs'!I17","v":0},{"$f":"'Occupancy Costs'!J9-'Occupancy Costs'!J17","v":0},{"$f":"'Occupancy Costs'!K9-'Occupancy Costs'!K17","v":0},{"$f":"'Occupancy Costs'!L9-'Occupancy Costs'!L17","v":0},{"$f":"'Occupancy Costs'!M9-'Occupancy Costs'!M17","v":0},{"$f":"'Occupancy Costs'!N9-'Occupancy Costs'!N17","v":0}]
[null,6,"+Operating Expenses From Tenant",null,{"$f":"'Occupancy Costs'!E10-'Occupancy Costs'!E18","v":0},{"$f":"'Occupancy Costs'!F10-'Occupancy Costs'!F18","v":0},{"$f":"'Occupancy Costs'!G10-'Occupancy Costs'!G18","v":0},{"$f":"'Occupancy Costs'!H10-'Occupancy Costs'!H18","v":0},{"$f":"'Occupancy Costs'!I10-'Occupancy Costs'!I18","v":0},{"$f":"'Occupancy Costs'!J10-'Occupancy Costs'!J18","v":0},{"$f":"'Occupancy Costs'!K10-'Occupancy Costs'!K18","v":0},{"$f":"'Occupancy Costs'!L10-'Occupancy Costs'!L18","v":0},{"$f":"'Occupancy Costs'!M10-'Occupancy Costs'!M18","v":0},{"$f":"'Occupancy Costs'!N10-'Occupancy Costs'!N18","v":0}]
[null,"Disbursements"]
[null,7,"-Rent Concession",null,{"$f":"'Occupancy Costs'!E15","v":0}]
[null,8,"-Total Real Estate Taxes",null,{"$f":"'Occupancy Costs'!E9","v":0},{"$f":"'Occupancy Costs'!F9","v":0},{"$f":"'Occupancy Costs'!G9","v":0},{"$f":"'Occupancy Costs'!H9","v":0},{"$f":"'Occupancy Costs'!I9","v":0},{"$f":"'Occupancy Costs'!J9","v":0},{"$f":"'Occupancy Costs'!K9","v":0},{"$f":"'Occupancy Costs'!L9","v":0},{"$f":"'Occupancy Costs'!M9","v":0},{"$f":"'Occupancy Costs'!N9","v":0}]
[null,9,"-Total Operating Expenses",null,{"$f":"'Occupancy Costs'!E10","v":0},{"$f":"'Occupancy Costs'!F10","v":0},{"$f":"'Occupancy Costs'!G10","v":0},{"$f":"'Occupancy Costs'!H10","v":0},{"$f":"'Occupancy Costs'!I10","v":0},{"$f":"'Occupancy Costs'!J10","v":0},{"$f":"'Occupancy Costs'!K10","v":0},{"$f":"'Occupancy Costs'!L10","v":0},{"$f":"'Occupancy Costs'!M10","v":0},{"$f":"'Occupancy Costs'!N10","v":0}]
[null,10,"-Tenant Improvement Allowance",{"$f":"'Occupancy Costs'!D19","v":0}]
[null,11,"-Amortized Tenant Improvements",{"$f":"'Occupancy Costs'!D20","v":0}]
[null,12,"-Moving Expense Allowance",{"$f":"'Lease Input'!D18","v":0}]
[null,13,"- Existing Lease Buyout Allowance",{"$f":"'Lease Input'!D20","v":0}]
[null,14,"- Leasing Commission",{"$f":"((SUM(E5:N5)*'Lease Input'!D21))","v":0}]
[null,"Owner Cash Flows"]
[null,15,"=CASH FLOW BEFORE TAXES",{"$f":"SUM(D5:D10)-SUM(D12:D19)","v":0},0,0,0,0,0,{"$f":"SUM(J5:J10)-SUM(J12:J19)","v":0},{"$f":"SUM(K5:K10)-SUM(K12:K19)","v":0},{"$f":"SUM(L5:L10)-SUM(L12:L19)","v":0},{"$f":"SUM(M5:M10)-SUM(M12:M19)","v":0},{"$f":"SUM(N5:N10)-SUM(N12:N19)","v":0}]
[null,16,"-Tax (Savings) Annual Income",null,{"$f":"E21*'Lease Input'!D39","v":0},{"$f":"F21*'Lease Input'!D39","v":0},{"$f":"G21*'Lease Input'!D39","v":0},{"$f":"H21*'Lease Input'!D39","v":0},{"$f":"I21*'Lease Input'!$D$39","v":0},{"$f":"J21*'Lease Input'!$D$39","v":0},{"$f":"K21*'Lease Input'!$D$39","v":0},{"$f":"L21*'Lease Input'!$D$39","v":0},{"$f":"M21*'Lease Input'!$D$39","v":0},{"$f":"N21*'Lease Input'!$D$39","v":0}]
[null,17,"-Tax (Savings) Tenant Improvements",null,{"$f":"-((((D15+D16)*(1-'Lease Input'!D41))*'Lease Input'!F35*'Lease Input'!D39)+((D15+D16)*'Lease Input'!D41*'Lease Input'!D39))","v":0},{"$f":"IF(F4<='Lease Input'!$D$4,-((($D$15+$D$16)*(1-'Lease Input'!$D$41))*'Lease Input'!$H$35*'Lease Input'!$D$39),0)","v":0},{"$f":"IF(G4<='Lease Input'!$D$4,-((($D$15+$D$16)*(1-'Lease Input'!$D$41))*'Lease Input'!$H$35*'Lease Input'!$D$39),0)","v":0},{"$f":"IF(H4<='Lease Input'!$D$4,-((($D$15+$D$16)*(1-'Lease Input'!$D$41))*'Lease Input'!$H$35*'Lease Input'!$D$39),0)","v":0},{"$f":"IF(I4<='Lease Input'!$D$4,-((($D$15+$D$16)*(1-'Lease Input'!$D$41))*'Lease Input'!$H$35*'Lease Input'!$D$39),0)","v":0},{"$f":"IF(J4<='Lease Input'!$D$4,-((($D$15+$D$16)*(1-'Lease Input'!$D$41))*'Lease Input'!$H$35*'Lease Input'!$D$39),0)","v":0},{"$f":"IF(K4<='Lease Input'!$D$4,-((($D$15+$D$16)*(1-'Lease Input'!$D$41))*'Lease Input'!$H$35*'Lease Input'!$D$39),0)","v":0},{"$f":"IF(L4<='Lease Input'!$D$4,-((($D$15+$D$16)*(1-'Lease Input'!$D$41))*'Lease Input'!$H$35*'Lease Input'!$D$39),0)","v":0},{"$f":"IF(M4<='Lease Input'!$D$4,-((($D$15+$D$16)*(1-'Lease Input'!$D$41))*'Lease Input'!$H$35*'Lease Input'!$D$39),0)","v":0},{"$f":"IF(N4<='Lease Input'!$D$4,-((($D$15+$D$16)*(1-'Lease Input'!$D$41))*'Lease Input'!$H$35*'Lease Input'!$D$39),0)","v":0}]
[null,18,"-Tax (Savings) Moving Expenses",null,{"$f":"IF(E4<='Lease Input'!$D$4,IF(E4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$17*'Lease Input'!$D$39/'Lease Input'!$D$4)),0),0)","v":0},{"$f":"IF(F4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$17*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(G4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$17*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(H4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$17*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(I4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$17*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(J4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$17*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(K4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$17*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(L4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$17*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(M4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$17*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF('Lease Input'!$D$4=0,0,-($D$17*'Lease Input'!$D$39/'Lease Input'!$D$4))","v":0}]
[null,19,"-Tax (Savings) Existing Lease Buyout ",null,{"$f":"IF(E4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$18*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(F4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$18*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(G4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$18*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(H4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$18*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(I4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$18*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(J4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$18*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(K4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$18*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(L4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$18*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(M4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$18*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(N4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$18*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0}]
[null,20,"-Tax (Savings) Leasing Commission",null,{"$f":"IF(E4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$19*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(F4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$19*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(G4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$19*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(H4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$19*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(I4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$19*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(J4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$19*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(K4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$19*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(L4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$19*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(M4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$19*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0},{"$f":"IF(N4<='Lease Input'!$D$4,IF('Lease Input'!$D$4=0,0,-($D$19*'Lease Input'!$D$39/'Lease Input'!$D$4)),0)","v":0}]
[null,21,"=CASH FLOW AFTER TAXES",{"$f":"D21-D22-D23-D24-D25-D26","v":0},{"$f":"E21-E22-E23-E24-E25-E26","v":0},{"$f":"F21-F22-F23-F24-F25-F26","v":0},0,0,0,0,0,0,0,0]
[null,"Summary",null,"Before Tax",null,"After Tax"]
[null,22,"INCREMENTAL LEASE VALUE @",{"$f":"'Lease Input'!D38","v":0},{"$f":"NPV(D29,E21:N21)+D21","v":0},{"$f":"'Lease Input'!E38","v":0},{"$f":"NPV(F29,E27:N27)+D27","v":0}]

{"sheet":"(5)Lease B Input","index":5,"n_rows":135,"n_cols":14,"rows_kept":135,"cut":false,"hidden":true,"merged":[[41,1,41,2],[36,1,36,2],[23,1,23,2],[7,5,7,6],[1,1,1,2],[22,1,22,2],[31,1,31,2],[2,1,2,2]]}
[]
[null,{"$f":"CONCATENATE(\"Lease B Input Sheet - \",TEXT(TODAY(),\"m/d/yyyy\"))","v":"Lease B Input Sheet - 8/16/2021"}]
[null,"Lease Assumptions"]
[null,1,"Lease Term in Years",null,null,null,100]
[null,2,"Rentable Square Feet"]
[null,3,"Base Rent"]
[null,4,"Base Rent Fixed Escalation Per SFAnnually"]
[null,5,"Base Rent Concession (Number of Months)"]
[null,6,"Parking"]
[null,7,"Real Estate Taxes"]
[null,8,"Real Estate Tax Stop"]
[null,9,"Operating Expenses"]
[null,10,"Operating Expense Stop"]
[null,11,"Total Tenant Improvements"]
[null,12,"Tenant Improvement Allowance"]
[null,13,"Amortized TI's/ Interest Rate"]
[null,14,"Total Moving Expense"]
[null,15,"Moving Expense Allowance"]
[null,16,"Total Existing Lease Buyout"]
[null,17,"Existing Lease Buyout Allowance"]
[null,18,"Leasing Commission"]
[null,19,"Sales Per SF / % of Sales / Sales Threshold",null,null,{"$f":"IF(E22=0,0,(D5*D6)/E22)","v":0}]
[null,"Escalation Assumptions"]
[null,"End of Year",null,null,1,2,3,4,5,6,7,8,9,10]
[null,20,"Base Rent",null,"N/A",null,{"$f":"F25","v":0},{"$f":"G25","v":0},0,0,0,0,0,0]
[null,21,"Parking",null,"N/A",null,{"$f":"F26","v":0},0,0,0,0,0,0,0]
[null,22,"Real Estate Taxes",null,"N/A",null,0,0,0,0,0,0,0,0]
[null,23,"Real Estate Tax Stop",null,"N/A",null,0,0,0,0,0,0,0,0]
[null,24,"Operating Expenses",null,"N/A",null,0,0,0,0,0,0,0,0]
[null,25,"Operating Expense Stop",null,"N/A",null,0,0,0,0,0,0,0,0]
[null,26,"Gross Sales ",null,"N/A",null,0,0,0,0,0,0,0,0]
[null,"Tenant Assumptions"]
[null,27,"Before Tax Discount Rate /After Tax Discount Rate"]
[null,28,"Marginal Tax Rate"]
[null,29,"Tenant Improvements Useful Life",null,"Year 1",{"$f":"ROUND((H35/12)*11.5,5)","v":0},"Yrs. 2,3,4, etc",{"$f":"IF(D35=0,0,ROUND(1/D35,5))","v":0}]
[null,30,"Bonus Depreciation Allowance (%)"]
[null,"Owner Assumptions"]
[null,31,"Before Tax Discount Rate / After Tax Discount Rate"]
[null,32,"Marginal Tax Rate",null,null,{"$f":"ROUND((H39/12)*11.5,5)","v":0},"Yrs. 2,3,4, etc",{"$f":"IF(D40=0,0,ROUND(1/D40,5))","v":0}]
[null,33,"Tenant Improvements Useful Life",null,"Year 1"]
[null,34,"Bonus Depreciation Allowance (%)"]
[null,"GAPP Accounting Reporting"]
[null,35,"Tenant's Incremental Borrowing Rate"]
[null,36,"Reasonable Cap Rate to Apply to Initial Base Rent"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,3,null,1]
[null,null,"Base Rent Per SF",1]
[null,null,"Total Base Rent",1]
[null,null,null,1]
[null,6,null,1]
[null,null,"Parking Per SF",1]
[null,null,"Total Parking",1]
[null,null,null,1]
[null,7,null,1]
[null,null,"Real Estate Taxes Per SF",1]
[null,null,"Total Real Estate Taxes",1]
[null,null,null,1]
[null,8,null,1]
[null,null,"Real Estate Tax Stop Per SF",1]
[null,null,"Total Real Estate Tax Stop",1]
[null,null,null,1]
[null,9,null,1]
[null,null,"Operating Expenses Per SF",1]
[null,null,"Total Operating Expenses",1]
[null,null,null,1]
[null,10,null,1]
[null,null,"Operating Expense Stop Per SF",1]
[null,null,"Total Operating Expense Stop",1]
[null,null,null,1]
[null,11,null,1]
[null,null,"Tenant Improvements Per SF",1]
[null,null,"Total Tenant Improvements",1]
[null,null,null,1]
[null,12,null,1]
[null,null,"Tenant Improvements Allowance Per SF",1]
[null,null,"Total Tenant Improvements Allowance",1]
[null,null,null,1]
[null,13,null,1]
[null,null,"Amortized TI's Per SF",1]
[null,null,"Total Amortized TI'l",1]
[null,null,null,1]

{"sheet":"(6)Lease B Tenant","index":6,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":true,"merged":[[35,1,35,2],[1,1,1,4],[29,1,29,2],[29,3,29,4],[29,5,29,6],[3,1,3,2],[2,1,2,2],[22,1,22,2],[13,1,13,2]]}
[]
[null,"Lease \"B\" Tenant Spreadsheet"]
[null,"Total Occupancy Costs"]
[null,"End of Year",null,"0",1,2,3,4,5,6,7,8,9,10]
[null,1,"Base Rent",null,{"$f":"IF('(5)Lease B Input'!D6<'(5)Lease B Input'!G4,'(5)Lease B Input'!D5*'(5)Lease B Input'!D6,'(5)Lease B Input'!D6)","v":0},{"$f":"IF(F4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$7>0,'(6)Lease B Tenant'!E5+('(5)Lease B Input'!$D$5*'(5)Lease B Input'!$D$7),E5*(1+'(5)Lease B Input'!F25)),0)","v":0},{"$f":"IF(G4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$7>0,'(6)Lease B Tenant'!F5+('(5)Lease B Input'!$D$5*'(5)Lease B Input'!$D$7),F5*(1+'(5)Lease B Input'!G25)),0)","v":0},{"$f":"IF(H4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$7>0,'(6)Lease B Tenant'!G5+('(5)Lease B Input'!$D$5*'(5)Lease B Input'!$D$7),G5*(1+'(5)Lease B Input'!H25)),0)","v":0},{"$f":"IF(I4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$7>0,'(6)Lease B Tenant'!H5+('(5)Lease B Input'!$D$5*'(5)Lease B Input'!$D$7),H5*(1+'(5)Lease B Input'!I25)),0)","v":0},{"$f":"IF(J4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$7>0,'(6)Lease B Tenant'!I5+('(5)Lease B Input'!$D$5*'(5)Lease B Input'!$D$7),I5*(1+'(5)Lease B Input'!J25)),0)","v":0},{"$f":"IF(K4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$7>0,'(6)Lease B Tenant'!J5+('(5)Lease B Input'!$D$5*'(5)Lease B Input'!$D$7),J5*(1+'(5)Lease B Input'!K25)),0)","v":0},{"$f":"IF(L4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$7>0,'(6)Lease B Tenant'!K5+('(5)Lease B Input'!$D$5*'(5)Lease B Input'!$D$7),K5*(1+'(5)Lease B Input'!L25)),0)","v":0},{"$f":"IF(M4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$7>0,'(6)Lease B Tenant'!L5+('(5)Lease B Input'!$D$5*'(5)Lease B Input'!$D$7),L5*(1+'(5)Lease B Input'!M25)),0)","v":0},{"$f":"IF(N4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$7>0,'(6)Lease B Tenant'!M5+('(5)Lease B Input'!$D$5*'(5)Lease B Input'!$D$7),M5*(1+'(5)Lease B Input'!N25)),0)","v":0}]
[null,2,"+Percentage Rent",null,{"$f":"MAX(0,('(5)Lease B Input'!$D$22*'(5)Lease B Input'!$D$5-'(5)Lease B Input'!$F$22)*'(5)Lease B Input'!$E$22)","v":0},{"$f":"IF(F4<='(5)Lease B Input'!$D$4,MAX(0,(('(5)Lease B Input'!$D$22*'(5)Lease B Input'!$D$5*(1+'(5)Lease B Input'!$F$31)-'(5)Lease B Input'!$F$22))*'(5)Lease B Input'!$E$22),0)","v":0},{"$f":"IF(G4<='(5)Lease B Input'!D5,MAX(0,((('(5)Lease B Input'!$D$22*'(5)Lease B Input'!$D$5*(1+'(5)Lease B Input'!$F$31)*(1+'(5)Lease B Input'!$G$31)-'(5)Lease B Input'!$F$22)))*'(5)Lease B Input'!$E$22),0)","v":0},{"$f":"IF(H4<='(5)Lease B Input'!D4,MAX(0,(((('(5)Lease B Input'!$D$22*'(5)Lease B Input'!$D$5*(1+'(5)Lease B Input'!$F$31)*(1+'(5)Lease B Input'!$G$31)*(1+'(5)Lease B Input'!$H$31)-'(5)Lease B Input'!$F$22))))*'(5)Lease B Input'!$E$22),0)","v":0},{"$f":"IF(I4<='(5)Lease B Input'!D4,MAX(0,((((('(5)Lease B Input'!$D$22*'(5)Lease B Input'!$D$5*(1+'(5)Lease B Input'!$F$31)*(1+'(5)Lease B Input'!$G$31)*(1+'(5)Lease B Input'!$H$31)*(1+'(5)Lease B Input'!$I$31)-'(5)Lease B Input'!$F$22)))))*'(5)Lease B Input'!$E$22),0)","v":0},{"$f":"IF(J4<='(5)Lease B Input'!D4,MAX(0,(((((('(5)Lease B Input'!$D$22*'(5)Lease B Input'!$D$5*(1+'(5)Lease B Input'!$F$31)*(1+'(5)Lease B Input'!$G$31)*(1+'(5)Lease B Input'!$H$31)*(1+'(5)Lease B Input'!$I$31)*(1+'(5)Lease B Input'!$J$31)-'(5)Lease B Input'!$F$22))))))*'(5)Lease B Input'!$E$22),0)","v":0},{"$f":"IF(K4<='(5)Lease B Input'!D4,MAX(0,((((((('(5)Lease B Input'!$D$22*'(5)Lease B Input'!$D$5*(1+'(5)Lease B Input'!$F$31)*(1+'(5)Lease B Input'!$G$31)*(1+'(5)Lease B Input'!$H$31)*(1+'(5)Lease B Input'!$I$31)*(1+'(5)Lease B Input'!$J$31)*(1+'(5)Lease B Input'!$K$31)-'(5)Lease B Input'!$F$22)))))))*'(5)Lease B Input'!$E$22),0)","v":0},{"$f":"IF(L4<='(5)Lease B Input'!D4,MAX(0,(((((((('(5)Lease B Input'!$D$22*'(5)Lease B Input'!$D$5*(1+'(5)Lease B Input'!$F$31)*(1+'(5)Lease B Input'!$G$31)*(1+'(5)Lease B Input'!$H$31)*(1+'(5)Lease B Input'!$I$31)*(1+'(5)Lease B Input'!$J$31)*(1+'(5)Lease B Input'!$K$31)*(1+'(5)Lease B Input'!$L$31)-'(5)Lease B Input'!$F$22))))))))*'(5)Lease B Input'!$E$22),0)","v":0},{"$f":"IF(M4<='(5)Lease B Input'!D4,MAX(0,((((((((('(5)Lease B Input'!$D$22*'(5)Lease B Input'!$D$5*(1+'(5)Lease B Input'!$F$31)*(1+'(5)Lease B Input'!$G$31)*(1+'(5)Lease B Input'!$H$31)*(1+'(5)Lease B Input'!$I$31)*(1+'(5)Lease B Input'!$J$31)*(1+'(5)Lease B Input'!$K$31)*(1+'(5)Lease B Input'!$L$31)*(1+'(5)Lease B Input'!$M$31)-'(5)Lease B Input'!$F$22)))))))))*'(5)Lease B Input'!$E$22),0)","v":0},{"$f":"IF(N4<='(5)Lease B Input'!D4,MAX(0,(((((((((('(5)Lease B Input'!$D$22*'(5)Lease B Input'!$D$5*(1+'(5)Lease B Input'!$F$31)*(1+'(5)Lease B Input'!$G$31)*(1+'(5)Lease B Input'!$H$31)*(1+'(5)Lease B Input'!$I$31)*(1+'(5)Lease B Input'!$J$31)*(1+'(5)Lease B Input'!$K$31)*(1+'(5)Lease B Input'!$L$31)*(1+'(5)Lease B Input'!$M$31)*(1+'(5)Lease B Input'!$N$31)-'(5)Lease B Input'!$F$22))))))))))*'(5)Lease B Input'!$E$22),0)","v":0}]
[null,3,"+Amortized TI's Additional Rent",null,{"$f":"IF('(5)Lease B Input'!$D$4=0,0,-PMT('(5)Lease B Input'!$E$16/12,'(5)Lease B Input'!$D$4*12,$D$20,0,0)*12)","v":0},{"$f":"IF(F4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-PMT('(5)Lease B Input'!$E$16/12,'(5)Lease B Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(G4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-PMT('(5)Lease B Input'!$E$16/12,'(5)Lease B Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(H4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-PMT('(5)Lease B Input'!$E$16/12,'(5)Lease B Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(I4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-PMT('(5)Lease B Input'!$E$16/12,'(5)Lease B Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(J4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-PMT('(5)Lease B Input'!$E$16/12,'(5)Lease B Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(K4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-PMT('(5)Lease B Input'!$E$16/12,'(5)Lease B Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(L4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-PMT('(5)Lease B Input'!$E$16/12,'(5)Lease B Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(M4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-PMT('(5)Lease B Input'!$E$16/12,'(5)Lease B Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(N4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-PMT('(5)Lease B Input'!$E$16/12,'(5)Lease B Input'!$D$4*12,$D$20,0,0)*12),0)","v":0}]
[null,4,"+Parking",null,{"$f":"IF('(5)Lease B Input'!D9<'(5)Lease B Input'!G4,'(5)Lease B Input'!D9*'(5)Lease B Input'!D5,'(5)Lease B Input'!D9)","v":0},{"$f":"IF(F4<='(5)Lease B Input'!$D$4,E8*(1+'(5)Lease B Input'!F26),0)","v":0},{"$f":"IF(G4<='(5)Lease B Input'!$D$4,F8*(1+'(5)Lease B Input'!G26),0)","v":0},{"$f":"IF(H4<='(5)Lease B Input'!$D$4,G8*(1+'(5)Lease B Input'!H26),0)","v":0},{"$f":"IF(I4<='(5)Lease B Input'!$D$4,H8*(1+'(5)Lease B Input'!I26),0)","v":0},{"$f":"IF(J4<='(5)Lease B Input'!$D$4,I8*(1+'(5)Lease B Input'!J26),0)","v":0},{"$f":"IF(K4<='(5)Lease B Input'!$D$4,J8*(1+'(5)Lease B Input'!K26),0)","v":0},{"$f":"IF(L4<='(5)Lease B Input'!$D$4,K8*(1+'(5)Lease B Input'!L26),0)","v":0},{"$f":"IF(M4<='(5)Lease B Input'!$D$4,L8*(1+'(5)Lease B Input'!M26),0)","v":0},{"$f":"IF(N4<='(5)Lease B Input'!$D$4,M8*(1+'(5)Lease B Input'!N26),0)","v":0}]
[null,5,"+Real Estate Taxes",null,{"$f":"IF('(5)Lease B Input'!D10<'(5)Lease B Input'!G4,'(5)Lease B Input'!D10*'(5)Lease B Input'!D5,'(5)Lease B Input'!D10)","v":0},{"$f":"IF(F4<='(5)Lease B Input'!$D$4,E9*(1+'(5)Lease B Input'!F27),0)","v":0},{"$f":"IF(G4<='(5)Lease B Input'!$D$4,F9*(1+'(5)Lease B Input'!G27),0)","v":0},{"$f":"IF(H4<='(5)Lease B Input'!$D$4,G9*(1+'(5)Lease B Input'!H27),0)","v":0},{"$f":"IF(I4<='(5)Lease B Input'!$D$4,H9*(1+'(5)Lease B Input'!I27),0)","v":0},{"$f":"IF(J4<='(5)Lease B Input'!$D$4,I9*(1+'(5)Lease B Input'!J27),0)","v":0},{"$f":"IF(K4<='(5)Lease B Input'!$D$4,J9*(1+'(5)Lease B Input'!K27),0)","v":0},{"$f":"IF(L4<='(5)Lease B Input'!$D$4,K9*(1+'(5)Lease B Input'!L27),0)","v":0},{"$f":"IF(M4<='(5)Lease B Input'!$D$4,L9*(1+'(5)Lease B Input'!M27),0)","v":0},{"$f":"IF(N4<='(5)Lease B Input'!$D$4,M9*(1+'(5)Lease B Input'!N27),0)","v":0}]
[null,6,"+Operating Expenses",null,{"$f":"IF('(5)Lease B Input'!D12<'(5)Lease B Input'!G4,'(5)Lease B Input'!D12*'(5)Lease B Input'!D5,'(5)Lease B Input'!D12)","v":0},{"$f":"IF(F4<='(5)Lease B Input'!$D$4,E10*(1+'(5)Lease B Input'!F29),0)","v":0},{"$f":"IF(G4<='(5)Lease B Input'!$D$4,F10*(1+'(5)Lease B Input'!G29),0)","v":0},{"$f":"IF(H4<='(5)Lease B Input'!$D$4,G10*(1+'(5)Lease B Input'!H29),0)","v":0},{"$f":"IF(I4<='(5)Lease B Input'!$D$4,H10*(1+'(5)Lease B Input'!I29),0)","v":0},{"$f":"IF(J4<='(5)Lease B Input'!$D$4,I10*(1+'(5)Lease B Input'!J29),0)","v":0},{"$f":"IF(K4<='(5)Lease B Input'!$D$4,J10*(1+'(5)Lease B Input'!K29),0)","v":0},{"$f":"IF(L4<='(5)Lease B Input'!$D$4,K10*(1+'(5)Lease B Input'!L29),0)","v":0},{"$f":"IF(M4<='(5)Lease B Input'!$D$4,L10*(1+'(5)Lease B Input'!M29),0)","v":0},{"$f":"IF(N4<='(5)Lease B Input'!$D$4,M10*(1+'(5)Lease B Input'!N29),0)","v":0}]
[null,7,"+Tenant Improvements",{"$f":"IF('(5)Lease B Input'!D14<'(5)Lease B Input'!G4,'(5)Lease B Input'!D14*'(5)Lease B Input'!D5,'(5)Lease B Input'!D14)","v":0}]
[null,8,"+Moving Expense",{"$f":"'(5)Lease B Input'!D17","v":0}]
[null,9,"+Existing Lease Buyout ",{"$f":"'(5)Lease B Input'!D19","v":0}]
[null,"Contributions From Owner"]
[null,10,"-Rent Concession",null,{"$f":"E5/12*'(5)Lease B Input'!D8","v":0}]
[null,11,"-Parking Stop"]
[null,12,"-Real Estate Tax Stop",null,{"$f":"IF('(5)Lease B Input'!D11<'(5)Lease B Input'!G4,'(5)Lease B Input'!D11*'(5)Lease B Input'!D5,'(5)Lease B Input'!D11)","v":0},{"$f":"IF(F4<='(5)Lease B Input'!$D$4,E17*(1+'(5)Lease B Input'!F28),0)","v":0},{"$f":"IF(G4<='(5)Lease B Input'!$D$4,F17*(1+'(5)Lease B Input'!G28),0)","v":0},{"$f":"IF(H4<='(5)Lease B Input'!$D$4,G17*(1+'(5)Lease B Input'!H28),0)","v":0},{"$f":"IF(I4<='(5)Lease B Input'!$D$4,H17*(1+'(5)Lease B Input'!I28),0)","v":0},{"$f":"IF(J4<='(5)Lease B Input'!$D$4,I17*(1+'(5)Lease B Input'!J28),0)","v":0},{"$f":"IF(K4<='(5)Lease B Input'!$D$4,J17*(1+'(5)Lease B Input'!K28),0)","v":0},{"$f":"IF(L4<='(5)Lease B Input'!$D$4,K17*(1+'(5)Lease B Input'!L28),0)","v":0},{"$f":"IF(M4<='(5)Lease B Input'!$D$4,L17*(1+'(5)Lease B Input'!M28),0)","v":0},{"$f":"IF(N4<='(5)Lease B Input'!$D$4,M17*(1+'(5)Lease B Input'!N28),0)","v":0}]
[null,13,"-Operating Expense Stop",null,{"$f":"IF('(5)Lease B Input'!D13<'(5)Lease B Input'!G4,'(5)Lease B Input'!D13*'(5)Lease B Input'!D5,'(5)Lease B Input'!D13)","v":0},{"$f":"IF(F4<='(5)Lease B Input'!$D$4,E18*(1+'(5)Lease B Input'!F30),0)","v":0},{"$f":"IF(G4<='(5)Lease B Input'!$D$4,F18*(1+'(5)Lease B Input'!G30),0)","v":0},{"$f":"IF(H4<='(5)Lease B Input'!$D$4,G18*(1+'(5)Lease B Input'!H30),0)","v":0},{"$f":"IF(I4<='(5)Lease B Input'!$D$4,H18*(1+'(5)Lease B Input'!I30),0)","v":0},{"$f":"IF(J4<='(5)Lease B Input'!$D$4,I18*(1+'(5)Lease B Input'!J30),0)","v":0},{"$f":"IF(K4<='(5)Lease B Input'!$D$4,J18*(1+'(5)Lease B Input'!K30),0)","v":0},{"$f":"IF(L4<='(5)Lease B Input'!$D$4,K18*(1+'(5)Lease B Input'!L30),0)","v":0},{"$f":"IF(M4<='(5)Lease B Input'!$D$4,L18*(1+'(5)Lease B Input'!M30),0)","v":0},{"$f":"IF(N4<='(5)Lease B Input'!$D$4,M18*(1+'(5)Lease B Input'!N30),0)","v":0}]
[null,14,"-Tenant Improvement Allowance",{"$f":"IF('(5)Lease B Input'!D15<'(5)Lease B Input'!G4,'(5)Lease B Input'!D15*'(5)Lease B Input'!D5,'(5)Lease B Input'!D15)","v":0}]
[null,15,"-Amortized Tenant Improvements",{"$f":"IF('(5)Lease B Input'!D16<'(5)Lease B Input'!G4,'(5)Lease B Input'!D16*'(5)Lease B Input'!D5,'(5)Lease B Input'!D16)","v":0}]
[null,16,"-Moving Expense Allowance",{"$f":"'(5)Lease B Input'!D18","v":0}]
[null,17,"-Existing Lease Buyout Allowance",{"$f":"'(5)Lease B Input'!D20","v":0}]
[null,"Tenant Occupancy Costs"]
[null,18,"=TENANT BEFORE TAX OCCUPANCY COST",{"$f":"SUM(D5:D13)-SUM(D15:D22)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,19,"-Tax Savings (Annual Expenditures)",null,{"$f":"E24*'(5)Lease B Input'!$D$34","v":0},{"$f":"F24*'(5)Lease B Input'!$D$34","v":0},{"$f":"G24*'(5)Lease B Input'!$D$34","v":0},{"$f":"H24*'(5)Lease B Input'!$D$34","v":0},{"$f":"I24*'(5)Lease B Input'!$D$34","v":0},{"$f":"J24*'(5)Lease B Input'!$D$34","v":0},{"$f":"K24*'(5)Lease B Input'!$D$34","v":0},{"$f":"L24*'(5)Lease B Input'!$D$34","v":0},{"$f":"M24*'(5)Lease B Input'!$D$34","v":0},{"$f":"N24*'(5)Lease B Input'!$D$34","v":0}]
[null,20,"-Tax Savings (Tenant Improvements)",null,{"$f":"IF(E4<'(5)Lease B Input'!D4,((D11-D19-D20)*(1-'(5)Lease B Input'!D36)*'(5)Lease B Input'!F35*'(5)Lease B Input'!D34)+(D11-D19-D20)*'(5)Lease B Input'!D36*'(5)Lease B Input'!D34,(D11-D19-D20)*'(5)Lease B Input'!D34)","v":0},{"$f":"IF(F4<'(5)Lease B Input'!$D$4,($D$11-$D$19-$D$20)*(1-'(5)Lease B Input'!$D$36)*'(5)Lease B Input'!$H$35*'(5)Lease B Input'!$D$34,IF(F4='(5)Lease B Input'!$D$4,($D$11-$D$19-$D$20)*'(5)Lease B Input'!$D$34-SUM('(6)Lease B Tenant'!$E$26:E26),0))","v":0},{"$f":"IF(G4<'(5)Lease B Input'!$D$4,($D$11-$D$19-$D$20)*(1-'(5)Lease B Input'!$D$36)*'(5)Lease B Input'!$H$35*'(5)Lease B Input'!$D$34,IF(G4='(5)Lease B Input'!$D$4,($D$11-$D$19-$D$20)*'(5)Lease B Input'!$D$34-SUM('(6)Lease B Tenant'!$E$26:F26),0))","v":0},{"$f":"IF(H4<'(5)Lease B Input'!$D$4,($D$11-$D$19-$D$20)*(1-'(5)Lease B Input'!$D$36)*'(5)Lease B Input'!$H$35*'(5)Lease B Input'!$D$34,IF(H4='(5)Lease B Input'!$D$4,($D$11-$D$19-$D$20)*'(5)Lease B Input'!$D$34-SUM('(6)Lease B Tenant'!$E$26:G26),0))","v":0},{"$f":"IF(I4<'(5)Lease B Input'!$D$4,($D$11-$D$19-$D$20)*(1-'(5)Lease B Input'!$D$36)*'(5)Lease B Input'!$H$35*'(5)Lease B Input'!$D$34,IF(I4='(5)Lease B Input'!$D$4,($D$11-$D$19-$D$20)*'(5)Lease B Input'!$D$34-SUM('(6)Lease B Tenant'!$E$26:H26),0))","v":0},{"$f":"IF(J4<'(5)Lease B Input'!$D$4,($D$11-$D$19-$D$20)*(1-'(5)Lease B Input'!$D$36)*'(5)Lease B Input'!$H$35*'(5)Lease B Input'!$D$34,IF(J4='(5)Lease B Input'!$D$4,($D$11-$D$19-$D$20)*'(5)Lease B Input'!$D$34-SUM('(6)Lease B Tenant'!$E$26:I26),0))","v":0},{"$f":"IF(K4<'(5)Lease B Input'!$D$4,($D$11-$D$19-$D$20)*(1-'(5)Lease B Input'!$D$36)*'(5)Lease B Input'!$H$35*'(5)Lease B Input'!$D$34,IF(K4='(5)Lease B Input'!$D$4,($D$11-$D$19-$D$20)*'(5)Lease B Input'!$D$34-SUM('(6)Lease B Tenant'!$E$26:J26),0))","v":0},{"$f":"IF(L4<'(5)Lease B Input'!$D$4,($D$11-$D$19-$D$20)*(1-'(5)Lease B Input'!$D$36)*'(5)Lease B Input'!$H$35*'(5)Lease B Input'!$D$34,IF(L4='(5)Lease B Input'!$D$4,($D$11-$D$19-$D$20)*'(5)Lease B Input'!$D$34-SUM('(6)Lease B Tenant'!$E$26:K26),0))","v":0},{"$f":"IF(M4<'(5)Lease B Input'!$D$4,($D$11-$D$19-$D$20)*(1-'(5)Lease B Input'!$D$36)*'(5)Lease B Input'!$H$35*'(5)Lease B Input'!$D$34,IF(M4='(5)Lease B Input'!$D$4,($D$11-$D$19-$D$20)*'(5)Lease B Input'!$D$34-SUM('(6)Lease B Tenant'!$E$26:L26),0))","v":0},{"$f":"IF(N4<'(5)Lease B Input'!$D$4,($D$11-$D$19-$D$20)*(1-'(5)Lease B Input'!$D$36)*'(5)Lease B Input'!$H$35*'(5)Lease B Input'!$D$34,IF(N4='(5)Lease B Input'!$D$4,($D$11-$D$19-$D$20)*'(5)Lease B Input'!$D$34-SUM('(6)Lease B Tenant'!$E$26:M26),0))","v":0}]
[null,21,"-Tax Savings (Moving Expenses)",null,{"$f":"(D12-D21)*'(5)Lease B Input'!D34","v":0}]
[null,22,"-Tax Savings (Existing Lease Buyout)",null,{"$f":"(D13-D22)*'(5)Lease B Input'!D34","v":0}]
[null,23,"=TENANT AFTER TAX OCCUPANCY COST",{"$f":"D24-D25-D26-D27-D28","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Summary",null,"Before Tax",null,"After Tax"]
[null,24,"TOTAL EFFECTIVE RENT:",null,{"$f":"SUM(D24:N24)","v":0},null,{"$f":"SUM(D29:N29)","v":0}]
[null,25,"TOTAL EFFECTIVE RATE:",null,{"$f":"IF('(5)Lease B Input'!D5=0,0,E31/'(5)Lease B Input'!D5)","v":0},null,{"$f":"IF('(5)Lease B Input'!D5=0,0,G31/'(5)Lease B Input'!D5)","v":0}]
[null,26,"AVERAGE ANNUAL EFFECTIVE RENT:",null,{"$f":"IF('(5)Lease B Input'!D4=0,0,E31/'(5)Lease B Input'!D4)","v":0},null,{"$f":"IF('(5)Lease B Input'!D4=0,0,G31/'(5)Lease B Input'!D4)","v":0}]
[null,27,"AVERAGE ANNUAL EFFECTIVE RATE:",null,{"$f":"IF('(5)Lease B Input'!D5=0,0,E33/'(5)Lease B Input'!D5)","v":0},null,{"$f":"IF('(5)Lease B Input'!D5=0,0,G33/'(5)Lease B Input'!D5)","v":0}]
[null,28,"DISCOUNTED EFFECTIVE RENT            @",{"$f":"'(5)Lease B Input'!D33","v":0},{"$f":"NPV(D35,E24:N24)+D24","v":0},{"$f":"'(5)Lease B Input'!E33","v":0},{"$f":"NPV(F35,E29:N29)+D29","v":0}]
[null,"GAPP Accounting Reporting"]
[null,29,"Straightline GAPP Rent Annual Expense",{"$f":"E33","v":0}]
[null,30,"Tenant's Incremental Borrowing Rate",{"$f":"'(5)Lease B Input'!D43","v":0}]
[null,31,"Reasonable CAP Rate to Apply to Initial Base Rent",{"$f":"'(5)Lease B Input'!D44","v":0}]
[null,32,"Estimated Fair Market Value of Leased Space",{"$f":"IF(D39=0,0,E5/D39)","v":0}]
[null,33,"90% Threshhold for FAS-13 Capital Lease Test",{"$f":"D40*0.9","v":0}]
[null,34,"Present Value of Minimum Lease Payments",{"$f":"NPV(D38,E5:N5)+D5","v":0}]

{"sheet":"(7)Lease B Owner","index":7,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":true,"merged":[[1,1,1,4],[2,1,2,2],[10,1,10,2],[27,5,27,6],[19,1,19,2],[27,1,27,2],[3,1,3,2],[27,3,27,4]]}
[]
[null,"Lease \"B\" Owner Spreadsheet"]
[null,"Collections"]
[null,"End of Year",null,"0",1,2,3,4,5,6,7,8,9,10]
[null,1,"Base Rent",null,{"$f":"'(6)Lease B Tenant'!E5","v":0},{"$f":"'(6)Lease B Tenant'!F5","v":0},{"$f":"'(6)Lease B Tenant'!G5","v":0},{"$f":"'(6)Lease B Tenant'!H5","v":0},{"$f":"'(6)Lease B Tenant'!I5","v":0},{"$f":"'(6)Lease B Tenant'!J5","v":0},{"$f":"'(6)Lease B Tenant'!K5","v":0},{"$f":"'(6)Lease B Tenant'!L5","v":0},{"$f":"'(6)Lease B Tenant'!M5","v":0},{"$f":"'(6)Lease B Tenant'!N5","v":0}]
[null,2,"+Percentage Rent",null,{"$f":"'(6)Lease B Tenant'!E6","v":0},{"$f":"'(6)Lease B Tenant'!F6","v":0},{"$f":"'(6)Lease B Tenant'!G6","v":0},{"$f":"'(6)Lease B Tenant'!H6","v":0},{"$f":"'(6)Lease B Tenant'!I6","v":0},{"$f":"'(6)Lease B Tenant'!J6","v":0},{"$f":"'(6)Lease B Tenant'!K6","v":0},{"$f":"'(6)Lease B Tenant'!L6","v":0},{"$f":"'(6)Lease B Tenant'!M6","v":0},{"$f":"'(6)Lease B Tenant'!N6","v":0}]
[null,3,"+Amortized TI's Additional Rent",null,{"$f":"'(6)Lease B Tenant'!E7","v":0},{"$f":"'(6)Lease B Tenant'!F7","v":0},{"$f":"'(6)Lease B Tenant'!G7","v":0},{"$f":"'(6)Lease B Tenant'!H7","v":0},{"$f":"'(6)Lease B Tenant'!I7","v":0},{"$f":"'(6)Lease B Tenant'!J7","v":0},{"$f":"'(6)Lease B Tenant'!K7","v":0},{"$f":"'(6)Lease B Tenant'!L7","v":0},{"$f":"'(6)Lease B Tenant'!M7","v":0},{"$f":"'(6)Lease B Tenant'!N7","v":0}]
[null,4,"+Parking From Tenant",null,{"$f":"'(6)Lease B Tenant'!E8","v":0},{"$f":"'(6)Lease B Tenant'!F8","v":0},{"$f":"'(6)Lease B Tenant'!G8","v":0},{"$f":"'(6)Lease B Tenant'!H8","v":0},{"$f":"'(6)Lease B Tenant'!I8","v":0},{"$f":"'(6)Lease B Tenant'!J8","v":0},{"$f":"'(6)Lease B Tenant'!K8","v":0},{"$f":"'(6)Lease B Tenant'!L8","v":0},{"$f":"'(6)Lease B Tenant'!M8","v":0},{"$f":"'(6)Lease B Tenant'!N8","v":0}]
[null,5,"+Real Estate Taxes From Tenant",null,{"$f":"'(6)Lease B Tenant'!E9-'(6)Lease B Tenant'!E17","v":0},{"$f":"'(6)Lease B Tenant'!F9-'(6)Lease B Tenant'!F17","v":0},{"$f":"'(6)Lease B Tenant'!G9-'(6)Lease B Tenant'!G17","v":0},{"$f":"'(6)Lease B Tenant'!H9-'(6)Lease B Tenant'!H17","v":0},{"$f":"'(6)Lease B Tenant'!I9-'(6)Lease B Tenant'!I17","v":0},{"$f":"'(6)Lease B Tenant'!J9-'(6)Lease B Tenant'!J17","v":0},{"$f":"'(6)Lease B Tenant'!K9-'(6)Lease B Tenant'!K17","v":0},{"$f":"'(6)Lease B Tenant'!L9-'(6)Lease B Tenant'!L17","v":0},{"$f":"'(6)Lease B Tenant'!M9-'(6)Lease B Tenant'!M17","v":0},{"$f":"'(6)Lease B Tenant'!N9-'(6)Lease B Tenant'!N17","v":0}]
[null,6,"+Operating Expenses From Tenant",null,{"$f":"'(6)Lease B Tenant'!E10-'(6)Lease B Tenant'!E18","v":0},{"$f":"'(6)Lease B Tenant'!F10-'(6)Lease B Tenant'!F18","v":0},{"$f":"'(6)Lease B Tenant'!G10-'(6)Lease B Tenant'!G18","v":0},{"$f":"'(6)Lease B Tenant'!H10-'(6)Lease B Tenant'!H18","v":0},{"$f":"'(6)Lease B Tenant'!I10-'(6)Lease B Tenant'!I18","v":0},{"$f":"'(6)Lease B Tenant'!J10-'(6)Lease B Tenant'!J18","v":0},{"$f":"'(6)Lease B Tenant'!K10-'(6)Lease B Tenant'!K18","v":0},{"$f":"'(6)Lease B Tenant'!L10-'(6)Lease B Tenant'!L18","v":0},{"$f":"'(6)Lease B Tenant'!M10-'(6)Lease B Tenant'!M18","v":0},{"$f":"'(6)Lease B Tenant'!N10-'(6)Lease B Tenant'!N18","v":0}]
[null,"Disbursements"]
[null,7,"-Rent Concession",null,{"$f":"'(6)Lease B Tenant'!E15","v":0}]
[null,8,"-Total Real Estate Taxes",null,{"$f":"'(6)Lease B Tenant'!E9","v":0},{"$f":"'(6)Lease B Tenant'!F9","v":0},{"$f":"'(6)Lease B Tenant'!G9","v":0},{"$f":"'(6)Lease B Tenant'!H9","v":0},{"$f":"'(6)Lease B Tenant'!I9","v":0},{"$f":"'(6)Lease B Tenant'!J9","v":0},{"$f":"'(6)Lease B Tenant'!K9","v":0},{"$f":"'(6)Lease B Tenant'!L9","v":0},{"$f":"'(6)Lease B Tenant'!M9","v":0},{"$f":"'(6)Lease B Tenant'!N9","v":0}]
[null,9,"-Total Operating Expenses",null,{"$f":"'(6)Lease B Tenant'!E10","v":0},{"$f":"'(6)Lease B Tenant'!F10","v":0},{"$f":"'(6)Lease B Tenant'!G10","v":0},{"$f":"'(6)Lease B Tenant'!H10","v":0},{"$f":"'(6)Lease B Tenant'!I10","v":0},{"$f":"'(6)Lease B Tenant'!J10","v":0},{"$f":"'(6)Lease B Tenant'!K10","v":0},{"$f":"'(6)Lease B Tenant'!L10","v":0},{"$f":"'(6)Lease B Tenant'!M10","v":0},{"$f":"'(6)Lease B Tenant'!N10","v":0}]
[null,10,"-Tenant Improvement Allowance",{"$f":"'(6)Lease B Tenant'!D19","v":0}]
[null,11,"-Amortized Tenant Improvements",{"$f":"'(6)Lease B Tenant'!D20","v":0}]
[null,12,"-Moving Expense Allowance",{"$f":"'(5)Lease B Input'!D18","v":0}]
[null,13,"- Existing Lease Buyout Allowance",{"$f":"'(5)Lease B Input'!D20","v":0}]
[null,14,"- Leasing Commission",{"$f":"((SUM(E5:N5)*'(5)Lease B Input'!D21))","v":0}]
[null,"Owner Cash Flows"]
[null,15,"=CASH FLOW BEFORE TAXES",{"$f":"SUM(D5:D10)-SUM(D12:D19)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,16,"-Tax (Savings) Annual Income",null,{"$f":"E21*'(5)Lease B Input'!D39","v":0},{"$f":"F21*'(5)Lease B Input'!D39","v":0},{"$f":"G21*'(5)Lease B Input'!D39","v":0},{"$f":"H21*'(5)Lease B Input'!D39","v":0},{"$f":"I21*'(5)Lease B Input'!$D$39","v":0},{"$f":"J21*'(5)Lease B Input'!$D$39","v":0},{"$f":"K21*'(5)Lease B Input'!$D$39","v":0},{"$f":"L21*'(5)Lease B Input'!$D$39","v":0},{"$f":"M21*'(5)Lease B Input'!$D$39","v":0},{"$f":"N21*'(5)Lease B Input'!$D$39","v":0}]
[null,17,"-Tax (Savings) Tenant Improvements",null,{"$f":"-((((D15+D16)*(1-'(5)Lease B Input'!D41))*'(5)Lease B Input'!F35*'(5)Lease B Input'!D39)+((D15+D16)*'(5)Lease B Input'!D41*'(5)Lease B Input'!D39))","v":0},{"$f":"IF(F4<='(5)Lease B Input'!$D$4,-((($D$15+$D$16)*(1-'(5)Lease B Input'!$D$41))*'(5)Lease B Input'!$H$35*'(5)Lease B Input'!$D$39),0)","v":0},{"$f":"IF(G4<='(5)Lease B Input'!$D$4,-((($D$15+$D$16)*(1-'(5)Lease B Input'!$D$41))*'(5)Lease B Input'!$H$35*'(5)Lease B Input'!$D$39),0)","v":0},{"$f":"IF(H4<='(5)Lease B Input'!$D$4,-((($D$15+$D$16)*(1-'(5)Lease B Input'!$D$41))*'(5)Lease B Input'!$H$35*'(5)Lease B Input'!$D$39),0)","v":0},{"$f":"IF(I4<='(5)Lease B Input'!$D$4,-((($D$15+$D$16)*(1-'(5)Lease B Input'!$D$41))*'(5)Lease B Input'!$H$35*'(5)Lease B Input'!$D$39),0)","v":0},{"$f":"IF(J4<='(5)Lease B Input'!$D$4,-((($D$15+$D$16)*(1-'(5)Lease B Input'!$D$41))*'(5)Lease B Input'!$H$35*'(5)Lease B Input'!$D$39),0)","v":0},{"$f":"IF(K4<='(5)Lease B Input'!$D$4,-((($D$15+$D$16)*(1-'(5)Lease B Input'!$D$41))*'(5)Lease B Input'!$H$35*'(5)Lease B Input'!$D$39),0)","v":0},{"$f":"IF(L4<='(5)Lease B Input'!$D$4,-((($D$15+$D$16)*(1-'(5)Lease B Input'!$D$41))*'(5)Lease B Input'!$H$35*'(5)Lease B Input'!$D$39),0)","v":0},{"$f":"IF(M4<='(5)Lease B Input'!$D$4,-((($D$15+$D$16)*(1-'(5)Lease B Input'!$D$41))*'(5)Lease B Input'!$H$35*'(5)Lease B Input'!$D$39),0)","v":0},{"$f":"IF(N4<='(5)Lease B Input'!$D$4,-((($D$15+$D$16)*(1-'(5)Lease B Input'!$D$41))*'(5)Lease B Input'!$H$35*'(5)Lease B Input'!$D$39),0)","v":0}]
[null,18,"-Tax (Savings) Moving Expenses",null,{"$f":"IF(E4<='(5)Lease B Input'!$D$4,IF(E4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$17*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0),0)","v":0},{"$f":"IF(F4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$17*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(G4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$17*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(H4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$17*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(I4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$17*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(J4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$17*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(K4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$17*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(L4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$17*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(M4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$17*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF('(5)Lease B Input'!$D$4=0,0,-($D$17*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4))","v":0}]
[null,19,"-Tax (Savings) Existing Lease Buyout ",null,{"$f":"IF(E4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$18*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(F4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$18*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(G4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$18*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(H4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$18*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(I4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$18*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(J4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$18*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(K4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$18*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(L4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$18*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(M4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$18*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(N4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$18*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0}]
[null,20,"-Tax (Savings) Leasing Commission",null,{"$f":"IF(E4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$19*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(F4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$19*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(G4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$19*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(H4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$19*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(I4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$19*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(J4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$19*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(K4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$19*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(L4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$19*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(M4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$19*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0},{"$f":"IF(N4<='(5)Lease B Input'!$D$4,IF('(5)Lease B Input'!$D$4=0,0,-($D$19*'(5)Lease B Input'!$D$39/'(5)Lease B Input'!$D$4)),0)","v":0}]
[null,21,"=CASH FLOW AFTER TAXES",{"$f":"D21-D22-D23-D24-D25-D26","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Summary",null,"Before Tax",null,"After Tax"]
[null,22,"INCREMENTAL LEASE VALUE @",{"$f":"'(5)Lease B Input'!D38","v":0},{"$f":"NPV(D29,E21:N21)+D21","v":0},{"$f":"'(5)Lease B Input'!E38","v":0},{"$f":"NPV(F29,E27:N27)+D27","v":0}]

{"sheet":"(8)Lease C Input","index":8,"n_rows":135,"n_cols":14,"rows_kept":135,"cut":false,"hidden":true,"merged":[[41,1,41,2],[36,1,36,2],[23,1,23,2],[7,5,7,6],[1,1,1,2],[22,1,22,2],[31,1,31,2],[2,1,2,2]]}
[]
[null,{"$f":"CONCATENATE(\"Lease C Input Sheet - \",TEXT(TODAY(),\"m/d/yyyy\"))","v":"Lease C Input Sheet - 8/16/2021"}]
[null,"Lease Assumptions"]
[null,1,"Lease Term in Years",null,null,null,100]
[null,2,"Rentable Square Feet"]
[null,3,"Base Rent"]
[null,4,"Base Rent Fixed Escalation Per SF Annually"]
[null,5,"Base Rent Concession (Number of Months)"]
[null,6,"Parking"]
[null,7,"Real Estate Taxes"]
[null,8,"Real Estate Tax Stop"]
[null,9,"Operating Expenses"]
[null,10,"Operating Expense Stop"]
[null,11,"Total Tenant Improvements"]
[null,12,"Tenant Improvement Allowance"]
[null,13,"Amortized TI's/ Interest Rate"]
[null,14,"Total Moving Expense"]
[null,15,"Moving Expense Allowance"]
[null,16,"Total Existing Lease Buyout"]
[null,17,"Existing Lease Buyout Allowance"]
[null,18,"Leasing Commission"]
[null,19,"Sales Per SF / % of Sales / Sales Threshold",null,null,{"$f":"IF(E22=0,0,(D5*D6)/E22)","v":0}]
[null,"Escalation Assumptions"]
[null,"End of Year",null,null,1,2,3,4,5,6,7,8,9,10]
[null,20,"Base Rent",null,"N/A",null,{"$f":"F25","v":0},{"$f":"G25","v":0},0,0,0,0,0,0]
[null,21,"Parking",null,"N/A",null,{"$f":"F26","v":0},0,0,0,0,0,0,0]
[null,22,"Real Estate Taxes",null,"N/A",null,0,0,0,0,0,0,0,0]
[null,23,"Real Estate Tax Stop",null,"N/A",null,0,0,0,0,0,0,0,0]
[null,24,"Operating Expenses",null,"N/A",null,0,0,0,0,0,0,0,0]
[null,25,"Operating Expense Stop",null,"N/A",null,0,0,0,0,0,0,0,0]
[null,26,"Gross Sales ",null,"N/A",null,0,0,0,0,0,0,0,0]
[null,"Tenant Assumptions"]
[null,27,"Before Tax Discount Rate /After Tax Discount Rate"]
[null,28,"Marginal Tax Rate"]
[null,29,"Tenant Improvements Useful Life",null,"Year 1",{"$f":"ROUND((H35/12)*11.5,5)","v":0},"Yrs. 2,3,4, etc",{"$f":"IF(D35=0,0,ROUND(1/D35,5))","v":0}]
[null,30,"Bonus Depreciation Allowance (%)"]
[null,"Owner Assumptions"]
[null,31,"Before Tax Discount Rate / After Tax Discount Rate"]
[null,32,"Marginal Tax Rate",null,null,{"$f":"ROUND((H39/12)*11.5,5)","v":0},"Yrs. 2,3,4, etc",{"$f":"IF(D40=0,0,ROUND(1/D40,5))","v":0}]
[null,33,"Tenant Improvements Useful Life",null,"Year 1"]
[null,34,"Bonus Depreciation Allowance (%)"]
[null,"GAPP Accounting Reporting"]
[null,35,"Tenant's Incremental Borrowing Rate"]
[null,36,"Reasonable Cap Rate to Apply to Initial Base Rent"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,3,null,1]
[null,null,"Base Rent Per SF",1]
[null,null,"Total Base Rent",1]
[null,null,null,1]
[null,6,null,1]
[null,null,"Parking Per SF",1]
[null,null,"Total Parking",1]
[null,null,null,1]
[null,7,null,1]
[null,null,"Real Estate Taxes Per SF",1]
[null,null,"Total Real Estate Taxes",1]
[null,null,null,1]
[null,8,null,1]
[null,null,"Real Estate Tax Stop Per SF",1]
[null,null,"Total Real Estate Tax Stop",1]
[null,null,null,1]
[null,9,null,1]
[null,null,"Operating Expenses Per SF",1]
[null,null,"Total Operating Expenses",1]
[null,null,null,1]
[null,10,null,1]
[null,null,"Operating Expense Stop Per SF",1]
[null,null,"Total Operating Expense Stop",1]
[null,null,null,1]
[null,11,null,1]
[null,null,"Tenant Improvements Per SF",1]
[null,null,"Total Tenant Improvements",1]
[null,null,null,1]
[null,12,null,1]
[null,null,"Tenant Improvements Allowance Per SF",1]
[null,null,"Total Tenant Improvements Allowance",1]
[null,null,null,1]
[null,13,null,1]
[null,null,"Amortized TI's Per SF",1]
[null,null,"Total Amortized TI'l",1]
[null,null,null,1]

{"sheet":"(9)Lease C Tenant","index":9,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":true,"merged":[[35,1,35,2],[1,1,1,4],[29,1,29,2],[29,3,29,4],[29,5,29,6],[3,1,3,2],[2,1,2,2],[22,1,22,2],[13,1,13,2]]}
[]
[null,"Lease \"C\" Tenant Spreadsheet"]
[null,"Total Occupancy Costs"]
[null,"End of Year",null,"0",1,2,3,4,5,6,7,8,9,10]
[null,1,"Base Rent",null,{"$f":"IF('(8)Lease C Input'!D6<'(8)Lease C Input'!G4,'(8)Lease C Input'!D5*'(8)Lease C Input'!D6,'(8)Lease C Input'!D6)","v":0},{"$f":"IF(F4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$7>0,'(9)Lease C Tenant'!E5+('(8)Lease C Input'!$D$5*'(8)Lease C Input'!$D$7),E5*(1+'(8)Lease C Input'!F25)),0)","v":0},{"$f":"IF(G4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$7>0,'(9)Lease C Tenant'!F5+('(8)Lease C Input'!$D$5*'(8)Lease C Input'!$D$7),F5*(1+'(8)Lease C Input'!G25)),0)","v":0},{"$f":"IF(H4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$7>0,'(9)Lease C Tenant'!G5+('(8)Lease C Input'!$D$5*'(8)Lease C Input'!$D$7),G5*(1+'(8)Lease C Input'!H25)),0)","v":0},{"$f":"IF(I4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$7>0,'(9)Lease C Tenant'!H5+('(8)Lease C Input'!$D$5*'(8)Lease C Input'!$D$7),H5*(1+'(8)Lease C Input'!I25)),0)","v":0},{"$f":"IF(J4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$7>0,'(9)Lease C Tenant'!I5+('(8)Lease C Input'!$D$5*'(8)Lease C Input'!$D$7),I5*(1+'(8)Lease C Input'!J25)),0)","v":0},{"$f":"IF(K4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$7>0,'(9)Lease C Tenant'!J5+('(8)Lease C Input'!$D$5*'(8)Lease C Input'!$D$7),J5*(1+'(8)Lease C Input'!K25)),0)","v":0},{"$f":"IF(L4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$7>0,'(9)Lease C Tenant'!K5+('(8)Lease C Input'!$D$5*'(8)Lease C Input'!$D$7),K5*(1+'(8)Lease C Input'!L25)),0)","v":0},{"$f":"IF(M4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$7>0,'(9)Lease C Tenant'!L5+('(8)Lease C Input'!$D$5*'(8)Lease C Input'!$D$7),L5*(1+'(8)Lease C Input'!M25)),0)","v":0},{"$f":"IF(N4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$7>0,'(9)Lease C Tenant'!M5+('(8)Lease C Input'!$D$5*'(8)Lease C Input'!$D$7),M5*(1+'(8)Lease C Input'!N25)),0)","v":0}]
[null,2,"+Percentage Rent",null,{"$f":"MAX(0,('(8)Lease C Input'!$D$22*'(8)Lease C Input'!$D$5-'(8)Lease C Input'!$F$22)*'(8)Lease C Input'!$E$22)","v":0},{"$f":"IF(F4<='(8)Lease C Input'!$D$4,MAX(0,(('(8)Lease C Input'!$D$22*'(8)Lease C Input'!$D$5*(1+'(8)Lease C Input'!$F$31)-'(8)Lease C Input'!$F$22))*'(8)Lease C Input'!$E$22),0)","v":0},{"$f":"IF(G4<='(8)Lease C Input'!D5,MAX(0,((('(8)Lease C Input'!$D$22*'(8)Lease C Input'!$D$5*(1+'(8)Lease C Input'!$F$31)*(1+'(8)Lease C Input'!$G$31)-'(8)Lease C Input'!$F$22)))*'(8)Lease C Input'!$E$22),0)","v":0},{"$f":"IF(H4<='(8)Lease C Input'!D4,MAX(0,(((('(8)Lease C Input'!$D$22*'(8)Lease C Input'!$D$5*(1+'(8)Lease C Input'!$F$31)*(1+'(8)Lease C Input'!$G$31)*(1+'(8)Lease C Input'!$H$31)-'(8)Lease C Input'!$F$22))))*'(8)Lease C Input'!$E$22),0)","v":0},{"$f":"IF(I4<='(8)Lease C Input'!D4,MAX(0,((((('(8)Lease C Input'!$D$22*'(8)Lease C Input'!$D$5*(1+'(8)Lease C Input'!$F$31)*(1+'(8)Lease C Input'!$G$31)*(1+'(8)Lease C Input'!$H$31)*(1+'(8)Lease C Input'!$I$31)-'(8)Lease C Input'!$F$22)))))*'(8)Lease C Input'!$E$22),0)","v":0},{"$f":"IF(J4<='(8)Lease C Input'!D4,MAX(0,(((((('(8)Lease C Input'!$D$22*'(8)Lease C Input'!$D$5*(1+'(8)Lease C Input'!$F$31)*(1+'(8)Lease C Input'!$G$31)*(1+'(8)Lease C Input'!$H$31)*(1+'(8)Lease C Input'!$I$31)*(1+'(8)Lease C Input'!$J$31)-'(8)Lease C Input'!$F$22))))))*'(8)Lease C Input'!$E$22),0)","v":0},{"$f":"IF(K4<='(8)Lease C Input'!D4,MAX(0,((((((('(8)Lease C Input'!$D$22*'(8)Lease C Input'!$D$5*(1+'(8)Lease C Input'!$F$31)*(1+'(8)Lease C Input'!$G$31)*(1+'(8)Lease C Input'!$H$31)*(1+'(8)Lease C Input'!$I$31)*(1+'(8)Lease C Input'!$J$31)*(1+'(8)Lease C Input'!$K$31)-'(8)Lease C Input'!$F$22)))))))*'(8)Lease C Input'!$E$22),0)","v":0},{"$f":"IF(L4<='(8)Lease C Input'!D4,MAX(0,(((((((('(8)Lease C Input'!$D$22*'(8)Lease C Input'!$D$5*(1+'(8)Lease C Input'!$F$31)*(1+'(8)Lease C Input'!$G$31)*(1+'(8)Lease C Input'!$H$31)*(1+'(8)Lease C Input'!$I$31)*(1+'(8)Lease C Input'!$J$31)*(1+'(8)Lease C Input'!$K$31)*(1+'(8)Lease C Input'!$L$31)-'(8)Lease C Input'!$F$22))))))))*'(8)Lease C Input'!$E$22),0)","v":0},{"$f":"IF(M4<='(8)Lease C Input'!D4,MAX(0,((((((((('(8)Lease C Input'!$D$22*'(8)Lease C Input'!$D$5*(1+'(8)Lease C Input'!$F$31)*(1+'(8)Lease C Input'!$G$31)*(1+'(8)Lease C Input'!$H$31)*(1+'(8)Lease C Input'!$I$31)*(1+'(8)Lease C Input'!$J$31)*(1+'(8)Lease C Input'!$K$31)*(1+'(8)Lease C Input'!$L$31)*(1+'(8)Lease C Input'!$M$31)-'(8)Lease C Input'!$F$22)))))))))*'(8)Lease C Input'!$E$22),0)","v":0},{"$f":"IF(N4<='(8)Lease C Input'!D4,MAX(0,(((((((((('(8)Lease C Input'!$D$22*'(8)Lease C Input'!$D$5*(1+'(8)Lease C Input'!$F$31)*(1+'(8)Lease C Input'!$G$31)*(1+'(8)Lease C Input'!$H$31)*(1+'(8)Lease C Input'!$I$31)*(1+'(8)Lease C Input'!$J$31)*(1+'(8)Lease C Input'!$K$31)*(1+'(8)Lease C Input'!$L$31)*(1+'(8)Lease C Input'!$M$31)*(1+'(8)Lease C Input'!$N$31)-'(8)Lease C Input'!$F$22))))))))))*'(8)Lease C Input'!$E$22),0)","v":0}]
[null,3,"+Amortized TI's Additional Rent",null,{"$f":"IF('(8)Lease C Input'!$D$4=0,0,-PMT('(8)Lease C Input'!$E$16/12,'(8)Lease C Input'!$D$4*12,$D$20,0,0)*12)","v":0},{"$f":"IF(F4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-PMT('(8)Lease C Input'!$E$16/12,'(8)Lease C Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(G4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-PMT('(8)Lease C Input'!$E$16/12,'(8)Lease C Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(H4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-PMT('(8)Lease C Input'!$E$16/12,'(8)Lease C Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(I4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-PMT('(8)Lease C Input'!$E$16/12,'(8)Lease C Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(J4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-PMT('(8)Lease C Input'!$E$16/12,'(8)Lease C Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(K4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-PMT('(8)Lease C Input'!$E$16/12,'(8)Lease C Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(L4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-PMT('(8)Lease C Input'!$E$16/12,'(8)Lease C Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(M4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-PMT('(8)Lease C Input'!$E$16/12,'(8)Lease C Input'!$D$4*12,$D$20,0,0)*12),0)","v":0},{"$f":"IF(N4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-PMT('(8)Lease C Input'!$E$16/12,'(8)Lease C Input'!$D$4*12,$D$20,0,0)*12),0)","v":0}]
[null,4,"+Parking",null,{"$f":"IF('(8)Lease C Input'!D9<'(8)Lease C Input'!G4,'(8)Lease C Input'!D9*'(8)Lease C Input'!D5,'(8)Lease C Input'!D9)","v":0},{"$f":"IF(F4<='(8)Lease C Input'!$D$4,E8*(1+'(8)Lease C Input'!F26),0)","v":0},{"$f":"IF(G4<='(8)Lease C Input'!$D$4,F8*(1+'(8)Lease C Input'!G26),0)","v":0},{"$f":"IF(H4<='(8)Lease C Input'!$D$4,G8*(1+'(8)Lease C Input'!H26),0)","v":0},{"$f":"IF(I4<='(8)Lease C Input'!$D$4,H8*(1+'(8)Lease C Input'!I26),0)","v":0},{"$f":"IF(J4<='(8)Lease C Input'!$D$4,I8*(1+'(8)Lease C Input'!J26),0)","v":0},{"$f":"IF(K4<='(8)Lease C Input'!$D$4,J8*(1+'(8)Lease C Input'!K26),0)","v":0},{"$f":"IF(L4<='(8)Lease C Input'!$D$4,K8*(1+'(8)Lease C Input'!L26),0)","v":0},{"$f":"IF(M4<='(8)Lease C Input'!$D$4,L8*(1+'(8)Lease C Input'!M26),0)","v":0},{"$f":"IF(N4<='(8)Lease C Input'!$D$4,M8*(1+'(8)Lease C Input'!N26),0)","v":0}]
[null,5,"+Real Estate Taxes",null,{"$f":"IF('(8)Lease C Input'!D10<'(8)Lease C Input'!G4,'(8)Lease C Input'!D10*'(8)Lease C Input'!D5,'(8)Lease C Input'!D10)","v":0},{"$f":"IF(F4<='(8)Lease C Input'!$D$4,E9*(1+'(8)Lease C Input'!F27),0)","v":0},{"$f":"IF(G4<='(8)Lease C Input'!$D$4,F9*(1+'(8)Lease C Input'!G27),0)","v":0},{"$f":"IF(H4<='(8)Lease C Input'!$D$4,G9*(1+'(8)Lease C Input'!H27),0)","v":0},{"$f":"IF(I4<='(8)Lease C Input'!$D$4,H9*(1+'(8)Lease C Input'!I27),0)","v":0},{"$f":"IF(J4<='(8)Lease C Input'!$D$4,I9*(1+'(8)Lease C Input'!J27),0)","v":0},{"$f":"IF(K4<='(8)Lease C Input'!$D$4,J9*(1+'(8)Lease C Input'!K27),0)","v":0},{"$f":"IF(L4<='(8)Lease C Input'!$D$4,K9*(1+'(8)Lease C Input'!L27),0)","v":0},{"$f":"IF(M4<='(8)Lease C Input'!$D$4,L9*(1+'(8)Lease C Input'!M27),0)","v":0},{"$f":"IF(N4<='(8)Lease C Input'!$D$4,M9*(1+'(8)Lease C Input'!N27),0)","v":0}]
[null,6,"+Operating Expenses",null,{"$f":"IF('(8)Lease C Input'!D12<'(8)Lease C Input'!G4,'(8)Lease C Input'!D12*'(8)Lease C Input'!D5,'(8)Lease C Input'!D12)","v":0},{"$f":"IF(F4<='(8)Lease C Input'!$D$4,E10*(1+'(8)Lease C Input'!F29),0)","v":0},{"$f":"IF(G4<='(8)Lease C Input'!$D$4,F10*(1+'(8)Lease C Input'!G29),0)","v":0},{"$f":"IF(H4<='(8)Lease C Input'!$D$4,G10*(1+'(8)Lease C Input'!H29),0)","v":0},{"$f":"IF(I4<='(8)Lease C Input'!$D$4,H10*(1+'(8)Lease C Input'!I29),0)","v":0},{"$f":"IF(J4<='(8)Lease C Input'!$D$4,I10*(1+'(8)Lease C Input'!J29),0)","v":0},{"$f":"IF(K4<='(8)Lease C Input'!$D$4,J10*(1+'(8)Lease C Input'!K29),0)","v":0},{"$f":"IF(L4<='(8)Lease C Input'!$D$4,K10*(1+'(8)Lease C Input'!L29),0)","v":0},{"$f":"IF(M4<='(8)Lease C Input'!$D$4,L10*(1+'(8)Lease C Input'!M29),0)","v":0},{"$f":"IF(N4<='(8)Lease C Input'!$D$4,M10*(1+'(8)Lease C Input'!N29),0)","v":0}]
[null,7,"+Tenant Improvements",{"$f":"IF('(8)Lease C Input'!D14<'(8)Lease C Input'!G4,'(8)Lease C Input'!D14*'(8)Lease C Input'!D5,'(8)Lease C Input'!D14)","v":0}]
[null,8,"+Moving Expense",{"$f":"'(8)Lease C Input'!D17","v":0}]
[null,9,"+Existing Lease Buyout ",{"$f":"'(8)Lease C Input'!D19","v":0}]
[null,"Contributions From Owner"]
[null,10,"-Rent Concession",null,{"$f":"E5/12*'(8)Lease C Input'!D8","v":0}]
[null,11,"-Parking Stop"]
[null,12,"-Real Estate Tax Stop",null,{"$f":"IF('(8)Lease C Input'!D11<'(8)Lease C Input'!G4,'(8)Lease C Input'!D11*'(8)Lease C Input'!D5,'(8)Lease C Input'!D11)","v":0},{"$f":"IF(F4<='(8)Lease C Input'!$D$4,E17*(1+'(8)Lease C Input'!F28),0)","v":0},{"$f":"IF(G4<='(8)Lease C Input'!$D$4,F17*(1+'(8)Lease C Input'!G28),0)","v":0},{"$f":"IF(H4<='(8)Lease C Input'!$D$4,G17*(1+'(8)Lease C Input'!H28),0)","v":0},{"$f":"IF(I4<='(8)Lease C Input'!$D$4,H17*(1+'(8)Lease C Input'!I28),0)","v":0},{"$f":"IF(J4<='(8)Lease C Input'!$D$4,I17*(1+'(8)Lease C Input'!J28),0)","v":0},{"$f":"IF(K4<='(8)Lease C Input'!$D$4,J17*(1+'(8)Lease C Input'!K28),0)","v":0},{"$f":"IF(L4<='(8)Lease C Input'!$D$4,K17*(1+'(8)Lease C Input'!L28),0)","v":0},{"$f":"IF(M4<='(8)Lease C Input'!$D$4,L17*(1+'(8)Lease C Input'!M28),0)","v":0},{"$f":"IF(N4<='(8)Lease C Input'!$D$4,M17*(1+'(8)Lease C Input'!N28),0)","v":0}]
[null,13,"-Operating Expense Stop",null,{"$f":"IF('(8)Lease C Input'!D13<'(8)Lease C Input'!G4,'(8)Lease C Input'!D13*'(8)Lease C Input'!D5,'(8)Lease C Input'!D13)","v":0},{"$f":"IF(F4<='(8)Lease C Input'!$D$4,E18*(1+'(8)Lease C Input'!F30),0)","v":0},{"$f":"IF(G4<='(8)Lease C Input'!$D$4,F18*(1+'(8)Lease C Input'!G30),0)","v":0},{"$f":"IF(H4<='(8)Lease C Input'!$D$4,G18*(1+'(8)Lease C Input'!H30),0)","v":0},{"$f":"IF(I4<='(8)Lease C Input'!$D$4,H18*(1+'(8)Lease C Input'!I30),0)","v":0},{"$f":"IF(J4<='(8)Lease C Input'!$D$4,I18*(1+'(8)Lease C Input'!J30),0)","v":0},{"$f":"IF(K4<='(8)Lease C Input'!$D$4,J18*(1+'(8)Lease C Input'!K30),0)","v":0},{"$f":"IF(L4<='(8)Lease C Input'!$D$4,K18*(1+'(8)Lease C Input'!L30),0)","v":0},{"$f":"IF(M4<='(8)Lease C Input'!$D$4,L18*(1+'(8)Lease C Input'!M30),0)","v":0},{"$f":"IF(N4<='(8)Lease C Input'!$D$4,M18*(1+'(8)Lease C Input'!N30),0)","v":0}]
[null,14,"-Tenant Improvement Allowance",{"$f":"IF('(8)Lease C Input'!D15<'(8)Lease C Input'!G4,'(8)Lease C Input'!D15*'(8)Lease C Input'!D5,'(8)Lease C Input'!D15)","v":0}]
[null,15,"-Amortized Tenant Improvements",{"$f":"IF('(8)Lease C Input'!D16<'(8)Lease C Input'!G4,'(8)Lease C Input'!D16*'(8)Lease C Input'!D5,'(8)Lease C Input'!D16)","v":0}]
[null,16,"-Moving Expense Allowance",{"$f":"'(8)Lease C Input'!D18","v":0}]
[null,17,"-Existing Lease Buyout Allowance",{"$f":"'(8)Lease C Input'!D20","v":0}]
[null,"Tenant Occupancy Costs"]
[null,18,"=TENANT BEFORE TAX OCCUPANCY COST",{"$f":"SUM(D5:D13)-SUM(D15:D22)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,19,"-Tax Savings (Annual Expenditures)",null,{"$f":"E24*'(8)Lease C Input'!$D$34","v":0},{"$f":"F24*'(8)Lease C Input'!$D$34","v":0},{"$f":"G24*'(8)Lease C Input'!$D$34","v":0},{"$f":"H24*'(8)Lease C Input'!$D$34","v":0},{"$f":"I24*'(8)Lease C Input'!$D$34","v":0},{"$f":"J24*'(8)Lease C Input'!$D$34","v":0},{"$f":"K24*'(8)Lease C Input'!$D$34","v":0},{"$f":"L24*'(8)Lease C Input'!$D$34","v":0},{"$f":"M24*'(8)Lease C Input'!$D$34","v":0},{"$f":"N24*'(8)Lease C Input'!$D$34","v":0}]
[null,20,"-Tax Savings (Tenant Improvements)",null,{"$f":"IF(E4<'(8)Lease C Input'!D4,((D11-D19-D20)*(1-'(8)Lease C Input'!D36)*'(8)Lease C Input'!F35*'(8)Lease C Input'!D34)+(D11-D19-D20)*'(8)Lease C Input'!D36*'(8)Lease C Input'!D34,(D11-D19-D20)*'(8)Lease C Input'!D34)","v":0},{"$f":"IF(F4<'(8)Lease C Input'!$D$4,($D$11-$D$19-$D$20)*(1-'(8)Lease C Input'!$D$36)*'(8)Lease C Input'!$H$35*'(8)Lease C Input'!$D$34,IF(F4='(8)Lease C Input'!$D$4,($D$11-$D$19-$D$20)*'(8)Lease C Input'!$D$34-SUM('(9)Lease C Tenant'!$E$26:E26),0))","v":0},{"$f":"IF(G4<'(8)Lease C Input'!$D$4,($D$11-$D$19-$D$20)*(1-'(8)Lease C Input'!$D$36)*'(8)Lease C Input'!$H$35*'(8)Lease C Input'!$D$34,IF(G4='(8)Lease C Input'!$D$4,($D$11-$D$19-$D$20)*'(8)Lease C Input'!$D$34-SUM('(9)Lease C Tenant'!$E$26:F26),0))","v":0},{"$f":"IF(H4<'(8)Lease C Input'!$D$4,($D$11-$D$19-$D$20)*(1-'(8)Lease C Input'!$D$36)*'(8)Lease C Input'!$H$35*'(8)Lease C Input'!$D$34,IF(H4='(8)Lease C Input'!$D$4,($D$11-$D$19-$D$20)*'(8)Lease C Input'!$D$34-SUM('(9)Lease C Tenant'!$E$26:G26),0))","v":0},{"$f":"IF(I4<'(8)Lease C Input'!$D$4,($D$11-$D$19-$D$20)*(1-'(8)Lease C Input'!$D$36)*'(8)Lease C Input'!$H$35*'(8)Lease C Input'!$D$34,IF(I4='(8)Lease C Input'!$D$4,($D$11-$D$19-$D$20)*'(8)Lease C Input'!$D$34-SUM('(9)Lease C Tenant'!$E$26:H26),0))","v":0},{"$f":"IF(J4<'(8)Lease C Input'!$D$4,($D$11-$D$19-$D$20)*(1-'(8)Lease C Input'!$D$36)*'(8)Lease C Input'!$H$35*'(8)Lease C Input'!$D$34,IF(J4='(8)Lease C Input'!$D$4,($D$11-$D$19-$D$20)*'(8)Lease C Input'!$D$34-SUM('(9)Lease C Tenant'!$E$26:I26),0))","v":0},{"$f":"IF(K4<'(8)Lease C Input'!$D$4,($D$11-$D$19-$D$20)*(1-'(8)Lease C Input'!$D$36)*'(8)Lease C Input'!$H$35*'(8)Lease C Input'!$D$34,IF(K4='(8)Lease C Input'!$D$4,($D$11-$D$19-$D$20)*'(8)Lease C Input'!$D$34-SUM('(9)Lease C Tenant'!$E$26:J26),0))","v":0},{"$f":"IF(L4<'(8)Lease C Input'!$D$4,($D$11-$D$19-$D$20)*(1-'(8)Lease C Input'!$D$36)*'(8)Lease C Input'!$H$35*'(8)Lease C Input'!$D$34,IF(L4='(8)Lease C Input'!$D$4,($D$11-$D$19-$D$20)*'(8)Lease C Input'!$D$34-SUM('(9)Lease C Tenant'!$E$26:K26),0))","v":0},{"$f":"IF(M4<'(8)Lease C Input'!$D$4,($D$11-$D$19-$D$20)*(1-'(8)Lease C Input'!$D$36)*'(8)Lease C Input'!$H$35*'(8)Lease C Input'!$D$34,IF(M4='(8)Lease C Input'!$D$4,($D$11-$D$19-$D$20)*'(8)Lease C Input'!$D$34-SUM('(9)Lease C Tenant'!$E$26:L26),0))","v":0},{"$f":"IF(N4<'(8)Lease C Input'!$D$4,($D$11-$D$19-$D$20)*(1-'(8)Lease C Input'!$D$36)*'(8)Lease C Input'!$H$35*'(8)Lease C Input'!$D$34,IF(N4='(8)Lease C Input'!$D$4,($D$11-$D$19-$D$20)*'(8)Lease C Input'!$D$34-SUM('(9)Lease C Tenant'!$E$26:M26),0))","v":0}]
[null,21,"-Tax Savings (Moving Expenses)",null,{"$f":"(D12-D21)*'(8)Lease C Input'!D34","v":0}]
[null,22,"-Tax Savings (Existing Lease Buyout)",null,{"$f":"(D13-D22)*'(8)Lease C Input'!D34","v":0}]
[null,23,"=TENANT AFTER TAX OCCUPANCY COST",{"$f":"D24-D25-D26-D27-D28","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Summary",null,"Before Tax",null,"After Tax"]
[null,24,"TOTAL EFFECTIVE RENT:",null,{"$f":"SUM(D24:N24)","v":0},null,{"$f":"SUM(D29:N29)","v":0}]
[null,25,"TOTAL EFFECTIVE RATE:",null,{"$f":"IF('(8)Lease C Input'!D5=0,0,E31/'(8)Lease C Input'!D5)","v":0},null,{"$f":"IF('(8)Lease C Input'!D5=0,0,G31/'(8)Lease C Input'!D5)","v":0}]
[null,26,"AVERAGE ANNUAL EFFECTIVE RENT:",null,{"$f":"IF('(8)Lease C Input'!D4=0,0,E31/'(8)Lease C Input'!D4)","v":0},null,{"$f":"IF('(8)Lease C Input'!D4=0,0,G31/'(8)Lease C Input'!D4)","v":0}]
[null,27,"AVERAGE ANNUAL EFFECTIVE RATE:",null,{"$f":"IF('(8)Lease C Input'!D5=0,0,E33/'(8)Lease C Input'!D5)","v":0},null,{"$f":"IF('(8)Lease C Input'!D5=0,0,G33/'(8)Lease C Input'!D5)","v":0}]
[null,28,"DISCOUNTED EFFECTIVE RENT            @",{"$f":"'(8)Lease C Input'!D33","v":0},{"$f":"NPV(D35,E24:N24)+D24","v":0},{"$f":"'(8)Lease C Input'!E33","v":0},{"$f":"NPV(F35,E29:N29)+D29","v":0}]
[null,"GAPP Accounting Reporting"]
[null,29,"Straightline GAPP Rent Annual Expense",{"$f":"E33","v":0}]
[null,30,"Tenant's Incremental Borrowing Rate",{"$f":"'(8)Lease C Input'!D43","v":0}]
[null,31,"Reasonable CAP Rate to Apply to Initial Base Rent",{"$f":"'(8)Lease C Input'!D44","v":0}]
[null,32,"Estimated Fair Market Value of Leased Space",{"$f":"IF(D39=0,0,E5/D39)","v":0}]
[null,33,"90% Threshhold for FAS-13 Capital Lease Test",{"$f":"D40*0.9","v":0}]
[null,34,"Present Value of Minimum Lease Payments",{"$f":"NPV(D38,E5:N5)+D5","v":0}]

{"sheet":"(10)Lease C Owner","index":10,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":true,"merged":[[1,1,1,3],[2,1,2,2],[10,1,10,2],[27,5,27,6],[19,1,19,2],[27,1,27,2],[3,1,3,2],[27,3,27,4]]}
[]
[null,"Lease \"C\" Owner Spreadsheet"]
[null,"Collections"]
[null,"End of Year",null,"0",1,2,3,4,5,6,7,8,9,10]
[null,1,"Base Rent",null,{"$f":"'(9)Lease C Tenant'!E5","v":0},{"$f":"'(9)Lease C Tenant'!F5","v":0},{"$f":"'(9)Lease C Tenant'!G5","v":0},{"$f":"'(9)Lease C Tenant'!H5","v":0},{"$f":"'(9)Lease C Tenant'!I5","v":0},{"$f":"'(9)Lease C Tenant'!J5","v":0},{"$f":"'(9)Lease C Tenant'!K5","v":0},{"$f":"'(9)Lease C Tenant'!L5","v":0},{"$f":"'(9)Lease C Tenant'!M5","v":0},{"$f":"'(9)Lease C Tenant'!N5","v":0}]
[null,2,"+Percentage Rent",null,{"$f":"'(9)Lease C Tenant'!E6","v":0},{"$f":"'(9)Lease C Tenant'!F6","v":0},{"$f":"'(9)Lease C Tenant'!G6","v":0},{"$f":"'(9)Lease C Tenant'!H6","v":0},{"$f":"'(9)Lease C Tenant'!I6","v":0},{"$f":"'(9)Lease C Tenant'!J6","v":0},{"$f":"'(9)Lease C Tenant'!K6","v":0},{"$f":"'(9)Lease C Tenant'!L6","v":0},{"$f":"'(9)Lease C Tenant'!M6","v":0},{"$f":"'(9)Lease C Tenant'!N6","v":0}]
[null,3,"+Amortized TI's Additional Rent",null,{"$f":"'(9)Lease C Tenant'!E7","v":0},{"$f":"'(9)Lease C Tenant'!F7","v":0},{"$f":"'(9)Lease C Tenant'!G7","v":0},{"$f":"'(9)Lease C Tenant'!H7","v":0},{"$f":"'(9)Lease C Tenant'!I7","v":0},{"$f":"'(9)Lease C Tenant'!J7","v":0},{"$f":"'(9)Lease C Tenant'!K7","v":0},{"$f":"'(9)Lease C Tenant'!L7","v":0},{"$f":"'(9)Lease C Tenant'!M7","v":0},{"$f":"'(9)Lease C Tenant'!N7","v":0}]
[null,4,"+Parking From Tenant",null,{"$f":"'(9)Lease C Tenant'!E8","v":0},{"$f":"'(9)Lease C Tenant'!F8","v":0},{"$f":"'(9)Lease C Tenant'!G8","v":0},{"$f":"'(9)Lease C Tenant'!H8","v":0},{"$f":"'(9)Lease C Tenant'!I8","v":0},{"$f":"'(9)Lease C Tenant'!J8","v":0},{"$f":"'(9)Lease C Tenant'!K8","v":0},{"$f":"'(9)Lease C Tenant'!L8","v":0},{"$f":"'(9)Lease C Tenant'!M8","v":0},{"$f":"'(9)Lease C Tenant'!N8","v":0}]
[null,5,"+Real Estate Taxes From Tenant",null,{"$f":"'(9)Lease C Tenant'!E9-'(9)Lease C Tenant'!E17","v":0},{"$f":"'(9)Lease C Tenant'!F9-'(9)Lease C Tenant'!F17","v":0},{"$f":"'(9)Lease C Tenant'!G9-'(9)Lease C Tenant'!G17","v":0},{"$f":"'(9)Lease C Tenant'!H9-'(9)Lease C Tenant'!H17","v":0},{"$f":"'(9)Lease C Tenant'!I9-'(9)Lease C Tenant'!I17","v":0},{"$f":"'(9)Lease C Tenant'!J9-'(9)Lease C Tenant'!J17","v":0},{"$f":"'(9)Lease C Tenant'!K9-'(9)Lease C Tenant'!K17","v":0},{"$f":"'(9)Lease C Tenant'!L9-'(9)Lease C Tenant'!L17","v":0},{"$f":"'(9)Lease C Tenant'!M9-'(9)Lease C Tenant'!M17","v":0},{"$f":"'(9)Lease C Tenant'!N9-'(9)Lease C Tenant'!N17","v":0}]
[null,6,"+Operating Expenses From Tenant",null,{"$f":"'(9)Lease C Tenant'!E10-'(9)Lease C Tenant'!E18","v":0},{"$f":"'(9)Lease C Tenant'!F10-'(9)Lease C Tenant'!F18","v":0},{"$f":"'(9)Lease C Tenant'!G10-'(9)Lease C Tenant'!G18","v":0},{"$f":"'(9)Lease C Tenant'!H10-'(9)Lease C Tenant'!H18","v":0},{"$f":"'(9)Lease C Tenant'!I10-'(9)Lease C Tenant'!I18","v":0},{"$f":"'(9)Lease C Tenant'!J10-'(9)Lease C Tenant'!J18","v":0},{"$f":"'(9)Lease C Tenant'!K10-'(9)Lease C Tenant'!K18","v":0},{"$f":"'(9)Lease C Tenant'!L10-'(9)Lease C Tenant'!L18","v":0},{"$f":"'(9)Lease C Tenant'!M10-'(9)Lease C Tenant'!M18","v":0},{"$f":"'(9)Lease C Tenant'!N10-'(9)Lease C Tenant'!N18","v":0}]
[null,"Disbursements"]
[null,7,"-Rent Concession",null,{"$f":"'(9)Lease C Tenant'!E15","v":0}]
[null,8,"-Total Real Estate Taxes",null,{"$f":"'(9)Lease C Tenant'!E9","v":0},{"$f":"'(9)Lease C Tenant'!F9","v":0},{"$f":"'(9)Lease C Tenant'!G9","v":0},{"$f":"'(9)Lease C Tenant'!H9","v":0},{"$f":"'(9)Lease C Tenant'!I9","v":0},{"$f":"'(9)Lease C Tenant'!J9","v":0},{"$f":"'(9)Lease C Tenant'!K9","v":0},{"$f":"'(9)Lease C Tenant'!L9","v":0},{"$f":"'(9)Lease C Tenant'!M9","v":0},{"$f":"'(9)Lease C Tenant'!N9","v":0}]
[null,9,"-Total Operating Expenses",null,{"$f":"'(9)Lease C Tenant'!E10","v":0},{"$f":"'(9)Lease C Tenant'!F10","v":0},{"$f":"'(9)Lease C Tenant'!G10","v":0},{"$f":"'(9)Lease C Tenant'!H10","v":0},{"$f":"'(9)Lease C Tenant'!I10","v":0},{"$f":"'(9)Lease C Tenant'!J10","v":0},{"$f":"'(9)Lease C Tenant'!K10","v":0},{"$f":"'(9)Lease C Tenant'!L10","v":0},{"$f":"'(9)Lease C Tenant'!M10","v":0},{"$f":"'(9)Lease C Tenant'!N10","v":0}]
[null,10,"-Tenant Improvement Allowance",{"$f":"'(9)Lease C Tenant'!D19","v":0}]
[null,11,"-Amortized Tenant Improvements",{"$f":"'(9)Lease C Tenant'!D20","v":0}]
[null,12,"-Moving Expense Allowance",{"$f":"'(8)Lease C Input'!D18","v":0}]
[null,13,"- Existing Lease Buyout Allowance",{"$f":"'(8)Lease C Input'!D20","v":0}]
[null,14,"- Leasing Commission",{"$f":"((SUM(E5:N5)*'(8)Lease C Input'!D21))","v":0}]
[null,"Owner Cash Flows"]
[null,15,"=CASH FLOW BEFORE TAXES",{"$f":"SUM(D5:D10)-SUM(D12:D19)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,16,"-Tax (Savings) Annual Income",null,{"$f":"E21*'(8)Lease C Input'!D39","v":0},{"$f":"F21*'(8)Lease C Input'!D39","v":0},{"$f":"G21*'(8)Lease C Input'!D39","v":0},{"$f":"H21*'(8)Lease C Input'!D39","v":0},{"$f":"I21*'(8)Lease C Input'!$D$39","v":0},{"$f":"J21*'(8)Lease C Input'!$D$39","v":0},{"$f":"K21*'(8)Lease C Input'!$D$39","v":0},{"$f":"L21*'(8)Lease C Input'!$D$39","v":0},{"$f":"M21*'(8)Lease C Input'!$D$39","v":0},{"$f":"N21*'(8)Lease C Input'!$D$39","v":0}]
[null,17,"-Tax (Savings) Tenant Improvements",null,{"$f":"-((((D15+D16)*(1-'(8)Lease C Input'!D41))*'(8)Lease C Input'!F35*'(8)Lease C Input'!D39)+((D15+D16)*'(8)Lease C Input'!D41*'(8)Lease C Input'!D39))","v":0},{"$f":"IF(F4<='(8)Lease C Input'!$D$4,-((($D$15+$D$16)*(1-'(8)Lease C Input'!$D$41))*'(8)Lease C Input'!$H$35*'(8)Lease C Input'!$D$39),0)","v":0},{"$f":"IF(G4<='(8)Lease C Input'!$D$4,-((($D$15+$D$16)*(1-'(8)Lease C Input'!$D$41))*'(8)Lease C Input'!$H$35*'(8)Lease C Input'!$D$39),0)","v":0},{"$f":"IF(H4<='(8)Lease C Input'!$D$4,-((($D$15+$D$16)*(1-'(8)Lease C Input'!$D$41))*'(8)Lease C Input'!$H$35*'(8)Lease C Input'!$D$39),0)","v":0},{"$f":"IF(I4<='(8)Lease C Input'!$D$4,-((($D$15+$D$16)*(1-'(8)Lease C Input'!$D$41))*'(8)Lease C Input'!$H$35*'(8)Lease C Input'!$D$39),0)","v":0},{"$f":"IF(J4<='(8)Lease C Input'!$D$4,-((($D$15+$D$16)*(1-'(8)Lease C Input'!$D$41))*'(8)Lease C Input'!$H$35*'(8)Lease C Input'!$D$39),0)","v":0},{"$f":"IF(K4<='(8)Lease C Input'!$D$4,-((($D$15+$D$16)*(1-'(8)Lease C Input'!$D$41))*'(8)Lease C Input'!$H$35*'(8)Lease C Input'!$D$39),0)","v":0},{"$f":"IF(L4<='(8)Lease C Input'!$D$4,-((($D$15+$D$16)*(1-'(8)Lease C Input'!$D$41))*'(8)Lease C Input'!$H$35*'(8)Lease C Input'!$D$39),0)","v":0},{"$f":"IF(M4<='(8)Lease C Input'!$D$4,-((($D$15+$D$16)*(1-'(8)Lease C Input'!$D$41))*'(8)Lease C Input'!$H$35*'(8)Lease C Input'!$D$39),0)","v":0},{"$f":"IF(N4<='(8)Lease C Input'!$D$4,-((($D$15+$D$16)*(1-'(8)Lease C Input'!$D$41))*'(8)Lease C Input'!$H$35*'(8)Lease C Input'!$D$39),0)","v":0}]
[null,18,"-Tax (Savings) Moving Expenses",null,{"$f":"IF(E4<='(8)Lease C Input'!$D$4,IF(E4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$17*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0),0)","v":0},{"$f":"IF(F4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$17*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(G4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$17*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(H4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$17*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(I4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$17*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(J4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$17*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(K4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$17*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(L4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$17*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(M4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$17*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF('(8)Lease C Input'!$D$4=0,0,-($D$17*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4))","v":0}]
[null,19,"-Tax (Savings) Existing Lease Buyout ",null,{"$f":"IF(E4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$18*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(F4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$18*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(G4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$18*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(H4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$18*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(I4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$18*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(J4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$18*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(K4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$18*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(L4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$18*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(M4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$18*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(N4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$18*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0}]
[null,20,"-Tax (Savings) Leasing Commission",null,{"$f":"IF(E4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$19*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(F4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$19*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(G4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$19*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(H4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$19*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(I4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$19*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(J4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$19*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(K4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$19*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(L4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$19*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(M4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$19*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0},{"$f":"IF(N4<='(8)Lease C Input'!$D$4,IF('(8)Lease C Input'!$D$4=0,0,-($D$19*'(8)Lease C Input'!$D$39/'(8)Lease C Input'!$D$4)),0)","v":0}]
[null,21,"=CASH FLOW AFTER TAXES",{"$f":"D21-D22-D23-D24-D25-D26","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Summary",null,"Before Tax",null,"After Tax"]
[null,22,"INCREMENTAL LEASE VALUE @",{"$f":"'(8)Lease C Input'!D38","v":0},{"$f":"NPV(D29,E21:N21)+D21","v":0},{"$f":"'(8)Lease C Input'!E38","v":0},{"$f":"NPV(F29,E27:N27)+D27","v":0}]

{"sheet":"(11)Before Tax Summary","index":11,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":true,"merged":[[37,1,37,3],[0,1,0,12],[3,4,3,5],[3,7,3,8],[3,10,3,11],[1,1,1,6],[23,7,23,8],[23,10,23,11],[2,1,2,12],[22,1,22,12],[23,4,23,5],[21,1,21,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3]]}
[]
[null,"Before Tax Summary"]
[null,"Tenant"]
[null,null,null,null,"Lease A",null,null,"Lease B",null,null,"Lease C"]
[null,null,null,null,"EOY","$",null,"EOY","$",null,"EOY","$"]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>0,\"O\",0)","v":0},{"$f":"'Occupancy Costs'!D24","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>0,\"O\",0)","v":0},{"$f":"'(6)Lease B Tenant'!D24","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>0,\"O\",0)","v":0},{"$f":"'(9)Lease C Tenant'!D24","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=1,1,0)","v":0},{"$f":"'Occupancy Costs'!E24","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=1,1,0)","v":0},{"$f":"'(6)Lease B Tenant'!E24","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=1,1,0)","v":0},{"$f":"'(9)Lease C Tenant'!E24","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=2,2,0)","v":0},{"$f":"'Occupancy Costs'!F24","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=2,2,0)","v":0},{"$f":"'(6)Lease B Tenant'!F24","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=2,2,0)","v":0},{"$f":"'(9)Lease C Tenant'!F24","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=3,3,0)","v":0},{"$f":"'Occupancy Costs'!G24","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=3,3,0)","v":0},{"$f":"'(6)Lease B Tenant'!G24","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=3,3,0)","v":0},{"$f":"'(9)Lease C Tenant'!G24","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=4,4,0)","v":0},{"$f":"'Occupancy Costs'!H24","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=4,4,0)","v":0},{"$f":"'(6)Lease B Tenant'!H24","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=4,4,0)","v":0},{"$f":"'(9)Lease C Tenant'!H24","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=5,5,0)","v":0},{"$f":"'Occupancy Costs'!I24","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=5,5,0)","v":0},{"$f":"'(6)Lease B Tenant'!I24","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=5,5,0)","v":0},{"$f":"'(9)Lease C Tenant'!I24","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=6,6,0)","v":0},{"$f":"'Occupancy Costs'!J24","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=6,6,0)","v":0},{"$f":"'(6)Lease B Tenant'!J24","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=6,6,0)","v":0},{"$f":"'(9)Lease C Tenant'!J24","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=7,7,0)","v":0},{"$f":"'Occupancy Costs'!K24","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=7,7,0)","v":0},{"$f":"'(6)Lease B Tenant'!K24","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=7,7,0)","v":0},{"$f":"'(9)Lease C Tenant'!K24","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=8,8,0)","v":0},{"$f":"'Occupancy Costs'!L24","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=8,8,0)","v":0},{"$f":"'(6)Lease B Tenant'!L24","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=8,8,0)","v":0},{"$f":"'(9)Lease C Tenant'!L24","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=9,9,0)","v":0},{"$f":"'Occupancy Costs'!M24","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=9,9,0)","v":0},{"$f":"'(6)Lease B Tenant'!M24","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=9,9,0)","v":0},{"$f":"'(9)Lease C Tenant'!M24","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=10,10,0)","v":0},{"$f":"'Occupancy Costs'!N24","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=10,10,0)","v":0},{"$f":"'(6)Lease B Tenant'!N24","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=10,10,0)","v":0},{"$f":"'(9)Lease C Tenant'!N24","v":0}]
[]
[null,"Total Effective Rent",null,null,null,{"$f":"SUM(F6:F16)","v":0},null,null,{"$f":"SUM(I6:I16)","v":0},null,null,{"$f":"SUM(L6:L16)","v":0}]
[null,"Total Effective Rate",null,null,null,{"$f":"IF('Lease Input'!D5=0,0,F18/'Lease Input'!D5)","v":0},null,null,{"$f":"IF('(5)Lease B Input'!D5=0,0,I18/'(5)Lease B Input'!D5)","v":0},null,null,{"$f":"IF('(8)Lease C Input'!D5=0,0,L18/'(8)Lease C Input'!D5)","v":0}]
[null,"Average Annual Effective Rent",null,null,null,{"$f":"IF('Lease Input'!D4=0,0,F18/'Lease Input'!D4)","v":0},null,null,{"$f":"IF('(5)Lease B Input'!D4=0,0,I18/'(5)Lease B Input'!D4)","v":0},null,null,{"$f":"IF('(8)Lease C Input'!D4=0,0,L18/'(8)Lease C Input'!D4)","v":0}]
[null,"Average Annual Effective Rate",null,null,null,{"$f":"IF('Lease Input'!D5=0,0,F20/'Lease Input'!D5)","v":0},null,null,{"$f":"IF('(5)Lease B Input'!D5=0,0,I20/'(5)Lease B Input'!D5)","v":0},null,null,{"$f":"IF('(8)Lease C Input'!D5=0,0,L20/'(8)Lease C Input'!D5)","v":0}]
[null,"Discounted Effective Rent @",null,null,{"$f":"'Lease Input'!D33","v":0},{"$f":"NPV(E22,F7:F16)+F6","v":0},null,{"$f":"'(5)Lease B Input'!D33","v":0},{"$f":"NPV(H22,I7:I16)+I6","v":0},null,{"$f":"'(8)Lease C Input'!D33","v":0},{"$f":"NPV(K22,L7:L16)+L6","v":0}]
[null,"Owner"]
[null,null,null,null,"Lease A",null,null,"Lease B",null,null,"Lease C"]
[null,null,null,null,"EOY","$",null,"EOY","$",null,"EOY","$"]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>0,\"O\",0)","v":0},{"$f":"'(4)Lease A Owner'!D21","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>0,\"O\",0)","v":0},{"$f":"'(7)Lease B Owner'!D21","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>0,\"O\",0)","v":0},{"$f":"'(10)Lease C Owner'!D21","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=1,1,0)","v":0},{"$f":"'(4)Lease A Owner'!E21","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=1,1,0)","v":0},{"$f":"'(7)Lease B Owner'!E21","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=1,1,0)","v":0},{"$f":"'(10)Lease C Owner'!E21","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=2,2,0)","v":0},{"$f":"'(4)Lease A Owner'!F21","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=2,2,0)","v":0},{"$f":"'(7)Lease B Owner'!F21","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=2,2,0)","v":0},{"$f":"'(10)Lease C Owner'!F21","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=3,3,0)","v":0},{"$f":"'(4)Lease A Owner'!G21","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=3,3,0)","v":0},{"$f":"'(7)Lease B Owner'!G21","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=3,3,0)","v":0},{"$f":"'(10)Lease C Owner'!G21","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=4,4,0)","v":0},{"$f":"'(4)Lease A Owner'!H21","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=4,4,0)","v":0},{"$f":"'(7)Lease B Owner'!H21","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=4,4,0)","v":0},{"$f":"'(10)Lease C Owner'!H21","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=5,5,0)","v":0},{"$f":"'(4)Lease A Owner'!I21","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=5,5,0)","v":0},{"$f":"'(7)Lease B Owner'!I21","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=5,5,0)","v":0},{"$f":"'(10)Lease C Owner'!I21","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=6,6,0)","v":0},{"$f":"'(4)Lease A Owner'!J21","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=6,6,0)","v":0},{"$f":"'(7)Lease B Owner'!J21","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=6,6,0)","v":0},{"$f":"'(10)Lease C Owner'!J21","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=7,7,0)","v":0},{"$f":"'(4)Lease A Owner'!K21","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=7,7,0)","v":0},{"$f":"'(7)Lease B Owner'!K21","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=7,7,0)","v":0},{"$f":"'(10)Lease C Owner'!K21","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=8,8,0)","v":0},{"$f":"'(4)Lease A Owner'!L21","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=8,8,0)","v":0},{"$f":"'(7)Lease B Owner'!L21","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=8,8,0)","v":0},{"$f":"'(10)Lease C Owner'!L21","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=9,9,0)","v":0},{"$f":"'(4)Lease A Owner'!M21","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=9,9,0)","v":0},{"$f":"'(7)Lease B Owner'!M21","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=9,9,0)","v":0},{"$f":"'(10)Lease C Owner'!M21","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=10,10,0)","v":0},{"$f":"'(4)Lease A Owner'!N21","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=10,10,0)","v":0},{"$f":"'(7)Lease B Owner'!N21","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=10,10,0)","v":0},{"$f":"'(10)Lease C Owner'!N21","v":0}]
[]
[null,"Incremental Lease Value @",null,null,{"$f":"'Lease Input'!D38","v":0},{"$f":"NPV(E38,F27:F36)+F26","v":0},null,{"$f":"'(5)Lease B Input'!D38","v":0},{"$f":"NPV(H38,I27:I36)+I26","v":0},null,{"$f":"'(8)Lease C Input'!D38","v":0},{"$f":"NPV(K38,L27:L36)+L26","v":0}]

{"sheet":"(12)After Tax Summary","index":12,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":true,"merged":[[37,1,37,3],[1,1,1,6],[17,1,17,3],[18,1,18,3],[19,1,19,3],[2,1,2,12],[22,1,22,12],[3,4,3,5],[3,7,3,8],[3,10,3,11],[23,4,23,5],[23,7,23,8],[21,1,21,3],[20,1,20,3],[23,10,23,11]]}
[]
[null,"After Tax Summary"]
[null,"Tenant"]
[null,null,null,null,"Lease A",null,null,"Lease B",null,null,"Lease C"]
[null,null,null,null,"EOY","$",null,"EOY","$",null,"EOY","$"]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>0,\"O\",0)","v":0},{"$f":"'Occupancy Costs'!D29","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>0,\"O\",0)","v":0},{"$f":"'(6)Lease B Tenant'!D29","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>0,\"O\",0)","v":0},{"$f":"'(9)Lease C Tenant'!D29","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=1,1,0)","v":0},{"$f":"'Occupancy Costs'!E29","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=1,1,0)","v":0},{"$f":"'(6)Lease B Tenant'!E29","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=1,1,0)","v":0},{"$f":"'(9)Lease C Tenant'!E29","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=2,2,0)","v":0},{"$f":"'Occupancy Costs'!F29","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=2,2,0)","v":0},{"$f":"'(6)Lease B Tenant'!F29","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=2,2,0)","v":0},{"$f":"'(9)Lease C Tenant'!F29","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=3,3,0)","v":0},{"$f":"'Occupancy Costs'!G29","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=3,3,0)","v":0},{"$f":"'(6)Lease B Tenant'!G29","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=3,3,0)","v":0},{"$f":"'(9)Lease C Tenant'!G29","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=4,4,0)","v":0},{"$f":"'Occupancy Costs'!H29","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=4,4,0)","v":0},{"$f":"'(6)Lease B Tenant'!H29","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=4,4,0)","v":0},{"$f":"'(9)Lease C Tenant'!H29","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=5,5,0)","v":0},{"$f":"'Occupancy Costs'!I29","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=5,5,0)","v":0},{"$f":"'(6)Lease B Tenant'!I29","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=5,5,0)","v":0},{"$f":"'(9)Lease C Tenant'!I29","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=6,6,0)","v":0},{"$f":"'Occupancy Costs'!J29","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=6,6,0)","v":0},{"$f":"'(6)Lease B Tenant'!J29","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=6,6,0)","v":0},{"$f":"'(9)Lease C Tenant'!J29","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=7,7,0)","v":0},{"$f":"'Occupancy Costs'!K29","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=7,7,0)","v":0},{"$f":"'(6)Lease B Tenant'!K29","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=7,7,0)","v":0},{"$f":"'(9)Lease C Tenant'!K29","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=8,8,0)","v":0},{"$f":"'Occupancy Costs'!L29","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=8,8,0)","v":0},{"$f":"'(6)Lease B Tenant'!L29","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=8,8,0)","v":0},{"$f":"'(9)Lease C Tenant'!L29","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=9,9,0)","v":0},{"$f":"'Occupancy Costs'!M29","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=9,9,0)","v":0},{"$f":"'(6)Lease B Tenant'!M29","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=9,9,0)","v":0},{"$f":"'(9)Lease C Tenant'!M29","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=10,10,0)","v":0},{"$f":"'Occupancy Costs'!N29","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=10,10,0)","v":0},{"$f":"'(6)Lease B Tenant'!N29","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=10,10,0)","v":0},{"$f":"'(9)Lease C Tenant'!N29","v":0}]
[]
[null,"Total Effective Rent",null,null,null,{"$f":"SUM(F6:F16)","v":0},null,null,{"$f":"SUM(I6:I16)","v":0},null,null,{"$f":"SUM(L6:L16)","v":0}]
[null,"Total Effective Rate",null,null,null,{"$f":"IF('Lease Input'!D5=0,0,F18/'Lease Input'!D5)","v":0},null,null,{"$f":"IF('(5)Lease B Input'!D5=0,0,I18/'(5)Lease B Input'!D5)","v":0},null,null,{"$f":"IF('(8)Lease C Input'!D5=0,0,L18/'(8)Lease C Input'!D5)","v":0}]
[null,"Average Annual Effective Rent",null,null,null,{"$f":"IF('Lease Input'!D4=0,0,F18/'Lease Input'!D4)","v":0},null,null,{"$f":"IF('(5)Lease B Input'!D4=0,0,I18/'(5)Lease B Input'!D4)","v":0},null,null,{"$f":"IF('(8)Lease C Input'!D4=0,0,L18/'(8)Lease C Input'!D4)","v":0}]
[null,"Average Annual Effective Rate",null,null,null,{"$f":"IF('Lease Input'!D5=0,0,F20/'Lease Input'!D5)","v":0},null,null,{"$f":"IF('(5)Lease B Input'!D5=0,0,I20/'(5)Lease B Input'!D5)","v":0},null,null,{"$f":"IF('(8)Lease C Input'!D5=0,0,L20/'(8)Lease C Input'!D5)","v":0}]
[null,"Discounted Effective Rent @",null,null,{"$f":"'Lease Input'!E33","v":0},{"$f":"NPV(E22,F7:F16)+F6","v":0},null,{"$f":"'(5)Lease B Input'!E33","v":0},{"$f":"NPV(H22,I7:I16)+I6","v":0},null,{"$f":"'(8)Lease C Input'!E33","v":0},{"$f":"NPV(K22,L7:L16)+L6","v":0}]
[null,"Owner"]
[null,null,null,null,"Lease A",null,null,"Lease B",null,null,"Lease C"]
[null,null,null,null,"EOY","$",null,"EOY","$",null,"EOY","$"]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>0,\"O\",0)","v":0},{"$f":"'(4)Lease A Owner'!D27","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>0,\"O\",0)","v":0},{"$f":"'(7)Lease B Owner'!D27","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>0,\"O\",0)","v":0},{"$f":"'(10)Lease C Owner'!D27","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=1,1,0)","v":0},{"$f":"'(4)Lease A Owner'!E27","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=1,1,0)","v":0},{"$f":"'(7)Lease B Owner'!E27","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=1,1,0)","v":0},{"$f":"'(10)Lease C Owner'!E27","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=2,2,0)","v":0},{"$f":"'(4)Lease A Owner'!F27","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=2,2,0)","v":0},{"$f":"'(7)Lease B Owner'!F27","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=2,2,0)","v":0},{"$f":"'(10)Lease C Owner'!F27","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=3,3,0)","v":0},{"$f":"'(4)Lease A Owner'!G27","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=3,3,0)","v":0},{"$f":"'(7)Lease B Owner'!G27","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=3,3,0)","v":0},{"$f":"'(10)Lease C Owner'!G27","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=4,4,0)","v":0},{"$f":"'(4)Lease A Owner'!H27","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=4,4,0)","v":0},{"$f":"'(7)Lease B Owner'!H27","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=4,4,0)","v":0},{"$f":"'(10)Lease C Owner'!H27","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=5,5,0)","v":0},{"$f":"'(4)Lease A Owner'!I27","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=5,5,0)","v":0},{"$f":"'(7)Lease B Owner'!I27","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=5,5,0)","v":0},{"$f":"'(10)Lease C Owner'!I27","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=6,6,0)","v":0},{"$f":"'(4)Lease A Owner'!J27","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=6,6,0)","v":0},{"$f":"'(7)Lease B Owner'!J27","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=6,6,0)","v":0},{"$f":"'(10)Lease C Owner'!J27","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=7,7,0)","v":0},{"$f":"'(4)Lease A Owner'!K27","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=7,7,0)","v":0},{"$f":"'(7)Lease B Owner'!K27","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=7,7,0)","v":0},{"$f":"'(10)Lease C Owner'!K27","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=8,8,0)","v":0},{"$f":"'(4)Lease A Owner'!L27","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=8,8,0)","v":0},{"$f":"'(7)Lease B Owner'!L27","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=8,8,0)","v":0},{"$f":"'(10)Lease C Owner'!L27","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=9,9,0)","v":0},{"$f":"'(4)Lease A Owner'!M27","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=9,9,0)","v":0},{"$f":"'(7)Lease B Owner'!M27","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=9,9,0)","v":0},{"$f":"'(10)Lease C Owner'!M27","v":0}]
[null,null,null,null,{"$f":"IF('Lease Input'!$D$4>=10,10,0)","v":0},{"$f":"'(4)Lease A Owner'!N27","v":0},null,{"$f":"IF('(5)Lease B Input'!$D$4>=10,10,0)","v":0},{"$f":"'(7)Lease B Owner'!N27","v":0},null,{"$f":"IF('(8)Lease C Input'!$D$4>=10,10,0)","v":0},{"$f":"'(10)Lease C Owner'!N27","v":0}]
[]
[null,"Incremental Lease Value @",null,null,{"$f":"'Lease Input'!E38","v":0},{"$f":"NPV(E38,F27:F36)+F26","v":0},null,{"$f":"'(5)Lease B Input'!E38","v":0},{"$f":"NPV(H38,I27:I36)+I26","v":0},null,{"$f":"'(8)Lease C Input'!E38","v":0},{"$f":"NPV(K38,L27:L36)+L26","v":0}]