Document

Transactional Documents for Mortgagees and Contractors

ICR 201910-2502-002 · OMB 2502-0605 · Object 95374301.

Document Viewer [xlsx]

Status: Original and derived artifacts are available for this document.

Download: xlsx | pdf | html

Primary: spreadsheetSource: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Loading document viewer…

Document Metadata

Record metadata
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Transactional Documents for Mortgagees and Contractors
Milton, Vicki M
Calc
2017-11-13
2026-09-03
complete

Extracted Text

Maximum Insurable Loan
Calculation (MILC)

U.S. Department of Housing
and Urban Development
Office of Residential
Care Facilities

OMB Approval No. 2502-0605
(exp. 06/30/2017)

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.

Previous versions obsolete

form HUD-92264a-ORCF (06/2014)

Maximum Insurable Loan
Calculation (MILC)

U.S. Department of Housing
and Urban Development
Office of Residential
Care Facilities

OMB Approval No. 2502-0605
(exp. 06/30/2017)

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.

Previous versions obsolete

form HUD-92264a-ORCF (06/2014)

U.S. Department of Housing
and Urban Development
Office of Residential
Care Facilities

Maximum Insurable
Loan Calculation, by Program
Section 232

OMB Approval No.2502-0605
(exp. 06/30/2017)

Used for Acquisition
Used for
Projects
Refinances

Section 232 New
Construction
Section 232 Substantial
Rehabilitation
Section 232/241(a)
Section 232/223(f)
Section 232/223(a)(7)
Section 223(d)
Section 232(i)

Previous versions obsolete

Requested
Loan Amount

Original
Principal
Balance

A.

B.

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

D.

E.

X

X

X

X

X
X
X
X
X
X

X
X

X
X
X

X
X
X

X
X

F.

G.

H.

I.

J.

K.

L.
X

X

X
X
X

X
X

X
X
X
X

form HUD-92264a-ORCF (06/2014)

U.S. Department of Housing
and Urban Development
Office of Residential
Care Facilities

Maximum Insurable
Loan Calculation
Section 232

OMB Approval No. 2502-0605
(exp. 6/30/2017)

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

Project Name:
Project Number:
Program Type:
SOURCES

0
0
0
HUD Insured Loan
Existing Replacement Reserves to Transfer
Cash/Letter of Credit
Interest Rate Premium
Other (Describe)
Other (Describe)
TOTAL

USES
HUD ELIGIBLE COSTS
Existing Indebtedness or Purchase Price
Prepayment Penalty
Initial Deposit to the Reserve for Replacement
Existing Replacement Reserves to Transfer
Estimate of Repair Cost (Critical & Non Critical)
Appraisal (incl. update)
Phase I ESA / HUD 4128
PCNA
Financing/Placement Fee
Lender Legal
Borrower Legal
Title & Recording
HUD Inspection Fee
First Year MIP
HUD Application Fee
Survey
Additional Other Fees (Describe)
Lender Inspection Fee/PCNA Closeout Fee
Other (Describe)
TOTAL HUD ELIGIBLE COSTS
NON-ELIGIBLE COSTS
Special Escrow - Debt Service Reserve
Repair Completion Assurance Escrow
Other (Describe)
Other (Describe)
Other (Describe)
TOTAL ADDITIONAL COSTS
TOTAL COSTS

Previous versions obsolete

$0.00
$0.00
$0.00
Interest
rate either
This should
$0.00 only
premiums
be zero or may
a
$0.00
be
applied
on
positive
number.
behalf of$0.00
the
borrower to
$0.00
prepayment
penalties and
reserves for
replacement. The
Refer
to thecosts
232 in
transaction
$0.00
Handbook
for guidance
MILC Criterion
H
on
debt
and
areeligible
reduced
by the
$0.00
purchases.
If you still
amount of the
$0.00
This
does
not after
have
questions
interest
rate
include
any
R4R
$0.00
reviewing
the
232
premium.
transfer.
Handbook,
email
$0.00
[email protected].

$0.00
$0.00
$0.00
$0.00
0.00%
$0.00
If this is included in
$0.00
the
financing/placement
$0.00
fee percentage
$0.00
calculation please
detail the$0.00
dollars 0.00%
If
the lender
is
here.
$0.00
0.00%
administering the
$0.00
non-critical repair
.15%
of then
the
escrow
the
$0.00
requested
mortgage
refundable
payment
$0.00
amount
for 223(a)
is a non-eligible
use
(7)s
of funds.$0.00
$0.00

$0.00
$0.00
This is to$0.00
be used for
non-mortgageable
$0.00
20% of incomplete
debt
service
reserve
$0.00
repairs
for
223(f),
escrow.
10% for $0.00
223(a)(7).
$0.00 ok

