91128-ORCF Initial Operating Deficit Escrow Calculation

Comprehensive Listing of Transactional Documents for Mortgagors, Mortgagees and Contractors

91128_IODcalc-4.xlsx

Transactional Documents for Mortgagees and Contractors

OMB: 2502-0605

Document [xlsx]
Download: xlsx | pdf

Overview

Inputs
Details & Draw Requests
Output - Summary Exhibit


Sheet 1: Inputs

Initial Operating Deficit Escrow Calculation
Section 232
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 1.5 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:
Date Prepared:
Lender Name:











Income & Occupancy Assumptions









Unit Type UW Eff. Gross Inc. per year For Assisted Living, you will typically enter the number of units here, instead of beds. Total # Beds You are asked to enter the underwritten occupancy bedcause it is needed for the computation of the Effective Gross Income per Occupied Unit. The percentage will not be applied to the incomes, as vacacy is already implicit in Effective Gross Income UW Occupancy # Occupied Units EGI per Occp'd Unit Number of Preleases The absorption numbers must be estimated in a way that accounts for move-outs in the net gain per month. Net Monthly Absorption


e.g. Assisted Living


0.00 #DIV/0!




e.g. Memory Care


0.00 #DIV/0!




e.g. Skilled Nursing or Sub-Acute


0.00 #DIV/0!




e.g. Independent Living


0.00 #DIV/0!




Other Income



#DIV/0!




Totals This total should exactly equal the Effective Gross Income concluded in the lender's underwriting. Do not enter potential gross income. (Potential Gross Income minus Vacancy = EGI) $0 0 #DIV/0! 0.00 #DIV/0! 0.00 0.00













Expense Assumptions










Total UW Total UW Per Res POU % of EGI
Enter the base amount that an expense cannot fall below as a percentage of the total expense. If there is no floor, enter 0%. If the expense amount is constant regardless of occupancy (as with taxes), enter 100%. The percentages shown in this template represent the Lean expectations for the example expense categories entered. Giving justification when departing from these expectations may serve to expitite the review processs. Expense Floor
The categories below in blue are examples. The names should be changed to correspond to the categories presented in the Lender Narrative. Categories in black are either always present or have special rules about how and when they are applied. These should not be changed. Category Exp. per year Exp. per Month Day per year UW
Percentage Yearly Floor Monthly Floor
e.g. General & Administrative
$0 #DIV/0! #DIV/0! #DIV/0!
100.00% $0 $0
e.g. Payroll Taxes and Benefits
$0 #DIV/0! #DIV/0! #DIV/0!
80.00% $0 $0
e.g. Resident Care
$0 #DIV/0! #DIV/0! #DIV/0!
30.00% $0 $0
e.g. Food Services
$0 #DIV/0! #DIV/0! #DIV/0!
30.00% $0 $0
e.g. Activities
$0 #DIV/0! #DIV/0! #DIV/0!
30.00% $0 $0
e.g. Housekeeping & Laundry
$0 #DIV/0! #DIV/0! #DIV/0!
10.00% $0 $0
e.g. Maintenance
$0 #DIV/0! #DIV/0! #DIV/0!
30.00% $0 $0
e.g. Utilities
$0 #DIV/0! #DIV/0! #DIV/0!
50.00% $0 $0
e.g. Bad Debt
$0 #DIV/0! #DIV/0! #DIV/0!
0.00% $0 $0
If you have an expense that is charged only on occupied units, such as a provider tax, the lender may correct the formulas that calcuate the monthly charges in the tab called "Details & Draw Requests" to give the correct answer.

$0 #DIV/0! #DIV/0! #DIV/0!
0.00% $0 $0
This expense will not be charged in Interval 1. The expense for this period is covered in the mortgage. Ground Rent
$0 #DIV/0! #DIV/0! #DIV/0!
100.00% $0 $0
This expense will automatically be applied at 200% of normal until break even occupancy is reached. Marketing and Promotion
$0 #DIV/0! #DIV/0! #DIV/0!
100.00% $0 $0
This expense will automatically be distributed as a lump sum payment in month 3, then be impounded at the normal monthly rate. Insurance (property & liability)
$0 #DIV/0! #DIV/0! #DIV/0!
100.00% $0 $0
Real Estate (Property) Taxes
$0 #DIV/0! #DIV/0! #DIV/0!
100.00% $0 $0
Management Fees
$0 #DIV/0! #DIV/0! #DIV/0!
Enter the expense floor during the lease-up period. The amount will be spelled out in the management agreement. During the lease-up period, this expense is not likely to be calculated as a percentage of EGI, as it will be later. Management will need compensation during the lease-up period, eventhough the project is still minimally occupied. 80.00% $0 $0
Enter the amount determined by the lender that will actually be charged, not the "market" amount estimated by the appraiser. Replacement Reserves
$0 #DIV/0! #DIV/0! #DIV/0!
100.00% $0 $0
TOTAL This total should exactly match the expense total concluded by the lender. This means using HUD reserve amounts instead of market amounts, when different. $0 $0 #DIV/0! #DIV/0! #DIV/0!















Debt Service Assumptions









Interest Only $- per month
Debt Service Calculator





Principal Plus Interest #NUM! per month
Mortgage Amount





MIP An annual MIP payment is made at start of amortization. $- per month
Term in Months









Annual Interest Rate









