Image description goes here Image description goes here Image description goes here

What is the RFA?

The Reserve Funding Analyzer is a Microsoft Excel-based application that has been developed for HOAs and community associations to perform financial analysis on the HOA expenses and develop a funding plan to meet those expenses.

The RFA is used as a critical element in performing Reserve Study ... either a full Reserve Study or an update to a Reserve Study.

 The RFA is suitable for any size organization and can be used as part of  the development of a full reserve study or an update to an existing reserve study.

How Does it Work?

The Reserve Funding Analyzer works like any MS Excel application.  The user enters data and the application calculates the outcome.

But with the RFA, you do not have to create the relationships.  The application has been developed for you with extensive built in programming and very intuitive data input.

The key feature for the user is the ability to quickly perform what-if analysis and instantly see the results.

 

What is the Output?

The Reserve Funding Analyzer provides several tables, charts and graphs.  Once a funding plan is developed, the results are easily copied to the report format of your choosing ... whether that is a MS Word-type document or a presentation format document.

The RFA is a native MS Excel workbook and as part of the MS Office family, you can take full advantage of the features that are part of MS Office.

The Reserve Funding Analyzer is a full-function financial analysis tool.

 Click any image below for a larger view and a slide show

Reserve Study Financials

This software is the perfect application for developing the financials for a Reserve Study.

Development History

HOAs and community associations have a responsibility to establish and maintain a Replacement Reserve Fund to provide for the maintenance or replacement of the association's depreciable components.  Some governing bodies require that the HOA conduct a regular review of their reserve components funding plan as a requirement of their fiduciary responsibility to manage the association's funds and property. 

During the development of this application, the key design factor was to make the application one that could be used by anyone with moderate expertise with MS Excel and a basic foundation understanding of reserve funding requirements.  That said, this tool is ideal for the HOA or community association that wishes to perform reserve study themselves.  A caveat though, many professionals are available to conduct reserve studies.  If your association has never conducted a full reserve study, you should strongly consider employing the services of a qualified reserve study professional. 

For most organizations, however, updates to an existing reserve study (whether they include a site visit or not), are generally much easier to perform as the reserve component inventory is typically unchanged.  Generally, these updates can easily be performed by HOA or association themselves.  Especially true for smaller HOAs.  Besides an update of the actual component inventory, the purpose of regular updates is to review the financial information and funding plan.  The Reserve Funding Analyzer was developed as a tool for HOAs and community associations to perform the analysis and develop sound funding plans.  It does not replace the sound judgment of a qualified reserve study professional ... but it does provide the means for conducting financial analyses of an association's reserve components.  It can be used as the financial tool for a full reserve study or, more commonly, used to create financial analysis and develop funding strategies when updating an existing full reserve study.

How is the RFA used in a Reserve Study

A reserve study essentially consists of four parts:

  1. A comprehensive inventory of reserve components and their associated useful lives and costs.
  2. A reasonable estimate of operational revenue and expenses
  3.  Knowledge of the existing operational and reserve funds
  4. A reserve funding plan that provides a schedule of the date and amount of funds required to sufficiently fund required maintenance or replacement of the reserve components.

The first part can generally be performed by people familiar with the property with a good knowledge of typical components.  Users can also rely on vendors to provide information and they can reference previous studies as reserve components do not change much over time.

Parts two and three are typically known by the community manager or managing board. 

The fourth part requires extensive knowledge of financial capital planning or the use of specialized software.  This is where the Reserve Funding Analyzer (RFA) comes into play.  The RFA provides intuitive data input of the reserve component and financial data variables and gives you a tool to perform comprehensive financial analysis.  The output from the RFA gives you all the data that you need to create the funding plan that meets the standards of various governing bodies.

Standards and Compliance

State Compliance

The State of California and over 29 other states, require that HOAs prepare and distribute operational and reserve components financial information to any interested party.  The Reserve Funding Analyzer meets the compliance requirements imposed by these states with regard to the calculations and output for inclusion into a reserve study report.

CAI Guidlines

The Community Association Institute publishes guidelines for conducting reserve studies.  The Reserve Funding Analyzer complies with the these guidelines for development of the financial analyses used in reserve studies.

APRA Standards

The Reserve Funding Analyzer meets the Standards of Practice guidelines for financial analyses published by the Association of Professional Reserve Analysts.

Watch a short YouTube Video

I created a short (5 minute) video to show you some of the many functions and features available to you. Click the icon to view.

Get the Application

Purchase

The Reserve Funding Analyzer is packaged as a digital download.  Once you have completed the purchase, you will be directed to a download page where you can download the application and support materials.

Cost  —  $125

All payments are processed through PayPal

Packaging
  • Reserve Funding Analyzer application ... a native MS Excel Macro Enabled workbook
  • End User License Agreement
  • RFA Usage document
  • RFA ReadMe document
  • State of CA Reserve Guidelines document
  • RFA PowerPoint template
Prerequisites

The Reserve Funding Analyzer is a native macro-enabled MS Excel workbook.  It was developed using MS Excel 2010 and Windows 7.  It has been tested on MS Excel 2013 / 365 and Windows 10.   If you are using MS Excel on Mac, some macros may not function.  We are working on resolving this.

Support
  • Full support on using the Reserve Funding Analyzer is available through e-mail
  • When updates are available, you will receive them at no additional cost

Secure Payment by PayPal 

Buy now

No-Cost Trial Version

You may obtain a no-cost trial version of the RFA.  This is fully functioning version of the RFA, with an expiration of 7 days.

  • Full functionality
  • All graphs and tables

Click here to download the no cost 7-day trial version.

If you have any questions or comments,  send an email to info@reservefundinganalyzer.com

Have Questions?

Use the contact link below to send an email.  Your questions will be answered as rapidly as possible.  Typically less than 24 hours.

100% Satisfaction Guarantee

In case you're not 100% satisfied with the software, you have the right to return the software within 15 days after purchase:

  • Remove the software from your server(s) and archives
  •  Inform us by e-mail at info@reservefundinganalyzer.com 
  • Include your registration name or e-mail address in the notification e-mail, and your money will be refunded.