92264a-ORCF Maximum Insurable Loan Calculation

Comprehensive Listing of Transactional Documents for Mortgagors, Mortgagees and Contractors

92264a_orcf_Final_Clean.xlsx

Transactional Documents for Mortgagees and Contractors

OMB: 2502-0605

Document [xlsx]
Download: xlsx | pdf

Overview

Instructions
Criteria by Prog Type
S & U
Land Calc
Other Fees
Repl Cost
S & U NC, SR, 241a
MILC Pg 1
MILC Pg 2


Sheet 1: Instructions

Public reporting burden for this collection of information is estimated to average 2 hours. This includes the time for collecting, reviewing, and reporting the data. The information is being collected to obtain the supportive documentation which 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.









Project Name:






Project Number:






Program Type:














Instructions





1. Complete the project name, project number, and program type on this page (column D).






It will be carried forward to other tabs.





2. Fields to be completed are shaded in aqua.





3. For 223f, 223a7, 223d, and 232i complete the applicable Sources and Uses tab before






completing the criteria.






For 223f if the Maximum Insurable Loan is less than Criteria H then amend the Sources






and Uses tab to reflect the correct loan amount and other line items affected by the loan amount.






For NC and 241a complete the Land Calculation, Other Fees, Replacement Cost






and Sources and Uses tabs before completing the criteria.






Formulas on the criteria pages use data from the Land Calculation, Replacement Cost and






Sources and Uses tab.





4. 232 Handbook benchmarks should be used for all criteria. Do not use regulatory percentages.





5. The MILC should reflect benchmarks in the 232 Handbook. If the requested mortgage amount






exceeds the lowest of all applicable criteria a waiver request (Form HUD-2-ORCF) must






be included as part of the application and attached to the HUD-92264a-ORCF as an exhibit.





6. Applicable criteria are shown in the Criteria by Program tab. That tab and this instructions






tab are for information purposes only and are not to be attached to the Firm Commitment.





7. Fields with red arrows in the corner have additional notes. Placing your cursor over the






those fields will make them appear.





8. The percentage fields in the S & U tab for 223(f), 223(a)(7), 223(d) and 232(i) only drive the






calculations for Criteria G and H. Enter the actual, fixed dollar amount in the adjacent fields






when the mortgage amount has been determined. Both percentages and dollars must be






provided for all calculations to be completed.





9. The mortgage amount should be entered as the lowest of all applicable criteria. See the






Criteria by Program Type chart to determine which criteria apply.





10. A lender's underwriter signature and date are required for all submissions.





11. 223f, 223a7, 223d, and 232i Firm Commitments should include the applicable Sources and






Uses page and the Maximum Insurable Loan Calculation pages.





12. NC, SR and 241a Firm Commitments should include the Land Calculation, Other Fees,






and Replacement Cost pages, the applicable Sources and Uses page, and the






Maximum Insurable Loan Calculation pages.






Sheet 2: Criteria by Prog Type


Requested Loan Amount Original Principal Balance Amount Based on Replacement Cost Amount Based on Loan to Value Amount Based on Debt Service Coverage Amount Based on Estimated Cost of Rehabilitation Plus Amount Based on Borrower's Total Cost of Acquisition Amount Based on the Cost to Refinance Amount Based on Total Indebtedness Amount Based on 100% of the Operating Loss Amount Based on 100% of the Cost of Fire Safety Equipment Amount Based on Deduction of Grant(s), Loan(s), LIHTCs and Gift(s) for Mortgageable Items

A. B. C. D. E. F. G. H. I. J. K. L.
Section 232 New Construction X
X X X





X
Section 232 Substantial Rehabilitation X
X X X X




X
Section 232/241(a) X
X X X


X

X
Section 232/223(f) X

X X
Used for Acquisition Projects X Used for Refinances X


X
Section 232/223(a)(7) X X




X



Section 223(d) X


X



X

Section 232(i) X








X

Sheet 3: S & U

Sources and Uses



Pursuant to Sections 223(f), 223(a)(7), 223(d) and 232(i)








Project Name: 0


Project Number: 0


Program Type: 0







SOURCES HUD Insured Loan $0.00


Existing Replacement Reserves to Transfer $0.00


This should either be zero or a positive number. Cash/Letter of Credit $0.00


Interest rate premiums may only be applied on behalf of the borrower to prepayment penalties and reserves for replacement. The transaction costs in MILC Criterion H are reduced by the amount of the interest rate premium. Interest Rate Premium $0.00


Other (Describe) $0.00


Other (Describe) $0.00


TOTAL $0.00






USES




HUD ELIGIBLE COSTS



Refer to the 232 Handbook for guidance on eligible debt and purchases. If you still have questions after reviewing the 232 Handbook, email [email protected]. Existing Indebtedness or Purchase Price $0.00


