{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Reconciliation Template","Instructions"],"not_rendered":{"charts":0,"images":9,"macros":0,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Reconciliation Template","index":0,"n_rows":72,"n_cols":4,"rows_kept":72,"cut":false,"hidden":false,"merged":[[15,1,15,3],[33,0,33,2],[46,0,46,2],[71,0,78,3]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
["Date"," ","     Store #",0]
["Reconciliation Year"," ","     Premises Sq. Ft.",0]
["Number of days in period"," ","     Pro-Rata Share",0]
["Calculated by"," ","     Management Fee %   ",0]
[]
["Operating Expense Cap Calculation"," "," "]
["Prior Year Operating Expense  Payable by Tenant",0,"     Annual Cap  % in Lease",0]
["Allowable CAM CAP",0,"     CAM CAP = Prior Yr CAM Exp (x) Cap % + Management Fee"]
[" ","  "]
[" "," "]
[null,"Annual Expense","Tenant's Pro-Rata Share","Tenant's Pro-Rata Share of Expense"]
["Annual Operating Expenses"," "," "]
["   Total Operating Expenses"]
["        HVAC",0,0,0]
["        Security",0,0,0]
["        Repair & Maintenance",0,0,0]
["        Janitorial",0,0,0]
["        Parking Lot",0,0,0]
["        Water",0,0,0]
["        Trash (if defined as an Operating Expense)",0,0,0]
["        Electricity",0,0,0]
["        Gas",0,0,0]
["        Snow",0,0,0]
["        Other ",0,0,0]
["          Sub Total Operating Expenses",0,null,0]
["        Management Fee",null,0,0]
["Less Operating Expenses Not-capped (CNC)",null,null,0]
["Total Operating Expenses Capped (CAM):  \n Please refer To The Operating Expense Section Of Your Lease For Allowable Exclusions ",null,null,0]
["   Operating Expenses Not-capped  (CNC)",null," "," "]
["        Exp:",0,0,0]
["        Exp:",0,0,0]
["        Exp:",0,0,0]
["Total Operating  Expenses Not-capped (CNC)",0,null,0]
[null,null," "," "]
["Other Expense  ",0,0,0]
["Other Expense  ",0,0,0]
["Other Expense  ",0,0,0]
["Insurance",0,0,0]
["Real Estate Tax",0,0,0]
[]
[" Total Annual Additional Rent",null,null,0]
[]
["ACCOUNT RECONCILIATION"," "]
["Total Capped Operating Expenses"," ",0,"Includes Admin/ Management Fee"]
["HIDDEN ROW",null,0,"Includes Admin/ Management Fee"]
["     ALLOWABLE CAPPED OPERATING EXPENSE ",null,0,"Includes Admin/ Management Fee"]
["Total Operating Expenses Not-capped (CNC)",null,0]
["Other Expense  ",null,0]
["Other Expense  ",null,0]
["Other Expense  ",null,0]
["Insurance",null,0]
["Taxes",null,0]
["Total Annual Additional Rent Due",null,0]
[]
["Annual Escrows Paid by Starbucks"," "," ","Account Adjustments "]
["     Operating Expenses (CAM)",null,0,0]
["     Operating Expenses Not-Capped (CNC)",null,0,0]
["     Other   ",null,0,0]
["     Other",null,0,0]
["     Other",null,0,0]
["     Insurance",null,0,0]
["     Real Estate Taxes",null,0,0]
["TOTAL ESCROWS PAID",null,0,0]
[]
["Starbucks Payment/(Credit)  ",null,0]
["COMMENTS: "]

{"sheet":"Instructions","index":1,"n_rows":72,"n_cols":6,"rows_kept":72,"cut":false,"hidden":false,"merged":[[15,3,15,5],[46,2,46,4],[71,2,78,5],[33,2,33,4]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[null,null,"Date"," ","     Store #",0]
[null,null,"Reconciliation Year"," ","     Premises Sq. Ft.",0]
[null,null,"Number of days in period"," ","     Pro-Rata Share",0]
[null,null,"Calculated by"," ","     Management Fee %   ",0]
[]
[null,null,"Operating Expense Cap Calculation"," "," "]
[null,null,"Prior Year Operating Expense  Payable by Tenant",0,"     Annual Cap  % in Lease",0]
[null,null,"Allowable CAM CAP",0,"     CAM CAP = Prior Yr CAM Exp (x) Cap % + Management Fee"]
[null,null," ","  "]
[null,null," "," "]
[null,null,null,"Annual Expense","Tenant's Pro-Rata Share","Tenant's Pro-Rata Share of Expense"]
[null,null,"Annual Operating Expenses"," "," "]
[null,null,"   Total Operating Expenses"]
[null,null,"        HVAC",0,0,0]
[null,null,"        Security",0,0,0]
[null,null,"        Repair & Maintenance",0,0,0]
[null,null,"        Janitorial",0,0,0]
[null,null,"        Parking Lot",0,0,0]
[null,null,"        Water",0,0,0]
[null,null,"        Trash (if defined as an Operating Expense)",0,0,0]
[null,null,"        Electricity",0,0,0]
[null,null,"        Gas",0,0,0]
[null,null,"        Snow",0,0,0]
[null,null,"        Other ",0,0,0]
[null,null,"          Sub Total Operating Expenses",0,null,0]
[null,null,"        Management Fee",null,0,0]
[null,null,"Less Operating Expenses Not-capped (CNC)",null,null,0]
[null,null,"Total Operating Expenses Capped (CAM):  \n Please refer To The Operating Expense Section Of Your Lease For Allowable Exclusions ",null,null,0]
[null,null,"   Operating Expenses Not-capped  (CNC)",null," "," "]
[null,null,"        Exp: ______________________________",0,0,0]
[null,null,"        Exp: ______________________________",0,0,0]
[null,null,"        Exp: ______________________________",0,0,0]
[null,null,"Total Operating  Expenses Not-capped (CNC)",0,null,0]
[{"$nulls":4}," "," "]
[null,null,"Other Expense  ",0,0,0]
[null,null,"Other Expense  ",0,0,0]
[null,null,"Other Expense  ",0,0,0]
[null,null,"Insurance",0,0,0]
[null,null,"Real Estate Tax",0,0,0]
[]
[null,null," Total Annual Additional Rent",null,null,0]
[]
[null,null,"ACCOUNT RECONCILIATION"," "]
[null,null,"Total Capped Operating Expenses"," ",0,"Includes Admin/ Management Fee"]
[null,null,"HIDDEN ROW",null,0,"Includes Admin/ Management Fee"]
[null,null,"     ALLOWABLE CAPPED OPERATING EXPENSE ",null,0,"Includes Admin/ Management Fee"]
[null,null,"Total Operating Expenses Not-capped (CNC)",null,0]
[null,null,"Other Expense  ",null,0]
[null,null,"Other Expense  ",null,0]
[null,null,"Other Expense  ",null,0]
[null,null,"Insurance",null,0]
[null,null,"Taxes",null,0]
[null,null,"Total Annual Additional Rent Due",null,0]
[]
[null,null,"Annual Escrows Paid by Starbucks"," "," ","Account Adjustments "]
[null,null,"     Operating Expenses (CAM)",null,0,0]
[null,null,"     Operating Expenses Not-Capped (CNC)",null,0,0]
[null,null,"     Other   ",null,0,0]
[null,null,"     Other",null,0,0]
[null,null,"     Other",null,0,0]
[null,null,"     Insurance",null,0,0]
[null,null,"     Real Estate Taxes",null,0,0]
[null,null,"TOTAL ESCROWS PAID",null,0,0]
[]
[null,null,"Starbucks Payment/(Credit)  ",null,0]
[null,null,"COMMENTS: "]