1 / 12

Overview of the Affordable Housing Program Owner Project Workbook

Overview of the Affordable Housing Program Owner Project Workbook. (AHP/APP-104). 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.

aysha
Download Presentation

Overview of the Affordable Housing Program Owner Project Workbook

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

More Related