Each Reserve Fund Study includes the following spreadsheets:
Cost Life Data
Includes each common property component and includes current replacement costs, expected life, actual age, effective age (same as actual, or credited/penalized depending on condition of component), and annual replacement cost.
Cost Life Analysis
Includes each common property component and illustrates the percentage of the Reserve Fund each component utilizes, the amount of funds accumulated for each component based on current bank balance, the expired equity of each component based on the age of component and the existing shortfall.
It is important to know that every reserve fund has a shortfall as typically reserve funds are not working on a fully funded model as is the actual reason to have a reserve fund so that you know when the critical year is (when you need the most amount of money).
Present Course
Includes the Opening Balance (determined by the board – sometimes based on the fiscal year or current with the time the Reserve Fund report is being completed), Expenses (including inflation) over the next 30 years, Interest earned on investments, Current Annual Contributions, Additional Contributions, and Closing Balance.
This spreadsheet illustrates whether the existing funding requirements are sufficient and if additional contribution increases are required.
Reasonable & Sufficient
Includes the Opening Balance (determined by the board – sometimes based on the fiscal year or current with the time the Reserve Fund report is being completed), Expenses (including inflation) over the next 30 years, Interest earned on investments, Current Annual Contributions, Additional Contributions, and Closing Balance.
This spreadsheet illustrates recommended contribution increases based on the critical years of expenses in the future. If sufficient funds are not available for projects in the future, additional contribution increases are recommended (increased condo fees, special levies, surplus funds from operating, etc.)
30-Year Replacement Schedule
Includes all common property components and indicates reserve fund expenses required over the next 30 years. The funds carried are a guide. The best way to carry the most accurate numbers in a Reserve Fund, in particular for expenses in the next five years, would be to obtain quotes from the service industry and carry these amounts in the reporting. This is even more applicable at this time due to the economy and Covid-19 as pricing has changed quite a bit in the last couple of years and is sometimes difficult to determine an accurate number to carry without a quote.