Reserve Funding Reserve Funding Reserve Funding

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 the  tables, charts and graphs to support your reserve funding plan.

The resulting output provides an evaluation of the current strength of the reserve fund and helps you develop a recommended multi-year reserve funding plan.

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

The RFA stands heads and shoulders above any other reserve funding applications ... in terms of function and price.  You will not find a better application for developing your association's funding plan.  The RFA is easy to use and walks you through the development of your plan.  The end result is to give you a good understanding of your association's financial commitment and funding needs.

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 ... whether you are an association board member, an accountant or a reserve study professional.  This tool is ideal for the HOA or community association that wishes to perform reserve study themselves. 

In many cases, an association has had a previous reserve study.  This application is ideal for performing an update as the reserve component inventory is typically unchanged.  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 can be used as the financial tool for a full reserve study or 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 replacement costs.
  2. An estimate of operational revenue and expenses.
  3.  Knowledge of the existing operational and reserve funds
  4. A multi-year 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, such as the community members, property managers and board members.  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.

YouTube Videos

Introduction 

This introductory video is nine minutes long and covers the major functions and structure of the Reserve Funding Analyzer.

You will learn the navigation principles using the RFA, which parts of the application require data entry and which parts are informational.   

Reserve Funding Basics
 

This video provides  explanation about reserve funding and building a reserve funding plan. Learn about concepts such as Fully Funded Balance, funding methods, the difference between straight line funding and cash flow funding.  Also learn why  monitoring the fully funded balance percent is important to developing a sense of the risk of special assessments. 

Data Entry
 

In this second instructional video using the RFA, learn how to perform data entry. Generally starting with entering reserve component data and then following up with the financial information such as annual operational expenses and current income that HOA receives. 

Build Funding Plan
 

This video demonstrates how to develop a multi-year funding plan using the data from the Data Entry example. 

DIY Physical Inventory


  
The most time consuming part to creating your own reserve study is the physical inventory and analysis of the reserve components.  This video provides guidelines on how to do this.

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  —  $195

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.   Due to incompatibilities with MS Excel for Mac, the application is not compatible with Apple products.

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 

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.