Prepayment Penalty $0.00


This does not include any R4R transfer. Initial Deposit to the Reserve for Replacement $0.00


Existing Replacement Reserves to Transfer $0.00


Estimate of Repair Cost (Critical & Non Critical) $0.00


Appraisal (incl. update) $0.00


Phase I ESA / HUD 4128 $0.00


PCNA $0.00


Financing/Placement Fee $0.00 0.00%

If this is included in the financing/placement fee percentage calculation please detail the dollars here. Lender Legal $0.00


Borrower Legal $0.00


Title & Recording $0.00


If the lender is administering the non-critical repair escrow then the refundable payment is a non-eligible use of funds. HUD Inspection Fee $0.00


First Year MIP $0.00 0.00%

.15% of the requested mortgage amount for 223(a)(7)s HUD Application Fee $0.00 0.00%

Survey $0.00


Additional Other Fees (Describe) $0.00


Lender Inspection Fee/PCNA Closeout Fee $0.00


Other (Describe) $0.00


TOTAL HUD ELIGIBLE COSTS $0.00







NON-ELIGIBLE COSTS



This is to be used for non-mortgageable debt service reserve escrow. Special Escrow - Debt Service Reserve $0.00


20% of incomplete repairs for 223(f), 10% for 223(a)(7). Repair Completion Assurance Escrow $0.00


Other (Describe) $0.00


Other (Describe) $0.00


Other (Describe) $0.00


TOTAL ADDITIONAL COSTS $0.00







TOTAL COSTS $0.00 ok








































Sheet 4: Land Calc

Information Concerning Land or Property
Pursuant to New Construction, Substantial
Rehabilitation and Section 241(a)



Last Arms-Length Transaction
Buyer
Seller
Date Acquired
Purchase Price $0.00
Additional Cost $0.00
Total Cost $0.00


Annual Ground Rent $0.00
Note: If this is an allocation of a purchase of a larger site or a combination of multiple sites
provide detail (including basis of allocation) below. Insert additional page if needed.


Special Assessments
Prepayable, Non-Prepayable or N/A
Principal Balance $0.00
Annual Payment $0.00
Remaining Term


Value of Land and Cost Certification
Fair Market Value of land fully improved $0.00
Deduct unusual land improvements $0.00
Equals warranted price of land fully improved $0.00


For Cost Certification Purposes:
Demolition $0.00
Off-site Cost $0.00
Estimate of "as is" by subtraction from improved value $0.00
Estimate of "as is" by comparison (from appraisal) $0.00
Only enter if land is purchased from LPA or other Governmental authority for specific reuse. "As is" based on acquisition cost (include legal, title, etc.) $0.00
If this differs from the warranted price of land on the replacement cost tab include additional page with explanation. Estimate of value of land "as is" for cost certification purposes $0.00















Sheet 5: Other Fees

Schedule of Other Fees to be paid by Borrower



Pursuant to New Construction, Substantial
Rehabilitation and Section 241(a)







Line Description Amount

A Survey--Land and Final "as built" $0.00

B Building Permits $0.00

C Soils Report $0.00

D Traffic Study $0.00

E Impact Fees $0.00

F Hook-up Fees $0.00

G
$0.00

H
$0.00

I
$0.00

J
$0.00

Total
$0.00











All fees shown here should be reflected on the 92328_ORCF. Schedule of Other Fees included in Construction Contract








Line Description Amount

A Survey $0.00

B Required for cost plus contracts Cost Certification $0.00

C Municipal Inspections $0.00

D Special Engineering Tests/Fees $0.00

E Special Taxes $0.00

F Permits $0.00

G
$0.00

H
$0.00

I
$0.00

J
$0.00

Total
$0.00


Sheet 6: Repl Cost

All construction contract items should match figures on the 92328-ORCF. Estimated Replacement Cost



Pursuant to New Construction, Substantial
Rehabilitation and Section 241(a)









Unusual Land Improvements $0.00


Other Land Improvements $0.00


Total Land Improvements $0.00


Main Building $0.00


Other Structures (identify) $0.00


Other Structures (identify) $0.00


Total Structures $0.00


General Requirements $0.00







This should not exceed 2% of the total contract amount. Contractor General Overhead $0.00


Contractor Profit $0.00


Architect Design Fee $0.00


Architect Supervisory Fee $0.00


Bond Premium $0.00







Borrower Other Fees $0.00


Contractor Other Fees $0.00


Total Other Fees $0.00







Total For All Improvements $0.00


Note: Estimated Construction Time (months) 0


Note: Estimated Interest Time (months) 0


Note: Estimated Interest Rate (percent)








Interest $0.00


Taxes $0.00


Insurance $0.00


