Lender Narrative – Substantial Rehabilitation Section 232 – 2 Stage, Final Firm Submission |
U.S. Department of Housing and Urban Development Office of Residential Care Facilities |
OMB Approval No. 2502-0605 (exp. 03/31/2018) |
Public reporting burden for this collection of information is estimated to average 70 hours. This includes the time for collecting, reviewing, and reporting the data. The information is being collected to obtain the supportive documentation that must be submitted to HUD for approval, and is necessary to ensure that viable projects are developed and maintained. The Department will use this information to determine if properties meet HUD requirements with respect to development, operation and/or asset management, as well as ensuring the continued marketability of the properties. 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.
Warning: Any person who knowingly presents a false, fictitious, or fraudulent statement or claim in a matter within the jurisdiction of the U.S. Department of Housing and Urban Development is subject to criminal penalties, civil liability, and administrative sanctions.
Privacy Act Notice: The Department of Housing and Urban Development, Federal Housing Administration, is authorized to collect the information requested in this form by virtue of: The National Housing Act, 12 USC 1701 et seq. and the regulations at 24 CFR 5.212 and 24 CFR 200.6; and the Housing and Community Development Act of 1987, 42 USC 3543(a). The information requested is mandatory to receive the mortgage insurance benefits to be derived from the National Housing Act Section 232 Healthcare Facility Insurance Program. No confidentiality is assured.
INSTRUCTIONS:
The narrative is a document critical to the Lean Underwriting process. Each section of the narrative and all questions need to be completed and answered. If the lender’s underwriter disagrees and modifies any third-party report conclusions, provide sufficient detail to justify the changes must be provided. This narrative is to identify the strengths and weaknesses of the transactions and demonstrate how the weaknesses are mitigated by the underwriting.
Charts: The charts contained in this document have been created with versatility in mind; however they will not be able to accommodate all situations. For this reason, you are allowed to alter the charts as the situation demands. Be sure to state how you have altered the charts along with your justification. Include all the information the form calls for. Charts that include blue text indicate names that should be modified by the lender as the situation dictates.
Applicability: If a section is not applicable, state so in that section and provide a reason. Do not delete a section heading that is not applicable. The narrative will be checked to make certain all sections are provided. If a major section is not applicable, add “ – Not Applicable” to the heading and provide the reason. For instance:
Parent of the Operator – Not Applicable
This section is not applicable because there is no operator.
The rest of the subsections under the inapplicable section can then be deleted. This instruction page may also be deleted.
Format: In addition to submitting the PDF version of the Lender Narrative to HUD, please also submit an electronic Word version.
Instead of pasting large portions of text from third-party reports into the narrative, it is preferred that the lender simply reference the page number and the report. The focus of this document is for lender conclusions, analyses, and summaries.
Italicized text found between these characters <<EXAMPLE>> is instructional in nature, and may be deleted from the lender’s final version. Please use the gray shaded areas (e.g., ) for your response. Double click on a check box and then change the default value to mark selection (e.g., ).
<<Insert Project Photo>>
Executive Summary—Substantial Rehabilitation Final Submission 5
Summary of Amendment to Initial Firm Commitment 8
Sensitivity Analysis – Update 9
Location/Proximity to Hospitals 11
<<If unchanged from initial submission, state so. Otherwise, provide revised discussion.>> 11
Security, Networking and Other Information Technology Systems 12
Construction Progress Schedule 15
Construction Costs (Form HUD-92328-ORCF) 16
Other Fees – General Contractor 17
Bond Premium/Assurance of Completion 17
Proposed Major Movable Equipment as part of rehabilitation 18
Underwritten Reserve for Replacement 20
ALTA/ACSM Land Title Survey 21
Borrower – <<borrower's name here>> 21
Principals of the Borrower - <<principal(s) name(s) here>> 21
Operator – <<operator's name here>> 21
Parent of the Operator – <<parent's name here>> 21
Management Agent – <<management agent's name here>> 22
Professional Liability Insurance Coverage (PLI) 26
Commercial General Liability Insurance 29
Directors’ and Officers’ Liability Insurance 29
Commercial Auto Liability Coverage 29
Criterion C: Amount Based on Replacement Cost 31
Criterion D: Amount Based on Loan-to-Value 31
Criterion E: Amount Based on Debt Service Coverage 31
Criterion F: Cost of Rehabilitation Plus 31
Criterion L: Deduction of Grants, Loans, LIHTCs, and Gifts 31
Sources & Uses – Copied from HUD-92264a-ORCF 32
Circumstances that May Require Additional Information 33
FHA number: |
|
||
Project name: |
|
||
Project location: |
<<street address, city, county, state, and zip>> |
||
Lender’s name: |
|
||
Lenders UW: |
|
UW trainee: |
|
Borrower: |
|
||
Operator: |
|
||
Parent of operator: |
|
||
Management agent: |
|
||
General contractor: |
|
||
License holder: |
Borrower Operator Management agent |
||
Residents will contract with: |
<<Entity with whom residents will contract for services>> |
||
Section 38 of the Regulatory Agreement shall apply to the following individuals and/or entities (list name(s)): |
Type of Facility As Is:
|
|
Licensed |
Operating |
|
Licensed |
Operating |
|
|
Skilled Nursing (SNF): |
|
|
beds |
|
|
units |
|
Assisted Living (AL): |
|
|
beds |
|
|
units |
|
Memory Care (AL): |
|
|
beds |
|
|
units |
|
Board & Care (B&C): |
|
|
beds |
|
|
units |
|
Independent Living (IL): |
|
|
beds |
|
|
units |
|
Total: |
|
|
beds |
|
|
units |
Type of Facility As Rehabilitated:
|
|
Licensed |
Operating |
|
Licensed |
Operating |
|
|
Skilled Nursing (SNF): |
|
|
beds |
|
|
units |
|
Assisted Living (AL): |
|
|
beds |
|
|
units |
|
Memory Care (AL): |
|
|
beds |
|
|
units |
|
Board & Care (B&C): |
|
|
beds |
|
|
units |
|
Independent Living (IL): |
|
|
beds |
|
|
units |
|
Total: |
|
|
beds |
|
|
units |
|
|
|||||||||
|
Mortgage Amount: |
$ |
Loan-to-value: |
% |
Loan to transaction cost: |
% |
|
|
||
|
Term: |
years |
Interest rate: |
% |
|
|
||||
|
Principal
& interest: |
$ |
DSCR |
% |
Market
value |
$ |
|
|
||
|
Underwritten market value: |
$ |
Cap rate: |
% |
Mortgage amount per bed/unit*: |
$ |
|
|
||
|
Mortgage Criteria:
Criterion A: Requested loan amount: |
$ |
Sensitivity Analysis:
A 1.0 debt service coverage is still realized if:
|
|||||||
|
Criterion C: Amount based on replacement cost: |
$ |
||||||||
|
Criterion D: Amount based on loan-to-value: |
$ |
||||||||
|
Criterion E: Amount based on debt service coverage: |
$ |
||||||||
|
Criterion L: Amount based on deduction of grant(s), loan(s), LIHTCs, and gift(s) for mortgageable items: |
$ |
As-Is:
UW Gross income: |
$ |
UW occupancy rate: |
% |
UW Effective gross income: |
$ |
|
|
UW Expenses & repl. res.: |
$ |
UW Expense ratio: |
% |
UW Net operating income: |
$ |
UW Expense per bed/unit*: |
$ |
|
|
|
|
As-Rehabilitated:
UW Gross income: |
$ |
UW occupancy rate: |
% |
UW Effective gross income: |
$ |
|
|
UW Expenses & repl. res.: |
$ |
UW Expense ratio: |
% |
UW Net operating income: |
$ |
UW Expense per bed/unit*: |
$ |
|
|
|
|
Total project cost: |
$ |
Total project cost per bed/unit*: |
$ |
*Use per bed for SNF, or facilities with multiple care types (e.g., SNF/ALF). Use per unit for ALF only. |
|
|
||
Initial Operating Deficit: |
|
||
|
Number of Preleased units: |
||
|
Absorption rate/no. units per month: |
||
|
No. months to cover shortfalls: |
||
|
Breakeven Occupancy %: |
||
Working Capital: |
$ |
||
Cash Investment: |
$ |
||
Debt Service Reserve Escrow: |
$ |
||
|
No. months of principal & interest payments: |
||
Offsite Escrow: |
$ |
||
Minor Movable Equipment Escrow: |
$ |
||
Demolition: |
$ |
||
Other: |
$ |
||
TOTAL Equity Without Land: |
$ |
%
of total |
|
TOTAL Equity With Land: |
$ |
%
of total |
|
*Total project cost is the total uses on the Form HUD-92264a-ORCF. |
|||
|
|||
Land Equity (Calculation of Warranted Price of Land): <<Describe whether land is currently owned or will be acquired, purchase price, date of purchase, part of larger parcel or planned unit development, etc.>> |
|||
Front Money Escrow (Total Cash Requirement minus Escrows): |
|||
Cash requirement will be met by: |
<<pre-paids, letter of credit, sponsor, etc. Example: “Borrower’s cash and letters of credit.”>> |
||
Based on a review of the principals <<identify principal(s)>> their net worth is estimated at $ ; their liquidity meets/exceeds $ . |
Construction contract: |
$ |
Offsites |
$ |
Demolition |
$ |
|||
Total construction costs: As reported on HUD-92328-ORCF, Line 53 plus Offsites and Demolition Costs |
$ |
|
|
|
|
|||
Major Movable Equipment Budget: |
$ |
Construction Period: |
# of months: |
|||||
Architectural contract: |
$ |
|
|
Multiple AIA Agreements |
|
Year |
FTE’s As reported on Form HUD-91125-ORCF |
Operating Revenues |
SWB As reported on Form HUD-91125-ORCF |
|
Operations – Base year |
|
|
$ |
$ |
|
Operations – Post construction |
|
|
$ |
$ |
|
|
Third Party Reports provided:
|
|
Architecture/Cost Review |
Conclusion is: |
|
Accepted as is. |
|
Modified by lender. |
|
|
|
Market Study (if required) |
Conclusion is: |
|
Accepted as is. |
|
Modified by lender. |
|
|
|
Appraisal (if required) |
Conclusion is: |
|
Accepted as is. |
|
Modified by lender. |
|
|
|
Other <<identify>> |
Conclusion is: |
|
Accepted as is. |
|
Modified by lender. |
|
|
<<Provide brief Summary/Overview of project.>>
Program Guidance: Noteworthy modifications to Initial Firm Commitment should include any material changes such as the proposed land, building (design, units, use), underwriting, title, litigation, environmental, shared costs/expenses, licensing, lender underwriter from the initial submission application. Discuss risks and mitigation of any material changes.
Based on the updated processing of the loan application, the following is a summary of amendments to the initial firm commitment:
|
Increase |
|
Same |
|
Decrease |
|
|
|
|
|
|
Mortgage amount: |
$ |
|
$ |
|
$ |
Underwritten value: |
$ |
|
$ |
|
$ |
Loan-to-value: |
$ |
|
$ |
|
$ |
Debt service coverage: |
$ |
|
$ |
|
$ |
Net operating income: |
$ |
|
$ |
|
$ |
Total for all improvements: |
$ |
|
$ |
|
$ |
Total development costs: |
$ |
|
$ |
|
$ |
Land value: |
$ |
|
$ |
|
$ |
Operating deficit: |
$ |
|
$ |
|
$ |
<<Please provide an explanation of all changes below.>>
Mortgage amount increase/decrease:
Underwritten value:
Loan-to-value:
Debt service coverage:
Net operating income:
Total for all improvements:
Total development costs:
Land value:
Initial operating deficit:
Other noteworthy modifications to firm commitment:
Wage Decision: |
|||
Type: |
Residential Building (commercial) |
||
Number: |
|
No. of buildings: |
|
Modification date: |
|
No. of stories: |
|
Modification number: |
|
No. of units: |
|
|
|
No. of self-contained units*: |
|
*Self-contained means that the units contain both a kitchen/kitchenette and a bathroom. This criterion, in addition to the number of stories, affects whether the construction type will be “residential” or “building.” |
Lenders Pre-Construction Conference Coordinator Information:
Name: |
|
Email: |
|
Phone: |
|
Mailing address: |
|
|
|
General Overview
<<Provide narrative of rationale for selection of Wage Decision specified. Be specific about configurations of kitchens and bathrooms (e.g., kitchenette includes a sink, microwave, and refrigerator and bathroom includes a commode, sink, and shower, etc.).>>
<<Provide an updated Sensitivity Analysis. At a minimum, the analysis is to answer the following questions:>>
If everything else under consideration remains the same (ceteris paribus), a 1.0 debt service coverage is still realized if:
Average rental drops $ per month.
Occupancy rate decreases %.
Operating expenses increase % per year.
Annual net operating income (NOI) decreases $ or %.
Medicaid Rate decreases $ or %.
Medicaid Census drops by %.
<<Provide brief narrative summary of loan committee, including: date held; information provided; any pertinent requirements/conditions of the loan committee to gain the committee’s recommendation.>>
<<Indicate if any changes have occurred that would affect the eligibility of the project.>>
<<Identify and discuss any waivers received or requested as part of the Final Submission.>>
Key Questions
|
Yes |
|
No |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<<For each “yes” answer above, provide a narrative discussion regarding the topic. As applicable, describe the risk and how it will be mitigated. For example: The borrower and general contractor are related parties – John Doe has ownership in both entities. A Cost Plus Construction will be utilized.>>
Key Questions – Architectural Reviewer
|
Yes |
|
No |
|
|
|
|
|
|
|
|
|
|
|
|
Key Questions – Cost Analyst
|
Yes |
|
No |
|
|
|
|
|
|
|
|
<<If unchanged from initial submission, state so. Otherwise, provide revised discussion.>>
<<If unchanged from initial submission, state so. Otherwise, provide revised discussion.>>
<<If unchanged from initial submission, state so. Otherwise, provide revised discussion.>>
<<If unchanged from initial submission, state so. Otherwise, provide revised discussion.>>
|
Legal Conforming |
|
Legal Non-Conforming |
|
Other |
<<Provide narrative description: identify local jurisdiction; zoning designation; results of Zoning Letter provided in application submission; and discuss any variances, conditional uses, non-conformance or other pertinent issues affecting zoning.>>
<<If unchanged from initial submission, state so. Otherwise, provide revised discussion.>>
<< Identify whether emergency call system proposed is included in construction contract, major movable equipment and/or borrower other fees.>>
<< Identify whether these systems proposed are included in construction contract, major movable equipment and/or borrower other fees.>>
<<If unchanged from initial submission, state so. Otherwise, provide revised discussion.>>
<<If unchanged from initial submission, state so. Otherwise, provide revised discussion.>>
<<If unchanged from initial submission, state so. Otherwise, provide revised discussion.>>
<<Complete table or provide equivalent detail>>
Living Unit Description:
<<Brief narrative description of the units including: bathrooms, appliances, flooring, included furnishings, hook-ups, patios, etc. >>
<<If unchanged from initial submission, state so. Otherwise, provide revised discussion.>>
Date of report: |
|
Review firm: |
|
Reviewer: |
|
Key Questions
|
Yes |
|
No |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<<If you answer “yes” to any of the above questions, please address below. For example, Item 1 – Fire sprinkler system engineering will be completed by XXX, Item 3 – The completed plans and specifications will be submitted prior to closing. The architectural reviewer’s inspector has identified minor revisions to the plans and specifications that will be completed and submitted to HUD prior to closing. A list of the minor revisions includes XXX. The contractor has provided confirmation acknowledging the required revisions and confirms that they do not result in changes to the costs reflected on the HUD 92328-ORCF submitted with this application package. We (the lender) recommend a Special Condition to the Firm Commitment requiring that completed acceptable plans and specifications will be submitted prior to closing.
Item 4 – There is an identity of interest between the design architect and the borrower. The design architect is a principal of the borrower entity. Therefore, to meet HUD requirements, a separate AIA B108 is submitted with this package for an unrelated architect to provide the supervision services. Provide narrative describing the supervising architect’s name, experience, etc. >>
<<Provide narrative describing the architectural reviewer’s report and conclusions and if the lender’s underwriter concurs with the conclusions. Identify any modifications to the report conclusions and provide justification. Confirm if the review complies with the LEAN statement of work. Identify deliverables included in the application package. Include a narrative concerning key elements of the reviews, the appropriate HUD forms, and their correspondence with the design architect.>>
<<Provide narrative discussion of the construction period as projected by the general contractor and project architect. Indicate if architectural reviewer agrees. Typically, an updated Construction Progress Schedule that accurately reflects the month and date of construction start and completion will be needed prior to closing.>>
<<Indicate if the review architect has appropriately addressed all architectural aspects of the development and the firm commitment application.>>
Date of report: |
|
Review firm: |
|
Cost analyst: |
|
Key Questions
|
Yes |
|
No |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<<For each “yes” answer above, provide a narrative discussion regarding the topic and provide justification.>>
<<Confirm the cost reviewer performed the cost review pursuant to Section 232 standards. The deliverables in the application package include a narrative concerning the cost analysis, the appropriate HUD forms, and cost data. For example, “The cost analyst performed a comparison analysis and compared them to the contractor’s final schedules of values (form HUD-92328-ORCF). The cost analyst ultimately concludes to the contractor’s schedule of values. The underwriter concurs.”>>
<<Discuss the cost analyst’s review of the final forms HUD-92328-ORCF supplied by the contractor and owner after completing an independent cost analysis. Confirm the analyst found no front-loading in the final costs reflected in the HUD-92328-ORCF submitted. Indicate the analyst completed the HUD 9236 in accordance with HUD guidelines and those forms are included in the appropriate section of the application package.
Provide a breakdown of the costs from the form HUD-92328-ORCF, Contractor’s and/or Borrower’s Cost Breakdown, included in the application package. The form totals $XXX and is summarized as follows (complete the following table or provide equivalent detail):>>
Description |
Cost |
Structures |
|
Accessory structures |
|
Land improvements |
|
General requirements |
|
Builder’s overhead |
|
Builder’s profit |
|
Other fees |
|
Bond premium |
|
Total construction contract |
|
Construction Contract Type: |
|
Cost Plus |
|
Lump Sum |
<<The contractor’s estimate of general requirements totals $XXX. The cost analyst has determined that the proposed cost of the general requirements and the sub-items included in it are reasonable. The underwriter concurs.>>
The form HUD-92328-ORCF includes other fees to be paid the general contractor totaling $ . The other fees to be paid by the general contractor include the following:
Schedule of Other Fees included in Construction Contract
(Double click inside the Excel Table to add information)
<<The cost analyst has reviewed the schedule of other fees and determined the items and the total cost to be reasonable. The underwriter concurs.>>
<<Provide narrative discussion of either construction bond (bonding company, contractor’s bond capacity, etc.) or the Assurance of Completion escrow (15% or 25% of contract, cash or letter of credit, etc. Also, address whether the surety is listed on the Treasury Circular and is authorized to issue bonds in the state for the required amount.>>
<<Describe unusual site improvements and applicable costs, if any.>>
Program Guidance: In situations where there are multiple architects, submit each B108 as a separate exhibit in the firm application that corresponds to the below table (a, b, c, etc.).
Architect Name |
Function (Design, Supervision, Other) |
Amount of Fee |
Percent of Total Architect’s Fees |
Exhibit Number (a, b, c, etc.) |
|
|
|
|
|
<<Confirm there is not an identity of interest between the borrower and the architect or if there is, discuss the separate supervising architect and his/her B108. Confirm if the cost analyst and underwriter find the architectural fees to be reasonable in total and for the cost of design/supervision.>>
Schedule of Other Fees to be paid by Borrower
(Double click inside the Excel Table to add information)
<<The cost analyst has reviewed the schedule of other fees to be paid by the borrower and determined the items and the total cost to be reasonable. The underwriter concurs.>>
<<Describe any off-site work to be accomplished and who will be performing the work. If the general contractor is responsible, describe the cost attributed to it and the cost reviewer’s conclusions about the work and the cost. If the city will be performing the work, describe any cost or hookup fee related.
Describe any demolition that may apply; discuss costs and any other requirements or issues.>>
The borrower has provided a major movable list and budget totaling: |
$ |
Key Questions
|
Yes |
|
No |
|
|
|
|
|
|
|
|
|
|
|
|
<<For each “no” answer above, provide a narrative explanation and justification regarding the topic.>>
The borrower has provided a major movable list and budget totaling: |
$ |
Key Questions
|
Yes |
|
No |
|
|
|
|
|
|
|
|
|
|
|
|
<<For each “no” answer above, provide a narrative explanation and justification regarding the topic.>>
Program Guidance: The contingency reserve amount is based on available data for the type and condition of structure. Calculate as percentage of the sum of structures, land improvements, and general requirements. Percentage ranges from 1% to 10%, depending on the condition of the project, extent of rehabilitation, and experience and financial capacity of the borrower and contractor.
The contingency reserve can only be used to cover unanticipated costs, such as discovering more extensive dry rot than was expected. The contingency reserve is not available for items such as an increase in cost of carpet. |
<<The architectural and cost reviewer concluded that a contingency reserve of % is sufficient based on the site visit, the type of construction of the existing buildings, and the developer’s knowledge of the existing buildings. The lender agrees (explain modification).>>
<<Provide lender’s conclusions and wrap-up of the cost review. Reiterate if any of the cost analyst’s conclusions were modified and justified in the lender’s underwriting.>>
In the analysis below, the underwriter spreads the anticipated replacements by year based on the needs assessor’s replacement reserve analysis and assumes an interest of % and an inflation rate of %.
Reserve for Replacement Fund Schedule
(Double click inside the Excel Table to add information)
<<If unchanged from initial submission, state so. If a revised market study is provided, insert the Market Analysis section required for the Initial Submission narrative here. >>
<<If a revised appraisal is provided, substitute the Appraisal section required for the Initial Submission narrative here.>>
<<If revised title/survey documentation is provided, substitute the ALTA/ACSM Land Title Survey section for the Initial Submission narrative here.>>
<<Discuss any modifications/updates to the previous underwriting.>>
<<Discuss any modifications/updates to the previous underwriting.>>
<<Discuss any modifications/updates to the previous underwriting.>>
<<Discuss any modifications/updates to the previous underwriting.>>
<<Discuss any modifications/updates to the previous underwriting.>>
<<Discuss any modifications/updates to the previous underwriting.>>
Name: |
|
State of organization: |
|
License number/state: |
|
Surety: |
|
Key Questions
|
Yes |
|
No |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<<If you answer “yes” to any of the above questions, identify the risk factor and how it is mitigated below.>>
<<Provide narrative description of general contractor’s experience and qualifications. Discussion should highlight the contractor’s experience constructing similar type and size projects. It should discuss the architectural and cost reviewer’s analysis of the contractor’s experience, bonding capacity, financial capacity, etc.>>
Report date: |
<<within 60 days of submission>> |
Reporting firm: |
|
Score: |
|
<<Provide an explanation of the credit score in terms of risk level (i.e., low, medium, or high). Also, if the score is evaluated numerically, explain what value the credit agency places on the score. >>
Key Questions
|
Yes |
|
No |
|
|
|
|
|
|
|
|
<<If you answer “yes” to any of the above questions, identify the risk factor and how it is mitigated below.>>
Key Questions
|
Yes |
|
No |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<<As applicable, a “yes” answer requires a narrative discussion on the topic describing the risk and how it will be mitigated.>>
Credit Reports for Other Business Concerns:
<<Provide narrative discussion on other business concerns. For example, “XXX identified XX other business concerns. The underwriter reviewed Dunn and Bradstreet credit reports for XX other business concerns identified by XXXX. {Discuss each report}. No reports indicated derogatory information that would prohibit XXXXX from participation in this loan transaction.>>
Name of Entity |
Report Type (Commercial, etc.) |
Report Date |
Comments |
|
|
|
|
|
|
|
|
The application includes the following General Contractor financial statements:
Year to date: |
<<dates for start and end of period>> |
Fiscal year ending: |
<<date – end of period>> |
Fiscal year ending: |
<<date – end of period>> |
Fiscal year ending: |
<<date – end of period>> |
Key Questions
|
Yes |
|
No |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<<If you answer “yes” to any of the above questions, identify the risk factor and how it is mitigated below. For example: Item 7 – Contractor has less than 5% working capital. Contractor may hypothecate fixed assets. The contractor has a sale pending on another building that they have constructed. Lender will provide evidence prior to closing that funds are available to meet the 5% working capital.>>
General Review
<<Provide narrative and analysis of financial statements as appropriate. In addition to the Key Questions above, net working capital should be discussed along with the general financial stability and strength of the entity.>>
<<Provide narrative and analysis of contractor’s working capital. Analysis should discuss appropriate adjustments to current assets and liabilities; how you account for work-in-progress; lines-of-credit; verifications of deposit; etc.
Example: XXXX current balance sheet is summarized below.
|
|
|
Financial |
|
Working |
|
|
|
Statement |
|
Capital |
|
|
|
As of XXXXXXXX |
|
Analysis |
Current Assets |
|
|
|
|
|
|
Cash Accounts |
|
$ 1,200,000 |
|
$ 1,200,000 |
|
Retainage Receivable |
|
3,600,000 |
|
3,600,000 |
|
Accounts Receivable |
|
4,900,000 |
|
4,700,000 |
|
Accounts Receivable - Employees |
|
110,000 |
|
- |
|
Accounts Receivable - RELATED |
|
5,000 |
|
- |
|
Accounts Receivable - RELATED |
|
25,000 |
|
- |
|
Cost & Profit in Excess of Bill |
|
650,000 |
|
650,000 |
|
Prepaid Insurance |
|
150,000 |
|
- |
|
Total Current Assets |
|
$ 10,640,000 |
|
$ 10,150,000 |
|
|
|
|
|
|
Current Liabilities |
|
|
|
|
|
|
Retainage Payable |
|
$ 2,680,000 |
|
$ 2,680,000 |
|
Accounts Payable |
|
4,720,000 |
|
4,720,000 |
|
Profit Sharing Payable |
|
- |
|
- |
|
Current Portion of Notes Payable |
|
66,000 |
|
66,000 |
|
Accrued Payables |
|
445,000 |
|
445,000 |
|
Total Current Liabilities |
|
$ 7,911,000 |
|
$ 7,911,000 |
The underwriter has made the following modification for the working capital analysis:
Example:
Only used accounts receivable less than 90 days old
Did not use accounts receivable from related parties.
Did not include prepaid expenses.
The underwriter’s analysis of Work in Progress is as follows:
Job |
Contract Amount |
% Complete |
Contract Balance |
|
Used for Work In Progress |
Project A |
$ 309,875 |
87.0% |
$ 40,284 |
|
$ 40,284 |
Project B |
25,790,007 |
92.6% |
1,908,461 |
|
- |
Project C |
11,050,619 |
99.6% |
44,202 |
|
- |
Project D |
1,673,600 |
66.5% |
560,656 |
|
560,656 |
Project E |
5,935,000 |
77.0% |
1,365,050 |
|
1,365,050 |
: |
8,807,800 |
61.0% |
3,435,042 |
|
3,435,042 |
: |
196,200 |
42.2% |
113,404 |
|
113,404 |
: |
244,429 |
39.2% |
148,613 |
|
148,613 |
: |
833,806 |
98.0% |
16,676 |
|
- |
: |
100,164 |
16.8% |
83,336 |
|
83,336 |
: |
2,063,500 |
4.6% |
1,968,579 |
|
1,968,579 |
: |
74,434 |
36.5% |
47,266 |
|
47,266 |
: |
922,400 |
25.7% |
685,343 |
|
685,343 |
|
$ 58,001,834 |
|
$ 10,416,912 |
|
$ 8,447,572 |
|
5% of Work in Progress |
= |
422,379 |
The underwriter calculated the working capital necessary for the work in progress as 5% of the contract balances for all work that was less than 90% complete. The working capital for the planned sister facility in XXXXX is 5% of the contract amount of $6,356,426. The working capital for the subject is 5% of the contract amount of $6,502,743.
Based on the above adjustments and analysis, the underwriter concludes to the following working capital analysis:
Current Assets |
|
10,150,000 |
Current Liabilities |
|
(7,911,000) |
Working Capital |
|
$ 2,239,000 |
Working Capital for Other Work in Progress |
(422,379) |
|
Working Capital for planned SISTER Facility |
(317,821) |
|
Working Capital for Subject |
|
(325,137) |
Excess Working Capital |
|
$ 1,173,663 |
The contractor clearly demonstrates sufficient working capital for the current work in progress and the planned sister facility and the subject facility. In addition to the above working capital, the contractor also has a $XXXXM revolving line of credit that currently has no balance. The line of credit is available to supplement the above working capital, if necessary, during construction. >>
<<Provide narrative discussion of underwriter’s conclusion and recommendation. For example, “The general contractor has demonstrated an acceptable financial and credit history. The general contractor has the experience to continue to complete the construction. The underwriter recommends this general contractor for approval as an acceptable participant in this transaction.” >>
Program Guidance: Handbook 4232.1, Section II Production, Appendix 14.1
Name(s) of Insured: |
|
||
Insurance company: |
|
||
Rating: |
|
Rater: |
|
Insurance company is licensed in the United States: |
Yes No |
||
Statute of limitations: |
|
||
Current coverage: |
Per occurrence: |
|
|
|
Aggregate: |
|
|
|
Deductible: |
|
|
Policy Basis: |
Per occurrence Claims made |
||
Current Expiration: |
|
||
Retroactive Date: |
|
||
Policy Premium: |
|
Summary of Six-Year Loss History for Operator or its Parent of Operator |
|||||
|
Year |
Total claims paid under this policy (dollars) |
Total claims paid under this policy (no. of claims) |
Total bed count covered under the policy |
Dollars paid in claims per bed |
1 |
|
|
|
|
|
2 |
|
|
|
|
|
3 |
|
|
|
|
|
4 |
|
|
|
|
|
5 |
|
|
|
|
|
6 |
|
|
|
|
|
Total/average |
|
|
|
|
Key Questions
|
Yes |
|
No |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<<For each “yes” answer above, provide a narrative discussion on the topic describing the risk and how it will be mitigated.
Example: 1.Multiple properties: The underwriter notes that the professional liability policy is a ‘blanket’ policy covering XXX facilities, including the subject…{address potential impact of other facilities on the subject’s coverage}
Example: 2.Less than 6-year loss history: The claims history reports were examined for the period XX through XX. The underwriter determined that there were no professional liability XX claims during that period… {Address claims and sufficiency of coverage, etc. based on history}.
Example: Claims made coverage: The project’s previous professional liability insurance coverage was a “claims made” form policy with XXXX, which expired XXXX, when the current policy was put in place. In XXXX the borrower purchased a “nose coverage” policy which is the coverage needed when going from a “claims made” form of insurance to a “per occurrence” form of insurance. The premium for this “nose” coverage liability was a one-time charge and was paid in XXX. Because of that additional insurance coverage, the insurance expense for XXXX was substantially higher than the current expense. The current “per occurrence basis” insurance policy covers the entire statute of limitations. The project’s professional liability insurance is in compliance with HUD’s requirements. >>
<<Identify all potential or expected professional liability insurance (PLI) claims in excess of $35,000 that have been or may be filed for all periods within the statute of limitations for the state where the claim occurred. Identify any reserves held for potential claims. Discuss the risk associate with each potential PLI claim. Discuss how that risk is mitigated. Describe the circumstances, identify the potential award amount, provide evidence and analysis showing that the suits are covered by PLI insurance, and if the insurance is not sufficient, does the insured demonstrate adequate funds to cover the potential excess? Describe any other information that mitigates the risk.
As applicable, discuss other types of lawsuits (non-PLI) and describe the potential risk related to the party’s participation in the proposed project. Discuss how that risk is mitigated. If the suit is closed, does it contribute to a pattern? Does it materially affect the party’s ability to participate in the project? If not closed, describe the circumstances, identify the potential award amount, provide evidence and analysis showing that the suits are covered by insurance (general liability), and if the insurance is not sufficient, do they demonstrate adequate funds to cover the potential excess? Describe any other information that mitigates the risk.>>
<<Provide narrative discussion of policy coverage for bodily injury, property damage and personal injury. For example: General liability insurance will be provided by XX. The underwriter has confirmed estimates of the cost and coverage for underwriting. The insurance coverage will comply with HUD requirements prior to permission to occupy.>>
<<Provide narrative discussion of review. For example, “Hazard and Liability insurance has been and/or will be provided by XX. The underwriter has confirmed estimates of the cost and coverage for underwriting and that it complies with HUD requirements.”>>
<< If contractor is paying, show in contractor’s other fees. If borrower is paying, show in borrower’s other fees.>>
<<When applicable, provide narrative discussion of policy coverages.>>
<<Provide narrative discussion of policy coverages.>>
<<Provide narrative discussion of business income coverage insurance, including amount of coverage and deductible.
Provide narrative discussion of earthquake insurance coverage, when applicable, including amount of coverage and deductible.
Provide narrative discussion of fidelity bond / crime insurance coverage. For example: “A fidelity (crime) insurance with the limit of $XX and $XX deductible will be put into place prior to Permission to Occupy. The HUD requirement for at least two months potential gross income receipts would total $XX.
Provide narrative discussion of sinkhole / mine subsidence insurance, when applicable, including amount of coverage and deductible.
Provide narrative discussion of windstorm coverage insurance, when applicable, including amount of coverage and deductible.
Provide narrative discussion of windstorm coverage insurance, when applicable, including amount of coverage and deductible.
Provide narrative discussion of flood insurance, when applicable, including amount of coverage and deductible.>>
<<Provide narrative recommendation regarding acceptability of professional and general liability insurance. For example: “The borrower’s professional and general liability insurance was analyzed in accordance with Handbook 4232.1, Section II Production, Chapter 14 and Appendix 14.1.). The property has XX current potential (threatened) insurance claims at this time as reflected on the certification provided by the borrower. It is {lender’s} opinion that the information provided above and in the application sufficiently demonstrates that the existing professional liability coverage meets HUD’s requirements and that the risk from professional liability issues is sufficiently addressed. No modifications to the current coverage are recommended.”>>
The mortgage criteria shown on the form HUD-92264a-ORCF are summarized as follows:
|
Initial |
Final |
Request amount: |
$ |
$ |
Replacement Cost: |
$ |
$ |
Loan-to-value: |
$ |
$ |
Debt service coverage: |
$ |
$ |
Cost of rehabilitation plus: |
$ |
$ |
Amount based on deduction of loan(s), grant(s), LIHTCs, and gift(s) for mortgageable items: |
$ |
$ |
The proposed mortgage is $ and is constrained by .
The amount based on replacement cost limit is $ . This is based on
a replacement cost of $ .
The $ value of improvement limit was calculated in accordance with HUD guidelines. This is based on a value of $ .
The $ debt service limit was calculated using the underwritten NOI of $ .
The estimated cost of rehabilitation limit is $ . This amount is based on % of the total estimated rehabilitation cost of $ plus the offsite costs of $ plus the lesser of 90.0% of as-is value of $ or the allowable existing debt $ .
The limit was calculated in accordance with HUD guidelines as follows:
|
$ |
|
|
|
|
(2) Tax credits |
|
(3) Value of leased fee |
|
(4) Excess unusual land improvement cost |
|
(5) Unpaid balance of special assessment |
|
(6) Sum of lines (1) through (5) |
$ |
|
|
|
$ |
The secondary sources are discussed in detail below in the Sources & Uses section of the narrative.
<<Discuss any modifications/updates to the previous underwriting.>>
Program Guidance: In the case of tax credit transactions, the individual sources must be spelled out, as well as any non-mortgageable costs. Details regarding the requirements of those sources and uses should be discussed in the tax credit section, or under Secondary Sources, as applicable.
<<Provide a statement of Sources and Uses of actual estimated cost at closing. Include all eligible and ineligible costs.>>
Source |
Entity Receiving Funds |
Public or Private |
% of Equity Coverage |
% FMV |
Non-mortgageable costs? |
<<List and discuss all existing long-term debt that will survive closing.>>
<<Discuss any uses not previously discussed in this narrative.>>
In addition to the information required in this narrative, depending upon the facility for which mortgage insurance is to be provided, the mortgagor, operator, management agent and such other parties involved in the operation of the facility, current economic conditions, or other factors or conditions as identified by HUD, HUD may require additional information from the lender to accurately determine the strengths and weaknesses of the transaction. If additional information is required, the questions will be included in an appendix that accompanies the narrative.
<<List any recommended special conditions. If none, state “None.”>>
<<Provide narrative conclusion and recommendation.>>
Lender hereby certifies that the statements and representations of fact contained in this instrument and all documents submitted and executed by lender in connection with this transaction are, to the best of lender’s knowledge, true, accurate, and complete. This instrument has been made, presented, and delivered for the purpose of influencing an official action of HUD in insuring the loan and may be relied upon by HUD as a true statement of the facts contained therein.
Lender: |
|
HUD Mortgagee/Lender No.: |
|
This report was prepared by:
|
Date |
|
This report was reviewed by:
|
Date |
<<Name>> <<Title>> <<Phone>> <<Email>> |
|
|
<<Name>> <<Title>> <<Phone>> <<Email>> |
|
This report was reviewed and the site inspected by:
|
Date |
<<Name>> <<Title>> <<Phone>> <<Email>> |
|
Previous
versions obsolete Page
File Type | application/vnd.openxmlformats-officedocument.wordprocessingml.document |
Author | H22192 |
File Modified | 0000-00-00 |
File Created | 2021-01-13 |