MIP Percentage
NC/SR Healthcare Facilities without LIHTC = 0.77% NC/SR Assisted Living Facilities with LIHTC = 0.45% 232/223f Healthcare Facilities without LIHTC = 0.65% 232/223f Healthcare Facilities with LIHTC = 0.45% 0.77%




Sheet 2: Details & Draw Requests

0 Period One

Interval 1 spans the period of time between certificate of occupancy and the end of the construction period/cost certification period. (Note that the construction period is defined as construction time plus two months for cost certification purposes). When calculating expenses for this Interval, there should be no debt service included as an expense. The mortgage interest for this interval is included in the mortgage in Section G Line 53 "Construction Interest". Ground rent is also not to be included in Interval 1. Replacement reserves are also not included in Interval 1 .
Period Two

Interval 2 begins at the end of the construction period/cost certification process (construction time plus two months) and ends at the beginning of amortization. Debt service should include payment for interest and MIP, but not amortization, as the beginning of amortization signals the beginning of Interval 3. Ground rent must be included if the property is a leasehold. Replacement reserves are not included in Interval 2.
Period Three Interval 3 begins at the beginning of amortization. Amortized debt service is mandatory in this Interval, and should include payment to principle and interest and MIP. Ground rent, if applicable, is also mandatory in interval 3. Replacement reserves also are mandatory in Interval 3.





























































Instructions: Use this tab to make draw request from IOD escrow. Only modify shaded blue cells. Month 1 Forecast Month 1 Actual Month 2 Forecast Month 2 Actual Month 3 Forecast Month 3 Actual Month 4 Forecast Month 4 Actual Month 5 Forecast Month 5 Actual Month 6 Forecasted Month 6 Actual Month 7 Forecasted Month 7 Actual Month 8 Forecast Month 8 Actual Month 9 Forecast Month 9 Actual Month 10 Forecast Month 10 Actual Month 11 Forecast Month 11 Actual Month 12 Forecast Month 12 Actual Month 13 Forecast Month 13 Actual Month 14 Forecast Month 14 Actual Month 15 Forecast Month 15 Actual Month 16 Forecast Month 16 Actual Month 17 Forecast Month 17 Actual Month 18 Forecast Month 18 Actual Month 19 Forecast Month 19 Actual Month 20 Forecast Month 20 Actual Month 21 Forecast Month 21 Actual Month 22 Forecast Month 22 Actual Month 23 Forecast Month 23 Actual Month 24 Forecast Month 24 Actual Month 25 Forecast Month 25 Actual Month 26 Forecast Month 26 Actual Month 27 Forecast Month 27 Actual Month 28 Forecast Month 28 Actual Month 29 Forecast Month 29 Actual Month 30 Forecast Month 30 Actual Month 31 Forecast Month 31 Actual Month 32 Forecast Month 32 Actual Month 33 Forecast Month 33 Actual Month 34 Forecast Month 34 Actual Month 35 Forecast Month 35 Actual Month 36 Forecast
e.g. Assisted Living 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
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
e.g. Memory Care 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
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
e.g. Skilled Nursing or Sub-Acute 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
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
e.g. Independent Living 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
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
Total Occupied Units 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 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 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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Resident Days 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
EGI 0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
e.g. General & Administrative #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
e.g. Payroll Taxes and Benefits #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
e.g. Resident Care #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
e.g. Food Services #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
e.g. Activities #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
e.g. Housekeeping & Laundry #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
e.g. Maintenance #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
e.g. Utilities #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
e.g. Bad Debt #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!

#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Ground Rent 0 0 0 0 #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
This expense will automatically be applied at 200% of normal until break even occupancy is reached. Marketing and Promotion #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
This expense will automatically be distributed as a lump sum payment in month 3, then be impounded at the normal monthly rate. Insurance (property & liability) 0
0
0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Real Estate (Property) Taxes 0
0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Management Fees #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Replacement Reserves 0
0
0
0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Total Expenses #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0!
NOI #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0!
P+I 0
0
0
0
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
MIP 0
0
0
Includes a full first year's payment of MIP upon closing. 0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Income/Loss per Period #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0!
Cumulative Income/Loss #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0!









#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Expense Ratio NA NA NA NA #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
% of UW Expense #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Occupancy #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!








































































Draw Amount Requested






































































Dollar Difference from Scheduled Draws
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Amount Approved (entered by HUD)






































































Escrow Balance
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!








































































IOD Base Requirement






































































#DIV/0!







































































Sheet 3: Output - Summary Exhibit

0 Prepared: 12/30/1899






Occupancy Assumptions




Unit Type Total # Beds UW Occupancy Number of Preleases Avg. Monthly Absorption
e.g. Assisted Living 0 0.00% 0.00 0.00
e.g. Memory Care 0 0.00% 0.00 0.00
e.g. Skilled Nursing or Sub-Acute 0 0.00% 0.00 0.00
e.g. Independent Living 0 0.00% 0.00 0.00
Totals 0 #DIV/0! 0.00 0.00










Rounded Operating Deficit Total: #DIV/0!







Occupied Occupied Income Exp. & Mort. Income/Loss
Period Units Percent per Period per Period per Period
Month 1 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 2 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 3 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 4 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 5 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 6 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 7 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 8 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 9 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 10 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 11 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 12 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 13 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 14 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 15 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 16 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 17 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 18 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 19 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 20 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 21 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 22 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 23 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 24 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 25 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 26 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 27 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 28 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 29 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 30 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 31 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 32 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 33 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 34 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 35 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
Month 36 0.00 #DIV/0! $0 #DIV/0! #DIV/0!
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy