The HOME Multifamily Underwriting Template is a series of spreadsheets within a Microsoft Excel workbook that allows you to create a customized profile of a rental housing development scheme and determine what role HOME funds might play in the project. Using the online training material in tandem with the Template is strongly recommended in order to improve its results - especially for those using the Template for the first time.

In addition to helping you profile your project, the Template will help you generate a pro-forma, as well. But while the format of the pro-forma generated by the Template is effective in exploring a project's feasibility, it is not the only format used by lenders and other members of a typical development team.

The U.S. Department of Housing and Urban Development and ICF Consulting assume no liability for the use, functionality or content of this template. This template is for draft calculations only. All inputs, outcomes, and calculations should be independently verified.

To download the Underwriting Template, perform the following simple steps:

1. Open the HOME Multifamily Underwriting Template.
2. Once it has opened within MS Excel, select the "Save As" (under the File menu) option.
3. Save the MS Excel file in a location on your computer that you can remember.