{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Property Info","Expenditures","Funding Plan"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":88,"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":"Property Info","index":0,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,0,28,8]]}
["Version","v6.0"]
["Name","Avondale Run Homeowners Association, Inc."]
["City","Westminster"]
["State","Maryland"]
["Reference Number","232760",null,null,null," Expenditures Plan","Current Reserve Balance",{"$f":"Current_Fiscal_Year&\" Budgeted Contribution\"","v":"2023 Budgeted Contribution"},{"$f":"Current_Fiscal_Year + 1&\" Budgeted Contribution\"","v":"2024 Budgeted Contribution"}]
["Length of Study (Years)",30,null,null,null,"Funding Plan",82970.98000000001,0,"Not Budgeted"]
["Number of Units",110]
["Number of Buildings",18]
["Date of Inspection","2023-10-26"]
["Current Fiscal Year",2023]
["Fiscal Year Beginning","2023-01-01"]
["First Year of Recommendation",2024]
["Remaining Budgeted Month",2]
["Remaining Months of Interest",2]
["Beginning Reserve Balance Date","2023-10-26"]
["Is Balance Projected?","No"]
["Near Term Inflation",0.03]
["Last Year of Near Term Inflation",2064]
["Remaining Study Inflation",0.03]
["Interest",0.02]
["Frequency of Contributions",12]
["Currency Symbol","$"]
["Values rounded by",1]
["Total Operating Budget",34120]
["Property Type","homeowners association"]
[]
["© 2023 Reserve Advisors LLC. All rights reserved. Any unauthorized copying, alteration, distribution, transmission, display or other use of this spreadsheet and its contents, data or formula are strictly prohibited. This spreadsheet is licensed to you pursuant to (and is subject in all respects to the terms and conditions of) your agreement with Reserve Advisors LLC.  Reserve Advisors LLC does not make, and expressly disclaims, any representations or warranties (express or implied), including, without limitation, as to the accuracy or timeliness of information prepared by you or any third parties, whether linked to this spreadsheet or incorporated herein. We encourage you to contact us at www.reserveadvisors.com with any questions."]