form HUD-92264a-ORCF (06/2014)

Maximum Insurable
Loan Calculation
Section 232

U.S. Department of Housing
and Urban Development
Office of Residential
Care Facilities

OMB Approval No. 2502-0605
(exp. 06/30/2017)

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
Additional Cost
Total Cost

$0.00
$0.00
$0.00

Annual Ground Rent
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
Annual Payment
Remaining Term

$0.00

$0.00
$0.00

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

$0.00
$0.00
$0.00

For Cost Certification Purposes:
Demolition
Off-site Cost
Estimate of "as is" by subtraction from improved value
Estimate of "as is" by comparison (from appraisal)
"As is" based on acquisition cost (include legal, title, etc.)
Estimate of value of land "as is" for cost certification purposes

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Previous versions obsolete

Only enter if land
is purchased from
LPA or other
If
this differs from the
Governmental
warranted
price of
authority for
land
on the
specific
reuse.
replacement cost tab
include additional
page with
explanation.

form HUD-92264a-ORCF (06/2014)

Maximum Insurable
Loan Calculation
Section 232

Previous versions obsolete

U.S. Department of Housing
and Urban Development
Office of Residential
Care Facilities

Only enter if land
is purchased from
LPA or other
If
this differs from the
Governmental
warranted
price of
authority for
OMB Approval No. 2502-0605
land
on the
specific
reuse.
(exp. 06/30/2017)
replacement cost tab
include additional
page with
explanation.

form HUD-92264a-ORCF (06/2014)

Maximum Insurable
Loan Calculation
Section 232

U.S. Department of Housing
and Urban Development
Office of Residential
Care Facilities

OMB Approval No. 2502-0605
(exp. 06/30/2017)

Schedule of Other Fees to be paid by Borrower
Pursuant to New Construction, SubstantialRehabilitation and
Section 241(a)

Line Description
A Survey--Land and Final "as built"
B Building Permits
C Soils Report
D Traffic Study
E Impact Fees
F Hook-up Fees
G
H
I
J

Total

Amount
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Schedule of Other Fees included in Construction Contract
Line
A
B
C
D
E
F
G
H
I
J

All fees shown here
should be reflected
Description
on the 92328_ORCF.

Survey
Cost Certification
Municipal Inspections
Special Engineering Tests/Fees
Special Taxes
Permits

Total

Previous versions obsolete

Amount
$0.00
Required for cost
$0.00
plus contracts
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

form HUD-92264a-ORCF (06/2014)

Maximum Insurable
Loan Calculation, by Program
Section 232

U.S. Department of Housing
and Urban Development
Office of Residential
Care Facilities

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

OMB Approval No. 2502-0605
(exp. 06/30/2017)

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

Unusual Land Improvements
Other Land Improvements
Total Land Improvements
Main Building
Other Structures (identify)
Other Structures (identify)
Total Structures
General Requirements

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Contractor General Overhead
Contractor Profit
Architect Design Fee
Architect Supervisory Fee
Bond Premium

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

$0.00

$0.00

Borrower Other Fees
Contractor Other Fees
Total Other Fees

$0.00
$0.00
$0.00

Total For All Improvements
Note: Estimated Construction Time (months)
Note: Estimated Interest Time (months)
Note: Estimated Interest Rate (percent)

$0.00
0
0

Interest
Taxes
Insurance
HUD Mortgage Insurance Premium
HUD Application Fee
HUD Inspection Fee
Initial Financing Fee
Non-profit Developer's Fee (includes consultant)
Permanent Placement Fee
Title and Recording
Total Carrying Charges and Financing

Previous versions obsolete

$0.00
$0.00
$0.00
Use detailed
$0.00
guidance from
$0.00
email blasts,
mortgagee letters,
$0.00
etc. formula
to determine
The
in cell
B33 is for New
$0.00
this figure. projects. For
Construction
Use detailed
$0.00
Substantial
Rehabilitation, Blended
guidance
from
Survey
may
be in
$0.00
Rate
and
Section
241(a) projects
email
blasts,
Borrower's
Other$0.00
To be
consistent with
modify
the
formula
B10.
mortgagee
letters,into .005*cell
Fees or included
the Handbook, this
etc.
to determine
this line
item. If it$0.00
is
line item is to be
this
figure.
included
here indicate
that in lender
narrative.

removed.

form HUD-92264a-ORCF (06/2014)

Maximum Insurable
Loan Calculation, by Program
Section 232

U.S. Department of Housing
and Urban Development
Survey may be in
Office of Residential
Borrower's Other
Care Facilities
Fees or included in

Legal
Organizational
Borrower's Cost Certification Audit Fee
Total Legal, Organizational, Audit
Major Movable Equipment
Marketing
Contingency
Relocation
Initial Deposit to Reserve for Replacement
Other (Describe)
Total Estimated Development Cost
Warranted Price of Land
Offsite Costs (Rehab only)
Total Estimated Replacement Cost

