AvachaTech

Where Policy and Technology Meet

Contact Us

Financial Waterfall

Financial analytics for the affordable
housing industry

AvachaTech's Financial Waterfall app is designed to track financial and operational performance of affordable housing properties and automatically calculates and projects the waterfall of project fee, reserve, loan, and bond payments throughout the compliance period.


The Financial Waterfall app is built in Salesforce, giving it built-in reporting and analytics capabilities. It can be installed as a stand-alone app within a new Salesforce environment or it can enhance your existing Salesforce architecture.


Click the link to the right to visit the Financial Waterfall website.


Financial Waterfall

VIA
Virtual Impact Analysis

VIA is an online tool designed specifically for Moving to Work housing authorities to assess the impact of program and policy changes. Click the link to the right to visit the VIA website.
Impact Analysis

Our Services 

Data and Impact Analysis

Data is the underlying component of any modern business, regardless of the sector.  AvachaTech helps organizations manage data to inform their business decisions.

Affordable Housing Policy Development

AvachaTech works with Moving to Work housing authorities to craft and implement new policies.  This includes styding the policy choices to determine their impact, writing policy language, drafting materials for Board approval, and working with staff to put the new policies in place.

Process Automation

AvachaTech helps organizations with process automation in order to eliminate redundancies, reduce data processing time, and give policy-makers control over user choices.

Software Implementation

At AvachaTech, we understand how overwhelming software implementation can be.  Whether your project is a simple stand-alone software program or it is a complex rework of all of your current legacy systems, we can help.

Project Management

Effective project planning and execution is essential to the success of any project.  AvachaTech has extensive experience in leading and completing complex projects.

Our Projects 

NOFA Application

Software Implementation

Designed and built an application and portal used by developers to apply for packaged loans for affordable housing development. The application includes the routing, scoring, approval, and award of applications.

MTW Impact Analysis

Data Modeling

Utilizing AvachaTech's proprietary software (VIA) and multiple Excel data models, helped several Moving to Work housing authorities analyze the impact of their MTW waivers.  Included writing the full impact analysis covering all HUD required metrics, including impact on the agency's financials and disparate impact based on race, ethnicity and other factors.

IT Feasibility Study

IT Project Management

Wrote a feasibility study that assessed an agency’s software needs and business processes. The process included working with staff, board members, and state legislators to document all agency processes, identify gaps, and create a comprehensive report used to procure new software. 

