Commercial Underwriting

    Full pro forma for multifamily, retail, office, and industrial deals.

    NOI · Cap Rate · DSCR · Cash-on-Cash · IRR · Exit Analysis · 5/10/15-Year Projection

    THE PROPERTY

    $

    INCOME

    $
    $
    %
    $

    OPERATING EXPENSES

    $
    $
    %
    %
    %
    $
    $
    $
    $
    %

    FINANCING

    %
    $
    %
    %
    $

    Live Results

    NOI Snapshot

    Gross Scheduled Income$171,600
    (-) Vacancy & Credit Loss$12,012
    (-) Operating Expenses$77,038
    Net Operating Income$82,550
    (-) Annual Debt Service$95,415
    Annual Cash Flow-$12,865

    Investment Returns

    5.50%

    Cap Rate

    -3.06%

    Cash-on-Cash

    0.87

    DSCR

    7.34%

    Debt Yield

    100.50%

    Break-Even Occ.

    44.89%

    Expense Ratio

    $125

    Price / Sq Ft

    $187,500

    Price / Unit

    Exit Analysis (5-Year Hold)

    Exit Value (reversion)$1,455,113
    Exit Equity$353,194
    Total Profit-$101,543
    Equity Multiple0.76x
    IRR-5.10%

    This deal is cash-flow negative. The NOI doesn't cover debt service at these terms. Renegotiate price or improve income.

    Numbers work?

    Rob sources on and off-market commercial deals in Central Texas.

    $82,550

    NOI

    -$12,865

    Cash Flow

    0.87

    DSCR