Previous versions obsolete

OMB Approval No. 2502-0605

this line item. If it is
included here indicate
that in lender
narrative.
Details should be$0.00
provided in the $0.00
lender narrative.

To be consistent
(exp.with
06/30/2017)
the Handbook, this
line item is to be
removed.

$0.00
$0.00
$0.00
$0.00
Rehab only
$0.00
Rehab only--a
budget
should be$0.00
Rehab only
provided indicating
$0.00
Repairs
SR or
budgetedinnumber
$0.00
BRrelocations
should be and
of
$0.00
included
here.
detailed cost
"As
is"
Value
for
estimates.
$0.00
Rehab projects
$0.00
$0.00

form HUD-92264a-ORCF (06/2014)

Maximum Insurable
Loan Calculation, by Program
Section 232

U.S. Department of Housing
and Urban Development
Office of Residential
Care Facilities

OMB Approval No. 2502-0605
(exp. 06/30/2017)

onsistent with
ndbook, this
m is to be
d.

Previous versions obsolete

form HUD-92264a-ORCF (06/2014)

Maximum Insurable
Loan Calculation, by Program
onsistent with
ndbook, this Section 232

U.S. Department of Housing
and Urban Development
Office of Residential
Care Facilities

OMB Approval No. 2502-0605
(exp. 06/30/2017)

m is to be
d.

Previous versions obsolete

form HUD-92264a-ORCF (06/2014)

Maximum Insurable
Loan Calculation
Section 232

U.S. Department of Housing
and Urban Development
Office of Residential
Care Facilities

OMB Approval No. 2502-0605
(exp. 06/30/2017)

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

Project Name:
Project Number:
Program Type:
SOURCES

0
0
0
HUD Insured Loan
Cash/Letter of Credit
Existing Reserve for Replacement Deposit
Grants/Other Loans (Describe)
Other (Describe)
TOTAL

Not$0.00
$0.00
applicable
This should either be
for $0.00
new
zero or a positive
constructio
number.
n $0.00

$0.00
$0.00

USES
HUD ELIGIBLE COSTS
Existing Indebtedness
Repairs
Initial Deposit to the Reserve for Replacement
Land Purchase
Land Improvements
Structures
General Requirements
Builder’s Overhead
Builder’s Profit
Architect Fees (Design)
Architect Fees (Supervisory)
Bond Premium
Interest
Taxes
Insurance
Appraisal (incl. update)
Market Study
Phase I ESA / HUD 4128
A&E / Cost Reviews
Financing/Placement Fee/Lender Legal
Borrower Legal
Title and Recording
Borrower's Cost Certification Audit Fee
Major Movable Equipment
Marketing
Pre-Opening Management Fees
HUD Inspection Fee
HUD Initial MIP
HUD Application Fee
Other Fees
Other (Describe)
Other (Describe)
Other (Describe)
Other (Describe)
TOTAL HUD ELIGIBLE COSTS

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
during
$0.00
constructio
during
n
period
$0.00:
construction
during
period
$0.00
construction
period
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

NON-ELIGIBLE COSTS
Initial Operating Deficit Escrow
Working Capital Escrow
Special Escrow - Minor Moveable Equipment
Special Escrow - Demolition
Special Escrow - Off-site Construction
Special Escrow - Short-Term Debt Service Reserve
Non Profit Developer's Fee/Consultant
Other (Describe)
Other (Describe)
TOTAL ADDITIONAL COSTS

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

TOTAL COSTS

$0.00

Replacement Cost minus HUD Eligible Costs

$0.00 ok

Previous versions obsolete

form HUD-92264a-ORCF (06/2014)

Maximum Insurable
Loan Calculation
Section 232

U.S. Department of Housing
and Urban Development
Office of Residential
Care Facilities

OMB Approval No. 2502-0605
(exp. 06/30/2017)

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:
Project Number:
Program Type:

0
0
0

A. Requested Loan Amount

$0

B. Original Principal Amount

$0

C. Amount Based on Replacement Cost
a. Replacement Cost in Fee Simple
b.(1) Optional Purchase Price from 92070M
(2) Grant/Loan funds attributable to R.C. items
(3) Excess Unusual Land Improvement
(4) Total lines (1) to (3)
c. Unpaid Balance of Special Assessment
d. Total line b plus line c
e. Line a minus line d
D. Amount Based on Required Loan to Value
a. Value in Fee Simple
b. Optional Purchase Price from 92070M
c. Unpaid Balance of Special Assessment
d. Less: 90% of As-is Value (for 241(a) only)
e. Total line b plus line c (lines b through d for 241(a))
f. Line a minus line e
E. Amount Based on Required Debt Service Coverage
a. Mortgage Interest Rate
b. Mortgage Insurance Premium Rate
c. Initial Curtail Rate
d. Sum of Above Rates
e. Net Operating Income
f. Annual Ground Rent + Annual Special Assessment
g. Line e minus line f
h. Line g divided by line d
i. Annual Tax Abatement Savings
j. Line h plus line i

