Overview of the Affordable Housing Program Owner Project Workbook

1. Overview of the Affordable Housing Program Owner Project Workbook (AHP/APP-104)

2. Overview & System Requirements • Customized Microsoft Excel 2007 Workbook that replaces the former Microsoft Excel Workbooks for Owner Project Workbook submissions utilized in prior AHP rounds. • Requires Microsoft Excel 2007, or later, in a Windows environment to be installed on the User’s machine. • Utilizes standard Excel functionality to ensure maximum compatibility across all prospective Users; any PC running Windows with Microsoft Excel 2007 (or later) installed should be able to complete and save an AHP Owner Project Workbook (workbook.xlsm). • The template can be downloaded directly from the FHLBNY’s public Website; once downloaded, the User can begin filling out the AHP Owner Project Workbook.

3. Instructions Tab • Provides an overview of each worksheet • Users should input information into cells shaded in yellow • Cells shaded in orange provide formulas to recognize possible input errors • Red triangles contain comments to assist in completing the workbook

4. Project Schedule Tab • Provides the anticipated timeline of the Project lifecycle • Appropriate dates are entered into the yellow cells • Additional pertinent objectives may be added to the grid in the Other section

5. Site Information Tab • Provides a detailed breakdown of the site(s) within the Project • The top portion should be data for the location of the majority of project units • The next section should include specific data on each address

6. Development Budget Tab • Provides a breakdown of the Total Project Costs • Indicate what will be paid for with AHP funds • TIPS: • Total Acquisition on Dev Budget must equal Acquisition Price on Site Info this must be substantiated by 3rd party documentation • Total Construction Costs on Dev Budget must equal the construction cost documentation submitted • Any amounts input on the “Other” line items on the DevBudget must be further explained on the Supplement worksheet

7. Supplement Tab • Provides details for the “Other” soft costs on the Dev Budget • Input the Profit, Overhead and General Requirement amount and all Commercial Construction costs

8. Source of Funds Tab • Provides a list of the Project’s source of funds and their corresponding commitment statuses • Select the Funding Source Type from the dropdown menu and then provide the name of the source and the amount of construction and permanent funding. • The commitment status is only required for the permanent financing sources

9. Targeting Tab • Provides data on the targeting, unit counts and bedroom distribution for the Project • Input income limits into the AMI chart – use the current year’s income • Next, input data points shaded in yellow for each targeted AMI for your Project • If applicable, provide any explanations relevant to that Targeted AMI bucket • Dropdowns are available for Targeted AMI, Unit Type & Apartment Type

10. Market Tab • Provides a breakdown of the Project’s typical household by Targeted AMI buckets • For purchase transactions only, including Habitat projects, provide the expected purchase transaction details • For all transactions, provide the expected financing details for a typical household • For all transactions, provide the typical household’s income and expenses • Select the Funding Source Type from the dropdown menu and then provide the name of the source and the amount of permanent funding.

11. Results Tab • Provides a summary of the data that has been input • Provides a measurement of your application against the Bank’s feasibility guidelines • Provide a detailed explanation to any items resulting in “Explain” • Provides a per unit breakdown of costs and financing as compared to the Project • Provides a snapshot of the typical household’s debt-to-income ratios

12. Questions? Please e-mail us at ahp@fhlbny.com