Use detailed guidance from email blasts, mortgagee letters, etc. to determine this figure. HUD Mortgage Insurance Premium $0.00


HUD Application Fee $0.00


The formula in cell B33 is for New Construction projects. For Substantial Rehabilitation, Blended Rate and Section 241(a) projects modify the formula to .005*cell B10. HUD Inspection Fee $0.00


Initial Financing Fee $0.00


Use detailed guidance from email blasts, mortgagee letters, etc. to determine this figure. Non-profit Developer's Fee (includes consultant) To be consistent with the Handbook, this line item is to be removed. $0.00


Permanent Placement Fee $0.00


Survey may be in Borrower's Other Fees or included in this line item. If it is included here indicate that in lender narrative. Title and Recording $0.00


Total Carrying Charges and Financing $0.00







Legal $0.00


Details should be provided in the lender narrative. Organizational $0.00


Borrower's Cost Certification Audit Fee $0.00


Total Legal, Organizational, Audit $0.00


Major Movable Equipment $0.00


Marketing $0.00


Rehab only Contingency $0.00


Rehab only--a budget should be provided indicating budgeted number of relocations and detailed cost estimates. Relocation $0.00


Rehab only Initial Deposit to Reserve for Replacement $0.00


Repairs in SR or BR should be included here. Other (Describe) $0.00


Total Estimated Development Cost $0.00


"As is" Value for Rehab projects Warranted Price of Land $0.00


Offsite Costs (Rehab only) $0.00


Total Estimated Replacement Cost $0.00



Sheet 7: S & U NC, SR, 241a

Sources and Uses



Pursuant to New Construction, Substantial
Rehabilitation and Section 241(a)








Project Name: 0


Project Number: 0


Program Type: 0







SOURCES HUD Insured Loan $0.00


This should either be zero or a positive number. Cash/Letter of Credit $0.00


Not applicable for new construction Existing Reserve for Replacement Deposit $0.00


Grants/Other Loans (Describe) $0.00


Other (Describe) $0.00


TOTAL $0.00






USES




HUD ELIGIBLE COSTS



Existing Indebtedness $0.00


Repairs $0.00


Initial Deposit to the Reserve for Replacement $0.00


Land Purchase $0.00


Land Improvements $0.00


Structures $0.00


General Requirements $0.00


Builder’s Overhead $0.00


Builder’s Profit $0.00


Architect Fees (Design) $0.00


Architect Fees (Supervisory) $0.00


Bond Premium $0.00


during construction period: Interest $0.00


during construction period Taxes $0.00


during construction period Insurance $0.00


Appraisal (incl. update) $0.00


Market Study $0.00


Phase I ESA / HUD 4128 $0.00


A&E / Cost Reviews $0.00


Financing/Placement Fee/Lender Legal $0.00


Borrower Legal $0.00


Title and Recording $0.00


Borrower's Cost Certification Audit Fee $0.00


Major Movable Equipment $0.00


Marketing $0.00


Pre-Opening Management Fees $0.00


HUD Inspection Fee $0.00


HUD Initial MIP $0.00


HUD Application Fee $0.00


Other Fees $0.00


Other (Describe) $0.00


Other (Describe) $0.00


Other (Describe) $0.00


Other (Describe) $0.00


TOTAL HUD ELIGIBLE COSTS $0.00







NON-ELIGIBLE COSTS








Initial Operating Deficit Escrow $0.00


Working Capital Escrow $0.00


Special Escrow - Minor Moveable Equipment $0.00


Special Escrow - Demolition $0.00


Special Escrow - Off-site Construction $0.00


Special Escrow - Short-Term Debt Service Reserve $0.00


Non Profit Developer's Fee/Consultant $0.00


Other (Describe) $0.00


Other (Describe) $0.00


TOTAL ADDITIONAL COSTS $0.00







TOTAL COSTS $0.00







Replacement Cost minus HUD Eligible Costs $0.00 ok

Sheet 8: MILC Pg 1

Public reporting burden for this collection of information is estimated to average 1.25 hours. This includes the time for collecting, reviewing, and reporting the data. The information is being collected to obtain the supportive documentation which 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.

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.











Project Name: 0






Project Number: 0






Program Type: 0















A. Requested Loan Amount




$0
232 NC








232 SR
B. Original Principal Amount




$0
232 BR








241(a)
C. Amount Based on Replacement Cost






223(f)
a. Replacement Cost in Fee Simple 241(a): if building an addition, only use replacement cost of the addition. This figure should be recalculated as needed to include costs based on the mortgage amount. $0 x 90%
$0

223(a)(7)
When land is leased, enter the optional purchase price specified in the 92070M. b.(1) Optional Purchase Price from 92070M $0





223(d)
H08023: Only deduct items from non-govt. sources here. Use Criteria L to deduct govt. sources. (2) Grant/Loan funds attributable to R.C. items $0