$0
When land is $0
Use
the OHP
Loan
leased,
enter
the$0
Use
the OHP
Loan
to H08023:
Value
Limit
for the
optional
purchase
$0
to
Value
Limit
for
the
Only deduct
items
program
and
project
price specified in
program
and project
from
non-govt.
$0
type
the 92070M.
type
sources here. Use
Criteria
to deduct
241(a):
Use L90%
govt. sources.

$0
$0

When land is
leased, enter the
optional purchase
price specified in
the 92070M.

x

241(a): if building an
addition, only use
replacement cost of
thexaddition. This90%
figure should be
recalculated as
needed to include
costs based on the
mortgage amount.

x

241(a):
x Use AsProposed Value.

Use Lender's
Underwritten NOI

$0

0%
0%

$0

$0
$0
$0
$0

$0
$0
$0
$0
$0
$0

Loan term (years)
$0
$0

90%

0.00%
0.00%
#NUM!

0
÷
+

1.45
$0

223(d): insert NOI
less existing debt
÷
0.00
service

Use 1.11 for 223(d)

#NUM!
$0
$0
$0
#NUM!
$0
#NUM!

Fixed Broken Fo

Debt service
F. Amount Based on Estimated Cost of Rehabilitation Plus
constant for the
a. Existing Mortgage Indebtedness (Property Owned) or Purchase Price of Property (to be Acquired) abatement period
$0 x
90 %
b. "As Is" Value of Prop. Before Rehab.
$0
x
90 %
c. Lesser of a. or b.
d. Total Estimated Development Cost
e. Estimated Cost of Off-Site Construction
f. Sum of lines d & e
g. Grant/Loan funds attributable to Replacement Cost items
h. Line f minus line g
i. Line h plus line c

Changed the for
in G38 to
=IFERROR(B38
). That way if the
no tax abatemen
savings the form
won’t return a div
by 0 error, and th
formula in G39 w
able to correctly
calculate the crit
without an error.

$0
$0
$0
$0
$0
$0
$0
$0
$0

100%Non-Profit
95%
if refinance, 85% if
purchase

Previous versions obsolete

form HUD-92264a-ORCF (06/2014)

Maximum Insurable
Loan Calculation
Section 232

U.S. Department of Housing
and Urban Development
Office of Residential
Care Facilities

G. Amount Based on Borrower's Total Cost of Acquisition Section 223(f)
a. HUD Eligible Costs
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
d. Line c
x
H. Amount Based on the Cost to Refinance
a. HUD Eligible Costs
b. Enter the Sum of any Grant/Loan and Reserves for
Replacement and Major Movable Equipment on Deposit
c. Line a minus line b

OMB Approval No. 2502-0605
(exp. 06/30/2017)

$0

$0

90% 85
Non-Profit
%

$0

$0

$0

I. Amount Based on Total Indebtedness
a. As-Proposed Value
b. Loan-to-Value Percentage
c. Line a times line b
d. Total of All Outstanding Indebtedness Relating to Property
e. Line c minus line d

$0
90%
$0
$0
$0

J. Amount based on 100% of the Operating Loss

$0

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

$0

L. Amount Based on Deduction of Grant(s), Loan(s), LIHTCs and Gift(s) for mortgageable items
a. 100% Project (Replacement) Cost
If grants or loans
are used for nonb. (1) Grants/Loans/Gifts
mortgageable items
(2) Tax Credits
details should be
(3) Optional Purchase Price from 92070M
provided in the
lender narrative.
(4) Excess Unusual Land Improvement Cost
When land is
(5) Unpaid Balance of Special Assessment
leased, enter the
optional purchase
(6) Sum of Lines (1) through (5)
price specified in
c. Line a. minus line b. (6)
the 92070M.

$0
$0
$0
$0
$0
$0
$0

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

$0
0

Maximum Insurable Loan (Lowest of Foregoing Criteria)
Notes:
Estimated Liquidated Damages--Construction Contract
Incentive Percentage--Construction Contract (if applicable)
Estimated Soft Costs--Construction Period

0
0
#DIV/0!

Lender's Underwriter Signature

Date:

Office of Healthcare Programs Signature

Date:

Previous versions obsolete

Round down to the
nearest $100.

form HUD-92264a-ORCF (06/2014)

Use detailed
guidance from
blasts, mortgag
letters, etc. to
determine this
figure.