Addendum to Underwriting Narrative – Accounts Receivable (AR) FinancingSection 232/223(a)(7), 223(d), 241(a) |
U.S. Department of Housing and Urban Development Office of Residential Care Facilities |
OMB Approval No. 9999-9999 (exp. mm/dd/yyyy) |
Public reporting burden for this collection of information is estimated to average 0.5 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.
AR Lender: |
|
AR Borrower: |
|
Maximum Loan Amount: |
|
Current Balance: |
|
Current Maturity Date: |
|
Key Questions
|
Yes |
|
No |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
If you answer “yes” to any of the above questions, please briefly address below.
<<For each “yes” answer above, provide a narrative discussion regarding the topic.>>
Describe the borrowing base formula (e.g., XX% of AR borrower’s accounts receivable up to 120 days):
Describe term and renewal options:
Describe the rate applied to the used and unused portions of the AR loan:
Describe other fees (i.e., financing fees, late payment fees, etc):
Mechanisms for operator receipts, disbursements, and control of operator funds:
<<Describe the flow of all funds, into and out of accounts – point of origination to final destination. Describe how deposit accounts are controlled (e.g., number of controlled accounts, hard or springing lockbox, daily sweeps, etc.). Attach cash flow chart.>>
<<Provide narrative description of the AR lender’s collateral/security. Explain any unsecured AR financing.>>
<<Provide descriptions of the permitted uses of the AR loan funds in order of priority. For example: (1) debt service incurred in connection with the AR loan; (2) operating costs; and (3) distributions to the operator’s shareholders. See Attachment C of Notice H 08-09, Rider to Intercreditor, Paragraph 3 or any other successor guidance.>>
Maximum AR Loan Calculation
(Double click inside the Excel Table to add information)
Historical AR Loan Costs
<<If there is an existing AR loan that is not yet approved by HUD, provide a financial analysis that explains how the cost of the AR loan has been factored into the NOI calculation. Complete the Historical AR Loan Costs table.>>
Historical AR Loan Costs
(Double click inside the Excel Table to add information)
Proposed AR Loan Costs
<<If the AR borrower is obtaining AR financing for the first time, provide a financial analysis that demonstrates that the AR borrower has sufficient financial capacity to pay all projected operating expenses, AR financing costs and loan payments, and all rent or debt service payments. The analysis must assume the maximum AR loan amount to stress test the AR financing based on the lesser of the operator’s 12-month trailing operating statements or the underwritten NOI. Calculate the impact on the borrower’s debt coverage after payment of the AR loan expenses and payments.>>
Assuming the $ maximum AR loan limit, an annual interest rate of %, and that the entire amount is outstanding for the year, the maximum annual interest expense would be $ . In addition to the interest, the other associated fees are the fees <<list types of fees>>, which total $ per year for the same assumed balance. An analysis of the operator’s 12 month trailing financial statement through <<list month and year>> is shown below:
Trailing 12-Month Operating History (TTM thru Month/Year) |
|
Operating revenue |
$ |
Operating expenses |
|
Net Operating Income (NOI) |
$ |
|
|
Annual P&I + MIP |
$ |
AR fee: Interest |
|
AR fee: Other <<describe>> |
|
Total annual mortgage and AR debt service |
$ |
|
|
DSCR including AR |
|
The underwriting assumed an NOI of $ . The 12-month trailing NOI is $ . The annual debt service including the MIP amount is $ per year. Adding the AR fees equates to a total mortgage and AR debt service expense of $ per year. This equates to prospective debt service coverage.
<<If multiple HUD-insured facilities have access to the AR loan, repeat the analysis above with the consolidated revenues and expenses for all those facilities.>>
<<The lender recommends approval of the AR loan.>>
Previous
versions obsolete Page
File Type | application/msword |
File Title | ALTA/ACSM Land Title Survey |
Author | h56877 |
Last Modified By | Kelley Allen Mason |
File Modified | 2013-02-20 |
File Created | 2012-10-21 |