{"sheet":"Expenditures","index":1,"n_rows":18,"n_cols":54,"rows_kept":18,"cut":false,"hidden":false,"merged":[[6,17,6,20],[6,15,6,16],[7,15,7,16]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"RESERVE EXPENDITURES",null,null,null,null,null,null,null,null,null,null,"Inflation Notes:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1)",{"$f":"IF(Inflation=secondaryInflation,Inflation,secondaryInflation)","v":0.03},{"$f":"IF(Inflation=secondaryInflation,\"is the estimated Inflation Rate for estimating Future Replacement Costs.\",\"is the estimated Inflation Rate through \"&secondaryInflationYear&\".\")","v":"is the estimated Inflation Rate for estimating Future Replacement Costs."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Avondale Run",null,null,null,null,null,null,null,null,null,"2)","FY2023 is Fiscal Year beginning January 1, 2023 and ending December 31, 2023."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Homeowners Association, Inc.",null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Westminster, Maryland",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,"Costs, $",null,null,null,null,"Percentage",{"$f":"IF(secondaryInflationYear>=X$9,secondaryInflation,Inflation)","v":0.03},0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
[null,"Partial","Frequency","Length","Events","Next Full","Useful","Round",null,"Line","Total","Per Phase",null,null,"1st Year of","Years",null,"Unit","Percentage","Per Phase","Total","30-Year Total","of Future",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]
[null,"Quantity","of Events","of Phase","Per Phase"," Repl.","Life","Phase",null,"Item","Quantity","Quantity","Units","Reserve Component Inventory","Event","Useful","Remaining","(2023)","Ownership","(2023)","(2023)","(Inflated)","Expenditures",2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053]
[null,null,null,"-","-","-","-",null,null,"-",null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Property Site Elements"]
[null,1,1,{"$f":"((E12-1)*C12)+1","v":1},1,2030,15,0.01,null,4.04,5400,{"$f":"IF(M12=\"Allowance\",1,ROUND((K12*B12/E12/H12),0)*H12)","v":5400},"Square Yards","Asphalt Pavement, Repaving, Parking Areas",{"$f":"Current_Fiscal_Year+MATCH(TRUE,INDEX($X12:$BB12<>\"\",0),0)-1","v":2030},"15 to 20",{"$f":"O12-Current_Fiscal_Year&IF(B12<1,\" to \"&Study_Length&\"+\",IF( E12>1,\" to \"&IF(O12-Current_Fiscal_Year+D12-1>Study_Length,Study_Length&\"+\",O12-Current_Fiscal_Year+D12-1),\"\"))","v":"7"},18.5,1,{"$f":"L12*R12*S12","v":99900},{"$f":"K12*R12*S12","v":99900},{"$f":"SUM(OFFSET(X12,,,1,Study_Length+1))","v":314283},{"$f":"V12/Total_Study_Expenditures","v":0.5856332280515415},{"$f":"TIMING(\"yes\",1,$L12,$R12,$S12,X$7,X$8,secondaryInflation,secondaryInflationYear,Current_Fiscal_Year,$D12,$E12,$F12-Current_Fiscal_Year,$G12,1)","v":""},"","","","","","",122864,"","",{"$f":"TIMING(\"yes\",1,$L12,$R12,$S12,AH$7,AH$8,secondaryInflation,secondaryInflationYear,Current_Fiscal_Year,$D12,$E12,$F12-Current_Fiscal_Year,$G12,1)","v":""},"","","","","","","","","",{"$f":"TIMING(\"yes\",1,$L12,$R12,$S12,AR$7,AR$8,secondaryInflation,secondaryInflationYear,Current_Fiscal_Year,$D12,$E12,$F12-Current_Fiscal_Year,$G12,1)","v":""},"",191419,"","","","","","","",""]
[null,0.3,1,1,2,2030,15,10,null,4.1100000000000003,4400,{"$f":"IF(M13=\"Allowance\",1,ROUND((K13*B13/E13/H13),0)*H13)","v":660},"Linear Feet","Concrete Curbs and Gutters, Partial",{"$f":"Current_Fiscal_Year+MATCH(TRUE,INDEX($X13:$BB13<>\"\",0),0)-1","v":2030},"to 65",{"$f":"O13-Current_Fiscal_Year&IF(B13<1,\" to \"&Study_Length&\"+\",IF( E13>1,\" to \"&IF(O13-Current_Fiscal_Year+D13-1>Study_Length,Study_Length&\"+\",O13-Current_Fiscal_Year+D13-1),\"\"))","v":"7 to 30+"},36,1,{"$f":"L13*R13*S13","v":23760},{"$f":"K13*R13*S13","v":158400},{"$f":"SUM(OFFSET(X13,,,1,Study_Length+1))","v":74749},0.13928687890730543,"","","","","","","",29222,"","","","","","","","","","","","","","",45527,"","","","","","","",""]
[null,0.4,1,1,6,2027,5,10,null,4.1399999999999997,15000,{"$f":"IF(M14=\"Allowance\",1,ROUND((K14*B14/E14/H14),0)*H14)","v":1000},"Square Feet","Concrete Sidewalks, Partial",{"$f":"Current_Fiscal_Year+MATCH(TRUE,INDEX($X14:$BB14<>\"\",0),0)-1","v":2027},"to 65",{"$f":"O14-Current_Fiscal_Year&IF(B14<1,\" to \"&Study_Length&\"+\",IF( E14>1,\" to \"&IF(O14-Current_Fiscal_Year+D14-1>Study_Length,Study_Length&\"+\",O14-Current_Fiscal_Year+D14-1),\"\"))","v":"4 to 30+"},11.5,1,{"$f":"L14*R14*S14","v":11500},{"$f":"K14*R14*S14","v":172500},{"$f":"SUM(OFFSET(X14,,,1,Study_Length+1))","v":115986},0.21612767979428124,"","","","",12943,"","","","",15005,"","","","",17395,"","","","",20165,"","","","",23377,"","","","",27101,""]
[null,1,1,{"$f":"((E15-1)*C15)+1","v":1},1,2031,20,0.01,null,4.8,1,{"$f":"IF(M15=\"Allowance\",1,ROUND((K15*B15/E15/H15),0)*H15)","v":1},"Each","Signage, Property Identification",{"$f":"Current_Fiscal_Year+MATCH(TRUE,INDEX($X15:$BB15<>\"\",0),0)-1","v":2031},"15 to 20",{"$f":"O15-Current_Fiscal_Year&IF(B15<1,\" to \"&Study_Length&\"+\",IF( E15>1,\" to \"&IF(O15-Current_Fiscal_Year+D15-1>Study_Length,Study_Length&\"+\",O15-Current_Fiscal_Year+D15-1),\"\"))","v":"8"},8900,1,{"$f":"L15*R15*S15","v":8900},{"$f":"K15*R15*S15","v":8900},{"$f":"SUM(OFFSET(X15,,,1,Study_Length+1))","v":31637},{"$f":"V15/Total_Study_Expenditures","v":5.8952213246871825E-2},"","","","","","","","",11274,"","","","","","","","","","","","","","","","","","","",20363,"",""]
[]
[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":"\"Anticipated Expenditures, By Year (\"&Currency_Symbol&TEXT($V$18,\"#,##0\")&\" over \"&Study_Length&\" years)\"","v":"Anticipated Expenditures, By Year ($536,655 over 30 years)"},null,null,null,null,null,null,null,{"$f":"SUM(OFFSET(X18,,,1,Study_Length+1))","v":536655},null,{"$f":"SUM(X10:X17)","v":0},{"$f":"SUM(Y10:Y17)","v":0},{"$f":"SUM(Z10:Z17)","v":0},{"$f":"SUM(AA10:AA17)","v":0},{"$f":"SUM(AB10:AB17)","v":12943},{"$f":"SUM(AC10:AC17)","v":0},{"$f":"SUM(AD10:AD17)","v":0},{"$f":"SUM(AE10:AE17)","v":152086},{"$f":"SUM(AF10:AF17)","v":11274},{"$f":"SUM(AG10:AG17)","v":15005},{"$f":"SUM(AH10:AH17)","v":0},{"$f":"SUM(AI10:AI17)","v":0},{"$f":"SUM(AJ10:AJ17)","v":0},{"$f":"SUM(AK10:AK17)","v":0},{"$f":"SUM(AL10:AL17)","v":17395},{"$f":"SUM(AM10:AM17)","v":0},{"$f":"SUM(AN10:AN17)","v":0},{"$f":"SUM(AO10:AO17)","v":0},{"$f":"SUM(AP10:AP17)","v":0},{"$f":"SUM(AQ10:AQ17)","v":20165},{"$f":"SUM(AR10:AR17)","v":0},{"$f":"SUM(AS10:AS17)","v":0},{"$f":"SUM(AT10:AT17)","v":236946},{"$f":"SUM(AU10:AU17)","v":0},{"$f":"SUM(AV10:AV17)","v":23377},{"$f":"SUM(AW10:AW17)","v":0},{"$f":"SUM(AX10:AX17)","v":0},{"$f":"SUM(AY10:AY17)","v":0},{"$f":"SUM(AZ10:AZ17)","v":20363},{"$f":"SUM(BA10:BA17)","v":27101},{"$f":"SUM(BB10:BB17)","v":0}]

{"sheet":"Funding Plan","index":2,"n_rows":191,"n_cols":36,"rows_kept":191,"cut":false,"hidden":false,"merged":[[74,10,75,10],[50,10,52,18],[53,10,55,10],[56,10,57,10],[58,10,59,10],[60,10,61,10],[62,10,63,10],[53,11,55,11],[56,11,57,11],[58,11,59,11],[60,11,61,11],[64,10,65,10],[66,10,67,10],[68,10,69,10],[70,10,71,10],[72,10,73,10],[74,11,75,11],[53,12,55,12],[56,12,57,12],[58,12,59,12],[60,12,61,12],[62,12,63,12],[64,12,65,12],[66,12,67,12],[68,12,69,12],[70,12,71,12],[62,11,63,11],[64,11,65,11],[66,11,67,11],[68,11,69,11],[70,11,71,11],[72,11,73,11],[72,12,73,12],[74,12,75,12],[53,13,55,13],[56,13,57,13],[58,13,59,13],[60,13,61,13],[62,13,63,13],[64,13,65,13],[66,13,67,13],[68,13,69,13],[70,13,71,13],[72,13,73,13],[74,13,75,13],[53,14,55,14],[56,14,57,14],[58,14,59,14],[60,14,61,14],[62,14,63,14],[64,14,65,14],[66,14,67,14],[68,14,69,14],[70,14,71,14],[72,14,73,14],[74,14,75,14],[53,15,55,15],[56,15,57,15],[58,15,59,15],[60,15,61,15],[62,15,63,15],[64,15,65,15],[53,16,55,16],[56,16,57,16],[58,16,59,16],[60,16,61,16],[62,16,63,16],[72,16,73,16],[74,16,75,16],[66,15,67,15],[68,15,69,15],[70,15,71,15],[72,15,73,15],[74,15,75,15],[64,17,65,17],[64,16,65,16],[66,16,67,16],[68,16,69,16],[70,16,71,16],[53,17,55,17],[56,17,57,17],[58,17,59,17],[60,17,61,17],[62,17,63,17],[53,18,55,18],[56,18,57,18],[58,18,59,18],[60,18,61,18],[62,18,63,18],[74,18,75,18],[66,17,67,17],[68,17,69,17],[70,17,71,17],[72,17,73,17],[74,17,75,17],[64,18,65,18],[66,18,67,18],[68,18,69,18],[70,18,71,18],[72,18,73,18]]}
[null,null,"RESERVE FUNDING PLAN"]
[null,null,"",null,""]
[null,null,"CASH FLOW ANALYSIS",null,""]
[null,null,"Avondale Run"]
["Unit",null,"Homeowners Association, Inc.",null,null,"Individual Reserve Budgets & Cash Flows for the Next 30 Years"]
[null,null,"Westminster, Maryland",null,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038]
[null,"Reserves at Beginning of Year",null,"(Note 1)",{"$f":"IF(Reserve_Balance_Projected?=\"Yes\",\"N/A\",Funding_Plan_Balance)","v":82970.98000000001},{"$f":"E16","v":83247.98000000001},97335.98000000001,112109.98000000001,127582.98000000001,130696.98000000001,147349.98000000001,164739.98000000001,29274.98000000001,33724.98000000001,34999.98000000001,51960.98000000001,69765.98000000001,88431.98000000001,107976.98000000001,110848.98000000001]
[null,null,"Recommended Reserve Contributions ",null,{"$f":"IF(Reserve_Balance_Projected?=\"Yes\",\"N/A\",Funding_Plan_CurrentContrib/Frequency_of_Contributions_Number*Remaining_Budgeted_Months)","v":0},{"$f":"IF(First_Year_of_Recommendation=Current_Fiscal_Year+2,E160,E161)","v":12300},12700,13100,13500,13900,14300,14700,15100,15600,16100,16600,17100,17600,18100,18600]
[null,null,"Additional Reserve Contributions",null,"","","","","","","","","","","","","","","",""]
[null,null,"Additional Assessment",null,"","","","","","","","","","","","","","","",""]
[null,"Total Recommended Reserve Contributions",null,"(Note 2)",{"$f":"IF(Reserve_Balance_Projected?=\"Yes\",\"N/A\",SUM(E8,E9,E10))","v":0},{"$f":"SUM(F8,F9,F10)","v":12300},12700,13100,13500,13900,14300,14700,15100,15600,16100,16600,17100,17600,18100,18600]
[null,"           Anticipated Interest Rate",null,null,{"$f":"Interest","v":0.02},0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[null,"Estimated Interest Earned, During Year",null,"(Note 3)",{"$f":"IF(Reserve_Balance_Projected?=\"Yes\",\"N/A\",ROUND(E12*(E7+E14/2+E11/2)*(Remaining_Interest_Months/12),0))","v":277},{"$f":"ROUND(F12*(F7+F14/2+F11/2),0)","v":1788},2074,2373,2557,2753,3090,1921,624,680,861,1205,1566,1945,2167,2403]
[null,"Anticipated Expenditures, By Year",null,null,{"$f":"IF(Reserve_Balance_Projected?=\"Yes\",\"N/A\",-expenditures0)","v":0},{"$f":"-expenditures1","v":0},{"$f":"-expenditures2","v":0},{"$f":"-expenditures3","v":0},{"$f":"-expenditures4","v":-12943},{"$f":"-expenditures5","v":0},{"$f":"-expenditures6","v":0},{"$f":"-expenditures7","v":-152086},{"$f":"-expenditures8","v":-11274},{"$f":"-expenditures9","v":-15005},{"$f":"-expenditures10","v":0},{"$f":"-expenditures11","v":0},{"$f":"-expenditures12","v":0},{"$f":"-expenditures13","v":0},{"$f":"-expenditures14","v":-17395},{"$f":"-expenditures15","v":0}]
[null,null,null,null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,"Anticipated Reserves at Year End",null,null,{"$f":"IF(Reserve_Balance_Projected?=\"Yes\",Funding_Plan_Balance,SUM(E7,E11,E13,E14))","v":83247.98000000001},{"$f":"SUM(F7,F11,F13,F14)","v":97335.98000000001},112109.98000000001,127582.98000000001,130696.98000000001,147349.98000000001,164739.98000000001,29274.98000000001,33724.98000000001,34999.98000000001,51960.98000000001,69765.98000000001,88431.98000000001,107976.98000000001,110848.98000000001,131851.98000000001]
[null,null,null,null,"","","","","","","","(NOTE 5)","","","","","","","",""]
[null,null,"Predicted Reserves based on 2023 funding level of:  ",0,83247.98000000001,84912.98000000001,86610.98000000001,88342.98000000001,77036.98000000001,78577.98000000001,80149.98000000001,-71854.01999999999,-84678.01999999999,"","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[null,null,"(continued)",null,null,"Individual Reserve Budgets & Cash Flows for the Next 30 Years, Continued"]
[null,null,"",null,null,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053]
[null,"Reserves at Beginning of Year",null,null,null,{"$f":"T16","v":131851.98000000001},{"$f":"F37","v":153880.98000000001},176956.98,201099.98,205964.98,231899.98,258959.98,47952.979999999981,72747.979999999981,75134.979999999981,101887.97999999998,129882.97999999998,159245.97999999998,169436.97999999998,173834.97999999998]
[null,null,"Recommended Reserve Contributions ",null,null,19200,19800,20400,21000,21600,22200,22900,23600,24300,25000,25700,26500,27300,28100,28900]
[null,null,"Additional Reserve Contributions",null,null,"","","","","","","","","","","","","","",""]
[null,null,"Additional Assessment",null,null,"","","","","","","","","","","","","","",""]
[null,"Total Recommended Reserve Contributions ",null,null,null,{"$f":"SUM(F29,F30,F31)","v":19200},19800,20400,21000,21600,22200,22900,23600,24300,25000,25700,26500,27300,28100,28900]
[null,"           Anticipated Interest Rate",null,null,null,{"$f":"Interest","v":0.02},0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[null,"Estimated Interest Earned, During Year",null,null,null,{"$f":"ROUND(F33*(F28+F35/2+F32/2),0)","v":2829},3276,3743,4030,4335,4860,3039,1195,1464,1753,2295,2863,3254,3399,3766]
[null,"Anticipated Expenditures, By Year",null,null,null,{"$f":"-expenditures16","v":0},{"$f":"-expenditures17","v":0},{"$f":"-expenditures18","v":0},{"$f":"-expenditures19","v":-20165},{"$f":"-expenditures20","v":0},{"$f":"-expenditures21","v":0},{"$f":"-expenditures22","v":-236946},{"$f":"-expenditures23","v":0},{"$f":"-expenditures24","v":-23377},{"$f":"-expenditures25","v":0},{"$f":"-expenditures26","v":0},{"$f":"-expenditures27","v":0},{"$f":"-expenditures28","v":-20363},{"$f":"-expenditures29","v":-27101},{"$f":"-expenditures30","v":0}]
[null,null,null,null,null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,"Anticipated Reserves at Year End",null,null,null,{"$f":"SUM(F28,F32,F34,F35)","v":153880.98000000001},176956.98,201099.98,205964.98,231899.98,258959.98,47952.979999999981,72747.979999999981,75134.979999999981,101887.97999999998,129882.97999999998,159245.97999999998,169436.97999999998,173834.97999999998,206500.97999999998]
[null,null,null,null,null,"","","",null,"","","(NOTE 5)","","","","","","","","(NOTE 4)"]
[null,null,"","",null,"","","","","","","","","","","","","","",""]
[]
[]
[]
[null,"Explanatory Notes:"]
["1)","Year 2023 starting reserves are as of October 26, 2023; FY2023 starts January 1, 2023 and ends December 31, 2023."]
["2)",{"$f":"IF(Remaining_Budgeted_Months=0,\"\",IF(Remaining_Budgeted_Months/Frequency_of_Contributions_Number=1,\"Reserve Contributions for \"&Current_Fiscal_Year&\" are budgeted; \",\"Reserve Contributions for \"&Current_Fiscal_Year&\" are the remaining budgeted; \"))&IF(First_Year_of_Recommendation=Current_Fiscal_Year+1,First_Year_of_Recommendation&\" is the first year of recommended contributions.\",Current_Fiscal_Year+1&\" contributions are budgeted; \"&First_Year_of_Recommendation&\" is the first year of recommended contributions.\")","v":"Reserve Contributions for 2023 are the remaining budgeted; 2024 is the first year of recommended contributions."}]
["3)",{"$f":"[0]!Interest","v":0.02},{"$f":"\"is the estimated annual rate of return on invested reserves\"&IF(Remaining_Interest_Months<12,CONCATENATE(\"; \",Current_Fiscal_Year,\" is a partial year of interest earned.\"),\".\")","v":"is the estimated annual rate of return on invested reserves; 2023 is a partial year of interest earned."}]
["4)","Accumulated year 2053 ending reserves consider the need to fund for repaving of the asphalt pavement parking areas shortly after 2053, and the age, size, overall condition and complexity of the property."]
[{"$f":"IF(OR(COUNTIF(A1:T40,\"(NOTE 5)\")>0,COUNTIF(A1:T40,\"(NOTES 4&5)\")>0),\"5)\",\"\")","v":"5)"},{"$f":"IF(OR(COUNTIF(A1:T40,\"(NOTE 5)\")>0,COUNTIF(A1:T40,\"(NOTES 4&5)\")>0),\"Threshold Funding Year (reserve balance at critical point).\",\"\")","v":"Threshold Funding Year (reserve balance at critical point)."}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Recommended Reserve Funding Table"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Year","Reserve Contributions","Reserve Balances","Year","Reserve Contributions","Reserve Balances","Year","Reserve Contributions","Reserve Balances"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Current_Fiscal_Year+1","v":2024},{"$f":"F11","v":12300},{"$f":"F16","v":97335.98000000001},{"$f":"K57+10","v":2034},{"$f":"P11","v":16600},{"$f":"P16","v":69765.98000000001},{"$f":"N57+10","v":2044},{"$f":"K32","v":22200},{"$f":"K37","v":258959.98}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K57+1","v":2025},{"$f":"G11","v":12700},{"$f":"G16","v":112109.98000000001},{"$f":"N57+1","v":2035},{"$f":"Q11","v":17100},{"$f":"Q16","v":88431.98000000001},{"$f":"Q57+1","v":2045},{"$f":"L32","v":22900},{"$f":"L37","v":47952.979999999981}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K59+1","v":2026},{"$f":"H11","v":13100},{"$f":"H16","v":127582.98000000001},{"$f":"N59+1","v":2036},{"$f":"R11","v":17600},{"$f":"R16","v":107976.98000000001},{"$f":"Q59+1","v":2046},{"$f":"M32","v":23600},{"$f":"M37","v":72747.979999999981}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K61+1","v":2027},{"$f":"I11","v":13500},{"$f":"I16","v":130696.98000000001},{"$f":"N61+1","v":2037},{"$f":"S11","v":18100},{"$f":"S16","v":110848.98000000001},{"$f":"Q61+1","v":2047},{"$f":"N32","v":24300},{"$f":"N37","v":75134.979999999981}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K63+1","v":2028},{"$f":"J11","v":13900},{"$f":"J16","v":147349.98000000001},{"$f":"N63+1","v":2038},{"$f":"T11","v":18600},{"$f":"T16","v":131851.98000000001},{"$f":"Q63+1","v":2048},{"$f":"O32","v":25000},{"$f":"O37","v":101887.97999999998}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K65+1","v":2029},{"$f":"K11","v":14300},{"$f":"K16","v":164739.98000000001},{"$f":"N65+1","v":2039},{"$f":"F32","v":19200},{"$f":"F37","v":153880.98000000001},{"$f":"Q65+1","v":2049},{"$f":"P32","v":25700},{"$f":"P37","v":129882.97999999998}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K67+1","v":2030},{"$f":"L11","v":14700},{"$f":"L16","v":29274.98000000001},{"$f":"N67+1","v":2040},{"$f":"G32","v":19800},{"$f":"G37","v":176956.98},{"$f":"Q67+1","v":2050},{"$f":"Q32","v":26500},{"$f":"Q37","v":159245.97999999998}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K69+1","v":2031},{"$f":"M11","v":15100},{"$f":"M16","v":33724.98000000001},{"$f":"N69+1","v":2041},{"$f":"H32","v":20400},{"$f":"H37","v":201099.98},{"$f":"Q69+1","v":2051},{"$f":"R32","v":27300},{"$f":"R37","v":169436.97999999998}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K71+1","v":2032},{"$f":"N11","v":15600},{"$f":"N16","v":34999.98000000001},{"$f":"N71+1","v":2042},{"$f":"I32","v":21000},{"$f":"I37","v":205964.98},{"$f":"Q71+1","v":2052},{"$f":"S32","v":28100},{"$f":"S37","v":173834.97999999998}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K73+1","v":2033},{"$f":"O11","v":16100},{"$f":"O16","v":51960.98000000001},{"$f":"N73+1","v":2043},{"$f":"J32","v":21600},{"$f":"J37","v":231899.98},{"$f":"Q73+1","v":2053},{"$f":"T32","v":28900},{"$f":"T37","v":206500.97999999998}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"Funding_Plan_CurrentContrib","v":0},{"$f":"Funding_Plan_NextContrib","v":"Not Budgeted"},12300,12700,13100,13500,13900,14300,14700,15100,15600,16100,16600,17100,17600,18100,18600]
[null,null,null,null,12300]
[]
[null,null,null,null,null,19200,19800,20400,21000,21600,22200,22900,23600,24300,25000,25700,26500,27300,28100,28900]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,206500.97999999998]
[null,null,null,null,null,{"$f":"Current_Fiscal_Year + 1","v":2024},{"$f":"F167 + 1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053]
[null,null,null,null,null,"standard","standard","standard","standard","standard","standard","standard","standard","standard","standard","standard","standard","standard","standard","standard","standard","standard","standard","standard","standard","standard","standard","standard","standard","standard","standard","standard","standard","standard","standard"]
[null,null,null,null,null,12300]
[null,null,null,null,null,12300]
[]
[null,null,null,null,"Year",{"$f":"E6","v":2023},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,{"$f":"F27","v":2039},2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053]
[null,null,null,null,"Reserve Expenditures",{"$f":"E14/1000","v":0},0,0,0,-12.943,0,0,-152.08600000000001,-11.273999999999999,-15.005000000000001,0,0,0,0,-17.395,0,{"$f":"F35/1000","v":0},0,0,-20.164999999999999,0,0,-236.946,0,-23.376999999999999,0,0,0,-20.363,-27.100999999999999,0]
[null,null,null,null,"Recommended Reserve Contributions",{"$f":"E8/1000","v":0},12.3,12.7,13.1,13.5,13.9,14.3,14.7,15.1,15.6,16.100000000000001,16.600000000000001,17.100000000000001,17.600000000000001,18.100000000000001,18.600000000000001,{"$f":"F29/1000","v":19.2},19.8,20.399999999999999,21,21.6,22.2,22.9,23.6,24.3,25,25.7,26.5,27.3,28.1,28.9]
[null,null,null,null,"Additional Reserve Contributions",{"$f":"E9/1000","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,"Additional Assessment",{"$f":"E10/1000","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,"Year-End Reserve Balance",{"$f":"E16/1000","v":83.247980000000013},97.335980000000006,112.10998000000001,127.58298000000001,130.69698,147.34998000000002,164.73998,29.27498000000001,33.724980000000009,34.999980000000008,51.960980000000013,69.765980000000013,88.43198000000001,107.97698000000001,110.84898000000001,131.85198,{"$f":"F37/1000","v":153.88098000000002},176.95698000000002,201.09998000000002,205.96498,231.89998,258.95998000000003,47.952979999999982,72.747979999999984,75.134979999999985,101.88797999999998,129.88297999999998,159.24597999999997,169.43697999999998,173.83497999999997,206.50097999999997]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"This funding plan comprises the following sheets:"]
[null,null,"Expenditures"]