Other Projects...


  • Payment Standard Analysis and Implementation

    Performed an in-depth analysis of the impact of a new alternative payment standard schedule on households and the agency budget.  Once the analysis was completed and presented to the team, worked with operations to implement both the new payment standards and utility allowances within their existing software system.

  • Choice Neighborhoods Application

    Worked with a large public housing authority to draft and submit its application for a $500,000 Choice Neighborhoods Planning Grant.  Work included project-managing the application process, gathering required materials, writing application material, and compiling the application for submission.

  • MTW Implementation (Asset Building)

    Worked with a new Moving to Work (MTW) agency in Asset Building cohort to draft its first MTW supplement and submit to HUD.  Work included the following:

    • Work sessions with staff and leadership team to select and prioritize waivers
    • Draft board materials and MTW supplement language
    • Perform full impact analysis and work with team to understand the results
    • Advise on MTW policy questions
  • Legal Case Management Software Implementation

    Project managed the implementation of a legal case management system for a State agency.  Work included the following:

    • Performed all project management tasks on behalf of the agency
    • Advised client on contract scopes of work and related matters
    • Drafted and edited project documents and materials
    • Handled all data conversion efforts on behalf of the agency and provided data to vendor for migration
    • Coordinated project tasks and milestones between vendors and state agencies
    • Oversaw budget and schedule

  • MTW Implementation (Landlord Incentives)

    Worked with a new Moving to Work (MTW) agency in Landlord Incentive cohort to draft its first MTW supplement and submit to HUD.  Work included the following:

    • Work sessions with staff and leadership team to select and prioritize waivers
    • Draft board materials and MTW supplement language
    • Perform full impact analysis and work with team to understand the results
    • Advise on MTW policy questions
  • Shelter Capital Funding

    Worked with a County in Oregon to prioritize and select shelter projects to fund.  Included assessing shelter needs, working with County staff to understand funding requirements and restrictions, drafting contract scopes of work, participating in work sessions with shelter providers, and drafting other project materials for the team.

  • Simplified Utility Allowance

    Worked with housing authority staff to design a simplified utility allowance schedule.  Work involved the following:

    • Reviewing and analyzing all available utility data
    • Developing various options and strategies
    • Analyzing six different variations of the schedule for impact on the agency and residents
    • Drafting a proposal to the team with recommended next steps
  • Financial Waterfall

    Designed and implemented an application to calculate financial waterfalls for affordable housing and tax credit developments.  This application is hosted in Salesforce and includes automated waterfall calculation, tracking annual financial statements, and tracking other compliance-related activities.

  • MTW Application (Asset Building)

    Project-managed the application process and wrote the MTW application for a housing authority, which was ultimately successful.  This project included: 

    • Working with PHA team to define and prioritize activities and understand cohort requirements;
    • Drafting the MTW Plan and Application;
    • Creating several presentations for the County board, residents, and the general public; and
    • Drafting Board materials for the public hearing, special session, and Board approval.
  • Housing Choice Voucher Process Analysis

    Worked with a housing authority to analyze and document all processes and procedures used in the management of the Housing Choice Voucher program.  Included developing a library of processes and forms, identifying areas for improvement, and training staff on new procedures.

  • Yardi Implementation

    Project-managed the implementation of Yardi for a public housing authority (PHA).  Included working with PHA staff and Yardi to define requirements and training needs, handling data conversion tasks for the PHA, set up financial systems and define financial reporting needs, and advise on best practices.

  • Multifamily Project Database and Tracking System

    Designed, built, and implemented system for inputting and tracking multifamily projects from project inception through completion. Includes the ability to track all project financials, waterfalls, and residual receipts.

  • Affordable Housing Database

    Designed, built, and implemented an affordable housing database used to input, manage, and evaluate data related to affordable housing projects.  This system enabled the client to easily see various restrictions placed on each property, identify the most restrictive restrictions, and evaluate whether a property is in compliance.

  • Moving to Work Policy Development

    Worked with housing authority to draft application to HUD's Moving to Work (MTW) program, which was ultimately successful.  This project included oversight of the public process and preparation of all materials for the housing authority board and the public.

  • MTW Application (Rent Reform)

    Project-managed the application process and wrote the MTW application for a housing authority, which was ultimately successful.  This project included: 

    • Performing a detailed analysis of the impact of the new rent structure on existing households using AvachaTech’s VIA software;
    • Drafting the MTW Plan and Application;
    • Creating several presentations for the County Board, residents, and the general public; and
    • Drafting all Board materials for the public hearing, special session, and Board approval.
  • Project Turnkey Grant Application

    Worked with a housing authority to prepare and submit an application for Project Turnkey funds.  The application was utlimately successful and enabled the agency to purchase a hotel to house individuals unable to socially distance.  This project included the development of all Board and public process documents.

  • Local Implementation Plan Development

    Worked with a housing authority to draft a local implementation plan (LIP) document used to implement a regional supportive housing services program serving homeless families.

  • National Environmental Policy Act (NEPA) Compliance Tracking System

    Designed, built, and implemented a system for tracking NEPA Compliance.  The system stores high level project information and links the NEPA compliance information to projects already stored in other applications within the database.  The system also stores funding sources for all projects and allows staff to record field inspections and track mitigation requirements.

  • Accounting Inegration

    Designed and managed the build and implementation of an integration between Salesforce and Intacct.  All payables and receivables originated in Salesforce and were synced either nightly or on demand to Intacct.  On the AP side, checks were issued out of Intacct and the information was sent back to Salesforce; on the AR side, the transactions were reconciled with bank deposits.

  • Housing Management System

    Designed and managed the build and implementation of a housing management system in Salesforce that included all functions related to Public Housing, Tax Credits, and Section 8.  Functions included certifications / rent calculations, waitlist management, move-ins / outs, inspections, work orders, tenant accounting, Section 8 accounting, 50058 creation and export, etc.

  • Executive Discussion Tracker

    Designed, built, and implemented an application used to track goals, discussion items, and notes for an executive team.

  • Reasonable Accommodations

    Designed and managed the build and implementation of a custom system used to manage reasonable accommodations.  The system significantly reduced the agency’s legal exposure by automating the approval of accommodations based on a set of clear legal requirements.  Note that as part of this process, a patent was secured for the unique approach to assessing RA’s.

  • Case Management System

    Designed and managed the build and implementation of a case management system, including a customized MTW FSS program.  Case management was based on bridge assessments and logic was built to route cases based on complexity and intensity.

  • Family Self-Sufficiency (FSS) Add-On

    Designed an add-on built in ColdFusion for managing a custom Family Self-Sufficiency program.  Rather than earning escrow based on an increase in income like the traditional FSS program, the modified FSS program deposits funds into clients’ escrow accounts based on meeting certain “pay points”.  If the client meets their obligations, then the escrow is later disbursed to the client upon move out.  Note that this system was later replaced by Salesforce using the same design requirements.

  • Moving to Work (MTW) Rent Reform Add-On

    Designed an add-on built in ColdFusion that connected to the VisualHOMES housing software.  This add-on was used to calculate household’s rent outside of the standard HUD method for rent calculation.  Note that this system was later replaced by Salesforce using the same design requirements.

  • Property Based Subsidy Program

    Designed and built an application to accommodate a custom landlord payment program called Property Based Subsidy (PBS).  Unlike traditional Section 8 where payments are made to landlords based on each tenant on program, PBS pays landlords a set amount each month as long as the landlord complies with the program income requirements.  This project included the capability to import client data into the system each quarter to verify program compliance.

  • Incident and Insurance Claim Tracking

    Designed and implemented a system in SharePoint for tracking agency incidents and insurance claims.  Note that this system was later replaced by Salesforce using the same design requirements.

Our story

Todd Craven started AvachaTech with a focus on helping public sector clients improve processes and implement policy changes using technology and data modeling.  AvachaTech has completed a number of projects, including software implementations, grant applications, policy implementations, feasibility studies, and data models.  In addition, AvachaTech has developed a tool, called VIA, that will be used to help Moving to Work housing authorities measure the impact of various policy and program changes.

Contact Us

Share by: