{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Summary Table","Property Elements","Cash Flow Analysis","Trust Balance Graph","PIE CHART","Table data for Summary","Sheet3"],"not_rendered":{"charts":3,"images":2,"macros":0,"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":"Summary Table","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Property Elements","index":1,"n_rows":140,"n_cols":66,"rows_kept":140,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Exhibit A, Property Capital Expenditures and Annual Expenditures Spreadsheet For: ",null,null,null,null,null,null,null,null,null,null,"Notes:"]
[null,null,null,null,"Subject Property",null,null,null,null,null,null,null,"1) R.U.L. is Remaining Useful Life"]
[null,null,null,null,"W147 S6960 Durham Drive",null,null,null,null,null,null,null,"2) The estimated future inflation rate for estimating future replacement costs is",null,null,null,null,null,null,2.5000000000000001E-2]
[null,null,null,null,"Muskego, Wisconsin 53150"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Repeat Formula Clear",null,{"$f":"FV($T$4,AU$9,0,$K6,1)*(-1)","v":0}]
[null,null,null,null,"Identification Number 0603002",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Repeat Formula Green",null,{"$f":"FV($T$4,AU$9,0,$K7,1)*(-1)","v":0}]
[null,"Property Inspected on",null,"September 1, 2006"]
[null,null,null,null,null,null,null,null,null,null,null,"R.U.L. =",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,{"$f":"SUM(AH9+1)","v":22},{"$f":"SUM(AI9+1)","v":23},24,25,26,27,28,29,{"$f":"SUM(AP9+1)","v":30}]
["WEB REF.","Reference Number","Quantities","Unit of Measure","Component Description","Condition","Estimated 1st Year of Replacement","Useful Life, Years","Remaining Life, Years","Unit Cost","Current Replacement Cost","Total Future Cost of Replacement",2006,{"$f":"SUM(M10 +1)","v":2007},2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,null,null,null,null,null,null,null,null,null,null,null,"WEB REF.","#","Quantities","Unit of Measure","Component Description","Condition","Estimated 1st Year of Replacement","Useful Life, Years","Remaining Life, Years","Unit Cost","Current Replacement Cost","Total Future Cost of Replacement"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A10","v":"WEB REF."}]
[null,null,null,null,"Building Exterior",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B10","v":"Reference Number"}]
[null,1,null,"Each","Chimney Liner and Cap",null,{"$f":"SUM(2006+I13)","v":2006},"to 10",null,750,{"$f":"SUM(C13*J13)","v":0},{"$f":"SUM(M13:AQ13)","v":0},{"$f":"IF(M$9=$I13,FV($T$4,M$9,0,$K13,1)*(-1),\"---\")","v":0},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AC$9=$I13,FV($T$4,AC$9,0,$K13,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---",null,null,null,null,null,null,null,null,null,{"$f":"C10","v":"Quantities"}]
[null,2,null,"Each","Entry and Storm Doors",null,2006,"to 40",null,550,0,0,0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",null,null,null,null,null,null,null,null,null,{"$f":"D10","v":"Unit of Measure"}]
[null,3,null,"Each","Garage Door Openers",null,2006,"to 15",null,350,0,0,0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",null,null,null,null,null,null,null,null,null,{"$f":"E10","v":"Component Description"}]
[null,4,null,"Each","Garage Doors",null,2006," to 40",null,785,0,0,0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",null,null,null,null,null,null,null,null,null,{"$f":"F10","v":"Condition"}]
[null,5,null,"Linear Feet","Gutters and Downspouts",null,2006,"to 30",null,6.75,0,0,0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",null,null,null,null,null,null,null,null,null,{"$f":"G10","v":"Estimated 1st Year of Replacement"}]
[null,6,null,"Squares","Roof, Asphalt Shingle",null,2006,"15 to 20",null,265,0,0,0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",null,null,null,null,null,null,null,null,null,{"$f":"H10","v":"Useful Life, Years"}]
[null,7,null,"Linear Feet","Sealants",null,{"$f":"SUM(2006+I19)","v":2006},"to 15",null,2,0,{"$f":"SUM(M19:AQ19)","v":0},0,{"$f":"IF(N$9=$I19,FV($T$4,N$9,0,$K19,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",null,null,null,null,null,null,null,null,null,{"$f":"I10","v":"Remaining Life, Years"}]
[null,8,null,"Square Feet","Siding/Soffit/Fascia, Aluminum",null,2006,"to 35",null,5,0,0,0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",null,null,null,null,null,null,null,null,null,{"$f":"J10","v":"Unit Cost"}]
[null,9,null,"Each","Window, Garage East Side",null,2006,"40 to 60",null,458,0,0,0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",null,null,null,null,null,null,null,null,null,{"$f":"K10","v":"Current Replacement Cost"}]
[null,10,null,"Each","Windows",null,2006,"40 to 60",null,458,0,0,0,"---","---","---",{"$f":"IF(Q$9=$I22,FV($T$4,Q$9,0,$K22,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",null,null,null,null,null,null,null,null,null,{"$f":"L10","v":"Total Future Cost of Replacement"}]
[null,{"$f":"SUM(B22+1)","v":11},null,null,null,null,2006,null,null,null,{"$f":"SUM(C23*J23)","v":0},0,0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"SUM(B23+1)","v":12},null,null,null,null,2006,null,null,null,{"$f":"SUM(C24*J24)","v":0},0,0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"SUM(B24+1)","v":13},null,null,null,null,{"$f":"SUM(2006+I25)","v":2006},null,null,null,{"$f":"SUM(C25*J25)","v":0},{"$f":"SUM(M25:AQ25)","v":0},0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"MAX(B13:B25)","v":13},null,null,"Building Interior"]
[null,{"$f":"SUM(B26+1)","v":14},1,"Allowance","Bathroom Update/Remodeling, 1st Floor",null,{"$f":"SUM(2006+I27)","v":2006},"to 30",null,4417,{"$f":"SUM(C27*J27)","v":4417},{"$f":"SUM(M27:AQ27)","v":4417},{"$f":"IF(M$9=$I27,FV($T$4,M$9,0,$K27,1)*(-1),\"---\")","v":4417},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AC$9=$I27,FV($T$4,AC$9,0,$K27,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,15,1,"Allowance","Bathroom Update/Remodeling, 2nd Floor",null,2006,"to 30",null,4212,4212,4212,4212,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,16,null,"Square Yards","Carpet, 1st Floor",null,2006,"to 15",null,41.22,0,0,0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,17,null,"Square Yards","Carpet, 2nd Floor",null,2006,"to 15",null,41.22,0,0,0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,18,null,"Square Feet","Hardwood Floor Refinishing",null,2006,"to 30",null,2.62,0,0,0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,19,null,"Square Feet","Paint Finish, Ceiling",null,2006,"to 20",null,0.64,0,0,0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"SUM(B32+1)","v":20},null,"Square Feet","Paint Finish, Walls",null,{"$f":"SUM(2006+I33)","v":2006},"to 10",null,0.54,0,{"$f":"SUM(M33:AQ33)","v":0},0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,21,null,"Square Feet","Recreation Room, Update/Remodel, Basement",null,2006,"to 25",null,10,0,0,0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,22,null,"Square Yards","Vinyl Flooring",null,2006,"to 20",null,33.39,0,0,0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,23,null,null,null,null,2006,null,null,null,0,0,0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,24,null,null,null,null,2006,null,null,null,0,0,0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,25,null,null,null,null,2006,null,null,null,0,0,0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"MAX(B27:B38)","v":25},null,null,"Building Systems"]
[null,{"$f":"SUM(B39+1)","v":26},1,"Each","Central Air Conditioner, Condenser",null,{"$f":"SUM(2006+I40)","v":2006},"to 20",null,2000,{"$f":"SUM(C40*J40)","v":2000},{"$f":"SUM(M40:AQ40)","v":2000},{"$f":"IF(M$9=$I40,FV($T$4,M$9,0,$K40,1)*(-1),\"---\")","v":2000},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,27,1,"Each","Dehumidifier",null,2006,"to 10",null,150,150,150,{"$f":"IF(M$9=$I41,FV($T$4,M$9,0,$K41,1)*(-1),\"---\")","v":150},"---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(Z$9=$I41,FV($T$4,Z$9,0,$K41,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AP$9=$I41,FV($T$4,AP$9,0,$K41,1)*(-1),\"---\")","v":"---"},"---"]
[null,28,1,"Each","Electrical Panel Upgrade to 200 Amp",null,2006,"to 40",null,1500,1500,1500,1500,"---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(Y$9=$I42,FV($T$4,Y$9,0,$K42,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---",{"$f":"IF(AI$9=$I42,FV($T$4,AI$9,0,$K42,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---"]
[null,29,1,"Each","Furnace, Gas Forced Warm Air",null,2006,"to 20",null,2200,2200,2200,2200,"---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(Y$9=$I43,FV($T$4,Y$9,0,$K43,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,30,1,"Allowance","Plumping Pipe, Partial Replacements",null,2006,"to 70",null,1000,1000,1000,1000,"---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(Y$9=$I44,FV($T$4,Y$9,0,$K44,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,31,1,"Allowance","Sewer (Clean Out)",null,2006,"to 2",null,125,125,125,{"$f":"IF(M$9=$I45,FV($T$4,M$9,0,$K45,1)*(-1),\"---\")","v":125},"---","---","---","---",{"$f":"IF(R$9=$I45,FV($T$4,R$9,0,$K45,1)*(-1),\"---\")","v":"---"},"---",{"$f":"IF(T$9=$I45,FV($T$4,T$9,0,$K45,1)*(-1),\"---\")","v":"---"},"---",{"$f":"IF(V$9=$I45,FV($T$4,V$9,0,$K45,1)*(-1),\"---\")","v":"---"},"---",{"$f":"IF(X$9=$I45,FV($T$4,X$9,0,$K45,1)*(-1),\"---\")","v":"---"},"---",{"$f":"IF(Z$9=$I45,FV($T$4,Z$9,0,$K45,1)*(-1),\"---\")","v":"---"},"---",{"$f":"IF(AB$9=$I45,FV($T$4,AB$9,0,$K45,1)*(-1),\"---\")","v":"---"},"---",{"$f":"IF(AD$9=$I45,FV($T$4,AD$9,0,$K45,1)*(-1),\"---\")","v":"---"},"---",{"$f":"IF(AF$9=$I45,FV($T$4,AF$9,0,$K45,1)*(-1),\"---\")","v":"---"},"---",{"$f":"IF(AH$9=$I45,FV($T$4,AH$9,0,$K45,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---"]
[null,26,1,"Each","Sump Pump",null,{"$f":"SUM(2006+I46)","v":2006},"to 20",null,150,150,{"$f":"SUM(M46:AQ46)","v":150},150,"---","---","---",{"$f":"IF(Q$9=$I46,FV($T$4,Q$9,0,$K46,1)*(-1),\"---\")","v":"---"},"---",{"$f":"IF(S$9=$I46,FV($T$4,S$9,0,$K46,1)*(-1),\"---\")","v":"---"},"---",{"$f":"IF(U$9=$I46,FV($T$4,U$9,0,$K46,1)*(-1),\"---\")","v":"---"},"---",{"$f":"IF(W$9=$I46,FV($T$4,W$9,0,$K46,1)*(-1),\"---\")","v":"---"},"---",{"$f":"IF(Y$9=$I46,FV($T$4,Y$9,0,$K46,1)*(-1),\"---\")","v":"---"},{"$f":"IF(Z$9=$I46,FV($T$4,Z$9,0,$K46,1)*(-1),\"---\")","v":"---"},{"$f":"IF(AA$9=$I46,FV($T$4,AA$9,0,$K46,1)*(-1),\"---\")","v":"---"},"---",{"$f":"IF(AC$9=$I46,FV($T$4,AC$9,0,$K46,1)*(-1),\"---\")","v":"---"},"---",{"$f":"IF(AE$9=$I46,FV($T$4,AE$9,0,$K46,1)*(-1),\"---\")","v":"---"},"---",{"$f":"IF(AG$9=$I46,FV($T$4,AG$9,0,$K46,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---"]
[null,27,1,"Each","Water Heater, Gas, 40 Gal.",null,2006,"to 15",null,650,650,650,650,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AE$9=$I47,FV($T$4,AE$9,0,$K47,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---"]
[null,28,1,"Each","Water Softener",null,2006,"to 10",null,700,700,700,700,"---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(Z$9=$I48,FV($T$4,Z$9,0,$K48,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"SUM(B48+1)","v":29},1,"Each","Well Pump",null,2006,"to 20",null,2500,2500,2500,2500,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AE$9=$I49,FV($T$4,AE$9,0,$K49,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"SUM(B49+1)","v":30},1,"Each","Well Tank",null,2006,"to 50",null,500,500,500,500,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AE$9=$I50,FV($T$4,AE$9,0,$K50,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"SUM(B50+1)","v":31},null,null,null,null,2006,null,null,null,0,0,0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AE$9=$I51,FV($T$4,AE$9,0,$K51,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"SUM(B51+1)","v":32},null,null,null,null,{"$f":"SUM(2006+I52)","v":2006},null,null,null,0,{"$f":"SUM(M52:AQ52)","v":0},0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AE$9=$I52,FV($T$4,AE$9,0,$K52,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"SUM(B52+1)","v":33},null,null,null,null,{"$f":"SUM(2006+I53)","v":2006},null,null,null,0,{"$f":"SUM(M53:AQ53)","v":0},0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AE$9=$I53,FV($T$4,AE$9,0,$K53,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"MAX(B40:B53)","v":33},null,null,"Site"]
[null,{"$f":"SUM(B54+1)","v":34},null,"Square Feet","Brick Patio",null,{"$f":"SUM(2006+I55)","v":2006},"to 15",null,10.5,{"$f":"SUM(C55*J55)","v":0},{"$f":"SUM(M55:AQ55)","v":0},{"$f":"IF(M$9=$I55,FV($T$4,M$9,0,$K55,1)*(-1),\"---\")","v":0},"---","---","---","---","---","---","---","---","---",{"$f":"IF(W$9=$I55,FV($T$4,W$9,0,$K55,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AM$9=$I55,FV($T$4,AM$9,0,$K55,1)*(-1),\"---\")","v":"---"},"---","---","---","---"]
[null,35,null,"Square Feet","Concrete Garage Slab",null,2006,"to 65",null,7.44,0,0,0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,36,null,"Square Feet","Concrete Stoops",null,2006,"to 65",null,15,0,0,{"$f":"IF(M$9=$I57,FV($T$4,M$9,0,$K57,1)*(-1),\"---\")","v":0},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AC$9=$I57,FV($T$4,AC$9,0,$K57,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,37,null,"Square Yards","Driveway, Asphalt Pavement Replacement",null,2006,"15 to 20",null,12.5,0,0,{"$f":"IF(M$9=$I58,FV($T$4,M$9,0,$K58,1)*(-1),\"---\")","v":0},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,38,null,"Square Yards","Driveway, Asphalt Pavement Seal Coat",null,2006,"2 to 4",null,0.95,0,0,{"$f":"IF(M$9=$I59,FV($T$4,K$9,0,$K59,1)*(-1),\"---\")","v":0},{"$f":"IF(N$9=$I59,FV($T$4,N$9,0,$K59,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,39,null,"Linear Feet","Fence",null,2006,"to 15",null,15,0,0,{"$f":"IF(M$9=$I60,FV($T$4,M$9,0,$K60,1)*(-1),\"---\")","v":0},"---",{"$f":"IF(O$9=$I60,FV($T$4,O$9,0,$K60,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"SUM(B60+1)","v":40},null,"Each","Ramps, Accessible (Anticipated)",null,{"$f":"SUM(2006+I61)","v":2006},"to 15",null,300,0,{"$f":"SUM(M61:AQ61)","v":0},0,"---",{"$f":"IF(O$9=$I61,FV($T$4,O$9,0,$K61,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AE$9=$I61,FV($T$4,AE$9,0,$K61,1)*(-1),\"---\")","v":"---"},{"$f":"IF(AF$9=$I61,FV($T$4,AF$9,0,$K61,1)*(-1),\"---\")","v":"---"},{"$f":"IF(AG$9=$I61,FV($T$4,AG$9,0,$K61,1)*(-1),\"---\")","v":"---"},{"$f":"IF(AH$9=$I61,FV($T$4,AH$9,0,$K61,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---"]
[null,{"$f":"SUM(B61+1)","v":41},null,"Allowance","Tree Pruning",null,{"$f":"SUM(2006+I62)","v":2006},"to 5",null,500,0,{"$f":"SUM(M62:AQ62)","v":0},0,"---",{"$f":"IF(O$9=$I62,FV($T$4,O$9,0,$K62,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---",{"$f":"IF(V$9=$I62,FV($T$4,V$9,0,$K62,1)*(-1),\"---\")","v":"---"},"---","---","---","---",{"$f":"IF(AA$9=$I62,FV($T$4,AA$9,0,$K62,1)*(-1),\"---\")","v":"---"},"---","---","---","---",{"$f":"IF(AF$9=$I62,FV($T$4,AF$9,0,$K62,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"SUM(B62+1)","v":42},null,null,null,null,{"$f":"SUM(2006+I63)","v":2006},null,null,null,0,{"$f":"SUM(M63:AQ63)","v":0},0,"---","---","---","---","---","---","---",{"$f":"IF(U$9=$I63,FV($T$4,U$9,0,$K63,1)*(-1),\"---\")","v":"---"},"---","---","---","---",{"$f":"IF(Z$9=$I63,FV($T$4,Z$9,0,$K63,1)*(-1),\"---\")","v":"---"},"---","---","---","---",{"$f":"IF(AE$9=$I63,FV($T$4,AE$9,0,$K63,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"SUM(B63+1)","v":43},null,null,null,null,{"$f":"SUM(2006+I64)","v":2006},null,null,null,0,{"$f":"SUM(M64:AQ64)","v":0},0,"---","---","---","---","---","---","---",{"$f":"IF(U$9=$I64,FV($T$4,U$9,0,$K64,1)*(-1),\"---\")","v":"---"},"---","---","---","---",{"$f":"IF(Z$9=$I64,FV($T$4,Z$9,0,$K64,1)*(-1),\"---\")","v":"---"},"---","---","---","---",{"$f":"IF(AE$9=$I64,FV($T$4,AE$9,0,$K64,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"SUM(B64+1)","v":44},null,null,null,null,{"$f":"SUM(2006+I65)","v":2006},null,null,null,0,{"$f":"SUM(M65:AQ65)","v":0},0,"---","---","---","---","---","---","---",{"$f":"IF(U$9=$I65,FV($T$4,U$9,0,$K65,1)*(-1),\"---\")","v":"---"},"---","---","---","---",{"$f":"IF(Z$9=$I65,FV($T$4,Z$9,0,$K65,1)*(-1),\"---\")","v":"---"},"---","---","---","---",{"$f":"IF(AE$9=$I65,FV($T$4,AE$9,0,$K65,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"MAX(B54:B65)","v":44},null,null,"Major Appliances"]
[null,{"$f":"SUM(B66+1)","v":45},1,"Each","Dishwasher",null,{"$f":"SUM(2006+I67)","v":2006},"to 15",null,550,{"$f":"SUM(C67*J67)","v":550},{"$f":"SUM(M67:AQ67)","v":550},{"$f":"IF(M$9=$I67,FV($T$4,M$9,0,$K67,1)*(-1),\"---\")","v":550},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,46,1,"Each","Disposal",null,2006,"to 10",null,367,367,367,{"$f":"IF(M$9=$I68,FV($T$4,M$9,0,$K68,1)*(-1),\"---\")","v":367},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AC$9=$I68,FV($T$4,AC$9,0,$K68,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,47,1,"Each","Dryer, Gas",null,2006,"to 12",null,400,400,400,400,"---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AB$9=$I69,FV($T$4,AB$9,0,$K69,1)*(-1),\"---\")","v":"---"},"---","---","---","---",{"$f":"IF(AG$9=$I69,FV($T$4,AG$9,0,$K69,1)*(-1),\"---\")","v":"---"},{"$f":"IF(AH$9=$I69,FV($T$4,AH$9,0,$K69,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---"]
[null,48,1,"Each","Freezer",null,2006,"to 15",null,400,400,400,400,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AF$9=$I70,FV($T$4,AF$9,0,$K70,1)*(-1),\"---\")","v":"---"},{"$f":"IF(AG$9=$I70,FV($T$4,AG$9,0,$K70,1)*(-1),\"---\")","v":"---"},{"$f":"IF(AH$9=$I70,FV($T$4,AH$9,0,$K70,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---"]
[null,49,1,"Each","Microwave",null,2006,"to 10",null,150,150,150,{"$f":"IF(M$9=$I71,FV($T$4,M$9,0,$K71,1)*(-1),\"---\")","v":150},"---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(Z$9=$I71,FV($T$4,Z$9,0,$K71,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---",{"$f":"IF(AF$9=$I71,FV($T$4,AF$9,0,$K71,1)*(-1),\"---\")","v":"---"},{"$f":"IF(AG$9=$I71,FV($T$4,AG$9,0,$K71,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---"]
[null,50,1,"Each","Refrigerator",null,2006,"to 15",null,500,500,500,500,"---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(Y$9=$I72,FV($T$4,Y$9,0,$K72,1)*(-1),\"---\")","v":"---"},"---","---",{"$f":"IF(AB$9=$I72,FV($T$4,AB$9,0,$K72,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"SUM(B72+1)","v":51},1,"Each","Stove/Oven",null,{"$f":"SUM(2006+I73)","v":2006},"to 20",null,550,550,{"$f":"SUM(M73:AQ73)","v":550},550,"---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(Y$9=$I73,FV($T$4,Y$9,0,$K73,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---",{"$f":"IF(AE$9=$I73,FV($T$4,AE$9,0,$K73,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"SUM(B73+1)","v":52},1,"Each","Washer",null,{"$f":"SUM(2006+I74)","v":2006},"to 12",null,450,450,{"$f":"SUM(M74:AQ74)","v":450},450,"---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(Y$9=$I74,FV($T$4,Y$9,0,$K74,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---",{"$f":"IF(AE$9=$I74,FV($T$4,AE$9,0,$K74,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"SUM(B74+1)","v":53},null,null,null,null,{"$f":"SUM(2006+I75)","v":2006},null,null,null,0,{"$f":"SUM(M75:AQ75)","v":0},{"$f":"IF(M$9=$I75,FV($T$4,M$9,0,$K75,1)*(-1),\"---\")","v":0},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AE$9=$I75,FV($T$4,AE$9,0,$K75,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"SUM(B75+1)","v":54},null,null,null,null,{"$f":"SUM(2006+I76)","v":2006},null,null,null,0,{"$f":"SUM(M76:AQ76)","v":0},0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AE$9=$I76,FV($T$4,AE$9,0,$K76,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"SUM(B76+1)","v":55},null,null,null,null,{"$f":"SUM(2006+I77)","v":2006},null,null,null,0,{"$f":"SUM(M77:AQ77)","v":0},0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AE$9=$I77,FV($T$4,AE$9,0,$K77,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"MAX(B67:B77)","v":55},null,null,"Major Equipment"]
[null,{"$f":"SUM(B78+1)","v":56},1,"Each","Chipper/Shredder 5 HP",null,{"$f":"SUM(2006+I79)","v":2006},"to 20",null,400,{"$f":"SUM(C79*J79)","v":400},{"$f":"SUM(M79:AQ79)","v":400},{"$f":"IF(M$9=$I79,FV($T$4,M$9,0,$K79,1)*(-1),\"---\")","v":400},"---","---","---","---","---","---","---","---","---",{"$f":"IF(W$9=$I79,FV($T$4,W$9,0,$K79,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AM$9=$I79,FV($T$4,AM$9,0,$K79,1)*(-1),\"---\")","v":"---"},"---","---","---","---"]
[null,57,1,"Each","Generator, 5,000 Watt, Gas, 10 HP, Back up",null,2006,"to 25",null,500,500,500,500,"---","---","---","---","---","---","---","---","---",{"$f":"IF(W$9=$I80,FV($T$4,W$9,0,$K80,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,58,1,"Each","Lawn Tractor, 16 HP, 42\" Cut",null,2006,"to 12",null,1200,1200,1200,1200,"---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AB$9=$I81,FV($T$4,AB$9,0,$K81,1)*(-1),\"---\")","v":"---"},{"$f":"IF(AC$9=$I81,FV($T$4,AC$9,0,$K81,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,59,1,"Each","Pressure Washer, Electric",null,2006,"to 10",null,200,200,200,{"$f":"IF(M$9=$I82,FV($T$4,M$9,0,$K82,1)*(-1),\"---\")","v":200},"---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AB$9=$I82,FV($T$4,AB$9,0,$K82,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,60,1,"Each","Snow Blower, 5 HP, Two Stage",null,2006,"to 12",null,500,500,500,500,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,61,1,"Each","Tiller, 5 HP, 17\"",null,2006,"to 20",null,500,500,500,500,"---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AB$9=$I84,FV($T$4,AB$9,0,$K84,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"SUM(B84+1)","v":62},null,null,null,null,{"$f":"SUM(2006+I85)","v":2006},null,null,null,0,{"$f":"SUM(M85:AQ85)","v":0},0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AB$9=$I85,FV($T$4,AB$9,0,$K85,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"SUM(B85+1)","v":63},null,null,null,null,{"$f":"SUM(2006+I86)","v":2006},null,null,null,0,{"$f":"SUM(M86:AQ86)","v":0},0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AB$9=$I86,FV($T$4,AB$9,0,$K86,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,{"$f":"SUM(B86+1)","v":64},null,null,null,null,{"$f":"SUM(2006+I87)","v":2006},null,null,null,0,{"$f":"SUM(M87:AQ87)","v":0},0,"---","---","---","---","---","---","---","---","---","---","---","---","---","---","---",{"$f":"IF(AC$9=$I87,FV($T$4,AC$9,0,$K87,1)*(-1),\"---\")","v":"---"},"---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
[null,null,null,null,null,null,null,null,"Anticipated Capital Expenditures by Year",null,null,null,{"$f":"SUM(M12:M87)","v":26771},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AI12:AI87)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,"Total Capital Expenditures For 31 Years",null,null,{"$f":"SUM(L13:L87)","v":26771}]
[]
[null,null,null,null,null,"Annual Expenses/Routine Maintenance",null,null,null,null,"Annual Expense"]
[null,null,null,null,null,null,null,"Yard, mowing, trim, et.",null,null,975,{"$f":"SUM(M92:AQ92)","v":44850.263973794528},{"$f":"$K92","v":975},{"$f":"$K92* ($T$4+1)","v":999.37499999999989},{"$f":"N92* ($T$4+1)","v":1024.3593749999998},{"$f":"O92* ($T$4+1)","v":1049.9683593749996},{"$f":"P92* ($T$4+1)","v":1076.2175683593746},1103.1230075683588,1130.7010827575677,1158.9686098265067,1187.9428250721694,1217.6413956989736,1248.0824305914477,1279.2844913562337,1311.2666036401395,1344.0482687311428,1377.6494754494213,1412.0907123356567,1447.3929801440479,1483.5778046476489,1520.6672497638401,1558.6839310079361,1597.6510292831342,1637.5923050152123,{"$f":"AH92* ($T$4+1)","v":1678.5321126405925},1720.4954154566071,1763.5078008430221,1807.5954958640975,1852.7853832606997,1899.105017842217,1946.5826432882723,1995.2472093704789,2045.1283896047407]
[null,null,null,null,null,null,null,"Furnace, annual check & clean",null,null,85,3910.0230131000367,{"$f":"$K93","v":85},{"$f":"$K93* ($T$4+1)","v":87.124999999999986},{"$f":"N93* ($T$4+1)","v":89.30312499999998},91.535703124999969,93.824095703124954,96.169698095703069,98.573940548095635,101.03828906179801,103.56424628834296,106.15335244555152,108.8071862566903,111.52736591310754,114.31555006093522,117.1734388124586,120.10277478277006,123.1053441523393,126.18297775614776,129.33755220005145,132.57099100505272,135.88526578017903,139.2823974246835,142.76445736030058,{"$f":"AH93* ($T$4+1)","v":146.33356879430809},149.99190801416577,153.7417057145199,157.58524835738288,161.52487956631745,165.56300155547538,169.70207659436224,173.94462850922127,178.2932442219518]
[null,null,null,null,null,null,null,"Plumbing, minor repairs",null,null,20,920.00541484706798,20,20.5,{"$f":"N94* ($T$4+1)","v":21.012499999999999},21.537812499999998,22.076257812499996,22.628164257812493,23.193868364257803,23.773715073364247,24.368057950198352,24.977259398953308,25.601690883927137,26.241733156025312,26.897776484925942,27.570220897049087,28.259476419475313,28.965963329962193,29.690112413211246,30.432365223541524,31.193174354130058,31.973003712983306,32.772328805807888,33.591637025953084,{"$f":"AH94* ($T$4+1)","v":34.431427951601911},35.292213650391957,36.174518991651752,37.078881966443042,38.005854015604115,38.956000365994214,39.929900375144065,40.928147884522666,41.951351581635727]
[null,null,null,null,null,null,null,"Electrical, minor repairs",null,null,15,690.00406113530039,15,15.374999999999998,{"$f":"N95* ($T$4+1)","v":15.759374999999997},16.153359374999994,16.557193359374992,16.971123193359364,17.395401273193347,17.830286305023179,18.276043462648758,18.732944549214974,19.201268162945347,19.681299867018978,20.173332363694453,20.677665672786812,21.194607314606479,21.724472497471638,22.267584309908425,22.824273917656136,23.394880765597538,23.979752784737475,24.579246604355909,25.193727769464804,{"$f":"AH95* ($T$4+1)","v":25.823570963701421},26.469160237793954,27.1308892437388,27.809161474832266,28.504390511703068,29.217000274495643,29.947425281358033,30.69611091339198,31.463513686226776]
[null,null,null,null,null,null,null,"Window Cleaning -Seasonal",null,null,75,3450.0203056765044,75,76.875,{"$f":"N96* ($T$4+1)","v":78.796875},80.766796874999997,82.785966796874987,84.855615966796861,86.977006365966773,89.151431525115939,91.380217313243833,93.664722746074915,96.006340814726784,98.406499335094949,100.86666181847231,103.38832836393411,105.97303657303245,108.62236248735825,111.33792154954219,114.12136958828073,116.97440382798774,119.89876392368743,122.89623302177961,125.96863884732409,{"$f":"AH96* ($T$4+1)","v":129.11785481850717},132.34580118896983,135.65444621869406,139.0458073741614,142.52195255851541,146.08500137247827,149.73712640679022,153.48055456695997,157.31756843113396]
[null,null,null,null,null,null,null,"Utilities",null,null,0,0,0,0,{"$f":"N97* ($T$4+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AH97* ($T$4+1)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Interior Paint/Misc Repair",null,null,150,{"$f":"SUM(M98:AQ98)","v":6900.0406113530089},150,153.75,{"$f":"N98* ($T$4+1)","v":157.59375},161.53359374999999,165.57193359374997,169.71123193359372,173.95401273193355,178.30286305023188,182.76043462648767,187.32944549214983,192.01268162945357,196.8129986701899,201.73332363694462,206.77665672786821,211.94607314606489,217.24472497471649,222.67584309908437,228.24273917656146,233.94880765597549,239.79752784737485,245.79246604355922,251.93727769464817,{"$f":"AH98* ($T$4+1)","v":258.23570963701434},264.69160237793966,271.30889243738812,278.0916147483228,285.04390511703082,292.17000274495655,299.47425281358045,306.96110913391993,314.63513686226793]
[null,null,null,null,null,null,null,"City Assessments",null,null,0,0,0,0,{"$f":"N99* ($T$4+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AH99* ($T$4+1)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Sewer & Water",null,null,0,0,0,0,{"$f":"N100* ($T$4+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AH100* ($T$4+1)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Property Taxes",null,null,0,0,0,0,{"$f":"N101* ($T$4+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AH101* ($T$4+1)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Loan Principal & Interest",null,null,0,0,0,0,{"$f":"N102* ($T$4+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AH102* ($T$4+1)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Rental Property Insurance/Liability",null,null,0,0,0,0,{"$f":"N103* ($T$4+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AH103* ($T$4+1)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Personal Property Insurance",null,null,0,{"$f":"SUM(M104:AQ104)","v":0},0,0,{"$f":"N104* ($T$4+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AH104* ($T$4+1)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"24/7 Services Line",null,null,0,0,0,0,{"$f":"N105* ($T$4+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AH105* ($T$4+1)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Bank fees-total",null,null,0,0,0,0,{"$f":"N106* ($T$4+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AH106* ($T$4+1)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Exterior Trim Maintenance",null,null,350,16100.094759823678,350,358.74999999999994,{"$f":"N107* ($T$4+1)","v":367.71874999999989},376.91171874999986,386.33451171874981,395.99287451171853,405.89269637451144,416.0400137838742,426.44101412847101,437.10203948168277,448.02959046872479,459.23033023044286,470.71108848620389,482.47886569835896,494.54083734081792,506.90435827433834,519.5769672311967,532.56639141197661,545.88055119727596,559.52756497720782,573.51575410163798,587.85364795417888,{"$f":"AH107* ($T$4+1)","v":602.54998915303327},617.61373888185904,633.05408235390541,648.88043441275295,665.10244527307168,681.7300064048984,698.7732565650208,716.24258797914626,734.1486526786249]
[null,null,null,null,null,null,null,"Trustee Fees",null,null,1368,62928.370375539445,1368,1402.1999999999998,1437.2549999999997,1473.1863749999995,1510.0160343749994,1547.7664352343743,1586.4605961152336,1626.1221110181143,1666.7751637935671,1708.4445428884062,1751.1556564606162,1794.9345478721316,1839.8079115689347,1885.8031093581581,1932.9481870921118,1981.2718917694144,2030.8036890636497,2081.5737812902407,2133.6131258224964,2186.9534539680585,2241.6272903172598,2297.667972575191,2355.1096718895706,2413.9874136868098,2474.33709902898,2536.195526504704,2599.6004146673213,2664.5904250340041,2731.2051856598541,2799.4853153013501,2869.4724481838834]
[null,null,null,null,null,null,null,"Wish Fees-total",null,null,1800,82800.487336236096,{"$f":"$K109","v":1800},1844.9999999999998,{"$f":"N109* ($T$4+1)","v":1891.1249999999995},1938.4031249999994,1986.8632031249992,2036.5347832031241,2087.4481527832022,2139.6343566027822,2193.1252155178518,2247.953345905798,2304.1521795534427,2361.7559840422787,2420.7998836433353,2481.3198807344183,2543.3528777527786,2606.9366996965978,2672.1101171890123,2738.9128701187374,2807.3856918717056,2877.570334168498,2949.5095925227101,3023.2473323357776,{"$f":"AH109* ($T$4+1)","v":3098.8285156441716},3176.2992285352757,3255.7067092486573,3337.0993769798733,3420.5268614043698,3506.0400329394788,3593.6910337629656,3683.5333096070394,3775.6216423472151]
[null,null,null,null,null,null,null,null,"Anticipated Annual Expenses By Year",null,null,null,{"$f":"SUM(M91:M109)","v":4838},{"$f":"SUM(N91:N109)","v":4958.95},5082.923749999999,5209.9968437499983,5340.2467648437478,5473.7529339648408,5610.5967573139624,5750.86167624681,5894.6332181529806,6041.9990486068054,6193.0490248219749,6347.8752504425229,6506.5721317035859,6669.2364349961754,6835.9673458710786,7006.8665295178544,7182.0381927558001,7361.5891475746948,7545.6288762640615,7734.269598170662,7927.6263381249282,8125.8169965780507,{"$f":"SUM(AI91:AI109)","v":8328.9624214925007},8537.1864820298124,8750.6161440805572,8969.3815476825694,9193.6160863746336,9423.4564885339969,9659.0429007473467,9900.518973266031,10148.031947597679]
[null,null,null,null,null,null,null,null,"Anticipated Monthly Expenses by Year",null,null,null,{"$f":"M110*0.08333333333","v":403.16666665053998},413.24583331680344,423.57697914972346,434.16640362846653,445.02056371917814,456.14607781215756,467.54972975746153,479.23847300139795,491.21943482643292,503.49992069709378,516.08741871452105,528.98960418238391,542.21434428694351,555.76970289411713,569.66394546646995,583.90554410313166,598.50318270570983,613.46576227335254,628.80240633018627,644.52246648844084,660.63552815065191,677.15141635441819,{"$f":"AI110*0.08333333333","v":694.08020176327852},711.43220680736033,729.21801197754439,747.44846227698281,766.13467383390741,785.28804067975489,804.92024169674869,825.04324773916744,845.66932893264641]
[null,null,null,null,null,null,null,null,"Total Annual Expenditures For 31 Years",null,null,{"$f":"SUM(L92:L109)","v":222549.30985150568}]
[null,null,null,null,"Summary of Capital Expenditures and Annual Expenses"]
[null,null,null,null,null,null,"Total Capital and Annual Expenditures By Year",null,null,null,null,null,{"$f":"M88+M110","v":31609},{"$f":"N88+N110","v":4958.95},5082.923749999999,5209.9968437499983,5340.2467648437478,5473.7529339648408,5610.5967573139624,5750.86167624681,5894.6332181529806,6041.9990486068054,6193.0490248219749,6347.8752504425229,6506.5721317035859,6669.2364349961754,6835.9673458710786,7006.8665295178544,7182.0381927558001,7361.5891475746948,7545.6288762640615,7734.269598170662,7927.6263381249282,8125.8169965780507,{"$f":"AI88+AI110","v":8328.9624214925007},{"$f":"AJ88+AJ110","v":8537.1864820298124},8750.6161440805572,8969.3815476825694,9193.6160863746336,9423.4564885339969,9659.0429007473467,9900.518973266031,10148.031947597679]
[null,null,null,null,null,null,"Total Average Capital and Annual Expenditures By Year/Month",null,null,null,null,null,{"$f":"M114*0.08333333333","v":2634.0833332279699},413.24583331680344,423.57697914972346,434.16640362846653,445.02056371917814,456.14607781215756,467.54972975746153,479.23847300139795,491.21943482643292,503.49992069709378,516.08741871452105,528.98960418238391,542.21434428694351,555.76970289411713,569.66394546646995,583.90554410313166,598.50318270570983,613.46576227335254,628.80240633018627,644.52246648844084,660.63552815065191,677.15141635441819,{"$f":"AI114*0.08333333333","v":694.08020176327852},711.43220680736033,729.21801197754439,747.44846227698281,766.13467383390741,785.28804067975489,804.92024169674869,825.04324773916744,845.66932893264641]
[null,null,null,null,null,null,"Total Capital and Annual Expenditures For 31 Years",null,null,null,null,{"$f":"$L89+$L112","v":249320.30985150568}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Table Expenditure Information"]
[null,null,null,null,null,null,null,null,"Period, Years","2006 - 2013","2014 - 2021","2022 - 2029","2030 - 2036"]
[null,null,null,null,null,null,null,null,"Amount",{"$f":"SUM($M114:$T114)","v":69036.328726119362},{"$f":"SUM($U114:$AB114)","v":51496.198984112969},{"$f":"SUM($AC114:$AJ114)","v":62743.118052990518},{"$f":"SUM($AK114:$AQ114)","v":66044.664088282807}]
[null,null,null,null,null,null,null,null,"Percentage",{"$f":"SUM($J125/$L116)","v":0.27689813464148655},{"$f":"SUM($K125/$L116)","v":0.20654634600279428},{"$f":"SUM($L125/$L116)","v":0.25165666643989054},{"$f":"SUM($M125/$L116)","v":0.26489885291582854}]
[]
[null,null,null,null,"Pie Chart of Capital Expenditures"]
[null,null,null,null,"Building Exterior",{"$f":"SUM(L13:L25)","v":0}]
[null,null,null,null,"Building Interior",{"$f":"SUM(L27:L38)","v":8629}]
[null,null,null,null,"Building Systems",{"$f":"SUM(L40:L53)","v":11475}]
[null,null,null,null,"Site",{"$f":"SUM(L55:L65)","v":0}]
[null,null,null,null,"Major Appliances",{"$f":"SUM(L67:L77)","v":3367}]
[null,null,null,null,"Major Equipment",{"$f":"SUM(L79:L87)","v":3300}]
[null,null,null,null,null,null,{"$f":"SUM(F129:F134)","v":26771}]
[]
[]
[null,null,null,null,"Pie Chart - Capital Expeditures Vs. Annual Expenses/Maintenance"]
[null,null,null,null,"Capital Expeditures",{"$f":"SUM(L89)","v":26771}]
[null,null,null,null,"Annual Expenses & Maintenance",{"$f":"SUM(L112)","v":222549.30985150568}]

{"sheet":"Cash Flow Analysis","index":2,"n_rows":41,"n_cols":22,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"Cash Flow Analysis for "]
[null,null,null,null,{"$f":"'Property Elements'!E3","v":"Subject Property"}]
[null,null,null,null,{"$f":"'Property Elements'!E4","v":"W147 S6960 Durham Drive"}]
[null,null,null,null,{"$f":"'Property Elements'!E5","v":"Muskego, Wisconsin 53150"}]
[]
[null,null,null,null,"Inflation:",{"$f":"'Property Elements'!$T$4","v":2.5000000000000001E-2}]
["Anticipated Annual Percent Yield on Trust Funds:",null,null,null,null,3.5000000000000003E-2]
[]
[null,"Year","January 1, Trust Balance","Recommended Annual Funding (+)","Estimated Interest Earned (+)","Anticipated Expenditures        (-)","Trust Account Balance at Year End",null,null,null,"Monthly",null,null,"Year","Annually","Monthly","Year","Annually","Monthly","Year","Annually","Monthly"]
[null,2006,50000,14000,{"$f":"((C11+($D11/2))*($F$8+1))-(C11+(D11/2))","v":1994.9999999999927},{"$f":"'Property Elements'!$M114*-1","v":-31609},{"$f":"C11+D11+E11+ F11","v":34386},null,null,null,{"$f":"$D11/12","v":1166.6666666666667},null,null,{"$f":"B11","v":2006},{"$f":"D11","v":14000},{"$f":"$D11/12","v":1166.6666666666667},{"$f":"N21+1","v":2017},{"$f":"D22","v":18369.213209217713},{"$f":"$R11/12","v":1530.7677674348095},{"$f":"Q21+1","v":2028},{"$f":"D33","v":24101.999566121329},{"$f":"$U11/12","v":2008.499963843444}]
[null,{"$f":"SUM(B11+1)","v":2007},{"$f":"G11","v":34386},{"$f":"$D11*($F$7+1)","v":14349.999999999998},{"$f":"((C12+($D12/2))*($F$8+1))-(C12+(D12/2))","v":1454.6349999999948},{"$f":"'Property Elements'!$N114*-1","v":-4958.95},{"$f":"C12+D12+E12+ F12","v":45231.684999999998},null,null,null,{"$f":"$D12/12","v":1195.8333333333333},null,null,{"$f":"N11+1","v":2007},{"$f":"D12","v":14349.999999999998},{"$f":"$D12/12","v":1195.8333333333333},{"$f":"Q11+1","v":2018},{"$f":"D23","v":18828.443539448155},{"$f":"$R12/12","v":1569.0369616206797},{"$f":"T11+1","v":2029},{"$f":"D34","v":24704.54955527436},{"$f":"$U12/12","v":2058.7124629395298}]
[null,{"$f":"SUM(B12+1)","v":2008},{"$f":"G12","v":45231.684999999998},{"$f":"$D12*($F$7+1)","v":14708.749999999996},1840.5120999999926,{"$f":"'Property Elements'!$O$114*-1","v":-5082.923749999999},56698.023349999989,null,null,null,1225.7291666666663,null,null,{"$f":"N12+1","v":2008},{"$f":"D13","v":14708.749999999996},1225.7291666666663,2019,19299.154627934357,1608.2628856611964,2030,25322.163294156217,2110.180274513018]
[null,2009,{"$f":"G13","v":56698.023349999989},15076.468749999995,2248.2690203749953,{"$f":"'Property Elements'!$P$114*-1","v":-5209.9968437499983},68812.764276624992,null,null,null,1256.3723958333328,null,null,2009,15076.468749999995,1256.3723958333328,2020,19781.633493632715,1648.4694578027263,2031,25955.217376510122,2162.9347813758436]
[null,2010,68812.764276624992,15453.380468749992,2678.8809078849881,{"$f":"'Property Elements'!$Q$114*-1","v":-5340.2467648437478},81604.778888416229,null,null,null,1287.7817057291661,null,null,2010,15453.380468749992,1287.7817057291661,2021,20276.174330973532,1689.6811942477943,2032,26604.097810922871,2217.0081509102392]
[null,2011,81604.778888416229,15839.714980468741,3133.3622732527583,{"$f":"'Property Elements'!$R$114*-1","v":-5473.7529339648408},95104.103208172877,null,null,null,1319.976248372395,null,null,2011,15839.714980468741,1319.976248372395,2022,20783.078689247868,1731.923224103989,2033,27269.200256195942,2272.4333546829953]
[null,2012,95104.103208172877,16235.707854980459,3612.7684997481992,{"$f":"'Property Elements'!$S$114*-1","v":-5610.5967573139624},109341.98280558757,null,null,null,1352.9756545817049,null,null,2012,16235.707854980459,1352.9756545817049,2023,21302.655656479063,1775.2213047065886,2034,27950.930262600839,2329.2441885500698]
[null,2013,109341.98280558757,16641.600551354968,4118.1974078442727,{"$f":"'Property Elements'!$T$114*-1","v":-5750.86167624681},124350.91908854,null,null,null,1386.8000459462473,null,null,2013,16641.600551354968,1386.8000459462473,2024,21835.222047891039,1819.6018373242532,2035,28649.703519165858,2387.4752932638216]
[null,2014,124350.91908854,17057.640565138841,4650.7908779888239,{"$f":"'Property Elements'!$U$114*-1","v":-5894.6332181529806},140164.7173135147,null,null,null,1421.4700470949035,null,null,2014,17057.640565138841,1421.4700470949035,2025,22381.102599088314,1865.0918832573595,2036,29365.946107145002,2447.162175595417]
[null,2015,140164.7173135147,17484.081579267309,5211.7365336101793,{"$f":"'Property Elements'!$V$114*-1","v":-6041.9990486068054},156818.53637778538,null,null,null,1457.0067982722758,null,null,2015,17484.081579267309,1457.0067982722758,2026,22940.630164065518,1911.7191803387932]
[null,2016,156818.53637778538,17921.18361874899,5802.269486550591,{"$f":"'Property Elements'!$W$114*-1","v":-6193.0490248219749},174348.94045826298,null,null,null,1493.4319682290825,null,null,2016,17921.18361874899,1493.4319682290825,2027,23514.145918167153,1959.5121598472626]
[null,2017,174348.94045826298,18369.213209217713,6423.6741472005087,{"$f":"'Property Elements'!$X$114*-1","v":-6347.8752504425229},192793.95256423866,null,null,null,1530.7677674348095]
[null,2018,192793.95256423866,18828.443539448155,7077.2861016886891,{"$f":"'Property Elements'!$Y$114*-1","v":-6506.5721317035859},212193.11007367194,null,null,null,1569.0369616206797]
[null,2019,212193.11007367194,19299.154627934357,7764.4940585673612,{"$f":"'Property Elements'!$Z$114*-1","v":-6669.2364349961754},232587.52232517747,null,null,null,1608.2628856611964]
[null,2020,232587.52232517747,19781.633493632715,8486.7418675197696,{"$f":"'Property Elements'!$AA$114*-1","v":-6835.9673458710786},254019.93034045887,null,null,null,1648.4694578027263]
[null,2021,254019.93034045887,20276.174330973532,9245.5306127080694,{"$f":"'Property Elements'!$AB$114*-1","v":-7006.8665295178544},276534.76875462261,null,null,null,1689.6811942477943]
[null,2022,276534.76875462261,20783.078689247868,10042.420783473586,{"$f":"'Property Elements'!$AC$114*-1","v":-7182.0381927558001},300178.23003458831,null,null,null,1731.923224103989]
[null,2023,300178.23003458831,21302.655656479063,10879.034525198978,{"$f":"'Property Elements'!$AD$114*-1","v":-7361.5891475746948},324998.33106869168,null,null,null,1775.2213047065886]
[null,2024,324998.33106869168,21835.222047891039,11757.057973242248,{"$f":"'Property Elements'!$AE$114*-1","v":-7545.6288762640615},351044.98221356096,null,null,null,1819.6018373242532]
[null,2025,351044.98221356096,22381.102599088314,12678.243672958633,{"$f":"'Property Elements'!$AF$114*-1","v":-7734.269598170662},378370.05888743728,null,null,null,1865.0918832573595]
[null,2026,378370.05888743728,22940.630164065518,13644.413088931411,{"$f":"'Property Elements'!$AG$114*-1","v":-7927.6263381249282},407027.47580230929,null,null,null,1911.7191803387932]
[null,2027,407027.47580230929,23514.145918167153,14657.459206648695,{"$f":"'Property Elements'!$AH$114*-1","v":-8125.8169965780507},437073.26393054705,null,null,null,1959.5121598472626]
[null,2028,437073.26393054705,24101.999566121329,15719.349229976244,{"$f":"'Property Elements'!$AI$114*-1","v":-8328.9624214925007},{"$f":"C33+D33+E33+ F33","v":468565.65030515211},null,null,null,2008.499963843444]
[null,2029,468565.65030515211,24704.54955527436,16832.127377897559,{"$f":"'Property Elements'!$AJ$114*-1","v":-8537.1864820298124},501565.14075629425,null,null,null,2058.7124629395298]
[null,2030,501565.14075629425,25322.163294156217,17997.917784118035,{"$f":"'Property Elements'!$AK$114*-1","v":-8750.6161440805572},536134.60569048801,null,null,null,2110.180274513018]
[null,2031,536134.60569048801,25955.217376510122,19218.927503256011,{"$f":"'Property Elements'!$AL$114*-1","v":-8969.3815476825694},572339.3690225716,null,null,null,2162.9347813758436]
[null,2032,572339.3690225716,26604.097810922871,20497.449627481052,{"$f":"'Property Elements'!$AM$114*-1","v":-9193.6160863746336},610247.30037460092,null,null,null,2217.0081509102392]
[null,2033,610247.30037460092,27269.200256195942,21835.866517594433,{"$f":"'Property Elements'!$AN$114*-1","v":-9423.4564885339969},649928.91065985733,null,null,null,2272.4333546829953]
[null,2034,649928.91065985733,27950.930262600839,23236.653152690502,{"$f":"'Property Elements'!$AO$114*-1","v":-9659.0429007473467},691457.45117440133,null,null,null,2329.2441885500698]
[null,2035,691457.45117440133,28649.703519165858,24702.380602689344,{"$f":"'Property Elements'!$AP$114*-1","v":-9900.518973266031},734909.01632299053,null,null,null,2387.4752932638216]
[null,2036,734909.01632299053,29365.946107145002,26235.719628179679,{"$f":"'Property Elements'!$AQ$114*-1","v":-10148.031947597679},780362.65011071763,null,null,null,2447.162175595417]

{"sheet":"Trust Balance Graph","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"PIE CHART","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Table data for Summary","index":5,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Expenditure Table"]
[{"$f":"'Property Elements'!I124","v":"Period, Years"},{"$f":"'Property Elements'!J124","v":"2006 - 2013"},{"$f":"'Property Elements'!K124","v":"2014 - 2021"},{"$f":"'Property Elements'!L124","v":"2022 - 2029"},{"$f":"'Property Elements'!M124","v":"2030 - 2036"}]
[{"$f":"'Property Elements'!I125","v":"Amount"},{"$f":"'Property Elements'!J125","v":69036.328726119362},{"$f":"'Property Elements'!K125","v":51496.198984112969},{"$f":"'Property Elements'!L125","v":62743.118052990518},{"$f":"'Property Elements'!M125","v":66044.664088282807}]
[{"$f":"'Property Elements'!I126","v":"Percentage"},{"$f":"'Property Elements'!J126","v":0.27689813464148655},{"$f":"'Property Elements'!K126","v":0.20654634600279428},{"$f":"'Property Elements'!L126","v":0.25165666643989054},{"$f":"'Property Elements'!M126","v":0.26489885291582854}]

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