{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Expenditures","Funding Plan","Transition Study","Retrospective","20 Yr RF"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":4157,"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":"Expenditures","index":0,"n_rows":53,"n_cols":54,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Reserve Advisors Engineering, PLLC",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,"Years 2016 to 2031",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Years 2032 to 2046"]
[null,null,null,null,null,null,null,null,"RESERVE EXPENDITURES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Explanatory Notes:"]
[null,null,null,null,null,null,null,null,"Southampton",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1)",1.7000000000000001E-2,"is the estimated future Inflation Rate for estimating Future Replacement Costs."]
[null,null,null,null,null,null,null,null,"Homeowners Association",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2)","FY2016 is Fiscal Year beginning January 1, 2016 and ending December 31, 2016."]
[null,null,null,null,null,null,null,null,"Charlotte, North Carolina",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null," ",null," ",null,null,null,"Estimated","Life Analysis,",null,null,"Costs, $","",null,"Costs, $","",null,null,null,null,""]
["Line","30-Year","Total","Total","Per Phase",null,"Per",null,null,null,null,"1st Year of","Years",null,null,"Unit","Percentage","Per Phase","Unit","Percentage","Per Phase","Total","30-Year Total",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
["Item","Total","Quantity","Quantity","Quantity","Units","Phase","Units","Reserve Component Inventory",null,null,"Event","Useful",null,"Remaining","(2016)","Ownership","(2016)","(2016)","Ownership","(2016)","(2016)","(Inflated)",2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046]
["-","-",null,null,"-","-","-","-","-",null,null,"-","-",null,"-","-","-","-",null,"-",null,null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,null,null,null,null,null,null,null,"Exterior Clubhouse Elements"]
[1.28,40,40,40,40,"Squares",40,"Square Meters","Roofs, Asphalt Shingles (Includes Metal Roofs)","Roofs, Asphalt Shingles (Includes Metal Roofs)","Roofs, Asphalt Shingles, Phased",2034,"15 to 20","15 to 20","18",470,1,18800,470,1,18800,18800,25464,"","","","","","","","","","","","","","","","","","",25464,"","","","","","","","","","","",""]
[1.76,2,1,1,1,"Allowance",1,"Allowance","Walls, Siding and Trim, Paint Finishes","Walls, Siding and Trim, Paint Finishes","Walls, MATERIAL, Paint Finishes, Phased Applications",2024,"8 to 10","4 to 6","8",7200,1,7200,7200,1,7200,7200,19782,"","","","","","","","",8239,"","","","","","","","","",null,"","","","","","","","","",11543,"",""]
[1.98,550,550,550,550,"Square Feet",550,"Square Meters","Windows and Doors","Windows and Doors, Frame","Windows and Doors, Phased",2034,"to 40","varies","18",60,1,33000,60,1,33000,33000,44698,"","","","","","","","","","","","","","","","","","",44698,"","","","","","","","","","","",""]
[]
[null,null,null,null,null,null,null,null,"Interior Clubhouse Elements"]
[2.0710000000000002,1,1,1,1,"Each",1,"Systems","Air Handling and Condensing Units, Split System","Air Handling and Condensing Units, Split System","Air Handling and Condensing Units, Split Systems",2031,"15 to 20","to 20","15",6600,1,6600,6600,1,6600,6600,8499,"","","","","","","","","","","","","","","",8499,"","","","","","","","","","","","","","",""]
[2.2210000000000001,2,1,1,1,"Allowance",1,"Each","Entertainment System","Entertainment System","Light Fixtures",2023,"10 to 15","to 30","7",11500,1,11500,11500,1,11500,11500,29051,"","","","","","","",12940,"","","","","","","","","","","","",16111,"","","","","","","","","",""]
[2.2400000000000002,810,810,810,810,"Square Feet",810,"Square Meters","Floor Coverings, Tile","Floor Coverings, Tile","Floor Coverings, Tile",2023,"to 30","to 30","7",12,1,9720,12,1,9720,9720,10937,"","","","","","","",10937,"","","","","","","","","","","","","","","","","","","","","","",""]
[2.4500000000000002,5,2,2,1,"Allowance",1,"Allowance","Furnishings, Phased","Furnishings","Furnishings",2017,"to 15","to 25","1 to 8",5800,1,5800,5800,1,5800,11600,37866,"",5899,"","","","","","",6637,"","","","","","",7469,"","","","","","",8404,"","","","","","",9457,""]
[2.52,1,1,1,1,"Allowance",1,"Allowance","Kitchen, Renovation","Kitchen, Renovation","Kitchen, Renovations",2023,"to 25","to 25","7",14500,1,14500,14500,1,14500,14500,16316,"","","","","","","",16316,"","","","","","","","","","","","","","","","","","","","","","",""]
[2.56,1,1,1,1,"Allowance",1,"Each","Light Fixtures and Emergency Fixtures (Includes Ceiling Fans)","Light Fixtures and Emergency Fixtures (Includes Ceiling Fans)","Light Fixtures",2023,"to 30","to 30","7",5500,1,5500,5500,1,5500,5500,6189,"","","","","","","",6189,"","","","","","","","","","","","","","","","","","","","","","",""]
[2.8,17600,4400,4400,4400,"Square Feet",4400,"Square Meters","Paint Finishes","Paint Finishes","Paint Finishes, Hallways",2017,"6 to 10","6 to 10","1",0.70000000000000007,1,3080.0000000000005,0.70000000000000007,1,3080.0000000000005,3080.0000000000005,15267,"",3296,"","","","","",3466,"","","","","","","",3966,"","","","","","","",4539,"","","","","","",""]
[2.9,4,2,2,2,"Each",2,"Each","Rest Rooms, Renovation","Rest Rooms, Renovation","Rest Rooms, Renovation",2019,"to 25","to 35","3",16000,1,32000,16000,1,32000,32000,80815,"","","",33660,"","","","","","","","","","","","","","","","","","","",47155,"","","","","","",""]
[2.9209999999999998,2,1,1,1,"Allowance",1,"Allowance","Security System","Security System","Security System",2023,"10 to 15","to 15","7",17000,1,17000,17000,1,17000,17000,42547,"","","","","","","",19129,"","","","","","","","","","","",23418,"","","","","","","","","","",""]
[]
[null,null,null,null,null,null,null,null,"Property Site Elements"]
[4.0449999999999999,2680,1340,1340,1340,"Square Yards",1340,"Square Meters","Asphalt Pavement, Parking Lot, Total Replacement","Asphalt Pavement, Parking Lot, Total Replacement","Asphalt Pavement, Total Replacement, Phased",2018,"15 to 20","15 to 20","2",37.5,1,50250,37.5,1,50250,50250,124784,"","",51973,"","","","","","","","","","","","","","","","","","","",72811,"","","","","","","",""]
[4.0709999999999997,1080,270,270,270,"Square Yards",270,"Square Meters","Basketball Court, Color Coat","Basketball Court, Color Coat","Tennis Courts, Color Coat",2023,"4 to 6","4 to 6","7",8.5,1,2295,8.5,1,2295,2295,11774,"","","","","","","",2582,"","","","",2810,"","","","",3057,"","","","",3325,"","","","",null,"","",""]
[4.0720000000000001,180,180,180,180,"Linear Feet",180,"Meters","Basketball Court, Fence","Basketball Court, Fence","Tennis Courts, Fence",2037,"to 25","15 to 25","21",40,1,7200,40,1,7200,7200,10258,"","","","","","","","","","","","","","","","","","","","","",10258,"","","","","","","","",""]
[4.0730000000000004,540,270,270,270,"Square Yards",270,"Square Meters","Basketball Court, Surface Replacement (Includes Goals)","Basketball Court, Surface Replacement (Includes Goals)","Tennis Courts, Surface",2018,"to 25","20 to 25","2",53,1,14310,53,1,14310,14310,37359,"","",14801,"","","","","","","","","","","","","","","","","","","","","","","","",22558,"","",""]
[4.0910000000000002,430,215,215,215,"Square Feet",215,"Each","Bridges, Wood, Walking Paths","Bridges, Wood, Walking Paths","Doors, Front Entrances, Replacement",2022,"20 to 25","to 30","6",42.5,1,9137.5,42.5,1,9137.5,9137.5,25008,"","","","","","",10110,"","","","","","","","","","","","","","","","","","","","","","",14898,""]
[4.1399999999999997,2250,7500,7500,375,"Square Feet",375,"Square Meters","Concrete Sidewalks, Partial","Concrete Sidewalks","Concrete Sidewalks, Partial",2018,"to 65","to 65","2 to 30+",8.5,1,3187.5,8.5,1,3187.5,63750,24675,"","",3297,"","","","",3587,"","","","",3902,"","","","",4245,"","","","",4619,"","","","",5025,"","",""]
[4.42,4,4,0,4,"Each",0,"Square Meters","Irrigation Systems, Entrances and Recreation Area","Irrigation Systems, Entrances and Recreation Area","Irrigation System",2034,"to 35","to 40","18",16500,1,66000,{"$error":"#DIV/0!"},1,{"$error":"#DIV/0!"},66000,89397,"","","","","","","","","","","","","","","","","","",89397,"","","","","","","","","","","",""]
[4.5010000000000003,60,30,30,30,"Each",30,"Each","Light Fixtures, Landscape","Light Fixtures, Landscape","Light Poles and Fixtures",2021,"20 to 25","to 25","5",200,1,6000,200,1,6000,6000,15986,"","","","","",6528,"","","","","","","","","","","","","","","","","","","","","",9458,"","",""]
[4.66,2,1,1,1,"Allowance",1,"Allowance","Playground Equipment","Playground Equipment","Playground Equipment",2017,"15 to 20","15 to 20","1",45000,1,45000,45000,1,45000,45000,106988,"",45000,"","","","","","","","","","","","","","","","","",61988,"","","","","","","","","","",""]
[4.8,2,1,1,1,"Allowance",1,"Allowance","Signage, Monuments, Renovation","Signage, Monuments, Renovation (2017 is Budgeted)","Signage",2021,"20 to 25","15 to 20","5",21500,1,21500,21500,1,21500,21500,57284,"",null,"","","",23391,"","","","","","","","","","","","","","","","","","","","","",33893,"","",""]
[]
[null,null,null,null,null,null,null,null,"Pool Elements"]
[6.2,31500,10500,10500,10500,"Square Feet",10500,"Square Meters","Concrete Deck, Inspections, Partial Replacements and Repairs","Concrete Deck, Inspections, Partial Replacements and Repairs","Concrete Deck, Inspections, Partial Replacements and Repairs",2024,"8 to 12","8 to 12","8",1.25,1,13125,1.25,1,13125,13125,53840,"","","","","","","","",15020,"","","","","","","","","",17778,"","","","","","","","","",21042,"",""]
[6.3,17600,4400,4400,4400,"Square Feet",4400,"Each","Cover, Vinyl, Main Pool","Cover, Vinyl, Main Pool","Cover",2017,"6 to 8","6 to 8","1",2,1,8800,2,1,8800,8800,44324,"",8950,"","","","","","","",10242,"","","","","","","",11720,"","","","","","","",13412,"","","","",""]
[6.4,465,465,465,465,"Linear Feet",465,"Meters","Fences, Aluminum","Fences, Aluminum","Fence, MATERIAL",2024,"to 25","varies","8",46,1,21390,46,1,21390,21390,24478,"","","","","","","","",24478,"","","","","","","","","","","","","","","","","","","","","",""]
[6.5,7,3,3,1,"Allowance",1,"Allowance","Furniture, Phased","Furniture","Furniture",2019,"to 12","to 12","3 to 11",5500,1,5500,5500,1,5500,16500,50028,"","","",5785,"","","",6189,"","","",6621,"","","",7082,"","","",7576,"","","",8105,"","","",8670,"","",""]
[6.5510000000000002,6,1,0,1,"Allowance",1,"Allowance","Lane Lines",{"$error":"#N/A"},"Mechanical Equipment",2021,"4 to 6","to 15","5",5000,1,5000,5000,1,5000,5000,40713,"","","","","",5440,"","","","",5918,"","","","",6438,"","","","",7005,"","","","",7621,"","","","",8291]
[6.6,6,3,3,1,"Allowance",1,"Allowance","Mechanical Equipment, Phased","Mechanical Equipment","Mechanical Equipment",2021,"to 15","to 15","5 to 15",10500,1,10500,10500,1,10500,31500,85496,"","","","","",11423,"","","","",12428,"","","","",13521,"","","","",14710,"","","","",16003,"","","","",17411]
[6.8,12300,4100,4100,4100,"Square Feet",4100,"Square Meters","Pool Finish, Plaster, Main Pool","Pool Finish, Plaster, Main Pool","Plaster Finish",2026,"8 to 12","8 to 12","10",12.75,1,52275,12.75,1,52275,52275,221788,"","","","","","","","","","",61873,"","","","","","","","","",73234,"","","","","","","","","",86681]
[6.8010000000000002,2200,550,550,550,"Square Feet",550,"Square Meters","Pool Finish, Plaster, Splash Pad","Pool Finish, Plaster, Splash Pad","Plaster Finish",2016,"8 to 12","8 to 12","0",10.65,1,5850,10.65,1,5857.5,5857.5,30702,5850,"","","","","","","","","",6933,"","","","","","","","","",8206,"","","","","","","","","",9713]
[6.95,2,1,1,1,"Each",1,"Square Meters","Water Feature, Water Slide","Water Feature, Water Slide","Water Feature",2017,"to 15","to 60","1",17000,1,17000,17000,1,17000,17000,39552,"",17289,"","","","","","","","","","","","","","",22263,"","","","","","","","","","","","","",""]
[6.9509999999999996,2,1,1,1,"Each",1,"Square Meters","Water Feature, Mushroom","Water Feature, Mushroom","Water Feature",2017,"to 15","to 60","1",9000,1,9000,9000,1,9000,9000,20939,"",9153,"","","","","","","","","","","","","","",11786,"","","","","","","","","","","","","",""]
[]
["u.2",1,null,null,1,"Allowance",1,"Allowance","Reserve Study Update with Site Visit",null,null,2018,2,null,"2",2850,1,2850,null,1,null,2850,2850,null,null,2850]
["||",null,null,null,null,null,null,null,"-",null,null,"-",null,null,"-","-","-","-",null,"-",null,null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,null,null,null,null,null,null,null,"Anticipated Expenditures, By Year",null,null," ",null,null,null,null,null," ",null,null,null,null,1455654,5850,89587,72921,39445,0,46782,10110,81335,54374,10242,87152,6621,6712,0,0,46975,34049,19022,177337,92982,119266,10258,89159,59799,0,37036,0,79604,32585,24355,122096]

{"sheet":"Funding Plan","index":1,"n_rows":46,"n_cols":20,"rows_kept":46,"cut":false,"hidden":false,"merged":[[8,1,8,2]]}
[null,null,"RESERVE FUNDING PLAN"]
[null,null,"",null,""]
[null,null,"CASH FLOW ANALYSIS",null,""]
[null,null,"Southampton"]
["Unit",null,"Homeowners Association",null,null,"Individual Reserve Budgets & Cash Flows for the Next 30 Years"]
[null,null,"Charlotte, North Carolina",null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031]
[null,"Reserves at Beginning of Year (Note 1)",null,null,80472.59,74855.59,41965.59,25446.589999999997,25304.589999999997,65546.59,59912.59,91807.59,53136.59,41828.589999999997,75486.59,32880.589999999997,71481.59,111259.59,159071.59,208262.59]
["Plus","           Recommended Reserve Contributions ",null,null,115.375,56000,56000,39000,39700,40400,41100,41800,42500,43200,43900,44600,45400,46200,47000,47800]
["Plus","           Additional Assessment",null,null," ","","","","","","","","","","","","","","",""]
[null,"Total Recommended Reserve Contributions (Note 2)",null,null,0,56000,56000,39000,39700,40400,41100,41800,42500,43200,43900,44600,45400,46200,47000,47800]
[null,"           Anticipated Interest Rate",null,null,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2]
["Plus","Estimated Interest Earned, During Year (Note 3)",null,null,233,697,402,303,542,748,905,864,566,700,646,622,1090,1612,2191,2504]
["Less","Anticipated Expenditures, By Year",null,null,-5850,-89587,-72921,-39445,0,-46782,-10110,-81335,-54374,-10242,-87152,-6621,-6712,0,0,-46975]
[null,null,null,null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,"Anticipated Reserves at Year End",null,null,74855.59,41965.59,25446.589999999997,25304.589999999997,65546.59,59912.59,91807.59,53136.59,41828.589999999997,75486.59,32880.589999999997,71481.59,111259.59,159071.59,208262.59,211591.59]
[null,null,null,null,"","","(NOTE 5)",null,"","","","","","","","","","","",""]
[null,null,"Predicted Reserves based on 2016 funding level of:  ",461.5,74855.59,-13905.910000000003,"","","","","","","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[null,null,"(continued)",null,null,"Individual Reserve Budgets & Cash Flows for the Next 30 Years, Continued"]
[null,null,"",null,null,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046]
[null,"Reserves at Beginning of Year",null,null,null,211591.59,228768.58999999997,262073.58999999997,137318.58999999997,96833.589999999967,30325.589999999967,73587.589999999967,38899.589999999967,34236.589999999967,90580.589999999967,111248.58999999997,170428.58999999997,151243.58999999997,180134.58999999997,218657.58999999997]
["Plus","           Recommended Reserve Contributions ",null,null,null,48600,49400,50200,51100,52000,52900,53800,54700,55600,56500,57500,58500,59500,60500,61500]
["Plus","           Additional Assessment",null,null,null,"","","","","","","","","","","","","","",""]
[null,"Total Recommended Reserve Contributions ",null,null,null,48600,49400,50200,51100,52000,52900,53800,54700,55600,56500,57500,58500,59500,60500,61500]
[null,"           Anticipated Interest Rate",null,null,null,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2]
["Plus","Estimated Interest Earned, During Year",null,null,null,2626,2927,2382,1397,758,620,671,436,744,1204,1680,1919,1976,2378,2260]
["Less","Anticipated Expenditures, By Year",null,null,null,-34049,-19022,-177337,-92982,-119266,-10258,-89159,-59799,0,-37036,0,-79604,-32585,-24355,-122096]
[null,null,null,null,null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,"Anticipated Reserves at Year End",null,null,null,228768.58999999997,262073.58999999997,137318.58999999997,96833.589999999967,30325.589999999967,73587.589999999967,38899.589999999967,34236.589999999967,90580.589999999967,111248.58999999997,170428.58999999997,151243.58999999997,180134.58999999997,218657.58999999997,160321.58999999997]
[null,null,null,null,null,"","","","","(NOTE 5)","","","","","","","","","","(NOTE 4)"]
[null,null,"","",null,"","","","","","","","","","","","","","",""]
[]
[]
[]
["Explanatory Notes:"]
["1) ","Year 2016 starting reserves are as of September 30, 2016; FY2016 starts January 1, 2016 and ends December 31, 2016."]
["2) ","Reserve Contributions for 2016 are already contributed; 2017 is the first year of recommended contributions."]
["3) ",1.2E-2,"is the estimated annual rate of return on invested reserves; 2016 is a partial year of interest earned."]
["4) ","Accumulated year 2046 ending reserves consider the age, size, overall condition and complexity of the property."]
["5) ","Threshold Funding Years (reserve balance at critical point)."]

{"sheet":"Transition Study","index":2,"n_rows":39,"n_cols":14,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,{"$f":"COUNTA(Line_Item_Numbers)","v":0}]
[]
[null,null,null,null,"ESTIMATED REMEDIATION EXPENDITURES for"]
[null,null,null,null,null,null,null,null,null,null,null,"Include a more detailed description of defect here when compared to the bulleted lists in the report"]
[null,null,null,null,{"$f":"IFERROR(IF(FIND(\" \",#REF!,LEN(#REF!)/2)-LEN(#REF!)/2<LEN(#REF!)/2-FIND(\" \",#REF!,LEN(#REF!)/2-(FIND(\" \",#REF!,LEN(#REF!)/2)-LEN(#REF!)/2)),LEFT(#REF!,FIND(\" \",#REF!,LEN(#REF!)/2)-1),LEFT(#REF!,FIND(\" \",#REF!,LEN(#REF!)/2-(FIND(\" \",#REF!,LEN(#REF!)/2)-LEN(#REF!)/2))-1)),#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"IFERROR(IF(FIND(\" \",#REF!,LEN(#REF!)/2)-LEN(#REF!)/2<LEN(#REF!)/2-FIND(\" \",#REF!,LEN(#REF!)/2-(FIND(\" \",#REF!,LEN(#REF!)/2)-LEN(#REF!)/2)),MID(#REF!,FIND(\" \",#REF!,LEN(#REF!)/2)+1,1000),MID(#REF!,FIND(\" \",#REF!,LEN(#REF!)/2-(FIND(\" \",#REF!,LEN(#REF!)/2)-LEN(#REF!)/2))+1,1000)),\"\")","v":""}]
[null,null,null,null,{"$f":"CONCATENATE(#REF!,\", \",#REF!)","v":{"$error":"#REF!"}}]
[null,null,null," "]
[null,"Line",null,null,null,"Unit","Total"]
[null,"Item","Quantity","Units","Reserve Component Inventory","Cost","Cost"]
[null,"-","-","-","-","-","-"]
[]
[null,1,null,null,"Include a more detailed description of defect here than bulleted lists in the report",null,{"$f":"+F15*C15","v":0},null,null,null,null,null,{"$f":"E15","v":"Include a more detailed description of defect here than bulleted lists in the report"},{"$f":"G15","v":0}]
[null,{"$f":"B15+1","v":2},null,null,null,null,0,null,null,null,null,null,{"$f":"E16","v":0},{"$f":"G16","v":0}]
[null,{"$f":"B16+1","v":3},null,null,null,null,0,null,null,null,null,null,0,0]
[null,4,null,null,null,null,0,null,null,null,null,null,0,0]
[null,5,null,null,null,null,0,null,null,null,null,null,0,0]
[null,6,null,null,null,null,0,null,null,null,null,null,0,0]
[null,7,null,null,null,null,0,null,null,null,null,null,0,0]
[null,8,null,null,null,null,0,null,null,null,null,null,0,0]
[null,9,null,null,null,null,{"$f":"+F23*C23","v":0},null,null,null,null,null,0,0]
[null,10,null,null,null,null,{"$f":"+F24*C24","v":0},null,null,null,null,null,0,0]
[null,{"$f":"B24+1","v":11},null,null,"Other Common Elements Requiring Minor Repairs and Modifications",null,{"$f":"+F25*C25","v":0},null,null,null,null,null,"Other Common Elements Requiring Minor Repairs and Modifications",0]
[]
[null,null,null,null,"Estimate Total Amount Necessary to Correct Current Defects",null,{"$f":"SUM(G15:G26)","v":0},null,null,null,null,null,"Estimate Total Amount Necessary to Correct Current Defects",0]
[]
[null,null,null,null,null,null,null,null,"Abbreviate descriptions for pie chart"]
[null,null,null,null,null,null,null,null,"Pieces of the Pie","Their Future $"]
[null,null,null,null,null,null,null,null,{"$f":"E15","v":"Include a more detailed description of defect here than bulleted lists in the report"},{"$f":"G15","v":0}]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,{"$f":"E25","v":"Other Common Elements Requiring Minor Repairs and Modifications"},{"$f":"G25","v":0}]

{"sheet":"Retrospective","index":3,"n_rows":74,"n_cols":25,"rows_kept":74,"cut":false,"hidden":true,"merged":[[49,1,49,2],[50,1,50,2],[52,1,52,2],[3,6,3,7],[3,8,3,9],[43,2,43,3],[47,1,47,2],[48,1,48,2]]}
[null,null,"RESERVE FUNDING PLAN",null,null,null,null,null,"'FOR INTERNAL USE ONLY, DO NOT INCLUDE IN REPORT"]
[null,null,{"$f":"IF(MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)=\"Funding Plan\",\"\",MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))-13))","v":""},null,null,null,null," ",null,{"$f":"IF(C2=\"Alternate\",\"This Alternate Funding Plan is provided at the request of \"&Client_Representative_s&\" and does not represent the recommendation of Reserve Advisors, Inc.\",\"\")","v":""}]
[]
[null,null,{"$f":"+Expenditures!I4","v":"Southampton"},null,null,null,"Developer Controlled",null,"Association Controlled"]
["Unit",null,{"$f":"+Expenditures!I5","v":"Homeowners Association"},null,null,null,null,null,null,"Individual Reserve Budgets & Cash Flows for the Next 30 Years"]
[null,null,{"$f":"+Expenditures!I6","v":"Charlotte, North Carolina"},{"$f":"E6-1","v":{"$error":"#REF!"}},{"$f":"F6-1","v":{"$error":"#REF!"}},{"$f":"G6-1","v":{"$error":"#REF!"}},{"$f":"H6-1","v":{"$error":"#REF!"}},{"$f":"Current_Fiscal_Year-1","v":{"$error":"#REF!"}},{"$f":"Current_Fiscal_Year","v":{"$error":"#REF!"}},{"$f":"Current_Fiscal_Year+1","v":{"$error":"#REF!"}},{"$f":"J6+1","v":{"$error":"#REF!"}},{"$f":"K6+1","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Reserves at Beginning of Year (Note 1)",null,0,{"$f":"D13","v":{"$error":"#REF!"}},{"$f":"E13","v":{"$error":"#REF!"}},{"$f":"F13","v":{"$error":"#REF!"}},{"$f":"G13","v":{"$error":"#REF!"}},{"$f":"H13","v":{"$error":"#REF!"}},{"$f":"+I13","v":{"$error":"#REF!"}},{"$f":"J13","v":{"$error":"#REF!"}},{"$f":"+K13","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Plus","Reserve Monies Collected / Reserve Contributions",null,{"$f":"E8","v":{"$error":"#REF!"}},{"$f":"F8","v":{"$error":"#REF!"}},{"$f":"G8","v":{"$error":"#REF!"}},{"$f":"H8","v":{"$error":"#REF!"}},{"$f":"contributions_year0","v":{"$error":"#REF!"}},{"$f":"(Remaining_Budgeted_Months/12)*Current_Reserve_Contributions","v":{"$error":"#REF!"}},{"$f":"ROUND(IF(J6=First_Year_of_Recommendation,$S$62+I8,Second_Year_Contribution)/Round_Funding_to,0)*Round_Funding_to","v":{"$error":"#REF!"}},{"$f":"ROUND(IF(K6=First_Year_of_Recommendation,IF(ISBLANK($S$64),$S$62+J8,$S$64+J8),IF(ISBLANK($S$65),J8*(1+$S$60),IF(First_Year_of_Recommendation+$S$65-1>K6,$S$64+J8,J8*(1+$S$60))))/Round_Funding_to,0)*Round_Funding_to","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"           Anticipated Interest Rate",null,{"$f":"Interest","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"Interest","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Plus","Estimated Interest Earned, During Year (Note 3)",null,"n/a","n/a","n/a","n/a","n/a",{"$f":"M60","v":{"$error":"#REF!"}},{"$f":"ROUND(J9*(J7+J11/2+J8/2)/Round_Interest_to,0)*Round_Interest_to","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Less","Anticipated Expenditures, By Year",null,"n/a","n/a","n/a","n/a","n/a",{"$f":"-INDIRECT(\"'\"&$M$59&\"'!_total_year\"&I6-Current_Fiscal_Year)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,"Anticipated Reserves at Year End",null,{"$f":"D7+D8","v":{"$error":"#REF!"}},{"$f":"E7+E8","v":{"$error":"#REF!"}},{"$f":"F7+F8","v":{"$error":"#REF!"}},{"$f":"G7+G8","v":{"$error":"#REF!"}},{"$f":"H7+H8","v":{"$error":"#REF!"}},{"$f":"I7+I8+I10+I11","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"ADJUST BLUE CHART BELOW FOR INCLUSION IN REPORT",null,null,null,null,null,{"$f":"IF($C$2=\"Alternate\",\"\",IF(OR(I6<$M$63,ISBLANK($M$63)),\"\",IF(I13<$M$62+(ABS($M$62)*Multiple_Thresholds),\"(NOTE 5)\",\"\")))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,{"$f":"IF(I15=\"\",\"\",\"Predicted Reserves based on \"&Current_Fiscal_Year&\" funding level of:  \")","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Update*\",Study_Type)),Current_Reserve_Contributions=0),\"\",Current_Reserve_Contributions)","v":{"$error":"#REF!"}},{"$f":"IF(H15=\"\",\"\",I7+$H$15+I11)","v":{"$error":"#REF!"}},{"$f":"IF(OR(I15<0,I15=\"\"),\"\",I15+$H$15+J11)","v":{"$error":"#REF!"}},{"$f":"IF(OR(I15<0,I15=\"\"),\"\",J15+$H$15+K11)","v":{"$error":"#REF!"}},{"$f":"IF(OR(I15<0,I15=\"\"),\"\",K15+$H$15+L11)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,"Enter initial contribution in cell I8, ending balance to be nearly equal to ending balance in reserve study"]
[]
[]
[]
[]
[]
[]
[null,null,"(continued)",null,null,null,null,null,null,"Individual Reserve Budgets & Cash Flows for the Next 30 Years, Continued"]
[null,null,"",null,null,null,null,null,null,{"$f":"X6+1","v":{"$error":"#REF!"}},{"$f":"J24+1","v":{"$error":"#REF!"}},{"$f":"K24+1","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Reserves at Beginning of Year",null,null,null,null,null,null,null,{"$f":"+X13","v":{"$error":"#REF!"}},{"$f":"+J31","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Plus",{"$f":"B8","v":"Reserve Monies Collected / Reserve Contributions"},null,null,null,null,null,null,null,{"$f":"ROUND(IF(J24=First_Year_of_Recommendation,IF(ISBLANK($S$64),$S$62+X8,$S$64+X8),IF(ISBLANK($S$65),X8*(1+$S$60),IF(First_Year_of_Recommendation+$S$65-1>J24,$S$64+X8,X8*(1+$S$60))))/Round_Funding_to,0)*Round_Funding_to","v":{"$error":"#REF!"}},{"$f":"ROUND(IF(K24=First_Year_of_Recommendation,IF(ISBLANK($S$64),$S$62+J26,$S$64+J26),IF(ISBLANK($S$65),J26*(1+$S$60),IF(First_Year_of_Recommendation+$S$65-1>K24,$S$64+J26,J26*(1+$S$60))))/Round_Funding_to,0)*Round_Funding_to","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"           Anticipated Interest Rate",null,null,null,null,null,null,null,{"$f":"Interest","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Plus","Estimated Interest Earned, During Year",null,null,null,null,null,null,null,{"$f":"ROUND(J27*(J25+J29/2+J26/2)/Round_Interest_to,0)*Round_Interest_to","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Less","Anticipated Expenditures, By Year",null,null,null,null,null,null,null,{"$f":"-INDIRECT(\"'\"&$M$59&\"'!_total_year\"&J24-Current_Fiscal_Year)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,"Anticipated Reserves at Year End",null,null,null,null,null,null,null,{"$f":"J25+J26+J28+J29","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"Match this balance to balance from 1RF (1RF balance shown below)"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($C$2=\"Alternate\",\"\",IF(OR(J24<$M$63,ISBLANK($M$63)),\"\",IF(J31<$M$62+(ABS($M$62)*Multiple_Thresholds),\"(NOTE 5)\",\"\")))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($C$2=\"Alternate\",\"\",IF(OR(X24<$M$63,ISBLANK($M$63)),\"(NOTE 4)\",IF(X31<$M$62+(ABS($M$62)*Multiple_Thresholds),\"(NOTES 4&5)\",\"(NOTE 4)\")))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"IF(SUM(J33:X33)=0,\"\",\"Predicted Reserves based on \"&Current_Fiscal_Year&\" funding level of:  \")","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF(SUM(J33:X33)=0,\"\",H15)","v":{"$error":"#REF!"}},null,{"$f":"IF(OR(V15<0,V15=\"\"),\"\",X15+$H$15+J29)","v":{"$error":"#REF!"}},{"$f":"IF(OR(W15<0,W15=\"\"),\"\",J33+$H$15+K29)","v":{"$error":"#REF!"}},{"$f":"IF(OR(X15<0,X15=\"\"),\"\",K33+$H$15+L29)","v":{"$error":"#REF!"}},{"$f":"IF(OR(J33<0,J33=\"\"),\"\",L33+$H$15+M29)","v":{"$error":"#REF!"}},{"$f":"IF(OR(K33<0,K33=\"\"),\"\",M33+$H$15+N29)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Funding Plan'!T35","v":160321.58999999997},"Reserve balance from 1RF"]
[]
["Explanatory Notes:"]
["1) ",{"$f":"\"  Assumes $0 starting reserves as of XXXXXX, the Date of Declaration; Fiscal Year starts \"&Fiscal_Year_Beginning&\" and ends \"&Fiscal_Year_End&\".\"","v":{"$error":"#REF!"}}]
["2) ",{"$f":"Interest","v":{"$error":"#REF!"}},{"$f":"\"is the estimated annual rate of return on invested reserves.\"","v":"is the estimated annual rate of return on invested reserves."}]
["3) ",{"$f":"\"   Accumulated year \"&Current_Fiscal_Year+30&\" ending reserves is similar to the Reserve Funding Plan \"&Current_Fiscal_Year+30&\" balance.\"","v":{"$error":"#REF!"}}]
[null,"EDIT ABOVE NOTES when a PARTIAL YEAR APPLIES TO INTEREST or FY VARIES FROM THE CALENDAR"]
[]
[]
[]
[null,null,"RETROSPECTIVE CASH FLOW ANALYSIS",null,null,null,null,null,"FILL IN DATES"]
[null,null,{"$f":"C4","v":"Southampton"},null,null,null,null,null,"DECLARATION_DATE:","DECLARATION DATE"]
[null,null,{"$f":"C5","v":"Homeowners Association"},null,null,null,null,null,"TURNOVER_DATE:","TURNOVER DATE"]
[null,null,{"$f":"C6","v":"Charlotte, North Carolina"},{"$f":"D6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Reserves at Beginning of Year",null,0,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Plus","Reserve Monies Collected During Year",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Plus","Estimated Interest Earned, During Year",null,{"$f":"D10","v":"n/a"},"n/a","n/a","n/a","n/a"]
["Less","Anticipated Expenditures, By Year",null,"n/a","n/a","n/a","n/a","n/a"]
[null,null,null,"-","-","-","-","-"]
[null,"Anticipated Reserves at Year End",null,{"$f":"D13","v":{"$error":"#REF!"}},{"$f":"E13","v":{"$error":"#REF!"}},{"$f":"F13","v":{"$error":"#REF!"}},{"$f":"G13","v":{"$error":"#REF!"}},{"$f":"H13","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Beginning Reserve Balance Date",{"$f":"[0]!Beginning_Reserve_Balance_Date","v":{"$error":"#REF!"}},null,null,"Expenditures Sheet to use:",{"$f":"IF(C2=\"\",\"Expenditures\",C2&\" Expenditures\")","v":"Expenditures"},null,null,null,null,"First Year of Recommendation:",{"$f":"[0]!First_Year_of_Recommendation","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,"Remaining Budgeted Months",{"$f":"[0]!Remaining_Budgeted_Months","v":{"$error":"#REF!"}},null,null,"Partial Interest:",{"$f":"ROUND((I7+I11/2+I8/2)*((Interest/12)*Remaining_Budgeted_Months)/Round_Interest_to,0)*Round_Interest_to","v":{"$error":"#REF!"}},null,null,null,null,"Inflation Rate:",{"$f":"Inflation","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,"Operating Budget",{"$f":"[0]!Operating_Budget","v":{"$error":"#REF!"}},null,null,"Round Interest to:",{"$f":"Round_Interest_to","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,"Beginning Reserve Balance",{"$f":"[0]!Beginning_Reserve_Balance","v":{"$error":"#REF!"}},null,null,"Threshold Amount",{"$f":"IF(ISBLANK(M63),0,MIN(IF(M63>Current_Fiscal_Year+15,1E+100,MIN(OFFSET($I$13,0,IFERROR(MATCH(M63,I6:X6,0)-1,0),1,16))),MIN(OFFSET($J$31,0,IFERROR(MATCH(M63,J24:X24,0)-1,0),1,16))))","v":{"$error":"#REF!"}},{"$f":"\"+ \"&TEXT(ABS(M62)*Multiple_Thresholds,\"$#,###\")&\" = \"&TEXT(ABS(M62)*Multiple_Thresholds+M62,\"$#,###\")","v":{"$error":"#REF!"}},null,null,null,"Single Increase:"]
[null,null,null,null,null,null,null,"Reserve Balance Projected?",{"$f":"[0]!Reserve_Balance_Projected?","v":{"$error":"#REF!"}},null,null,"Begin Threshold Search at Year:",{"$f":"Current_Fiscal_Year+2","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"\"Current Reserve Contributions FY\"&Current_Fiscal_Year","v":{"$error":"#REF!"}},{"$f":"[0]!Current_Reserve_Contributions","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,"Phased Increase:"]
[null,null,null,null,null,null,null,{"$f":"IF(First_Year_of_Recommendation-Current_Fiscal_Year=1,\"Not Applicable, Leave Blank\",\"Current Reserve Contributions FY\"&Current_Fiscal_Year+1)","v":{"$error":"#REF!"}},{"$f":"[0]!Second_Year_Contribution","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,"Number of Phases:"]
[null,null,null,null,null,null,null,"List Elements to justify end balance",{"$f":"'20 Yr RF'!List_Elements_to_justify_end_balance","v":0},null,null,"# of Thresholds:",{"$f":"COUNTIF(I14:X14,\"(NOTE 5)\")+COUNTIF(J32:W32,\"(NOTE 5)\")+COUNTIF(X32,\"(NOTE 4&5)\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"First Threshold:",{"$f":"IF(M66>0,IFERROR(Current_Fiscal_Year+IFERROR(MATCH(\"(NOTE 5)\",J14:X14,0),MATCH(\"(NOTE 5)\",J32:X32,0)+15),X24),\"\")","v":""}]
[null,null,null,null,null,null,null,"Increase over prior budgeted amount",{"$f":"TEXT((#REF!-$I$64),\"$#,###\")","v":{"$error":"#REF!"}},null,null,"Second Threshold:",{"$f":"IF(M66>1,IFERROR(IF(M67>Current_Fiscal_Year+14,INDEX($24:$32,1,MATCH(\"(NOTE 5)\",$32:$32,0)+MATCH(\"(NOTE 5)\",OFFSET($A$1,35,MATCH(\"(NOTE 5)\",$32:$32,0),1,15),0)),IF(COUNTIF(14:14,\"=(NOTE 5)\")=1,INDEX($24:$32,1,MATCH(\"(NOTE 5)\",$32:$32,0)),INDEX($6:$14,1,MATCH(\"(NOTE 5)\",$14:$14,0)+MATCH(\"(NOTE 5)\",OFFSET($A$1,15,MATCH(\"(NOTE 5)\",$14:$14,0),1,15),0)))),X24),\"\")","v":""}]
[null,null,null,null,null,null,null,"% OB change",{"$f":"TEXT(Contribution_increase/Operating_Budget,\"##%\")","v":{"$error":"#NAME?"}},"Percent",null,"Threshold Statement:",{"$f":"IF(M66=0,\"does not recognize a critical year\",IF(M66=1,\"recognizes this threshold funding year in \"&M67,IF(M66=2, \"recognizes these threshold funding years in \"&M67&\" and \"&M68,IF(M66>2,\"recognizes multiple threshold funding years\",\"Error\"))))","v":"does not recognize a critical year"}]
[null,null,null,null,null,null,null,"Monthly Recommendation Per Unit",{"$f":"TEXT((#REF!/12)/Number_of_Units,\"$#,###.00\")","v":{"$error":"#REF!"}},null,null,"First Year of Negative Balance:",{"$f":"IF(COUNTIF(I15:X15,\"<0\"),INDEX(I6:X15,1,MATCH(TRUE,INDEX(I15:X15<0,0),0)),IF(COUNTIF(J33:X33,\"<0\"),INDEX(J24:X33,1,MATCH(TRUE,INDEX(J33:X33<0,0),0)),\"Not Negative!\"))","v":"Not Negative!"}]
[null,null,null,null,null,null,null,"Current Contributions Per Unit",{"$f":"TEXT((Current_Reserve_Contributions/12)/Number_of_Units,\"$#,###.00\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,"Monthly Difference Per Unit",{"$f":"TEXT(monthly_recommend-current_monthly_contr,\"$#,###.00\")","v":{"$error":"#NAME?"}}]
[]
[null,null,"Funding sentences:"]

{"sheet":"20 Yr RF","index":4,"n_rows":60,"n_cols":15,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
[null,null,"RESERVE FUNDING PLAN"]
[null,null,{"$f":"IF(MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)=\"20 Yr RF\",\"\",MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))-13))","v":""}," ",null,{"$f":"IF(C2=\"Alternate\",\"This Alternate Funding Plan is provided at the request of \"&Client_Representative_s&\" and does not represent the recommendation of Reserve Advisors, Inc.\",\"\")","v":""}]
[null,null,"CASH FLOW ANALYSIS"]
[null,null,{"$f":"+Expenditures!I4","v":"Southampton"}]
["Unit",null,{"$f":"+Expenditures!I5","v":"Homeowners Association"},null,null,"Individual Reserve Budgets & Cash Flows for the Next 20 Years"]
[null,null,{"$f":"+Expenditures!I6","v":"Charlotte, North Carolina"},null,{"$f":"Current_Fiscal_Year","v":{"$error":"#REF!"}},{"$f":"Current_Fiscal_Year+1","v":{"$error":"#REF!"}},{"$f":"F6+1","v":{"$error":"#REF!"}},{"$f":"G6+1","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Reserves at Beginning of Year (Note 1)",null,null,{"$f":"INDIRECT(\"'\"&$D$59&\"'!E7\")","v":80472.59},{"$f":"'Funding Plan'!F7","v":74855.59},{"$f":"'Funding Plan'!G7","v":41965.59},{"$f":"'Funding Plan'!H7","v":25446.589999999997},{"$f":"'Funding Plan'!I7","v":25304.589999999997},{"$f":"'Funding Plan'!J7","v":65546.59},{"$f":"'Funding Plan'!K7","v":59912.59},{"$f":"'Funding Plan'!L7","v":91807.59},{"$f":"'Funding Plan'!M7","v":53136.59},{"$f":"'Funding Plan'!N7","v":41828.589999999997},{"$f":"'Funding Plan'!O7","v":75486.59}]
["Plus","           Recommended Reserve Contributions ",null,null,{"$f":"'Funding Plan'!E8","v":115.375},{"$f":"'Funding Plan'!F8","v":56000},{"$f":"'Funding Plan'!G8","v":56000},{"$f":"'Funding Plan'!H8","v":39000},{"$f":"'Funding Plan'!I8","v":39700},{"$f":"'Funding Plan'!J8","v":40400},{"$f":"'Funding Plan'!K8","v":41100},{"$f":"'Funding Plan'!L8","v":41800},{"$f":"'Funding Plan'!M8","v":42500},{"$f":"'Funding Plan'!N8","v":43200},{"$f":"'Funding Plan'!O8","v":43900}]
["Plus","           Additional Assessment or Additional Reserve Contributions",null,null,{"$f":"'Funding Plan'!E9","v":" "},{"$f":"'Funding Plan'!F9","v":""},{"$f":"'Funding Plan'!G9","v":""},{"$f":"'Funding Plan'!H9","v":""},{"$f":"'Funding Plan'!I9","v":""},{"$f":"'Funding Plan'!J9","v":""},{"$f":"'Funding Plan'!K9","v":""},{"$f":"'Funding Plan'!L9","v":""},{"$f":"'Funding Plan'!M9","v":""},{"$f":"'Funding Plan'!N9","v":""},{"$f":"'Funding Plan'!O9","v":""}]
[null,"Total Recommended Reserve Contributions (Note 2)",null,null,{"$f":"'Funding Plan'!E10","v":0},{"$f":"'Funding Plan'!F10","v":56000},{"$f":"'Funding Plan'!G10","v":56000},{"$f":"'Funding Plan'!H10","v":39000},{"$f":"'Funding Plan'!I10","v":39700},{"$f":"'Funding Plan'!J10","v":40400},{"$f":"'Funding Plan'!K10","v":41100},{"$f":"'Funding Plan'!L10","v":41800},{"$f":"'Funding Plan'!M10","v":42500},{"$f":"'Funding Plan'!N10","v":43200},{"$f":"'Funding Plan'!O10","v":43900}]
[null,"           Anticipated Interest Rate",null,null,{"$f":"'Funding Plan'!E11","v":1.2E-2},{"$f":"'Funding Plan'!F11","v":1.2E-2},{"$f":"'Funding Plan'!G11","v":1.2E-2},{"$f":"'Funding Plan'!H11","v":1.2E-2},{"$f":"'Funding Plan'!I11","v":1.2E-2},{"$f":"'Funding Plan'!J11","v":1.2E-2},{"$f":"'Funding Plan'!K11","v":1.2E-2},{"$f":"'Funding Plan'!L11","v":1.2E-2},{"$f":"'Funding Plan'!M11","v":1.2E-2},{"$f":"'Funding Plan'!N11","v":1.2E-2},{"$f":"'Funding Plan'!O11","v":1.2E-2}]
["Plus","Estimated Interest Earned, During Year (Note 3)",null,null,{"$f":"'Funding Plan'!E12","v":233},{"$f":"'Funding Plan'!F12","v":697},{"$f":"'Funding Plan'!G12","v":402},{"$f":"'Funding Plan'!H12","v":303},{"$f":"'Funding Plan'!I12","v":542},{"$f":"'Funding Plan'!J12","v":748},{"$f":"'Funding Plan'!K12","v":905},{"$f":"'Funding Plan'!L12","v":864},{"$f":"'Funding Plan'!M12","v":566},{"$f":"'Funding Plan'!N12","v":700},{"$f":"'Funding Plan'!O12","v":646}]
["Less","Anticipated Expenditures, By Year",null,null,{"$f":"'Funding Plan'!E13","v":-5850},{"$f":"'Funding Plan'!F13","v":-89587},{"$f":"'Funding Plan'!G13","v":-72921},{"$f":"'Funding Plan'!H13","v":-39445},{"$f":"'Funding Plan'!I13","v":0},{"$f":"'Funding Plan'!J13","v":-46782},{"$f":"'Funding Plan'!K13","v":-10110},{"$f":"'Funding Plan'!L13","v":-81335},{"$f":"'Funding Plan'!M13","v":-54374},{"$f":"'Funding Plan'!N13","v":-10242},{"$f":"'Funding Plan'!O13","v":-87152}]
[null,null,null,null,"-","-","-","-","-","-","-","-","-","-","-"]
[null,"Anticipated Reserves at Year End",null,null,{"$f":"'Funding Plan'!E15","v":74855.59},{"$f":"'Funding Plan'!F15","v":41965.59},{"$f":"'Funding Plan'!G15","v":25446.589999999997},{"$f":"'Funding Plan'!H15","v":25304.589999999997},{"$f":"'Funding Plan'!I15","v":65546.59},{"$f":"'Funding Plan'!J15","v":59912.59},{"$f":"'Funding Plan'!K15","v":91807.59},{"$f":"'Funding Plan'!L15","v":53136.59},{"$f":"'Funding Plan'!M15","v":41828.589999999997},{"$f":"'Funding Plan'!N15","v":75486.59},{"$f":"'Funding Plan'!O15","v":32880.589999999997}]
[null,null,null,null,{"$f":"'Funding Plan'!E16","v":""},{"$f":"'Funding Plan'!F16","v":""},{"$f":"'Funding Plan'!G16","v":"(NOTE 5)"},{"$f":"'Funding Plan'!H16","v":0},{"$f":"'Funding Plan'!I16","v":""},{"$f":"'Funding Plan'!J16","v":""},{"$f":"'Funding Plan'!K16","v":""},{"$f":"'Funding Plan'!L16","v":""},{"$f":"'Funding Plan'!M16","v":""},{"$f":"'Funding Plan'!N16","v":""},{"$f":"'Funding Plan'!O16","v":""}]
[null,null,{"$f":"'Funding Plan'!C17","v":"Predicted Reserves based on 2016 funding level of:  "},{"$f":"'Funding Plan'!D17","v":461.5},{"$f":"'Funding Plan'!E17","v":74855.59},{"$f":"'Funding Plan'!F17","v":-13905.910000000003},{"$f":"'Funding Plan'!G17","v":""},{"$f":"'Funding Plan'!H17","v":""},{"$f":"'Funding Plan'!I17","v":""},{"$f":"'Funding Plan'!J17","v":""},{"$f":"'Funding Plan'!K17","v":""},{"$f":"'Funding Plan'!L17","v":""},{"$f":"'Funding Plan'!M17","v":""},{"$f":"'Funding Plan'!N17","v":""},{"$f":"'Funding Plan'!O17","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"(continued)",null,null,"Individual Reserve Budgets & Cash Flows for the Next 20 Years, Continued"]
[null,null,"",null,null,{"$f":"O6+1","v":{"$error":"#REF!"}},{"$f":"F26+1","v":{"$error":"#REF!"}},{"$f":"G26+1","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Reserves at Beginning of Year",null,null,null,{"$f":"'Funding Plan'!P7","v":32880.589999999997},{"$f":"'Funding Plan'!Q7","v":71481.59},{"$f":"'Funding Plan'!R7","v":111259.59},{"$f":"'Funding Plan'!S7","v":159071.59},{"$f":"'Funding Plan'!T7","v":208262.59},{"$f":"'Funding Plan'!F27","v":211591.59},{"$f":"'Funding Plan'!G27","v":228768.58999999997},{"$f":"'Funding Plan'!H27","v":262073.58999999997},{"$f":"'Funding Plan'!I27","v":137318.58999999997},{"$f":"'Funding Plan'!J27","v":96833.589999999967}]
["Plus","           Recommended Reserve Contributions ",null,null,null,{"$f":"'Funding Plan'!P8","v":44600},{"$f":"'Funding Plan'!Q8","v":45400},{"$f":"'Funding Plan'!R8","v":46200},{"$f":"'Funding Plan'!S8","v":47000},{"$f":"'Funding Plan'!T8","v":47800},{"$f":"'Funding Plan'!F28","v":48600},{"$f":"'Funding Plan'!G28","v":49400},{"$f":"'Funding Plan'!H28","v":50200},{"$f":"'Funding Plan'!I28","v":51100},{"$f":"'Funding Plan'!J28","v":52000}]
["Plus","           Additional Assessment or Additional Reserve Contributions",null,null,null,{"$f":"'Funding Plan'!P9","v":""},{"$f":"'Funding Plan'!Q9","v":""},{"$f":"'Funding Plan'!R9","v":""},{"$f":"'Funding Plan'!S9","v":""},{"$f":"'Funding Plan'!T9","v":""},{"$f":"'Funding Plan'!F29","v":""},{"$f":"'Funding Plan'!G29","v":""},{"$f":"'Funding Plan'!H29","v":""},{"$f":"'Funding Plan'!I29","v":""},{"$f":"'Funding Plan'!J29","v":""}]
[null,"Total Recommended Reserve Contributions ",null,null,null,{"$f":"'Funding Plan'!P10","v":44600},{"$f":"'Funding Plan'!Q10","v":45400},{"$f":"'Funding Plan'!R10","v":46200},{"$f":"'Funding Plan'!S10","v":47000},{"$f":"'Funding Plan'!T10","v":47800},{"$f":"'Funding Plan'!F30","v":48600},{"$f":"'Funding Plan'!G30","v":49400},{"$f":"'Funding Plan'!H30","v":50200},{"$f":"'Funding Plan'!I30","v":51100},{"$f":"'Funding Plan'!J30","v":52000}]
[null,"           Anticipated Interest Rate",null,null,null,{"$f":"'Funding Plan'!P11","v":1.2E-2},{"$f":"'Funding Plan'!Q11","v":1.2E-2},{"$f":"'Funding Plan'!R11","v":1.2E-2},{"$f":"'Funding Plan'!S11","v":1.2E-2},{"$f":"'Funding Plan'!T11","v":1.2E-2},{"$f":"'Funding Plan'!F31","v":1.2E-2},{"$f":"'Funding Plan'!G31","v":1.2E-2},{"$f":"'Funding Plan'!H31","v":1.2E-2},{"$f":"'Funding Plan'!I31","v":1.2E-2},{"$f":"'Funding Plan'!J31","v":1.2E-2}]
["Plus","Estimated Interest Earned, During Year",null,null,null,{"$f":"'Funding Plan'!P12","v":622},{"$f":"'Funding Plan'!Q12","v":1090},{"$f":"'Funding Plan'!R12","v":1612},{"$f":"'Funding Plan'!S12","v":2191},{"$f":"'Funding Plan'!T12","v":2504},{"$f":"'Funding Plan'!F32","v":2626},{"$f":"'Funding Plan'!G32","v":2927},{"$f":"'Funding Plan'!H32","v":2382},{"$f":"'Funding Plan'!I32","v":1397},{"$f":"'Funding Plan'!J32","v":758}]
["Less","Anticipated Expenditures, By Year",null,null,null,{"$f":"'Funding Plan'!P13","v":-6621},{"$f":"'Funding Plan'!Q13","v":-6712},{"$f":"'Funding Plan'!R13","v":0},{"$f":"'Funding Plan'!S13","v":0},{"$f":"'Funding Plan'!T13","v":-46975},{"$f":"'Funding Plan'!F33","v":-34049},{"$f":"'Funding Plan'!G33","v":-19022},{"$f":"'Funding Plan'!H33","v":-177337},{"$f":"'Funding Plan'!I33","v":-92982},{"$f":"'Funding Plan'!J33","v":-119266}]
[null,null,null,null,null,"-","-","-","-","-","-","-","-","-","-"]
[null,"Anticipated Reserves at Year End",null,null,null,{"$f":"'Funding Plan'!P15","v":71481.59},{"$f":"'Funding Plan'!Q15","v":111259.59},{"$f":"'Funding Plan'!R15","v":159071.59},{"$f":"'Funding Plan'!S15","v":208262.59},{"$f":"'Funding Plan'!T15","v":211591.59},{"$f":"'Funding Plan'!F35","v":228768.58999999997},{"$f":"'Funding Plan'!G35","v":262073.58999999997},{"$f":"'Funding Plan'!H35","v":137318.58999999997},{"$f":"'Funding Plan'!I35","v":96833.589999999967},{"$f":"'Funding Plan'!J35","v":30325.589999999967}]
[null,null,null,null,null,{"$f":"'Funding Plan'!P16","v":""},{"$f":"'Funding Plan'!Q16","v":""},{"$f":"'Funding Plan'!R16","v":""},{"$f":"'Funding Plan'!S16","v":""},{"$f":"'Funding Plan'!T16","v":""},{"$f":"'Funding Plan'!F36","v":""},{"$f":"'Funding Plan'!G36","v":""},{"$f":"'Funding Plan'!H36","v":""},{"$f":"'Funding Plan'!I36","v":""},{"$f":"'Funding Plan'!J36","v":"(NOTE 5)"}]
[null,null,{"$f":"IF(SUM(F37:T37)=0,\"\",\"Predicted Reserves based on \"&Current_Fiscal_Year&\" funding level of:  \")","v":""},{"$f":"IF(SUM(F37:T37)=0,\"\",D17)","v":""},null,{"$f":"'Funding Plan'!P17","v":""},{"$f":"'Funding Plan'!Q17","v":""},{"$f":"'Funding Plan'!R17","v":""},{"$f":"'Funding Plan'!S17","v":""},{"$f":"'Funding Plan'!T17","v":""},{"$f":"'Funding Plan'!F37","v":""},{"$f":"'Funding Plan'!G37","v":""},{"$f":"'Funding Plan'!H37","v":""},{"$f":"'Funding Plan'!I37","v":""},{"$f":"'Funding Plan'!J37","v":""}]
[]
[]
[]
["Explanatory Notes:"]
["1) ",{"$f":"'Funding Plan'!B42","v":"Year 2016 starting reserves are as of September 30, 2016; FY2016 starts January 1, 2016 and ends December 31, 2016."}]
["2) ",{"$f":"'Funding Plan'!B43","v":"Reserve Contributions for 2016 are already contributed; 2017 is the first year of recommended contributions."}]
["3) ",{"$f":"'Funding Plan'!B44","v":1.2E-2},{"$f":"'Funding Plan'!C44","v":"is the estimated annual rate of return on invested reserves; 2016 is a partial year of interest earned."}]
[{"$f":"IF(C2=\"Alternate\",\"\",\"4) \")","v":"4) "},{"$f":"'Funding Plan'!B45","v":"Accumulated year 2046 ending reserves consider the age, size, overall condition and complexity of the property."}]
[{"$f":"'Funding Plan'!A46","v":"5) "},{"$f":"'Funding Plan'!B46","v":"Threshold Funding Years (reserve balance at critical point)."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Funding plan to copy:","Funding Plan","<-- this currently doesn't work… use search and replace if needing multiple funding plans"]
[null,null,"Funding plan footer:",{"$f":"INDIRECT(\"'\"&$D$59&\"'!Footer_Funding\")","v":{"$error":"#REF!"}}]