(without MIP) Mortgage Underwritten amount per $ % $ market value: Cap rate: bed/unit*: *Use per bed for SNF, or facilities with multiple care types (e.g., SNF/ALF). Use per unit for ALF only. Mortgage Criteria: Sensitivity Analysis: Criterion A: Requested loan amount: $ A 1.0 debt service coverage is still realized if: Criterion C: Amount based on Average rental drops $ per month. replacement cost: $ Criterion D: Amount based Occupancy rate decreases %. on loan-to-value: $ Operating expenses increase % Criterion E: Amount based on debt per year. service coverage: $ Annual net operating income (NOI) Criterion F: Amount based on decreases $ or %. estimated cost of rehabilitation plus: $ Criterion L: Amount based on deduction of grant(s), loan(s), LIHTCs, and gift(s) for mortgageable items: $ As rehabilitated: Gross income: $ UW occupancy rate: % Effective gross income: $ Expenses & repl. res.: $ Expense ratio: % Net operating income: $ 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. Absorption rate Operating deficit: $ (# beds per month): Number of months to cover shortfall: Break-even occupancy: % $ Borrower’s working capital: Special escrows (describe below): $ Minor movables: $ <<describe special escrows here>> Major movable Major movable equipment budget: $ amount per bed: $ $ Construction contract: Offsites $ Demolition $ Total construction costs: $ As reported on HUD-2328, Line 53 plus Offisites and Demolition
(without MIP) Underwritten market value: $ Cap rate: % Mortgage amount per bed/unit*: $ *Use per bed for SNF, or facilities with multiple care types (e.g., SNF/ALF). Use per unit for ALF only. Mortgage Criteria: Sensitivity Analysis: Criterion A: Requested loan amount: $ 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 %. Criterion C: Amount based on replacement cost: $ Criterion D: Amount based on loan-to-value: $ Criterion E: Amount based on debt service coverage: $ Criterion F: Amount based on estimated cost of rehabilitation plus: $ Criterion L: Amount based on deduction of grant(s), loan(s), LIHTCs, and gift(s) for mortgageable items: $ As rehabilitated: Gross income: $ UW occupancy rate: % Effective gross income: $ Expenses & repl. res.: $ Expense ratio: % Net operating income: $ 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. Operating deficit: $ Absorption rate (# beds per month): Number of months to cover shortfall: Break-even occupancy: % Borrower’s working capital: $ Special escrows (describe below): $ Minor movables: $ <<describe special escrows here>> Major movable equipment budget: $ Major movable amount per bed: $ Construction contract: $ Offsites $ Demolition $ Total construction costs: As reported on HUD-2328, Line 53 plus Offisites and Demolition $
9006_LN-SR-SINGLE-4C.DOCX