Sample Reserve Study Your City, Your State February 01, 2003

Sample Reserve Study
Your City, Your State
Account Sample Reserve Study -- Version 7.0 (2003)
February 01, 2003
Reserve Analyst
P.O. Box 797
Vernon, AZ 85940
Phone: 800-561-0173
Fax: 928-537-3377
Prepared By
Quality Check By
Reserve Analyst Report
Sample Homeowner’s Association
Your City, Your State
Account Sample - Version 7.0 (2003)
February 1, 2003
This is an alternate cover page for this report.
Any style of page, including the cover, can be included
in your report.
Reserve Analyst
Software for the Reserve Professional
P.O. Box 1312
Show Low, AZ 85902
Phone: 800-561-0173
Fax: 928-537-3377
www.reserveanalyst.com
TABLE OF CONTENTS
Part I • Information About Your Reserve Study
Important Information
1-1
Introduction
1-2
Funding Options
1-2
Types of Reserve Studies
1-3
Developing a Component List
1-3
Operational Expenses
1-4
Reserve Expenses
1-4
Funding Methods
1-5
Funding Strategies
1-6
Distribution of Reserves
1-7
User’s Guide to Your Reserve Study
1-9
Definitions
1-9
Your Reserve Study is a Multi-Purpose Tool
1-13
Part II • Your Reserve Study
Current Assessment Funding Model Summary
2-1
Current Assessment Funding Model Projection
2-2
Current Funding Model & Fully Funded Comparison Chart
2-3
Program Features & Benefits - Page 1
2-4
Threshold Funding Model Summary
2-5
Threshold Funding Model Projection
2-6
Threshold Funding Model & Fully Funded Comparison Chart
2-7
Component Funding Model Summary
2-8
Component Funding Model Projection
2-9
Component Funding Model & Fully Funded Comparison Chart
2-10
Component Funding Model Assessment & Category Summary
2-11
Program Features & Benefits - Page 2
2-14
Distribution of Accumulated Reserves
2-15
Annual Expenditure Detail
2-17
Detail Report by Category
2-23
Program Features & Benefits - Page 3
2-55
Category Detail Index
2-56
TABLE OF CONTENTS
Annual Asset Expenditure Charts
2-57
Funding Model Comparison By Percent Funded Chart
2-58
Funding Model Reserve Ending Balance Comparison Chart
2-59
Important Information
This document has been provided pursuant to an agreement containing restrictions on its use.
No part of this document may be copied or distributed, in any form or by any means, nor
disclosed to third parties without the expressed written permission of Reserve Analyst©. The
client shall have the right to reproduce and distribute copies of this report, or the information
contained within, as may be required for compliance with all applicable regulations.
This reserve analysis study and the parameters under which it has been completed are based
upon information provided to us in part by representatives of the association, its contractors,
assorted vendors, specialist and independent contractors, the Community Association Institute,
and various construction pricing and scheduling manuals including, but not limited to: Marshall
& Swift Valuation Service, RS Means Facilities Maintenance & Repair Cost Data, RS Means
Repair & Remodeling Cost Data, National Construction Estimator, National Repair & Remodel
Estimator, Dodge Cost Manual and McGraw-Hill Professional. Additionally, costs are obtained
from numerous vendor catalogues, actual quotations or historical costs, and our own experience
in the field of property management and reserve study preparation.
It has been assumed, unless otherwise noted in this report, that all assets have been designed and
constructed properly and that each estimated useful life will approximate that of the norm per
industry standards and/or manufacturer’s specifications. In some cases, estimates may have been
used on assets, which have an indeterminable but potential liability to the association. The
decision for the inclusion of these as well as all assets considered is left to the client.
We recommend that your reserve analysis study be updated on an annual basis due to fluctuating
interest rates, inflationary changes, and the unpredictable nature of the lives of many of the
assets under consideration. All of the information collected during our inspection of the
association and computations made subsequently in preparing this reserve analysis study are
retained in our computer files. Therefore, annual updates may be completed quickly and
inexpensively each year.
Reserve Analyst© would like to thank you for using our services. We invite you to call us at any
time, should you have questions, comments or need assistance. In addition, any of the
parameters and estimates used in this study may be changed at your request, after which we will
provide a revised study.
This reserve analysis study is provided as an aid for planning purposes and not as an accounting
tool. Since it deals with events yet to take place, there is no assurance that the results
enumerated within it will, in fact, occur as described.
RESERVE ANALYST, LLC •800.561.0173
PAGE 1 - 1
Part I
Introduction
Preparing the annual budget and overseeing the association’s finances are perhaps the most
important responsibilities of board members. The annual operating and reserve budgets reflect
the planning and goals of the association and set the level and quality of service for all of the
association’s activities.
Funding Options
When a major repair or replacement is required in a community, an association has essentially
four options available to address the expenditure:
The first, and only logical means that the Board of Directors has to ensure its ability to maintain
the assets for which it is obligated, is by assessing an adequate level of reserves as part of the
regular membership assessment, thereby distributing the cost of the replacements uniformly over
the entire membership. The community is not only comprised of present members, but also
future members. Any decision by the Board of Directors to adopt a calculation method or
funding plan which would disproportionately burden future members in order to make up for
past reserve deficits, would be a breach of its fiduciary responsibility to those future members.
Unlike individuals determining their own course of action, the board is responsible to the
“community” as a whole.
Whereas, if the association was setting aside reserves for this purpose, using the vehicle of the
regularly assessed membership dues, it would have had the full term of the life of the roof, for
example, to accumulate the necessary moneys. Additionally, those contributions would have
been evenly distributed over the entire membership and would have earned interest as part of
that contribution.
The second option is for the association to acquire a loan from a lending institution in order to
effect the required repairs. In many cases, banks will lend to an association using “future
homeowner assessments” as collateral for the loan. With this method, the current board is
pledging the future assets of an association. They are also incurring the additional expense of
interest fees along with the original principal amount. In the case of a $150,000 roofing
replacement, the association may be required to pay back the loan over a three to five year
period, with interest.
The third option, too often used, is simply to defer the required repair or replacement. This
option, which is not recommended, can create an environment of declining property values due
to expanding lists of deferred maintenance items and the association’s financial inability to keep
pace with the normal aging process of the common area components. This, in turn, can have a
seriously negative impact on sellers in the association by making it difficult, or even impossible,
for potential buyers to obtain financing from lenders. Increasingly, lending institutions are
requesting copies of the association’s most recent reserve study before granting loans, either for
the association itself, a prospective purchaser, or for an individual within such an association.
The fourth option is to pass a “special assessment” to the membership in an amount required to
cover the expenditure. When a special assessment is passed, the association has the authority
and responsibility to collect the assessments, even by means of foreclosure, if necessary.
However, an association considering a special assessment cannot guarantee that an assessment,
when needed, will be passed. Consequently, the association cannot guarantee its ability to
perform the required repairs or replacements to those major components for which it is obligated
when the need arises. Additionally, while relatively new communities require very little in the
RESERVE ANALYST, LLC •800.561.0173
PAGE 1 - 2
way of major “reserve” expenditures, associations reaching 12 to 15 years of age and older, find
many components reaching the end of their effective useful lives. These required expenditures,
all accruing at the same time, could be devastating to an association’s overall budget.
Types of Reserve Studies
Most reserve studies fit into one of three categories:
Full Reserve Study;
Update with site inspection; and
Update without site inspection.
In a Full Reserve Study, the reserve provider conducts a component inventory, a condition
assessment (based upon on-site visual observations), and life and valuation estimates to
determine both a “fund status” and “funding plan”.
In an Update with site inspection, the reserve provider conducts a component inventory
(verification only, not quantification unless new components have been added to the inventory),
a condition assessment (based upon on-site visual observations), and life and valuation estimates
to determine both the “fund status and “funding plan.”
In an Update without site inspection, the reserve provider conducts life and valuation estimates
to determine the “fund status” and “funding plan.”
The Reserve Study: A Physical and a Financial Analysis
There are two components of a reserve study: a physical analysis and a financial analysis.
Physical Analysis
During the physical analysis, a reserve study provider evaluates information regarding the
physical status and repair/replacement cost of the association’s major common area components.
To do so, the provider conducts a component inventory, a condition assessment, and life and
valuation estimates.
Developing a Component List
The budget process begins with full inventory of all the major components for which the
association is responsible. The determination of whether an expense should be labeled as
operational, reserve, or excluded altogether is sometimes subjective. Since this labeling may
have a major impact on the financial plans of the association, subjective determinations should
be minimized. We suggest the following considerations when labeling an expense.
RESERVE ANALYST, LLC •800.561.0173
PAGE 1 - 3
Operational Expenses
Occur at least annually, no matter how large the expense, and can be budgeted for effectively
each year. They are characterized as being reasonably predictable, both in terms of frequency
and cost. Operational expenses include all minor expenses, which would not otherwise
adversely affect an operational budget from one year to the next. Examples of operational
expenses include:
Utilities:
Electricity
Gas
Water
Telephone
Cable TV
Administrative:
Supplies
Bank Service Charges
Dues & Publications
Licenses, Permits & Fees
Insurance(s)
Services:
Landscaping
Pool Maintenance
Street Sweeping
Accounting
Reserve Study
Repair Expenses:
Tile Roof Repairs
Equipment Repairs
Minor Concrete Repairs
Operating Contingency
Reserve Expenses
These are major expenses that occur other than annually, and which must be budgeted for in
advance in order to ensure the availability of the necessary funds in time for their use. Reserve
expenses are reasonably predictable both in terms of frequency and cost. However, they may
include significant assets that have an indeterminable but potential liability that may be
demonstrated as a likely occurrence. They are expenses that, when incurred, would have a
significant effect on the smooth operation of the budgetary process from one year to the next, if
they were not reserved for in advance. Examples of reserve expenses include:
Roof Replacements
Park/Play Equipment
Painting
Pool/Spa Re-plastering
Deck Resurfacing
Pool Equipment Replacement
Fencing Replacement
Pool Furniture Replacement
Asphalt Seal Coating
Tennis Court Resurfacing
Asphalt Repairs
Lighting Replacement
Asphalt Overlays
Insurance(s)
Equipment Replacement
Reserve Study
Interior Furnishings
Budgeting is Normally Excluded for:
Repairs or replacements of assets which are deemed to have an estimated useful life equal to or
exceeding the estimated useful life of the facility or community itself, or exceeding the legal life
of the community as defined in an association’s governing documents. Examples include the
complete replacement of elevators, tile roofs, wiring and plumbing. Also excluded are
insignificant expenses that may be covered either by an operating or reserve contingency, or
otherwise in a general maintenance fund. Expenses that are necessitated by acts of nature,
accidents or other occurrences that are more properly insured for, rather than reserved for, are
also excluded.
RESERVE ANALYST, LLC •800.561.0173
PAGE 1 - 4
Financial Analysis
The financial analysis assesses the association’s reserve balance or “fund status” (measured in
cash or as percent fully funded) to determine a recommendation for the appropriate reserve
contribution rate in the future, known as the “funding plan”.
Preparing the Reserve Study
Once the reserve assets have been identified and quantified, their respective replacement costs,
useful lives and remaining lives must be assigned so that a funding schedule can be constructed.
Replacement costs and useful lives can be found in published manuals such as construction
estimators, appraisal handbooks, and valuation guides. Remaining lives are calculated from the
useful lives and ages of assets and adjusted according to conditions such as design, manufactured
quality, usage, exposure to the elements and maintenance history.
By following the recommendations of an effective reserve study, the association should avoid
any major shortfalls. However, to remain accurate, the report should be updated on an annual
basis to reflect such changes as shifts in economic parameters, additions of phases or assets, or
expenditures of reserve funds. The association can assist in simplifying the reserve analysis
update process by keeping accurate records of these changes throughout the year.
Funding Methods
From the simplest to the most complex, reserve analysis providers use many different
computational processes to calculate reserve requirements. However, there are two basic
processes identified as industry standards: the cash flow method and the component method.
The cash flow method develops a reserve-funding plan where contributions to the reserve fund
are designed to offset the variable annual expenditures from the reserve fund. Different reserve
funding plans are tested against the actual anticipated schedule of reserve expenses until the
desired funding goal is achieved. This method sets up a “window” in which all future
anticipated replacement costs are computed, based upon the individual lives of the components
under consideration. The Reserve Analyst© Threshold and the Reserve Analyst© Current
Assessment funding models are based upon the cash flow method.
The component method develops a reserve-funding plan where the total contribution is based
upon the sum of contributions for individual components. The component method is the more
conservative of the two funding options, and assures that the association will achieve and
maintain an ideal level of reserve over time. This method also allows for computations on
individual components in the analysis. The Reserve Analyst© Component Funding model is
based upon the component methodology.
RESERVE ANALYST, LLC •800.561.0173
PAGE 1 - 5
Funding Strategies
Once an association has established its funding goals, the association can select an appropriate
funding plan. There are four basic strategies from which most associations select. It is
recommended that associations consult professionals to determine the best strategy or
combination of plans that best suit the association’s need. Additionally, associations should
consult with their financial advisor to determine the tax implications of selecting a particular
plan. Further, consultation with the American Institute of Certified Public Accountants (AICPA)
for their reporting requirements is advisable. The four funding plans and descriptions of each are
detailed below. Associations will have to update their reserve studies more or less frequently
depending on the funding strategy they select.
Full Funding---Given that the basis of funding for reserves is to distribute the costs of the
replacements over the lives of the components in question, it follows that the ideal level of
reserves would be proportionately related to those lives and costs. If an association has a
component with an expected estimated useful life of ten years, it would set aside approximately
one-tenth of the replacement cost each year. At the end of three years, one would expect threetenths of the replacement cost to have accumulated, and if so, that component would be “fullyfunded.” This model is important in that it is a measure of the adequacy of an association’s
reserves at any one point of time, and is independent of any particular method which may have
been used for past funding or may be under consideration for future funding. This formula
represents a snapshot in time and is based upon current replacement cost, independent of future
inflationary or investment factors:
Fully Funded Reserves = Age divided by Useful Life the results multiplied by Current
Replacement Cost
When an association’s total accumulated reserves for all components meet this criterion, its
reserves are considered “fully-funded.”
The Reserve Analyst© Threshold Funding Model (Minimum Funding). The goal of this
funding method is to keep the reserve cash balance above zero. This means that while each
individual component may not be fully funded, the reserve balance overall does not drop below
zero during the projected period. An association using this funding method must understand that
even a minor reduction in a component’s remaining useful life can result in a deficit in the
reserve cash balance.
The Reserve Analyst© Threshold Funding Model. This method is based upon the cash flow
funding concept. The minimum reserve cash balance in threshold funding, however, is set at a
predetermined dollar amount (other than $0).
The Reserve Analyst© Current Assessment Funding Model. This method is also based upon
the cash flow funding concept. The initial reserve assessment is set at the association’s current
fiscal year funding level and a 30-year projection is calculated to illustrate the adequacy of the
current funding over time.
The Reserve Analyst© Component Funding Model. This is a straight-line funding model. It
distributes the cash reserves to individual reserve components and then calculates what the
reserve assessment and interest contribution (minus taxes) should be, again by each reserve
component. The current annual assessment is then determined by summing all the individual
component assessments, hence the name “Component Funding Model”. This is the most
conservative funding model. It leads to or maintains the fully funded reserve position. The
following details this calculation process.
Component Funding Model Distribution of Accumulated Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 1 - 6
The “Distribution of Accumulated Reserves Report” is a “Component Funding Model”
calculation. This distribution does not apply to the cash flow funding models.
When calculating reserves based upon the component methodology, a beginning reserve balance
must be allocated for each of the individual components considered in the analysis, before the
individual calculations can be completed. When this distribution is not available, or of sufficient
detail, the following method is suggested for allocating reserves:
The first step the program performs in this process is subtracting, from the total accumulated
reserves, any amounts for assets that have predetermined (fixed) reserve balances. The user can
“fix” the accumulated reserve balance within the program on the individual asset’s detail page.
If, by error, these amounts total more than the amount of funds available, then the remaining
assets are adjusted accordingly. A provision for a contingency reserve is then deducted by the
determined percentage used, and if there are sufficient remaining funds available.
The second step is to identify the ideal level of reserves for each asset. As indicated in the prior
section, this is accomplished by evaluating the component’s age proportionate to its estimated
useful life and current replacement cost. Again, the equation used is as follows:
Fully Funded Reserves = (Age/Useful Life) x Current Replacement Cost
The Reserve Analyst© software program performs the above calculations to the actual month
the component was placed-in-service. The program projects that the accumulation of necessary
reserves for repairs or replacements will be available on the first day of the fiscal year in which
they are scheduled to occur.
The next step the program performs is to arrange all of the assets used in the study in ascending
order by remaining life, and alphabetically within each grouping of remaining life items. These
assets are then assigned their respective ideal level of reserves until the amount of funds
available is depleted, or until all assets are appropriately funded. If any assets are assigned a
zero remaining life (scheduled for replacement in the current fiscal year), then the amount
assigned equals the current replacement cost and funding begins for the next cycle of
replacement. If there are insufficient funds available to accomplish this, then the software
automatically adjusts the zero remaining life items to one year, and that asset assumes its new
grouping position alphabetically in the final printed report.
If, at the completion of this task, there are additional moneys that have not been distributed, the
remaining reserves are then assigned, in ascending order, to a level equal to, but not exceeding,
the current replacement cost for each component. If there are sufficient moneys available to
fund all assets at their current replacement cost levels, then any excess funds are designated as
such and are not factored into any of the report computations. If, at the end of this assignment
process there are designated excess funds, they can be used to offset the monthly contribution
requirements recommended, or used in any other manner the client may desire.
Assigning the reserves in this manner defers the make-up period for any under-funding over the
longest remaining life of all assets under consideration, thereby minimizing the impact of any
deficiency. For example, if the report indicates an under funding of $50,000, this under-funding
will be assigned to components with the longest remaining lives in order to give more time to
“replenish” the account. If the $50,000 under-funding were to be assigned to short remaining
life items, the impact would be felt immediately.
If the reserves are under-funded, the monthly contribution requirements, as outlined in this
report, can be expected to be higher than normal. In future years, as individual assets are
replaced, the funding requirements will return to their normal levels. In the case of a large
deficiency, a special assessment may be considered. The program can easily generate revised
RESERVE ANALYST, LLC •800.561.0173
PAGE 1 - 7
reports outlining how the monthly contributions would be affected by such an adjustment, or by
any other changes that may be under consideration.
Funding Reserves
Three assessment and contribution figures are provided in the report, the “Monthly Reserve
Assessment Required”, the “Average Net Monthly Interest Earned” contribution and the “Total
Monthly Allocation to Reserves.” The association should allocate the “Monthly Reserve
Assessment Required” amount to reserves each month when the interest earned on the reserves is
left in the reserve accounts as part of the contribution. Any interest earned on reserve deposits,
must be left in reserves and only amounts set aside for taxes should be removed.
The second alternative is to allocate the “Total Monthly Allocation” to reserves (this is the
member assessment plus the anticipated interest earned for the fiscal year). This method
assumes that all interest earned will be assigned directly as operating income. This allocation
takes into consideration the anticipated interest earned on accumulated reserves regardless of
whether or not it is actually earned. When taxes are paid, the amount due will be taken directly
from the association’s operating accounts as the reserve accounts are allocated only those
moneys net of taxes.
Users’ Guide to your Reserve Analysis Study
Part II of your Reserve Analyst© Report contains the reserve analysis study for your association.
There are seven types of reports in the study as described below.
Report Summaries
The Report Summary for all funding models lists all of the parameters that were used in
calculating the report as well as the summary of your reserve analysis study.
Index Reports
The Distribution of Accumulated Reserves report lists all assets in remaining life order. It also
identifies the ideal level of reserves that should have accumulated for the association as well as
the actual reserves available. This information is valid only for the “Component Funding
Model” calculation.
RESERVE ANALYST, LLC •800.561.0173
PAGE 1 - 8
The Component Listing/Summary lists all assets by category (i.e. roofing, painting, lighting,
etc.) together with their remaining life, current cost, monthly reserve contribution, and net
monthly allocation.
Detail Reports
The Detail Report itemizes each asset and lists all measurements, current and future costs, and
calculations for that asset. Provisions for percentage replacements, salvage values, and one-time
replacements can also be utilized. These reports can be sorted by category or group.
The numerical listings for each asset are enhanced by extensive narrative detailing factors such
as design, manufactured quality, usage, exposure to elements and maintenance history.
The Reserve Analyst© Detail Index is an alphabetical listing of all assets, together with the page
number of the asset’s detail report, the projected replacement year, and the asset number.
Projections
Thirty-year projections add to the usefulness of your reserve analysis study.
Definitions
Report I.D.
Includes the Report Date (example: November 15, 1992), Account Number (example: 9773), and
Version (example: 1.0). Please use this information (displayed on the summary page) when
referencing your report.
Budget Year Beginning/Ending
The budgetary year for which the report is prepared. For associations with fiscal years ending
December 31st, the monthly contribution figures indicated are for the 12-month period beginning
1/1/20xx and ending 12/31/20xx.
Number of Units and/or Phases
If applicable, the number of units and/or phases included in this version of the report.
Inflation
This figure is used to approximate the future cost to repair or replace each component in the
report. The current cost for each component is compounded on an annual basis by the number of
remaining years to replacement, and the total is used in calculating the monthly reserve
contribution that will be necessary to accumulate the required funds in time for replacement.
Annual Assessment Increase
This represents the percentage rate at which the association will increase its assessment to
reserves at the end of each year. For example, in order to accumulate $10,000 in 10 years, you
could set aside $1,000 per year. As an alternative, you could set aside $795 the first year and
increase that amount by 5% each year until the year of replacement. In either case you arrive at
the same amount. The idea is that you start setting aside a lower amount and increase that
number each year in accordance with the planned percentage. Ideally this figure should be equal
to the rate of inflation. It can, however, be used to aide those associations that have not set aside
appropriate reserves in the past, by making the initial year’s allocation less formidable.
RESERVE ANALYST, LLC •800.561.0173
PAGE 1 - 9
Investment Yield Before Taxes
The average interest rate anticipated by the association based upon its current investment
practices.
Taxes on Interest Yield
The estimated percentage of interest income that will be set aside to pay income taxes on the
interest earned.
Projected Reserve Balance
The anticipated reserve balance on the first day of the fiscal year for which this report has been
prepared. This is based upon information provided and not audited.
Percent Fully Funded
The ratio, at the beginning of the fiscal year, of the actual (or projected) reserve balance to the
calculated fully funded balance, expressed as a percentage.
Phase Increment Detail and/or Age
Comments regarding aging of the components on the basis of construction date or date of
acceptance by the association.
Monthly Assessment
The assessment to reserves required by the association each month.
Interest Contribution (After Taxes)
The interest that should be earned on the reserves, net of taxes, based upon their beginning
reserve balance and monthly contributions for one year. This figure is averaged for budgeting
purposes.
Total Monthly Allocation
The sum of the monthly assessment and interest contribution figures.
Group and Category
The report may be prepared and sorted either by group (location, building, phase, etc.) or by
category (roofing, painting, etc.). The standard report printing format is by category.
Percentage of Replacement or Repairs
In some cases, an asset may not be replaced in its entirety or the cost may be shared with a
second party. Examples are budgeting for a percentage of replacement of streets over a period of
time, or sharing the expense to replace a common wall with a neighboring party.
Placed-In-Service Date
The month and year that the asset was placed-in-service. This may be the construction date, the
first escrow closure date in a given phase, or the date of the last servicing or replacement.
Estimated Useful Life
The estimated useful life of an asset based upon industry standards, manufacturer specifications,
visual inspection, location, usage, association standards and prior history. All of these factors
are taken into consideration when tailoring the estimated useful life to the particular asset. For
example, the carpeting in a hallway or elevator (a heavy traffic area) will not have the same life
as the identical carpeting in a seldom-used meeting room or office.
Adjustment to Useful Life
Once the useful life is determined, it may be adjusted, up or down, by this separate figure for the
current cycle of replacement. This will allow for a current period adjustment without affecting
the estimated replacement cycles for future replacements.
Estimated Remaining Life
RESERVE ANALYST, LLC •800.561.0173
PAGE 1 - 10
This calculation is completed internally based upon the report’s fiscal year date and the date the
asset was placed-in-service.
Replacement Year
The year that the asset is scheduled to be replaced. The appropriate funds will be available by
the first day of the fiscal year for which replacement is anticipated.
Annual Fixed Reserves
An optional figure which, if used, will override the normal process of allocating reserves to each
asset.
Fixed Assessment
An optional figure which, if used, will override all calculations and set the assessment at this
amount. This assessment can be set for monthly, quarterly or annually as necessary.
Salvage Value
The salvage value of the asset at the time of replacement, if applicable.
One-Time Replacement
Notation if the asset is to be replaced on a one-time basis.
Current Replacement Cost
The estimated replacement cost effective at the beginning of the fiscal year for which the report
is being prepared
Future Replacement Cost
The estimated cost to repair or replace the asset at the end of its estimated useful life based upon
the current replacement cost and inflation.
Component Inventory
The task of selecting and qualifying reserve components. This task can be accomplished through
on-site visual, review of association design and organizational documents, a review of
established association precedents, and discussion with appropriate association representative(s).
RESERVE ANALYST, LLC •800.561.0173
PAGE 1 - 11
A Multi-Purpose Tool
Your Reserve Analyst© Report is an important part of your association’s budgetary process.
Following its recommendations should ensure the association’s smooth budgetary transitions
from one fiscal year to the next, and either decrease or eliminate the need for “special
assessments”.
In addition, your Reserve Analyst© reserve study serves a variety of useful purposes:
•
Following the recommendations of a reserve study performed by a professional
consultant can protect the Board of Directors in a community from personal liability
concerning reserve components and reserve funding.
•
A reserve analysis study is required by your accountant during the preparation of the
association’s annual audit.
•
The Reserve Analyst© reserve study is often requested by lending institutions during the
process of loan applications, both for the community and, in many cases, the individual
owners.
•
Your Reserve Analyst© Report is also a detailed inventory of the association’s major
assets and serves as a management tool for scheduling, coordinating and planning future
repairs and replacements.
•
Your Reserve Analyst© Report is a tool that can assist the Board in fulfilling its legal and
fiduciary obligations for maintaining the community in a state of good repair. If a
community is operating on a special assessment basis, it cannot guarantee that an
assessment, when needed, will be passed. Therefore, it cannot guarantee its ability to
perform the required repairs or replacements to those major components for which the
association is obligated.
•
Since the Reserve Analyst© reserve analysis study includes measurements and cost
estimates of the client’s assets, the detail reports may be used to evaluate the accuracy
and price of contractor bids when assets are due to be repaired or replaced.
•
The Reserve Analyst© reserve study is an annual disclosure to the membership
concerning the financial condition of the association, and may be used as a “consumers’
guide” by prospective purchasers.
•
The Reserve Analyst© Owners’ Summary meets the disclosure requirements of the
California Civil Code and also the recently adopted ECHO standards.
•
Your Reserve Analyst© Report provides a record of the time, cost, and quantities of past
reserve replacements. At times the association’s management company and board of
directors are transitory which may result in the loss of these important records.
RESERVE ANALYST, LLC •800.561.0173
PAGE 1 - 12
Sample Reserve Study
Your City, Your State
RA Current Assessment Funding Model Summary
Report Parameters
Report Date
Account Number
Version
Budget Year Beginning
Budget Year Ending
February 01, 2003
Sample Reserve Study
7.0 (2003)
January 01, 2003
December 31, 2003
Total Units
Phase Development
55
1 of 1
Inflation
Annual Assessment Increase
Interest Rate on Reserve Deposit
Tax Rate on Interest
Contingency
2003 Beginning Balance
3.00%
3.00%
3.00%
30.00%
3.00%
$105,000.00
Current Assessment Funding Model Summary
• For budgeting purposes, unless otherwise indicated, we have used January 1990 to begin
aging the original components in this reserve study.
• This a 55 unit condominium is located at the intersection of 1st Street and Main Street, Your
Town, Your State, USA.
• The last Reserve Analyst field inspection was completed on Janury 3, 2002.
Summary of Calculations
Monthly Reserve Assessment Required
$28.03 per unit per monthly
Average Net Monthly Interest Earned
Total Monthly Allocation to Reserves
$28.32 per unit monthly
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 1
$1,541.66
$193.56
$1,557.79
Sample Reserve Study
RA Current Assessment Funding Model Projection
Beginning Balance: $105,000
Year
Current
Cost
2003
2004
2005
2006
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
244,942
252,291
259,859
267,655
275,685
283,955
292,474
301,248
310,286
319,594
329,182
339,057
349,229
359,706
370,497
381,612
393,061
404,852
416,998
429,508
442,393
455,665
469,335
483,415
497,917
512,855
528,240
544,088
560,410
577,223
Annual
Assessment
18,500
19,055
19,627
20,215
20,822
21,447
22,090
22,753
23,435
24,138
24,862
25,608
26,377
27,168
27,983
28,822
29,687
30,578
31,495
32,440
33,413
34,415
35,448
36,511
37,607
38,735
39,897
41,094
42,327
43,596
Annual
Interest
2,323
2,538
2,819
2,933
3,232
2,967
3,490
2,990
2,204
1,915
2,475
2,714
2,352
2,342
2,450
2,800
3,479
3,917
3,152
3,077
3,528
4,076
4,903
4,296
4,648
5,359
5,019
3,590
2,527
1,395
Annual
Expenditures
3,892
10,925
8,605
17,338
9,297
36,883
49,485
63,099
39,596
16,416
45,730
29,563
24,763
14,333
12,882
70,990
38,662
14,650
11,547
69,442
24,703
9,227
60,670
112,849
95,405
98,811
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 2
Projected
Ending
Reserves
121,931
132,599
146,439
152,249
167,007
154,538
180,118
156,375
118,916
105,374
132,711
144,617
127,616
127,562
133,232
150,521
183,687
205,299
168,957
165,811
188,103
215,047
255,398
226,764
244,316
279,183
263,429
195,265
144,713
90,894
Fully
Funded
Reserves
Percent
Fully
Funded
131,223
144,130
160,503
168,737
186,404
176,009
205,125
183,331
147,176
135,630
166,526
181,739
167,137
170,103
179,129
200,397
238,442
264,923
231,541
232,475
259,960
292,644
339,673
315,589
339,429
381,618
371,752
307,525
261,208
211,258
92%
91%
91%
90%
89%
87%
87%
85%
80%
77%
79%
79%
76%
74%
74%
75%
77%
77%
72%
71%
72%
73%
75%
71%
71%
73%
70%
63%
55%
43%
Sample Reserve Study
RA Current Funding Model & Fully Funded Comparison Chart
Current Funding Model VS Fully Funded Reserves
450,000
400,000
350,000
300,000
250,000
200,000
150,000
100,000
50,000
0
'03 '04 '05 '06 '07 '08 '09 '10 '11 '12 '13 '14 '15 '16 '17 '18 '19 '20 '21 '22 '23 '24 '25 '26 '27 '28 '29 '30 '31 '32
Fiscal Year
Current Funding Model
Fully Funded Reserves
The Current Assessment Funding Model is based on the current annual assessment, parameters, and
reserve fund balance. Because it is calculated using the current annual assessment, it will give the
accurate projection of how well the association is funded for the next 30 years of planned reserve
expenditures.
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 3
Sample Reserve Study
RA Program Features & Benefits - Page 1
Program Features & Benefits
¾ Windows Software
¾
Open ended architecture - Any desired feature can be added
¾
Very user friendly
¾
Uses Rich Text - Edits like Microsoft Word
¾
Network ready
¾
Easily Zip and e-mail project files to others or use as backup
¾
Craftsman component cost database included
¾
Produces Professional reports
¾
Import other data files
¾
Project Notes for specific information about each project
¾
Meets current California owner's disclosure requirements
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 4
Sample Reserve Study
Your City, Your State
RA Threshold Funding Model Summary
Report Parameters
Report Date
Account Number
Version
Budget Year Beginning
Budget Year Ending
February 01, 2003
Sample Reserve Study
7.0 (2003)
January 01, 2003
December 31, 2003
Total Units
Phase Development
55
1 of 1
Inflation
Annual Assessment Increase
Interest Rate on Reserve Deposit
Tax Rate on Interest
Contingency
2003 Beginning Balance
3.00%
3.00%
3.00%
30.00%
3.00%
$105,000.00
Threshold Funding Model Summary
• For budgeting purposes, unless otherwise indicated, we have used January 1990 to begin
aging the original components in this reserve study.
• This a 55 unit condominium is located at the intersection of 1st Street and Main Street, Your
Town, Your State, USA.
• The last Reserve Analyst field inspection was completed on Janury 3, 2002.
Summary of Calculations
Monthly Reserve Assessment Required
$27.41 per unit per monthly
Average Net Monthly Interest Earned
Total Monthly Allocation to Reserves
$27.70 per unit monthly
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 5
$1,507.76
$193.23
$1,523.86
Sample Reserve Study
RA Threshold Funding Model Projection
Beginning Balance: $105,000
Year
Current
Cost
2003
2004
2005
2006
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
244,942
252,291
259,859
267,655
275,685
283,955
292,474
301,248
310,286
319,594
329,182
339,057
349,229
359,706
370,497
381,612
393,061
404,852
416,998
429,508
442,393
455,665
469,335
483,415
497,917
512,855
528,240
544,088
560,410
577,223
Annual
Assessment
18,093
18,636
19,195
19,771
20,364
20,975
21,604
22,252
22,920
23,608
24,316
25,045
25,797
26,570
27,368
28,189
29,034
29,905
30,802
31,727
32,678
33,659
34,668
35,708
36,780
37,883
39,020
40,190
41,396
42,638
Annual
Interest
2,319
2,525
2,797
2,901
3,190
2,914
3,426
2,914
2,116
1,814
2,360
2,585
2,208
2,183
2,275
2,608
3,269
3,689
2,905
2,809
3,239
3,766
4,569
3,938
4,266
4,951
4,584
3,127
2,034
872
Annual
Expenditures
3,892
10,925
8,605
17,338
9,297
36,883
49,485
63,099
39,596
16,416
45,730
29,563
24,763
14,333
12,882
70,990
38,662
14,650
11,547
69,442
24,703
9,227
60,670
112,849
95,405
98,811
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 6
Projected
Ending
Reserves
121,520
131,756
145,143
150,477
164,735
151,741
176,771
152,453
114,390
100,216
126,892
138,106
120,381
119,570
124,450
140,912
173,215
193,927
156,644
152,517
173,785
199,662
238,899
209,104
225,447
259,054
241,988
172,456
120,482
65,180
Fully
Funded
Reserves
Percent
Fully
Funded
131,223
144,130
160,503
168,737
186,404
176,009
205,125
183,331
147,176
135,630
166,526
181,739
167,137
170,103
179,129
200,397
238,442
264,923
231,541
232,475
259,960
292,644
339,673
315,589
339,429
381,618
371,752
307,525
261,208
211,258
92%
91%
90%
89%
88%
86%
86%
83%
77%
73%
76%
75%
72%
70%
69%
70%
72%
73%
67%
65%
66%
68%
70%
66%
66%
67%
65%
56%
46%
30%
Sample Reserve Study
RA Threshold Funding Model & Fully Funded Comparison Chart
Threshold Funding Model VS Fully Funded Reserves
450,000
400,000
350,000
300,000
250,000
200,000
150,000
100,000
50,000
0
'03 '04 '05 '06 '07 '08 '09 '10 '11 '12 '13 '14 '15 '16 '17 '18 '19 '20 '21 '22 '23 '24 '25 '26 '27 '28 '29 '30 '31 '32
Fiscal Year
Threshold Funding Model
Fully Funded Reserves
The Threshold Funding Model calculates the minimum reserve assessments, with the restriction that
the reserve balance is not allowed to go below $0 or other predetermined threshold, during the period of
time examined. All funds for planned reserve expenditures will be available on the first day of each
fiscal year. The Threshold Funding Model allows the client to choose the level of conservative
funding they desire by choosing the threshold dollar amount.
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 7
Sample Reserve Study
Your City, Your State
RA Component Funding Model Summary
Report Parameters
Report Date
Account Number
Version
Budget Year Beginning
Budget Year Ending
February 01, 2003
Sample Reserve Study
7.0 (2003)
January 01, 2003
December 31, 2003
Total Units
Phase Development
55
1 of 1
Inflation
Annual Assessment Increase
Interest Rate on Reserve Deposit
Tax Rate on Interest
Contingency
2003 Beginning Balance
3.00%
3.00%
3.00%
30.00%
3.00%
$105,000.00
Component Funding Model Summary
• For budgeting purposes, unless otherwise indicated, we have used January 1990 to begin
aging the original components in this reserve study.
• This a 55 unit condominium is located at the intersection of 1st Street and Main Street, Your
Town, Your State, USA.
• The last Reserve Analyst field inspection was completed on Janury 3, 2002.
Summary of Calculations
Monthly Reserve Assessment Required
$32.14 per unit per monthly
Average Net Monthly Interest Earned
Total Monthly Allocation to Reserves
$32.44 per unit monthly
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 8
$1,768.24
$195.75
$1,784.56
Sample Reserve Study
RA Component Funding Model Projection
Beginning Balance: $105,000
Year
Current
Cost
2003
2004
2005
2006
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
244,942
252,291
259,859
267,655
275,685
283,955
292,474
301,248
310,286
319,594
329,182
339,057
349,229
359,706
370,497
381,612
393,061
404,852
416,998
429,508
442,393
455,665
469,335
483,415
497,917
512,855
528,240
544,088
560,410
577,223
Annual
Assessment
21,219
21,945
22,369
22,929
23,413
24,310
24,665
25,809
26,920
27,769
27,668
28,245
29,448
30,718
31,392
32,022
32,608
33,419
34,863
35,705
36,377
37,163
37,902
39,692
41,030
42,362
44,004
46,196
47,688
49,339
Annual
Interest
2,349
2,624
2,967
3,142
3,502
3,299
3,888
3,456
2,749
2,547
3,188
3,500
3,215
3,293
3,496
3,938
4,706
5,232
4,560
4,584
5,135
5,778
6,695
6,186
6,648
7,476
7,262
5,977
5,075
4,115
Annual
Expenditures
3,892
10,925
8,605
17,338
9,297
36,883
49,485
63,099
39,596
16,416
45,730
29,563
24,763
14,333
12,882
70,990
38,662
14,650
11,547
69,442
24,703
9,227
60,670
112,849
95,405
98,811
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 9
Projected
Ending
Reserves
124,676
138,320
155,050
163,783
181,401
172,128
200,682
180,461
147,032
137,751
168,607
183,937
170,870
175,318
185,443
207,070
244,383
270,152
238,586
240,213
267,075
298,468
343,065
319,501
342,476
383,087
373,683
313,008
270,366
225,009
Fully
Funded
Reserves
Percent
Fully
Funded
131,223
144,130
160,503
168,737
186,404
176,009
205,125
183,331
147,176
135,630
166,526
181,739
167,137
170,103
179,129
200,397
238,442
264,923
231,541
232,475
259,960
292,644
339,673
315,589
339,429
381,618
371,752
307,525
261,208
211,258
95%
95%
96%
97%
97%
97%
97%
98%
99%
101%
101%
101%
102%
103%
103%
103%
102%
101%
103%
103%
102%
101%
100%
101%
100%
100%
100%
101%
103%
106%
Sample Reserve Study
RA Component Funding Model & Fully Funded Comparison Chart
Component Funding Model VS Fully Funded Reserves
450,000
400,000
350,000
300,000
250,000
200,000
150,000
100,000
50,000
0
'03 '04 '05 '06 '07 '08 '09 '10 '11 '12 '13 '14 '15 '16 '17 '18 '19 '20 '21 '22 '23 '24 '25 '26 '27 '28 '29 '30 '31 '32
Fiscal Year
Component Funding Model
Fully Funded Reserves
The Component Funding Model’s long-term objective is to provide a plan to a fully funded reserve
position over the longest period of time practical. This is the most conservative funding model.
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 10
Sample Reserve Study
RA Component Funding Model Assessment & Category Summary
d
Cu
Cor r e n
st t
Asphalt Pavement
Asphalt Overlay
Streets - Asphalt Repairs
Streets - Asphalt Seal Coat
Asphalt Pavement - Total
2010
2007
2007
20
5
5
0
5
0
7
4
4
40,236
3,360
4,900
$48,496
26,153
2,016
980
$29,149
26,153
2,016
980
$29,149
Roofing
Roofs - Built Up w/Gravel, Replace
Roofing - Total
2015
14
0
12
18,375
$18,375
0
2,625
$2,625
Gutters & Downspouts
Gutters & Downspouts - Replace
Gutters & Downspouts - Total
2012
22
0
9
1,212
$1,212
716
$716
716
$716
Skylights
Skylights - Roof, Replace
Skylights - Total
2012
22
0
9
1,340
$1,340
792
$792
792
$792
Painting, Interior
Paint - Lobby, Atrium, & Halls
Painting, Interior - Total
2006
8
0
3
10,567
$10,567
6,604
$6,604
6,604
$6,604
Painting, Exterior
Paint - Metal
Paint - Stucco
Paint - Wood Siding
Painting, Exterior - Total
2006
2011
2006
5
10
5
0
0
0
3
8
3
2,384
37,975
1,340
$41,699
954
7,595
536
$9,085
954
7,595
536
$9,085
Fencing
Fence - Steel, Pool, Replace
Fencing - Total
2008
18
0
5
15,686
$15,686
11,328
$11,328
11,328
$11,328
Pool
Pool - Filter, Replace
Pool - Replaster/Tile Replacement
Pool Furniture - Replacement
Pool Heater - Replacement
Pool - Total
2014
2012
2008
2003
12
12
7
12
0
0
0
0
11
9
5
0
1,292
6,207
1,646
2,164
$11,309
108
1,552
470
2,164
$4,294
108
1,552
470
2,164
$4,294
Play Equipment
Play Equipment - Replace
Play Equipment - Total
2016
16
0
13
12,000
$12,000
0
2,250
$2,250
Description
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 11
Fu
Fully
nd
e
Ad
j us
tm
en
Re
t
Lifmain
e i ng
7.0 (2003)
Us
Lifeful
e
Re
Y e pl ac
a r em
e
nt
Version Number
As
s
Re igne
se r d
ve
Report Date
February 01, 2003
Beginning Fiscal Year
January 01, 2003
Account Number
Sample Reserve Study
Cu
Corre n
st t
As
s
Re igne
se r d
ve
Fu
Fully
nd
e
Railings, Metal
Railing - Ext, Wrght Iron, Replace
Railings, Metal - Total
2008
18
0
5
3,484
$3,484
2,516
$2,516
2,516
$2,516
Lighting, Interior
Lighting - Ceiling Recess Rounds, Replace
Lighting - EXIT/Emergency, Replace
Lighting - Fluorescent Fixtures, Replace
Lighting - Wall Sconces, Replace
Lighting, Interior - Total
2020
2012
2020
2012
22
22
22
22
0
0
0
0
17
9
17
9
1,500
5,434
6,294
6,084
$19,312
0
3,211
0
3,595
$6,806
341
3,211
1,430
3,595
$8,577
Lighting, Exterior
Lighting - Buildings, Replace
Lighting, Exterior - Total
2012
22
0
9
1,810
$1,810
1,070
$1,070
1,070
$1,070
Floor Cover
Floor Cover - Carpet, Halls, Replace
Floor Cover - Total
2005
6
0
2
8,111
$8,111
5,408
$5,408
5,408
$5,408
Hot Water System
Boiler - Hot Water System, Replace
Hot Water Storage Tank - Replace
Hot Water System - Total
2032
2018
30
16
0
0
29
15
15,470
3,000
$18,470
0
0
516
187
$703
Elevator
Elevator - Cab Refurbishing
Elevator - Major Repairs
Elevator - Total
2004
2008
14
18
0
0
1
5
6,200
11,000
$17,200
5,757
7,944
$13,702
5,757
7,944
$13,702
Gate Operator
Security - Gate Operators, Sliding, Replace
Gate Operator - Total
2004
12
2
1
1,895
$1,895
1,760
$1,760
1,760
$1,760
Security
Security - Access Phone, Replace
Security - Total
2004
12
2
1
2,512
$2,512
2,333
$2,333
2,333
$2,333
Doors, Exterior
Doors - Exterior, Metal, Replace
Doors, Exterior - Total
2015
25
0
12
8,161
$8,161
3,280
$3,280
4,244
$4,244
Landscape Equipment
Irrigation Controller - Replace
Landscape Equipment - Total
2003
12
0
0
1,728
$1,728
1,728
$1,728
1,728
$1,728
Mailboxes
Mailboxes - Wall Clusters, Replace
Mailboxes - Total
2006
16
0
3
1,575
$1,575
1,280
$1,280
1,280
$1,280
Description
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 12
d
Ad
j us
tm
en
Re
t
Lifmain
e i ng
Us
Lifeful
e
Re
Y e pl ac
a r em
e
nt
Sample Reserve Study
RA Component Funding Model Assessment & Category Summary
Contingency
Traffic Signs
Contingency - Total
d
Fu
Fully
nd
e
As
s
Re igne
se r d
ve
Cu
Corre n
st t
j us
tm
en
Re
t
Lifmain
e i ng
Ad
Us
Lifeful
e
Description
Re
Y e pl ac
a r em
e
nt
Sample Reserve Study
RA Component Funding Model Assessment & Category Summary
unfunded
Total Asset Summary
Contingency at 3.00%
Summary Total
$244,942
$101,850
$3,150
$105,000
Fully Funded Level
92%
Current Average Liability per Unit (Total Units:55)
-$155
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 13
$110,163
$3,407
$113,570
Sample Reserve Study
RA Program Features & Benefits - Page 2
...More Features & Benefits
Add and print color digital photos of assets to the report
Solid industry accepted funding models
Special Assessments
Reserve preparer has control of funding models
Sort, group and find assets
Add record comments to describe assets
Use names for asset categories and groups
Stock Comments included to describe assets
Keep detailed inventory of the association’s assets
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 14
Sample Reserve Study
RA Distribution of Accumulated Reserves
Description
Remaining
Life
Irrigation Controller - Replace
Pool Heater - Replacement
Elevator - Cab Refurbishing
Security - Access Phone, Replace
Security - Gate Operators, Sliding, Replace
Floor Cover - Carpet, Halls, Replace
Mailboxes - Wall Clusters, Replace
Paint - Lobby, Atrium, & Halls
Paint - Metal
Paint - Wood Siding
Streets - Asphalt Repairs
Streets - Asphalt Seal Coat
Elevator - Major Repairs
Fence - Steel, Pool, Replace
Pool Furniture - Replacement
Railing - Ext, Wrght Iron, Replace
Asphalt Overlay
Paint - Stucco
Gutters & Downspouts - Replace
Lighting - Buildings, Replace
Lighting - EXIT/Emergency, Replace
Lighting - Wall Sconces, Replace
Pool - Replaster/Tile Replacement
Skylights - Roof, Replace
Pool - Filter, Replace
Doors - Exterior, Metal, Replace
Roofs - Built Up w/Gravel, Replace
Play Equipment - Replace
Hot Water Storage Tank - Replace
Lighting - Ceiling Recess Rounds, Replace
Lighting - Fluorescent Fixtures, Replace
Boiler - Hot Water System, Replace
Traffic Signs
0
0
1
1
1
2
3
3
3
3
4
4
5
5
5
5
7
8
9
9
9
9
9
9
11
12
12
13
15
17
17
29
Replacement
Year
2003
2003
2004
2004
2004
2005
2006
2006
2006
2006
2007
2007
2008
2008
2008
2008
2010
2011
2012
2012
2012
2012
2012
2012
2014
2015
2015
2016
2018
2020
2020
2032
unfunded
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 15
Assigned
Reserves
1,728
2,164
5,757
2,333
1,760
5,408
1,280
6,604
954
536
2,016
980
7,944
11,328
470
2,516
26,153
7,595
716
1,070
3,211
3,595
1,552
792
108
3,280
Fully Funded
Reserves
1,728
2,164
5,757
2,333
1,760
5,408
1,280
6,604
954
536
2,016
980
7,944
11,328
470
2,516
26,153
7,595
716
1,070
3,211
3,595
1,552
792
108
4,244
2,625
2,250
187
341
1,430
516
Sample Reserve Study
RA Distribution of Accumulated Reserves
Description
Remaining
Life
Replacement
Year
Total Asset Summary
Contingency at 3.00%
Summary Total
Assigned
Reserves
$101,850
$3,150
$105,000
Fully Funded Level
92%
Current Average Liability per Unit (Total Units:55)
-$155
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 16
Fully Funded
Reserves
$110,163
$3,407
$113,570
Sample Reserve Study
RA Annual Expenditure Detail
Description
Expenditures
Replacement Year 2003
Irrigation Controller - Replace
Pool Heater - Replacement
Total
Replacement Year 2004
Elevator - Cab Refurbishing
Security - Access Phone, Replace
Security - Gate Operators, Sliding, Replace
Total
1,728
2,164
$3,892
6,386
2,587
1,952
$10,925
Replacement Year 2005
Floor Cover - Carpet, Halls, Replace
Total
8,605
$8,605
Replacement Year 2006
Mailboxes - Wall Clusters, Replace
Paint - Lobby, Atrium, & Halls
Paint - Metal
Paint - Wood Siding
Total
1,721
11,547
2,605
1,464
$17,338
Replacement Year 2007
Streets - Asphalt Repairs
Streets - Asphalt Seal Coat
Total
3,782
5,515
$9,297
Replacement Year 2008
Elevator - Major Repairs
Fence - Steel, Pool, Replace
12,752
18,184
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 17
Sample Reserve Study
RA Annual Expenditure Detail
Description
Expenditures
Replacement Year 2008 continued...
Pool Furniture - Replacement
Railing - Ext, Wrght Iron, Replace
Total
1,908
4,038
$36,883
No Replacement in 2009
Replacement Year 2010
Asphalt Overlay
Total
49,485
$49,485
Replacement Year 2011
Floor Cover - Carpet, Halls, Replace
Paint - Metal
Paint - Stucco
Paint - Wood Siding
Total
10,275
3,020
48,106
1,697
$63,099
Replacement Year 2012
Gutters & Downspouts - Replace
Lighting - Buildings, Replace
Lighting - EXIT/Emergency, Replace
Lighting - Wall Sconces, Replace
Pool - Replaster/Tile Replacement
Skylights - Roof, Replace
Streets - Asphalt Repairs
Streets - Asphalt Seal Coat
Total
1,582
2,362
7,090
7,938
8,099
1,748
4,384
6,393
$39,596
No Replacement in 2013
Replacement Year 2014
Paint - Lobby, Atrium, & Halls
Pool - Filter, Replace
Total
14,627
1,788
$16,416
Replacement Year 2015
Doors - Exterior, Metal, Replace
11,636
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 18
Sample Reserve Study
RA Annual Expenditure Detail
Description
Expenditures
Replacement Year 2015 continued...
Irrigation Controller - Replace
Pool Furniture - Replacement
Pool Heater - Replacement
Roofs - Built Up w/Gravel, Replace
Total
2,464
2,347
3,085
26,198
$45,730
Replacement Year 2016
Paint - Metal
Paint - Wood Siding
Play Equipment - Replace
Security - Access Phone, Replace
Security - Gate Operators, Sliding, Replace
Total
3,501
1,968
17,622
3,689
2,783
$29,563
Replacement Year 2017
Floor Cover - Carpet, Halls, Replace
Streets - Asphalt Repairs
Streets - Asphalt Seal Coat
Total
12,269
5,082
7,412
$24,763
Replacement Year 2018
Elevator - Cab Refurbishing
Hot Water Storage Tank - Replace
Total
9,659
4,674
$14,333
No Replacement in 2019
Replacement Year 2020
Lighting - Ceiling Recess Rounds, Replace
Lighting - Fluorescent Fixtures, Replace
Total
Replacement Year 2021
Paint - Metal
2,479
10,403
$12,882
4,059
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 19
Sample Reserve Study
RA Annual Expenditure Detail
Description
Expenditures
Replacement Year 2021 continued...
Paint - Stucco
Paint - Wood Siding
Total
64,650
2,281
$70,990
Replacement Year 2022
Mailboxes - Wall Clusters, Replace
Paint - Lobby, Atrium, & Halls
Pool Furniture - Replacement
Streets - Asphalt Repairs
Streets - Asphalt Seal Coat
Total
2,762
18,530
2,886
5,892
8,592
$38,662
Replacement Year 2023
Floor Cover - Carpet, Halls, Replace
Total
14,650
$14,650
Replacement Year 2024
Pool - Replaster/Tile Replacement
Total
11,547
$11,547
No Replacement in 2025
Replacement Year 2026
Elevator - Major Repairs
Fence - Steel, Pool, Replace
Paint - Metal
Paint - Wood Siding
Pool - Filter, Replace
Railing - Ext, Wrght Iron, Replace
Total
Replacement Year 2027
Irrigation Controller - Replace
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 20
21,709
30,957
4,706
2,645
2,550
6,875
$69,442
3,513
Sample Reserve Study
RA Annual Expenditure Detail
Description
Expenditures
Replacement Year 2027 continued...
Pool Heater - Replacement
Streets - Asphalt Repairs
Streets - Asphalt Seal Coat
Total
Replacement Year 2028
Security - Access Phone, Replace
Security - Gate Operators, Sliding, Replace
Total
Replacement Year 2029
Floor Cover - Carpet, Halls, Replace
Pool Furniture - Replacement
Roofs - Built Up w/Gravel, Replace
Total
Replacement Year 2030
Asphalt Overlay
Paint - Lobby, Atrium, & Halls
Total
Replacement Year 2031
Paint - Metal
Paint - Stucco
Paint - Wood Siding
Total
Replacement Year 2032
Boiler - Hot Water System, Replace
Elevator - Cab Refurbishing
Play Equipment - Replace
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 21
4,399
6,830
9,961
$24,703
5,260
3,968
$9,227
17,493
3,550
39,627
$60,670
89,376
23,473
$112,849
5,455
86,884
3,066
$95,405
36,456
14,611
28,279
Sample Reserve Study
RA Annual Expenditure Detail
Description
Expenditures
Replacement Year 2032 continued...
Streets - Asphalt Repairs
Streets - Asphalt Seal Coat
Total
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 22
7,918
11,547
$98,811
Sample Reserve Study
RA Detail Report by Category
Asphalt Overlay - 2010
Asset ID
1069
Placed in Service
Useful Life
Asphalt Pavement
January 1990
20
Replacement Year
Remaining Life
2010
7
35,000 - sq. ft. of asphalt overlay
7 - manhole cover adjustments
12 - valve cover adjustments
@
@
@
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
$40,236.00
100%
$49,485.20
$26,153.40
Monthly Assessment
Interest Contribution
Reserve Allocation
$212.31
$48.26
$260.58
$1.01 =
458.00 =
140.00 =
Total =
$35,350.00
3,206.00
1,680.00
$40,236.00
The cost of asphalt overlay is based on a minimum thickness of 1.5" and includes the cost of
applying a paving fabric.
Streets - Asphalt Repairs - 2007
Asset ID
1058
Asphalt Pavement
Placed in Service
January 1997
Useful Life
5
Adjustment
5
Replacement Year
2007
Remaining Life
4
35,000 sq. ft.
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
@ $6.40
$3,360.00
1.5%
$3,781.70
$2,016.00
Monthly Assessment
Interest Contribution
Reserve Allocation
$31.76
$3.86
$35.63
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 23
Sample Reserve Study
RA Detail Report by Category
Streets - Asphalt Repairs Continued...
The useful life on the asphalt repairs has been adjusted to align with the future cycle of the
asphalt sealing.
It is estimated that a percentage of the asphalt areas will require repair or replacement. The
actual condition of the asphalt should be monitored through time and the estimates adjusted
accordingly.
The actual date this item was placed in service was not available. For budgeting purposes, we
have estimated this date based upon its present condition.
Streets - Asphalt Seal Coat - 2007
Asset ID
1059
Asphalt Pavement
Placed in Service
January 2002
Useful Life
5
Replacement Year
Remaining Life
2007
4
35,000 sq. ft
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
@ $0.14
$4,900.00
100%
$5,514.99
$980.00
Monthly Assessment
Interest Contribution
Reserve Allocation
$88.93
$2.59
$91.52
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 24
Sample Reserve Study
RA Detail Report by Category
Streets - Asphalt Seal Coat Continued...
Asphalt surfaces should be sealed within 3 years of their initial installation. Thereafter, a 4 to 5
year cycle should be observed and adjusted according to the client's particular needs.
The cost includes any restriping that may be necessary.
The actual date this item was placed in service was not available. For budgeting purposes, we
have estimated this date based upon its present condition.
The replacement cost for this asset has been adjusted downward due to the large quantity to be
replaced or maintained.
Asphalt Pavement - Total Current Cost
Assigned Reserves
Fully Funded Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 25
$48,496
$29,149
$29,149
Sample Reserve Study
RA Detail Report by Category
Roofs - Built Up w/Gravel, Replace - 2015
Asset ID
1001
Placed in Service
Useful Life
Roofing
June 2001
14
Replacement Year
Remaining Life
2015
12
5,090 sq. ft.
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
@ $3.61
$18,374.90
100%
$26,198.21
none
Monthly Assessment
Interest Contribution
Reserve Allocation
$160.12
$1.54
$161.67
The client advises that these roofs were replaced during June 2001 for $18,476.
Main building
Building A
Total =
3,890
1,200
5,090
sq. ft.
It is recommended that the association secure cost proposals for the roofing replacement from
qualified roofing contractors or consultants as soon as practical. Roofing costs have risen
significantly due to new environmental and safety regulations, as well as higher costs of
materials. In addition, existing or changes to roofing specifications, choice of the quality of the
product, possible structural repairs, or other unknown factors can add to the cost. We can amend
this analysis using the current cost proposals in an updated or revised reserve study when the
information becomes available.
In order to ensure a high quality installation, the client may wish to obtain the services of an
independent roofing consultant to work with the client and the roofing contractor providing
installation. Consultants are available for the preparation of installation specifications and, if
desired, to work with the contractor during the installation process. We have been advised that
fees vary upon the size of the job and the extent of detail required by the client. However, fees
for a consultant should not exceed six to eight percent of the actual roof replacement cost. The
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 26
Sample Reserve Study
RA Detail Report by Category
Roofs - Built Up w/Gravel, Replace Continued...
costs we have used do not include this additional expense. Should the client request, we will be
happy to incorporate this into our calculations.
The cost used on this component includes the removal and disposal of the existing material.
The roofing specifications are unknown; therefore, the cost used on this built-up roof is based
upon replacing it with a 3-ply roof membrane. The useful life estimate is based upon the
assumption that the roof will be inspected annually and maintained as needed.
Roofing - Total Current Cost
Assigned Reserves
Fully Funded Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 27
$18,375
$0
$2,625
Sample Reserve Study
RA Detail Report by Category
Gutters & Downspouts - Replace - 2012
Asset ID
1004
Gutters & Downspouts
Placed in Service
January 1990
Useful Life
22
Replacement Year
Remaining Life
2012
9
170 lin. ft.
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
@ $7.13
$1,212.10
100%
$1,581.51
$716.24
Monthly Assessment
Interest Contribution
Reserve Allocation
$6.03
$1.32
$7.35
There are gutters and downspouts on Building A only.
gutters
downspouts
Total =
110
60
170
Gutters & Downspouts - Total Current Cost
Assigned Reserves
Fully Funded Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 28
sq. ft.
$1,212
$716
$716
Sample Reserve Study
RA Detail Report by Category
Skylights - Roof, Replace - 2012
Asset ID
1013
Placed in Service
Useful Life
Skylights
January 1990
22
Replacement Year
Remaining Life
2012
9
2 skylights
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
@ $670.00
$1,340.00
100%
$1,748.39
$791.81
Monthly Assessment
Interest Contribution
Reserve Allocation
$6.66
$1.46
$8.13
These skylights are 4' by 3'.
Skylights - Total Current Cost
Assigned Reserves
Fully Funded Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 29
$1,340
$792
$792
Sample Reserve Study
RA Detail Report by Category
Paint - Lobby, Atrium, & Halls - 2006
Asset ID
1011
Painting, Interior
Placed in Service
January 1998
Useful Life
8
Replacement Year
Remaining Life
2006
3
18,870 sq. ft.
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
@ $0.56
$10,567.20
100%
$11,547.06
$6,604.50
Monthly Assessment
Interest Contribution
Reserve Allocation
$121.57
$12.84
$134.42
This is the interiors for the main building. Building A has no interiors.
entry doors
lobby
hallway/atrium, 1st floor
hallway, 2nd floor
hallway, 3rd floor
hallway, 4th floor
garage, wall only
stairwells
Total =
690
1,130
4,380
1,610
1,610
420
3,840
5,190
18,870
sq. ft.
The actual date this item was placed in service was not available. For budgeting purposes, we
have estimated this date based upon its present condition.
Painting, Interior - Total Current Cost
Assigned Reserves
Fully Funded Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 30
$10,567
$6,604
$6,604
Sample Reserve Study
RA Detail Report by Category
Paint - Metal - 2006
Asset ID
1067
Painting, Exterior
Placed in Service
January 2001
Useful Life
5
Replacement Year
Remaining Life
2006
3
2,148 sq. ft.
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
@ $1.11
$2,384.28
100%
$2,605.36
$953.71
Monthly Assessment
Interest Contribution
Reserve Allocation
$42.82
$2.09
$44.92
This asset budgets for painting the metal fencing, gates and deck railing.
Paint - Stucco - 2011
Asset ID
1007
Placed in Service
Useful Life
Painting, Exterior
January 2001
10
Replacement Year
Remaining Life
2011
8
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
$37,975.00
100%
$48,105.59
$7,595.00
Monthly Assessment
Interest Contribution
Reserve Allocation
$374.60
$17.04
$391.65
The client advises that the entire association was painted, interior and exteriors for a total of
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 31
Sample Reserve Study
RA Detail Report by Category
Paint - Stucco Continued...
$54,139 during May 2002.
This is a five story building.
24,500 - sq. ft. of stucco, Main Building
@
$1.55 =
Total =
$37,975.00
$37,975.00
The actual date this item was placed in service was not available. For budgeting purposes, we
have estimated this date based upon its present condition.
Paint - Wood Siding - 2006
Asset ID
1066
Placed in Service
Useful Life
Painting, Exterior
January 2001
5
Replacement Year
Remaining Life
2006
3
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
$1,340.00
100%
$1,464.25
$536.00
Monthly Assessment
Interest Contribution
Reserve Allocation
$24.06
$1.17
$25.24
This is a two story building.
2,000 - sq. ft., siding, bldg A
@
$0.67 =
Total =
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 32
$1,340.00
$1,340.00
Sample Reserve Study
RA Detail Report by Category
Painting, Exterior - Total Current Cost
Assigned Reserves
Fully Funded Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 33
$41,699
$9,085
$9,085
Sample Reserve Study
RA Detail Report by Category
Fence - Steel, Pool, Replace - 2008
Asset ID
1016
Placed in Service
Useful Life
Fencing
January 1990
18
Replacement Year
Remaining Life
2008
5
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
$15,685.60
100%
$18,183.90
$11,328.48
Monthly Assessment
Interest Contribution
Reserve Allocation
$88.63
$20.87
$109.51
This is painted steel tubular fencing with a spear top.
120 - lin. ft. of 6'H fencing, pool
1 - gate, 2'W x 6'H
150 - lin. ft., driveway, 6'H
1 - vehicle gate, 18'x6'H, driveway
@
@
@
@
$46.58 =
192.00 =
46.58 =
2,917.00 =
Total =
Fencing - Total Current Cost
Assigned Reserves
Fully Funded Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 34
$5,589.60
192.00
6,987.00
2,917.00
$15,685.60
$15,686
$11,328
$11,328
Sample Reserve Study
RA Detail Report by Category
Pool - Filter, Replace - 2014
Asset ID
1063
Placed in Service
Useful Life
Pool
January 2002
12
Replacement Year
Remaining Life
2014
11
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
$1,292.00
100%
$1,788.42
$107.66
Monthly Assessment
Interest Contribution
Reserve Allocation
$11.14
$0.29
$11.43
The pool contractor advises that this Purex 60 sq. ft. pool filter was placed in serviced during
2002.
The actual month this item was placed in service was not available. For budgeting purposes we
have used the month corresponding to the beginning of the client's fiscal year.
Pool - Replaster/Tile Replacement - 2012
Asset ID
1060
Placed in Service
Useful Life
Pool
January 2000
12
Replacement Year
Remaining Life
2012
9
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
$6,207.20
100%
$8,098.98
$1,551.80
Monthly Assessment
Interest Contribution
Reserve Allocation
$52.41
$3.24
$55.66
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 35
Sample Reserve Study
RA Detail Report by Category
Pool - Replaster/Tile Replacement Continued...
The pool appears to be in good condition.
800 - sq. ft. of pool replastering
120 - lin. ft. of trim tile
20 - lin. ft. of lane tile
@
@
@
$5.12 =
15.08 =
15.08 =
Total =
$4,096.00
1,809.60
301.60
$6,207.20
The actual date this item was placed in service was not available. For budgeting purposes, we
have estimated this date based upon its present condition.
Pool Furniture - Replacement - 2008
Asset ID
1061
Placed in Service
Useful Life
Pool
January 2001
7
Replacement Year
Remaining Life
2008
5
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
$1,646.00
100%
$1,908.16
$470.28
Monthly Assessment
Interest Contribution
Reserve Allocation
$21.92
$1.04
$22.96
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 36
Sample Reserve Study
RA Detail Report by Category
Pool Furniture - Replacement Continued...
This Tropi-Kai style furniture appears to be in good conditon.
4 - chairs
1 - bruch table
1 - fabric umbrella
$220.00 =
362.00 =
404.00 =
Total =
@
@
@
$880.00
362.00
404.00
$1,646.00
Pool Heater - Replacement - 2003
Asset ID
1062
Placed in Service
Useful Life
Pool
January 1990
12
Replacement Year
Remaining Life
2003
0
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
$2,164.00
100%
$2,164.00
$2,164.00
Monthly Assessment
Interest Contribution
Reserve Allocation
$18.85
$0.18
$19.04
The pool contractor advises that this 400K Teledyne Laars pool heater is original and is in poor
condition.
Pool - Total Current Cost
Assigned Reserves
Fully Funded Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 37
$11,309
$4,294
$4,294
Sample Reserve Study
RA Detail Report by Category
Play Equipment - Replace - 2016
Asset ID
1064
Placed in Service
Useful Life
Play Equipment
January 2000
16
Replacement Year
Remaining Life
2016
13
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
$12,000.00
100%
$17,622.40
none
Monthly Assessment
Interest Contribution
Reserve Allocation
$98.34
$0.95
$99.29
The actual date this item was placed in service was not available. For budgeting purposes, we
have estimated this date based upon its present condition.
Play Equipment - Total Current Cost
Assigned Reserves
Fully Funded Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 38
$12,000
$0
$2,250
Sample Reserve Study
RA Detail Report by Category
Railing - Ext, Wrght Iron, Replace - 2008
Asset ID
1053
Placed in Service
Useful Life
Railings, Metal
January 1990
18
Replacement Year
Remaining Life
2008
5
120 - lin. ft. of 3.5'H railing, decks
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
$3,483.60
100%
$4,038.44
$2,515.93
Monthly Assessment
Interest Contribution
Reserve Allocation
$19.68
$4.63
$24.32
@
$29.03 =
Total =
Railings, Metal - Total Current Cost
Assigned Reserves
Fully Funded Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 39
$3,483.60
$3,483.60
$3,484
$2,516
$2,516
Sample Reserve Study
RA Detail Report by Category
Lighting - Ceiling Recess Rounds, Replace - 2020
Asset ID
1026
Lighting, Interior
Placed in Service
August 1998
Useful Life
22
Replacement Year
Remaining Life
2020
17
12 fixtures
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
@ $125.00
$1,500.00
100%
$2,479.27
none
Monthly Assessment
Interest Contribution
Reserve Allocation
$10.12
$0.09
$10.22
The client advises that all light fixtures were replaced or modified during August1998, to reduce
electricity usage and, therefore reduce costs . The hallway wall sconces, emergency double
spots, and EXIT signs were not part of this program.
Lighting - EXIT/Emergency, Replace - 2012
Asset ID
1022
Placed in Service
Useful Life
Lighting, Interior
January 1990
22
Replacement Year
Remaining Life
2012
9
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
$5,434.00
100%
$7,090.13
$3,211.00
Monthly Assessment
Interest Contribution
Reserve Allocation
$27.04
$5.93
$32.97
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 40
Sample Reserve Study
RA Detail Report by Category
Lighting - EXIT/Emergency, Replace Continued...
13 - EXIT emergency signs
@ $418.00 =
Total =
$5,434.00
$5,434.00
Lighting - Fluorescent Fixtures, Replace - 2020
Asset ID
1020
Placed in Service
Useful Life
Lighting, Interior
August 1998
22
Replacement Year
Remaining Life
2020
17
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
$6,294.00
100%
$10,403.02
none
Monthly Assessment
Interest Contribution
Reserve Allocation
$42.47
$0.41
$42.88
The client advises that all light fixtures were replaced or modified during August 1998, to reduce
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 41
Sample Reserve Study
RA Detail Report by Category
Lighting - Fluorescent Fixtures, Replace Continued...
electricity usage and, therefore reduce costs .
24 - fluor, 8' dbl, w/o lens, garage
3 - fluor, 4' dbl, w/o lens, garage
15 - fluor, 4' dbl, w/lens, hallways
Lighting - Wall Sconces, Replace - 2012
Asset ID
1024
Placed in Service
Useful Life
Lighting, Interior
January 1990
22
Replacement Year
Remaining Life
2012
9
$166.00 =
100.00 =
134.00 =
Total =
@
@
@
$3,984.00
300.00
2,010.00
$6,294.00
39 sconces
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
@ $156.00
$6,084.00
100%
$7,938.23
$3,595.09
Monthly Assessment
Interest Contribution
Reserve Allocation
$30.27
$6.64
$36.92
These wall sconces are located in the hallways.
Lighting, Interior - Total Current Cost
Assigned Reserves
Fully Funded Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 42
$19,312
$6,806
$8,577
Sample Reserve Study
RA Detail Report by Category
Lighting - Buildings, Replace - 2012
Asset ID
1068
Lighting, Exterior
Placed in Service
January 1990
Useful Life
22
Replacement Year
Remaining Life
2012
9
4 - vapor flood fixtures, Main Building
2 - wall mount lanterns, Building A
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
$1,810.00
100%
$2,361.63
$1,069.54
Monthly Assessment
Interest Contribution
Reserve Allocation
$9.00
$1.97
$10.98
@
@
$425.00 =
55.00 =
Total =
$1,700.00
110.00
$1,810.00
All cost estimates have been calculated based upon the original inventory as identified in this
section. It is likely that future replacements will vary and therefore the cost used may be
considered as a general indication of budgetary needs rather than specific for these components.
Lighting, Exterior - Total Current Cost
Assigned Reserves
Fully Funded Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 43
$1,810
$1,070
$1,070
Sample Reserve Study
RA Detail Report by Category
Floor Cover - Carpet, Halls, Replace - 2005
Asset ID
1027
Placed in Service
Useful Life
Floor Cover
January 1999
6
Replacement Year
Remaining Life
2005
2
160 sq. yds.
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
@ $47.38
$8,111.45
107%
$8,605.44
$5,407.63
Monthly Assessment
Interest Contribution
Reserve Allocation
$121.11
$10.72
$131.84
The client advises that this new carpeting was installed during December 1998 for $6,998.
1st floor
2nd floor
3rd floor
4th floor
Total =
45
50
50
15
160
sq. yrds.
The measurement indicated represents the actual area to be replaced. The percentage of
replacement has been increased above 100% to allow for a waste factor which should be
considered when replacing this component.
The current cost used on this asset is based upon actual expenditures incurred at last
replacement, and has been adjusted for inflation where applicable.
Date For budgeting purposes, we have used the next fiscal year's beginning date as the placed-inservice date for this component.
Floor Cover - Total Current Cost
Assigned Reserves
Fully Funded Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 44
$8,111
$5,408
$5,408
Sample Reserve Study
RA Detail Report by Category
Boiler - Hot Water System, Replace - 2032
Asset ID
1039
Hot Water System
Placed in Service
March 2002
Useful Life
30
Replacement Year
Remaining Life
2032
29
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
$15,470.00
100%
$36,456.06
none
Monthly Assessment
Interest Contribution
Reserve Allocation
$76.16
$0.73
$76.90
This is a 15,500 KBTU input, Teledyne Laars boiler. The client advises that it was replaced
during March 2002 for $15,000.
The cost estimates on this asset were originally provided by the client, and have been adjusted to
allow for inflationary changes.
Hot Water Storage Tank - Replace - 2018
Asset ID
1040
Placed in Service
Useful Life
Hot Water System
March 2002
16
Replacement Year
Remaining Life
2018
15
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
$3,000.00
100%
$4,673.90
none
Monthly Assessment
Interest Contribution
Reserve Allocation
$22.11
$0.21
$22.32
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 45
Sample Reserve Study
RA Detail Report by Category
Hot Water Storage Tank - Replace Continued...
This is an insulated, 150 gallon, hot water storage tank. The client advises that this water storage
tank was placed in service during March 2002 with the boiler for $2,913.
The current cost used on this asset is based upon actual expenditures incurred at last
replacement, and has been adjusted for inflation where applicable.
Hot Water System - Total Current Cost
Assigned Reserves
Fully Funded Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 46
$18,470
$0
$703
Sample Reserve Study
RA Detail Report by Category
Elevator - Cab Refurbishing - 2004
Asset ID
1036
Placed in Service
Useful Life
Elevator
January 1990
14
Replacement Year
Remaining Life
2004
1
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
$6,200.00
100%
$6,386.00
$5,757.14
Monthly Assessment
Interest Contribution
Reserve Allocation
$41.82
$10.57
$52.40
This is a 5' x 6.5' elevator cab. The cab has carpeted walls with a mid-grade of carpet and tile
flooring with a non-skid rubber mat. Lighting in the cab is a large round fluorescent fixture.
Elevator - Major Repairs - 2008
Asset ID
1037
Placed in Service
Useful Life
Elevator
January 1990
18
Replacement Year
Remaining Life
2008
5
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
$11,000.00
100%
$12,752.01
$7,944.44
Monthly Assessment
Interest Contribution
Reserve Allocation
$62.16
$14.63
$76.79
This category is for the additional major repair costs associated with hydraulic style elevators
such as valve and cylinder replacements. Cab refurbishing alone is generally sufficient for
traction style elevators as all additional maintenance is usually covered within the elevator
service agreements.
Elevator - Total Current Cost
Assigned Reserves
Fully Funded Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 47
$17,200
$13,702
$13,702
Sample Reserve Study
RA Detail Report by Category
Security - Gate Operators, Sliding, Replace - 2004
Asset ID
1030
Placed in Service
Useful Life
Adjustment
Replacement Year
Remaining Life
Gate Operator
January 1990
12
2
2004
1
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
$1,895.00
100%
$1,951.85
$1,759.64
Monthly Assessment
Interest Contribution
Reserve Allocation
$12.78
$3.23
$16.01
The gate operator opens the driveway vehicle gate. It appears to be in working order.
The useful life of this asset has been extended due to its present condition.
Gate Operator - Total Current Cost
Assigned Reserves
Fully Funded Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 48
$1,895
$1,760
$1,760
Sample Reserve Study
RA Detail Report by Category
Security - Access Phone, Replace - 2004
Asset ID
1028
Placed in Service
Useful Life
Adjustment
Replacement Year
Remaining Life
Security
January 1990
12
2
2004
1
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
$2,512.00
100%
$2,587.36
$2,332.57
Monthly Assessment
Interest Contribution
Reserve Allocation
$16.94
$4.28
$21.23
This is a Nutone, "hands free", access phone. It is in working condition.
The useful life of this asset has been extended due to its present condition.
Security - Total Current Cost
Assigned Reserves
Fully Funded Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 49
$2,512
$2,333
$2,333
Sample Reserve Study
RA Detail Report by Category
Doors - Exterior, Metal, Replace - 2015
Asset ID
1014
Placed in Service
Useful Life
Doors, Exterior
January 1990
25
Replacement Year
Remaining Life
2015
12
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
$8,161.00
100%
$11,635.63
$3,280.39
Monthly Assessment
Interest Contribution
Reserve Allocation
$45.32
$6.23
$51.56
9 - doors, 3'W x 7'H, solid core, stairwells
@ $473.00 =
6 - doors, 3'W x 7'H, solid core, parking area @ 473.00 =
2 - doors, 4'W x 8'H, Main Bldg, util, 2 vents @ 533.00 =
Total =
Doors, Exterior - Total Current Cost
Assigned Reserves
Fully Funded Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 50
$4,257.00
2,838.00
1,066.00
$8,161.00
$8,161
$3,280
$4,244
Sample Reserve Study
RA Detail Report by Category
Irrigation Controller - Replace - 2003
Asset ID
1046
Landscape Equipment
Placed in Service
January 1990
Useful Life
12
Replacement Year
Remaining Life
2003
0
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
$1,728.00
100%
$1,728.00
$1,728.00
Monthly Assessment
Interest Contribution
Reserve Allocation
$15.05
$0.14
$15.20
The landscape contractor advises that these Irritrol irrigation controllers are in poor condition.
2 - 8 station controllers
@
$864.00 =
Total =
$1,728.00
$1,728.00
The information used on this asset has been provided with the assistance of the client's
maintenance contractor.
Landscape Equipment - Total Current Cost
Assigned Reserves
Fully Funded Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 51
$1,728
$1,728
$1,728
Sample Reserve Study
RA Detail Report by Category
Mailboxes - Wall Clusters, Replace - 2006
Asset ID
1047
Placed in Service
Useful Life
Mailboxes
January 1990
16
Replacement Year
Remaining Life
2006
3
35 boxes
Asset Cost
Percent Replacement
Future Cost
Assigned Reserves
@ $45.00
$1,575.00
100%
$1,721.04
$1,279.68
Monthly Assessment
Interest Contribution
Reserve Allocation
$9.64
$2.35
$12.00
These mailboxes are located in the lobby.
Mailboxes - Total Current Cost
Assigned Reserves
Fully Funded Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 52
$1,575
$1,280
$1,280
Sample Reserve Study
RA Detail Report by Category
Contingency or Operational Funded
These components are intended to be funded by reserve contingency, or operational contingency,
or the operational account, or not intended to be funded at all. See the individual component
detail for specific information. All of these components have been arbitrarily grouped together.
Traffic Signs
Asset ID
1070
Contingency
There are several traffic signs within the association. These signs are currently maintained by
the city and are expected to have a useful life equal to the life of the community. They should
only need to be replaced due to weather or vandalism and in the event that the city will no longer
maintain the signs they will be budgeted for in the operation budget of the association. The
condition of the signs at the time of the last field inspection was near new.
Contingency - Total Current Cost
Assigned Reserves
Fully Funded Reserves
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 53
$0
$0
$0
Sample Reserve Study
RA Detail Report by Category
Detail Report Summary
Total of All Assets
Assigned Reserves
Monthly Contribution
Monthly Interest
Monthly Allocation
$101,850.00
$1,495.41
$187.75
$1,683.17
Contingency at 3.00%
Assigned Reserves
Monthly Contribution
Monthly Interest
Monthly Allocation
$3,150.00
$46.25
$5.80
$52.05
Grand Total
Assigned Reserves
Monthly Contribution
Monthly Interest
Monthly Allocation
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 54
$105,000.00
$1,541.66
$193.56
$1,735.23
Sample Reserve Study
RA Program Features & Benefits - Page 3
Several stock charts to choose from are completely and easily edited
Print sections/pages selectable (user choice to print only one page if
needed)
Prints on any Windows printer
Versatile report options
Insert user defined pages to the report for project specific information
Charts & User Defined pages can be opened and edited in Microsoft
Word
Project Assets database can be opened and edited in Microsoft
Access
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 55
Sample Reserve Study
RA Category Detail Index
Number
Description
Replacement
Page
1069
1039
1014
1036
1037
1016
1027
1004
1040
1046
1068
1026
1022
1020
1024
1047
1011
1067
1007
1066
1064
1063
1060
1061
1062
1053
1001
1028
1030
1013
1058
1059
1070
Asphalt Overlay
Boiler - Hot Water System, Replace
Doors - Exterior, Metal, Replace
Elevator - Cab Refurbishing
Elevator - Major Repairs
Fence - Steel, Pool, Replace
Floor Cover - Carpet, Halls, Replace
Gutters & Downspouts - Replace
Hot Water Storage Tank - Replace
Irrigation Controller - Replace
Lighting - Buildings, Replace
Lighting - Ceiling Recess Rounds, Replace
Lighting - EXIT/Emergency, Replace
Lighting - Fluorescent Fixtures, Replace
Lighting - Wall Sconces, Replace
Mailboxes - Wall Clusters, Replace
Paint - Lobby, Atrium, & Halls
Paint - Metal
Paint - Stucco
Paint - Wood Siding
Play Equipment - Replace
Pool - Filter, Replace
Pool - Replaster/Tile Replacement
Pool Furniture - Replacement
Pool Heater - Replacement
Railing - Ext, Wrght Iron, Replace
Roofs - Built Up w/Gravel, Replace
Security - Access Phone, Replace
Security - Gate Operators, Sliding, Replace
Skylights - Roof, Replace
Streets - Asphalt Repairs
Streets - Asphalt Seal Coat
Traffic Signs
2010
2032
2015
2004
2008
2008
2005
2012
2018
2003
2012
2020
2012
2020
2012
2006
2006
2006
2011
2006
2016
2014
2012
2008
2003
2008
2015
2004
2004
2012
2007
2007
unfunded
2 - 23
2 - 45
2 - 50
2 - 47
2 - 47
2 - 34
2 - 44
2 - 28
2 - 45
2 - 51
2 - 43
2 - 40
2 - 40
2 - 41
2 - 42
2 - 52
2 - 30
2 - 31
2 - 31
2 - 32
2 - 38
2 - 35
2 - 35
2 - 36
2 - 37
2 - 39
2 - 26
2 - 49
2 - 48
2 - 29
2 - 23
2 - 24
2 - 53
Total Funded Assets
Total Unfunded Assets
Total Assets
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 56
32
1
33
Sample Reserve Study
RA Annual Asset Expenditure Charts
Annual Expenditures
120,000
100,000
80,000
60,000
40,000
20,000
0
'03 '04 '05 '06 '07 '08 '09 '10 '11 '12 '13 '14 '15 '16 '17 '18 '19 '20 '21 '22 '23 '24 '25 '26 '27 '28 '29 '30 '31 '32
Fiscal Year
Asset Current Cost By Category
Asphalt Pavement
4%
5%
Painting, Exterior
4%
Lighting, Interior
21%
Hot Water System
5%
Roofing
5%
Elevator
7%
Fencing
18%
7%
Play Equipment
Pool
8%
8%
8%
Painting, Interior
Doors, Exterior
Other
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 57
Sample Reserve Study
RA Funding Model Comparison By Percent Funded Chart
Funding Model Comparison By Percentage Funded
120%
Percent Fully Funded
100%
80%
60%
40%
20%
0%
'03 '04 '05 '06 '07 '08 '09 '10 '11 '12 '13 '14 '15 '16 '17 '18 '19 '20 '21 '22 '23 '24 '25 '26 '27 '28 '29 '30 '31 '32
Fiscal Year
Current Funding Model
Threshold Funding Model
Component Funding Model
The chart above compares the three funding models (Current Assessment Funding Model, Threshold
Funding Model and Component Funding Model) by the percentage fully funded over 30 years. This
allows your association to view and then choose the funding model that might best fit your community’s
needs.
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 58
Sample Reserve Study
RA Funding Model Reserve Ending Balance Comparison Chart
Funding Model Comparison
Projected Reserve Ending Balances
450,000
400,000
350,000
300,000
250,000
200,000
150,000
100,000
50,000
0
'03 '04 '05 '06 '07 '08 '09 '10 '11 '12 '13 '14 '15 '16 '17 '18 '19 '20 '21 '22 '23 '24 '25 '26 '27 '28 '29 '30 '31 '32
Fiscal Year
Current Funding Model
Threshold Funding Model
Component Funding Model
Fully Funded
The chart above compares the projected reserve ending balances of the three funding models (Current
Assessment Funding Model, Threshold Funding Model and Component Funding Model) over 30 years.
RESERVE ANALYST, LLC •800.561.0173
PAGE 2 - 59