RENTAL ASSISTANCE DEMONSTRATION | |
U.S. Department of HUD, Form HUD-5260 | |
OMB Approval Number 2577-xxxx (Issue Date x/xx) (Expires x/xx) |
|
Paperwork Reduction Notice: The information collection requirements contained in this notice have been approved by the Office of Management and Budget (OMB) under the Paperwork Reduction Act of 1995 (44 U.S.C. 3520). Public reporting burden for this collection of information is estimated to average 2 hours per response, including the time for reviewing instructions, searching existing data sources , gathering and maintaining the data needed, and completing and reviewing the collection of information. This agency may not collect this information, and you are not required to complete this form, unless it displays a currently valid OMB control number. This collection of information is required for applying to the Rental Assistance Demonstration pursuant to PL-112-55 and HUD requirements as explained in PIH Notice PIH-2012-032. The information will be used to provide HUD with sufficient information to enable a determination that the proposed conversion is financially feasible and that HUD statutory and regulatory requirements have been met. Please address any comments or questions on this data collection to rad@hud.gov and the appropriate personnel will respond to your inquiry in a timely manner. HUD may not collect this information, and you are not required to complete this form unless it displays a currently valid OMB number. Limited confidentiality is assured. |
|
Note: This Excel Spreadsheet has multiple worksheets listed in the tabs below. Depending upon each worksheet’s applicability to your application, you may be required to fill out several of these worksheets in order for HUD to consider your application complete. To navigate amoung the worksheets, click the indivdual worksheet tabs at the bottom of this window. If no worksheet tabs are visible, select "Options ..." from the "Tools" menu. In the dialogue box, select the "View" tab and then "Normal". | |
Instructions to Applicants: Public Housing Agencies | |
INTRODUCTION | |
1 | In accordance with Notice PIH-2012-32, this Excel-based Application Form shall be used by public housing agencies (PHAs) in submitting applications under the Rental Assistance Demonstration (RAD). |
2 | As part of the application, the user will be completing both an Operating Pro-Forma and a Development Budget for the proposed conversion. An application cannot be submitted (see "fatal error" message, below) if the Pro-Forma or Development Budget do not balance or otherwise contain error messages. |
GENERAL INSTRUCTIONS | |
1 | Complete one Application Form for each public housing project proposed for conversion. |
2 | Upon completion of the application, print out the associated attachments. |
3 | Submit the completed application, along with the signed attachments (where applicable), and email to RADApplication@hud.gov. |
HOW THIS EXCEL WORKBOOK WORKS | |
1 | In order to obtain this Excel workbook, go to the RAD website (www.hud.gov/rad), and click on 'Obtain Excel Application for PHAs'. Enter the project's PIC Development Number. The web site will auto-populate certain cells with information on the project from HUD systems. You can then download this Excel workbook and save it on your computer. |
2 | Fill in all items that appear in grey highlight. |
3 | Bright blue squares containing a white question mark offer additional guidance. Place the mouse cursor over the square to read this guidance. |
4 | Note that, for the purposes of reviewing applications, HUD has standardized some of the financing assumptions. These benchmarks/assumptions are only for the purposes of reviewing the applications; actual lender underwriting may be different. If an entry trips one of these assumptions, an error message will appear, indicating either that the user provide an explanation or that the user enter an amount that complies with the standardized assumption. |
5 | If a "fatal error" message appears in red, the application cannot be submitted. Review the fatal error message and correct the input(s) as needed. The fatal error message will disappear once the input(s) has been corrected. |
6 | Once all information has been entered, print the following form-generated attachments (where applicable): • Board Approval Form. This is a document that the PHA and the PHA Board must approve. A PDF copy of the signed document must be submitted with the RAD Application. It summarizes key aspects of the application. Failure to submit an executed form with the application will result in its rejection. • Financing Letter of Interest/Intent. This is a document that a lender or equity investor must sign. A PDF copy of the signed document must be submitted with the RAD Application. It is designed to give the lender or equity investor information on key aspects of the proposed transaction. A separate Financing Letter of Interest/Intent must be submitted for each proposed source of funding. Failure to submit all of the required Letters of Interest/Intent with the application will result in its rejection. • Mixed-Finance Affidavit. This is a document that the PHA and the owner-representative of the mixed-finance project must sign. A PDF copy of the signed document must be submitted with the RAD application for any mixed-finance project. PHAs should note that the Notice provides that mixed-finance projects funded with HOPE VI grants are eligible only if the Date of Full Availability (DOFA) is October 1, 2002 or earlier; and • Choice-Mobility Letter Agreement. This is a document that will be signed by both the PHA that is providing choice-mobility vouchers and by the PHA (or Mod Rehab project owner) whose RAD project will receive the choice-mobility vouchers. A PDF copy of the signed document must be submitted with the Application in order to qualify for the choice-mobility ranking factor. These attachments will include the name of the authorized representative identified in the application. Additionally, the Board Approval Form and the Financing Letter of Interest/Intent will include both a Statement of Sources and Uses and a Financing Pro-Forma, generated from the information submitted on the Application Form. Note that the Application Form, along with all the attachments, must be submitted electronically as part of the submission package. The full list of attachments needed will be automatically generated at the end of the Application Form once it has been completed. |
THE VALIDATION WORKSHEET | |
This worksheet shows the detailed calculations for potential PBRA and PBV rents. It also shows the historical FASS-PH data for the referenced project. |
If required, this worksheet should be printed, signed and attached as a PDF to the application email. | ||||||||||||
Identify the person who will sign the PHA Certification: | ||||||||||||
Lewis McDonald | Executive Director | |||||||||||
Name | Title | Date Signed | ||||||||||
Attachment 1A: Board Approval Form | ||||||||||||
This application will be rejected if submitted; there are 5 fatal errors. | ||||||||||||
Jefferson County Housing Authority RAD Application for FULTON/BROOK/HICKORY/RED HOLLOW | ||||||||||||
AMP No: | AL086000001 | |||||||||||
Units | 205 | |||||||||||
Type of Conversion | ||||||||||||
PBRA (Project Based Rental Assistance) | ||||||||||||
Proposed Units for Conversion and De Minimis | ||||||||||||
Summary | Total Units Proposed for Conversion | Units Proposed to be Reduced | de minimis threshold | |||||||||
194 | 11 | 10 | ||||||||||
Explanation for de minimis reduction | Unit Count | |||||||||||
Pro Forma Sources and Uses | ||||||||||||
Sources of Funds | Amount | Per Unit | ||||||||||
New First Mortgage Loan | $0 | $0 | ||||||||||
Public Housing Operating Reserves | $0 | $0 | ||||||||||
Public Housing Capital Funds | $0 | $0 | ||||||||||
Replacement Housing Factor | $0 | $0 | ||||||||||
Low Income Housing Tax Credit Equity - 4% | $0 | $0 | ||||||||||
Other | $0 | $0 | ||||||||||
Other | $0 | $0 | ||||||||||
Other | $0 | $0 | ||||||||||
Total Sources of Funds | $0 | $0 | ||||||||||
Uses of Funds | Amount | Per Unit | ||||||||||
Acquisition Costs | $0 | $0 | ||||||||||
Construction Costs | $0 | $0 | ||||||||||
Relocation Costs | $0 | $0 | ||||||||||
Professional Fees | $0 | $0 | ||||||||||
Loan Fees and Costs | $0 | $0 | ||||||||||
Reserves | $0 | $0 | ||||||||||
Developer Fees | $0 | $0 | ||||||||||
Total Uses of Funds | $0 | $0 | ||||||||||
Stabilized Cash Flow Pro Forma | ||||||||||||
Total | PUPA | |||||||||||
Gross Potential Rents for RAD Units | $1,308,936 | $6,747 | ||||||||||
Gross Potential Rents for Other Apartment Units | $0 | $0 | ||||||||||
Gross Potential Rents for Commercial | $0 | N/A | ||||||||||
Vacancy Loss and Bad Debt Loss | ($65,447) | -$337 | ||||||||||
Other Income | $0 | $0 | ||||||||||
Effective Gross Income | $1,243,489 | $6,410 | ||||||||||
Total Operating Expenses | $0 | $0 | ||||||||||
Annual Deposit to Replacement Reserve | $0 | $0 | ||||||||||
Net Operating Income | $1,243,489 | $0 | ||||||||||
First Mortgage Debt Service | $0 | $0 | ||||||||||
Operating Cash Flow | $1,243,489 | $0 | ||||||||||
PHA's Explanation of Any Relocation of Tenants (Estimated Relocation Cost is $0) | ||||||||||||
N/A | ||||||||||||
PHA's Explanation of Capacity and Experience to Carry Out the RAD Conversion | ||||||||||||
N/A | ||||||||||||
PHA's Explanation of the Proposed Total Operating Cost being less then 85% of the 3 Year Historical Operating Expenses | ||||||||||||
3 Year Historical Average Comparison | 2009 | 2010 | 2011 | Average | Proposed | |||||||
$1,216,159 | $1,152,883 | #N/A | $1,184,521 | $0 | ||||||||
N/A | ||||||||||||
PHA's Explanation of the Capital Needs and Replacement Reserves Estimates | ||||||||||||
N/A | ||||||||||||
Discussion of QAP timing | ||||||||||||
N/A | ||||||||||||
Demonstration of recent success obtaining 9% LIHTCs | ||||||||||||
N/A | ||||||||||||
Likelihood of obtaining 9% LIHTCs | ||||||||||||
N/A | ||||||||||||
I hereby certify to the following: (1) that I have the requisite authority to execute this application on behalf of the owner; (2) that HUD can rely upon this certification in evaluating the Application, (3) that I acknowledge that I have read and understand PIH Notice 2012-32 (the "Notice"), which describes the Rental Assistance Demonstration (RAD) (the "Program"), and agree to comply with all requirements of the Program or Notice; (4) that all materials submitted in association with the application are accurate, complete and not misleading; (5) that the application meets all applicable eligibility requirements for the Program set forth in the Notice; (6) that the owner approves the creation of a single-asset entity of the affected project if required by the lender to facilitate financing; (7) that, if selected for award, the owner will comply with the fair housing and civil rights requirements at 24 CFR 5.105(a) (general requirements) and will affirmatively further fair housing; (8) that there are no debarments, suspensions, or Limited Denials of Participation in Federal programs lodged against the applicant, PHA Executive Director, Board members, or affiliates; (9) that this Board Approval Form has been approved by the Board of Commissioners on the date noted below; and (10) that, if selected for an award, the PHA will comply with all provisions of HUD’s Commitment to Enter into a HAP (CHAP), which shall indicate the HUD-approved terms and conditions for conversion of assistance, or will indicate to HUD within 15 days that it is refusing the terms of the CHAP and withdrawing from RAD participation. | ||||||||||||
Warning: HUD will prosecute false claims and statements. Conviction may result in criminal and/or civil penalties (18 USC Sections 1001, 1010, 1012; 31 USC Sections 3729, 3802) | ||||||||||||
PHA Certification: By Lewis McDonald (Executive Director) | ||||||||||||
December 30, 1899 | ||||||||||||
Signature: | Date: | |||||||||||
If required, this worksheet should be printed, signed and attached as a PDF to the application email. | |||||||||||||||||||
Identify the lender firm / equity investor that will sign the Financing Letter of Interest/Intent | |||||||||||||||||||
ABC Mortgage Corporation | |||||||||||||||||||
Identify the person who will sign on behalf of the lender / investor: | |||||||||||||||||||
Gustavo Martinez | Vice President | ||||||||||||||||||
Name | Title | Date Signed | |||||||||||||||||
Attachment 1B: Financing Letter of Interest/Intent | |||||||||||||||||||
Jefferson County Housing Authority RAD Application for FULTON/BROOK/HICKORY/RED HOLLOW | |||||||||||||||||||
AMP No: | AL086000001 | ||||||||||||||||||
Units | 205 | ||||||||||||||||||
Type of Conversion | |||||||||||||||||||
PBRA (Project Based Rental Assistance) | |||||||||||||||||||
Pro Forma Sources and Uses | |||||||||||||||||||
Sources of Funds | Amount | Per Unit | |||||||||||||||||
New First Mortgage Loan | $0 | $0 | |||||||||||||||||
Public Housing Operating Reserves | $0 | $0 | |||||||||||||||||
Public Housing Capital Funds | $0 | $0 | |||||||||||||||||
Replacement Housing Factor | $0 | $0 | |||||||||||||||||
Low Income Housing Tax Credit Equity - 4% | $0 | $0 | |||||||||||||||||
Other | $0 | $0 | |||||||||||||||||
Other | $0 | $0 | |||||||||||||||||
Other | $0 | $0 | |||||||||||||||||
Total Sources of Funds | $0 | $0 | |||||||||||||||||
Uses of Funds | Amount | Per Unit | |||||||||||||||||
Acquisition Costs | $0 | $0 | |||||||||||||||||
Construction Costs | $0 | $0 | |||||||||||||||||
Relocation Costs | $0 | $0 | |||||||||||||||||
Professional Fees | $0 | $0 | |||||||||||||||||
Loan Fees and Costs | $0 | $0 | |||||||||||||||||
Reserves | $0 | $0 | |||||||||||||||||
Developer Fees | $0 | $0 | |||||||||||||||||
Total Uses of Funds | $0 | $0 | |||||||||||||||||
Stabilized Cash Flow Pro Forma | |||||||||||||||||||
Total | PUPA | ||||||||||||||||||
Gross Potential Rents for RAD Units | $1,308,936 | $6,747 | |||||||||||||||||
Gross Potential Rents for Other Apartment Units | $0 | $0 | |||||||||||||||||
Gross Potential Rents for Commercial | $0 | N/A | |||||||||||||||||
Vacancy Loss and Bad Debt Loss | ($65,447) | -$337 | |||||||||||||||||
Other Income | $0 | $0 | |||||||||||||||||
Effective Gross Income | $1,243,489 | $6,410 | |||||||||||||||||
Total Operating Expenses | $0 | $0 | |||||||||||||||||
Annual Deposit to Replacement Reserve | $0 | $0 | |||||||||||||||||
Net Operating Income | $1,243,489 | $0 | |||||||||||||||||
First Mortgage Debt Service | $0 | $0 | |||||||||||||||||
Operating Cash Flow | $1,243,489 | $0 | |||||||||||||||||
PHA's Explanation of the Proposed Total Operating Cost being less then 85% of the 3 Year Historical Operating Expenses | |||||||||||||||||||
3 Year Historical Average Comparison | 2009 | 2010 | 2011 | Average | Proposed | ||||||||||||||
$1,216,159 | $1,152,883 | #N/A | $1,184,521 | $0 | |||||||||||||||
N/A | |||||||||||||||||||
PHA's Explanation of the Capital Needs and Replacement Reserves Estimates | |||||||||||||||||||
N/A | |||||||||||||||||||
Discussion of QAP timing | |||||||||||||||||||
N/A | |||||||||||||||||||
Demonstration of recent success obtaining 9% LIHTCs | |||||||||||||||||||
N/A | |||||||||||||||||||
Likelihood of obtaining 9% LIHTCs | |||||||||||||||||||
N/A | |||||||||||||||||||
Statement of Lender / Equity Provider: | |||||||||||||||||||
The project appears feasible for ABC Mortgage Corporation to fund. Our general repayment terms and any conditions are stated above and/or in the comment block below. ABC Mortgage Corporation understands and acknowledges the RAD program requirements and policies and agrees to cooperate with the applicable RAD processes, as appropriate. This letter of interest/intent is not a firm commitment. Final approval will be contingent on the results of ABC Mortgage Corporation due diligence process and approvals. | |||||||||||||||||||
State any exceptions or additional conditions | |||||||||||||||||||
ABC Mortgage Corporation: By Gustavo Martinez (Vice President) | |||||||||||||||||||
December 30, 1899 | |||||||||||||||||||
Signature: | Date: | ||||||||||||||||||
If required, this worksheet should be printed, signed and attached as a PDF to the application email | ||||||||||||||||||||
Identify the person who will sign on behalf of the PHA: | ||||||||||||||||||||
Lewis McDonald | Executive Director | |||||||||||||||||||
Name | Title | Date Signed | ||||||||||||||||||
Identify the legal entity that owns the mixed finance project: | ||||||||||||||||||||
Name | Title | Date Signed | ||||||||||||||||||
Attachment 1C –Mixed-Finance Affidavit | ||||||||||||||||||||
Of Jefferson County Housing Authority | ||||||||||||||||||||
And | ||||||||||||||||||||
Regarding Jefferson County Housing Authority RAD Application for FULTON/BROOK/HICKORY/RED HOLLOW | ||||||||||||||||||||
1. | Lewis McDonald certifies that he or she is the Executive Director of Jefferson County Housing Authority and that he or she has been authorized by Jefferson County Housing Authority to execute this Mixed Finance Affidavit. | |||||||||||||||||||
2. | certifies that he or she is the of and that he or she has been authorized by to execute this Mixed Finance Affidavit. | |||||||||||||||||||
3. | Jefferson County Housing Authority and , through their duly authorized representatives, agree that if the application for FULTON/BROOK/HICKORY/RED HOLLOW (AL086000001), is awarded entry into the Rental Assistance Demonstration, they will, if requested to do so by HUD: | |||||||||||||||||||
(a) Convert the subject project’s current subsidy to long-term Section 8 rental assistance in accordance with the requirements of the Rental Assistance Demonstration ("RAD") including, without limitation, the requirements of Notice PIH-2012-32 (the "Notice"). | ||||||||||||||||||||
(b) Agree to Section 8 contract rent levels in accordance with RAD and the Notice. | ||||||||||||||||||||
(c) Comply with all applicable requirements of RAD and the Notice. | ||||||||||||||||||||
(d) Enter into one or more agreements to carry out the foregoing commitments. Such agreements shall include, without limitation, a Housing Assistance Payments (HAP) contract that: | ||||||||||||||||||||
(a) In the case of a RAD conversion to project based rental assistance, shall be between the project owner and the contract administrator designated by HUD; and | ||||||||||||||||||||
(b) In the case of a RAD conversion to project based voucher assistance, shall be between the project owner and a public housing authority designated by HUD. | ||||||||||||||||||||
Jefferson County Housing Authority: By Lewis McDonald (Executive Director) | ||||||||||||||||||||
December 30, 1899 | ||||||||||||||||||||
Signature: | Date: | |||||||||||||||||||
: By () | ||||||||||||||||||||
December 30, 1899 | ||||||||||||||||||||
Signature: | Date: |
If required, this worksheet should be printed, signed and attached as a PDF to the application email | ||||||||||||||||||||
Identify the PHA that is contributing choice-mobility vouchers: | ||||||||||||||||||||
Identify the person who will sign on behalf of the PHA that is contributing vouchers: | ||||||||||||||||||||
Name | Title | Date Signed | ||||||||||||||||||
Identify the PHA that is receiving choice-mobility vouchers: | ||||||||||||||||||||
Identify the person who will sign on behalf of the PHA that is receiving vouchers: | ||||||||||||||||||||
Name | Title | Date Signed | ||||||||||||||||||
Attachment 1D – Choice-Mobility Letter Agreement | ||||||||||||||||||||
Between (contributing vouchers) | ||||||||||||||||||||
And (receiving vouchers) | ||||||||||||||||||||
Regarding Jefferson County Housing Authority RAD Application for FULTON/BROOK/HICKORY/RED HOLLOW | ||||||||||||||||||||
1. | Capitalized terms herein shall have the meaning given to them in Notice PIH-2012-32 (the "Notice") and in the Rental Assistance Demonstration ("RAD"). | |||||||||||||||||||
2. | certifies that he or she is the of and that he or she has been authorized by to enter into this Choice-Mobility Letter Agreement regarding the RAD application submitted by FULTON/BROOK/HICKORY/RED HOLLOW (AL086000001). | |||||||||||||||||||
3. | certifies that he or she is the of and that he or she has been authorized by to enter into this Choice-Mobility Letter Agreement regarding the RAD application submitted by FULTON/BROOK/HICKORY/RED HOLLOW (AL086000001). | |||||||||||||||||||
4. | , through its duly authorized representative, commits that if the subject project converts assistance under RAD, will provide Section 8 Housing Choice Vouchers to the assisted residents of the subject project to achieve the choice-mobility objective described in Section 1.7(5)(C) of the Notice. agrees that this commitment is binding on without regard to whether any RAD application submitted by is selected for participation in RAD. | |||||||||||||||||||
5. | acknowledges that if the subject project's application for RAD conversion is incomplete, fails to meet threshold criteria, or is submitted outside of the Initial Application Period, will not earn any Ranking Factor. However, if such application is submitted during the Initial Application Period, is complete, and meets threshold criteria, then will earn a Ranking Factor regardless of whether such application is selected, or, once selected, is withdrawn or terminated. | |||||||||||||||||||
6. | acknowledges that if the subject project's application for RAD conversion is incomplete, fails to meet threshold criteria, or is submitted outside of the Initial Application Period, will not earn any Ranking Factor. | |||||||||||||||||||
: By () | ||||||||||||||||||||
December 30, 1899 | ||||||||||||||||||||
Signature: | Date: | |||||||||||||||||||
: By () | ||||||||||||||||||||
December 30, 1899 | ||||||||||||||||||||
Signature: | Date: |
Formula RAD Rents (PBRA and PBV) | |||||||||||||||||||||
Funding Baseline (pre-RAD) | Annual | Per Unit | PUPM | 205 | ACC units in PIC (after any corrections) | ||||||||||||||||
Operating Fund | $977,137 | $4,767 | $397.21 | ||||||||||||||||||
Capital Fund | $257,496 | $1,256 | $104.67 | ||||||||||||||||||
Tenant Payments | $160,121 | $781 | $65.09 | ||||||||||||||||||
Total | $1,394,754 | $6,804 | $566.97 | ||||||||||||||||||
Funding Utilized if PBRA Selected | $1,308,936 | $6,747 | $562.26 | 93.8% | of baseline funding is utilized | ||||||||||||||||
Funding Utilized if PBV Selected | $0 | $0 | $0.00 | 0.0% | of baseline funding is utilized | ||||||||||||||||
Baseline Funding By Unit Type | 0-BR | 1-BR | 2-BR | 3-BR | 4-BR | 5-BR | 6-BR | Monthly | Annual | ||||||||||||
Units | 0 | 20 | 104 | 65 | 16 | 0 | 0 | 205 | 205 | ||||||||||||
FMR | $605 | $673 | $750 | $952 | $980 | $1,127 | $1,274 | ||||||||||||||
Ratio FMR : 2BR FMR | 0.807 | 0.897 | 1.000 | 1.269 | 1.307 | 1.503 | 1.699 | ||||||||||||||
# Units of 2BR FMR Equivalents | 0.00 | 17.95 | 104.00 | 82.51 | 20.91 | 0.00 | 0.00 | 225.36 | |||||||||||||
BR Adjusted Rents | $416 | $463 | $516 | $655 | $674 | $775 | $877 | ||||||||||||||
Proposed Units | 0 | 20 | 104 | 54 | 16 | 0 | 0 | ||||||||||||||
Preliminary Actual Rents | $0 | $463 | $516 | $655 | $674 | $0 | $0 | $109,078 | $1,308,936 | ||||||||||||
Formula Rents if Project Based Rental Assistance is Proposed: | |||||||||||||||||||||
0-BR | 1-BR | 2-BR | 3-BR | 4-BR | 5-BR | 6-BR | Monthly | Annual | |||||||||||||
Units | 0 | 20 | 104 | 54 | 16 | 0 | 0 | 194 | 194 | ||||||||||||
Preliminary Contract Rents | $0 | $463 | $516 | $655 | $674 | $0 | $0 | $109,078 | $1,308,936 | ||||||||||||
FMR | $605 | $673 | $750 | $952 | $980 | $1,127 | $1,274 | $158,548 | $1,902,576 | ||||||||||||
Utility Allowance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||||
Rent Reasonable | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||||
120% FMR, minus Utility Allowance | $726 | $808 | $900 | $1,142 | $1,176 | $1,352 | $1,529 | $190,244 | $2,282,928 | ||||||||||||
150% FMR, minus Utility Allowance | $908 | $1,010 | $1,125 | $1,428 | $1,470 | $1,691 | $1,911 | $237,822 | $2,853,864 | ||||||||||||
PBRA-Contract Rent * | $463 | $516 | $655 | $674 | $109,078 | $1,308,936 | |||||||||||||||
* Lower of preliminary contract rent and [120% of FMR minus utility allowance]. Reasonable rent does not affect this calculation. | |||||||||||||||||||||
Formula Rents if Project Based Vouchers are Proposed: | |||||||||||||||||||||
0-BR | 1-BR | 2-BR | 3-BR | 4-BR | 5-BR | 6-BR | Monthly | Annual | |||||||||||||
Units | 0 | 20 | 104 | 54 | 16 | 0 | 0 | 194 | 194 | ||||||||||||
Preliminary Contract Rents | $0 | $463 | $516 | $655 | $674 | $0 | $0 | $109,078 | $1,308,936 | ||||||||||||
Rent Reasonable | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||||
FMR | $605 | $673 | $750 | $952 | $980 | $1,127 | $1,274 | $158,548 | $1,902,576 | ||||||||||||
Utility Allowance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||||
110% FMR, minues Utility Allowance | $666 | $740 | $825 | $1,047 | $1,078 | $1,240 | $1,401 | $174,403 | $2,092,834 | ||||||||||||
PBV-Contract Rents ** | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||
** Lowest of preliminary contract rent, reasonable rent, and [110% of FMR minus utility allowance] | |||||||||||||||||||||
Latest Board Approved Operating Expenses | |||||||||||||||||||||
2009 AFS | 2010 AFS | #N/A | 3 yr Average | ||||||||||||||||||
Provided? | Yes | Yes | MISSING | ||||||||||||||||||
Vacancy Loss % | 1.62% | 2.51% | #N/A | 2.06% | 1 year of data missing; average is 2 years | ||||||||||||||||
Total Operating Expenses: | $1,186,674 | $1,135,141 | #N/A | ||||||||||||||||||
Administrative | $458,532 | $436,237 | #N/A | $447,385 | 1 year of data missing; average is 2 years | ||||||||||||||||
Asset Management Fee | $24,720 | $24,720 | #N/A | $24,720 | 1 year of data missing; average is 2 years | ||||||||||||||||
Tenant Services | $22,755 | $16,082 | #N/A | $19,419 | 1 year of data missing; average is 2 years | ||||||||||||||||
Utility Expense | $203,977 | $215,545 | #N/A | $209,761 | 1 year of data missing; average is 2 years | ||||||||||||||||
Ordinary Maint and Ops | $447,104 | $412,542 | #N/A | $429,823 | 1 year of data missing; average is 2 years | ||||||||||||||||
Protective Services | $0 | $0 | #N/A | $0 | 1 year of data missing; average is 2 years | ||||||||||||||||
Real Estate Taxes | $0 | $0 | #N/A | $0 | 1 year of data missing; average is 2 years | ||||||||||||||||
Property Insurance | $27,947 | $28,376 | #N/A | $28,162 | 1 year of data missing; average is 2 years | ||||||||||||||||
Liability Insurance | $1,639 | $1,639 | #N/A | $1,639 | 1 year of data missing; average is 2 years | ||||||||||||||||
Other General Expenses | $0 | $0 | #N/A | $0 | 1 year of data missing; average is 2 years | ||||||||||||||||
Bad Debt Loss ($) | $29,485 | $17,742 | #N/A | $23,614 | 1 year of data missing; average is 2 years | ||||||||||||||||
2 Years Prior | 1 Year Prior | Most Recent | 3 yr Average | ||||||||||||||||||
Total FASS Operating Expenses: | $1,216,159 | $1,152,883 | #N/A | $1,184,521 | 1 year of data missing; average is 2 years | ||||||||||||||||
3 yr Average | Corrected | ||||||||||||||||||||
Vacancy Loss % | 2.06% | 2.06% | |||||||||||||||||||
Total Operating Expenses: | $1,160,908 | $1,160,908 | |||||||||||||||||||
Administrative | $447,385 | $447,385 | |||||||||||||||||||
Asset Management Fee | $24,720 | $24,720 | |||||||||||||||||||
Tenant Services | $19,419 | $19,419 | |||||||||||||||||||
Utility Expense | $209,761 | $209,761 | |||||||||||||||||||
Ordinary Maint and Ops | $429,823 | $429,823 | |||||||||||||||||||
Protective Services | $0 | $0 | |||||||||||||||||||
Real Estate Taxes | $0 | $0 | |||||||||||||||||||
Property Insurance | $28,162 | $28,162 | |||||||||||||||||||
Liability Insurance | $1,639 | $1,639 | |||||||||||||||||||
Other General Expenses | $0 | $0 | |||||||||||||||||||
Bad Debt Loss ($) | $23,614 | $23,614 | |||||||||||||||||||
Other General exp (net of bad debt) | -$23,614 | -$23,614 | |||||||||||||||||||
2010 Capital Needs Study Definition for 'Elderly' and 'Family' Projects | |||||||||||||||||||||
Number of 2+ Bedroom Units | 185 | PIC data (before any corrections) | |||||||||||||||||||
Average # Bedrooms | 2.38 | PIC data (before any corrections) | |||||||||||||||||||
Family Definition 1 | Yes | At least 1.5 bedrooms per unit | |||||||||||||||||||
Family Definition 2 | No | Between 1.2 and 1.5 and at least 100 2+ bedroom units | |||||||||||||||||||
Elderly | No | All others | |||||||||||||||||||
Occupancy Type for Preference | Family | Use this designation for purposes of the preference for high-rehab projects |
Data Elements Downloaded from PIC Appear in Rows 2-3 | ||||||||||||||||||||||||||
AMP No | 0-BR | 1-BR | 2-BR | 3-BR | 4-BR | 5-BR | 6-BR | Units | Average Bedroom Size | FMR (bedroom adjusted) | Utility Allowance (brm adj) | Operating Fund per unit | Operating Fund PUM | Capital fund per unit | Capital Fund PUM | Tenant Payments Per unit | Tenant payments PUM | Current Funding to FMR % | Primary PHA Signatory | Position | Phone | Mixed Finance | Housing Authority | DUNS number | Lease up | |
AL086000001 | 0 | 20 | 104 | 65 | 16 | 0 | 0 | 205 | 2.38 | $824 | $117 | $4,767 | $397 | $1,256 | $105 | $781 | $65 | 69% | Lewis McDonald | Executive Director | 2058490123 | lmcdonald@jcha.com | No | Jefferson County Housing Authority | 101705270 | |
0 | 20 | 208 | 195 | 64 | 0 | 0 | 487 | |||||||||||||||||||
0 | 1 | 2 | 3 | 4 | 5 | 6 | ||||||||||||||||||||
Uses Can Enter Corrections in the Grey Highlighted Cells Below in Column C (be sure to make the same changes in PIC itself as well) | ||||||||||||||||||||||||||
PIC Data Element | PIC Value | Corrected Value | Comment | |||||||||||||||||||||||
AMP No | AL086000001 | AL086000001 | Cannot be modified | |||||||||||||||||||||||
0-BR | 0 | 0 | See RAD App Form Section 2 to modify | |||||||||||||||||||||||
1-BR | 20 | 20 | See RAD App Form Section 2 to modify | |||||||||||||||||||||||
2-BR | 104 | 104 | See RAD App Form Section 2 to modify | |||||||||||||||||||||||
3-BR | 65 | 65 | See RAD App Form Section 2 to modify | |||||||||||||||||||||||
4-BR | 16 | 16 | See RAD App Form Section 2 to modify | |||||||||||||||||||||||
5-BR | 0 | 0 | See RAD App Form Section 2 to modify | |||||||||||||||||||||||
6-BR | 0 | 0 | See RAD App Form Section 2 to modify | |||||||||||||||||||||||
Units | 205 | 205 | See RAD App Form Section 2 to modify | |||||||||||||||||||||||
Average Bedroom Size | 2.38 | 2.38 | See RAD App Form Section 2 to modify | |||||||||||||||||||||||
FMR (bedroom adjusted) | $824 | $824 | 0 | Used on Board Approval form only | ||||||||||||||||||||||
Utility Allowance (brm adj) | $117 | $117 | 0 | Used on Board Approval form only | ||||||||||||||||||||||
Operating Fund per unit | $4,767 | $4,767 | 0 | Used on Validation sheet | ||||||||||||||||||||||
Operating Fund PUM | $397 | $397 | 0 | Not currently used | ||||||||||||||||||||||
Capital fund per unit | $1,256 | $1,256 | 0 | Used on Validation sheet | ||||||||||||||||||||||
Capital Fund PUM | $105 | $105 | 0 | Not currently used | ||||||||||||||||||||||
Tenant Payments Per unit | $781 | $781 | 0 | Used on Validation sheet | ||||||||||||||||||||||
Tenant payments PUM | $65 | $65 | 0 | Not currently used | ||||||||||||||||||||||
Current Funding to FMR % | 69% | 69% | 0 | Not currently used | ||||||||||||||||||||||
Primary PHA Signatory | Lewis McDonald | Lewis McDonald | 0 | Used on RAD App Form sheet | ||||||||||||||||||||||
Position | Executive Director | Executive Director | 0 | Used on RAD App Form sheet | ||||||||||||||||||||||
Phone | 2058490123 | 2058490123 | 0 | Used on RAD App Form sheet | ||||||||||||||||||||||
lmcdonald@jcha.com | lmcdonald@jcha.com | 0 | Used on RAD App Form sheet | |||||||||||||||||||||||
Mixed Finance | No | No | 0 | Used on RAD App Form sheet | ||||||||||||||||||||||
Housing Authority | Jefferson County Housing Authority | Jefferson County Housing Authority | 0 | Used on RAD App Form sheet | ||||||||||||||||||||||
DUNS number | 101705270 | 101705270 | 0 | Used on RAD App Form sheet | ||||||||||||||||||||||
Total Corrections | 0 | |||||||||||||||||||||||||
File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
File Modified | 0000-00-00 |
File Created | 0000-00-00 |