{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Recon & Budget Change TEMPLATE","RE Tax ONLY","CAP Information","Base Year Information"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":8,"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":"Recon & Budget Change TEMPLATE","index":0,"n_rows":69,"n_cols":7,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,1],[68,0,72,1],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2]]}
[{"$f":"CONCATENATE(F12,\" Operating Expense Reconcilation\")","v":"2017 Operating Expense Reconcilation"},null,"Fill out the top portion - middle section is for Reconciliation - bottom chart is for Escrow Adjust"]
[]
["Bill Date:",{"$f":"TODAY()","v":"2018-09-11"},null,null,"Total Sq Ft:",null,"Enter Total Property SF"]
["DAVITA Facility Number ",null,"(if known)",null,"DaVita Sq Ft:",null,"Enter Davita SF"]
["Premises Address:",null,null,null,"Prorata Share:",{"$f":"F4/F3","v":{"$error":"#DIV/0!"}},"Auto Calculates"]
["Premises City, State:",null,null,null,"Sales Tax",0,"Leave blank if n/a"]
["Center Name:",null,null,null,"Cap %:",0,"*See your Lease - Leave blank if n/a"]
["Landlord Name:",null,null,null,"Base Year:",null,"*See your Lease - Leave blank if n/a"]
["Landlord Address:",null,null,null,"Lease Comm Date:",null,"May be applicable if 1st or 2nd year"]
["Landlord Email Address:",null,null,null,"Days Occupied",365,"enter if less than 365 other leave"]
["Landlord Phone Number: ",null,null,null,"Occupied/Days Yr",{"$f":"F10/365","v":1},"will auto calculate based on 365 days"]
["Service Period:","2017-01-01","2017-12-31",null,"CAM Year:",2017]
[]
["Notes:"]
["Add any notes that would clarify charges or changes etc."]
["*If you have questions on how to calculate a Cap see \"CAP Information\" tab or please email leaseadmin@davita.com and someone will respond."]
["*If you have questions on how to calculate a Base Year see \"Base Year Information\" tab or please email leaseadmin@davita.com and someone will respond."]
[]
[]
["EXPENSES","Current Year","Prior Year","will auto populate from above"]
["ACCOUNT NAME","CHARGED TO CAM (Per LL)","Final CAM Per Lease Review","DaVita %","DaVita's Share"]
["CAM Controllable Expenses (controllable/non-controllable breakdown is necessary if you have a cap*)"]
["Add account Name","Add Actual Expense",null,{"$f":"Prorata_Share","v":{"$error":"#DIV/0!"}},{"$f":"B23*D23","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$error":"#DIV/0!"},{"$f":"B24*D24","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Total Controllable - Actual CAM",{"$f":"SUM(B23:B33)","v":0},{"$f":"SUM(C23:C33)","v":0},null,{"$f":"SUM(E23:E33)","v":{"$error":"#VALUE!"}}]
["Total Controllable - CAP","Add first year then calculate % Across",null,null,{"$f":"B35*Prorata_Share","v":{"$error":"#VALUE!"}},"Add CAP over prior year if applicable or \"n/a\""]
["Lessor of Actual or CAP",{"$f":"IF(F7>0, MIN(B34,B35),B34)","v":0},{"$f":"IF(G7>0, MIN(C34,C35),C34)","v":0},null,{"$f":"IF(F7>0, MIN(E34,E35),E34)","v":{"$error":"#VALUE!"}}]
[]
["CAM Non-controllable Expenses"]
[null,null,null,{"$f":"$F$5","v":{"$error":"#DIV/0!"}},{"$f":"B39*D39","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Total Uncontrollable ",{"$f":"SUM(B39:B46)","v":0},{"$f":"SUM(C39:C46)","v":0},null,{"$f":"SUM(E39:E46)","v":{"$error":"#DIV/0!"}}]
[]
["CAM Total ",{"$f":"B36+B47","v":0},{"$f":"C36+C47","v":0},null,{"$f":"+E47+E36","v":{"$error":"#DIV/0!"}}]
[]
["Property  Taxes",null,null,{"$f":"F5","v":{"$error":"#DIV/0!"}},{"$f":"B51*D51","v":{"$error":"#DIV/0!"}}]
["Insurance",null,null,{"$f":"F5","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
[]
["Total Operating Expenses",{"$f":"SUM(B49:B52)","v":0},{"$f":"SUM(C49:C52)","v":0},"Total",{"$f":"SUM(E49:E52)","v":{"$error":"#DIV/0!"}},"Will auto calculate when you've entered expenses"]
[null,null,"Amount Escrows Davita Paid",null,0,"Enter Amt Billed to/Paid by Davita (this will be the total of the monthly escrows paid by Tenant throughout the prior year)"]
[null,null,"Total DUE/CREDIT",null,{"$f":"E55-E56","v":{"$error":"#DIV/0!"}},"Will auto calculate when you've entered billed amount"]
[]
[]
["BUDGET FOR THE COMING YEAR"]
["CHANGE TO MONTHLY ESCROWS (if applicable)",null,"Effective Date","2019-01-01","Example Jan-Mar = 3"]
["Description","NEW ESCROW","OLD ESCROW","DIFF","# OF ADJ MONTHS","ADJUSTMENT DUE"]
["CAM 2019 Budget",null,null,{"$f":"B63-C63","v":0},0,{"$f":"E63*D63","v":0},"Enter new monthly Escrow, effective date and if billing after effective date enter # of months to adjust"]
["RE Taxes 2019 Budget",null,null,{"$f":"B64-C64","v":0},0,{"$f":"E64*D64","v":0}]
["Insurance 2019 Budget",null,null,0,0,0]
["Total",{"$f":"SUM(B63:B65)","v":0},{"$f":"SUM(C63:C65)","v":0},{"$f":"SUM(D63:D65)","v":0},null,{"$f":"SUM(F63:F65)","v":0}]
[]
["Notes"]
["Landlord please attach copies of the RE Tax bills, Insurance bills, any Tenant Specific bills and breakdown the expenses by category: i.e. Landscaping, Janitorial, Elevator R&M, Electric R&M, Parking lot etc."]

{"sheet":"RE Tax ONLY","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[9,1,9,2],[10,1,10,2],[32,0,36,1],[0,0,0,1],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2]]}
[{"$f":"CONCATENATE(F12,\" RE Tax Expense Reconcilation\")","v":"2017 RE Tax Expense Reconcilation"},null,"Fill out the top portion for either "]
[]
["Bill Date:",{"$f":"TODAY()","v":"2018-09-11"},null,null,"Total Sq Ft:",null,"Enter Total Property SF"]
["DAVITA Facility Number ",null,"(if known)",null,"DaVita Sq Ft:",null,"Enter Davita SF"]
["Premises Address:",null,null,null,"Prorata Share:",{"$f":"F4/F3","v":{"$error":"#DIV/0!"}},"Auto Calculates"]
["Premises City, State:",null,null,null,"Sales Tax",0,"Leave blank if n/a"]
["Center Name:",null,null,null,"Cap %:",0,"*See your Lease - Leave blank if n/a"]
["Landlord Name:",null,null,null,"Base Year:",null,"*See your Lease - Leave blank if n/a"]
["Landlord Address:",null,null,null,"Lease Comm Date:",null,"May be applicable if 1st or 2nd year"]
["Landlord Email Address:",null,null,null,"Days Occupied",365,"enter if less than 365 other leave"]
["Landlord Phone Number: ",null,null,null,"Occupied/Days Yr",{"$f":"F10/365","v":1},"will auto calculate based on 365 days"]
["Service Period:","2017-01-01","2017-12-31",null,"CAM Year:",2017]
[]
["Notes:"]
["Add any notes that would clarify charges or changes etc."]
["*If you have questions on how to calculate a Cap or Base year - please email leaseadmin@davita.com and someone will respond."]
[]
[]
["EXPENSES","Current Year","Prior Year","will auto populate from above"]
["ACCOUNT NAME","CHARGED TO CAM (Per LL)","Final CAM Per Lease Review","DaVita %","DaVita's Share"]
[]
["Property  Taxes",0,null,{"$f":"F5","v":{"$error":"#DIV/0!"}},{"$f":"B22*D22","v":{"$error":"#DIV/0!"}}]
[null,null,"Amount Escrows Davita Paid",null,0,"Enter Amt Billed to/Paid by Davita "]
[null,null,"Total DUE/CREDIT",null,{"$f":"#REF!-E23","v":{"$error":"#REF!"}},"Will auto calculate when you've entered billed amount"]
[]
["BUDGET FOR THE COMING YEAR"]
["CHANGE TO MONTHLY ESCROWS (if applicable)",null,"Effective Date","2019-01-01","Example Jan-Mar = 3"]
["Description","NEW ESCROW","OLD ESCROW","DIFF","# OF ADJ MONTHS","ADJUSTMENT DUE"]
["RE Taxes 2019 Budget",null,null,{"$f":"B29-C29","v":0},0,{"$f":"E29*D29","v":0},"Enter new monthly Escrow, effective date and if billing after effective date enter # of months to adjust"]
["Totals",{"$f":"SUM(B29:B29)","v":0},{"$f":"SUM(C29:C29)","v":0},{"$f":"SUM(D29:D29)","v":0},null,{"$f":"SUM(F29:F29)","v":0}]
[]
["Notes"]
["Attach copies of the actual RE Tax bills - reminder Tenant is not liable for interest or late fees due to late payment by Landlord."]

{"sheet":"CAP Information","index":2,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[24,1,24,11],[1,1,1,11],[2,1,2,11],[4,1,4,11],[5,1,5,11],[3,1,3,11]]}
[null,"Hints on % CAPs"]
["1)","Check your Lease to see if there is a CAP on Operating Expenses."]
["2)","If you have a CAP on \"Operating Expenses\" - please check how your Lease defines \"Operating Expenses\".  It is common for Operating Expenses to include CAM, Insurance and RE Taxes, but check  your specific Lease."]
["3)","If you are in the 1st partial year or 1st full calendar year there may be a $/PSF CAP on all Operating Expenses.  This will likely be separate from the % CAP applicable thereafter.  Check your Lease language."]
["4)","If you have a CAP on \"Controllable Expenses\" there is usually a list of items that are excluded from this % CAP, those are your \"Uncontrollable Expenses\", usually RE Taxes, Insurance and Utilities, but check your Lease."]
["5) ","A \"non-cumulative\" % CAP means that there is a CAP on expenses over the expenses paid in the prior year.  It is based off of the lesser of actual or CAP paid in the prior year.  EXAMPLE:  3% cap on prior Controllable Expenses, excluding Tax, Insurance and Utilities  - assume 2015 is the 1st full calendar year, and in this example our share is 100%.  See example calculation below:"]
[null,"EXPENSES",null,null,2018,2017,2016,2015]
[null,"Controllable Charges"]
[null,"R&M Electrical",null,null,400,250,100,250]
[null,"R&M Parking Lot Sweeping",null,null,100,100,50,100]
[null,"Pest Control",null,null,50,50,100,50]
[null,"R&M HVAC",null,null,75,100,200,200]
[null,null,null,"Actuals",{"$f":"SUM(E9:E12)","v":625},500,450,{"$f":"SUM(H9:H12)","v":600}]
[null,null,null,"3% CAP",{"$f":"F15*103%","v":477.40500000000003},{"$f":"G15*103%","v":463.5},{"$f":"H15*103%","v":618},{"$f":"H13","v":600}]
[null,null,null,"(<  of Actual or CAP) Control Total Allowed",{"$f":"IF(E14<E13,E14,E13)","v":477.40500000000003},463.5,450,{"$f":"IF(H14<H13,H14,H13)","v":600}]
[null,"Uncontrollable"]
[null,"Water & Sewer",null,null,2000,1500,1000,1250]
[null,"Electricity",null,null,5000,4000,3000,2000]
[null,"RE Taxes",null,null,10000,9000,8000,7000]
[null,"Insurance",null,null,500,450,425,400]
[null,"Uncontrollable TOTAL",null,null,{"$f":"SUM(E17:E20)","v":17500},{"$f":"SUM(F17:F20)","v":14950},12425,10650]
[]
[null,"TOTAL Opex Allowed",null,null,{"$f":"SUM(E21,E15)","v":17977.404999999999},{"$f":"SUM(F21,F15)","v":15413.5},12875,11250,"Total controllable & Uncontrollable"]
[]
["6) ","A \"cumulative\" % CAP means that there is a CAP on expenses starting after the 1st full calendar year and increasing % over the cap year to year.  It does not change based on the actual expenses.  EXAMPLE:  3% cap cumulative cap Controllable Expenses, excluding Tax, Insurance and Utilities  - assume 2015 is the 1st full calendar year, and in this example our share is 100%.  See example calculation below:"]
[null,"EXPENSES",null,null,2018,2017,2016,2015]
[null,"Controllable Charges"]
[null,"R&M Electrical",null,null,400,250,100,250]
[null,"R&M Parking Lot Sweeping",null,null,100,100,50,100]
[null,"Pest Control",null,null,50,50,100,50]
[null,"R&M HVAC",null,null,75,100,200,200]
[null,null,null,"Actuals",{"$f":"SUM(E28:E31)","v":625},{"$f":"SUM(F28:F31)","v":500},{"$f":"SUM(G28:G31)","v":450},{"$f":"SUM(H28:H31)","v":600}]
[null,null,null,"3% CAP",{"$f":"F33*103%","v":655.63620000000003},636.54,{"$f":"H33*103%","v":618},{"$f":"H32","v":600}]
[null,null,null,"(<  of Actual or CAP) Control Total Allowed",{"$f":"IF(E33<E32,E33,E32)","v":625},{"$f":"IF(F33<F32,F33,F32)","v":500},{"$f":"IF(G33<G32,G33,G32)","v":450},{"$f":"IF(H33<H32,H33,H32)","v":600}]

{"sheet":"Base Year Information","index":3,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,11],[2,1,2,11],[3,1,3,11],[4,1,4,11],[5,1,5,11]]}
[null,"Hints on Base Years"]
["1)","Check your Lease to see if there is a Base Year on Operating Expenses.  Usually the Language will require Tenant to pay its Proportionate Share of all expenses that \"exceed\" the Base Year.  If not specifically defined in your Lease it usually refers to the first full calendar year of expenses.  The Base Year concept includes a specific estimated amount directly into the calculation of the Base Rent so anything below the Base Year is assumed to already be included in Base Rent.  Therefore, usually the last full year of expenses prior to the Execution of the Lease is designated as the Base Year if it is an established property."]
["2)","If your Lease has a Base Year it will also define what is included under the Base Year.  Sometimes only the RE Taxes are included, sometimes all Operating Expenses, or sometimes just CAM expenses.  Check your Lease for specific language."]
["3)","If the billing is for the designated \"Base Year\" your billing should be $0 because it is all assumed to be part of the Base Year."]
["4)","If the billing is for the 1st partial year, based on a prior year Base year you should prorate both the actual expenses for the partial year and the Base Year proportionately."]
["5) ","See the example below:  Assume the Base Year is 2015.  The Base Year includes all \"Operating Expenses\" defined as CAM, Insurance and RE Taxes and the Prorata Share (PRS) is 100%"]
[null,"EXPENSES",null,null,2018,2017,2016,2015]
[null,"R&M Electrical",null,null,400,250,100,250]
[null,"R&M Parking Lot Sweeping",null,null,100,100,50,100]
[null,"Pest Control",null,null,50,50,100,50]
[null,"R&M HVAC",null,null,75,100,200,200]
[null,"Water & Sewer",null,null,2000,1500,1000,1250]
[null,"Electricity",null,null,5000,4000,3000,2000]
[null,"RE Taxes",null,null,10000,9000,8000,7000]
[null,"Insurance",null,null,500,450,425,400]
[null,"Operating Expense TOTAL",null,null,{"$f":"SUM(E12:E15)","v":17500},{"$f":"SUM(F12:F15)","v":14950},12425,10650]
[null,"Base Year TOTAL",null,null,10650,10650,10650,10650]
[null,"TOTAL Billable OpEx",null,null,{"$f":"E16-E17","v":6850},4300,1775,{"$f":"H16-H17","v":0}]