232(i)
(3) Excess Unusual Land Improvement $0






(4) Total lines (1) to (3) $0 x 90% $0



c. Unpaid Balance of Special Assessment


$0



d. Total line b plus line c



$0


e. Line a minus line d




$0










D. Amount Based on Required Loan to Value







a. Value in Fee Simple 241(a): Use As-Proposed Value. $0 x Use the OHP Loan to Value Limit for the program and project type 241(a): Use 90% 0%
$0


When land is leased, enter the optional purchase price specified in the 92070M. b. Optional Purchase Price from 92070M $0 x Use the OHP Loan to Value Limit for the program and project type 0% $0



c. Unpaid Balance of Special Assessment


$0



d. Less: 90% of As-is Value (for 241(a) only)


$0



e. Total line b plus line c (lines b through d for 241(a))



$0


f. Line a minus line e




$0










E. Amount Based on Required Debt Service Coverage







a. Mortgage Interest Rate


0.00%



b. Mortgage Insurance Premium Rate


0.00%



c. Initial Curtail Rate Loan term (years) 0
#NUM!



d. Sum of Above Rates



#NUM!


Use Lender's Underwritten NOI e. Net Operating Income 223(d): insert NOI less existing debt service $0 ÷ Use 1.11 for 223(d) 1.45
$0


f. Annual Ground Rent + Annual Special Assessment $0 + $0
$0


g. Line e minus line f



$0


h. Line g divided by line d




#NUM!

i. Annual Tax Abatement Savings $0 ÷ Debt service constant for the abatement period 0.00

Fixed Broken Formula Changed the formula in G38 to =IFERROR(B38/D38,0). That way if there is no tax abatement savings the formula won’t return a divided by 0 error, and the formula in G39 will be able to correctly calculate the criterion without an error. $0

j. Line h plus line i




#NUM!










F. Amount Based on Estimated Cost of Rehabilitation Plus







a. Existing Mortgage Indebtedness (Property Owned) or Purchase Price of Property (to be Acquired)








$0 x 90 % $0


b. "As Is" Value of Prop. Before Rehab. $0 x 90 % $0


c. Lesser of a. or b.



$0


d. Total Estimated Development Cost



$0


e. Estimated Cost of Off-Site Construction



$0


f. Sum of lines d & e



$0


g. Grant/Loan funds attributable to Replacement Cost items

95% Non-Profit

$0


h. Line f minus line g



$0


i. Line h plus line c

100% if refinance, 85% if purchase


$0






































Sheet 9: MILC Pg 2

G. Amount Based on Borrower's Total Cost of Acquisition Section 223(f)








a. HUD Eligible Costs
$0






b. Enter the Sum of any Grant/Loan and Reserves for








Replacement and Major Movable Equipment to be








Purchased as an asset of the project








c. Line a minus line b
$0






d. Line c x 90% Non-Profit 85 %

$0












H. Amount Based on the Cost to Refinance








a. HUD Eligible Costs
$0






b. Enter the Sum of any Grant/Loan and Reserves for








Replacement and Major Movable Equipment on Deposit








c. Line a minus line b




$0












I. Amount Based on Total Indebtedness








a. As-Proposed Value
$0






b. Loan-to-Value Percentage
90%






c. Line a times line b
$0






d. Total of All Outstanding Indebtedness Relating to Property
$0






e. Line c minus line d




$0












J. Amount based on 100% of the Operating Loss




Use detailed guidance from email blasts, mortgagee letters, etc. to determine this figure. $0












K. Amount based on 100% of the Cost of Fire Safety Equipment








100% of the Cost of Fire Safety Equipment




$0












If grants or loans are used for non-mortgageable items details should be provided in the lender narrative. L. Amount Based on Deduction of Grant(s), Loan(s), LIHTCs and Gift(s) for mortgageable items








a. 100% Project (Replacement) Cost



241(a): if building an addition, only use replacement cost of the addition $0



b. (1) Grants/Loans/Gifts



$0



(2) Tax Credits



$0



When land is leased, enter the optional purchase price specified in the 92070M. (3) Optional Purchase Price from 92070M



$0



(4) Excess Unusual Land Improvement Cost



$0



(5) Unpaid Balance of Special Assessment



$0



(6) Sum of Lines (1) through (5)



$0



c. Line a. minus line b. (6)




$0












Maximum Insurable Loan (Lowest of Foregoing Criteria)




Round down to the nearest $100. 0












Notes:








Estimated Liquidated Damages--Construction Contract
0






Incentive Percentage--Construction Contract (if applicable)
0






Estimated Soft Costs--Construction Period
#DIV/0!














































Lender's Underwriter Signature Date:

























































Office of Healthcare Programs Signature Date:

























































File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy